Search Results icx_ap_invoice_payments_pkg




Overview
Explore in AI Chat

Overview

APPS.ICX_AP_INVOICE_PAYMENTS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its status is VALID, and the ETRM repository classifies it under the API classification OTHER, indicating that it is an internal supporting package rather than a formally published public API. The package belongs to the ICX (Oracle iProcurement / Internet Procurement) module family, whose views expose Payables and Purchasing data to self-service web applications. Its central purpose is to resolve and supply payment-related reference information for invoices displayed in ICX-based inquiry and reporting views. Specifically, it provides the data necessary to describe how a given invoice was paid, such as the payment or check reference associated with the invoice, and to build the selectable "Paid By" listing used in those user interfaces. The package thus acts as a presentation-layer data provider between the Oracle Payables base tables and the ICX self-service views.

Key Procedures and Functions

The ETRM metadata documents a single procedure or function within this package:

  • GET_PAID_BY_LIST — Retrieves the list of payment reference values (the "paid by" list) applicable to one or more invoices. It supplies the lookup data used by ICX views and self-service pages to display the payment instrument or check reference through which an invoice was settled. No parameter list is published in the ETRM documentation, and parameter details should be confirmed against the package specification in the target environment before invocation.

No additional documented procedures or functions exist in the ETRM record; the package specification and body are both listed as present but their internal logic is not itemized.

Tables Accessed

The package references the following base tables through APPS synonyms:

  • AP_CHECKS — the Oracle Payables payments table, holding payment and check records. The package reads this table to derive the payment reference returned by GET_PAID_BY_LIST.
  • AP_INVOICES — the invoice header table, used to link an invoice to its payment records and to constrain the returned list to the relevant invoice set.
  • AP_INVOICE_PAYMENTS — the invoice-to-payment association table, which joins invoices with the payments applied against them and is the primary source for determining how each invoice was paid.

These three tables form the standard Payables payment-resolution join path, confirming that the package is read-only with respect to Payables transactional data.

Usage Notes

ICX_AP_INVOICE_PAYMENTS_PKG is not intended for direct invocation by end users or external interfaces. It is referenced by four dependent ICX views:

Through these views, the package is exercised whenever a user queries invoice or expense-report information in iProcurement, Payables self-service, or related ICX inquiry pages. In custom development, the package should be treated as an internal dependency of those views; custom code should query the ICX views rather than call GET_PAID_BY_LIST directly, since the procedure is undocumented as a public API and its signature is not guaranteed across patch levels. Because the package also references itself in the dependency listing, deployments and recompilations should follow the standard APPS schema dependency ordering to avoid invalidated view states after patching. In Oracle EBS 12.2.2, with the online patching (adop) model, recompilation is handled automatically during patching cycles, but administrators validating view status should include these ICX views in post-patch verification.