Search Results amount_withheld




Overview
Explore in AI Chat

Overview

ICX_AP_INVOICES_PKG is an Oracle Application Object Library PL/SQL package body owned by the APPS schema and classified under API type OTHER. It provides supporting data-retrieval logic for the Oracle iProcurement and Internet Expenses invoice review user interfaces, which fall under the ICX (Interaction Center eXchange) application family. The package sits behind invoice detail and drill-down pages that allow requesters, approvers, and payables personnel to inspect the composition of a supplier invoice without navigating directly into Oracle Payables forms.

Two concerns are addressed. The first is presentation of the purchase order context for an invoice: users viewing an invoice in an ICX-based self-service page need to see which purchase orders the invoice references, expressed as a human-readable list rather than as internal identifiers. The second, and most relevant to searches on amount_withheld, is the quantification of withheld tax amounts recorded on the invoice, which is required for accurate display of invoice totals and net payable figures.

Key Procedures and Functions

  • GET_PO_NUMBER_LIST — Returns a comma-delimited character string containing the distinct purchase order numbers associated with a given invoice, or NULL when the invoice is not matched to any purchase order. It opens an explicit cursor that joins invoice distribution rows to PO distributions and PO headers, concatenating each PO header segment into a single output string. This function is typically used to populate the PO Number field on ICX invoice inquiry screens where multiple PO references may exist on a single invoice.
  • GET_AMOUNT_WITHHELD — Returns the automatic withholding tax (AWT) amount withheld on an invoice. The implementation aggregates the amount column of the AP_INVOICE_DISTRIBUTIONS table for rows whose line type is 'AWT', negating the sum so that the returned value is expressed as a positive withheld amount. Null amounts are coalesced to zero, and the function initializes its local variable to zero, so an invoice with no withholding distributions returns 0 rather than NULL.

Tables Accessed

  • AP_INVOICE_DISTRIBUTIONS — The primary source for both functions. GET_PO_NUMBER_LIST reads the invoice_id and po_distribution_id columns to link invoice lines to purchase order distributions. GET_AMOUNT_WITHHELD reads invoice_id, line_type_lookup_code, and amount to isolate and total withholding lines. The package performs read-only access; it does not insert, update, or delete rows.
  • PO_HEADERS — Read by GET_PO_NUMBER_LIST to resolve the segment1 (PO number) value for each matched PO header. Accessed through the PO_DISTRIBUTIONS_AP_V view, which supplies the po_header_id join key and restricts the distributions to those visible to Payables.
  • PO_DISTRIBUTIONS_AP_V — A Payables-facing view over purchase order distributions used as the join bridge between invoice distributions and PO headers.

Usage Notes

The package is referenced by five other packages, confirming that it is an internal utility layer rather than a top-level entry point. It is not registered as a concurrent program and exposes no user-facing API; callers typically pass only an invoice identifier and receive scalar results suitable for direct display. Typical invocations occur when an ICX self-service invoice page is rendered: the page controller calls GET_AMOUNT_WITHHELD to display the withheld tax component of the invoice and GET_PO_NUMBER_LIST to display matched PO references.

Because the functions rely on APPS synonyms and are not wrapped in an open API contract, customizations should treat them as read-only conveniences. Performance is generally acceptable for single-invoice lookups, but the PO number cursor performs a DISTINCT join and should not be invoked in bulk loops. All monetary results from GET_AMOUNT_WITHHELD inherit the functional currency of the invoice, and the function returns a sign-adjusted value rather than the raw negative distribution amount.