Search Results g_message_text

Overview

The APPS.PER_EEO_MAG_REPORT package body supports Oracle E-Business Suite's regulatory compliance reporting for the EEO-1 (Employer Information Report) and the related MAG (Minority and Affirmative Action Guidelines) reporting requirements imposed by the U.S. Equal Employment Opportunity Commission. Its principal function is to assemble, format, and emit the aggregated workforce demographic data and establishment-level identification data required for federal EEO filings, combining organization unit attributes, location details, and headcount counts by race, ethnicity, and gender.

The package header comment ($Header: peeeomag.pkb 120.10.12000000.7) confirms that the body is maintained at the 12.1.1/12.2.2 code level. Internally, the body declares three PL/SQL record types that mirror the structure of the EEO-1 report form: org_rec for organization and certification-officer data (company number, DUNS number, SIC and NAICS codes, payroll period, certifying official name and contact details), con_rec for consolidated totals such as a_1_total_mfc, and estab_rec for establishment-level data (unit number, unit name, address, city, state, ZIP, EIN, county, and the full matrix of demographic counts). A package-scoped variable g_package initializes to the literal string ' per_eeo_mag_report.', following the EBS convention of embedding the package name in error and message text for traceability.

Key Procedures and Functions

• EEO_MAG_REPORT — The single documented public procedure. It orchestrates extraction and formatting of EEO-1/MAG report data by iterating over organization units and their associated establishments, populating the org_rec, con_rec, and estab_rec structures, and generating the report output. The ETRM metadata documents no additional public subprograms; supporting logic is contained within the package body or invoked through other packages.

Tables Accessed

The package reads the following tables via APPS synonyms, consistent with the ETRM reference list:

• HR_ALL_ORGANIZATION_UNITS — Provides organization unit names, dates, and identifiers that populate the org_rec and estab_rec fields.
• HR_ORGANIZATION_INFORMATION — Supplies organization-level descriptive and classification attributes referenced by the report.
• HR_LOCATIONS_ALL and HR_LOCATION_EXTRA_INFO — Provide establishment addresses, city, state, ZIP, county, and DUNS-related or extended location attributes.
• PER_ALL_PEOPLE_F — The dated person record, used to determine employee demographics (race, ethnicity, gender) and to bind people to assignments.
• PER_ALL_ASSIGNMENTS_F — Links employees to their organization units and primary assignments, enabling headcount aggregation by establishment.
• PER_ASSIGNMENT_STATUS_TYPES — Determines which assignments represent active employment for EEO headcount purposes.
• PER_PEOPLE_EXTRA_INFO — Holds EEO-specific flexfield or descriptive information attached to person records.
• PER_GEN_HIERARCHY_NODES — Supports traversal of the organization hierarchy for consolidation and roll-up of establishment data.

Usage Notes

PER_EEO_MAG_REPORT is typically invoked from the Oracle HRMS EEO reporting concurrent program or from a report definition that calls the EEO_MAG_REPORT procedure. Because the package name is embedded in g_package, error messages raised during execution reference per_eeo_mag_report to aid diagnosis. The ETRM metadata records no packages that call this package, indicating it is invoked directly by concurrent programs or custom code rather than by another PL/SQL package. When troubleshooting output, the user's search term g_message_text is relevant: this is a common naming convention for the package-level message or buffer string variable used to hold formatted report lines or error text before emission, and values visible in g_message_text during a session provide the clearest window into what the procedure is constructing at runtime.