Search Results pay_fi_expiry_support




Overview
Explore in AI Chat

Overview

PAY_FI_EXPIRY_SUPPORT is an APPS-owned PL/SQL package within the Oracle E-Business Suite Payroll (PAY) module. Its name and procedure set indicate that it provides supporting logic for expiry-related processing of payroll entries, with a particular focus on Finnish (FI) legislative requirements. In Oracle EBS 12.1.1 and 12.2.2, the package is registered as VALID and is classified as "OTHER" in the ETRM API classification, meaning it is not a public, supported API but rather an internal utility invoked by other payroll components. The object has both a package specification and a package body, and it depends on the SYS.STANDARD package. ETRM documentation lists it as referenced by itself (APPS.PAY_FI_EXPIRY_SUPPORT) and by no other packages, confirming its role as a leaf-level utility rather than a shared framework component.

Key Procedures and Functions

The ETRM metadata documents two procedures within the package body:

  • COURT_ORDER_EC — Relates to court order processing for Finnish payroll. Court orders are legal deductions applied against an employee's pay, and this procedure supports the expiry logic that determines when such deductions cease or must be recalculated. The "EC" suffix denotes an element or entry classification context.
  • HOLIDAY_PAY_EC — Supports holiday pay processing, which under Finnish payroll rules follows specific accrual and expiry patterns. This procedure handles the expiry aspect of holiday pay balances and entitlements.

ETRM counts a total of four documented procedures/functions, though only the two above are named in the metadata excerpt. No parameter lists are documented, and none should be assumed.

Tables Accessed

The package accesses a consistent set of payroll and HR tables through APPS synonyms:

These tables are read primarily to determine whether a given element entry or balance has reached its expiry threshold under Finnish statutory rules.

Usage Notes

Because PAY_FI_EXPIRY_SUPPORT is classified as OTHER and is referenced by no other packages, it is not intended for direct invocation by customers. It is typically called from payroll element processing logic, most likely from the element's calculation or expiry routines during a payroll run, or from Finnish localization extensions to the Payroll module. Developers extending Finnish payroll should not call this package directly; instead they should use supported payroll APIs and element configuration. Direct modification of the package is unsupported and would be overwritten by patching.