Search Results period1_pod_p

Overview

FA_FASPARTX_XMLP_PKG is the generated PL/SQL package associated with the Oracle Assets XML Publisher report FASPARTX, commonly titled "Asset Additions, Adjustments, Transfers, and Retirements" or similar transaction activity reports. The package resides in the APPS schema and is classified as an "OTHER" API type within the ETRM metadata for Oracle EBS 12.1.1 and 12.2.2. Its principal role is to supply the runtime logic, parameter retrieval functions, and reporting infrastructure that XML Publisher (BI Publisher) invokes when the FASPARTX concurrent program executes. The package exposes public variables representing report parameters such as P_BOOK, P_PERIOD1, P_CONCURRENT_REQUEST_ID, and P_MIN_PRECISION, together with a series of getter functions and report-level formula hooks that format and return parameter values to the report template.

Key Procedures and Functions

The package documents twelve procedures and functions. Together they implement the standard XML Publisher report lifecycle for Oracle Assets.

• BEFOREREPORT — Executes before the report data model is populated, performing setup such as initializing globals, deriving reporting period attributes, and preparing values consumed by the query.
• AFTERREPORT — Executes after report completion, used to reset session state and release resources.
• PERIOD1_PCFORMULA — A formula function that computes and returns a numeric value tied to the Period1 parameter (typically a period counter or period number used in period comparisons).
• PERIOD1_POD_P — Getter returning the Period1 period-open date, derived from the accounting period definition.
• PERIOD1_PCD_P — Getter returning the Period1 period-close date for the selected depreciation period.
• PERIOD1_FY_P — Getter returning the fiscal year associated with the Period1 parameter.
• ACCT_BAL_APROMPT_P — Returns the balancing segment (account) prompt value used in the parameter window.
• ACCT_CC_APROMPT_P — Returns the cost center segment prompt value.
• CAT_MAJ_RPROMPT_P — Returns the major category range prompt value.
• RP_COMPANY_NAME_P — Returns the company name used in the report header.
• RP_REPORT_NAME_P — Returns the formatted report title.
• REPORT_NAMEFORMULA — A formula that builds the report name string, taking the company name as input.

Tables Accessed

The package references two documented tables through APPS synonyms. FA_DEPRN_PERIODS is queried to resolve period-open and period-close dates and fiscal year information for the selected depreciation book and period, which directly feed the Period1_POD_P, Period1_PCD_P, and Period1_FY_P functions. FND_CONCURRENT_REQUESTS is accessed to retrieve information about the concurrent request that launched the report, supporting use of P_CONCURRENT_REQUEST_ID and related runtime context. Both tables are read-only in the context of this reporting package.

Usage Notes

FA_FASPARTX_XMLP_PKG is not intended for direct invocation by developers or custom code. It is generated automatically by Oracle's XML Publisher concurrent program registration process and is called by the BI Publisher engine when the FASPARTX concurrent program runs. The public getter functions (for example, Period1_POD_P, which corresponds to the user search term "period1_pod_p") are referenced directly from the report's RTF or XSL-FO template to embed parameter-derived values. Because the metadata records zero referencing packages, the package sits at the leaf of the dependency chain and is consumed exclusively by its associated report definition. Customizations should be applied to the underlying report template or the concurrent program definition rather than to this generated package, since it may be regenerated during patching or upgrades.