Search Results period_to_p

Overview

FA_FAS740_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that backs the concurrent program associated with the FAS740 report, a Fixed Assets reporting utility in the Oracle Assets module. The package is declared AUTHID CURRENT_USER, meaning its database objects are resolved under the privileges of the invoking user rather than the package owner. In the context of Oracle EBS 12.1.1 and 12.2.2, packages carrying the _XMLP_PKG suffix are generated wrappers used by Oracle XML Publisher (BI Publisher) to supply report parameters, execute pre- and post-report logic, and expose global variables and getter functions to the report definition. The version header, FAS740S.pls 120.1 2009/07/19, indicates this is a long-standing component that has been carried forward across releases.

Key Procedures and Functions

The package exposes eleven documented callable units, comprising two formula functions, two report lifecycle functions, and seven accessor functions.

• BOOKFORMULA — Returns the book value used by the report, derived from the book control context.
• REPORT_NAMEFORMULA — Returns the formatted report title, accepting the company name as input to build the display string.
• BEFOREREPORT — The pre-report hook invoked by XML Publisher prior to data retrieval; initializes package state and prepares report-level variables such as accounting flexfield structure and currency.
• AFTERREPORT — The post-report hook that performs cleanup or finalization once the report output is produced.
• ACCOUNTING_FLEX_STRUCTURE_P — Accessor returning the accounting flexfield structure identifier populated during setup.
• CURRENCY_CODE_P — Accessor returning the currency code applied to the report run.
• DIST_SOURCE_BOOK_P — Accessor returning the distribution source book value.
• RP_COMPANY_NAME_P — Accessor returning the company name used in the report header.
• RP_REPORT_NAME_P — Accessor returning the report name displayed in the output.
• PERIOD_FROM_P — Accessor returning the starting accounting period (period_from) selected by the user; this is the object most directly associated with the user's search term period_from_p.
• PERIOD_TO_P — Accessor returning the ending accounting period for the report range.

The package also declares public variables including P_BOOK, P_PERIOD1, P_PERIOD2, P_CONC_REQUEST_ID, P_MIN_PRECISION, PERIOD_FROM, and PERIOD_TO, which carry the concurrent request parameters into the report layout.

Tables Accessed

The package references three tables through APPS synonyms:

• FA_BOOK_CONTROLS — Supplies book-level attributes such as the accounting flexfield structure and the minimum precision used in the report.
• FND_CONCURRENT_REQUESTS — Used to read the concurrent request context (P_CONC_REQUEST_ID), enabling the report to tie output to a specific submission.
• FND_CURRENCIES — Provides currency code and precision information needed for monetary formatting.

Usage Notes

This package is not intended for direct invocation by end users or custom code. It is executed automatically by XML Publisher when the corresponding FAS740 concurrent program is submitted, with BEFOREREPORT and AFTERREPORT fired as lifecycle hooks. The accessor functions (including PERIOD_FROM_P and PERIOD_TO_P) are called by the report template to bind parameter values into the layout. Because the package operates under AUTHID CURRENT_USER, any customization or extension should preserve the parameter-passing contract expected by the concurrent program. In 12.1.1 and 12.2.2 the package behaves identically; the ETRM metadata records no dependents, meaning no other APPS packages reference it directly, so changes carry limited ripple risk but must still respect the published function signatures.