Search Results acct_cc_aprompt

Overview

FA_FAS822_XMLP_PKG is the generated PL/SQL package that backs the Oracle Assets report FAS822 (Asset Additions and Retirements / CIP-related asset reporting, depending on installation). The package is owned by APPS and is classified as OTHER, meaning Oracle does not treat it as a public API; it exists primarily to support the XML Publisher concurrent program that shares its name. In Oracle EBS 12.1.1 and 12.2.2 the package is compiled with AUTHID CURRENT_USER, so all unqualified references resolve through the schema of the calling session, which in practice is APPS.

The specification declares the report's bind and lexical parameters (P_BOOK, P_CONC_REQUEST_ID, P_MIN_PRECISION) alongside a set of prompt variables and return-value functions. The package therefore acts as the data-source contract between the concurrent manager and the XML Publisher template: the concurrent program invokes it, the functions populate the report's parameter and prompt values, and the template consumes the result. The user search term "acct_cc_aprompt" maps directly to the ACCT_CC_APROMPT variable, the accounting cost-center prompt that the report exposes to the runtime template.

Key Procedures and Functions

• BEFOREREPORT — Oracle Reports style before-report trigger, used to initialise report state and derive prompt values before the data model runs.
• AFTERREPORT — Post-report trigger, used for cleanup and completion handling once the report content has been produced.
• REPORT_NAMEFORMULA — Derives the formatted report name/heading from the company name input, so the printed output carries the correct title block.
• ACCT_BAL_APROMPT_P — Returns the value of the ACCT_BAL_APROMPT prompt (the "from" accounting flexfield / balancing segment prompt shown on the report).
• ACCT_CC_APROMPT_P — Returns ACCT_CC_APROMPT, the accounting cost-center prompt parameter; this is the function associated with the user's search term "acct_cc_aprompt".
• CAT_MAJ_RPROMPT_P — Returns CAT_MAJ_RPROMPT, the major asset category prompt.
• RP_COMPANY_NAME_P — Returns the company name used in the report header.
• RP_REPORT_NAME_P — Returns the report name populated by REPORT_NAMEFORMULA.

Tables Accessed

The documented dependency list contains a single table, FND_CONCURRENT_REQUESTS, accessed through an APPS synonym. The package reads this table primarily to resolve P_CONC_REQUEST_ID — the concurrent request identifier — so that request-specific context (such as the reporting book and ledger) can be retrieved and so that the report can log or query its own request status. No other base tables are recorded in the ETRM metadata; the asset and accounting data itself is fetched by the underlying XML Publisher data definition rather than by this package.

Usage Notes

FA_FAS822_XMLP_PKG is not intended for direct invocation by custom code. It is called by the concurrent manager when the FAS822 XML Publisher report is submitted from the Assets responsibility, or programmatically when the report is launched through the standard concurrent program APIs with the correct request ID. Because the package is generated and version-stamped (the header records FAS822S.pls), customers should not modify it; any change to prompt labels or derived values should be made through the report template or by extending the package in a supported way. The package is referenced by zero other packages according to the ETRM dependency data, confirming that its role is confined to the concurrent reporting layer. Developers troubleshooting an "acct_cc_aprompt" issue should verify that the reporting book and cost-center parameters passed to the concurrent request are valid, since ACCT_CC_APROMPT ultimately reflects those request parameters rather than a database lookup.