Search Results specified_date_absence




Overview
Explore in AI Chat

Overview

APPS.PAY_HK_AVG_PAY is a Hong Kong localization package body within the Oracle EBS Payroll (PAY) module. Its principal business function is to derive the correct time-period start date used when calculating average pay over a defined earnings window. Oracle Payroll for Hong Kong relies on this logic to support statutory average-pay computations — for example, severance, long-service, and related payments that reference earnings across a trailing period such as the twelve-month dimension _ASG_12MTHS_PREV. The header comment pyhkavgpay.pkb 120.0 indicates a release-12 family file, so the object exists in the 12.1.1 and 12.2.2 file systems with the same logical name; version differences between the two releases are limited to repository packaging rather than functional intent.

Key Procedures and Functions

  • TIME_START — The core public function. It opens a cursor named get_date_earned (the term the user searched for) that joins pay_payroll_actions and pay_assignment_actions to retrieve the date_earned and assignment_id for a given assignment action. It then applies a fallback sequence: first it attempts to obtain a start date from absence data, then from a specified-date element, and finally defaults to the earned date itself. The resolved date is shifted back thirteen months and adjusted with ADD_MONTHS and LAST_DAY + 1 to produce the opening boundary of the average-pay window.
  • SPECIFIED_DATE_ABSENCE — Retrieves a window start date when the trigger for the average-pay calculation is associated with an absence or attendance record.
  • SPECIFIED_DATE_ELEMENT — Retrieves a window start date when the trigger is driven by a specified-date element rather than an absence, forming the second tier of the fallback logic used by TIME_START.
  • NO_OF_DAYS — Computes the number of days within the derived averaging period, supporting downstream proration or daily-rate determination.

All four routines are internally scoped to the package and are not published as public APIs; the ETRM classification is OTHER.

Tables Accessed

The package reads payroll and HR data through APPS synonyms: PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS supply the earned date and assignment linkage; PER_ABSENCE_ATTENDANCES feeds the absence-based start date; PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F provide element-level entries and input values used to locate specified-date elements; PER_ALL_ASSIGNMENTS_F and PER_PERIODS_OF_SERVICE supply assignment and service context. The operations are read-only in the documented logic.

Usage Notes

PAY_HK_AVG_PAY is invoked indirectly during Hong Kong payroll processing, primarily from balance and element calculation routines that require a historical averaging window. It is referenced by one other package, indicating typical use from a payroll calculation wrapper rather than direct form invocation. Custom code extending average-pay logic for Hong Kong should call the public functions with the documented effective-date and assignment-action inputs. Debug output is governed by HR_UTILITY.DEBUG_ENABLED, so enable HR debug when tracing the date_earned derivation.