Search Results p_entered_currency

Overview

ARRX_RC_UNAPP is an Oracle Receivables (AR) report package body owned by APPS. It implements the PL/SQL logic behind the "Unapplied Receipts Register" RXi-style concurrent report, which lists receipts that have been received but not yet applied (or only partially applied) to customer transactions. The package header comment (version 120.14, last shipped 2012/05/18) identifies AR_UNAPP_REG as the inner procedure for the RXi report and states that it uses the appropriate FA_RX_UTIL_PKG routines to build the report output. Because it is an RXi (report extraction) based program, the package delegates report formatting and data extraction to the generic FA_RX_UTIL_PKG framework rather than emitting output directly.

The package was created 04-OCT-2004 by rkader, and was modified 23-Jun-2006 by ggadhams for payment uptake, with column sizes increased for Bug 5244326. It is classified in ETRM as API classification OTHER, meaning it is an internal report driver rather than a public callable API.

Key Procedures and Functions

• AR_UNAPP_REG — The main driver procedure for the Unapplied Receipts Register. It receives the concurrent request ID along with the full set of report input parameters, and assigns these to package global variables so that the FA_RX_UTIL_PKG before-report trigger can consume them. Its documented parameters include the request ID, reporting level and reporting entity, set of books and chart of accounts identifiers, a company (balancing) segment low/high range, GL date from/to, the entered currency (p_entered_currency), batch name and batch source low/high ranges, customer name and customer number low/high ranges, and receipt number low/high ranges. It returns the standard concurrent retcode and errbuf OUT NOCOPY parameters.
• BEFORE_REPORT — The FA_RX_UTIL_PKG callback executed before report execution, responsible for initializing the RXi report context using the globals populated by AR_UNAPP_REG.
• BIND — Binds the report columns and parameters to the query result set within the FA_RX_UTIL_PKG RXi framework.
• AFTER_FETCH — The fetch-time callback that performs per-row processing and derived computations as report rows are retrieved.

Tables Accessed

ETRM documents only two referenced objects via APPS synonyms: DBMS_SQL and DUAL. DUAL is used for trivial single-row computations and parameter assignment checks. DBMS_SQL indicates the package builds and executes dynamic SQL at runtime, which is the standard mechanism for RXi report drivers where the SELECT statement is assembled from the user's supplied flexfield ranges and parameter values rather than being statically coded. The report's transactional data (receipts, applications, customers, batches) is reached through this dynamic SQL and through FA_RX_UTIL_PKG, which is why no AR base tables are listed directly against the package.

Usage Notes

ARRX_RC_UNAPP is invoked internally by the Unapplied Receipts Register concurrent program; end users launch it from the Submit Requests form or from the Receivables responsibility, not by calling the package directly. The package is documented as referenced by one other package, consistent with a framework relationship with FA_RX_UTIL_PKG. The parameter p_entered_currency, which prompted this search, restricts report output to receipts entered in a specific currency and is passed into the package globals from the concurrent program's parameter form. Custom code should not call AR_UNAPP_REG directly, since it depends on the RXi runtime environment and the FA_RX_UTIL_PKG callbacks to produce output. For custom reporting requirements, developers should query the underlying AR receipt and application tables instead, or use supported Receivables public APIs. Any modification to this package body should be treated as an upgrade-sensitive change, because Oracle patches may overwrite it.