Search Results icx_ap_checks_pkg

Overview

ICX_AP_CHECKS_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the general "OTHER" API category. It belongs to the ICX (Oracle iProcurement / Internet Commerce Exchange) module family and is closely associated with the Oracle Payables (AP) payment workflow. Its principal business function is to determine, for a given payment or check record, which invoices have been settled by that payment. This supports the self-service and procurement-facing views through which users review payment activity against supplier invoices, without requiring direct navigation of the core Payables inquiry forms.

The package is defined with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the defining APPS schema. Its header carries an original revision marker dating to 1999, indicating it is a long-standing, stable component of the EBS codebase carried forward into 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents a single program unit within this package.

• get_invoices_paid — A function that returns invoice payment information associated with a specific payment record. It accepts a single identifier representing the payment or check (referenced internally as l_check_id) and returns a VARCHAR2 result. The function is pure with respect to database state: it is declared with the PRAGMA RESTRICT_REFERENCES assertion specifying WNDS, WNPS, and RNPS, meaning it performs no writes to database state, no writes to package state, and no reads of package state. This constraint makes it safe for invocation inside SQL statements as well as from PL/SQL.

No other procedures or functions are exposed by the documented specification. The single public entry point reflects the package's narrow, purpose-built design: answering one question about payment-to-invoice linkage.

Tables Accessed

The package references two core Oracle Payables tables through APPS synonyms:

• AP_INVOICES — The Payables invoice header table. It supplies invoice-level attributes such as invoice number, supplier, and amount for the invoices determined to have been paid.
• AP_INVOICE_PAYMENTS — The intersection table linking invoices to their payments. This is the primary table used to resolve which invoices correspond to the supplied payment identifier.

Because the function carries WNDS and WNPS assertions, its interaction with these tables is read-only. It queries payment and invoice relationships rather than creating, updating, or deleting records.

Usage Notes

The package is referenced by one other package in the documented metadata, indicating it is consumed programmatically rather than executed standalone. Typical invocation scenarios include:

• iProcurement and self-service payment inquiry — Displaying the invoices settled by a particular payment so that requesters and buyers can reconcile what they have been billed against what has been paid.
• Payments workbench and inquiry forms — Embedded calls that populate invoice detail when a user drills into a payment or check.
• Custom extensions and concurrent programs — Because the function is callable from SQL, developers frequently embed it in custom reports or reconciliation queries that need to list paid invoices for a payment.

When integrating, developers should note the package is part of the ICX application surface and is not documented as a formally supported public API. Oracle's standard guidance for such "OTHER" classified objects applies: use them cautiously, understand the underlying table semantics, and validate behavior across both 12.1.1 and 12.2.2 since the Online Patching architecture in 12.2 does not alter the core Payables data model but does affect how custom code should be deployed and editioned.