Search Results c_currency_summary_labelformul

Overview

APPS.AR_ARXCTA_XMLP_PKG is the generated PL/SQL package that backs the Oracle Receivables XML Publisher (BI Publisher) report commonly identified as the "Adjustment / Account Balance" style concurrent report, sourced from the file ARXCTAS.pls. In Oracle EBS 12.1.1 and 12.2.2, Oracle Reports and XML Publisher concurrent programs are implemented as a package specification plus body that declare global variables, define report-level formulas and triggers, and expose the BeforeReport and AfterReport entry points consumed by the report runtime. The package is compiled with AUTHID CURRENT_USER, meaning it executes under the privileges of the invoking user rather than the definer, so it relies on APPS synonyms and grants to reach FND_CONCURRENT_REQUESTS and other objects.

The package primarily serves as the parameter and layout driver for the report: it declares the concurrent program's input parameters (for example P_ORDER_BY, P_ADJUSTMENT_NAME_LOW/HIGH, P_CUSTOMER_NAME_LOW/HIGH, P_GL_DATE_LOW/HIGH, P_INVOICE_LOW/HIGH, P_INVOICE_TYPE_LOW/HIGH, P_STATUS_LOW/HIGH, P_CURR_CODE, and P_CONC_REQUEST_ID) and the report's placeholder variables (RP_ and lp_ prefixed globals) used to format parameter summaries and grand totals on the output. It performs no core subledger accounting logic; that work is done by the report query itself.

Key Procedures and Functions

The 24 documented units fall into two groups. Report lifecycle trigger functions include BEFOREREPORT and AFTERREPORT, which run before and after report execution, and AFTERPFORM, which executes after the parameter form is submitted. The remainder are formula columns and helper routines referenced from the report layout or parameter defaults:

• CURRENCY_SUMMARY_LABELFORMULA, recorded as C_CURRENCY_SUMMARY_LABELFORMUL — the formula the user searched for; it generates the currency summary label text shown on the report output.
• C_STATUS_SUMMARY_LABELFORMULA, C_NAME_SUMMARY_LABELFORMULA, C_CREATOR_LABELFORMULA, C_GRAND_TOTAL_LABELFORMULA — build descriptive labels for status, customer name, creator, and grand total sections.
• C_ORDER_BYFORMULA and C_DATA_NOT_FOUNDFORMULA — assemble the order-by clause text and the message displayed when no rows are returned.
• REPORT_NAMEFORMULA — returns the report's display name.
• Placeholder assignment routines: ACCT_BAL_APROMPT_P, RP_COMPANY_NAME_P, RP_REPORT_NAME_P, RP_DATA_FOUND_P, RP_GL_DATE_P, RP_ORDER_BY_P, RP_FUNC_CURRENCY_P, P_MEANING_P, RP_TOTAL_P — each populates the corresponding global used by the layout.

Eight additional procedures/functions are documented in the metadata but not individually named in the excerpt; their names follow the same formula/placeholder convention.

Tables Accessed

Via APPS synonyms, the package references FND_CONCURRENT_REQUESTS. This is the standard mechanism for resolving the concurrent request identifier (P_CONC_REQUEST_ID) and for retrieving request context and completion information needed by report triggers and the AfterReport routine. No Receivables transaction tables are accessed by the package itself; invoice, adjustment, customer, and GL data are retrieved by the report's SQL query, not by this package.

Usage Notes

This package is invoked indirectly whenever the associated concurrent program runs — either from the Standard Request Submission or Submit Request window, from the XML Publisher / Oracle Reports runtime launched by the concurrent manager, or programmatically through FND_REQUEST.SUBMIT_REQUEST. It is not intended for direct call from forms or custom code, and the metadata indicates it is referenced by zero other packages. Customizations should avoid modifying AR_ARXCTA_XMLP_PKG directly, because Oracle regeneration of the report definition can overwrite the specification and body; instead, custom labels and formatting should be applied through XML Publisher templates or the report's own query. The C_CURRENCY_SUMMARY_LABELFORMULA is the specific unit responsible for the currency summary caption referenced by the user's search term.