Search Results po_pdoi_mainproc_pvt




Overview
Explore in AI Chat

Overview

PO_PDOI_MAINPROC_PVT is a private PL/SQL package in the APPS schema that forms part of the Purchasing Document Open Interface (PDOI) architecture in Oracle E-Business Suite. PDOI provides the supported mechanism for bulk-loading purchasing documents — including purchase orders, blanket agreements, contracts, quotations, and their associated lines, shipments, distributions, and price differentials — into the Purchasing application without manual data entry. The MAINPROC_PVT package acts as the principal processing driver within this architecture: it is responsible for reading staged rows from the PO interface tables, validating and defaulting their attributes, and orchestrating the transfer of accepted records into the base Purchasing tables.

The package is classified as a private (PVT) API, meaning it is intended for internal consumption by the PDOI framework rather than as a publicly supported interface for customer extensions. The documented metadata shows a single entry point, PROCESS, with the package itself referencing a broad set of interface and base tables. This design concentrates the core processing logic for a PDOI run in one place, allowing the surrounding public package PO_PDOI_PVT to manage submission, parameter handling, and result reporting while delegating the actual row-by-row work.

Key Procedures and Functions

The documented API surface of PO_PDOI_MAINPROC_PVT consists of one procedure:

  • PROCESS — The single documented entry point. It drives the main PDOI processing cycle: consuming staged interface records, applying validation and defaulting rules, and inserting or updating the corresponding Purchasing entities. Because it is a private procedure, its parameter list is not published as a supported interface; callers within the framework invoke it to execute the processing pass for the records selected by the calling process.

No other procedures or functions are documented for this package in the ETRM metadata. The dependency information confirms that PO_PDOI_MAINPROC_PVT does not reference any external database object of its own outside the tables listed below, and that it is referenced by two related packages: PO_PDOI_MAINPROC_PVT itself (internal recursion or self-reference in the dependency report) and PO_PDOI_PVT, which is the public-facing companion package that invokes it.

Tables Accessed

The package interacts with both the PDOI interface tables and the Purchasing base tables, reflecting its dual role as validator and loader:

Usage Notes

PO_PDOI_MAINPROC_PVT is not intended to be called directly from custom code, forms, or concurrent program registrations. It is invoked indirectly through the supported PDOI path: users or programs populate the PO interface tables (via the PO_DOCUMENT_INTERFACE or equivalent loading utilities), then submit the Purchasing Documents Open Interface concurrent program, which executes the public package PO_PDOI_PVT. That public package in turn calls PO_PDOI_MAINPROC_PVT.PROCESS to perform the core processing pass. Because it is a PVT-class API, Oracle does not guarantee its signature or behavior across releases; customizations should target the public PDOI interfaces and the interface tables rather than this package. Diagnosis of PDOI failures should begin with the interface table error columns and the PDOI concurrent program log, since PROCESS surfaces validation messages by updating those staging rows rather than returning structured error output to callers.