Search Results pay_kr_sep_pkg




Overview
Explore in AI Chat

Overview

PAY_KR_SEP_PKG is an Oracle EBS Payroll (PAY) package owned by the APPS schema, classified under the product's "OTHER" API category. The "KR" infix identifies it as part of the Korean localization layer of Oracle Payroll. Its name — SEP, for Separations — indicates that the package supports statutory payroll processing that occurs when an employee leaves a Korean organization. In the Korean statutory framework, termination triggers distinct calculations that do not arise during ordinary payroll runs: severance-related tax adjustments and settlement of employment insurance premiums. PAY_KR_SEP_PKG encapsulates the PL/SQL logic that derives those amounts so that they can be stored as payroll balance values and consumed by the standard payroll engine. The package exists in both 12.1.1 and 12.2.2, and ETRM records it as VALID in both releases.

Key Procedures and Functions

ETRM documents two entry points, both of which are calculation-oriented functions returning adjustment amounts rather than performing database maintenance:

  • GET_IYEA_TAX_ADJ — Returns the income tax adjustment applicable on separation. "IYEA" corresponds to the Korean year-end tax settlement concept, so this function computes the correction to withholding that arises when final remuneration and severance are assessed together at termination.
  • GET_IHIA_PREM_ADJ — Returns the employment insurance premium adjustment. "IHIA" reflects the Korean employment insurance contribution identifier, and the function determines the premium delta that must be applied on the employee's final payroll.

No parameter lists are published in the ETRM metadata; the documented behavior is limited to the return of these two adjustment values. Neither function is documented as performing DML against application tables.

Tables Accessed

The metadata records two referenced tables, both reached through APPS synonyms:

  • FF_USER_ENTITIES — The FastFormula user entity registry. The package relies on this table to resolve user-defined entities, most likely the input values and database items through which the Korean separation formulas supply taxable earnings and premium bases to the calculation routines.
  • PAY_BALANCE_TYPES — The payroll balance type definition table. The package consults this table to identify the balance types that hold the tax and premium adjustment results, ensuring the computed values are mapped to the correct balance for downstream reporting and statutory filing.

Because only balance type and user entity definitions are involved, the package is best characterized as a read-oriented calculation helper rather than a transactional API.

Usage Notes

PAY_KR_SEP_PKG is invoked indirectly. Korean separation and severance FastFormulas call GET_IYEA_TAX_ADJ and GET_IHIA_PREM_ADJ during payroll run processing for terminating employees, and the returned values are written into the appropriate balance. Because ETRM documents no package that references PAY_KR_SEP_PKG (zero referencing packages) and no calling forms or concurrent programs, customers should treat it as an internal localization component rather than a supported extension point. Any customization should be limited to reading its results through standard balance reporting or to wrapping the functions from a custom FastFormula; direct modification of the package body is unsupported and will be overwritten by patch application.