Search Results ni_date_of_birth
Overview
PAY_KR_FF_FUNCTIONS_PKG is a Korean localization package owned by the APPS schema in Oracle E-Business Suite (Oracle HRMS / Payroll). It contains the PL/SQL functions and procedures invoked by Oracle FastFormula (FF) definitions that support statutory payroll and legislative processing for the Republic of Korea. The package encapsulates Korean-specific derivation logic — national identifier (resident registration number) parsing, dependent classification, and age-based eligibility rules — and exposes it to FastFormula through a set of callable database functions. Because it is classified as OTHER rather than as a public API, it is intended for internal use by seeded Korean payroll formulas rather than as a general-purpose integration interface.
Key Procedures and Functions
The 52 documented entry points cluster into four functional groups.
- Legislative parameter and message utilities. GET_LEGISLATIVE_PARAMETER retrieves a legislative parameter value for a given payroll action, with an override default and an optional FastFormula flash cache. SET_MESSAGE_NAME, SET_MESSAGE_TOKEN, and GET_MESSAGE support construction and retrieval of localized error or informational messages emitted from formulas.
- National identifier (residence registration number) parsing. NI_COMPONENT returns the sex and date of birth components encoded within a national identifier. The convenience functions NI_SEX and NI_DATE_OF_BIRTH each return a single component; the latter is the function targeted by the search term ni_date_of_birth. Two overloads of NI_NATIONALITY (introduced under Bug 3172960) return nationality either directly from a national identifier or derived from an assignment and effective date.
- Age and year-end calculation. EOY_AGE supports year-end tax settlement processing by computing an age at a reference point. Additional age-related helpers are exposed to formulas for statutory age thresholds.
- Dependent and status classification flags. 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, and GET_NP_EXCEPTION_FLAG provide boolean-style determinations used to drive dependent allowances, insurance eligibility, and exemption rules.
Tables Accessed
The package reads and writes the standard Oracle HRMS payroll and person data model through APPS synonyms. Payroll context and results are drawn from PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_TYPES_F, and PAY_INPUT_VALUES_F. Person-level attributes and dependents are sourced from PER_CONTACT_RELATIONSHIPS, PER_CONTACT_EXTRA_INFO_F, PER_ASSIGNMENT_EXTRA_INFO, PER_DISABILITIES_F, and PER_KR_ADDRESSES (Korean address structures used for residency determination). FF_GLOBALS_F and FND_SESSIONS supply FastFormula global values and session context, including the flash-cache mechanism used by GET_LEGISLATIVE_PARAMETER.
Usage Notes
The package is invoked primarily from seeded Korean FastFormula definitions executed during payroll runs, year-end adjustment (YEA) processing, and statutory reporting. It is referenced by 18 other packages, confirming its role as a shared localization utility layer. Custom FastFormula can call NI_DATE_OF_BIRTH and the other functions directly from formula text, but because the package is not classified as a public API, customizations should treat its signatures as version-sensitive across 12.1.1 and 12.2.2. Direct PL/SQL invocation is possible for diagnostic or data-conversion purposes, but values derived from the national identifier should be validated against the corresponding PER_* records before use outside the payroll engine.