Search Results g_setupgroupfilter

Overview

APPS.FA_FASRSVES_XMLP_PKG is the database-side PL/SQL package generated to support the Oracle Assets Reserve and Depreciation report executed through the Oracle E-Business Suite concurrent manager and rendered as XML Publisher (BI Publisher) output. In the EBS 12.1.1 and 12.2.2 releases, reports historically developed with Oracle Reports are wrapped in a package that exposes the report's user parameters as package globals, its data model queries as internal SQL, and its report-level triggers and formulas as PL/SQL functions. FA_FASRSVES_XMLP_PKG follows this pattern: it declares bind variables such as P_BOOK, P_PERIOD1, P_PERIOD2, P_REPORT_TYPE, P_ADJ_MODE, P_MIN_PRECISION and P_CONC_REQUEST_ID, together with derived variables for the accounting period dates (POD, PCD), fiscal year, set of books, organization identifier and multi-reporting-currencies sob type.

The package therefore serves as the executable engine for the Reserve Summary report across the distribution source book. It is the object that the concurrent program FA_FASRSVES_XMLP is bound to, and it drives period-to-period asset balance, depreciation reserve and cost roll-forward calculations by source book, distribution source book, category and account.

Key Procedures and Functions

The 36 documented program units fall into three groups. The first group contains report lifecycle hooks: BEFOREREPORT executes setup logic and populates the global variables before the query runs, while AFTERREPORT performs cleanup and returns control to the concurrent manager. AFTERPFORM and G_SETUPGROUPFILTER support the report parameter form and group filtering respectively.

The second group contains lexical and derived-value formulas. REPORT_NAMEFORMULA returns the dynamic title of the report. PERIOD1_PCFORMULA and PERIOD2_PCFormula derive the period counters, and ADJUSTFORMULA and REVAL_TAX_FLAGFORMULA resolve report flags. The _P suffix functions — ACCT_BAL_APROMPT_P, ACCT_CC_APROMPT_P, CAT_MAJ_RPROMPT_P, PERIOD1_POD_P, PERIOD1_PCD_P, PERIOD1_FY_P and their period-two counterparts — are the PL/SQL ports of the Oracle Reports format triggers that populate the displayed prompts and period dates.

The third group contains the balance-validation formulas. OUT_OF_BALANCEFORMULA, ACCT_OUT_OF_BALANCEFORMULA, BAL_OUT_OF_BALANCEFORMULA and RP_OUT_OF_BALANCEFORMULA each compare the opening balance plus additions, depreciation, reclassifications, retirements, adjustments and transfers against the closing balance, returning an indicator when the roll-forward does not reconcile. DO_INSERTFORMULA controls insertion of rows into the report's summary structures. This set of checks is central to the auditability of the report since it flags assets that fail the cost or reserve reconciliation test.

Tables Accessed

The package reads the core Oracle Assets book and control tables: FA_BOOKS, FA_BOOKS_GROUPS and FA_BOOK_CONTROLS supply the distribution source book and report book definitions and the depreciation rules for the selected period. FA_DEPRN_PERIODS provides the period open and close dates. FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL supply the period depreciation, cost and reserve amounts. FA_BALANCES_REPORT_GT is the global temporary table into which intermediate balance rows are inserted and subsequently summarised.

FA_ADJUSTMENTS, FA_ASSET_HISTORY and FA_DISTRIBUTION_HISTORY provide the transaction and assignment history used in the roll-forward and in the distribution source book comparison. FA_CATEGORY_BOOKS and the group asset tables FA_GROUP_ASSET_DEFAULT and FA_GROUP_ASSET_RULES supply the asset category and grouping defaults. FA_LOOKUPS and FA_LOOKUPS_B resolve the lookup code meanings displayed in the report output.

Usage Notes

FA_FASRSVES_XMLP_PKG is normally invoked indirectly. The Oracle Assets responsibility submits the Reserve Summary concurrent program, which supplies P_BOOK, P_PERIOD1, P_PERIOD2, P_REPORT_TYPE and P_ADJ_MODE from the parameter window and P_CONC_REQUEST_ID from the concurrent manager. The package entry point BEFOREREPORT then populates the globals, the data model executes its SELECT statements against the tables listed above, and AFTERREPORT releases resources.

Because the package is marked with an API classification of OTHER and is referenced by no other packages, it should not be called directly from custom code. Modifying its contents invalidates the supported report definition, and patches to the Oracle Assets report or to the XML Publisher template may regenerate the package. Custom reporting requirements that need the distribution source book data are better served by querying FA_BOOKS, FA_DEPRN_SUMMARY and FA_DISTRIBUTION_HISTORY directly, or by using the public Oracle Assets report APIs rather than reusing this private, generated package body.