Search Results pay_se_holiday_pay




Overview
Explore in AI Chat

Overview

PAY_SE_HOLIDAY_PAY is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that encapsulates the holiday pay and absence entitlement logic used by the Swedish (SE) localization of Oracle Payroll. The package provides the calculation engine that determines how much holiday pay, vacation pay, saved pay, and related compensation an employee is entitled to during a given earning year, and it reconciles that entitlement against actual paid and unpaid days recorded in the system. It is a country-specific rules package, meaning its business logic reflects Swedish statutory holiday and vacation regulations rather than generic payroll behavior.

The package is classified as type OTHER in the ETRM 12.2.2 metadata, indicating it is not a public published API but an internal payroll engine component invoked through element formulas and payroll processing. It is reported as VALID and is not referenced by any other database object, although one referenced package dependency exists in the reverse direction, confirming that it functions as a leaf-level computational package rather than a shared service.

Key Procedures and Functions

The package exposes 33 documented procedures and functions. Their names cluster into several functional groups:

Because the ETRM excerpt does not publish signatures, parameter lists are not reproduced here; only the documented purpose of each routine is described.

Tables Accessed

The package reads and writes a broad set of payroll and HR tables through APPS synonyms. Payroll definition tables — PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_INPUT_VALUES_F, PAY_ELEMENT_ENTRIES_F, and PAY_ELEMENT_ENTRY_VALUES_F — supply element configuration and the entry values that drive calculation. PAY_USER_ROWS_F and PAY_USER_TABLES hold user-defined result columns populated by the processing. Fast Formula infrastructure (FF_DATABASE_ITEMS, FF_GLOBALS_F, FF_USER_ENTITIES) provides formula-level configuration. HR and person data come from PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_PEOPLE_EXTRA_INFO, PER_ASSIGNMENT_EXTRA_INFO, PER_PREVIOUS_JOB_USAGES, PER_ABSENCE_ATTENDANCE_TYPES, and PER_TIME_PERIODS, supporting absence and assignment analysis. Organization and scheduling context is retrieved from HR_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_LOC_WORK_SCHEDULE, and HR_SOFT_CODING_KEYFLEX. Balance validation uses PAY_BALANCE_PKG, and numeric rounding uses FND_NUMBER.

Usage Notes

PAY_SE_HOLIDAY_PAY is normally invoked indirectly. Swedish payroll elements and their associated Fast Formulas call these routines during payroll runs, absence processing, or dedicated holiday pay calculation processes, so customers rarely call the package directly from custom code. It may also be reached from concurrent programs or from the entitlement recalculation routines that periodically re-evaluate saved holiday balances. Because it is an internal, localization-specific package with no documented public API contract, it should not be called from custom PL/SQL without careful regression testing, and its logic should be treated as subject to change with payroll legislative patches applied to the 12.1.1 or 12.2.2 environment.