Search Results breakup_discounts

Overview

ARP_PROCESS_DET_PKG is an Oracle Receivables (AR) PL/SQL package owned by APPS that supports the detailed processing of receivable application activity. Its primary business function is to assemble, cache, and execute the distribution and application logic that occurs when a receipt is applied against a transaction, when adjustments are made, or when discounts, freight, and charges must be apportioned across transaction lines. The package operates as a low-level processing engine invoked by higher-level AutoAccounting and application routines within Receivables.

The header comment (version 120.7.12010000.1) indicates the package has been stable since the 11.5.10/12.0 era and continues unchanged into 12.1.1 and 12.2.2. It coordinates work performed by companion packages such as ARP_DET_DIST_PKG, and it stages data in global temporary tables (GT) before final distribution accounting is generated.

Key Procedures and Functions

• INITIALIZATION — Entry point that prepares the package for a given invoice and receipt. It copies transaction lines into the RA_CUSTOMER_TRX_LINES_GT global temporary table by calling ARP_DET_DIST_PKG, and caches the invoice payment schedule via GET_INV_PS.
• APPLICATION_EXECUTE — Core execution routine that applies amounts at the TRANSACTION, GROUP, or LINE level. It accepts amounts applied for line, tax, freight, and charges, together with earned and unearned discount components for each of those elements.
• FINAL_COMMIT — Performs the final commit of work staged during initialization and application execution.
• GET_LATEST_AMOUNT_REMAINING — Returns the latest remaining balance for the application in process.
• GET_LATEST_AMOUNT_APPLIED — Returns the latest applied amount.
• GET_APP_RA_AMOUNTS — Retrieves receivable application amounts used during processing.
• BASE_FOR_PRORATION and ELEMENT_FOR_PRORATION — Determine the base and element values used to prorate amounts across lines.
• VERIF_INT_ADJ_LINE_TAX — Validates line-level tax for interest adjustments; this is the object of the user's search term "verif_int_adj_line_tax".
• VERIF_INT_APP_LINE_TAX — Validates application line-level tax for interest adjustments, complementing the line tax verification.
• BREAKUP_DISCOUNTS — Splits discount amounts across the applicable elements (line, tax, freight, charges) for earned and unearned discount treatment.

Tables Accessed

The package reads and writes a defined set of AR tables through APPS synonyms. AR_RECEIVABLE_APPLICATIONS and AR_RECEIVABLE_APPLICATIONS_ALL hold the application rows being processed. AR_ADJUSTMENTS stores adjustment records, particularly relevant to the interest adjustment tax verification routines. RA_CUSTOMER_TRX and AR_PAYMENT_SCHEDULES provide transaction and schedule context. AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY supply receipt-level detail. AR_DISTRIBUTIONS_ALL receives the generated accounting distributions. AR_RECEIPT_METHODS and AR_RECEIPT_METHOD_ACCOUNTS drive receipt method accounting rules, while AR_RECEIVABLES_TRX and AR_AE_ALLOC_REC_GT support allocation processing. Staging and temporary results are held in AR_LINE_APP_DETAIL_GT and AR_LINE_DIST_INTERFACE_GT.

Usage Notes

ARP_PROCESS_DET_PKG is an internal processing package rather than a public API. It is invoked programmatically by five other packages within Receivables, typically during receipt application, adjustment creation, and AutoAccounting distribution generation. It is not exposed as a concurrent program or Oracle Forms entry point directly; instead it underlies the standard application and adjustment workflows. The VERIF_INT_ADJ_LINE_TAX and VERIF_INT_APP_LINE_TAX routines specifically support interest adjustment processing, verifying that line-level tax amounts are correctly identified before distributions are produced. Custom code should not call this package directly, as its interfaces and staged GTT structures are subject to change across patch levels.