Search Results ap_invoice_payments_s




Overview
Explore in AI Chat

Overview

The APPS.AP_PAYMENT_PUBLIC_PKG package body is a public PL/SQL API within the Oracle E-Business Suite Payables (AP) module. Its primary business function is to support the creation and management of netting payments, whereby offsetting payables and receivables between trading partners or related parties are consolidated so that only a net balance is settled. The package exposes a small, deliberately public interface of four callable units (two procedures and two functions) that allow external programs, forms, and concurrent processes to generate netting payment records against the AP payment tables and to compute the discounts applicable to those payments.

The package is documented with a status of VALID under the APPS schema and is classified generically as OTHER in the ETRM 12.2.2 metadata. It is not a core seeded API such as AP_PAYMENT_PKG or AP_INVOICE_PKG; rather, it is a supporting public package that isolates netting-related logic and discount derivation so that it can be reused across callers without duplicating business rules. Within the package body, the implementation also depends on internal AP packages such as AP_PAY_INVOICE_PKG, AP_RECONCILIATION_PKG, AP_ACCOUNTING_EVENTS_PKG, AP_AC_TABLE_HANDLER_PKG, and AP_UTILITIES_PKG, indicating that netting payment creation involves payment schedule validation, reconciliation, accounting event generation, and utility lookups.

Key Procedures and Functions

The documented public interface consists of four callable units:

  • CREATE_NETTING_PAYMENT — A procedure that creates a netting payment. It is the primary entry point for generating a payment record that represents a netted settlement, writing to the AP checks and payment tables.
  • CREATE_NETTING_INV_PAYMENT — A procedure that creates the netting invoice-payment association, linking invoices to the netting payment created by CREATE_NETTING_PAYMENT and recording the corresponding detail rows.
  • GET_DISC_FOR_PMT_SCHEDULE — A function that derives the available discount for a given payment schedule, used to determine the discount amount applicable before a payment is created.
  • GET_DISC_FOR_NETTED_AMT — A function that derives the discount applicable to a netted amount, supporting the calculation of net settlement values across multiple offsetting items.

The metadata does not expose parameter lists, so signatures are intentionally not described here; callers should consult the package specification in the target instance.

Tables Accessed

The package reads and writes across the principal Payables payment, invoice, and scheduling tables through APPS synonyms:

Usage Notes

AP_PAYMENT_PUBLIC_PKG is invoked programmatically rather than through a seeded form or standard concurrent program. It is referenced by one other package, confirming it is called from within the AP codebase (typically a netting or payment-processing program). Custom extensions that require netting payment generation should call the public procedures in the correct sequence: first CREATE_NETTING_PAYMENT to establish the payment, then CREATE_NETTING_INV_PAYMENT to associate invoices. The discount functions GET_DISC_FOR_PMT_SCHEDULE and GET_DISC_FOR_NETTED_AMT may be called independently to preview discount amounts. Because the package performs document sequencing and period validation, callers must ensure Payables is properly configured and that the target GL period is open. All calls should be wrapped in appropriate transaction control, as the package does not manage commit scope for the caller.