Search Results per_mx_full_name

Overview

APPS.HR_MX_UTILITY is a legislation-specific PL/SQL package that supports the Mexico (MX) localization of Oracle Human Resources in Oracle E-Business Suite 12.1.1 and 12.2.2. The package encapsulates Mexican statutory and business rules that govern person name formatting, legal employer derivation, tax subsidy calculation, seniority computation, and address derivation. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the defining schema, which is significant for packages that must be callable from forms, concurrent programs, and self-service flows under a variety of database users.

The header comment (hrmxutil.pkh 120.6.12010000.1) confirms the original design intent: the package exists primarily to support the Mexico full-name trigger. Over time it has been extended into a general utility library for Mexican HR processing, covering GRE (Global Reporting Entity / legal employer) resolution, tax subsidy percentages, work-related injury protection (WRIP), and hire anniversary and seniority calculations.

Key Procedures and Functions

The ETRM metadata documents 19 procedures and functions. The most prominent include:

• PER_MX_FULL_NAME — Supports the Mexico full-name trigger, accepting the standard person name components (first name, middle names, last name, known as, title, suffix, pre-name adjunct) plus 30 legislative information attributes, returning the formatted full name.
• GET_GRE_FROM_LOCATION — Resolves the legal employer (GRE) from a location, using business group and session date, with out parameters flagging ambiguity and missing GRE.
• GET_GRE_FROM_SCL — Derives the GRE from a soft coding keyflex identifier.
• GET_BG_FROM_PERSON — Returns the business group for a given person; the function matched by the user's search term.
• GET_BG_FROM_ASSIGNMENT — Returns the business group associated with an assignment.
• CHECK_BUS_GRP — Validates business group membership or configuration.
• GET_TAX_SUBSIDY_PERCENT — Computes the Mexican employment tax subsidy percentage.
• GET_WRIP — Returns work-related injury protection (Work Risk Insurance Premium) data.
• GET_LEGAL_EMPLOYER — Resolves the legal employer for a person or assignment.
• GET_HIRE_ANNIVERSARY — Calculates hire anniversary dates.
• GET_SENIORITY_SOCIAL_SECURITY — Computes seniority for social security purposes.
• GET_SENIORITY — General seniority calculation.
• GET_HIRE_DATE — Derives the hire date.
• GET_IANA_CHARSET — Returns the IANA character set identifier.
• CHK_ENTRY_IN_LOOKUP — Validates an entry against FND_LOOKUP_VALUES.
• DERIVE_HR_LOC_ADDRESS — Derives the HR location address.
• DERIVE_PER_ADD_ADDRESS — Derives the person address.

Tables Accessed

The package reads and writes through APPS synonyms across the HR, Payroll, and FND schemas:

• PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — Core person and assignment data, used by GET_BG_FROM_PERSON, GET_BG_FROM_ASSIGNMENT, seniority, and hire date functions.
• PER_PERIODS_OF_SERVICE — Supporting seniority and service calculations.
• HR_ALL_ORGANIZATION_UNITS and HR_SOFT_CODING_KEYFLEX — Used to resolve legal employer and GRE from organizational structures and soft coding.
• PAY_USER_ROWS_F — Payroll user-defined rows, typically for tax subsidy and WRIP values.
• PER_GEN_HIERARCHY, PER_GEN_HIERARCHY_NODES, PER_GEN_HIERARCHY_VERSIONS — Generic hierarchy data used in organizational derivation.
• FND_LOOKUP_VALUES — Lookup validation via CHK_ENTRY_IN_LOOKUP.
• FND_SESSIONS — Session context, used to establish effective dates and user context.
• DUAL and PLITBLM — Utility/scratch usage, PLITBLM being the standard PL/SQL table-to-integer mapping used by Oracle's character set utilities.

Usage Notes

HR_MX_UTILITY is an internal support package rather than a public API. It is referenced by 32 other packages in the E-Business Suite, and is typically invoked from Mexico-localized forms (such as the People and Assignment forms when the MX legislation is active), from the full-name trigger, and from payroll and tax reporting code that must derive GRE, tax subsidy, or seniority values. The GET_BG_FROM_PERSON function is commonly reached when a form or report has a person identifier and needs to establish business group context — for example, when validating flexfield segments or applying business-group-specific lookups.

Because the package is AUTHID CURRENT_USER and legislation-specific, it should not be called directly in custom code without reviewing the Mexico localization configuration. Oracle does not document these routines as supported public APIs in all releases, so custom extensions should treat them as internal and version-sensitive. Any change to person, assignment, or payroll data that triggers a full-name or legislative derivation will flow through this package, making it a dependency worth tracing during upgrades from 12.1.1 to 12.2.2.