Search Results prev_er

Overview

PAY_KR_AEI_API is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an API within the ETRM repository. It provides an alternative, programmatic interface to the Assignment Extra Information (AEI) infrastructure specifically for Korean statutory year-end tax reporting requirements. The package supports the Korea localization (KR) by allowing developers and integrators to create and maintain the context-specific AEI records that store employee tax adjustment data — such as housing loan interest repayment, stock savings, and long-term stock savings — against an assignment. Rather than requiring callers to navigate the generic PAY_ASSIGNMENT_EXTRA_INFO insert and update APIs directly, PAY_KR_AEI_API exposes a set of focused, purpose-named procedures that encapsulate the correct information type, context, and column mapping for the KR_YEA_* information categories. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema. The header identifies the package as internal development use only, so it is not intended as a public integration point.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions, organized as insert/update pairs across several year-end adjustment (YEA) contexts, plus a validation utility.

• INS_YEA_TAX_BREAK_INFO / UPD_YEA_TAX_BREAK_INFO — Create and modify the KR_YEA_TAX_BREAK_INFO AEI context record for an assignment, capturing tax break entitlements.
• INS_YEA_TAX_EXEM_INFO / UPD_YEA_TAX_EXEM_INFO — Create and modify the year-end adjustment tax exemption information for an assignment.
• INS_YEA_SP_TAX_EXEM_INFO / UPD_YEA_SP_TAX_EXEM_INFO — Maintain the special tax exemption AEI record associated with the year-end adjustment.
• INS_YEA_DPNTEDUC_TAX_EXEM_INFO / UPD_YEA_DPNTEDUC_TAX_EXEM_INFO — Maintain the dependent education tax exemption AEI record.
• INS_YEA_FW_TAX_BREAK_INFO / UPD_YEA_FW_TAX_BREAK_INFO — Maintain the foreign worker tax break AEI record.
• INS_YEA_OVS_TAX_BREAK_INFO / UPD_YEA_OVS_TAX_BREAK_INFO — Maintain the overseas tax break AEI record.
• INS_YEA_PREV_ER_INFO / UPD_YEA_PREV_ER_INFO — Maintain prior employer information used in aggregating year-end tax data.
• CHK_DATE_IN_CURRENT_YEAR — A validation function that confirms a supplied date falls within the current reporting year.

The documented insert procedure INS_YEA_TAX_BREAK_INFO accepts a validate-only flag, assignment and business group identifiers, an information type, and optional AEI information columns mapped to effective date, housing loan interest repayment, stock savings, and long-term stock savings.

Tables Accessed

The ETRM metadata does not enumerate specific base tables referenced through APPS synonyms for this package. By design, the procedures target the Assignment Extra Information table (PAY_ASSIGNMENT_EXTRA_INFO) and its associated context definitions, creating rows keyed by assignment, business group, and information type such as KR_YEA_TAX_BREAK_INFO. The package returns a new object version number on successful insert or update, consistent with AEI table maintenance. Business group identifiers and assignment identifiers act as the primary lookups.

Usage Notes

PAY_KR_AEI_API is typically invoked from Oracle Forms or custom PL/SQL that manages Korean year-end tax adjustment maintenance, or from concurrent/custom code loaded through the standard AEI API framework. Callers pass the validate flag to perform a dry run; on success the AEI record is created or updated, and on failure no record is written and an error message is returned. Because the header documents it as internal development use only and referenced by zero other packages, it should be treated as an internal helper rather than a supported public API.