Search Results distribution_source_book_p

Overview

FA_FAS840_XMLP_PKG is the Oracle Application Object Library package that supports the Oracle Assets depreciation reporting concurrent program FAS840. In Oracle E-Business Suite 12.1.1 and 12.2.2, report-specific PL/SQL packages of this type are generated by Oracle Reports and registered as the public interface between the concurrent manager and the underlying report definition. The suffix "XMLP" identifies the report as an XML Publisher (BI Publisher) based concurrent program.

The package exposes a set of global variables that carry report parameter values into the report execution context, together with formatter-style functions that resolve mandatory report parameters and derived values. It holds the depreciation book (P_BOOK), the two accounting periods being reported (P_PERIOD1, P_PERIOD2), the concurrent request identifier (P_CONC_REQUEST_ID), and the minimum precision to be applied (P_MIN_PRECISION). Supporting globals include lp_currency_code, p_ca_org_id, p_ca_set_of_books_id, and p_mrcsobtype, the latter supporting multiple reporting currencies (MRC) processing.

Key Procedures and Functions

The package declares fourteen documented program units. The accessor functions BOOKFORMULA, PERIOD1FORMULA, PERIOD2FORMULA, and REPORT_NAMEFORMULA supply report-level parameter and lexical defaults prior to report execution.

The event functions BEFOREREPORT, AFTERREPORT, and AFTERPFORM implement the standard report lifecycle hooks. BEFOREREPORT initializes package state before the query executes; AFTERPFORM fires after the parameter form is processed and is the point at which derived globals such as the distribution source book and currency are resolved; AFTERREPORT performs cleanup.

The remaining functions are value accessors that return the state of the package globals: PRECISION_p, ACCOUNTING_FLEX_STRUCTURE_p, CURRENCY_CODE_p, DISTRIBUTION_SOURCE_BOOK_p, PERIOD1_PC_p, PERIOD2_PC_p, and RP_REPORT_NAME_p. These allow the report definition and concurrent program setup to read resolved values at runtime.

The term searched by the user, distribution_source_book_p, corresponds directly to the documented function DISTRIBUTION_SOURCE_BOOK_P, which returns the Distribution_Source_Book global. This value identifies the depreciation book from which cost distribution information is sourced when it differs from the reporting book.

Tables Accessed

The package references four tables through APPS synonyms. FA_BOOK_CONTROLS is the book definition table, queried to validate the book and retrieve accounting flexfield and currency attributes. FA_DEPRN_PERIODS supplies depreciation period information used to reconcile the requested reporting periods, supporting the Period1_PC and Period2_PC globals. FND_CONCURRENT_REQUESTS is read using the concurrent request identifier to obtain request context such as the organization and set of books. FND_CURRENCIES resolves currency precision, feeding the PRECISION global and the minimum precision parameter applied to reported amounts.

Usage Notes

This package is not intended for direct invocation from forms or custom code. It is registered against the FAS840 concurrent program and is invoked by the concurrent manager when the report is submitted from the Standard Report Submission (SRS) window or by schedule. The report definition itself calls the package functions to populate parameters and initialize state.

In 12.1.1 and 12.2.2 the runtime behavior is identical; the object resides in the APPS schema and is shipped under the standard Oracle Assets patch series. Because the metadata records no referencing packages, customizations should treat it as report-private and avoid direct dependency.