Search Results c_status_summary_labelformula

Overview

APPS.AR_ARXASR_XMLP_PKG is a generated PL/SQL package that supports the Oracle Receivables Account Status Report, a concurrent program delivered through the Oracle XML Publisher (BI Publisher) reporting framework. The package is declared with AUTHID CURRENT_USER and forms part of the standard Oracle E-Business Suite Receivables module as shipped in releases 12.1.1 and 12.2.2. Its principal role is to serve as the report-level database package that supplies parameter values, session context, and layout metadata to the XML Publisher template associated with the Account Status Report, rather than to encapsulate reusable business logic. It is classified as OTHER in the ETRM metadata, indicating that it is not published as a public API and is not intended for direct invocation by external code.

The package exposes a set of user-facing report parameters that correspond directly to the Account Status Report submission form, including customer number and name ranges, collector name ranges, order-by selection, set of books identifier, and start and end account status values. Alongside these, numerous internal variables prefixed with lp_ and p_ hold formatted display strings and table-name aliases used by the report's SQL definitions during execution.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions within the package. BEFOREREPORT and AFTERREPORT are the standard XML Publisher report lifecycle hooks invoked at the start and conclusion of report execution, used to initialize session-dependent values and to clean up afterward. AFTERPFORM executes after the report parameter form has been processed, allowing the package to adjust derived parameter values. REPORT_NAMEFORMULA returns the display name of the report for placement in the report header.

Several members follow the XML Publisher formula-naming convention. C_STATUS_SUMMARY_LABELFORMULA supplies the descriptive label rendered for the account status summary column in the report output, and is the member most commonly matched by searches for the identifier c_status_summary_labelformula. C_DATA_NOT_FOUNDFORMULA returns the message displayed when the report query yields no rows. The remaining members are hidden report parameters: RP_COMPANY_NAME_P supplies the legal entity or organization name, RP_REPORT_NAME_P supplies the report title, RP_DATA_FOUND_P indicates whether qualifying data exists, and RPD_REPORT_SUMMARY_P provides the consolidated report summary string. No parameter lists are documented for these members, and callers should not assume fixed signatures.

Tables Accessed

The only table identified through APPS synonyms in the metadata is FND_CONCURRENT_REQUESTS. The package reads this table to resolve the concurrent request identifier passed in P_CONC_REQUEST_ID, thereby recovering request-level attributes such as the submitting user, request date, and parameter context required for report header generation and session initialization. No other base tables or views are documented as direct dependencies, although the report's underlying query definitions reference the broader Receivables transaction, payment schedule, adjustment, and cash receipt tables indirectly through the lp_ alias variables declared in the package specification.

Usage Notes

AR_ARXASR_XMLP_PKG is invoked indirectly by the Oracle Receivables Account Status Report concurrent program and its associated XML Publisher template. It is not referenced by any other documented package, and the metadata records zero inbound package references, confirming that it is a terminal integration point. Customizations should not modify package body logic, since the package is regenerated during patching and upgrade. Organizations requiring additional report columns or alternate labels should instead copy the concurrent program and XML template and extend the formula members in a custom package, ensuring that the standard AR_ARXASR_XMLP_PKG remains intact across the 12.1.1 to 12.2.2 upgrade path.