CARIS HPD : HPD® Server API : Projects : P_PROJECT_MANAGER : ADDCHILDPROJECT
 

ADDCHILDPROJECT

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).