Search Results pay_mx_yearend_rep




Overview
Explore in AI Chat

Overview

The APPS.PAY_MX_YEAREND_REP package is a Mexican localization utility within Oracle E-Business Suite Payroll (PAY). Its business purpose is to supply aggregated year-end balance figures required for statutory Mexican payroll reporting. Specifically, it supports the calculation of annual earnings balances used to satisfy Mexican tax and social security reporting obligations, including the annual income certification ("constancia de percepciones") and related year-end declarations that employers must produce for each employee.

The package is defined as AUTHID CURRENT_USER, meaning its stored procedures execute with the privileges of the invoking schema rather than the defining schema. This is significant because the package reads directly from payroll balance and archive tables owned throughout the HR/Payroll schema, and it allows a calling session operating under its own privilege model to query those objects without requiring APPS-owner execution context. The package header carries the identifier paymxyearend.pkh, version 120.1, indicating it originates from the 12.1 code line and has remained stable across 12.1.1 and 12.2.2 application releases.

The classification of this package as OTHER denotes that it is a supporting internal API rather than a public, documented business interface. It is intended for consumption by other payroll localization programs and reports rather than by end users directly.

Key Procedures and Functions

The documented package interface contains two functions, both returning numeric results:

  • GET_YE_ARCH_BAL_AMT — Retrieves an archived year-end balance amount for a given payroll action, person, effective date, and balance name. As the name suggests ("YE" for year-end, "ARCH" for archive), this function draws from archived balance data, which is essential because year-end reporting frequently requires balances captured at a point in time that may no longer be present in live payroll run tables.
  • GET_F37_BALANCE — Retrieves a specific balance value associated with the F37 reporting construct, again parameterized by payroll action, person, effective date, and a balance name. The "F37" designation references a Mexican fiscal reporting form, and this function isolates the balance extraction logic needed to populate that declaration.

The existing metadata does not document the full parameter lists as published reference material; the header excerpt confirms only the general shape of the signatures (payroll action identifier, person identifier, effective date, and balance name). No additional procedures are exposed in the documented interface.

Tables Accessed

The package reads from a substantial set of APPS synonyms spanning payroll balancing, payroll action, and descriptive flexfield archive infrastructure:

Usage Notes

This package is typically invoked as a helper library by Mexican year-end payroll reports and concurrent programs, and it is referenced by at least one other package within the application. Callers supply a payroll action identifier, person identifier, effective date, and balance name, and receive a numeric balance in return. Because the package uses AUTHID CURRENT_USER, invoking sessions must have appropriate read privileges on the underlying payroll and flexfield objects. The metadata does not document direct form invocations, so the package is best regarded as internal localization infrastructure supporting year-end statutory reporting rather than a user-facing interface.