Search Results do_insertformula

Overview

FA_FASMAINT_XMLP_PKG is the generated PL/SQL package associated with the Oracle Assets concurrent program "Asset Maintenance," published under the XML Publisher (BI Publisher) report definition FASMAINT. The package encapsulates the server-side logic required to run the maintenance report within the Oracle E-Business Suite environment, and is stored under the APPS schema with AUTHID CURRENT_USER. Its primary business purpose is to produce a formatted listing of asset maintenance events across a specified book and date range, allowing fixed asset managers and accountants to review additions, adjustments, retirements, transfers, and reclassifications in a controlled reporting window.

The package declares a block of global variables that mirror the report's concurrent program parameters — maintenance date ranges, asset number ranges, DPIS (date placed in service) ranges, category identifiers, book name, and event name. Two of these are exposed as conversion functions for the XML Publisher data template, and one, C_REQUEST_ID, is initialized to a literal value, providing a fallback request identifier for downstream queries. The header comment indicates the source was last shipped in release 120.1, consistent with the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

• GET_CURRENCY_CODE — Retrieves the functional currency code associated with the specified book, populating the C_currency_code variable used by the report layout.
• RAISE_ORA_ERR — A utility that raises a standardized Oracle error, allowing the report to fail gracefully with a meaningful message when validation or fetch logic encounters a problem.
• BEFOREREPORT — Executes prior to report output generation. It performs setup tasks such as deriving the currency code and preparing parameter-driven context for the query.
• AFTERREPORT — Executes after report production completes, typically used for cleanup or final status handling.
• RP_COMPANY_NAMEFormula — Supplies the company (legal entity) name to the report template, drawing from system configuration data.
• C_CURRENCY_CODE_P — An accessor function returning the currency code value to the XML Publisher data engine.
• C_REQUEST_ID_P — An accessor function returning the request identifier, allowing the report's SQL to correlate output with the concurrent request that spawned it.
• DO_INSERTFORMULA — An added helper, marked in the source as "added," which performs an insert operation, generally into the maintenance reporting interface table, to stage or record report data.

Tables Accessed

• FA_BOOK_CONTROLS — Provides book-level attributes, including the functional currency, which drives GET_CURRENCY_CODE and the report's monetary formatting.
• FA_MAINT_REP_ITF — The Asset Maintenance reporting interface table, used to stage or retrieve the maintenance event rows that form the body of the report.
• FA_SYSTEM_CONTROLS — Supplies system-wide defaults and organization-level settings referenced during report initialization.
• FND_CURRENCIES — Supplies currency descriptive information, joined to the book currency for display purposes.

All tables are referenced through APPS synonyms rather than owner-qualified names, which is standard for a report package executing under APPS with AUTHID CURRENT_USER.

Usage Notes

FA_FASMAINT_XMLP_PKG is invoked indirectly by the Oracle Assets "Asset Maintenance" concurrent program when the FASMAINT XML Publisher report is submitted. The concurrent manager calls the report executable, which in turn drives the BeforeReport and AfterReport entry points and supplies the parameter values assigned to the package globals. The C_REQUEST_ID_P and C_CURRENCY_CODE_P functions are called by the associated XML Publisher data template rather than by application forms, so any report customizations that reference these accessors must preserve their signatur