Search Results pqh_pqhwspbd_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PQH_PQHWSPBD_XMLP_PKG is the generated PL/SQL package that backs the Oracle HRMS "Position Budget" (PQHWSPBD) report, a business intelligence output produced for the Public Sector / Position Management (PQH) module set. In Oracle EBS 12.1.1 and 12.2.2, concurrent programs that are implemented as XML Publisher (BI Publisher) reports are compiled from an RTF template plus a PL/SQL "package" that supplies the data, parameters, and derived columns. This package, whose header dates to 2007 (PQHWSPBDS.pls 120.1), is that generated wrapper. Its principal business purpose is to report budgeted, actual, committed, and projected expenditures for a given position or organization over a date range, together with variance amounts and percentages, so that administrators can monitor whether spending on a position is within its allocated budget.

The package exposes public bind variables corresponding to the report's concurrent program parameters — business group, session date, report title, concurrent request ID, start and end dates, position ID, organization ID, position type, variance percent, currency code, and effective date — and it populates global "CP_*" and "C_*" variables used by the template to render the report header.

Key Procedures and Functions

  • BEFOREREPORT — Initializes report-level parameters and header values before the main data fetch executes.
  • BEFOREPFORM — Performs the equivalent setup for the after-parameter form phase, resolving dependent parameter values.
  • AFTERREPORT — Clean-up / post-processing hook executed after the report's data model completes.
  • CF_1FORMULA and CF_FORMAT_MASK — Derived (calculation) formulas: CF_1FORMULA produces a computed amount from budget unit, actual, and committed values, while CF_FORMAT_MASK returns a number format mask for the given budget unit.
  • CF_ACT_PERFORMULA, CF_COM_PERFORMULA, CF_PROJ_PERFORMULA, CF_DEF_EX_PERFORMULA — Percentage formulas: each returns numerator / budgeted amount × 100 for actual, committed, projected, and "default excluding" amounts respectively.
  • CF_DEF_EX_AMTFORMULA — Computes the default-excluding amount (budgeted amount less projected expenditure).
  • CP_*_P and C_REPORT_SUBTITLE_P getters — Accessor functions (C_REPORT_SUBTITLE_P, CP_ORGANIZATION_NAME_P, CP_POSITION_NAME_P, CP_POSITION_TYPE_P, CP_CURRENCY_P, C_BUSINESS_GROUP_NAME_P, CP_SESSION_DT_P) that return the resolved global values to the report template. CP_POSITION_TYPE_P in particular returns the display name for the position type selected, and is the accessor most closely associated with the user's search term cp_position_type.
  • GET_BUSINESS_GROUP — Returns the business group name for a given business group ID.

Tables Accessed

Usage Notes

This package is not a public API; its classification is OTHER and no other package references it. It is invoked automatically by the XML Publisher / Concurrent Manager runtime when the PQHWSPBD concurrent program is submitted (typically from the Position Budget / Position Management responsibility). Administrators should never call its functions directly. The cp_position_type identifier is the global that the report template substitutes for the position type parameter, and is surfaced through the CP_POSITION_TYPE_P accessor.