Search Results cp_sob_name

Overview

PSB_PSBRPPSA_XMLP_PKG is the generated PL/SQL package body that supports the Oracle EBS XML Publisher (BI Publisher) report PSBRPPSA, which belongs to the PSB (Public Sector Budgeting) product family. The package owns the report's ancillary logic: initializing the concurrent request context, resolving budget group and worksheet attributes, retrieving NLS message text for the "no data" and "end of report" conditions, and exposing report-level variables to the XML Publisher data template through a set of accessor functions. The report itself is generally understood to present budget worksheet or budget group information, and it is executed as a concurrent program within the Public Sector Budgeting module in release 12.1.1 and 12.2.2.

The specific identifier referenced in the source, CP_SOB_NAME, is a package-level variable populated during the BeforeReport trigger and surfaced to the report layout via the accessor function CP_SOB_NAME_P. It holds the set of books (ledger) name obtained from PSB_BUDGET_GROUPS_V, the budget group view, and is used for display, grouping, or header purposes on the output.

Key Procedures and Functions

• BEFOREREPORT — The core initialization trigger. Assigns the concurrent request identifier from FND_GLOBAL.CONC_REQUEST_ID into P_CONC_REQUEST_ID, queries PSB_BUDGET_GROUPS_V joined to PSB_WORKSHEETS to populate CP_SOB_NAME and CP_WS_NAME for the worksheet identified by P_WORKSHEET_ID, and derives the NLS message strings C_NLS_NO_DATA_EXISTS and C_NLS_END_OF_REPORT from the message dictionary. Returns TRUE, and returns NULL on NO_DATA_FOUND or any other exception, so the report can terminate cleanly when the worksheet does not exist.
• AFTERREPORT — Cleanup trigger. Retained for structural symmetry with the Oracle Reports execution model; the SRW.USER_EXIT('FND SRWEXIT') call is commented out and the function simply returns TRUE.
• BEFOREPFORM — Returns TRUE unconditionally; reserved for logic that must execute before the report parameter form is displayed.
• AFTERPFORM — Returns TRUE unconditionally; reserved for logic that must execute after the parameter form is submitted.
• BETWEENPAGE — Returns TRUE unconditionally; reserved for logic executed between report pages.
• P_CONC_REQUEST_ID_P — Accessor returning the stored concurrent request identifier to the report layout.
• C_NLS_END_OF_REPORT_P — Accessor returning the NLS text used to label the end-of-report marker.
• C_NLS_NO_DATA_EXISTS_P — Accessor returning the NLS text used when the report produces no rows.
• CP_WS_NAME_P — Accessor returning the worksheet name resolved in BEFOREREPORT.
• CP_SOB_NAME_P — Accessor returning the set of books (ledger) name resolved in BEFOREREPORT, i.e. the value the user searched for as cp_sob_name.
• CP_CURRENCY_CODE_P — Accessor returning the currency code variable, which is populated by other report SQL rather than by this package.

Tables Accessed

The package reads PSB_BUDGET_GROUPS_V and PSB_WORKSHEETS. PSB_WORKSHEETS is the documented base table (accessed through its APPS synonym); PSB_BUDGET_GROUPS_V is the budget group view joined on BUDGET_GROUP_ID. The join key is WORKSHEET_ID = P_WORKSHEET_ID. Only read access occurs; the package performs no inserts, updates, or deletes.

Usage Notes

This package is invoked automatically by the Oracle Reports/XML Publisher runtime when the PSBRPPSA concurrent program is submitted; it is not called directly by forms or custom code. The generated _P accessor functions exist so that the report's data model and layout templates can reference package-level variables such as CP_SOB_NAME. The package is referenced by zero other packages, confirming it is a leaf artifact tied to a single report. Because CP_SOB_NAME is populated only by the BEFOREREPORT query, any customization or diagnostic work referencing cp_sob_name should account for the possibility that the value is NULL when no matching worksheet row exists for the supplied P_WORKSHEET_ID.