Search Results generate_ft_xml_data

Overview

APPS.PER_US_EEO4A_PKG is a United States–specific legislative reporting package delivered as part of the Oracle E-Business Suite HRMS (Oracle Human Resources) module. Its sole purpose is to support the EEO4A Report (XML) concurrent program, which produces the Employer Information Report (Standard Form 100, EEO-4) — a mandatory annual filing that US state and local government employers submit to the Equal Employment Opportunity Commission. The package file, peuseeo4a.pkh, carries a header version of 120.0.12020000.1 dated 2012/07/16, and the package body was originally created on 09-DEC-2011 under bug 13112110 for the EEO4A report, placing it firmly in the 12.1.1 and 12.2.2 code lines. The package is declared AUTHID CURRENT_USER, so its SQL executes with the privileges of the calling schema rather than the definer, a standard construction for APPS-owned report packages that read shared HR tables at runtime.

Key Procedures and Functions

The package exposes 19 documented routines. Several are generic utilities: DERIVE_SINGLE_RACE reduces multi-race person records to the single racial category required by EEO-4 reporting; CONVERT_INTO_XML escapes and wraps a name/value pair into XML markup with a supplied element type; GET_LOOKUP_MEANING returns the meaning for a lookup code; GET_FUNCTION_NUMBER and CHECK_FUNCTION resolve and validate job-function classifications; and GENERATE_SQL dynamically assembles query text.

Data population is handled by POPULATE_FT_EMP_DATA, POPULATE_OFT_EMP_DATA, and POPULATE_NH_EMP_DATA, which load the full-time, other-than-full-time, and new-hire employee aggregates into the package's emp_rec collection type. The POPULATE_NH_EMP_DATA routine is the procedure users reach for when troubleshooting new-hire headcount and demographic totals.

XML generation is performed by GENERATE_HEADER_XML_DATA, GENERATE_FOOTER_XML_DATA, GENERATE_JURIS_CERT_XML_DATA, GENERATE_FT_XML_DATA, GENERATE_OFT_XML_DATA, GENERATE_NH_XML_DATA, and the orchestrating GENERATE_XML_DATA. CREATE_XML and CREATE_REPORT assemble the final BI Publisher document, and WRITE_TO_CONCURRENT_OUT writes the generated XML to the concurrent manager output file. The record and table types emp_rec, func_rec, function_data, full_time_emp_data, other_full_time_emp_data, and new_hire_emp_data define the report's internal data model.

Tables Accessed

The package reads HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION to obtain the reporting organization and its classification data, and PER_PEOPLE_EXTRA_INFO to retrieve the EEO-4 specific extra information types that capture race, ethnicity, and gender attributes of employees. DBMS_SQL is used for dynamic cursor execution inside GENERATE_SQL, and PLITBLM provides the PL/SQL table-to-string conversion needed when emitting large XML fragments. All objects are referenced through APPS synonyms.

Usage Notes

PER_US_EEO4A_PKG is not an API; it is invoked internally by the EEO4A Report (XML) concurrent program. No other PL/SQL package references it. Users interact with it only indirectly, through the concurrent program's parameters (organization, reporting year, and similar selections). When diagnosing the populate_nh_emp_data path, ensure the requisite person extra information types are populated for new hires within the reporting period, and confirm the concurrent request log, since WRITE_TO_CONCURRENT_OUT is the terminal step and any upstream failure in the NH population or XML generation will surface there.