Search Results ap_checks_s

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:

• AP_CHECKS_ALL and AP_CHECKS_S — the base and sequence/security views for payment records. The user search term "ap_checks_s" corresponds directly to this dependency. The package inserts and updates payment rows here when netting payments are created.
• AP_INVOICES, AP_INVOICES_ALL, and AP_INVOICE_PAYMENTS_S — invoice headers and invoice-to-payment associations, used to identify netted invoices and record their payment linkage.
• AP_PAYMENT_SCHEDULES and AP_PAYMENT_SCHEDULES_ALL — used to read scheduled amounts and derive discounts and netted amounts.
• AP_SUPPLIER_SITES_ALL and AP_SYSTEM_PARAMETERS — supplier site defaults and Payables system options that govern payment behavior.
• FND_DOCUMENT_SEQUENCES, FND_DOC_SEQUENCE_ASSIGNMENTS, and FND_SEQNUM — document sequencing and sequence number generation for the payment document.
• GL_PERIOD_STATUSES — general ledger period validation to ensure the payment falls in an open accounting period.
• FND_LOG, FND_LOG_MESSAGES, and FND_MESSAGE — logging and message retrieval for diagnostics and user-facing errors.
• DUAL and PLITBLM — standard utility references.

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.