Search Results p_report_date

Overview

APPS.PQH_PQIPED7_XMLP_PKG is an Oracle E-Business Suite package body belonging to the Oracle HRMS (PQH) schema family, specifically the Public Sector/HR reporting modules often referred to as PQIP reports. This package is the supporting PL/SQL package for an XML Publisher (XMLP) concurrent program report, and its primary business function is to supply calculated aggregate values and derived metrics to the report's data model and layout. The "PQIPED7" naming convention indicates a specific edition or report definition (ED7) within the PQIP reporting series, typically used for workforce statistics, headcount reporting, and equal opportunity or staff composition analysis.

The package body contains helper functions, predominantly formula-based, that combine instructional and non-instructional headcount or personnel figures into consolidated totals. These functions allow the XML Publisher template to reference named columns rather than embedding complex arithmetic directly into the report SQL, thereby improving maintainability and consistency across report variants.

Key Procedures and Functions

The package exposes 30 documented program units, the majority of which are single-purpose formula functions. Each returns a computed value derived from two numeric inputs passed by the calling report query.

• CF_1FORMULA through CF_4FORMULA and CF_4FORMULA0004 — Consolidate non-instructional and instructional counts for defined population categories, contributing to report-level summary totals.
• CF_SUMAM_ALWMENFORMULA, CF_SUMAPMENFORMULA, CF_SUMAPWMENFORMULA — Compute combined totals for specific demographic or location groupings (for example, "AM/AL" and "AP" categories) by summing instructional and non-instructional components.
• CF_SUMHMENFORMULA, CF_SUMHWMENFORMULA, CF_SUMWNHMENFORMULA, CF_SUMWNHWMENFORMULA — Produce aggregate totals for the "H", "HW", "WnH" and related population segments, again by adding instructional to non-instructional values.
• CF_SUMURMENFORMULA, CF_SUMURWMENFORMULA, CF_SUMNH_OPMENFORMULA, CF_SUMNH_OPWMENFORMULA — Calculate totals for UR and NH/OP reporting categories used in the report's demographic breakdown sections.
• CF_SUMTMRMENFORMULA, CF_SUMTMRWMENFORMULA, CF_TOTMENFORMULA, CF_11FORMULA — Generate grand total and overall report figures, providing the consolidated numbers displayed in summary lines and headers.

All functions above are defined with two numeric parameters and return a numeric result, but parameter names are deliberately omitted here per documentation scope. They perform additive consolidation logic with no side effects on database state.

Tables Accessed

The package and its associated report query reference the following tables through APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS — Supplies organization/establishment context for grouping report output.
• PER_ALL_ASSIGNMENTS_F — Provides assignment-level data that forms the base population for headcount and demographic calculations.
• PER_ALL_PEOPLE_F — Supplies person-level attributes such as gender and personal details used in demographic breakdowns.
• PER_ASSIGNMENT_STATUS_TYPES — Filters assignments by active or relevant status types.
• PER_JOBS — Used to classify personnel into instructional and non-instructional job categories.
• PER_PAY_BASES and PER_PAY_PROPOSALS — Contribute pay-related and proposal-driven data elements to the report.
• PAY_US_RPT_TOTALS — A US payroll reporting totals table used to source pre-aggregated payroll figures.

Usage Notes

This package body is not intended for direct invocation by end users. It is typically referenced by the XML Publisher data model or a concurrent program's PL/SQL logic when the associated PQIPED7 report is submitted from the HRMS responsibility menu. Because it is a package body without a documented public API classification beyond "OTHER," and because no other packages reference it, its lifecycle is tightly bound to the specific concurrent program and XML template it supports. Customization should be avoided; any change to the formula functions risks altering the totals presented in the statutory or management report output and may affect downstream reconciliation. When troubleshooting report discrepancies, DBAs and developers should verify the underlying table data (particularly assignment status and job classification) before examining these formula functions, since the functions themselves perform straightforward addition and are unlikely to be the source of error unless the input values are incorrect.