Search Results gain_lossformula

Overview

FA_FASMRET_XMLP_PKG is the PL/SQL package body associated with the Oracle Assets Asset Retirements Report (XML Publisher / BI Publisher concurrent program, short name FASMRET). It forms part of the Oracle E-Business Suite release 12.1.1 and 12.2.2 XML Publisher report infrastructure, residing in the APPS schema and classified as an "OTHER" API type. The package supplies the report-level and formula-level logic that the XML Publisher engine invokes during the report execution lifecycle. Principally it resolves the runtime report title, captures the concurrent request context, computes gain or loss on asset retirements, and exposes lexical parameter values used by the report template for the accounting flexfield, balancing segment, and category prompts.

Key Procedures and Functions

The documented package exposes nine procedures and functions:

• REPORT_NAMEFORMULA — Derives the display name of the running concurrent program. It queries FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS_VL for the current request, strips the " (XML)" suffix, and returns the program name. On failure it falls back to a default literal title.
• BEFOREREPORT — Executes prior to report generation. It retrieves the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID and parses ARGUMENT1 to extract the mass retirement identifier used as a report parameter.
• AFTERREPORT — Post-report hook returning TRUE; reserved for cleanup or post-processing logic.
• GAIN_LOSSFORMULA — Computes the retirement gain or loss from net book value, proceeds, removal cost, and revaluation reserve retirement.
• ACCT_BAL_APROMPT_P — Returns the balancing segment prompt value (ACCT_BAL_APROMPT) for the report parameter.
• ACCT_CC_APROMPT_P — Returns the cost center / accounting flexfield prompt value (ACCT_CC_APROMPT). This is the function referenced by the search term "acct_cc_aprompt_p".
• CAT_MAJ_RPROMPT_P — Returns the major category prompt value (CAT_MAJ_RPROMPT).
• RP_COMPANY_NAME_P — Returns the stored company name lexical parameter.
• RP_REPORT_NAME_P — Returns the stored report name lexical parameter.

Tables Accessed

The package reads from FND_CONCURRENT_REQUESTS (via its APPS synonym) to obtain the concurrent program ID, the request ID, and the concatenated ARGUMENT1 string containing the mass retirement parameter. It further joins FND_CONCURRENT_PROGRAMS_VL to resolve the user-facing concurrent program name. No INSERT, UPDATE, or DELETE operations are documented, so the package is read-only against the concurrent manager data model. It does not access Oracle Assets base tables directly; retirement data is supplied by the report query associated with the concurrent program rather than through this package.

Usage Notes

FA_FASMRET_XMLP_PKG is invoked exclusively by the Oracle Assets Asset Retirements Report concurrent program and its XML Publisher template. BEFOREREPORT and AFTERREPORT are automatically called by the XML Publisher runtime at the appropriate execution phases; the *_P functions are bound as lexical or formula parameters in the RTF template to render prompt values; GAIN_LOSSFORMULA is referenced by the template to calculate gains and losses row by row. Custom code should not call these functions directly, as their inputs assume the concurrent request context established by BEFOREREPORT. The package is referenced by zero other packages, confirming it is a leaf-level report utility intended for report generation rather than reuse across modules.