Search Results po_pdoi_header_grouping_pvt




Overview
Explore in AI Chat

Overview

PO_PDOI_HEADER_GROUPING_PVT is a private PL/SQL package in the APPS schema that supports the Oracle Purchasing "PDOI" (Purchasing Document Open Interface) architecture — the framework that processes purchase orders, quotations, and related documents supplied through the open interface tables PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, and their related structures. Its specific responsibility is header grouping: during PDOI import processing, interface rows belonging to a logical purchasing document must be consolidated and organized by header-level groupings before they can be validated, defaulted, and ultimately written to the base PO tables. PO_PDOI_HEADER_GROUPING_PVT provides the grouping logic that the main PDOI orchestrator, PO_PDOI_PVT, calls upon to segregate and stage batches of header and line interface records. The package is classified as a PVT (private) API, meaning it is intended for internal use by the Purchasing open interface and is not documented as a supported public extension point.

Key Procedures and Functions

The ETRM metadata documents a single program unit within this package: PROCESS. Consistent with the naming conventions of PDOI private packages, PROCESS serves as the main driver routine for the header grouping activity — it accepts the interface context established by the parent PDOI processing run, identifies the header-level groups represented in the incoming interface data, and orchestrates the association of those groups so that subsequent PDOI phases operate on coherent document sets. Because this is a private package, no public parameter lists are documented and none should be assumed. Custom code should not invoke PROCESS directly; it is an internal component of the PDOI pipeline.

Tables Accessed

The package accesses the following objects through APPS synonyms:

  • PO_HEADERS_INTERFACE / PO_LINES_INTERFACE — the open interface staging tables from which incoming header and line records are read and grouped.
  • PO_HEADERS_ALL / PO_LINES_ALL — the base Purchasing tables consulted for existing document information that influences grouping decisions.
  • PO_DRAFTS / PO_LINES_DRAFT_ALL — draft structure tables used by PDOI to hold intermediate, pre-validation document images; grouping results are reflected in draft rows.
  • DBMS_SQL — Oracle's dynamic SQL package, indicating that portions of the grouping logic build and execute statements dynamically.
  • PLITBLM — the standard Oracle Application Object Library PL/SQL table utility package, used for manipulating PL/SQL index-by tables during processing.

Usage Notes

PO_PDOI_HEADER_GROUPING_PVT is referenced by only one other package, PO_PDOI_PVT, which is the principal private controller for PDOI document ingestion. It is therefore invoked indirectly whenever the open interface processes purchasing documents — for example, through the Purchasing Documents Open Interface concurrent program, through import functionality embedded in the Purchasing forms, or through any integration that loads the PO interface tables. Direct calls from custom code are not supported. Developers troubleshooting interface loads should trace into PO_PDOI_PVT production runs, where this package will appear in the call stack; the typical failure mode is misgrouped or incomplete header data in the interface tables, which surfaces as downstream validation errors. Because DBMS_SQL is used dynamically, the package may generate recursive SQL, a consideration when diagnosing performance in high-volume interface runs.