Search Results test_get_po_encumbered

Overview

PO_HEADERS_SV2 is a server-side validation package in the Oracle E-Business Suite Purchasing module, owned by the APPS schema. The package bundles row-level validation logic used by the Purchasing forms and public APIs to enforce business rules on purchase order header data before a record is committed or its approval status is refreshed. The source header identifies the module as POXPOH2S.pls (version 115.5), confirming its role as a supporting validation library for the PO Headers entity.

The primary documented function, val_approval_status, compares a set of header attributes against their current database values (selected by ROWID) and determines whether any critical purchasing attribute has changed—including agent, vendor site, vendor contact, confirming order flag, ship-to and bill-to locations, payment terms, ship-via, FOB, freight terms, note to vendor, acceptance flags and dates, blanket amount, start and end dates, amount limit, and contracting terms update dates. When a change is detected, the function signals the calling process to refresh the document status, which drives re-approval, re-encumbrance, or workflow restart. The package is therefore central to maintaining document integrity across the header's lifecycle.

Key Procedures and Functions

The ETRM metadata lists ten documented procedures and functions, of which three are named in the extract. NAME is the package's identity or naming routine used internally for object identification. TEST_GET_PO_ENCUMBERED is a diagnostic/test utility associated with purchase order encumbrance retrieval—appropriate given that this is the object returned for the user's search term "test_get_po_encumbered." It allows developers or support personnel to probe the encumbered amount associated with a purchase order, an essential check in budgetary control and funds reservation scenarios. VAL_CONTRACT_EFF_DATE validates contract effective dates, ensuring that purchasing documents tied to contracts do not take effect outside the contract's valid date range.

The header also documents val_approval_status and update_children, the latter of which propagates changes made at the header level down to dependent line, shipment, and distribution records. Parameter lists are intentionally omitted here, as the package's signatures are version-specific and should be confirmed against the deployed source.

Tables Accessed

The package references several core Purchasing tables through APPS synonyms: PO_HEADERS and PO_HEADERS_ALL (the header record and its multi-org variant, read to detect changed values and status), PO_LINES_ALL and PO_LINE_LOCATIONS_ALL (line and shipment data updated when children are synchronized), PO_RELEASES (for release-level attributes and amounts), and PO_REQUISITION_LINES_ALL (supporting requisition-to-PO linkage checks). These reads and writes underpin the validation and child-update routines.

Usage Notes

PO_HEADERS_SV2 is invoked indirectly: the Purchasing forms call it during header save and approval-status refreshes, while public APIs and workflow activities use it to detect material changes that require re-approval or encumbrance recalculation. Because the package is referenced by three other packages, customizations should avoid overriding it directly. TEST_GET_PO_ENCUMBERED is typically called from a test or diagnostic script rather than production code. All calls run with AUTHID CURRENT_USER, so effective privileges are governed by the invoking user's schema context.