Update current project priority.
Input
Parameter | Type | Description |
|---|---|---|
v_project_id | NUMBER | The primary key value of the project. |
v_new_project_priority | NUMBER | The ID of the project priority from the lookup table sourceregistry_priority. |
Example
declare v_project_id CONSTANT PROJECT.PJ_ID%TYPE := 2; v_new_priority CONSTANT NUMBER:= 1; begin P_PROJECT_MANAGER.CHANGEPROJECTPRIORITY (v_project_id, v_new_priority); end; / |
Exceptions
• Input project ID does not exist.
• Input project priority ID does not exist.
• Project priority ID is already set.
• Error in CHANGEPROJECTPRIORITY: (SQL code).