Search Results meth_per_add_budformula
Overview
FA_FASCAPSP_XMLP_PKG is an Oracle E-Business Suite package owned by the APPS schema and classified as OTHER within the ETRM metadata model. It serves as the PL/SQL implementation backing for the FA_FASCAPSP XML Publisher concurrent report, which corresponds to the Capitalization Summary report in Oracle Assets (Fixed Assets). The package is not a standalone business API; rather, it is a generated XML Publisher package whose public and private members exist to supply runtime variables, computed formula columns, and report lifecycle hooks to the BI Publisher data template associated with the concurrent program.
The package header carries the version marker FASCAPSPS.pls 120.1, dated 2009, and is declared with AUTHID CURRENT_USER, meaning execution privileges resolve against the invoking schema rather than the defining schema. This is the standard pattern for Oracle's seeded XML Publisher packages, where the APPS user or a submitted concurrent request session must possess the necessary object privileges on the underlying FA tables.
The presence of the string "end_date_p" in the user's search reflects the naming convention used for bind and prompt variables in these generated packages. END_DATE is declared as a DATE variable at package scope, while END_DATE_P is the accessor function that returns its value to the report layout.
Key Procedures and Functions
The package exposes 18 documented procedures and functions. The lifecycle procedures are BEFOREREPORT and AFTERREPORT, which execute before and after the report data fetch respectively; these are the standard Oracle Reports/XML Publisher triggers used to initialize globals and perform session-level setup or cleanup.
The remaining functions fall into two categories. The first group consists of accessor functions ending in _P, which expose package-level variables to the report template: END_DATE_P returns the date prompting value that bounds the capitalization summary; FISCAL_YEAR_P returns the fiscal year number; ACCT_BAL_APROMPT_P, ACCT_CC_APROMPT_P, CAT_MAJ_RPROMPT_P, and RP_BAL_LPROMPT_P return the concatenated prompt strings used in the report heading to describe the accounting book, cost center, major category, and balance selections; and RP_COMPANY_NAME_P, RP_REPORT_NAME_P return the company and report display names.
The second group comprises computation functions used for summary and comparison rows in the capitalization report: PERIOD_NUMFORMULA, REPORT_NAMEFORMULA, PER_ADD_BEFOREFORMULA, PER_BUD_BEFOREFORMULA, PER_ADD_BUDFORMULA, METH_PER_ADD_BEFOREFORMULA, METH_PER_BUD_BEFOREFORMULA, and METH_PER_ADD_BUDFORMULA. These functions aggregate additions and budgeted additions by period and by depreciation method, formatting the results for presentation.
Tables Accessed
The package references four documented tables through APPS synonyms. FA_BOOK_CONTROLS supplies book-level parameters such as the depreciation calendar and the current open period. FA_DEPRN_PERIODS provides the period status and period number mapping required to align the report to the selected fiscal period. FA_FISCAL_YEAR resolves fiscal year definitions used by FISCAL_YEAR_P. FND_CONCURRENT_REQUESTS is queried against P_CONC_REQUEST_ID to retrieve concurrent request context information, a common requirement for XML Publisher reports to obtain submission parameters and output attributes.
Usage Notes
FA_FASCAPSP_XMLP_PKG is invoked exclusively through the Oracle Assets concurrent program for the Capitalization Summary report. It is not referenced by any other package, as confirmed by the ETRM metadata. Customers and consultants should treat this object as seeded and non-extensible: modifications alter report behavior and are overwritten by patching. The END_DATE_P accessor in particular reflects the report's date-bounded data selection and mirrors the concurrent program parameter of the same conceptual name; custom report variants should copy this package rather than modify the seeded definition.