Search Results psb_psbbgasr_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.PSB_PSBBGASR_XMLP_PKG package is a report logic container generated by Oracle Reports and registered within the Oracle E-Business Suite environment. Its name follows the standard EBS convention for report-implementing PL/SQL packages, where the XMLP suffix indicates the package was produced for the XML Publisher (BI Publisher) generation path of a concurrent report program, and the PSB prefix identifies it as belonging to the Public Sector Budgeting (PSB) product family. The report identifier PSBBGASR corresponds to a Public Sector Budgeting budget group activity summary report.

The package encapsulates the server-side PL/SQL logic that the report definition invokes during its execution lifecycle, including report-level format triggers, user exit routines, and parameter accessors. It does not represent a public business API; the ETRM classification records it as OTHER, confirming that it is an internal technical object rather than a supported integration interface.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions that fall into three functional groupings.

  • Report lifecycle triggers: BEFOREREPORT, AFTERREPORT, and BETWEENPAGE correspond to the standard Oracle Reports report-level and page-level format triggers. BEFOREREPORT prepares report state prior to execution, AFTERREPORT performs cleanup and finalization, and BETWEENPAGE allows logic to be applied between page breaks.
  • Flexfield value handling: CF_FLEXFIELD_HIGHFORMULA, CF_FLEXFIELD_LOWFORMULA, and CF_USER_EXIT_DUMMYFORMULA supply the high and low ranges of a key flexfield range used for the report's accounting flexfield parameter selection, together with a placeholder user exit required by the report definition.
  • Concurrent parameter accessors and column populations: P_STRUCT_NUM_P, CP_FLEXDATA_HIGH_P, CP_FLEXDATA_LOW_P, CP_SET_OF_BOOKS_NAME_P, CP_BUDGET_GROUP_NAME_P, CP_PRINT_SUBGROUPS_P, CP_NO_DATA_FOUND_P, and CP_END_OF_REPORT_P provide the getter/setter plumbing for the report's concurrent program parameters (structure number, low and high flexfield data, set of books name, budget group name, and the print subgroups flag) and the derived column values used to render "no data found" and end-of-report indicators in the output.

Tables Accessed

The package references PSB_BUDGET_GROUPS through an APPS synonym. This table stores the budget group definitions maintained within Public Sector Budgeting and is read to resolve the budget group name and its associated hierarchy and reporting structure needed by the activity summary report. No other application tables are documented as dependencies. The only additional references recorded are to SYS.STANDARD, the standard PL/SQL package that underpins all PL/SQL execution.

Usage Notes

PSB_PSBBGASR_XMLP_PKG is invoked exclusively at runtime by the Oracle Reports engine when the associated Public Sector Budgeting budget group activity summary concurrent request executes. It is not called directly from Oracle Forms, and ETRM records zero downstream packages referencing it, confirming it sits at the leaf of the dependency chain apart from the report definition itself. Its status is VALID, and it is present in both Oracle EBS 12.1.1 and 12.2.2. Because the package is auto-generated report scaffolding, customizations should not modify it in place; the supported approach is to copy and rename the report and its generated package, leaving the seeded object untouched during patching and upgrades.