Search Results calc_amt_applied

Overview

AR_CC_LOCKBOX is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports Automatic Receipts processing for credit card lockbox transmissions. It operates at the boundary between raw bank lockbox transmission data and the standard Oracle Receivables receipt application engine. The package implements the calculation and staging logic required to interpret lockbox records that carry credit card settlement information, map those records against open customer transactions, and prepare rows in the AR_PAYMENTS_INTERFACE table for downstream validation and application by the Automatic Receipts program (AR_RECEIPT_API_PUB and its related concurrent programs). It is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling session rather than as definer, which is relevant to how it is invoked from concurrent managers and any custom wrapper code. The header comment dates the source file to release 11.5.3 lineage (ARCCLOCS.pls 115.3), and the object remains documented in ETRM for 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes five documented procedures and functions. Each is described below; parameter lists are intentionally omitted and procedural signatures should be obtained from the database or from the shipped ARCCLOCS.pls source.

• CALC_CROSS_RATE — Derives the cross-currency conversion rate between an invoice currency and a receipt currency when the two differ. Its output is used to populate the cross-rate field on receipts staged in the interface, enabling correct amount_applied_from computation for cross-currency receipt application.
• POPULATE_ADD_INV_DETAILS — The principal staging routine. It parses lockbox transmission records and writes additional invoice detail rows into AR_PAYMENTS_INTERFACE, applying the caller-supplied transmission identifier, payment and overflow record types, batch and lockbox identifiers, and the various formatting masks that describe how numeric amounts are laid out in the transmission file. It also honors flags controlling whether unrelated invoices may be paid, whether a single lockbox is being processed, and whether cross-currency application is enabled.
• CALC_AMT_APPLIED_FROM — Computes the amount_applied_from value, the amount expressed in the transaction's currency, from the entered amount applied, the currency code, and the transaction-to-receipt conversion rate.
• CALC_AMT_APPLIED — Performs the inverse or complementary calculation, deriving the amount applied from the supplied invoice currency context.
• ARE_VALUES_VALID — A validation helper that confirms referenced values are consistent and valid before the interface rows are committed for application.

Tables Accessed

The package reads and writes AR_PAYMENTS_INTERFACE, which is the staging table for lockbox and manual receipts awaiting application. It reads AR_LOCKBOXES for lockbox configuration, including the record and transmission definitions that govern parsing. AR_PAYMENT_SCHEDULES is joined to determine open installment balances and to support application logic. FND_CURRENCIES supplies currency attributes and precision used in rate and rounding calculations. HZ_CUST_ACCOUNTS and HZ_CUST_ACCT_RELATE resolve the customer and any account relationship context for matching lockbox remittances to the correct payer. RA_CUST_TRX_TYPES identifies valid transaction types during invoice matching. DUAL is used for single-row scalar computations.

Usage Notes

AR_CC_LOCKBOX is not an end-user-facing API; it is internal plumbing invoked during Automatic Receipts lockbox processing, typically from the lockbox import and receipt application flow that runs under the Receivables concurrent manager. It may be called from submission of the Lockbox Transmission and Automatic Receipts programs when credit card records are present, and from custom extensions that pre-process lockbox files before standard import. Because it is AUTHID CURRENT_USER, custom code calling it must run with appropriate APPS-level privileges. The package is referenced by one other package in the ETRM inventory, indicating that at least one shipped or dependent program relies on its calculation routines. Implementers extending cross-currency or multi-invoice lockbox behavior should treat CALC_CROSS_RATE, CALC_AMT_APPLIED, and CALC_AMT_APPLIED_FROM as the authoritative amount conversion helpers rather than reimplementing that arithmetic.