Search Results pay_kr_yea_don_efile_conc_pkg




Overview
Explore in AI Chat

Overview

PAY_KR_YEA_DON_EFILE_CONC_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Korean localization for Year-End Adjustment (YEA) electronic filing, specifically the Donation (DON) e-file submission. The package name breaks down as follows: PAY (Payroll), KR (Korea), YEA (Year-End Adjustment), DON (Donation), EFILE (Electronic File), CONC (Concurrent Program). Its primary business purpose is to assemble and submit donation-related year-end adjustment data to the Korean tax authority (National Tax Service) via an electronic filing interface, typically driven by a concurrent program.

The package is classified as OTHER in the ETRM API classification and is marked VALID in release 12.2.2. Its internal helper procedures and the presence of a concurrent-oriented design indicate that it works alongside the broader Korean payroll localization stack, particularly the parent package PAY_KR_YEA_DON_EFILE_PKG, which references it.

Key Procedures and Functions

The ETRM metadata documents three procedures/functions within this package:

  • SUBMIT_EFILE — The main driver procedure that orchestrates the electronic file submission process for Korean YEA donation data. It is the entry point invoked by the concurrent program to generate and transmit the e-file payload.
  • GET_BG_ID — A helper that retrieves the relevant business group identifier. In Oracle HRMS/Payroll, the business group defines the legislative and organizational context, which is essential when selecting the correct Korean tax-reporting parameters and organization records.
  • RECORD_COUNT — A utility that returns the count of records included in the e-file output. This is typically used for logging, validation, or reporting the volume of donation rows processed during the concurrent run.

No parameter lists are documented in the ETRM extract; exact signatures should be confirmed by inspecting the package source in the target instance.

Tables Accessed

The package accesses the following tables (via APPS synonyms):

  • HR_ORGANIZATION_INFORMATION — Stores descriptive and classification information about organizations. It is read to obtain legislative or registration details required for the Korean tax filing header.
  • PAY_ASSIGNMENT_ACTIONS — Holds assignment-level payroll action records. It supplies employee-level data used in constructing the donation e-file records.
  • PAY_PAYROLL_ACTIONS — Contains payroll run/action information. It is used to scope the e-file extract to the appropriate payroll action or period.
  • PER_ASSIGNMENT_EXTRA_INFO — Stores assignment extra information (DFF). It provides Korean-specific descriptive flexfield values such as donation details and tax identifiers.

Usage Notes

This package is normally invoked indirectly through a concurrent program that is part of the Korean Year-End Adjustment e-filing process. The concurrent program calls SUBMIT_EFILE, which in turn uses GET_BG_ID and RECORD_COUNT to resolve context and report processed volumes. It is a dependent of PAY_KR_YEA_DON_EFILE_PKG, meaning it is not intended for direct ad-hoc invocation.

Customizations should not modify this package; instead, extensions should wrap or replicate its logic. Because it references legislative data and the Korean NTS format, changes may be required when tax regulations are updated. Troubleshooting typically begins with verifying the business group, payroll action, and extra information setup, then reviewing the concurrent request log produced by SUBMIT_EFILE. As with all APPS-owned seeded packages, direct grants should be avoided in favor of the standard concurrent program interface.