Search Results csr_b

Overview

PAY_KR_YEA_MED_EFILE_PKG is an Oracle E-Business Suite PL/SQL package that supports the Korean Year-End Adjustment (YEA) medical expense electronic filing process. It is owned by the APPS schema and is declared with AUTHID CURRENT_USER, meaning that all unqualified object references are resolved against the privileges of the invoking user rather than the package owner. The package is part of the Korean localization layer (identified by the PAY_KR prefix) and is shipped under the pykrymef.pkh header, with the current source revision dated January 2010 (120.6.12010000.3). Its principal role is to assemble the data set required by the Korean National Tax Service (NTS) for reporting employee medical expenses incurred during a payroll year, and to hand that data to the downstream e-filing mechanics. The package is classified as OTHER in the ETRM repository, indicating that it is not a public, supported API but an internal implementation package used by Korean payroll statutory reporting.

Key Procedures and Functions

The ETRM metadata documents no procedures or functions as public entry points, which is consistent with the package being an internal worker rather than a callable API. The package specification nevertheless declares a set of package-level globals that govern its behavior and persist state across the session: LEVEL_CNT, G_BUSINESS_PLACE_ID, G_TARGET_YEAR, G_B_RECORDS, G_PAYROLL_ACTION_ID, G_ASSIGNMENT_SET_ID, G_MEDICAL_EXP_ARCHIVE, and the flags G_NORMAL_YEA, G_INTERIM_YEA, and G_RE_YEA (all initialized to 'X'), together with G_REP_PERIOD_CODE initialized to '2'. These globals indicate that the package processes three distinct YEA variants—normal, interim, and re-adjustment—and that G_TARGET_YEAR and G_BUSINESS_PLACE_ID drive record selection. An internal cursor, CSR_A, projects the reporting fields required for each employee record, including TAX_OFFICE_CODE, PRIMARY_BP_NUMBER, BR_NUMBER, NATIONAL_IDENTIFIER, FULL_NAME, CORP_NAME, ASSIGN_ID, VALIDATION, and EMP_NATIONALITY. Validation is delegated to PAY_KR_YEA_MED_EFILE_CONC_PKG.VALIDATE_DET_MEDICAL_REC, and nationality derivation to PAY_KR_FF_FUNCTIONS_PKG.NI_NATIONALITY.

Tables Accessed

The package reads from a well-defined set of payroll and HR tables. HR_ORGANIZATION_INFORMATION supplies the business place registration and corporate information rows, with contexts such as KR_BUSINESS_PLACE_REGISTRATION and KR_CORPORATE_INFORMATION; the legacy identifier is resolved through ORG_INFORMATION2 and the primary business place through the concurrent parameter PRIMARY_BP_ID (fetched via PAY_MAGTAPE_GENERIC.GET_PARAMETER_VALUE). PER_PEOPLE_F and PER_PERIODS_OF_SERVICE provide person and hire data, PER_ASSIGNMENTS_F and PAY_ASSIGNMENT_ACTIONS supply assignment-level context, and PAY_PAYROLL_ACTIONS ties records to the payroll run that produced them. FF_ARCHIVE_ITEMS holds the archived fast-formula values that are re-emitted in the e-file. PER_ASSIGNMENT_EXTRA_INFO, PER_ORG_STRUCTURE_ELEMENTS, and FF_USER_ENTITIES support the organizational hierarchy and fast-formula definition lookups needed to resolve the reporting entity structure. All references are made through APPS synonyms.

Usage Notes

PAY_KR_YEA_MED_EFILE_PKG is invoked indirectly by the Korean YEA medical expense concurrent programs, most notably the e-file concurrent process that consumes the record set assembled by CSR_A. It is not intended to be called directly from Oracle Forms or by customer-written code. Implementers setting up Korean YEA reporting must ensure that the relevant business place organizations carry the KR_BUSINESS_PLACE_REGISTRATION information context, that the corporate information context is populated, and that the PRIMARY_BP_ID parameter is supplied on the concurrent request. Because the package uses AUTHID CURRENT_USER, execution privileges must be granted to any user running the report. The presence of separate normal, interim, and re-adjustment flags confirms that a single executable handles all YEA submission types, with G_REP_PERIOD_CODE defaulting to '2' per Bug 9251566. The package is referenced by no other packages in the ETRM repository, confirming its position as a leaf-level reporting module dedicated to Korean statutory e-filing.