Search Results p_conc_request_id_p

Overview

PSB_PSBRPFHP_XMLP_PKG is the generated PL/SQL package body that supports an Oracle EBS XML Publisher (BI Publisher) concurrent program report in the Public Sector Budgeting (PSB) module. The package encapsulates the report-level logic that Oracle Reports/XML Publisher expects for report execution: initialization, data-fetching for report header parameters, NLS message resolution, and cleanup. It is classified as an OTHER API in ETRM, meaning it is a reporting support package rather than a public integration API, and it is referenced by zero other packages. Based on the module context (Public Sector Budgeting), the report prints budget worksheet information, including the budget group, worksheet name, company (ledger/SOB), and budget period name.

Key Procedures and Functions

The package exposes the following documented functions, most of which are trivial getters required by the Oracle Reports/XML Publisher report definition:

• BEFOREREPORT — The main initialization function. It populates the concurrent request ID using FND_GLOBAL.CONC_REQUEST_ID, queries PSB_BUDGET_GROUPS_V and PSB_WORKSHEETS to derive the company, worksheet, and budget group names, optionally resolves the budget period name from PSB_BUDGET_PERIODS, and loads NLS messages (PSB_NO_DATA_FOUND, PSB_END_OF_REPORT). It returns TRUE on success and handles NO_DATA_FOUND and OTHERS exceptions by returning NULL.
• AFTERREPORT — Cleanup function called at end of report; in this version the SRW exit call is commented out and it simply returns TRUE.
• BEFOREPFORM and AFTERPFORM — Report format triggers that return TRUE; no custom logic is implemented.
• BETWEENPAGE — Page-break trigger returning TRUE; reserved for page-level logic.
• C_NLS_END_OF_REPORT_P — Getter that returns the NLS end-of-report message.
• C_NLS_NO_DATA_EXISTS_P — Getter that returns the NLS no-data message.
• P_CONC_REQUEST_ID_P — Getter returning the concurrent request ID captured at before-report time.
• CP_COMPANY_P, CP_WORKSHEET_P, CP_BUDGET_GROUP_P, and CP_BUD_PERIOD_NAME_P — Getters that expose the report's header/parameter values (company/SOB name, worksheet name, budget group name, and budget period name) to the report layout.

Tables Accessed

The package reads the following tables and views, referenced through APPS synonyms:

• PSB_BUDGET_GROUPS_V — Supplies the budget group name and SOB/company name used to identify the budget context of the report.
• PSB_WORKSHEETS — Provides the worksheet name; joined to PSB_BUDGET_GROUPS_V on BUDGET_GROUP_ID and filtered by P_WORKSHEET_ID.
• PSB_BUDGET_PERIODS — Queried only when P_BUDGET_PERIOD_ID is not null, restricted to budget period type 'Y', to resolve the period name.

The package performs read-only access; no inserts, updates, or deletes are documented.

Usage Notes

This package is invoked automatically by the Oracle Reports/XML Publisher runtime when the associated PSB concurrent program is submitted. Users execute the report from the Submit Requests window or a PSB form; the report engine then calls BEFOREREPORT, the format triggers, and the getter functions to render header and summary information. Because the package depends on report bind parameters such as P_WORKSHEET_ID and P_BUDGET_PERIOD_ID, it is not intended for direct invocation from custom code. The getters (P_CONC_REQUEST_ID_P and the CP_*_P functions) exist solely so the report layout can reference these values. The package is generated code (as indicated by the XMLP_PKG suffix and the RCS header), so customization should be avoided; the standard Oracle recommendation is that the underlying SQL query or the report definition be modified rather than editing the package body directly.