Search Results po_intg_document_funds_grp




Overview
Explore in AI Chat

Overview

PO_INTG_DOCUMENT_FUNDS_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified as a "GRP" (group) object within the ETRM repository, indicating that it consolidates a related set of purchasing fund and encumbrance routines that are intended to be invoked together as a logical unit of work rather than as a general-purpose public API. The package sits at the intersection of Oracle Purchasing and Oracle Grants Management, providing the plumbing that lets purchasing documents (purchase orders, requisitions and their distributions) participate correctly in encumbrance accounting. Its central concern is determining and reinstating the active encumbrance amount associated with a purchasing document so that commitments remain accurate as documents are created, modified, cancelled or closed. Because it is referenced by both Purchasing inquiry components and Grants Management budget/commitment views, it functions as a shared funds-control utility across the two modules.

Key Procedures and Functions

The documented API surface consists of three units:

  • REINSTATE_PO_ENCUMBRANCE — a procedure that re-establishes (reinstates) the encumbrance for a purchasing document. This is typically required when a document that was previously relieved of its commitment — for example through cancellation, final close, or a funding re-evaluation — must again be reflected as an outstanding encumbrance against the correct budget. It is the corrective counterpart to normal encumbrance relief.
  • GET_ACTIVE_ENCUMBRANCE_AMOUNT — a function that returns the monetary value of the encumbrance currently active for a given purchasing document. It is the amount still standing against funds, as distinct from amounts already relieved or invoiced. Callers use it to reconcile commitment balances.
  • GET_ACTIVE_ENCUMBRANCE_FUNC — a function that resolves the functional-currency representation of the active encumbrance. Because purchasing documents may be denominated in a transaction currency while budgets are held in the ledger's functional currency, this companion function performs the currency conversion needed to present the amount in functional terms.

The routines depend on FND_API (the standard EBS API utility package) for error handling and message conventions, consistent with Oracle's public API coding standards.

Tables Accessed

The package reads purchasing base tables through APPS synonyms. PO_DOCUMENT_TYPES supplies the document-type classification (for example, standard purchase order, blanket, requisition) that governs how encumbrance logic is applied. PO_DISTRIBUTIONS_ALL and PO_LINE_LOCATIONS_ALL provide the distribution-level and shipment/schedule-level detail from which committed amounts are derived and against which encumbrance is reinstated. PO_REQUISITION_LINES_ALL and PO_REQ_DISTRIBUTIONS_ALL extend the same treatment to requisitions, ensuring that requisition-level commitments are consistent with those of the resulting purchase orders. Together these tables let the package age and quantify only the genuinely outstanding portion of a document.

Usage Notes

PO_INTG_DOCUMENT_FUNDS_GRP is an internal integration package rather than a documented end-user API; it is not normally called directly from forms. It is invoked indirectly by other purchasing and grants components, including PO_INQ_SV (the purchasing inquiry service used by the Purchase Order and Requisition inquiry windows), and by Grants Management objects such as GMS_BUDGET_BALANCE, GMS_COST_PLUS_EXTN, GMS_COMMITMENT_BURDEN_V, GMS_COMMITMENT_ENCUMBERED_V and GMS_STATUS_COMMITMENTS_V. It is also referenced by PSA_AP_BC_PVT, linking it to Projects/Public Sector budgeting. Custom code should treat it as an unsupported internal dependency and prefer calling a supported public API, since its signature and behavior are not guaranteed across releases.