Search Results get_proj_status_attributes

Overview

PA_PROJECT_WF is the Oracle Projects workflow integration package body owned by APPS. Its central responsibility is to manage the Oracle Workflow processes that surround the lifecycle of a project, most notably the project approval cycle and status-change validation logic. The package acts as the glue between the Projects application tables and the Workflow engine (WF_ITEM_TYPES, notifications, and activities), exposing PL/SQL entry points that the workflow engine invokes as activity functions and that application forms invoke when a project must be routed for approval or validated against status transition rules.

The package is classified as OTHER within the ETRM documentation, meaning it is not a public, customer-facing API in the sense of the standard Projects APIs (for example the PA_PROJECT_PUB or PA_PROJECT_STRUCTURE_PUB family). It is nevertheless a supported integration point referenced by five other packages, which confirms that it is called from within the Projects workflow infrastructure rather than being an isolated utility. The header comment captured at version 120.2.12010000.3 (2008/11/24) identifies the package as pa_project_wf and shows an early history of refactoring, including replacement of Set_Global_Info calls with Set_Global_Attr to drop Application Message Generator (AMG) linkage.

Key Procedures and Functions

Eight subprograms are documented: SELECT_PROJECT_APPROVER, START_PROJECT_WF, SET_SUCCESS_STATUS, SET_FAILURE_STATUS, VERIFY_STATUS_CHANGE_RULES, WF_STATUS_FAILURE, GET_PROJ_STATUS_ATTRIBUTES, and VALIDATE_CHANGES.

• SELECT_PROJECT_APPROVER — Selects the correct project approver and returns the approver's user ID as the workflow activity result. The excerpt shows it calling the client extension PA_CLIENT_EXTN_PROJECT_WF.Select_Project_Approver and resolving the FND_USER record associated with the approver's employee.
• START_PROJECT_WF — Initiates the project workflow process, launching the approval chain associated with a project.
• SET_SUCCESS_STATUS and SET_FAILURE_STATUS — Set the outcome status of a workflow-driven operation, typically used by workflow activities to signal the result of a status transition or approval step.
• VERIFY_STATUS_CHANGE_RULES — Evaluates whether a requested project status change satisfies the configured transition rules.
• WF_STATUS_FAILURE — Handles the failure path of a workflow status operation, recording the failure and returning control to the process.
• GET_PROJ_STATUS_ATTRIBUTES — The subprogram matching the user's search term; it retrieves the attributes associated with a project's status, supplying the workflow with the status metadata it needs to render or evaluate the approval and status-change process.
• VALIDATE_CHANGES — Validates pending changes against project status rules before allowing them to be applied.

Tables Accessed

Documented accesses include FND_USER, PA_OBJ_STATUS_CHANGES_S, PA_PROJECTS_ALL, PA_PROJECT_STATUSES, and DUAL. FND_USER is queried to resolve the approver's user account from the employee record. PA_PROJECTS_ALL provides the project header data required to determine the project in scope and its current attributes. PA_PROJECT_STATUSES supplies the valid status definitions used by GET_PROJ_STATUS_ATTRIBUTES and the status-rule checks. PA_OBJ_STATUS_CHANGES_S stores the status-change records that VERIFY_STATUS_CHANGE_RULES, VALIDATE_CHANGES, and WF_STATUS_FAILURE read and update. DUAL is used for simple value derivation and cursor initialization.

Usage Notes

This package is invoked primarily by the Oracle Workflow engine as activity function definitions tied to project approval item types, and secondarily by the Projects forms and concurrent programs that initiate or validate project status changes. It is not intended for direct ad hoc invocation. Because the package participates in workflow status management, customizations following a workflow-enabled project status configuration should call it indirectly through the standard Workflow process rather than bypassing it. The dependency on PA_CLIENT_EXTN_PROJECT_WF means customer extensions to approver selection are supported through that designated client extension package.