Search Results set_notification_party

Overview

APPS.PA_CONTROL_ITEMS_WF_CLIENT is a public Oracle Projects client extension package that enables organizations to customize the Oracle Workflow processes responsible for submitting and approving issues and change documents. Issues and change documents are managed in Oracle Projects through the Control Items framework, where each control item progresses through a governed lifecycle that includes submission, review, approval, and closure. This package provides the extension hooks invoked by the seeded Issue and Change Document Workflow to determine process participants and routing at each activity.

The package is classified as a client extension under the Oracle Projects API, Client Extensions, and Open Interfaces Reference (120pjapi.pdf). Its lifecycle status is active, and it is registered as a public API with compatibility level S. The package belongs to the PA product and is associated with the PA_PROJECT business entity category. Its procedures are called by the workflow engine during execution of each activity within the Issue and Change Document Workflow, allowing implementers to substitute site-specific logic for participant resolution without modifying seeded workflow definitions.

Key Procedures and Functions

The package exposes four documented procedures:

• START_WORKFLOW — Initiates the workflow process for a control item. It receives the workflow item type, process name, item key, and control item identifier, and returns message count, message data, and return status information to the caller.
• SET_CI_APPROVER — Determines and assigns the approver for a control item activity. It accepts the workflow item type and item key along with the activity identifier and function mode, and returns the process result.
• SET_NOTIFICATION_PARTY — Resolves the notification recipient for a control item based on the current control item status. This is the procedure most commonly referenced when searching for "set_notification_party," since it controls who receives workflow notifications as an issue or change document advances through its lifecycle. It accepts the workflow item type, item key, control item status, activity identifier, and function mode, and returns the process result.
• SET_SUBMITTED_BY — Establishes the submitting party for the control item workflow, ensuring the originator is correctly attributed within the approval routing.

Tables Accessed

The package reads and writes data through APPS synonyms across several Oracle EBS schemas:

• PA_CONTROL_ITEMS — the primary control item record driving workflow routing and status.
• PA_CI_TYPES_B and PA_CI_TYPES_TL — control item type definitions and their translated names.
• PA_OBJ_STATUS_CHANGES — status transition history used to determine the current workflow stage.
• PA_CI_COMMENTS — comments associated with control items.
• PA_PROJECT_PARTIES and PA_CLASS_CODES — project party assignments and classification used for participant resolution.
• FND_USER, PER_ALL_PEOPLE_F, and HZ_PARTIES — user, person, and party identity data for approver and notification resolution.
• DBMS_LOCK — used for concurrency control during workflow activity execution.

Usage Notes

This package is invoked by the Oracle Workflow engine during execution of the Issue and Change Document Workflow, not directly by end users. Implementers customize the extension by modifying the PL/SQL bodies of these procedures so that approver selection and notification routing reflect organizational business rules. Typical invocation contexts include workflow function activities configured in the seeded Issue and Change Document process definitions and, less commonly, custom code that programmatically starts control item workflows.

Because the package is documented as a public client extension, modifications should be made within a custom copy or through supported extension mechanisms rather than by altering the seeded package directly. One other package references PA_CONTROL_ITEMS_WF_CLIENT, indicating it participates in a broader workflow integration chain. The header annotation reflects version 120.4, and the package remains documented as active under ETRM 12.2.2 metadata.