The following functions/procedures are in the package P_PROJECT_MANAGER of your HPD Schema. These functions and procedures can be used to view and edit HPD project information.
Name | Type | Description |
|---|---|---|
ADDPROJECT | Function | Add a Direct Project. |
ADDISOLATEDPROJECT | Function | Add an Isolated Project. |
SET_PROJECT_ATTRIBUTE | Procedure | Add or change a project attribute. |
CHANGEPROJECTTYPE | Procedure | Alter an existing project type. |
CHANGEPROJECTSTATUS | Procedure | Update current project status. |
CHANGEPROJECTPRIORITY | Procedure | Update current project priority. |
COMPLETEPROJECT | Procedure | Set the status of a project to complete. |
UPDATEPROJECT | Procedure | Alter the metadata values of a existing project. |
DELETEPROJECT | Procedure | Remove a project from the database. |
UNDELETEPROJECT | Procedure | Undeletes a deleted project. |
ADDCHILDPROJECT | Procedure | Relate a project or source entry to a project. |
REMOVECHILDPROJECT | Procedure | Remove the relation between projects. |
REMOVECHILDREGISTRY | Procedure | Remove a source from a project. |
AREPROJECTFEATURESSUBMITTED | Function | Determine if an isolated project is ready for validation. |
AREPROJECTFEATURESVERIFIED | Function | Determine if an isolated project is ready for completion. |
GETCURRENTPROJECTSTATUSCODE | Function | Returns a project status code. |
LOCKPROJECT | Function | Lock the specified project. |