Search Results ar_arxsoc2_xmlp_pkg




Overview
Explore in AI Chat

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.

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.