Search Results addtl_child_flag

Overview

PAY_KR_YEA_MAGTAPE_PKG is a Korean localization package within the Oracle E-Business Suite Payroll module (APPS schema). Its name reflects its purpose: to support the generation of Year-End Adjustment (YEA) magnetic tape output for Korean payroll legislative reporting. The package header, dated 2008 and shipped under the 12.1.1 code line (120.5.12010000.7), establishes a set of global state variables that drive the production of statutory Korean year-end tax files — including flags for normal (g_normal_yea), interim (g_interim_yea), and revised (g_re_yea) year-end adjustments, together with identifiers for business place, target year, B-records, payroll action, assignment set, and the taxable and annual income/resident/standard tax identifiers.

These globals are populated as the package processes a payroll action and assembles the fixed-format records required by the Korean National Tax Service (NTS). The package is categorized under the ETRM API classification OTHER and is referenced by one other package, indicating it operates as a supporting utility within a broader Korean YEA reporting flow rather than as a standalone concurrent program.

Key Procedures and Functions

The ETRM metadata documents a single public program unit for this package:

• GET_TAX_REDUCTION_DATE — Returns the applicable tax reduction date used when computing Korean year-end adjustment reliefs. The date value feeds the taxable-base calculations and the corresponding magnetic tape record fields produced by the package's reporting cursors. No parameter list is asserted here, since only the name and purpose are documented.

The package header additionally declares a primary cursor (csr_a) that assembles the business-place and corporate header information — business group identifier, business place organization name, tax office code, business place registration number, corporate organization name, corporate name and number, corporate representative name, phone number, B-record count, and home tax identifier (via pay_magtape_generic.get_parameter_value). This cursor forms the header portion of the Korean YEA magnetic tape layout.

Tables Accessed

The documented synonym list confirms the data domain over which the package operates:

• HR_ORGANIZATION_INFORMATION — Supplies Korean statutory context values for the business place (KR_INCOME_TAX_OFFICE, KR_BUSINESS_PLACE_REGISTRATION) and corporate identifiers.
• HR_ALL_ORGANIZATION_UNITS_TL and HR_LOCATIONS_ALL — Provide organization names (business place and corporate) and contact telephone details for header records.
• PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS — Drive the payroll action and assignment set being reported.
• PER_ASSIGNMENT_EXTRA_INFO, PER_CONTACT_EXTRA_INFO_F, PER_ADDRESSES, PER_PERIODS_OF_SERVICE, and PER_ORG_STRUCTURE_ELEMENTS — Provide employee and assignment attributes (addresses, extra information, service dates, organization hierarchy) required for individual YEA records.
• FND_TERRITORIES — Resolves territory codes, typically the Korean country reference.
• FF_USER_ENTITIES — Supports Fast Formula user entity lookups used in deriving reportable values.

Usage Notes

PAY_KR_YEA_MAGTAPE_PKG is invoked indirectly in the Korean YEA reporting path. It is typically called from the Year-End Adjustment concurrent program or from a parent driver package (the single referencing package noted in ETRM), which sets g_payroll_action_id, g_assignment_set_id, g_target_year, and the YEA type flags before the header cursor and record-generation logic execute. Because it exposes global variables and cursors rather than a parameterized PL/SQL API, custom extensions should set the globals in the documented order and rely on GET_TAX_REDUCTION_DATE for relief date derivation. Deployments on 12.1.1 and 12.2.2 use the same shipped package; no online form calls it directly — it is a backend concurrent-program dependency. The addtl_child_flag search term is not part of the documented package metadata; users tracing that flag should confirm it resides in the calling form or a related Korean YEA routine rather than in this package's documented interface.