Search Results change_status_approved

Overview

PA_WORKPLAN_WORKFLOW is the Oracle Projects workflow integration package responsible for orchestrating the Oracle Workflow processes that drive the Project Workplan approval lifecycle in Oracle E-Business Suite. The package links the Project Workplan and Project/Task execution structures to the Workflow engine, enabling workplan submission, approval, rejection, cancellation, and notification routing. The header comment indicates a build dated 2005 (PAXSTWWS.pls 120.1), reflecting a long-stable interface carried forward into release 12.1.1 and 12.2.2. The package is owned by APPS and is classified as an OTHER API, meaning it is not a formally published open interface but is nonetheless called by Oracle Projects forms, concurrent programs, and other Oracle Projects packages. It is referenced by four other packages within the application.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions, several of which are Workflow-standard callbacks (itemtype, itemkey, actid, funcmode, resultout signature) invoked by the Workflow engine itself.

• START_WORKFLOW — Initiates a workplan workflow process for a given item type and process name, keyed to a structure version, responsibility, and user; returns the generated item key and standard messaging outputs.
• CANCEL_WORKFLOW — Terminates an in-flight workflow instance identified by item type and item key.
• CHECK_WORKPLAN_STATUS — A Workflow function callback that evaluates the current workplan status and returns a result to the process.
• CHANGE_STATUS_WORKING — Callback that transitions the workplan to a working (in-progress) state; this is the procedure users seek when troubleshooting workplan status changes.
• CHANGE_STATUS_REJECTED — Callback that sets the workplan to rejected status following an approver rejection.
• CHANGE_STATUS_APPROVED — Callback that sets the workplan to approved status upon successful approval.
• SELECT_ERROR_RECEIVER — Determines the notification recipient for error conditions within the workflow.
• SHOW_WORKPLAN_PUB_ERR — Formats and displays public workplan error information into a CLOB document.
• START_PROJECT_EXECUTION_WF / CANCEL_PROJECT_EXECUTION_WF — Launch and terminate the project-level execution workflow.
• START_TASK_EXECUTION_WF / CANCEL_TASK_EXECUTION_WF / RESTART_TASK_EXECUTION_WF — Manage the task-level execution workflow lifecycle, including restart after interruption.
• IS_PROJECT_CLOSED — Boolean check used to suppress workflow activity on closed projects.

Tables Accessed

The package reads and writes through APPS synonyms across the Projects and Workflow schemas. PA_PROJ_ELEM_VER_STRUCTURE, PA_PROJ_ELEM_VER_SCHEDULE, and PA_PROJ_ELEMENT_VERSIONS provide the workplan structure version, hierarchy, and scheduling data that define the object under approval. PA_PROJECTS_ALL, PA_PROJ_ELEMENTS, PA_PROJECT_STATUSES, and PA_PROJ_STRUCTURE_TYPES supply project and structure-type context, while IS_PROJECT_CLOSED relies on project status data. PA_PROJECT_PARTIES and PA_PROJ_WORKPLAN_ATTR supply party/role and workplan attribute information used for approval routing and notification. Workflow-specific state is stored in PA_WORKFLOW_ITEMKEY_S and PA_WF_PROCESSES, and PA_PAGE_CONTENTS supports the workplan UI. FND_USER, FND_FORM_FUNCTIONS, and FND_COMPILED_MENU_FUNCTIONS resolve user identities and function/menu security.

Usage Notes

Most of the change_status_* and check_workplan_status procedures are registered as Workflow function activities and are therefore invoked implicitly by the Workflow engine during workplan approval processes rather than being called directly by end users. START_WORKFLOW, CANCEL_WORKFLOW, and the project/task execution procedures are called programmatically from Oracle Projects forms and from other Oracle Projects PL/SQL packages (the four referencing packages). Because the API classification is OTHER, customizations that call this package directly should treat it as an internal, non-supported interface: signatures and behavior may change across patches. For diagnostics involving "change_status_working," inspect the corresponding Workflow process definition and item key recorded in PA_WORKFLOW_ITEMKEY_S, and review the workflow notification and error history before altering statuses manually.