Search Results fa_fas441_xmlp_pkg




Overview
Explore in AI Chat

Overview

The package APPS.FA_FAS441_XMLP_PKG is the generated PL/SQL wrapper that supports the Oracle Assets report identified as FAS441. In Oracle E-Business Suite 12.1.1 and 12.2.2, Oracle Reports executables that are deployed through the concurrent manager are accompanied by a package of the same name that declares the report's user parameters and its report-level trigger functions. This package is therefore not a general-purpose API; it is a technical artifact whose sole business purpose is to bind the XML Publisher (BI Publisher) concurrent program definition to the underlying report logic and to resolve the parameter values, lexical references, and derived dates needed to produce the FAS441 output.

The package is declared AUTHID CURRENT_USER, meaning that at runtime it executes with the privileges of the invoking APPS schema under which the concurrent request is submitted. All declared variables and functions are therefore scoped to a single concurrent request execution and are populated by the Oracle Reports runtime engine immediately before the report query is fired.

Key Procedures and Functions

The package exposes fourteen documented program units. Their purposes are as follows:

  • REPORT_NAMEFORMULA — derives the run-time report name displayed on the report header, typically by combining the company name with the standard FAS441 title.
  • BEFOREREPORT — the main before-report trigger. It performs the initialization work required before data retrieval, including resolving period and precision values from the book controls and concurrent request context.
  • AFTERREPORT — the after-report trigger, executed on completion of the report run.
  • PERIOD1_PCFORMULA — computes the period-close date value for the report period.
  • PRECFORMULA — returns the display precision string used to format monetary columns in the report output.
  • PRECISION_P — the accessor function for the PRECISION package variable. This is the element directly associated with the user's search term precision_p; it returns the numeric precision to be applied when rendering asset cost and depreciation amounts.
  • ACCT_BAL_APROMPT_P, ACCT_CC_APROMPT_P, CAT_MAJ_RPROMPT_P — accessors returning the accounting balance, accounting cost center, and major category report prompts.
  • PERIOD1_POD_P, PERIOD1_PCD_P, PERIOD1_FY_P — accessors returning the period open date, period close date, and fiscal year for the first report period.
  • RP_COMPANY_NAME_P and RP_REPORT_NAME_P — accessors returning the company name and report name values used by the report layout.

Tables Accessed

The package references four tables through APPS synonyms:

  • FA_BOOK_CONTROLS — the authoritative source of the depreciation book definition; supplies book calendar, currency, and the accounting precision settings that drive PRECISION_P.
  • FA_DEPRN_PERIODS — provides the period open and close dates used by the PERIOD1_* accessors and by the report's date-range filtering.
  • FND_CONCURRENT_REQUESTS — supplies the concurrent request identifier, allowing the package to recover request-level context such as the submitted parameters.
  • FND_CURRENCIES — resolves currency formatting attributes, including the currency precision used in amount display.

Usage Notes

This package is invoked only by the Oracle Reports runtime when the FAS441 concurrent program is submitted from the Assets responsibility or from a scheduled request set. It is not intended to be called directly from forms or custom PL/SQL. The _P accessor functions exist because Oracle Reports cannot read package variables directly; each layout field that must display a package state value is bound to a corresponding accessor. Customizations should be made to the underlying report definition rather than to this generated package, since any modification is overwritten on patch application. It is referenced by zero other packages, confirming its role as a leaf-level report support unit.