Search Results l_fr

Overview

The APPS.PQH_PQHEEO4_XMLP_PKG package body implements the server-side PL/SQL logic for the EEO-4 (Equal Employment Opportunity) report in Oracle E-Business Suite. It is a generated XML Publisher (BI Publisher) report integration package, identified by the _XMLP_PKG suffix and the $Header: PQHEEO4B.pls 120.1 2007/12/07 banner that places its origin in the PQH (Public Sector/HR) product family. The package exists to build the dynamic SQL, bind the EEO-4 report parameters, and assemble the runtime data set that the XML Publisher report template consumes. In Oracle EBS 12.1.1 and 12.2.2 the package is deployed under the APPS schema and classified as OTHER, meaning it is not a published public API but an internal report-support package.

EEO-4 reporting is a statutory U.S. federal filing that summarizes full-time and part-time employment by job category, race/ethnicity, and gender for state and local governments. The package therefore accumulates counts across those dimensions and formats them for the report output. The variable captured in the user search, l_ft, is one of the local PL/SQL declarations inside the package (adjacent declarations include L_FR, L_FT, L_PR, and L_PT) used to hold the full-time and part-time measure strings assembled by the report logic.

Key Procedures and Functions

• BEFOREREPORT — The before-report trigger function. It initializes the report run, sets C_REPORT_TYPE from P_REPORT_YEAR, declares the local report variables (including the l_ft full-time aggregate), derives the report date from P_REPORT_DAY_MONTH and P_REPORT_YEAR, and stages the dynamic SELECT_CLAUSE that counts employees by ethnicity (per_information1 values 1–7) and gender (M/F).
• AFTERREPORT — The after-report trigger, used for post-processing and cleanup once report data has been fetched.
• CF_TOTAL_TITLEFORMULA0005 — A formula column function that computes or formats the "Total" title used in the report layout, including the full-time/part-time subtotals.
• CF_SET_FUNCTION_DESCFORMULA — A formula column function that resolves and returns the descriptive text for a given function or work location grouping.
• CP_1_P — A report data-model group/query function associated with the first data group of the EEO-4 report.
• C_BUSINESS_GROUP_NAME_P — Supplies the business group name used in the report header.
• C_REPORT_TYPE_P — Returns the report type value (derived in BEFOREREPORT from the reporting year).
• C_ORGANIZATION_HIERARCHY_P — Returns the organization hierarchy parameter used to scope the report population.
• C_EEO1_ORGANIZATION_P — Returns the EEO organization parameter for the report.
• C_END_OF_TIME_P — Returns the effective end-of-time date used to bound the as-of query.

Tables Accessed

The documented metadata records a single referenced object, the DBMS_SQL built-in package, accessed via an APPS synonym. This confirms that the package constructs and executes SQL dynamically at runtime rather than relying solely on static cursors. The dynamic SELECT_CLAUSE shown in the source counts rows from PER_ALL_PEOPLE_F (aliased peo), joined to the EEO/establishment views that supply the organization hierarchy filter. Employee counts are disaggregated by per_information1 (ethnicity code) and sex, with full-time and part-time populations reported separately.

Usage Notes

PQH_PQHEEO4_XMLP_PKG is not invoked directly by end users or by other PL/SQL packages; the metadata records zero referencing packages. It is executed by the XML Publisher concurrent program that runs the EEO-4 report, which passes the standard report parameters (P_REPORT_YEAR, P_REPORT_DAY_MONTH, organization hierarchy, and business group) into the before-report, data-model, and after-report phases. Because it is generated report code owned by APPS, customization is not supported during EBS upgrades; any change to the EEO-4 layout or logic should be made through the report definition rather than by editing the package body.