Search Results ins_yea_prev_er_info
Overview
APPS.PAY_KR_AEI_API is a Korea-specific payroll assignment extra information API within Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Payroll (PAY) module and is responsible for creating and maintaining the Korean statutory extra information records that Payroll stores against an assignment through the Assignment Extra Information (AEI) framework. These records capture the year-end adjustment and tax reporting attributes required by Korean payroll legislation, including tax break information, tax exemption data, prior employer information, and foreign worker tax attributes.
The package follows the standard Oracle EBS API pattern: each logical business entity is supported by a paired insert and update procedure, both of which accept a p_validate parameter that allows the caller to run the API in validation-only mode without committing data. Every procedure validates that the target business group exists and that its legislation code is 'KR' before proceeding, raising HR_7208_API_BUS_GRP_INVALID or HR_7961_PER_BUS_GRP_INVALID as appropriate. The package is classified as an API and is intended for programmatic maintenance of the underlying AEI rows rather than direct table manipulation.
Key Procedures and Functions
The package exposes fifteen documented procedures and functions, organised as insert/update pairs over the Korean AEI information types, plus one date validation utility.
INS_YEA_TAX_BREAK_INFO— creates a year-end adjustment tax break extra information record for an assignment.UPD_YEA_TAX_BREAK_INFO— updates an existing tax break extra information record.INS_YEA_TAX_EXEM_INFO— creates a tax exemption extra information record.UPD_YEA_TAX_EXEM_INFO— updates an existing tax exemption record.INS_YEA_SP_TAX_EXEM_INFO— creates a tax exemption record for a specified person or special category.UPD_YEA_SP_TAX_EXEM_INFO— updates an existing specified-person tax exemption record.INS_YEA_DPNTEDUC_TAX_EXEM_INFO— creates a dependent education tax exemption record.UPD_YEA_DPNTEDUC_TAX_EXEM_INFO— updates an existing dependent education tax exemption record.INS_YEA_FW_TAX_BREAK_INFO— creates a foreign worker tax break record.UPD_YEA_FW_TAX_BREAK_INFO— updates an existing foreign worker tax break record.INS_YEA_OVS_TAX_BREAK_INFO— creates an overseas tax break record.UPD_YEA_OVS_TAX_BREAK_INFO— updates an existing overseas tax break record.INS_YEA_PREV_ER_INFO— creates a previous employer extra information record, the object behind the user search term ins_yea_prev_er_info. It captures details of an employee's prior employment that must be carried into the year-end adjustment calculation.UPD_YEA_PREV_ER_INFO— updates an existing previous employer record.CHK_DATE_IN_CURRENT_YEAR— a utility function that validates whether a supplied date falls within the current payroll year, used to enforce period integrity on the AEI records above.
Tables Accessed
The implementation shown in the header references PER_BUSINESS_GROUPS through the common CHECK_BG_LC helper, which reads legislation_code to confirm the business group is Korean. The insert and update procedures themselves operate against the Payroll assignment extra information storage used by the AEI information types listed above; the ETRM metadata does not enumerate these under APPS synonyms, but the naming convention and the p_assignment_extra_info_id output parameter confirm that writes target the assignment extra information entity rather than a standalone payroll table.
Usage Notes
PAY_KR_AEI_API is invoked from Korean payroll forms, from year-end adjustment concurrent processes, and from custom PL/SQL that must maintain Korean tax attributes on an assignment. Callers normally pass p_validate => true first to confirm the business group and legislation checks succeed, then call again with p_validate => false to commit. The procedures return the object version number and the assignment extra information identifier so callers can chain updates. No other package in the ETRM inventory references this API, so it should be treated as an entry point rather than a shared utility.