Search Results po_delrec_pvt




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_DELREC_PVT is an Oracle E-Business Suite private PL/SQL package owned by the APPS schema and classified as a PVT (private) API. In EBS 12.1.1 and 12.2.2, it serves the Purchasing module as an internal utility for building and maintaining the delivery record (delrec) structures that describe how ordered goods are to be received at their destination. A delivery record captures the receiving-relevant attributes of a purchase order shipment — destination organization, ship-to location, receipt routing, freight carrier and terms, unit of measure, and related reference data. The package encapsulates the logic that creates or updates these records so that the same derivation rules are applied consistently whether the action originates from a form, a concurrent process, or another programmatic caller.

Consistent with the PVT naming convention, PO_DELREC_PVT is not a supported public interface. It is invoked by other products inside the EBS code base rather than by customer extensions, and its signature may change between releases without notice.

Key Procedures and Functions

The ETRM documentation for 12.2.2 records a single documented program unit, CREATE_UPDATE_DELREC. As its name indicates, this procedure performs the create-or-update operation on a purchasing delivery record: when a suitable record does not yet exist for the given shipment, it inserts one; when one already exists, it updates the existing record to reflect current source data. It is the package's sole documented entry point and carries the core business logic that maps purchase order shipment attributes onto the freight and receiving configuration tables.

The package body also lists PO_DELREC_PVT among the objects referenced by the package, indicating an internal recursive or self-referencing call. The exact parameter list of CREATE_UPDATE_DELREC is not exposed in the available metadata and is therefore not reproduced here.

Tables Accessed

PO_DELREC_PVT reads and writes a set of core Purchasing and Inventory tables through APPS synonyms:

Usage Notes

Because PO_DELREC_PVT is a private package, it is not called directly from the Purchasing forms or from standard concurrent programs. It is reached indirectly. The ETRM dependency listing shows it referenced by seven other packages, including PO_DOCUMENT_CONTROL_PVT, PO_DOCUMENT_ACTION_PVT, PO_AME_WF_PVT, PO_PDOI_POSTPROC_PVT, PO_RELGEN_PKG, PO_SIGNATURE_PVT, and RCV_FTE_CALL_PVT. This places the package on the execution path of document control and change processing, approval management workflow integration, releases generation, signature processing, and the post-processing stage of the Purchasing Documents Open Interface (PDOI). It is exercised whenever a purchase order or release is created, changed, approved, or loaded through PDOI and the delivery record must be built or refreshed. Custom code should depend on the supported public APIs (for example, the PO document control and receiving interfaces) rather than on PO_DELREC_PVT, since internal packages are subject to change in upgrade or patching cycles.