Search Results cp_report_type_p

Overview

APPS.PSB_PSBRPVPR_XMLP_PKG is the generated PL/SQL package body that supports the Oracle E-Business Suite XML Publisher (BI Publisher) concurrent program associated with the PSBRPVPR report. The report belongs to the Public Sector Budgeting (PSB) product family and is used to present position, budget worksheet, and position budget extract information in a printable and exportable format. The package encapsulates all report-level logic required by the XML Publisher template, including the derivation of run-time report parameters, the initialization of report context, and the population of global package variables that the data model exposes to the template.

The central mechanism in this package is the BEFOREREPORT function, which sets up key report attributes such as CP_REPORT_TYPE, worksheet name, budget year name, and extract name. These values drive the conditional presentation logic within the report template. The package is registered as an OTHER API classification object in ETRM, indicating that it is not a public business API but rather an implementation component of the report infrastructure.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions, each serving a specific role within the XML Publisher runtime lifecycle.

• BEFOREREPORT — Executes before report data retrieval. It assigns the concurrent request ID, resolves message text for "no data found" and "end of report" conditions, and sets CP_REPORT_TYPE to 'W' when a worksheet ID is supplied or 'D' when a data extract ID is supplied. It also invokes the PSB_POSITIONS_I_PVT API to define worksheet values and initialize the view.
• BEFOREPFORM — Executes before the report's parameter form.
• AFTERPFORM — Executes after the parameter form completes.
• AFTERREPORT — Executes after report completion, typically for cleanup.
• BETWEENPAGE — Executes between pages during report generation.
• CF_1FORMULA0090 — A generated formula column used within the report data model.
• CP_CURRENCY_CODE_P — Placeholder function returning the currency code value.
• CP_ELEM_TOTAL_P — Placeholder function for element total values.
• CP_POS_TOTAL_P — Placeholder function for position total values.
• CP_NO_DATA_FOUND_P — Placeholder for the localized "no data found" message.
• CP_END_OF_REPORT_P — Placeholder for the localized "end of report" message.
• CP_POS_ASS_WS_P — Placeholder for position assignment worksheet data.
• CP_EXTRACT_NAME_P — Placeholder for the data extract name.
• CP_WORKSHEET_NAME_P — Placeholder for the worksheet name.
• CP_YEAR_NAME_P — Placeholder for the budget year name.
• CP_REPORT_TYPE_P — Placeholder function returning the CP_REPORT_TYPE global, which is the parameter the user searched for.

Tables Accessed

The package reads from three PSB tables through APPS synonyms:

• PSB_WORKSHEETS — Queried to retrieve the worksheet name when P_WORKSHEET_ID is provided.
• PSB_BUDGET_PERIODS — Queried to retrieve the budget year name using P_BUDGET_YEAR_ID.
• PSB_DATA_EXTRACTS — Queried to retrieve the data extract name when P_DATA_EXTRACT_ID is provided.

These reads populate global variables exposed to the XML Publisher template, ensuring the report header and body reflect the correct organizational and period context.

Usage Notes

This package is not intended to be called directly from custom forms or client code. It is invoked exclusively by the Oracle XML Publisher engine when the PSBRPVPR concurrent program is executed, either from the standard PSB responsibilities or from a customized concurrent request submission. The CP_REPORT_TYPE global, which the user searched on, distinguishes between worksheet-based ('W') and data-extract-based ('D') reporting modes, allowing a single report definition to serve two distinct presentation scenarios. Developers extending PSB reporting should treat this package as a report-support artifact and avoid modifying it directly, since it is regenerated from the underlying report definition.