Alter an existing project type.
Input
Parameter | Type | Description |
|---|---|---|
v_project_id | NUMBER | The primary key value of the project. |
v_new_project_type | NUMBER | The ID of the project type from the lookup table project_type. |
Example
declare v_project_id CONSTANT PROJECT.PJ_ID%TYPE:= 2; v_new_project_type CONSTANT NUMBER := 3; begin P_PROJECT_MANAGER.ChangeProjectType(v_project_id, v_new_project_type); end; / |
Exceptions
• Input project ID does not exist.
• Input project type does not exist.
• Project type ID is already set.