Search Results rp_report_name

Overview

APPS.FA_FAS828_XMLP_PKG is the PL/SQL package body that backs the Oracle E-Business Suite concurrent program "Delete Mass Additions Preview Report" (report code FAS828). As the "_XMLP_PKG" suffix indicates, this package is generated by the Oracle BI Publisher / XML Publisher integration layer for an Oracle Reports (RDF) or XML Publisher based report. Its primary business function is to gather and return the runtime attributes needed to render the report — most notably the report name, the ledger currency and its precision, the company name, and the feeder system — and to supply the standard BeforeReport and AfterReport event hooks that Oracle Reports invokes during execution.

The report supports the Fixed Assets mass additions cleanup process, giving users a preview listing of mass addition lines before they are deleted. Because the package is registered under the APPS schema and classified as "OTHER," it is treated as an internal, report-support utility rather than a formal public API. No other documented packages reference it, confirming that it exists solely to service its host concurrent program.

Key Procedures and Functions

• REPORT_NAMEFORMULA — Derives the displayable report name. It reads the concurrent request identified by P_CONC_REQUEST_ID (populated from fnd_global.CONC_REQUEST_ID during the DT fix) and joins to FND_CONCURRENT_PROGRAMS_VL to retrieve the user concurrent program name. The result is stored in RP_Report_Name and RP_REPORT_NAME, with the trailing " (XML)" token stripped before returning. An exception handler defaults the name to 'DELETE MASS ADDITIONS PREVIEW REPORT'.
• BEFOREREPORT — Standard Oracle Reports before-report trigger. In this package the original SRW user exit (FND SRWINIT) is commented out, and the function simply returns TRUE.
• AFTERREPORT — Standard after-report trigger. The FND SRWEXIT call is likewise commented out, and the function returns TRUE.
• CURRENCY_CODEFORMULA — Given a book (BOOK), it joins FA_BOOK_CONTROLS, GL_SETS_OF_BOOKS, and FND_CURRENCIES to return the ledger currency code and capture its precision into P_Min_Precision, which controls currency rounding in the report output.
• D_COSTFORMULA — Added during the DT fix; accepts FEEDER_SYSTEM and assigns it to RP_FEEDER_SYSTEM, exposing feeder system context to the report layout.
• RP_COMPANY_NAME_P, RP_REPORT_NAME_P, RP_FEEDER_SYSTEM_P — Placeholder / parameter assignment routines that back the corresponding report parameters (RP_Company_Name, RP_Report_Name, RP_FEEDER_SYSTEM) used by the XML Publisher template.

Tables Accessed

• FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS_VL — Read in REPORT_NAMEFORMULA to resolve the current request to its program definition and user-facing name.
• FA_BOOK_CONTROLS and GL_SETS_OF_BOOKS — Read in CURRENCY_CODEFORMULA to map a book type code to its associated set of books and currency.
• FND_CURRENCIES — Read to obtain the currency precision used for rounding monetary columns in the report.

Usage Notes

The package is not intended for direct invocation by application code. It is called automatically by the Oracle Reports/XML Publisher runtime when the FAS828 "Delete Mass Additions Preview Report" concurrent program is submitted. Its formula functions fire as report-level and data-model triggers, and the P_/RP_ global variables it sets are consumed by the report template. The DT fix commenting out the SRW user exits and initializing P_CONC_REQUEST_ID reflects adaptation to the XML Publisher processing model, where the FND request context is derived from fnd_global rather than SRW initialization. Customizations should avoid modifying the package body directly; instead, use a custom copy or template-level changes to preserve upgrade safety.