Search Results eoy_age
Overview
PAY_KR_FF_FUNCTIONS_PKG is a Korean localization package body owned by the APPS schema in Oracle E-Business Suite. It provides a library of legislative "fast formula" helper functions used by Oracle Payroll during payroll processing for Korean (KR) legal entities. The package encapsulates country-specific statutory rules — national insurance (social insurance) determination, dependent classification, age-based eligibility, and legislative parameter lookups — so that payroll formulas, element eligibility rules, and payroll processes can invoke them consistently rather than embedding Korean statutory logic directly in user-defined formulas.
The object holds a VALID status in ETRM for both 12.1.1 and 12.2.2. Its API classification is OTHER, meaning it is a supporting utility package rather than a public, declarative API. Note that although the excerpt states the package body "is not referenced by any database object," ETRM additionally records that it is referenced by 18 other packages, reflecting its role as a shared localization library invoked by other Korean payroll packages such as PAY_KR_REPORT_PKG and HR_NI_CHK_PKG.
Key Procedures and Functions
The package exposes 52 documented procedures and functions. Representative members include:
- GET_LEGISLATIVE_PARAMETER — retrieves Korean legislative parameters (statutory thresholds, rates, and limits) for use inside fast formulas.
- SET_MESSAGE_NAME / SET_MESSAGE_TOKEN / GET_MESSAGE — message-handling utilities for defining and returning formatted messages (typically via FND_MESSAGE) for validation and reporting.
- NI_COMPONENT, NI_SEX, NI_NATIONALITY, NI_DATE_OF_BIRTH — return national insurance–relevant attributes and personal data required for contribution determination.
- EOY_AGE — computes age at end of year, supporting age-banded statutory rules.
- Dependent-classification functions — DPNT_SPOUSE_FLAG, AGED_DPNT_FLAG, ADULT_DPNT_FLAG, UNDERAGED_DPNT_FLAG, AGED_FLAG, SUPER_AGED_FLAG, DISABLED_FLAG, CHILD_FLAG, SINGLE_PARENT_CHILD_FLAG, ADDTL_CHILD_FLAG — return indicator flags that classify dependents for tax and insurance purposes.
- GET_NP_EXCEPTION_FLAG — returns an exception indicator relevant to non-Korean or non-resident (NP) handling.
Tables Accessed
The package body reads and writes payroll and HR data through APPS synonyms. Payroll results and entries are drawn from PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_ASSIGNMENT_ACTIONS, and PAY_PAYROLL_ACTIONS. Person and assignment context comes from PER_ASSIGNMENTS_F, PER_PEOPLE_F, PER_ASSIGNMENT_EXTRA_INFO, and PER_PEOPLE_EXTRA_INFO. Korean-specific address and contact detail is sourced from PER_KR_ADDRESSES, while dependent and disability classification relies on PER_CONTACT_RELATIONSHIPS, PER_CONTACT_EXTRA_INFO_F, and PER_DISABILITIES_F. Session, date, and globals context are supplied by FND_SESSIONS, FND_DATE, and FF_GLOBALS_F.
Usage Notes
PAY_KR_FF_FUNCTIONS_PKG is invoked at runtime from Korean payroll fast formulas, element eligibility criteria, and payroll processes, where its functions supply statutory values and dependent flags. It is also called by related localization packages (HR_NI_CHK_PKG, PAY_KR_REPORT_PKG, HR_GENERAL, HR_LEG_LOOKUPS, and HR_UTILITY) that perform national insurance checks and reporting. Custom code should call these functions rather than replicating Korean statutory logic, since the package centralizes rate and threshold maintenance and keeps downstream formulas compliant with legislative changes.