Search Results g_rep_period_code

Overview

APPS.PAY_KR_YEA_MED_EFILE_PKG is a Korean localization payroll package responsible for generating electronic filing (e-file) output for the Year-End Adjustment (YEA) medical expense tax exemption. The package assembles the data required by Korean tax authorities for employees claiming medical expense deductions, and produces a structured, report-ready extract suitable for magnetic media or file-based submission. It is part of the broader Korean payroll localization layer that ships with Oracle E-Business Suite and is associated with the "X_YEA_MED_EXP_TAX_EXEM" user entity, which is registered in FF_USER_ENTITIES under legislation code "KR".

The package header comment (pykrymef.pkb 120.1.12010000.2) indicates it was last patched in January 2010, and the body carries annotations referencing Bug 9251566, which governs the assignment of report period codes during package initialization.

Key Procedures and Functions

The documented metadata lists no public procedures or functions, and the excerpt shows the package is dominated by its initialization block rather than a large callable API surface. Two internal constructs are visible:

• user_entity_id — a private function that resolves a user entity name to its numeric USER_ENTITY_ID by querying FF_USER_ENTITIES filtered on legislation code "KR" and creator type "X". It is used to obtain the identifier for the medical expense tax exemption entity.
• Package initialization section — an anonymous PL/SQL block that executes when the package is first referenced. It populates global package variables from concurrent program parameters and derives control flags and the report period code.

Because the package has no documented public routines, its behavior is primarily exposed through these package-level globals (for example g_payroll_action_id, g_assignment_set_id, g_target_year, g_medical_exp_archive, g_normal_yea, g_interim_yea, g_re_yea, and g_rep_period_code), which downstream report logic within the same package reads.

Tables Accessed

The package reads and writes against the following documented tables (accessed via APPS synonyms):

• FF_USER_ENTITIES — resolves the medical expense tax exemption user entity identifier during initialization.
• FF_ARCHIVE_ITEMS — supports archive item metadata for the e-file output.
• PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS — provide the payroll action and assignment action context driving the run.
• PER_ASSIGNMENT_EXTRA_INFO, PER_PERIODS_OF_SERVICE, and PER_ORG_STRUCTURE_ELEMENTS — supply assignment-level, service-period, and organization hierarchy data required to attribute medical expenses to the correct employees and business places.
• HR_ORGANIZATION_INFORMATION — provides organization attribute information used in file formatting.

Usage Notes

The package is invoked in the context of a Korean payroll Year-End Adjustment concurrent program. During initialization it calls pay_magtape_generic.get_parameter_value to retrieve PAYROLL_ACTION_ID, ASSIGNMENT_SET_ID, and TARGET_YEAR. When no payroll action ID is present, it reads the REPORT_TYPE parameter to set the reporting flags and the report period code.

Under Bug 9251566, g_rep_period_code is assigned "1" for a Normal YEA (or when the report type is null, in which case g_normal_yea is set to "N") and "3" for an Interim or Replacement YEA (report types "I" and "R"). This global is the value most commonly referenced by developers and support analysts searching for "g_rep_period_code", as it controls how the medical expense e-file is segmented by reporting period. The package is not referenced by other documented packages, so it is typically executed as a standalone concurrent program step rather than as a shared library.