ADDISOLATEDPROJECT

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.

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;