Search Results g_currency_code

Overview

APPS.PAY_MX_SOE_SS_PKG is a Mexican localization package in Oracle E-Business Suite that generates the "State of Earnings" (SOE) report content for social security reporting purposes. Its stated description in the package header is "This package is used to show SS SOE for Mexico." The package body encapsulates the SQL construction and currency formatting logic required to present employee earnings, tax calculations, balances, and benefit information in a format suitable for Mexican social security (Instituto Mexicano del Seguro Social, or IMSS) reporting.

The package forms part of the Oracle Payroll Mexican localization layer. It was originally created in August 2004 and evolved through several revisions, including changes to the underlying view naming conventions, addition of several balance-oriented functions, and the introduction of a parameter-setting routine. A notable revision in August 2005 replaced the legacy currency code MXP with MXN, reflecting Mexico's currency revaluation, which is directly relevant to the global variable g_currency_code maintained at package level and consumed by the currency-sensitive reporting functions.

Key Procedures and Functions

The package exposes eleven documented program units, each responsible for a distinct reporting dimension of the SOE output:

• EMPLOYEE_EARNINGS — Returns earnings data for an assignment action, serving as the foundational function for the SOE extract.
• EMPLOYEE_TAXES — Retrieves employee-level tax amounts associated with the payroll run.
• TAX_CALC_DETAILS — Supplies the detailed tax calculation breakdown for reporting.
• SUMMARY_BALANCES — Produces summarized balance information; a subsequent revision applied the _PAYMENTS dimension for prepayment amounts.
• HOURLY_EARNINGS — Extracts hourly earnings figures where applicable.
• TAXABLE_BENEFITS — Reports benefits subject to taxation under Mexican rules.
• TAX_BALANCES — Returns aggregated tax balance values.
• DEDUCTIONS — Provides deduction amounts for inclusion in the SOE.
• OTHER_BALANCES — Captures residual balance categories outside the primary groupings.
• SETPARAMETERS — Added in February 2005, this routine establishes runtime parameters, including the currency code that drives formatting throughout the package.

Tables Accessed

The package operates against core Oracle Payroll tables accessed through APPS synonyms. PAY_ASSIGNMENT_ACTIONS supplies the assignment action context that anchors the SOE extraction to a specific payroll run for an employee. PAY_PAYROLL_ACTIONS and PAY_RUN_TYPES_F provide the payroll action and run type definitions needed to qualify and classify the data returned. PAY_ACTION_INTERLOCKS participates in the action lifecycle, and PLITBLM is referenced as part of the standard payroll table-handling infrastructure. The global g_currency_code variable and the local lv_currency_code declare the currency context used when formatting monetary values.

Usage Notes

PAY_MX_SOE_SS_PKG is a localization utility rather than a general-purpose API. It is not referenced by any other documented package, indicating that it is invoked directly—typically from Oracle Forms-based SOE reporting screens or from custom concurrent programs built for Mexican payroll customers. Because its functions return LONG values containing SQL fragments, callers generally execute the returned statements dynamically to populate report outputs. Developers extending the SOE should invoke SETPARAMETERS first to establish the correct currency (MXN) and other runtime values, then call the individual data functions in the required order.