Search Results diff_deprnformula

Overview

APPS.FA_FASAAMTS_XMLP_PKG is a report-support PL/SQL package associated with the Oracle Assets (FA) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name follows the standard XML Publisher report package convention, in which a report definition file (in this case the FASAAMTS report) is paired with a generated package that holds global report parameters, formula functions, and report-level event handlers. The package exists to provide the procedural scaffolding that the XML Publisher engine invokes at runtime: it declares bind parameters populated from concurrent program parameters, exposes derived period and fiscal-year values used by the report layout, and supplies calculation formulas for depreciation amounts reported at the book level.

The report itself presents asset amounts in a comparative format, contrasting a federal book against an AMT (alternative minimum tax) book over a defined accounting period. The package's structure reflects that purpose, carrying separate global variables for the federal book, the AMT book, the report period, account ranges, and adjusted flags, along with derived period start/end and fiscal-year values.

Key Procedures and Functions

The package exposes seventeen documented functions, all scoped to XML Publisher report generation rather than to general application programming. They fall into four functional groups.

• Report lifecycle handlers — BeforeReport and AfterReport execute at the boundaries of report execution, performing setup and teardown logic for the run.
• Parameter and formula functions — report_nameformula, Period1_PCFormula, and FED_START_PERIOD_PCFormula derive display values from the company name and period inputs at runtime.
• Depreciation amount formulas — diff_deprnformula computes the difference between the federal and AMT depreciation figures; amt_deprnformula derives the AMT depreciation from the AMT depreciation detail and adjustment values; and fed_deprnformula performs the parallel calculation for the federal book. The user search term "diff_deprnformula" corresponds directly to the first of these.
• Accessor functions — the suffixed _p functions (Period1_POD_p, Period1_PCD_p, Period1_FY_p, FED_END_PERIOD_PC_p, AMT_START_PERIOD_PC_p, AMT_END_PERIOD_PC_p, RP_COMPANY_NAME_p, RP_REPORT_NAME_p, and RP_BAL_LPROMPT_p) return the current values of the package's global variables to the report template. RP_BAL_LPROMPT_p is notable for accepting an account balance prompt argument, allowing the prompt label to be resolved dynamically from the account context.

Tables Accessed

The package accesses two documented tables through APPS synonyms. FA_DEPRN_PERIODS is read to resolve the accounting period boundaries and fiscal-year attributes used by the period accessor and formula functions — specifically the period open and close dates and the corresponding fiscal year. FND_CONCURRENT_REQUESTS is referenced to obtain the concurrent request identifier and related execution context for the report run, which the package captures in the P_CONC_REQUEST_ID global. No insert, update, or delete operations against application data are documented; the package is read-only with respect to assets data.

Usage Notes

FA_FASAAMTS_XMLP_PKG is not a general-purpose API and is not referenced by any other package. It is invoked exclusively by the XML Publisher runtime when the associated FASAAMTS concurrent program executes. Because all entry points are formula or event handlers evaluated by the report engine, the package should be treated as internal report infrastructure. Customizations to depreciation comparison logic on this report are normally implemented through the report definition or by copying and extending the concurrent program rather than by modifying this package directly, since it is regenerated from the report definition and carries a shipped header revision.