Relate a project or source entry to a project.
Input
Parameter | Type | Description |
|---|---|---|
v_parent_project_id | NUMBER | The primary key value of the project. |
v_child_project_id | NUMBER | The primary key value of the child project. Only one child id should be not-NULL. |
v_child_registry_id | NUMBER | The primary key value of a source entry. Only one child id should be not-NULL. |
Example
-- Add a child project declare v_parent_project_id CONSTANT PROJECT.PJ_ID%TYPE:= 10; v_child_project_id CONSTANT PROJECT.PJ_ID%TYPE:= 552; v_child_registry_id CONSTANT REGISTRY.REGISTRY_ID%TYPE := NULL; begin p_project_manager.addchildproject ( v_parent_project_id, v_child_project_id, v_child_registry_id); end; / |
– Add a child source registry
declare v_parent_project_id CONSTANT PROJECT.PJ_ID%TYPE:= 10; v_child_project_id CONSTANT PROJECT.PJ_ID%TYPE:= NULL; v_child_registry_id CONSTANT REGISTRY.REGISTRY_ID%TYPE := 30; begin p_project_manager.addchildproject ( v_parent_project_id, v_child_project_id, v_child_registry_id); end; / |
Exceptions
• Input parent project ID does not exist.
• Input child project ID does not exist.
• Input parent project is already a child of input child project.
• Input child project is already a child of input parent project.
• The input child project ID and input project ID cannot be the same value.
• No child value found.
• Error in ADDCHILDPROJECT: (SQL code).