Search Results rp_currency_code_p

Overview

FA_FAS930_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the standard Oracle Assets (FA) reporting infrastructure and functions as the XML Publisher (BI Publisher) report logic package for the FAS930 report — the Asset Additions report, also referenced as the Cost Additions and Adjustments report. In EBS 12.1.1 and 12.2.2, XML Publisher concurrent programs are implemented as a package that supplies data groups, prompts, and before/after report triggers to the underlying report definition. FA_FAS930_XMLP_PKG therefore provides the runtime PL/SQL hooks required to execute FAS930 through the concurrent manager, resolve its parameter values, and render the output through a layout template.

The package carries a VALID status in the ETRM, confirming it is compiled and present in a functioning environment. Its dependency list is minimal, referencing only SYS.STANDARD, which indicates the package body primarily orchestrates report-level logic and prompts rather than embedding complex standalone business rules.

Key Procedures and Functions

The ETRM documents eleven procedures and functions. They fall into three functional groupings:

• BEFOREREPORT — The report-level trigger executed before the data model runs. It initializes report state prior to query execution.
• AFTERREPORT — The report-level trigger executed after the data model completes, used for post-processing and cleanup.
• REPORT_NAMEFORMULA — Returns the report name used by the XML Publisher report definition, tying the package to its FAS930 template.
• ACCT_BAL_APROMPT_P, ACCT_CC_APROMPT_P — Prompt/parameter functions for accounting flexfield values, supplying the balancing and cost center account parameter values used as report selection criteria.
• CAT_MAJ_RPROMPT_P, RP_CAT_LPROMPT_P — Prompt functions for asset category, providing the major category range and the low (from) category value for the report parameter set.
• RP_COMPANY_NAME_P, RP_REPORT_NAME_P — Reporting attribute functions returning the company name and report name displayed in the report header.
• RP_BAL_LPROMPT_P — Prompt function for the balancing segment low value used in account selection.
• RP_CURRENCY_CODE_P — Returns the currency code applied to the report, ensuring monetary amounts are presented in the correct functional or reporting currency.

No parameter signatures are documented in the ETRM; the descriptions above reflect the naming conventions and standard roles of XML Publisher report packages.

Tables Accessed

The single documented table reference is FND_CONCURRENT_REQUESTS, accessed through an APPS synonym. This is the concurrent manager request table, and the package reads it to obtain the current request identifier and associated runtime parameters — the standard mechanism by which XML Publisher report packages inherit their parameter values from the concurrent program submission. The Asset Additions data itself is retrieved through the report's data model (the XML Publisher data template), not through direct table references in this package.

Usage Notes

FA_FAS930_XMLP_PKG is invoked indirectly, not called by custom code. It is bound to the FAS930 XML Publisher concurrent program and executes whenever that program is submitted — typically from the Assets responsibility under Reports, or through the standard request submission form. The ETRM records zero referencing packages, so it exposes no public API for external calls and should not be invoked directly from custom PL/SQL. Its dependency footprint (only SYS.STANDARD) means it is self-contained and unlikely to be affected by changes in other application packages, simplifying upgrade impact analysis across 12.1.1 and 12.2.2.