Search Results get_packing_slip_list

Overview

POS_AP_INVOICES_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified as a public API (API classification: OTHER). It belongs to the Public Sector (POS) product family and provides the data access layer that supports the invoice inquiry and expense-report views used by Oracle Purchasing, Payables, and Public Sector Procurement applications. The package encapsulates the business logic required to retrieve supplier invoice information together with its associated purchase order, receipt, payment, tax, prepayment, retainage, and hold data. Rather than exposing complex multi-table joins directly to the presentation layer, the package surfaces this information through a set of well-defined getter functions and procedures that the invoice inquiry views call.

Its principal consumers are the views POS_AP_INVOICES_V, POS_AP_EXPENSE_REPORTS_V, and POS_PO_SUP_ORDER_INVOICES_V, all of which rely on the package to aggregate invoice attributes from the Payables and Purchasing base tables. It is also referenced by three other PL/SQL packages within the APPS schema. The object is documented as VALID in ETRM releases 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes sixteen documented program units. Their purposes are as follows:

• GET_PO_NUMBER_LIST — Returns the list of purchase order numbers associated with an invoice.
• GET_PACKING_SLIP_LIST and GET_PACKING_SLIP — Retrieve the collection of packing slips, or an individual packing slip, linked to invoice lines.
• GET_RECEIPT_INFO — Supplies receipt details derived from the receiving tables so an invoice can be reconciled against goods received.
• GET_PO_INFO — Returns purchase order header and release information relevant to the invoiced transaction.
• GET_RETAINAGE_FOR_INVOICE — Calculates the retainage amount withheld on a given invoice.
• GET_PREPAY_FOR_INVOICE — Returns prepayment amounts applied to or available against the invoice.
• GET_TOTAL_FOR_INVOICE — Computes the total invoiced amount.
• GET_TAX_FOR_INVOICE — Returns the tax amount associated with the invoice.
• GET_AMOUNT_WITHHELD — Returns the total amount withheld, including hold-related amounts.
• GET_PAYMENT_LIST and GET_PAYMENT_INFO — Return the payments applied to an invoice and the detailed payment attributes, respectively.
• GET_DUE_DATE — Derives the invoice due date from the payment schedule.
• GET_ON_HOLD_INFO and GET_ON_HOLD_STATUS — Return hold details and the current hold status of the invoice.

Parameter lists are intentionally not documented here; callers should reference the package specification in the APPS schema.

Tables Accessed

The package reads from several Payables and Purchasing base tables via APPS synonyms:

• AP_INVOICES… (AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL, AP_PAYMENT_SCHEDULES_ALL, AP_INVOICE_PAYMENTS_ALL) — provide invoice lines, distributions, scheduled payments, and applied payments.
• AP_CHECKS_ALL — supplies payment document details.
• AP_HOLDS_ALL — provides invoice hold records used by the on-hold functions.
• PO_HEADERS_ALL, PO_RELEASES_ALL, PO_DISTRIBUTIONS_ALL — supply purchase order header, release, and distribution information linked to the invoice.
• RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, RCV_TRANSACTIONS — supply receipt and receiving transaction data for reconciliation against invoices.

The package is primarily read-oriented; any writes occur indirectly through the underlying Payables APIs rather than through direct DML on these tables.

Usage Notes

POS_AP_INVOICES_PKG is invoked almost exclusively through the invoice inquiry and expense-report views in Oracle Public Sector and Payables inquiry forms. Because the views depend on the package, any customization or extension of those views must preserve the package API contract. Concurrent programs and custom code that need summary invoice, PO, receipt, payment, tax, or retainage information can call the package functions directly to avoid re-implementing complex joins. When extending the package, developers should treat all sixteen procedures and functions as the supported interface and avoid altering their signatures, since dependent views and packages (POS_AP_INVOICES_V, POS_AP_EXPENSE_REPORTS_V, POS_PO_SUP_ORDER_INVOICES_V, and three referencing packages) will fail to compile if the specification changes.