Search Results cp_end_of_report_p

Overview

PSB_PSBRPBGH_XMLP_PKG is the generated PL/SQL package body that backs the Oracle EBS XML Publisher (BI Publisher) concurrent report PSBRPBGH, a budgeting report within the Public Sector Budgeting (PSB) module. The report belongs to the Grants and Budgeting family and is designed to render the budget group hierarchy for a given ledger and budget group, filtered by an effective date. In Oracle EBS 12.1.1 and 12.2.2, XML Publisher reports are implemented as PL/SQL packages containing the standard report trigger functions (BEFOREREPORT, BEFOREPFORM, AFTERPFORM, BETWEENPAGE, AFTERREPORT) plus accessor functions that expose named "lexical" or column parameters to the report template. The package header defines those public functions; the body (this object) contains their implementations.

The identifier the user searched for, cp_end_of_report_p, is the accessor function that returns the value of the CP_END_OF_REPORT parameter. That parameter is a hidden or displayed report parameter holding a translated message used to mark the end of the report output, sourced from the PSB message dictionary.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions, all declared in the package body:

• BEFOREREPORT — Executes before the report data is fetched. It assigns the concurrent request ID from FND_GLOBAL.CONC_REQUEST_ID, resolves set of books and budget group names, sets the effective date default to SYSDATE, and populates message-based parameters such as CP_NO_DATA_FOUND and CP_END_OF_REPORT.
• BEFOREPFORM — Trigger fired before the report "print form" section; returns TRUE.
• AFTERPFORM — Trigger fired after the print form section; returns TRUE.
• BETWEENPAGE — Trigger fired between pages; returns TRUE.
• AFTERREPORT — Trigger fired at the end of the report; returns TRUE and, historically, contained the SRW.USER_EXIT('FND SRWEXIT') call (now commented out).
• CP_SET_OF_BOOKS_NAME_P — Accessor returning the resolved set of books name.
• CP_TOP_BUDGET_GROUP_NAME_P — Accessor returning the resolved top budget group name.
• CP_NO_DATA_FOUND_P — Accessor returning the localized "no data found" message.
• CP_END_OF_REPORT_P — Accessor returning the localized end-of-report message used by the report template.

The logic in BEFOREREPORT populates the underlying private variables (CP_SET_OF_BOOKS_NAME, CP_TOP_BUDGET_GROUP_NAME, CP_NO_DATA_FOUND, CP_END_OF_REPORT, LP_EFFECTIVE_DATE, DP_EFFECTIVE_DATE) which the _P functions then expose. When P_SET_OF_BOOKS_ID is null, the set of books name defaults to the "PSB_ALL" message; otherwise it is queried from GL_SETS_OF_BOOKS. Likewise, P_BUDGET_GROUP_ID null yields the default "PSB_ALL" name; otherwise it is read from PSB_BUDGET_GROUPS.

Tables Accessed

The ETRM metadata identifies a single directly referenced table via APPS synonyms: PSB_BUDGET_GROUPS. This table is queried in BEFOREREPORT to resolve the budget group ID supplied at runtime into its human-readable NAME for display on the report. In addition, the body references GL_SETS_OF_BOOKS and FND_GLOBAL in the excerpt shown; the ETRM document lists only PSB_BUDGET_GROUPS as the formally documented table, but GL_SETS_OF_BOOKS is used to retrieve the ledger name and FND_GLOBAL.CONC_REQUEST_ID supplies the concurrent request identifier. No INSERT, UPDATE, or DELETE operations are present — the package is entirely read-only against the database.

Usage Notes

This package is invoked exclusively through the Oracle EBS concurrent manager as the PL/SQL implementation of the PSBRPBGH XML Publisher report. It is not intended for direct invocation from forms or custom code, and the metadata records zero dependent packages, confirming it functions as a leaf report package. The functions BEFOREREPORT and AFTERREPORT bracket execution; the accessor functions (including CP_END_OF_REPORT_P) are called by the report template to embed resolved values into the output. In 12.2.2 the same package structure applies, though the underlying concurrent program is registered under the newer OAF-based concurrent manager. The $Header line indicates the source file is PSBRPBGHB.pls, version 120.0, last modified January 2008 — the package has remained stable across the 12.1.1 and 12.2.2 releases. Customizations should avoid modifying the generated body, as it can be regenerated by the XML Publisher report definition.