Search Results psb_psbrpbrs_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.PSB_PSBRPBRS_XMLP_PKG package is a PL/SQL package that belongs to the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module. It is a database-resident package in the APPS schema and is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2. Its name follows the standard Oracle XML Publisher (XMLP) concurrent program conventions, which indicates that it serves as the supporting PL/SQL package for a concurrent program that produces an XML Publisher report. The "PSBRPBRS" identifier refers to a Public Sector Budgeting budget revisions report. This package provides the report data logic, formula calculations, and formatting anchors that XML Publisher templates invoke when the report runs.

Key Procedures and Functions

The package exposes eleven documented program units that support the report lifecycle:

  • BEFOREREPORT — Standard XML Publisher anchor that initializes report-level variables and setup before data retrieval begins.
  • AFTERREPORT — Standard XML Publisher anchor executing after report generation completes, typically performing cleanup or finalization.
  • CP_ORIGINAL_BUDGETFORMULA — A formula program unit returning a value used to display the original budget amount in the output.
  • CF_ORIGINAL_BUDGETFORMULA — A column formula that formats or derives the original budget value for a report column.
  • CF_PERCENT_CHANGEFORMULA — A column formula computing the percentage change between budget figures for display.
  • CF_ACCT_FLEX_DESCFORMULA — A column formula that renders the concatenated accounting flexfield description.
  • CF_CURRENCY_CODEFORMULA — A column formula returning the currency code associated with report rows.
  • CF_DOCUMENT_POSTING_STATUSFORM — A formula that formats the document posting status for display.
  • CP_ORIGINAL_BUDGET_P — A procedure used within the report to process the original budget data.
  • CP_END_OF_REPORT_P — A procedure that signals end-of-report processing, often used to place totals or trailing sections.
  • CP_NO_DATA_FOUND_P — A procedure invoked when the query returns no rows, controlling the report's no-data handling.

Tables Accessed

The package references the table PSB_BUDGET_REVISIONS through APPS synonyms. This table stores the budget revision definitions and revision details for the Public Sector Budgeting application. The report package reads from this table to obtain the revision records, original budget amounts, currency information, and posting statuses that populate the budget revisions report output.

Usage Notes

PSB_PSBRPBRS_XMLP_PKG is not a general-purpose API and is not referenced by other packages, as documented (referenced by 0 other packages). It is tightly coupled to its consuming concurrent program and XML Publisher report template. It is invoked when the associated budget revisions report is executed from the Submit Requests form or via a scheduled concurrent request. Administrators and technical developers use it when troubleshooting report execution, modifying report formulas, or diagnosing data retrieval issues. Because it is an XMLP anchor package, changes should be coordinated with the corresponding data template and report definition. Its validity status should be verified after EBS patching or upgrades, since report-layer packages can be invalidated by dependency changes to PSB_BUDGET_REVISIONS or underlying PL/SQL libraries.