Search Results pay_mx_ptu_calc




Overview
Explore in AI Chat

Overview

PAY_MX_PTU_CALC is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Mexican payroll statutory requirement known as PTU (Participación de los Trabajadores en las Utilidades), the employee profit-sharing obligation mandated under Mexican labor law. The package encapsulates the calculation and processing logic that determines each worker's share of company profits, applying the rules, ranges, and payroll action context required by the Mexican localization for Oracle Payroll. Within Oracle EBS 12.1.1 and 12.2.2, PAY_MX_PTU_CALC acts as a supporting calculation engine invoked by the Mexican payroll processes rather than as a standalone user-facing program. The package status is documented as VALID, indicating that the compiled package and package body are present and free of compilation errors, with no invalid dependent objects reported. Its API classification in the ETRM 12.2.2 documentation is OTHER, reflecting that it is an internal, localization-specific utility rather than a published public API. It has no documented downstream references from other APPS packages, meaning it is a leaf-level component called during payroll processing rather than a shared library reused broadly across the application.

Key Procedures and Functions

The ETRM metadata documents six procedures or functions within PAY_MX_PTU_CALC. Each corresponds to a phase in the payroll action lifecycle, following the initialization/calculation/archive/deinitialization pattern used by Oracle Payroll localization packages:

  • GET_PAYROLL_ACTION_INFO — Retrieves payroll action context, such as the payroll action, assignment action, and related header information required to drive the PTU computation for a given run.
  • RANGE_CODE — Handles population range processing, identifying the set of assignments or elements over which the PTU calculation applies.
  • ASSIGNMENT_ACTION_CODE — Executes the core per-assignment logic that produces PTU results for individual employee assignments during the payroll action.
  • INITIALIZATION_CODE — Performs setup and preparatory work before calculation begins, establishing the working context for the payroll action.
  • ARCHIVE_CODE — Writes or preserves PTU results and audit information so the calculated values are retained after the payroll run completes.
  • DEINIT_CODE — Cleans up session state and releases temporary objects after processing concludes.

The procedure names only are documented; parameter lists are not published in the reference metadata and should not be assumed.

Tables Accessed

The package operates against a broad set of payroll and HR tables accessed through APPS synonyms. Payroll action and assignment action context is read from PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_ACTIONS_S, PAY_ACTION_CLASSIFICATIONS, PAY_ACTION_INFORMATION, PAY_POPULATION_RANGES, and PAY_TEMP_OBJECT_ACTIONS. Employee and assignment data is obtained from PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, and HR_ASSIGNMENT_SETS with HR_ASSIGNMENT_SET_AMENDMENTS. Element and organizational context is drawn from PAY_ELEMENT_TYPES_F, HR_ALL_ORGANIZATION_UNITS_TL, and HR_ORGANIZATION_UNITS. Batch information comes from PAY_BATCH_HEADERS, and lookup values are resolved through FND_LOOKUP_VALUES. Together these tables provide the population, assignment, element, and action metadata required to compute and archive PTU amounts during Mexican payroll processing.

Usage Notes

PAY_MX_PTU_CALC is not invoked directly by end users. It is called by Oracle Payroll when the Mexican PTU payroll action or element is processed, typically as part of a payroll run or a supplementary statutory calculation. Because the package follows the initialization, assignment action, archive, and deinitialization sequence, it integrates with the standard Oracle Payroll action framework rather than being scheduled as an independent concurrent program. Custom code and extensions in the Mexican localization should treat this package as internal and avoid direct calls, since its interface is not documented as a public API. Any functional or legislative change to PTU rules in Mexico is delivered through patching of this package, and the absence of dependent APPS packages means its behavior flows outward only through the payroll results it produces.