Search Results pay_mx_utility




Overview
Explore in AI Chat

Overview

PAY_MX_UTILITY is a shared PL/SQL utility package in the APPS schema that provides common helper routines for the Oracle EBS Payroll (PAY) and Human Resources (HR) modules in the Mexican (MX) localization. Its primary role is to centralize calculations and lookups that are reused across the Mexican payroll processing framework, including date and period computations, balance type resolution, classification creation, legislative parameter retrieval, and the determination of Mexican economic zone and minimum wage values. Owned by APPS and classified as a standard (non-API) utility, the package is validated and holds no public API designation, meaning it is intended for internal consumption by other Mexican localization components rather than as a supported external interface.

Key Procedures and Functions

The package exposes nineteen documented procedures and functions, grouped by purpose:

Tables Accessed

The package reads and writes across payroll and HR tables through APPS synonyms. Date and period logic draws on PER_TIME_PERIOD_TYPES and PAY_PAYROLL_ACTIONS. Balance-related functions query PAY_BALANCE_TYPES, PAY_BALANCE_ATTRIBUTES, PAY_BAL_ATTRIBUTE_DEFINITIONS, and PAY_DEFINED_BALANCES. Classification routines touch PAY_ELEMENT_CLASSIFICATIONS, PAY_ELE_TMPLT_CLASS_USAGES, and PAY_ELE_TMPLT_CLASS_USG_S. Organization context is supplied by HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION. Legislative parameters are read from PAY_MX_LEGISLATION_INFO_F. FND_SESSIONS provides session context, while DUAL and PLITBLM support generic query and large-object handling.

Usage Notes

PAY_MX_UTILITY is referenced by fifteen other packages and views, including HR_MX_UTILITY, PAY_MX_ANNUAL_WRI, PAY_MX_DIM_MAG, PAY_MX_FF_UDFS, PAY_MX_FORMAT_2D, PAY_MX_PTU_CALC, PAY_MX_SUA_MAG, PAY_MX_TAX_FUNCTIONS, PAY_MX_YREND_ARCH, and PER_MX_SS_AFFILIATION. It is therefore invoked indirectly whenever those Mexican payroll processes, archival routines, statutory reports, or fast formulas execute. It is not a concurrent program or form-level API itself, but rather a dependency that custom code extending the Mexican payroll localization may call for consistent date, balance, parameter, and minimum-wage handling. Because it is undocumented as a public API, customizations should treat these routines as internal and verify signatures against the specific EBS release (12.1.1 or 12.2.2) before reliance.