Search Results po_distributions_s




Overview
Explore in AI Chat

Overview

PO_DISTRIBUTIONS_PKG1 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It encapsulates the core data manipulation logic for purchase order distribution records, which represent the accounting and charge allocations of a purchase order shipment or release line. Every distribution row maps a quantity or amount to a charge account, and this package is the underlying engine that creates and maintains those rows on behalf of Purchasing and Payables processing flows. The package is classified as OTHER in the Oracle ETRM registry, indicating it is an internal implementation package rather than a public, supported PL/SQL API. Its status is VALID, and no other database object in the schema references it, confirming that it operates as a private worker unit invoked from other components of the Purchasing module. Searches for "po_distributions_s" typically surface this object because the package depends on the PO_DISTRIBUTIONS_S synonym within the same dependency chain.

Key Procedures and Functions

The package body exposes two documented procedures:

  • INSERT_ROW — Inserts a new purchase order distribution record. It resolves the appropriate distribution identifier, validates the supplied column values against the distribution structure, and writes the resulting row through the PO_DISTRIBUTIONS_ALL table via its APPS synonyms. This procedure is the entry point used when a new shipment, release, or requisition-to-PO conversion requires an additional charge allocation.
  • UPDATE_ROW — Modifies an existing distribution row. It is used when quantities, amounts, accounting flexfield assignments, or other distribution attributes change after initial creation, such as during PO revision, corrective action, or accounting redistribution.

Both procedures are internal to the package's implementation. No parameter signatures are published through the supported API surface, and callers should treat the procedures as private implementation details.

Tables Accessed

Dependency analysis shows the package body references the following APPS synonyms and SYS objects:

  • PO_DISTRIBUTIONS_ALL — the base table storing purchase order distribution records across all operating units; the target of the INSERT_ROW and UPDATE_ROW operations.
  • PO_DISTRIBUTIONS — the installation-level view that exposes distributions for the current operating unit, referenced for reads and validation.
  • PO_DISTRIBUTIONS_S — a sequence-based synonym used to obtain the next primary key value for new distribution rows created by INSERT_ROW.
  • PO_DIST_S — an additional distribution sequence synonym supporting identifier generation, particularly when multiple distributions are created in one transaction.
  • PO_TAX_INTERFACE_PVT — the tax interface package, invoked to populate or update tax-related distribution attributes consistent with EBS tax engine requirements.
  • DUAL and STANDARD — standard SYS objects used for single-row selects and built-in PL/SQL operations.

Usage Notes

Because PO_DISTRIBUTIONS_PKG1 is not referenced by any other database object, it is not part of the public, supported API surface. It is invoked indirectly by Purchasing forms, internal concurrent programs, and workflow-driven processes that create or revise purchase order distributions. Customizations that must manipulate distributions should use the supported PO_DISTRIBUTIONS_PKG and related documented APIs rather than calling this package body directly, since the procedures are undocumented in parameter shape and may change across patch levels. Where direct invocation is unavoidable, callers should ensure the distribution sequences, the tax interface, and the operating unit context are correct so that INSERT_ROW and UPDATE_ROW produce rows consistent with the Purchasing data model.