Search Results fa_fas444_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.FA_FAS444_XMLP_PKG package body implements the server-side PL/SQL logic for the Oracle E-Business Suite Fixed Assets report known internally as FAS444, distributed as an XML Publisher (BI Publisher) concurrent program. The package is owned by the APPS schema and carries a VALID status in both Oracle EBS 12.1.1 and 12.2.2. Its primary business purpose is to compute and supply period-level depreciation balances and accounting period context to an XML Publisher report template, allowing users to compare asset balances between two accounting periods for a selected depreciation book. It is classified as an OTHER API, indicating that it is a report-supporting package rather than a public, callable business API, and it is referenced by no other database object, confirming that its scope is limited to its own concurrent program.

Key Procedures and Functions

The ETRM metadata documents fifteen procedures and functions within this package body. The temporal parameters are exposed through a structured set of prompt and formula routines:

The paired Period1/Period2 routines mirror one another, which reflects the report's two-column comparative design. No parameter lists are documented in ETRM and none should be assumed.

Tables Accessed

Dependency metadata identifies two application tables read through APPS synonyms:

  • FA_DEPRN_PERIODS — the Fixed Assets depreciation period calendar. The package reads this table to obtain period open and close dates, fiscal year designations, and to validate the two periods chosen by the user at runtime. All PERIOD1_* and PERIOD2_* routines depend on this table, as do the period-column formulas.
  • FND_CONCURRENT_REQUESTS — the concurrent manager request table, accessed to resolve request-specific runtime context such as the concurrent request identifier used for report parameter handling.

Additional dependencies include FND_CONCURRENT_PROGRAMS_VL (concurrent program definition lookup) and FND_GLOBAL (session and user context), together with standard SYS.STANDARD references.

Usage Notes

FA_FAS444_XMLP_PKG is not intended for direct invocation by custom code. It is executed implicitly by the Oracle XML Publisher engine when the associated FAS444 concurrent program is submitted through the Standard Report Submission (SRS) window or scheduled via the concurrent manager. At runtime, the layout template calls the formula and prompt functions to populate report headers and period descriptors, while BEFOREREPORT and AFTERREPORT manage execution lifecycle. Because the package is referenced by no other database object, modifications carry limited blast radius but should still be applied cautiously, since the generated output directly drives a statutory-style asset comparison report.