Search Results cp_worksheet_name

Overview

PSB_PSBRPPPS_XMLP_PKG is an Oracle E-Business Suite package body owned by APPS and classified as OTHER in the ETRM metadata for release 12.1.1. It is the generated PL/SQL wrapper for an Oracle Reports (XML Publisher) concurrent program built on the PSB product schema, which supports budgeting and worksheet functionality. The package supplies the report-level PL/SQL constructs required by the Reports runtime: standard Before Report, Before Form, After Form, After Report and Between Page trigger functions, together with a set of accessor functions that expose report constants and derived values to the layout. The package is not a general-purpose API; it exists solely to service a single report executable and to resolve display text for "no data found" and "end of report" messaging through the FND message dictionary.

Key Procedures and Functions

• BEFOREREPORT — The primary initialization function. It captures the concurrent request ID via FND_GLOBAL.CONC_REQUEST_ID, loads the message text for PSB_NO_DATA_FOUND and PSB_END_OF_REPORT via FND_MESSAGE, derives the CP_NO_DATA_FOUND and CP_END_OF_REPORT constants from those messages, validates the P_WORKSHEET_ID parameter, and resolves the worksheet name from PSB_WORKSHEETS and the budget year name from PSB_BUDGET_PERIODS. It returns FALSE on NO_DATA_FOUND.
• BEFOREPFORM — Placeholder trigger that returns TRUE, permitting report execution to continue.
• AFTERPFORM — Re-reads the concurrent request ID into P_CONC_REQUEST_ID and returns TRUE.
• AFTERREPORT — Re-reads the concurrent request ID and returns TRUE at report completion. The standard FND SRWINIT and SRWEXIT user exits are present only as commented-out statements.
• BETWEENPAGE — Placeholder trigger returning TRUE for each page break.
• CP_NO_DATA_FOUND_P — Accessor that returns the CP_NO_DATA_FOUND VARCHAR2 constant. This is the function referenced by the search term "cp_no_data_found_p"; it exposes the localized "no data found" message text (derived by SUBSTR of the FND message at offset 7, length 13) to the report layout.
• CP_END_OF_REPORT_P — Accessor returning the CP_END_OF_REPORT message constant.
• CP_WORKSHEET_NAME_P — Accessor returning the worksheet name resolved from PSB_WORKSHEETS.
• CP_YEAR_NAME_P — Accessor returning the budget year name resolved from PSB_BUDGET_PERIODS.

Tables Accessed

• PSB_WORKSHEETS — Read in BEFOREREPORT to retrieve the NAME column for the worksheet identified by P_WORKSHEET_ID. This value populates CP_WORKSHEET_NAME and is surfaced to the report through CP_WORKSHEET_NAME_P.
• PSB_BUDGET_PERIODS — Read in BEFOREREPORT to retrieve the NAME column for the budget period identified by P_BUDGET_YEAR_ID. This value populates CP_YEAR_NAME and is surfaced through CP_YEAR_NAME_P.

Both tables are referenced through APPS synonyms, consistent with the package being compiled in the APPS schema.

Usage Notes

The package is invoked exclusively by the Oracle Reports runtime when the associated PSB concurrent program is submitted; it is not referenced by any other documented package (referenced by 0 other packages). Parameters such as P_WORKSHEET_ID and P_BUDGET_YEAR_ID originate from the concurrent program definition and report parameter form. The accessor functions are called from the report layout to display header context and message text. Because BEFOREREPORT returns FALSE when P_WORKSHEET_ID is null or when lookups raise NO_DATA_FOUND, a missing worksheet effectively suppresses report output. Customizations should avoid direct calls to this package; concurrent program parameters and the underlying PSB tables are the supported integration points.