Search Results po_req_distributions




Overview
Explore in AI Chat

Overview

PO_REQ_DIST_SV1 is a server-side PL/SQL package body in the APPS schema that provides utility services for the distribution records of purchasing requisition lines in Oracle E-Business Suite. In the Oracle Purchasing data model, a requisition line can be charged to one or more account distributions stored in PO_REQ_DISTRIBUTIONS and its multi-organization counterpart PO_REQ_DISTRIBUTIONS_ALL. The package encapsulates the logic required to inspect those distributions and to determine the single accounting flexfield combination associated with a requisition line when exactly one distribution exists. The header comment (POXRQD2B.pls, revision 115.6, dated 2003/12/19) indicates a long-lived, stable utility layer that has been carried forward largely unchanged into the 12.1.1 and 12.2.2 releases. The package is classified as OTHER in the ETRM metadata, meaning it is an internal supporting service rather than a formally published public API.

Key Procedures and Functions

The ETRM metadata documents three program units, listed as NAMES and NAME, corresponding to the package's internal naming utilities. In practice the body exposes the following principal entry points:

  • get_dist_num_account — a procedure that accepts a requisition line identifier and returns both the count of distributions attached to that line and, when the count equals one, the associated code combination identifier. When the distribution count differs from one, the code combination is returned as null, signalling that the account cannot be unambiguously derived.
  • get_dist_account — a function that returns the code combination identifier for a requisition line. It performs the same single-distribution determination against the _ALL table, reflecting the correction recorded under Bug 1702850 to read the multi-organization table rather than the striped table.
  • NAME / NAMES — supporting naming utilities referenced in the documented procedure list; these are internal helpers used by the account-derivation logic.

No parameter lists are reproduced here beyond those visible in the documented source excerpt; readers should treat the signatures as defined in the shipped package specification.

Tables Accessed

  • PO_REQ_DISTRIBUTIONS — the base requisition distribution table, queried to count distributions for a given requisition line and to retrieve the code combination identifier when a single distribution exists.
  • PO_REQ_DISTRIBUTIONS_ALL — the multi-organization table used by get_dist_account, consistent with the documented bug fix that directs queries to the _ALL table instead of the striped table.

Both tables are accessed through APPS synonyms. The package performs read-only queries; no inserts, updates, or deletes are documented.

Usage Notes

PO_REQ_DIST_SV1 is an internal server-side utility rather than an end-user-facing API. It is referenced by three other packages, which call it to resolve requisition-line accounting before downstream processing such as requisition import, autocreate, or approval workflows. Typical invocation occurs from within other PL/SQL packages or from form-level logic that needs to validate or default the accounting distribution on a requisition line. The package handles the NO_DATA_FOUND condition by returning a distribution count of zero, and routes unexpected errors through PO_MESSAGE_S.SQL_ERROR before re-raising. Because the code path assumes at most one meaningful distribution for account derivation, callers should not rely on it for multi-distribution lines; in those cases the returned code combination will be null by design.