Search Results p_eeo4_query

Overview

The package APPS.PQH_PQHEEO4_XMLP_PKG is the generated PL/SQL package that accompanies the Oracle E-Business Suite concurrent program XML Publisher (BI Publisher) report identified as PQHEEO4. In Oracle EBS 12.1.1 and 12.2.2, this report belongs to the Oracle Human Resources (HR) product family, and specifically addresses the statistical reporting obligations associated with Equal Employment Opportunity (EEO) reporting — the EEO-4 survey in which employers report the composition of their workforce by job category, salary range, and gender/ethnicity. The package encapsulates the report's data logic and the host variables that are populated by the Oracle Reports/XmlPublisher runtime engine before the report's data model executes.

The suffix _XMLP_PKG indicates that this package was autogenerated when the report was converted for XML Publisher delivery, and it carries the AUTHID CURRENT_USER declaration so that execution privileges are resolved against the invoking user rather than the package owner. The package does not implement business logic of its own; it is a thin wrapper of setters, getters, and helper formulas used by the report definition.

Key Procedures and Functions

• BEFOREREPORT — The pre-report initialization hook, invoked once before the report's data model is executed. It typically establishes session context and default parameter values.
• AFTERREPORT — The post-report cleanup hook, invoked after the data model completes.
• CF_TOTAL_TITLEFORMULA0005 — A column formula that computes the total title value used in the report output. It is one of several column formulas generated from the Oracle Reports layout.
• CF_SET_FUNCTION_DESCFORMULA — A column formula that resolves the English description of a job function code, given a job function code value.
• CP_1_P — Getter for the package variable CP_1, a numeric copy book (CP) value referenced inside the report's EEO4 SQL query.
• C_BUSINESS_GROUP_NAME_P — Getter for C_BUSINESS_GROUP_NAME, exposing the business group name for use in the report output.
• C_REPORT_TYPE_P — Getter for C_REPORT_TYPE, the report type indicator (full-time / part-time / new hires / etc.) that governs the union structure of the EEO-4 query.
• C_ORGANIZATION_HIERARCHY_P — Getter for C_ORGANIZATION_HIERARCHY, the organization hierarchy name driving the organizational scope of the report.
• C_EEO1_ORGANIZATION_P — Getter for C_EEO1_ORGANIZATION, the organization used for the EEO-1 organization context. This is the function matched by the user's search string c_eeo1_organization_p.
• C_END_OF_TIME_P — Getter for C_END_OF_TIME, the effective end date used to bound the employee population.

Tables Accessed

The only object explicitly recorded as referenced by this package is DBMS_SQL, the Oracle-supplied dynamic SQL package. The ETRM metadata lists no application tables referenced directly from this package; application table access is performed dynamically through the P_EEO4_QUERY variable, a VARCHAR2(20000) literal containing the SELECT statement against DUAL that seeds the report's XML data source. That SELECT statement itself performs no direct table access; the actual employee data is retrieved by the report's underlying query, not by this package.

Usage Notes

This package is invoked automatically by the XML Publisher concurrent program runtime for the EEO-4 report. Customers do not normally call it directly. The *_P getter functions are referenced from the report's RTF template or from the report trigger logic, and the setter variables (P_BUSINESS_GROUP_ID, P_REPORT_YEAR, P_CONC_REQUEST_ID, the P_MESSAGE_1 through P_MESSAGE_7 messaging variables, P_REPORT_DAY_MONTH, P_BPT_FT_EMP_COUNT, and P_BPT_EMP_COUNT_FUNC) are populated by the concurrent manager before BEFOREREPORT executes. Because it is a report-support package, it is not part of any documented public API; the ETRM classification for the object is OTHER, and no other packages reference it.