UPDATEPROJECT

Change the metadata values on an existing project. If an input parameter is set to NULL, that value is not updated.

Parameter	Type	Description
v_project_id	NUMBER	The primary key value of the project.
v_new_created_by	NUMBER	The ID of the user that created the project. Use NULL to leave the existing value unchanged.
v_new_name	VARCHAR2	The name of the project. This is limited to 50 characters. Use NULL to leave the existing value unchanged.
v_new_workorder	VARCHAR2	New work order value. This is limited to 100 characters. Use NULL to leave the existing value unchanged.
v_new_startdate	DATE	A date field. Specifies the date that the project was started. Use NULL to leave the existing value unchanged.
v_new_time	VARCHAR2	New expected time to complete project. This is limited to 10 characters. Use NULL to leave the existing value unchanged.
v_new_project_type	NUMBER	The ID of the project type from the lookup table project_type. Use NULL to leave the existing value unchanged.
v_new_status_id	NUMBER	The ID of the project status from the lookup table project_status. Use NULL to leave the existing value unchanged.
v_new_priority_id	NUMBER	The ID of the project priority from the lookup table sourceregistry_priority. Use NULL to leave the existing value unchanged.
v_external_id	VARCHAR2	The ID of a record external to HPD. Used to link a project to an external database or workflow system. This is limited to 50 characters. Use NULL to leave the existing value unchanged.
v_assignedusers	hpdnumber$table_type	A list of IDs of users who can work on the project.

declare

v_project_ID CONSTANT PROJECT.PJ_ID%TYPE := 3;

v_new_created_by CONSTANT HPD_USER_VW.USER_ID%TYPE:= 4; -- user_id

v_NEW_NAME CONSTANT PROJECT.PJ_NAME%TYPE := 'Load Data TEST 2B';

v_NEW_WORKORDER CONSTANT PROJECT.PJ_WORK_ORDER%TYPE := 'WO-133-TEST';

v_NEW_STARTDATE CONSTANT PROJECT.PJDATE_STARTED%TYPE := SYSDATE+5;

v_NEW_TIME CONSTANT PROJECT.PJ_PLANNED_PROCESS_TIME%TYPE := NULL;

v_NEW_PROJECT_TYPE CONSTANT PROJECT.PTE_PROJECT_TYPE_ID%TYPE := NULL;

v_NEW_STATUS_ID CONSTANT PROJECT_certification.PROJECT_STATUS_ID%TYPE := NULL;

v_NEW_PRIORITY_ID CONSTANT PROJECT.SPY_PRIORITY_ID%TYPE := NULL;

v_EXTERNAL_ID CONSTANT project.external_id%type := NULL;

v_assigned_user1 CONSTANT HPD_USER_VW.USER_ID%TYPE := 5;

v_assigned_users HPDNUMBER$TABLE_TYPE := hpdnumber$table_type();

begin

v_assigned_users.extend(1);

v_assigned_users(1) := hpdnumber$row_type(v_assigned_user1);

P_PROJECT_MANAGER.UPDATEPROJECT(v_project_ID,

v_new_created_by,

v_NEW_NAME,

v_NEW_WORKORDER,

v_NEW_STARTDATE,

v_NEW_TIME,

v_NEW_PROJECT_TYPE,

v_NEW_STATUS_ID,

v_NEW_PRIORITY_ID,

v_EXTERNAL_ID,

v_assigned_users);

end;

Only the attributes being updated need to be referenced in the function call. This example shows how to change the assigned to user.

declare

in_project_id CONSTANT PROJECT.PJ_ID%TYPE := 3;

v_assigned_user1 CONSTANT HPD_USER_VW.USER_ID%TYPE := 5;

v_assigned_users CONSTANT HPDNUMBER$TABLE_TYPE :=

hpdnumber$table_type(hpdnumber$row_type(v_assigned_user1));

begin

p_project_manager.updateproject(

v_project_id => in_project_id,

v_assignedusers => v_assigned_users);

end;