Results for “ap_pay_single_invoice_pkg”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.AP_PAY_SINGLE_INVOICE_PKG is a server-side PL/SQL package in the Oracle Payables (AP) module that provides a programmatic interface for paying a single invoice in full. Rather than routing a payment through the standard batch payment process — which selects, formats, and confirms payment batches for many invoices at once — this package supports the immediate, single-invoice disbursement scenario. It bridges the Payables invoice and payment schedule data with the Oracle Payments (IBY) disbursement layer, allowing an application or concurrent program to create and confirm a payment for one invoice without user intervention in the standard Payables payment workbench.
The package is classified as OTHER in the ETRM API classification, indicating it is a documented internal/supporting package rather than a formally published public API. Its status is VALID under the APPS schema, and it is referenced by the FV_IPAC_AUTOPAYMENTS_PKG package, which is associated with Treasury/IPAC automated payment processing. This dependency confirms its role as a reusable payment-execution building block for other modules.
Key Procedures and Functions
The ETRM metadata documents one procedure or function within this package:
- AP_PAY_INVOICE_IN_FULL — The core routine of the package. Its purpose is to pay a designated accounts payable invoice for its full outstanding amount, driving the payment from invoice selection through to disbursement. It coordinates with the IBY_DISBURSE_SINGLE_PMT_PKG dependency, which performs the actual Oracle Payments single-payment disbursement. The procedure is responsible for validating the invoice, establishing the payment schedule, creating the payment document record, and recording payment history. No parameter list is documented in the ETRM metadata; callers should inspect the package specification in the target environment for the exact signature.
Tables Accessed
The package reads and writes a range of Payables, Payments, and setup tables through APPS synonyms:
- AP_INVOICES_ALL, AP_PAYMENT_SCHEDULES_ALL, AP_SELECTED_INVOICES_ALL — invoice header, scheduled payment lines, and the selection of invoices eligible for payment.
- AP_CHECKS, AP_CHECKS_ALL, AP_CHECKS_S — creation and maintenance of the payment (check) record and its distribution/schedule records.
- AP_PAYMENT_HISTORY_ALL — recording the payment event against the invoice for audit and reporting.
- AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL — supplier and supplier site used to determine remit-to and payment details.
- AP_SYSTEM_PARAMETERS_ALL — Payables system options that govern payment behavior and defaults.
- CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL, CE_PAYMENT_DOCUMENTS — the disbursement bank account, its usage assignments, and payment document setup.
- FND_DOC_SEQUENCE_CATEGORIES — document sequence category for payment numbering.
- GL_PERIOD_STATUSES — validation that the relevant accounting period is open before posting payment accounting.
Usage Notes
This package is intended for programmatic, single-invoice payment execution rather than interactive use. It is typically invoked from custom PL/SQL code, from concurrent programs, or from other packaged logic — as evidenced by its reference from FV_IPAC_AUTOPAYMENTS_PKG. It should not be confused with the standard Payables payment batch or Quick Payment flows, which use separate APIs and concurrent programs. Because it is not a formally published public API and its parameters are not documented in ETRM, implementers should treat it as an internal interface: validate behavior against the specific EBS release (12.1.1 or 12.2.2) and test thoroughly in a controlled environment before relying on it in production. Its dependency on IBY_DISBURSE_SINGLE_PMT_PKG means the Oracle Payments disbursement setup, payment process profile, and bank account configuration must be correctly defined for successful execution.
-
SYNONYM: APPS.AP_CHECKS_S 12.1.1
-
SYNONYM: APPS.AP_CHECKS_S 12.2.2
-
SYNONYM: APPS.AP_CHECKS 12.1.1
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: APPS.AP_CHECKS_ALL 12.1.1
-
SYNONYM: APPS.AP_CHECKS 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: APPS.AP_CHECKS_ALL 12.2.2
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: APPS.AP_SUPPLIERS 12.1.1