Search Results pay_nl_eoy_pkg




Overview
Explore in AI Chat

Overview

APPS.PAY_NL_EOY_PKG is a Dutch localization PL/SQL package within Oracle E-Business Suite 12.1.1 and 12.2.2 that supports Netherlands End-of-Year (EOY) payroll processing and statutory tax reporting. The package encapsulates the business rules required to derive cumulative taxable income figures, holiday allowance balances, and retrospective adjustments for a given assignment, and to drive the annual EOY reconciliation that feeds Dutch tax authority reporting. In the ETRM metadata the API is classified as OTHER, indicating that it is an internal localization utility rather than a formally published public API. Its header comment block (pynleoy.pkh 120.1) confirms it was introduced for the Dutch EOY reporting cycle and remains part of the PAY localization layer.

Key Procedures and Functions

  • GET_PREV_YEAR_TAX_INCOME — Returns the prior-year taxable income for a person as of an effective date. Two overloads exist: one scoped to a payroll action, and one scoped only to the assignment and effective date.
  • GET_BALANCE_VALUES — Populates a set of OUT parameters with the standard, supplementary, retrospective, retrospective-current-quarter, and holiday allowance taxable income balances for an assignment, evaluated between the previous year-end date and the current period end date. Both year-to-date and period-to-date variants are returned.
  • RESET_OVERRIDE_LASTYR_SAL — Resets the override value of the previous-year salary flag across assignments, ensuring EOY calculations are re-derived from current balance data rather than stale manual overrides.
  • END_OF_YEAR_PROCESS — Orchestrates the annual EOY run, invoking the supporting functions and procedures to compute and persist the required income figures for the reporting period.
  • UPDATE_ASSIGNMENTS — The routine associated with the user search term "update_assignments". It applies the EOY calculation results back to assignment-level records, writing the derived previous-year salary, income, or override values so downstream reporting and subsequent payroll runs read consistent data.

Tables Accessed

The package reads and writes through APPS synonyms. Assignment and statutory data is sourced from PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES, PER_PERIODS_OF_SERVICE, PER_TIME_PERIODS, and PER_CAGR_GRADES_DEF, which supply the assignment, service period, payroll period, and grade context used in EOY calculations. Organization hierarchy and structure data come from PER_ORG_STRUCTURE_ELEMENTS and PER_ORG_STRUCTURE_VERSIONS. Payroll processing context is taken from PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS, while HR_SOFT_CODING_KEYFLEX provides costing/accounting flexfield values. FND_NEW_MESSAGES is used for user-facing messages, and DUAL is used for single-row computations.

Usage Notes

PAY_NL_EOY_PKG is typically invoked from the Dutch EOY concurrent program and from payroll localization code paths rather than directly by end users. UPDATE_ASSIGNMENTS, in particular, is called as the write-back step after cumulative balances have been assembled, so it should not be run outside the controlled EOY sequence. Because the package is classified as OTHER and versioned as an internal noship object, custom code invoking these routines must treat the signatures as subject to change across patches; developers should locate the shipped .pks to confirm current parameter lists rather than assuming API stability. The package is referenced by one other dependent package, confirming its role as a supporting utility in the Dutch payroll localization stack.