Search Results get_element_entry_id

Overview

The APPS.PAY_FI_EXPIRY_SUPPORT package body is a Payroll (PAY) module support utility that provides date-span calculation logic used during element entry expiry processing. In Oracle EBS 12.1.1 and 12.2.2, the package supplies helper functions that determine the correct start date of a payroll time span — month, quarter, year, or payroll period — relative to a given effective date or payroll action. Its central role is to support the expiry of recurring element entries (for example, court orders, holiday pay, and other dated element entries) when an employee's effective period changes, ensuring that expiring entries are terminated at the correct boundary rather than mid-period.

The package is classified in ETRM as an OTHER API, meaning it is not a public or supported integration interface but an internal payroll utility. It is referenced by no other documented packages, indicating it is invoked directly from payroll processing code or concurrent processes rather than exposed as a shared library.

Key Procedures and Functions

ETRM documents four public procedures and functions, of which two are named: COURT_ORDER_EC and HOLIDAY_PAY_EC. Both follow the _EC naming convention used for "end/expiry calculation" helpers and return span boundary dates used to determine when a associated element entry should expire.

• COURT_ORDER_EC — Supports expiry determination for court order element entries. Court orders are typically deducted on a recurring basis with defined start and end dates, and this function supplies the governing date used to decide whether an entry must be expired for the current processing span.
• HOLIDAY_PAY_EC — Supports expiry determination for holiday pay element entries, where payment entitlement is tied to specific qualifying periods or holidays. The function computes the relevant cutoff used to expire or retain the entry.

The source excerpt additionally reveals internal, non-documented span functions — month_ec, quarter_ec, year_ec, and period_ec — which return the start of the previous calendar month, quarter, year, or payroll period respectively using TRUNC and ADD_MONTHS relative to the effective date. These are private building blocks used by the public functions above.

Tables Accessed

The package reads from the following APPS-synonym tables:

• PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_TYPES_F — Identify the element entry and element definition being evaluated for expiry.
• PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS — Provide the payroll action context and effective dates driving the span calculation.
• PAY_BALANCE_DIMENSIONS — Supplies balance dimension context where expiry logic depends on balance accumulation.
• PER_ALL_ASSIGNMENTS_F — Determines the assignment and its effective dates.
• PER_TIME_PERIODS — Resolves payroll period start and end dates for the period-based span function.
• HR_ORGANIZATION_INFORMATION — Retrieves organization-level configuration relevant to the entry.
• DUAL — Used for scalar date computations.

Usage Notes

This package is not intended for direct customer invocation. It is called internally by Oracle Payroll during the expiry of recurring element entries, most commonly within the payroll run or a related expiry concurrent process. The user search term get_element_entry_id does not correspond to a documented public routine in this package; the documented public functions are COURT_ORDER_EC and HOLIDAY_PAY_EC. Developers investigating element entry expiry should therefore trace the element entry identifier through the payroll action and element entry tables listed above rather than through a function of that name in this package. Custom code should not call these helpers directly, as their signatures and behavior are subject to change across patch levels.