Search Results get_ihia_prem_adj

Overview

PAY_KR_SEP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM metadata as an OTHER API. It supports the Korean localizations of Oracle Payroll, specifically the statutory separation and year-end settlement processing required for Korean employees. The package header declares AUTHID CURRENT_USER, meaning that all unqualified object references are resolved using the privileges and synonyms of the calling schema rather than those of the defining schema; callers must therefore hold the necessary grants or be operating within a schema whose synonym resolution reaches the underlying payroll tables.

The package exposes two standalone functions that compute adjustment amounts associated with separation and annual tax settlement events. Its naming convention reflects the Korean localization elements: iyea denotes year-end tax adjustment (YEA), and ihia denotes the Korean national health insurance adjustment (IHIA). The presence of only two entry points and no package-level state indicates a stateless utility package whose sole purpose is to derive amounts that are subsequently consumed by payroll element processing or by downstream reporting.

Key Procedures and Functions

• GET_IYEA_TAX_ADJ — Calculates the year-end tax adjustment amounts for a given payroll action. It returns three output amounts — an income tax adjustment, a resident tax adjustment, and a special tax adjustment — along with a numeric return value conventionally used as a status or success indicator. The inputs identify the assignment action and the business group that scope the calculation.
• GET_IHIA_PREM_ADJ — The function associated with the user search term get_ihia_prem_adj. It derives the Korean national health insurance premium adjustment amounts, returning separate output values for the employee share and the employer share of the premium adjustment. As with the tax function, it accepts an assignment action identifier and a business group identifier and returns a status value. This separation of employee versus employer contributions mirrors the dual-funded structure of the Korean health insurance regime and allows each component to be posted to the appropriate payroll balance.

Both functions use out NOCOPY parameters, a PL/SQL optimization that avoids copying large values on return and signals that the outputs are intended for immediate consumption by the caller.

Tables Accessed

ETRM metadata records two tables referenced through APPS synonyms:

• PAY_BALANCE_TYPES — the payroll balance type definition table. The package reads this to resolve the balance identifiers into which or from which the computed adjustment amounts are derived, ensuring the correct predefined balance feeds the tax and health insurance calculations.
• FF_USER_ENTITIES — the FastFormula user entity table, which stores the input and output definitions used by Oracle Payroll FastFormula. This indicates the computed adjustments are surfaced as FastFormula-visible values, allowing payroll elements to reference them during element processing.

Usage Notes

PAY_KR_SEP_PKG is invoked from Korean payroll localization flows, typically during separation processing and year-end settlement runs. Because the functions operate on assignment action identifiers, they are most naturally called from FastFormula, from payroll element processing logic, or from custom concurrent programs that iterate assignments within a business group. The package is documented as referenced by zero other packages, indicating it is a terminal consumer rather than a shared dependency, and that callers are expected to be application-level components or customer extensions rather than other delivered PL/SQL packages. Implementers integrating with it should confirm grants on the APPS synonyms and supply a valid business group and assignment action combination.