Search Results psb_psbrpfhp_xmlp_pkg

Overview

PSB_PSBRPFHP_XMLP_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that supports the concurrent program output associated with the Public Sector Budgeting (PSB) module. The naming convention _XMLP_PKG indicates that this package is generated and used by the Oracle XML Publisher (BI Publisher) engine to drive the report data model for a specific budget reporting concurrent program. Its presence in the APPS schema and its classification as an OTHER API reflect that it is an internal report-support package rather than a public application programming interface intended for customer extension.

In EBS 12.1.1 and 12.2.2, XML Publisher-based reports require a PL/SQL package to supply the before-report, after-report, and formatting hooks that pass concurrent request parameters into the report and manipulate the result set prior to rendering. PSB_PSBRPFHP_XMLP_PKG fulfills this role for the "PSB Budget Report/Worksheet" family of reports. Documentation via ETRM confirms the package is VALID and carries 12 documented procedures/functions, all consistent with the standard XML Publisher data-model package template.

Key Procedures and Functions

The package exposes the customary XML Publisher entry points along with report-specific parameter accessors:

• BEFOREREPORT — Executed once before the report data query is fired; typically initializes variables and anchors the concurrent request context.
• AFTERREPORT — Executed after the report completes; used to release cursor state and finalize values.
• BEFOREPFORM — Pre-format hook fired prior to the output formatting (report layout) stage.
• AFTERPFORM — Post-format hook fired after the layout stage completes.
• BETWEENPAGE — Page-break level hook invoked between report pages, generally used for repeated or conditional page content.
• C_NLS_END_OF_REPORT_P — Constant/accessor providing the localized "end of report" text token.
• C_NLS_NO_DATA_EXISTS_P — Constant/accessor providing the localized "no data exists" text token.
• P_CONC_REQUEST_ID_P — Accessor for the concurrent request ID parameter.
• CP_COMPANY_P — Accessor for the company parameter.
• CP_WORKSHEET_P — Accessor for the worksheet parameter.
• CP_BUDGET_GROUP_P — Accessor for the budget group parameter.
• CP_BUD_PERIOD_NAME_P — Accessor for the budget period name parameter.

These names confirm the report is scoped to a specific company, budget group, budget period, and worksheet.

Tables Accessed

Via APPS synonyms, the package reads from PSB_BUDGET_PERIODS and PSB_WORKSHEETS. PSB_BUDGET_PERIODS holds the defined budget period calendar entries used to filter report output to the selected period (CP_BUD_PERIOD_NAME_P). PSB_WORKSHEETS stores worksheet definitions and identifiers (CP_WORKSHEET_P), which determine the structure of the budget data retrieved. These tables supply the report's data model; access is read-oriented for report generation.

Usage Notes

The package is invoked automatically by the XML Publisher concurrent program framework when the associated PSB report is submitted from the Submit Requests or Run Reports interfaces; no manual call is required. It is not intended for direct customer calls. Because ETRM shows zero referencing packages, external dependencies are limited to SYS.STANDARD. ETRM confirms the object's release currency for 12.1.1; for 12.2.2 the same XML Publisher package structure applies. Confirm compilation state via USER_OBJECTS after any patch upgrade.