Search Results po_link_req_dist_pvt




Overview
Explore in AI Chat

Overview

PO_LINK_REQ_DIST_PVT is a private (PVT) PL/SQL package in the APPS schema that supports the Oracle Purchasing feature known as "linked requisition distributions." Its principal business purpose is to create the associations between purchase order distributions and the requisition distributions from which they originate, and to preserve the accounting context (GL date and GL period) of those requisitions when purchasing documents are generated. The public-facing implementation of this functionality resides in PO_LINK_REQ_DIST_PUB; this package supplies the internal, unexposed logic that the public layer invokes. Because the package is classified as PVT, it is not intended for direct customer invocation and does not constitute a supported extension point.

Key Procedures and Functions

Four documented program units are exposed within the package:

  • CREATE_LINK_REQ_DIST_GT — Populates a global temporary structure (backed by PO_DISTRIBUTIONS_GT) that holds the set of distribution rows to be processed for requisition-distribution linkage. This serves as the staging step that later validation and insertion logic consumes in a set-based fashion.
  • CREATE_AND_VAL_LINKED_REQ_DIST — Performs the substantive work: it creates the linked requisition distribution records and validates them against purchasing and requisitioning rules. This is the core routine that establishes and confirms the linkage between PO distributions and their source requisition distributions.
  • GET_GL_DATE — Returns the accounting date (GL date) associated with a linked requisition distribution, used to align the purchasing transaction's accounting date with that of the originating requisition.
  • GET_GL_PERIOD_NAME — Returns the GL period name corresponding to the requisition distribution's accounting context, ensuring period consistency across the requisition-to-order flow.

The package further references the user-defined types PO_LINK_REQ_DIST_FU_TAB, PO_MULTI_MOD_VAL_RESULTS_TYPE, and PO_MULTI_MOD_VAL_RESULTS_S, which carry multi-row validation results and serve as the declarations used by the validation routines.

Tables Accessed

The package reads from and writes to a broad set of Purchasing base and draft tables. The PO_DISTRIBUTIONS_ALL, PO_HEADERS_ALL, PO_LINES_ALL, and PO_LINE_LOCATIONS_ALL families form the transactional core, with their corresponding _DRAFT_ALL variants allowing the same linkage logic to operate against draft or document-builder records before they are finalized. PO_DISTRIBUTIONS_S and PO_DISTRIBUTIONS_GT provide sequence and global temporary working storage during mass processing.

On the requisitioning side, the package references PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL to identify the source requisition lines and distributions being linked. PO_MULTI_MOD_VAL_RESULTS_S stores multi-row validation outcomes, PO_SYSTEM_PARAMETERS supplies operating configuration and defaults, and PO_MULTI_MOD_VAL_RESULTS_TYPE feeds the validation-result data structures. Together these accesses allow the package to reconstruct the requisition-side accounting context and apply it to the purchase order side.

Usage Notes

PO_LINK_REQ_DIST_PVT is invoked indirectly, through PO_LINK_REQ_DIST_PUB, during the creation and validation of purchase order distributions that are tied to requisitions. Typical trigger scenarios include Autocreate, document generation, and the manual creation of releases or orders from requisition lines in the Purchasing and iProcurement flows. Because the ETRM metadata records zero packages referencing it, its exposure is limited to its own package body and its public wrapper, indicating a tightly encapsulated internal component. It is not a supported public API for custom development; customizations requiring requisition-to-order linkage should target the corresponding public package or supported interfaces rather than calling this private package directly.