Search Results rp_currency_code

Overview

FA_FAS930_XMLP_PKG is a generated Oracle Reports PL/SQL package body owned by APPS in Oracle E-Business Suite 12.1.1 and 12.2.2. It supports the XML Publisher (XMLP) version of the Leased Assets Report, a Fixed Assets reporting program identified by the concurrent program ID 140 (the Fixed Assets application). Because the object resides in the APPS schema and is classified as OTHER rather than as a published API, it is intended primarily as an internal implementation artifact consumed by the report definition rather than by external integrations. The package encapsulates the report's global variables (placeholders such as company name, report name, and the currency code) and exposes accessor functions that the Oracle Reports runtime invokes to resolve these values during execution.

Key Procedures and Functions

The package exposes eleven documented procedures and functions. The REPORT_NAMEFORMULA function is the central piece of logic: it accepts the company name and currency code, assigns them to the RP_COMPANY_NAME and RP_CURRENCY_CODE placeholders, and derives the report title by querying the concurrent program definition associated with the current request. It returns the trimmed report name and falls back to ':Leased Assets Report:' when the lookup fails. BEFOREREPORT initializes the P_CONC_REQUEST_ID from the FND_GLOBAL package before the report layout executes, while AFTERREPORT provides the corresponding post-execution hook. The remaining functions—ACCT_BAL_APROMPT_P, ACCT_CC_APROMPT_P, CAT_MAJ_RPROMPT_P, RP_COMPANY_NAME_P, RP_REPORT_NAME_P, RP_BAL_LPROMPT_P, RP_CAT_LPROMPT_P, and RP_CURRENCY_CODE_P—are lightweight accessors that return the current values of report placeholders (account balance and cost center prompts, category major and category prompts, company name, report name, and the requested currency code). These accessors exist because Oracle Reports requires a function interface to reference package-level placeholders within the report layout.

Tables Accessed

The package reads from a single documented table, FND_CONCURRENT_REQUESTS (accessed through its APPS synonym), to resolve the concurrent_program_id for the running request identified by P_CONC_REQUEST_ID. It also queries FND_CONCURRENT_PROGRAMS_VL to retrieve the user-facing concurrent program name, which is truncated at the ' (XML)' marker to produce the display title. Both queries are restricted to application_id 140, the Fixed Assets application. No writes to any table are documented.

Usage Notes

FA_FAS930_XMLP_PKG is invoked exclusively by the XML Publisher Leased Assets Report concurrent program; it is referenced by no other database package, confirming its role as a report-dedicated artifact. The RP_CURRENCY_CODE_P accessor is directly relevant to the search term "rp_currency_code": it returns the currency value captured by REPORT_NAMEFORMULA, which callers supply at report submission time. Because the package body is regenerated from the Oracle Reports source (FAS930B.pls), any customization should be performed through the report definition or a supported extension mechanism rather than by editing the generated code, as regeneration will overwrite manual changes. It should not be called directly from custom forms or concurrent programs.