Results for “gre_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_EOSURVEY_PKG is a PL/SQL package body in the Oracle E-Business Suite Payroll (PAY) module that supports the EO Survey report, a U.S. federal Equal Employment Opportunity (EEO/EO) reporting obligation. The package defines the cursors, procedures, and functions required to extract, aggregate, and store workforce demographic and payroll data—race, gender, job, location, hours worked, and full-time-equivalent (FTE) counts—needed to produce the EO Survey output. It is classified as an OTHER API and is not designed as a public, callable business interface; rather it is an internal reporting utility.

The header comment identifies the creation of the package and documents a substantial change history spanning versions 115.0 through 115.17, with development entries from 2001 through 2007. Notable corrections include GSCC changes involving DBDRV and TO_DATE usage, promotion procedure changes, adjustments to the length of FEIN within the establishment type, handling of NULL hours worked in the FTE calculation, and modifications to cursor parameters used when counting persons and assignments. Bug references such as 3894120, 3941606, 3954458, and 3886008 indicate targeted fixes to demographic and date-handling logic.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions within the package:

• FIND_PERSONS — Populates the working set of persons/assignments to be surveyed, using an assignment_details cursor whose parameters were revised in later versions.
• APP_FIRE_COUNT — Computes applicant, hire, and termination counts for the survey period.
• P_INSERT — Inserts the assembled survey rows into the reporting totals table.
• HIRE_OR_FTE — Calculates hire counts and full-time-equivalent figures, incorporating NULL hours worked handling and future termination checking.
• GRE_NAME — Resolves or formats the establishment/company name, including the FEIN-related establishment typing.
• MINORITY — Determines minority status from race codes, including the case where an applicant's race code is NULL.
• PROMOTION — Counts promotions occurring within the survey period.
• MALE_FEMALE_COUNT — Aggregates employees by gender.
• JOB_RACE_INSERT — Inserts the job-by-race breakdown rows into the report totals.

Tables Accessed

The package reads and writes through APPS synonyms across payroll and HR schemas:

• PER_ALL_ASSIGNMENTS_F, PAY_ASSIGNMENT_ACTIONS, PER_ASSIGNMENT_STATUS_TYPES, PER_PERIODS_OF_SERVICE — assignment, action, status, and service history used to identify in-scope persons.
• PER_JOBS, PER_GEN_HIERARCHY_NODES, PER_GEN_HIERARCHY_VERSIONS — job and organization hierarchy resolution for survey reporting.
• HR_LOCATION_EXTRA_INFO, HR_ORGANIZATION_INFORMATION — establishment, location, and FEIN-level attributes.
• PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, PAY_BALANCE_DIMENSIONS — balance definitions and dimensions used to derive hours and pay.
• PAY_PAYROLL_ACTIONS, PAY_ACTION_INTERLOCKS — payroll action linkage for period processing.
• PAY_US_RPT_TOTALS — the U.S. reporting totals table that P_INSERT and JOB_RACE_INSERT write to; the location name is truncated to 80 characters before insertion.

Usage Notes

PAY_EOSURVEY_PKG is invoked indirectly during execution of the EO Survey report, typically launched as a concurrent program from the Payroll responsibility. Because the ETRM metadata records zero referencing packages, it is not a shared dependency of other delivered APIs and should be treated as a report-supporting object. Customizations should avoid direct calls to its internal procedures, since parameter signatures were altered repeatedly across patch versions. Any modification must preserve the tables' insert behavior, particularly the length constraints on FEIN and location name, to remain compatible with PAY_US_RPT_TOTALS.