Update the status of a current project.
Input
Parameter | Value | Description |
|---|---|---|
v_project_id | NUMBER | The primary key value of the project. |
v_new_project_status | NUMBER | The ID of the project status from the lookup table project_status. |
Example
declare v_project_id CONSTANT PROJECT.PJ_ID%TYPE := 2; v_new_status CONSTANT NUMBER:= 4; begin P_PROJECT_MANAGER.CHANGEPROJECTSTATUS(v_project_id, v_new_status); end; / |
Exceptions
• Input project ID does not exist.
• Input project status ID does not exist.
• Project status ID is already set.
• Error in CHANGEPROJECTSTATUS: (SQL code).