Search Results accounting_flex_structure_p

Overview

The APPS.FA_FAS833_XMLP_PKG package is the generated PL/SQL wrapper package that supports the Oracle E-Business Suite Fixed Assets report identified internally as FAS833. It is a standard XML Publisher (BI Publisher) report package, generated by Oracle Reports to XML conversion utilities and shipped under the APPS schema. The package declares the global variables and formula functions that the report definition references at runtime, allowing the XML template to resolve bind parameters, derived values, and report-level context.

The user search term "accounting_flex_structure_p" corresponds directly to one of the accessor functions declared in this package. The Accounting_Flex_Structure global variable holds the chart of accounts structure identifier used by the report, and Accounting_Flex_Structure_p returns that value to the report engine. This confirms that the report relies on the accounting key flexfield structure to format and group asset accounting information.

Key Procedures and Functions

The package exposes eleven documented programs, all structured as report-side formula or lifecycle functions:

• BookFormula — Returns the value associated with the P_BOOK global, supplying the asset book parameter to the report.
• report_nameformula — Builds the display name of the report using the company name passed in, populating RP_REPORT_NAME.
• BeforeReport — The before-report trigger; initializes global variables and prepares report context prior to data retrieval.
• AfterReport — The after-report trigger; performs cleanup and finalization once the report completes.
• d_statusformula — Derives the display text for asset status values passed to it.
• Accounting_Flex_Structure_p — Returns the stored accounting flexfield structure value; this is the function targeted by the user's search.
• Currency_Code_p — Returns the currency code associated with the report run.
• RP_COMPANY_NAME_p — Returns the resolved company name for the report header.
• RP_REPORT_NAME_p — Returns the resolved report name.
• RP_DATA_FOUND_p — Returns a flag indicating whether data rows were retrieved, typically used to suppress or produce an empty-report message.
• D_COSTFormula — Added during defect fixes; derives cost display values.

Tables Accessed

The package references three tables through APPS synonyms:

• FA_BOOK_CONTROLS — Supplies asset book setup and control information, including the accounting flexfield structure and currency associated with the selected book.
• FND_CONCURRENT_REQUESTS — Used in conjunction with the P_CONC_REQUEST_ID global to resolve concurrent request context and parameters for the report run.
• FND_CURRENCIES — Provides currency definitions used when resolving currency codes and descriptions.

Usage Notes

FA_FAS833_XMLP_PKG is not intended for direct invocation by custom code. It is generated infrastructure that is loaded automatically whenever the associated concurrent program is submitted from the Fixed Assets responsibility. When a user runs the FAS833 report, the concurrent manager instantiates the report, the BeforeReport function initializes the P_BOOK, P_CONC_REQUEST_ID, and P_MIN_PRECISION globals, and the formula functions are called by the XML template as it renders.

The package is referenced by no other PL/SQL packages, confirming its role as a terminal, report-specific artifact. Because the source header carries a 2008 date stamp and the code is marked proprietary, it should be treated as Oracle-maintained and never modified in place; any functional change must be applied through supported patching. Custom reports that call the Accounting_Flex_Structure_p function directly should be aware that its return value depends on globals populated during the report lifecycle, and it is not meaningful outside a running FAS833 concurrent request.