Search Results get_apdist_qty




Overview
Explore in AI Chat

Overview

PA_CMT_UTILS is an Oracle Projects utility package owned by the APPS schema. Its name reflects its role as a helper library for commitment processing within Oracle Project Costing and Oracle Grants Management. In Oracle EBS, a commitment represents an anticipated cost arising from a purchase order, requisition, or supplier invoice that has not yet been matched to actual project expenditure. The package supplies reusable PL/SQL routines that convert raw transactional data—receipts, invoice distributions, purchase order distributions, and accounts payable payment records—into the quantity and amount values that populate commitment, burden, and encumbrance views.

The object is documented as VALID in ETRM for both 12.1.1 and 12.2.2, and is classified as an OTHER API rather than a public, supported interface. It is referenced by 23 other packages and a substantial family of views, confirming its position as an internal building block rather than a standalone business process driver.

Key Procedures and Functions

Seven procedures and functions are documented for this package. Their names indicate the data-retrieval responsibilities they perform:

  • GET_RCPT_QTY — Retrieves received quantity from receiving records so that commitment quantities reflect goods actually received against a purchase order or requisition.
  • GET_INV_CMT — Obtains the commitment amount associated with supplier invoices, supporting the accrual side of commitment reporting.
  • GET_INV_VAR — Returns the invoice variance element, allowing committed values to be reconciled against invoiced values.
  • GET_APDIST_QTY — Extracts the quantity recorded on accounts payable invoice distribution lines.
  • GET_APDIST_AMT — Extracts the amount recorded on accounts payable invoice distribution lines.
  • IS_EIB_ITEM — Returns a boolean-style indicator testing whether an item is an Oracle E-Business Suite Inventory item, used to branch logic for inventory versus non-inventory commitments.

These routines are invoked internally by the views and packages that build the commitment picture; they are not intended to be called directly by end users. Parameter lists are not published in the ETRM extract and should be confirmed from the package source in the specific instance.

Tables Accessed

The package reads transactional tables through APPS synonyms: AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL for invoice headers and lines; AP_PREPAY_APP_DISTS and AP_SELF_ASSESSED_TAX_DIST_ALL for prepayment applications and tax distributions; AP_PAYMENT_HIST_DISTS for payment history detail; PO_DISTRIBUTIONS_ALL, PO_LINES_ALL, and PO_LINE_LOCATIONS_ALL for purchasing commitment detail; RCV_RECEIVING_SUB_LEDGER and RCV_TRANSACTIONS for receiving activity; MTL_SYSTEM_ITEMS to identify inventory items; and PA_COST_DISTRIBUTION_LINES_ALL with PA_EXPENDITURE_ITEMS_ALL to relate commitments to project expenditure. DUAL and PLITBLM are used for SQL expression evaluation and internal PL/SQL table handling. Write operations, if any, are confined to the project-side cost and expenditure tables.

Usage Notes

PA_CMT_UTILS is consumed implicitly. The ETRM dependency list shows it referenced by PA_CHECK_COMMITMENTS, by the commitment views PA_COMMITMENTS_V, PA_COMMITMENTS_V1, and PA_COMMITMENT_TXNS_V, by the project PO and AP distribution views and tables, and by Grants Management objects such as GMS_COMMITMENTS_OVERRIDE_V and GMS_STATUS_COMMITMENTS_V. Consequently, it executes whenever those views are queried—typically from commitment inquiry forms, commitment and encumbrance concurrent programs, and Grants Management commitment reporting. Because it is an undocumented internal API, customizations should call the supported views rather than the package directly, and any direct reference must be regression-tested during upgrades between 12.1.1 and 12.2.2.