Search Results pqh_pqiped11_xmlp_pkg




Overview
Explore in AI Chat

Overview

The APPS.PQH_PQIPED11_XMLP_PKG package body is a generated Oracle XML Publisher (BI Publisher) report logic container delivered in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Public Sector / Human Resources product family under the PQH application short name, which governs position management, position hierarchies, and related workforce reporting. The package exists to drive the runtime execution of a specific XML Publisher concurrent program whose report short name follows the PQIPED11 convention. Its primary responsibility is to bind report parameters, execute the underlying SQL query against HR and payroll base tables, and produce the XML data set consumed by the report template for formatting. Because the object is a package body with status VALID in the APPS schema, it is an actively compiled component of the EBS database tier rather than a legacy artifact. The _XMLP_PKG suffix identifies it as part of the standard Oracle XML Publisher report packaging pattern, in which each registered report receives a dedicated PL/SQL package that centralizes query execution and computed column formulas.

Key Procedures and Functions

The documented interface exposes twenty-six program units. The majority are formula functions referenced directly by the report template to derive computed values at runtime:

Tables Accessed

The package reads from HR and payroll reporting tables through APPS synonyms. PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F supply the dated person and assignment records that define the report population. HR_ALL_ORGANIZATION_UNITS provides organizational context, while PER_JOBS, PER_PAY_BASES, PER_PAY_PROPOSALS, and PER_ASSIGNMENT_STATUS_TYPES enrich each row with job, pay basis, proposed pay, and status attributes. PER_PEOPLE_EXTRA_INFO and HR_LOOKUPS supply descriptive flexfield and lookup code translations. PAY_US_RPT_TOTALS holds summarized payroll reporting totals used in the aggregation formulas. The package also references PQH_EMPLOYMENT_CATEGORY and PQH_NR_ALIEN_PKG, the latter being a non-resident alien processing package used in Public Sector payroll contexts.

Usage Notes

This package is not intended for direct invocation. It is called by the XML Publisher concurrent program framework when the associated PQIPED11 report is submitted from the Submit Requests form or scheduled through the concurrent manager. Custom code should never call its formula functions directly, because parameter binding and global state are established by BEFOREREPORT. The ETRM metadata confirms the package is referenced by no other database object, reinforcing its role as a standalone report driver. Any modification should be treated as a patch to a seeded object and preserved through the standard EBS patching and customization registration process.