Search Results pqh_pqhwsbpr_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.PQH_PQHWSBPR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package associated with the Public Sector/HR budgeting reporting infrastructure in the Oracle Payroll/HR (PQH) product family. Its name conforms to the standard EBS convention for a BI Publisher/XML Publisher report package: it is the database-side companion of a concurrent program that emits report data as XML. The "PQHWSBPR" identifier corresponds to a workspace or budget-position reporting layout, and the "_XMLP_PKG" suffix indicates the package is generated for and consumed by the XML Publisher engine.

The package declares AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer. The header (RCS version 120.1, dated 2007) contains report-level bind variables such as the business group, session date, concurrent request ID, budget version, effective date, record type, report title and subtitle, budget name and version, currency code, and business group name. These globals are populated before the report runs and are exposed through the "_P" accessor functions so that the XML Publisher template can reference their values.

Key Procedures and Functions

Eighteen documented program units make up the package. The lifecycle routines are BEFOREREPORT, which initializes state before the main query executes, BEFOREPFORM, which prepares data before the report body is formatted, and AFTERREPORT, which performs any post-processing at the end of the run.

The bulk of the package consists of report formatting functions that supply calculated columns to the XML layout. The CF_*FORMULA family contains the actual computation logic: CF_1FORMULA combines budget unit and actual and commitment values; CF_DEF_EX_AMTFORMULA and CF_DEF_EX_PERFORMULA compute a definition/exception amount and percentage from the budgeted value and projected expenditure; CF_ACT_PERFORMULA, CF_COM_PERFORMULA, and CF_PROJ_PERFORMULA derive actual, commitment, and projected percentages against the budgeted value; and CF_FORMAT_MASKFORMULA returns an appropriate numeric format mask for a given budget unit.

Accessor functions C_REPORT_SUBTITLE_P, CP_BUDGET_NAME_P, CP_BUDGET_VERSION_P, CP_CURRENCY_CODE_P, C_BUSINESS_GROUP_NAME_P, CP_SESSION_DT_P, and CP_RECORD_VALUE_P expose the package globals. GET_BUSINESS_GROUP resolves a business group name from its identifier.

Tables Accessed

The package reads and writes through APPS synonyms: FND_SESSIONS supplies session context; PER_SHARED_TYPES provides shared HR lookup values; PQH_BUDGETS and PQH_BUDGET_VERSIONS provide the budget header and version data that drive the report; and DUAL supports scalar computations. The package is not referenced by any other package, confirming its role as a terminal report consumer.

Usage Notes

This package is invoked automatically as the data source for its associated XML Publisher concurrent program; users do not call it directly. It is registered against the concurrent program definition and executes during the report request, using the concurrent manager session and the FND_SESSIONS context. Customizations should be limited to the configuration of the parent report rather than the generated package, because the _XMLP_PKG body is regenerated whenever the report definition changes and unsupported modifications will be overwritten.