Search Results arxsoc_deposit_date_range

Overview

APPS.AR_ARXSOC2_XMLP_PKG is the generated PL/SQL package body that backs the Oracle Receivables XML Publisher (BI Publisher) concurrent program associated with the ARXSOC2 report — the "Deposit/Cash Receipts Summary" style report that reconciles receipt control amounts against actual, unapplied, unidentified, and miscellaneous amounts. In Oracle EBS 12.1.1 and 12.2.2, XML Publisher reports are published as concurrent programs whose data model is driven by a PL/SQL package; this package supplies the report's formula columns, group-level aggregates, layout parameters, and the before/after report triggers that Oracle Reports-compatible XMLP execution expects.

The package is classified as OTHER and is not referenced by any other package in the ETRM inventory. It is a leaf-level, report-private package: it is invoked only by its owning concurrent program and serves no shared API role.

Key Procedures and Functions

The package exposes 37 documented procedures and functions. Because the metadata does not specify parameter lists, they are described by purpose only.

• BEFOREREPORT and AFTERPFORM — report lifecycle triggers. BEFOREREPORT initializes the report and returns TRUE; AFTERPFORM handles post-formula processing for the data model.
• AFTERREPORT — terminates the report session and returns TRUE.
• REPORT_NAMEFORMULA — builds the report title. It formats the low and high date parameters as DD-MON-YYYY, calls the ARP_STANDARD.FND_MESSAGE message ARXSOC_DEPOSIT_DATE_RANGE to produce a localized date range string, and looks up the concurrent program's user-friendly name from FND_CONCURRENT_PROGRAMS_VL joined to FND_CONCURRENT_REQUESTS on the request ID, trimming the " (XML)" suffix.
• C_DIFFERENCE_AMOUNTFORMULA and CA_DIFFERENCE_AMOUNTFORMULA — compute the difference between a receipt control amount and an actual amount, using NVL to treat nulls as zero. The C_ variant operates at the currency level and the CA_ variant at the consolidated/currency-amounts level.
• C_SUMMARY_LABELFORMULA and CA_SUMMARY_LABELFORMULA — normalize currency labels by right-padding then trimming to three characters.
• F_AMOUNTSFORMULA and F_ALL_AMOUNTSFORMULA — aggregate amount formulas for the report's functional currency columns.
• C_UNAPPLIED_AMOUNTFORMULA and CA_UNAPPLIED_AMOUNTFORMULA — derive unapplied receipt amounts at currency and consolidated levels.
• CF_DATA_NOT_FOUNDFORMULA, CR_DATA_FOUNDFORMULA, and CM_DATA_NOT_FOUNDFORMULA — conditional format triggers that suppress or display sections depending on whether data exists for the functional, entered, and memo currencies.
• ORDER_BY_MEANINGFORMULA — supplies the ORDER BY clause used by the report's query.
• P_ACTUAL_AMOUNT_P, P_UNIDENTIFIED_AMOUNT_P, P_MISC_AMOUNT_P, P_NSF_AMOUNT_P — parameter/formula placeholders used to bind the actual, unidentified, miscellaneous, and NSF amounts into the report layout.

Tables Accessed

• AR_CASH_RECEIPTS — the primary transactional source; the report is a cash receipts deposit summary.
• AR_RECEIVABLE_APPLICATIONS — supplies applied and unapplied amounts used in difference and unapplied-amount formulas.
• CE_BANK_ACCOUNTS — resolves the bank account associated with each deposit.
• FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS_VL — used by REPORT_NAMEFORMULA to derive the program name from the request ID.
• DUAL — used for scalar expression evaluation.

Usage Notes

This package is not a public API. It is invoked exclusively by the ARXSOC2 XML Publisher concurrent program through the Oracle XML Publisher PL/SQL data model, which calls the lifecycle triggers and formula functions at runtime. The relevant parameter is P_CONC_REQUEST_ID, which ties the report instance to a concurrent request and enables the report-name lookup. Date parameters P_DATE_LOW and P_DATE_HIGH control the reporting period and are formatted for the message-based title.

Customization of this package is generally discouraged. Referencing it from other PL/SQL code is not supported, and because no other package in the ETRM inventory references it, any change is isolated to the report itself. The user search term "cr_type" corresponds to the cash receipt type attribute handled within the AR_CASH_RECEIPTS-driven query and the CR_* formula functions that render entered-currency data. A recompile is required after any modification, and the ARXSOC2 concurrent program definition must be resubmitted for the change to take effect.