Search Results test_get_total_dist_qty

Overview

APPS.PO_DIST_S is a Purchasing distribution utility package in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is a supporting library rather than a business API, and it exposes helper logic tied to the PO_DISTRIBUTIONS entity. The package body carries a header dated 2007, consistent with the Purchasing module code lineage carried forward across the 12.x family. Its documented classification in ETRM is OTHER, indicating it is not an officially published open interface but is available in the APPS schema for internal and extension use.

The package exists to answer two recurring distribution questions in purchasing flows: how much quantity has been distributed against a given distribution record, and whether a distribution record exists at all for a given identifier. These are validation and summation utilities used before transactions are committed or displayed.

Key Procedures and Functions

• GET_TOTAL_DIST_QTY — Returns the total ordered quantity for a distribution. It opens an explicit cursor that sums QUANTITY_ORDERED from PO_DISTRIBUTIONS filtered by the supplied distribution identifier, and assigns the result to an OUT NOCOPY numeric parameter. It guards against a null input identifier and routes error conditions through PO_MESSAGE_S.SQL_ERROR with a progress marker.
• TEST_GET_TOTAL_DIST_QTY — A test harness shell that invokes GET_TOTAL_DIST_QTY and discards the result. The commented DBMS_OUTPUT calls confirm its diagnostic purpose.
• TEST_VAL_DISTRIBUTION_EXISTS — The test counterpart to the validation routine. It exists to exercise the distribution-existence check during development and unit testing. This is the procedure associated with the user's search term.
• VAL_APPROVAL_STATUS — A validation routine for the approval status attribute of a distribution, returning or rejecting values based on the purchasing validation rules.
• NAMES and NAME — Naming helpers that resolve identifiers or labels associated with distribution records; NAME and NAMES appear as separate documented entries.

Tables Accessed

The single documented table is PO_DISTRIBUTIONS, accessed through an APPS synonym. GET_TOTAL_DIST_QTY reads it with an aggregate SUM over QUANTITY_ORDERED. The existence-validation path relies on the same table, since determining whether a distribution exists is a primary-key-style lookup against PO_DISTRIBUTIONS. No inserts, updates, or deletes are documented, so the package is effectively read-only in its documented behavior.

Usage Notes

PO_DIST_S is invoked indirectly by two other packages rather than by end users directly. Typical call sites are Purchasing forms logic, approval workflows, and custom extensions that need to confirm a distribution record or total distributed quantity before proceeding. The TEST_ prefixed routines should not be called in production paths; they are scaffolding with no meaningful return value and exist only to permit manual execution from SQL*Plus or a diagnostic session. Errors surface through PO_MESSAGE_S.SQL_ERROR, so callers should expect Purchasing-standard message handling rather than raised application exceptions. Because the package is not a published API, any direct dependency should be code-reviewed against upgrade impact, particularly across the 12.1.1 to 12.2.2 transition.