Search Results g_interim_yea

Overview

APPS.PAY_KR_YEA_DON_EFILE_PKG is a Korean localization package body responsible for generating Year-End Adjustment (YEA) donation e-filing output. Its internal package name, pay_kr_yea_don_efile_pkg, and the shipped header file pykrydef.pkb (version 120.1.12010000.1) confirm that it belongs to the Oracle Payroll Korean legislative extension layer. The package is designed for execution inside the Oracle E-Business Suite concurrent manager runtime, where it produces the structured donation deduction data required for Korean year-end tax settlement reporting to the tax authority.

The package operates exclusively in the performance of a single payroll action, reading its parameters from the concurrent request through pay_magtape_generic.get_parameter_value rather than accepting an explicit parameter list. This design is typical of Oracle Payroll "magtape" style e-file programs, which are configured as concurrent programs and driven by the Payroll Action parameters (PAYROLL_ACTION_ID, TARGET_YEAR, ASSIGNMENT_SET_ID, REPORT_TYPE).

Key Procedures and Functions

The ETRM metadata records no publicly documented procedures or functions for this package. The body excerpt shows a package initialization section that executes on first invocation within a session. It contains one private helper function, user_entity_id, which resolves a user entity identifier from the FF_USER_ENTITIES table for a given user entity name under legislation code 'KR' and creator type 'X'. The package uses this to obtain g_donation_exem_archive, the archived donation tax exemption user entity ('X_YEA_DONATION_TAX_EXEM').

The initialization block also declares global package state variables, including g_payroll_action_id, g_target_year, g_assignment_set_id, g_donation_exem_archive, g_normal_yea, g_interim_yea, and g_re_yea. These globals are populated from concurrent program parameters and control which report variants execute.

Tables Accessed

The package references the following tables via APPS synonyms: HR_ALL_ORGANIZATION_UNITS_TL, HR_ORGANIZATION_INFORMATION, PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PER_ASSIGNMENT_EXTRA_INFO, and PER_ORG_STRUCTURE_ELEMENTS. HR_ALL_ORGANIZATION_UNITS_TL and HR_ORGANIZATION_INFORMATION supply the legal employer and organization-level attributes needed to identify the reporting entity and its tax registration details. PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS provide the payroll action context and assignment-level action records selected for the target year and assignment set. PER_ASSIGNMENT_EXTRA_INFO and PER_ORG_STRUCTURE_ELEMENTS supply assignment-level descriptive flexfield data and organization hierarchy information used to classify employees for donation e-filing.

Usage Notes

The package is referenced by one other package, indicating that it is typically invoked indirectly rather than called directly by end users. In Oracle EBS 12.1.1 and 12.2.2, it is expected to be submitted through a Korean payroll concurrent program, either directly from the Submit Requests form or as part of a request set for year-end adjustment processing. When PAYROLL_ACTION_ID is null, the package derives its operating mode from the REPORT_TYPE parameter: 'N' sets the normal YEA flag (g_normal_yea), 'I' sets the interim YEA flag (g_interim_yea), 'R' sets the re-report flag (g_re_yea), and combinations 'NI' or 'NR' enable multiple output modes simultaneously. When no REPORT_TYPE is supplied, the package defaults to interim YEA behavior (g_interim_yea := 'I'). The variable name g_interim_yea that prompted the search is thus a global package flag controlling whether interim year-end adjustment donation data is included in the e-file output. Because the package body is a single initialization block without exposed APIs, there are no supported customization entry points; any extension should be handled through a wrapper concurrent program or by copying the package under a custom prefix.