Search Results get_acctd_amount

Overview

ARP_BR_REMIT_FUNCTION is an Oracle Receivables package body owned by APPS that supports the Brazilian localization remittance and factoring process. Its role is to resolve monetary values associated with a remittance or factoring event recorded in the transaction history, so that downstream processing can report or post the correct amount for a given status. The package operates against the core Receivables transaction history and distributions model, translating a status code into a specific source amount drawn from either distribution rows or receivable applications. It is classified in ETRM as OTHER rather than as a public API, indicating that it is an internal helper package invoked by the Brazilian remittance feature rather than by general customer extensions. The package header comment references an internal version string (115.8), reflecting its position in the legacy Brazilian localization code line that has been carried forward into EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

ETRM documents three program units within this package body.

• GET_AMOUNT — Returns a numeric amount for a transaction history record based on the supplied status and customer transaction. Its logic is status-driven: for the REMITTED status it retrieves the REMITTANCE distribution amount; for FACTORED it retrieves the FACTOR distribution amount; and for CLOSED it retrieves the applied amount from receivable applications. Any other status raises a standard Receivables procedure-validation exception using the FND_MESSAGE framework, with tokens identifying GET_AMOUNT and the P_STATUS parameter. This is the function most directly associated with the search term "get_amount," as it is the package's primary amount-resolution entry point.
• GET_ACCTD_AMOUNT — Returns the accounted amount counterpart to GET_AMOUNT. Where GET_AMOUNT resolves the entered amount, GET_ACCTD_AMOUNT resolves the accounted (ledger currency) value for the same remittance or factoring context, again keyed by transaction history, status, and customer transaction identifiers. It supports reporting and accounting entries where the accounted figure differs from the entered figure.
• REVISION — A supporting function in the package, typically used to expose the internal revision identifier used for change tracking of the localization code.

Tables Accessed

• AR_TRANSACTION_HISTORY — Provides the transaction_history_id and status columns that drive the p_trh_id and p_status inputs; status values such as REMITTED, FACTORED, and CLOSED determine which amount source is selected.
• AR_DISTRIBUTIONS — Supplies amount_dr for REMITTED and FACTORED statuses, filtered by source_id equal to the transaction history id, source_table of 'TH', and source_type of 'REMITTANCE' or 'FACTOR'.
• AR_RECEIVABLE_APPLICATIONS — Supplies amount_applied for the CLOSED status, filtered by applied_customer_trx_id, status 'APP', and link_to_trx_hist_id matching the transaction history record.
• RA_CUSTOMER_TRX — Referenced for the customer_trx_id key that links applications back to the originating transaction.

Usage Notes

This package is invoked internally by the Brazilian remittance and factoring flow in Oracle Receivables rather than being called directly by end users. It is referenced by one other package in the ETRM dependency map, consistent with its role as a lower-level utility beneath the remittance feature's orchestration code. Customers extending the Brazilian localization should treat GET_AMOUNT and GET_ACCTD_AMOUNT as internal routines whose contracts may change; any custom integration should rely on the supported Receivables APIs instead. Because the logic branches strictly on status, callers must pass a status value recognized by the function, otherwise the procedure-validation exception is raised. Earlier releases shipped this code in the 11i-era ARBRRMFB.pls file, and the same package body remains available in 12.1.1 and 12.2.2 for compatibility with existing Brazilian localization processing.