Search Results show_clob_content

Overview

APPS.PA_CONTROL_ITEMS_WORKFLOW is a PL/SQL package in the Oracle E-Business Suite Projects (PA) module that orchestrates the Oracle Workflow-driven approval lifecycle for project control items. Control items represent change control records, issues, action items, and similar reviewable objects that follow a governed approval path in Oracle Projects. In releases 12.1.1 and 12.2.2, this package owns the transaction-level logic that starts, advances, rejects, cancels, and closes the workflow associated with a control item, ensuring that status transitions and notifications remain synchronized with the underlying PA_CI_ACTIONS and PA_CONTROL_ITEMS records. It is classified as an OTHER API in the ETRM repository, meaning it is an internally-oriented package rather than a supported public interface, and it sits beneath the public PA_CONTROL_API_PUB layer that external integrations typically call.

Key Procedures and Functions

The package exposes 17 documented procedures and functions that map to distinct stages of the control item workflow:

• START_WORKFLOW — Initiates the approval workflow for a control item action, establishing the workflow process instance against the item.
• CANCEL_WORKFLOW and CANCEL_NOTIF_AND_ABORT_WF — Terminate an in-flight workflow, cancelling open notifications and aborting the active process.
• CHANGE_STATUS_REJECTED, CHANGE_STATUS_WORKING, and CHANGE_STATUS_APPROVED — Apply the corresponding control item status transitions once the workflow outcome is known.
• IS_APPROVER_SAME_AS_SUBMITTER — Determines whether the designated approver matches the original submitter, supporting self-approval validation rules.
• CHECK_STATUS_CHANGE — Validates whether a proposed status change is permitted for the control item.
• APPROVAL_REQUEST_POST_NOTFY and START_NOTIFICATION_WF — Generate and post approval request notifications and launch the notification workflow.
• FORWARD_NOTIFICATION — Routes an existing notification to another recipient.
• CLOSE_NOTIFICATION — Closes an open workflow notification.
• SET_WORKFLOW_ATTRIBUTES — Populates the workflow item attributes used by downstream notification and routing logic.
• CLOSE_CI_ACTION and KEEP_OPEN — Conclude or retain a control item action, controlling whether the record is finalized or remains active.
• SHOW_CLOB_CONTENT and SHOW_TASK_DETAILS — Retrieve and display large object content and task detail information associated with the control item for review purposes.

Tables Accessed

The package reads and writes through APPS synonyms against several core Projects and Oracle Common tables. PA_CONTROL_ITEMS and PA_CI_ACTIONS are the primary transactional tables holding the control item and its workflow actions. PA_CI_COMMENTS, PA_CI_TYPES_B, and PA_CI_TYPES_TL supply commentary and control item type definitions. PA_PROJECTS_ALL, PA_PROJECT_STATUSES, PA_PROJ_ELEMENTS, and PA_PROJ_ELEMENT_VERSIONS provide the project and task context. PA_BUDGET_VERSIONS, PA_CLASS_CODES, PA_OBJECT_RELATIONSHIPS, and PA_PAGE_CONTENTS support budget, classification, relationship, and page content requirements. FND_USER and HZ_PARTIES resolve approver and party identities for routing and notification.

Usage Notes

PA_CONTROL_ITEMS_WORKFLOW is not intended for direct customer invocation. It is referenced by eight packages, most notably PA_CONTROL_API_PUB and PA_CONTROL_API_PVT, which form the supported public entry points, and by PA_CI_ACTIONS_PVT, PA_CONTROL_ITEMS_PVT, PA_CONTROL_ITEMS_UTILS, and PA_PROJECT_UTILS2. In practice it is invoked when a user submits, approves, rejects, forwards, or cancels a control item through the Oracle Projects forms or through workflow notification responses generated by the Oracle Workflow engine. Customizations should call PA_CONTROL_API_PUB rather than this package directly, since its interfaces are internal and subject to change between 12.1.1 and 12.2.2.