Search Results lp_effective_date

Overview

PSB_PSBRPBGH_XMLP_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that supports the "PSB_PSBRPBGH" XML Publisher (BI Publisher) concurrent program report. The report covers budget group data within the Public Sector Budgeting (PSB) module. The package follows the standard XML Publisher concurrent program packaging convention in EBS 12.1.1 and 12.2.2, where Oracle Reports or BI Publisher data definitions invoke a generated package that exposes report parameters, global cursors, and standard report-lifecycle hooks. Its API classification is OTHER, meaning it is not a public application programming interface but an internal, report-specific construct. The package does not expose business logic intended for reuse; instead, it exists solely to bind SQL and PL/SQL logic to the XML Publisher report template. The reference to the header "PSBRPBGHS.pls 120.0" with a 2008 timestamp confirms it is a legacy report package retained through the 12.2.x codebase without functional redesign.

Key Procedures and Functions

The package declares nine documented procedures and functions, which are the conventional entry points generated by the Oracle Reports-to-XML-Publisher bridge and the EBS concurrent program framework:

• BEFOREREPORT — Fires before report processing begins; used to initialize package globals and resolve parameter values prior to data extraction.
• BEFOREPFORM — Executes before the parameter form is rendered, allowing pre-population or validation of report parameters.
• AFTERPFORM — Executes after the parameter form has been submitted, typically to finalize parameter values before the query phase.
• BETWEENPAGE — Invoked between report pages; used for page-level formatting or repeated header logic.
• AFTERREPORT — Fires after the report completes; used for cleanup or summary computations.
• CP_SET_OF_BOOKS_NAME_P — A getter function returning the set of books name, referencing the CP_SET_OF_BOOKS_NAME global.
• CP_TOP_BUDGET_GROUP_NAME_P — A getter function returning the top budget group name from the CP_TOP_BUDGET_GROUP_NAME global.
• CP_NO_DATA_FOUND_P — A getter function returning the no-data-found message text.
• CP_END_OF_REPORT_P — A getter function returning the end-of-report label text.

The package also declares global variables including P_BUDGET_GROUP_ID, P_SET_OF_BOOKS_ID, P_EFFECTIVE_DATE, LP_EFFECTIVE_DATE, DP_EFFECTIVE_DATE, and P_CONC_REQUEST_ID, which carry runtime parameter and context values into the report logic. The LP_EFFECTIVE_DATE variable is the local PL/SQL binding for the effective date parameter and is the item users searched for.

Tables Accessed

Per the documented metadata, the package reads the PSB_BUDGET_GROUPS table through an APPS synonym. This table stores budget group definitions used by Public Sector Budgeting, and the report retrieves budget group identifiers and descriptive attributes for the requesting set of books and effective date. No other tables are documented as accessed by this package. Writes are not indicated; the package acts as a read-only reporting component against PSB_BUDGET_GROUPS.

Usage Notes

PSB_PSBRPBGH_XMLP_PKG is invoked exclusively through the PSB_PSBRPBGH XML Publisher concurrent program, not through forms or external custom code. It is referenced by zero other packages, confirming it sits at a leaf of the dependency tree. Parameters such as P_EFFECTIVE_DATE and P_BUDGET_GROUP_ID are supplied by the concurrent program request and bound into LP_EFFECTIVE_DATE and related globals during the BEFOREREPORT phase. Because the header reflects version 120.0 and no changes since 2008, the package is stable and should be treated as internal; direct calls from custom code are unsupported and would bypass the standard report lifecycle. Organizations troubleshooting report output should trace the effective date value through LP_EFFECTIVE_DATE and the PSB_BUDGET_GROUPS query rather than modifying the package itself.