Search Results report_nameformula

Overview

APPS.FA_FAS822_XMLP_PKG is the generated PL/SQL package body that supports the Oracle E-Business Suite Fixed Assets report identified by concurrent program application identifier 140 — the Mass Additions Create Report (FAS822). The package follows the standard Oracle Reports XML Publisher (XMLP) integration pattern used throughout EBS 12.1.1 and 12.2.2, in which a package encapsulates the report's user-facing parameters, exposes them as PL/SQL functions, and supplies boilerplate report-level triggers. Its header comment ($Header: FAS822B.pls 120.0.12010000.1 2008/07/28 ... ship $) confirms it is a shipped Oracle file, not a customer extension.

The principal business value of this object is the dynamic derivation of the report title that appears on the Mass Additions Create Report output. Rather than hard-coding the title, the package resolves the concurrent program name at runtime from the EBS concurrent manager tables, strips the XML Publisher suffix, and passes the cleaned string back to the report layout.

Key Procedures and Functions

• REPORT_NAMEFORMULA — The core function, and the object a user locates when searching on "report_nameformula." It accepts the company name as an input, stores it in the package variable RP_COMPANY_NAME, resolves the concurrent program identifier for the current request, looks up the user-facing program name, truncates everything from the literal " (XML)" onward, and returns the resulting title. It writes the result to RP_REPORT_NAME and wraps all logic in a WHEN OTHERS handler that falls back to the literal ':Mass Additions Create Report:', ensuring the report never fails solely because the title could not be resolved.
• BEFOREREPORT — Report-level BeforeReport trigger. It populates P_CONC_REQUEST_ID from FND_GLOBAL.CONC_REQUEST_ID so that downstream queries and REPORT_NAMEFORMULA can identify the executing concurrent request. Returns TRUE.
• AFTERREPORT — Report-level AfterReport trigger; a stub that returns TRUE, present to satisfy the XMLP package contract.
• ACCT_BAL_APROMPT_P — Parameter accessor that returns the accounting balance low/high range prompt value.
• ACCT_CC_APROMPT_P — Parameter accessor that returns the accounting cost center low/high range prompt value.
• CAT_MAJ_RPROMPT_P — Parameter accessor that returns the major category range prompt value.
• RP_COMPANY_NAME_P — Returns the stored RP_COMPANY_NAME package variable for use in the report layout.
• RP_REPORT_NAME_P — Returns the stored RP_REPORT_NAME package variable, i.e. the resolved report title.

Tables Accessed

The package reads from the FND_CONCURRENT_REQUESTS table (accessed through the APPS synonym) to obtain the CONCURRENT_PROGRAM_ID of the currently executing request, filtered by PROGRAM_APPLICATION_ID = 140 and the session's P_CONC_REQUEST_ID. It then queries FND_CONCURRENT_PROGRAMS_VL to translate that identifier into the user-facing concurrent program name used to build the report title. As a generated XMLP support package, it performs no inserts, updates, or deletes and does not touch Fixed Assets transaction tables directly; all business data retrieval is handled elsewhere in the report definition.

Usage Notes

This package is invoked automatically by the Oracle Reports runtime when the FAS822 Mass Additions Create Report concurrent program executes. It is not intended for direct invocation by forms, custom concurrent programs, or ad hoc SQL. The parameter accessor functions (ACCT_BAL_APROMPT_P, ACCT_CC_APROMPT_P, CAT_MAJ_RPROMPT_P) exist purely to expose report parameters to the XML Publisher template. Because it is a shipped object, it should not be modified; any required change to the report title behavior would be delivered through a patch or, in exceptional cases, by cloning the report and its package under a customer-owned name.