Search Results p_mrcsobtype

Overview

The APPS.FA_FAS840_XMLP_PKG package body is the supporting PL/SQL package for the Oracle E-Business Suite Fixed Assets report FAS840. Under the Oracle ETRM classification it is registered as an OTHER API owned by APPS. Its role is to supply the runtime values and helper logic needed by the Oracle Reports XML Publisher (XMLP) concurrent report that produces the FAS840 Fixed Assets output. The package does not expose a general-purpose business API; instead it provides formula columns, report-level triggers, and package-level variables that the report definition references during execution. A defining characteristic of this package is its handling of the p_mrcsobtype parameter, which distinguishes a Multiple Reporting Currency (MRC) reporting set of books (value 'R') from a primary/standard set of books. Almost every formula function branches on this value to choose between MRC views such as FA_BOOK_CONTROLS_MRC_V and FA_DEPRN_PERIODS_MRC_V and their non-MRC counterparts. The header indicates it was last shipped at version 120.0.12010000.1 (2008), consistent with the 12.1.1 and 12.2.2 file system and online patching model.

Key Procedures and Functions

ETRM documents 14 procedures and functions within the body:

• BOOKFORMULA — resolves the book context (book type code, accounting flexfield structure, distribution source book, currency code, and precision) from FA_BOOK_CONTROLS or FA_BOOK_CONTROLS_MRC_V, and populates package variables used elsewhere in the report.
• PERIOD1FORMULA and PERIOD2FORMULA — return the period name and period counter for the reporting period(s) requested by the report, switching between FA_DEPRN_PERIODS and FA_DEPRN_PERIODS_MRC_V based on p_mrcsobtype.
• REPORT_NAMEFORMULA — derives the report name (exposed through RP_REPORT_NAME_P) used for the XML Publisher output.
• BEFOREREPORT and AFTERREPORT — report-level triggers that perform initialization before data retrieval and cleanup/finalization after report completion.
• AFTERPFORM — a report trigger executed after the report's parameter form or parameter processing, used to finalize parameter-dependent setup.
• PRECISION_P, ACCOUNTING_FLEX_STRUCTURE_P, CURRENCY_CODE_P, DISTRIBUTION_SOURCE_BOOK_P, PERIOD1_PC_P, PERIOD2_PC_P, RP_REPORT_NAME_P — package-level functions that expose the corresponding package variables (precision, accounting flexfield structure, currency code, distribution source book, period 1 and period 2 period counters, and report name) to the report layout.

Tables Accessed

The package reads from several Fixed Assets and shared reference tables via APPS synonyms:

• FA_BOOK_CONTROLS and its MRC view FA_BOOK_CONTROLS_MRC_V — source of book definition attributes, flexfield structure, and distribution source book.
• FA_DEPRN_PERIODS and the MRC view FA_DEPRN_PERIODS_MRC_V — source of period name and period counter for the requested depreciation periods.
• FND_CURRENCIES — supplies the currency precision for the reporting set of books.
• FND_CONCURRENT_REQUESTS — used to associate report output with the concurrent request context.

Usage Notes

This package is invoked indirectly: it is bound to the FAS840 report definition and executed by the Oracle Reports/XML Publisher runtime when the FAS840 concurrent program is submitted. It is not called by other packaged procedures; ETRM records zero referencing packages. Customizations should avoid modifying the shipped body directly, since the header identifies it as an APPLDEV-shipped file; extensions should be layered through report template changes or a custom copy. The p_mrcsobtype parameter is the primary behavioral switch and must be supplied consistently so that the correct MRC or non-MRC views are queried.