Search Results pay_mx_tax_functions




Overview
Explore in AI Chat

Overview

PAY_MX_TAX_FUNCTIONS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that centralizes Mexican statutory payroll tax logic for Oracle Payroll. Its principal business purpose is to support the calculation of Mexican income tax (ISR, Impuesto Sobre la Renta) and related state-level tax obligations, including employment subsidy adjustments, economic zone treatment, and minimum wage considerations. The package encapsulates the country-specific rules required to derive taxable earnings, evaluate employee eligibility and exemption criteria, and compute final tax amounts within the payroll run.

The package is classified in the ETRM documentation as an OTHER API rather than a public or private PL/SQL API, indicating that it is an internal implementation object invoked by Oracle's seeded Mexican payroll processes rather than a supported integration point for external callers. Its status is recorded as VALID in the APPS schema. The package body and specification contain embedded SQL statements and, apart from a SYS.STANDARD reference, no other package-level dependencies are documented, which reflects a self-contained design built on direct table access and callable utility routines.

Key Procedures and Functions

The 12.2.2 documentation identifies twenty-one callable routines. These fall into several functional groupings:

Tables Accessed

The package reads Oracle Payroll and HR tables through APPS synonyms. Payroll definition and processing context come from PAY_ALL_PAYROLLS_F, PAY_ASSIGNMENT_ACTIONS, and FF_USER_ENTITIES. Balance and element data are drawn from PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, PAY_BALANCE_DIMENSIONS, PAY_ELEMENT_CLASSIFICATIONS, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_ELEMENT_ENTRIES_F, and PAY_ELEMENT_ENTRY_VALUES_F, which together supply the earnings, input values, and classification metadata needed for tax computation. Organization and legislative context is obtained from HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, and HR_SOFT_CODING_KEYFLEX, supporting economic zone, state, and employer attribute determination. FND_SESSIONS provides session context for the executing environment.

Usage Notes

PAY_MX_TAX_FUNCTIONS is invoked indirectly by the seeded Mexican payroll tax processes. The ETRM dependency record documents that it is referenced by the package APPS.PAY_MX_PTU_CALC, which handles Mexican profit-sharing (PTU) calculations, and by itself through internal calls, with two other packages also referencing it. It is not intended to be called directly from custom code; customers requiring Mexican tax behavior should rely on the seeded payroll elements, element links, and balance feeds that drive these routines. Because the package is an internal object, its procedures and signatures may change without notice in patches or upgrades, and any customization that calls it directly carries upgrade risk. Functional validation is best performed by running the Mexican payroll processes and reviewing the resulting ISR and state tax results, rather than unit-testing package procedures in isolation.