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

ADDISOLATEDPROJECT

Add the definition of an isolated project.

Input

Parameter

Type

Description

v_created_by_in

NUMBER

The ID of the user that created the project.

v_project_name

VARCHAR2

The name of the project. This is limited to 50 characters.

v_work_order

VARCHAR2

Assigned work order value. This is limited to 100 characters.

v_start_date

DATE

A date field. Specifies the date that the project was started.

v_process_time

VARCHAR2

Expected duration to process. This is limited to 10 characters.

v_type_in

NUMBER

The ID of the project type from the lookup table project_type.

v_status_in

NUMBER

The ID of the project status from the lookup table project_status.

v_priority_in

NUMBER

The ID of the project priority from the lookup table sourceregistry_priority.

v_geom

SDO_GEOMETRY

Cover area of interest for this project.

v_external_id

VARCHAR2

The ID of an record external to HPD. This is limited to 50 characters.

v_assigned_to

NUMBER

The ID of the user who can work on the project.

v_usage_id

NUMBER

Primary key of default usage.

Output

Example

declare

  v_project_id     PROJECT.PJ_ID%TYPE;

  v_CREATED_BY     CONSTANT HPD_USER_VW.USER_ID%TYPE := 1; -- user_id

  v_PROJECT_NAME   CONSTANT PROJECT.PJ_NAME%TYPE := 'test project';

  v_WORK_ORDER     CONSTANT PROJECT.PJ_WORK_ORDER%TYPE := 'WO-1001';

  v_START_DATE     CONSTANT PROJECT.PJDATE_STARTED%TYPE := sysdate;

  v_PROCESS_TIME   CONSTANT PROJECT.PJ_PLANNED_PROCESS_TIME%TYPE := '24 days';

  v_TYPE_IN        CONSTANT PROJECT.PTE_PROJECT_TYPE_ID%TYPE := 1;

  v_STATUS_IN      CONSTANT PROJECT_certification.PROJECT_STATUS_ID%TYPE := 1;

  v_PRIORITY_IN    CONSTANT PROJECT.SPY_PRIORITY_ID%TYPE := 1;

  v_EXTERNAL_ID    CONSTANT project.external_id%type :=1;

  v_assigned_to    CONSTANT HPD_USER_VW.USER_ID%TYPE := 1;

  v_default_usage  CONSTANT usage.usage_id%type := 1;

  v_GEOM           SDO_GEOMETRY;

begin

  v_geom := SDO_GEOMETRY(2003, NULL, NULL,

      SDO_ELEM_INFO_ARRAY(1, 1003, 1),

      SDO_ORDINATE_ARRAY(

         -1.2, 50.1, -1.2, 50.2, -1.3, 50.2, -1.3, 50.1, -1.2, 50.1));

  v_project_id := P_PROJECT_MANAGER.ADDISOLATEDPROJECT(

            v_CREATED_BY,

            v_PROJECT_NAME,

            v_WORK_ORDER,

            v_START_DATE,

            v_PROCESS_TIME,

            v_TYPE_IN,

            v_STATUS_IN,

            v_PRIORITY_IN,

            v_GEOM,

            v_EXTERNAL_ID,

            v_assigned_to,

            v_default_usage);

 

  DBMS_OUTPUT.PUT_LINE('--*-- Created isolated project ID: '|| v_project_id);

end;

/

Exceptions

• Project name cannot be null.

• Input project type does not exist.

• Input project status does not exist.

• Project start date cannot be null.

• Input project priority does not exist.

• Input responsible user ID does not exist.

• Input responsible user ID does not exist.

• Input project name is already used by an existing project.

• Geometry is required of Isolated Projects.

• A user must be assigned to an Isolated Project.

• A usage must be assigned to an Isolated Project.