Search Results get_process_parameters

Overview

APPS.PAY_MX_UTILITY is a Mexico-specific payroll utility package body within the Oracle E-Business Suite Payroll (PAY) module. It centralizes a set of reusable PL/SQL routines required by Mexican statutory payroll processing, including balance unit-of-measure conversions between days and hours, calendar calculations for pay periods, minimum wage and economic zone lookups, and helper functions for element template classification. The package is documented as an OTHER classification API in ETRM 12.2.2 and is owned by APPS. Its header revision ($Header: pymxutil.pkb 120.6.12010000.4) confirms it is delivered as part of the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The package exposes nineteen documented procedures and functions. The balance-related helpers—GET_DAYS_BAL_TYPE_ID and GET_HOURS_BAL_TYPE_ID—resolve the balance type identifier associated with the Earnings Days and Hours attributes for legislation MX, using a cached global PL/SQL table (days_bal_tbl) to avoid repeated queries. GET_DAYS_YR_FOR_PAY_PERIOD, GET_DAYS_MONTH_YEAR, GET_DAYS_IN_YEAR, GET_DAYS_IN_MONTH, GET_DAYS_IN_PAY_PERIOD, and GET_DAYS_IN_BIMONTH perform calendar arithmetic to derive day counts for payroll periods, months, bimonthly periods, and years, which are essential for accrual and proration logic in Mexican payroll. GET_NO_OF_DAYS_FOR_ORG returns day counts scoped to a specific organization.

The parameter and localization helpers—GET_LEGI_PARAM_VAL, GET_PARAMETER, and GET_PROCESS_PARAMETERS—retrieve legislation-level values, generic parameters, and the runtime parameter set for a payroll process, respectively. GET_DEFAULT_IMP_DATE supplies a default import date. GET_MX_ECON_ZONE and GET_MIN_WAGE return the Mexican economic zone and minimum wage values used in statutory calculations. Classification utilities—GET_CLASSIFICATION_ID, CREATE_ELE_TMPLT_CLASS_USG, and CREATE_TEMPLATE_CLASSIFICATION—support element template classification setup and usage records.

Tables Accessed

The package reads (and in some cases writes) the following APPS-synonym tables. PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, PAY_BALANCE_ATTRIBUTES, and PAY_BAL_ATTRIBUTE_DEFINITIONS are joined to resolve balance type IDs and UOMs for the Mexico 'Earnings Days' attribute. PER_TIME_PERIOD_TYPES supplies period definitions for the calendar-day calculations. PAY_PAYROLL_ACTIONS and PAY_ELEMENT_CLASSIFICATIONS support action and classification lookups. PAY_ELE_TMPLT_CLASS_USAGES and PAY_ELE_TMPLT_CLASS_USG_S are used by the classification creation utilities. HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION provide the organization context for GET_NO_OF_DAYS_FOR_ORG. PAY_MX_LEGISLATION_INFO_F holds Mexico legislation parameters, FND_SESSIONS supports session context, DUAL is used for scalar evaluation, and PLITBLM is the PL/SQL table type base referenced by the package.

Usage Notes

PAY_MX_UTILITY is invoked primarily from Mexico payroll business logic rather than directly by end users. It is referenced by fifteen other packages, indicating it functions as a shared internal utility called by element template processing, payroll run calculations, and statutory reporting routines. The get_process_parameters routine is typically called at the start of a concurrent payroll process to load the parameter set (payroll ID, effective date, consolidation set, and related options) into the calling program. Customizations or extensions targeting Mexican payroll should call these functions rather than reimplementing calendar, minimum wage, or economic zone logic, ensuring consistency with Oracle-delivered statutory calculations. Because the global days_bal_tbl is package-scoped, developers should be aware that its cached contents persist for the duration of a database session.