Search Results po_wf_itemkey_s




Overview
Explore in AI Chat

Overview

PO_CONC_MODS_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified as a PVT (private) API. Its name reflects its role in the Purchasing module: it orchestrates concurrent modification processing for documents and notifications. The package serves as an internal driver that raises and manages workflow notifications associated with concurrent modifications to purchasing documents, bridging the Oracle Purchasing application tables and the Oracle Workflow engine.

The package is classified as private, meaning it is not intended for direct invocation by external application code or customizations. It supports the notification and approval infrastructure that surrounds purchasing documents, invoking workflow processes through the standard EBS workflow APIs (WF_CORE and WF_ENGINE). Because it is a private package body, it is referenced by no other database objects, confirming its position as a lower-level utility consumed only within the Purchasing concurrent processing framework.

Key Procedures and Functions

The ETRM metadata documents a single procedure or function in PO_CONC_MODS_PVT:

  • START_CONCMODS_NOTIF_WORKFLOW — This procedure initiates the workflow notification process for concurrent modifications. Its purpose is to launch the notification workflow that informs relevant parties (such as buyers, approvers, or document owners) when concurrent modification activity occurs against purchasing documents. It operates through the Oracle Workflow engine to generate and route the appropriate notification items.

No parameter lists are documented in the ETRM metadata, and no additional procedures or functions are recorded for this package body. Customizations should not assume the existence of undocumented entry points, as the package is private and subject to change between releases.

Tables Accessed

The package body references the following tables and views through APPS synonyms:

  • PO_HEADERS_ALL — The base purchasing document headers table. The package reads document header information to identify which purchasing documents are subject to concurrent modification notifications.
  • PO_DRAFTS — Stores draft changes to purchasing documents. Referenced to determine in-progress modifications that require notification workflow processing.
  • PO_DOCUMENT_TYPES_ALL_B — Defines purchasing document types. Used to resolve document type context for the notification workflow.
  • PO_WF_ITEMKEY_S — A sequence used to generate unique workflow item keys for notification items raised by START_CONCMODS_NOTIF_WORKFLOW.

The package also depends on PO_WF_ITEMKEY_S, PO_LOG, PO_REQAPPROVAL_INIT1, WF_CORE, and WF_ENGINE, indicating that it logs activity and integrates directly with the Workflow runtime to start notification processes.

Usage Notes

PO_CONC_MODS_PVT is invoked indirectly through Oracle Purchasing concurrent programs and internal document modification flows, not through Oracle Forms directly. When concurrent modification processing runs against purchasing documents, this package's START_CONCMODS_NOTIF_WORKFLOW procedure is called to initiate the associated workflow notification.

Because the package is classified as PVT and is referenced by no other database objects, it is not a supported extension point. Customizations should never call PO_CONC_MODS_PVT directly; instead, they should use supported public APIs or hook into the Workflow notification events. The package is present and valid in both EBS 12.1.1 and 12.2.2, and its dependency on WF_ENGINE and WF_CORE confirms that any workflow configuration changes affecting the notification infrastructure can impact its behavior.