Search Results f_1formattrigger

Overview

APPS.PSB_PSBRPPRM_XMLP_PKG is the generated PL/SQL package body that supports the Oracle E-Business Suite XML Publisher (BI Publisher) concurrent report corresponding to the PSB (Public Sector Budgeting) parameter listing program, PSBRPPRM. The "XMLP" suffix identifies it as a report-data-source package produced by the Oracle Reports-to-XML Publisher migration process. In Oracle EBS 12.1.1 and 12.2.2, such packages execute at runtime within the concurrent manager to populate the report's placeholder columns before the XML template is applied against the generated XML output.

The package's principal responsibility is report initialization and parameter interpretation. The BEFOREREPORT function resolves user-supplied concurrent program parameters — the set of books, budget group, and parameter set identifiers — into descriptive values displayed on the printed report. It also derives localization strings for the "no data found" and "end of report" messages from the FND_MESSAGE facility. The AFTERREPORT function performs the complementary teardown logic at the end of report execution. The package as documented is referenced by no other packages, confirming its role as a standalone report driver rather than a shared utility.

Key Procedures and Functions

The package exposes fifteen documented program units, most of which are standard XML Publisher report triggers:

• BEFOREREPORT — the primary initialization function. It captures the concurrent request identifier via FND_GLOBAL.CONC_REQUEST_ID, resolves the SOB, budget group, and parameter set values into placeholder columns (CP_SOB, CP_BGP, CP_SET), and derives the NLS message text for empty and end-of-report conditions.
• AFTERREPORT — executes the standard report exit processing at the conclusion of the report run.
• BEFOREPFORM and AFTERPFORM — format triggers fired before and after the report's parameter form is rendered.
• BETWEENPAGE — the between-pages trigger, invoked during report pagination.
• M_SET_GRPFRFORMATTRIGGER, M_1FORMATTRIGGER, F_2FORMATTRIGGER, and F_1FORMATTRIGGER — named format triggers associated with report-level and repeating-frame sections of the report layout.
• P_CONC_REQUEST_ID_P, CP_NLS_NO_DATA_EXISTS_P, CP_NLS_END_OF_REPORT_P, CP_SOB_P, CP_BGP_P, and CP_SET_P — accessor functions that expose the corresponding private placeholder and parameter values to the XML Publisher data model.

Tables Accessed

According to the documented metadata, the package reads from PSB_BUDGET_GROUPS via the APPS synonym. Specifically, it selects the SHORT_NAME column keyed by BUDGET_GROUP_ID to resolve the budget group description displayed on the report output. The source excerpt additionally shows queries against GL_SETS_OF_BOOKS (for the set-of-books NAME) and PSB_PARAMETER_SETS_V (for the parameter set NAME and its associated set-of-books and budget group identifiers), which together allow the report to present meaningful parameter values rather than raw numeric identifiers.

Usage Notes

PSB_PSBRPPRM_XMLP_PKG is invoked automatically by the Oracle EBS concurrent manager when the associated PSBRPPRM XML Publisher report is submitted, typically from the Public Sector Budgeting responsibility. It is not intended for direct invocation from Oracle Forms or custom PL/SQL code; the placeholder accessor functions exist solely to bind data-model values for the report layout. Because the package is tied to a specific concurrent program definition, its signature and parameter handling should not be modified. Default values are drawn from the PSB message dictionary using the 'PSB_ALL' token when a parameter is left null, meaning the report will present "ALL" for any unresolved set of books, budget group, or parameter set.