Search Results kr_corporate_information

Overview

PAY_KR_NONSTAT_SPAY_EFILE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Korean statutory (non-statutory supplementary payment) electronic filing requirements. It is part of the Oracle Payroll localization layer for South Korea and is responsible for generating the magnetic media and report files that Korean employers must submit to the National Tax Service and related authorities. The package consolidates corporate information, reporting organization details, and payroll action data into the structured record formats (records A through D) required by the Korean e-file specification, then submits the resulting request to the concurrent manager for output.

In the 12.1.1 and 12.2.2 releases, the package is classified as OTHER under the ETRM API taxonomy, meaning it is not an exposed public API but an internal implementation of the Korean payroll statutory reporting flow. The user query "kr_corporate_information" maps to cursor and record structures inside this package that draw corporate-level identity and contact data — corporation name, corporation number, representative name, representative tax office code, and corporate phone number — from HR organization information.

Key Procedures and Functions

• GET_BP_COUNT — Returns the count of business places (BP) under a given primary business place. Used to size the data set before the file is built.
• GET_RECORD_D_CONTEXT — Resolves the context values needed to assemble record D of the e-file layout, retrieving descriptive and grouping attributes associated with the reporting entity.
• SUBMIT_EFILE — The main driver procedure. It accepts the effective date, business place, reporting scope, magnetic file name, report file name, target year, payroll action, assignment set, reported date, character set, business group, tax reporting organization, tax reporter, contact phone number, home tax ID, and organization structure version, then produces and submits the electronic file request. Its design allows the same routine to serve both statutory and non-statutory supplementary payment runs.

Tables Accessed

The package reads reference and transactional data through APPS synonyms. FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEM_CONTEXTS, FF_CONTEXTS, FF_ROUTE_CONTEXT_USAGES, and FF_USER_ENTITIES supply the FastFormula archive and context infrastructure used to resolve entity-specific parameters. HR_LOCATIONS_ALL and HR_ORGANIZATION_INFORMATION provide corporate identity and contact details (the "kr_corporate_information" attributes such as corporation number and representative name). PER_ORG_STRUCTURE_ELEMENTS and PAY_PAYROLL_ACTIONS, together with PAY_ASSIGNMENT_ACTIONS, supply the organization hierarchy and the payroll action context that scopes which employees and payments are reported. DUAL is used for single-row lookups and default derivations.

Usage Notes

PAY_KR_NONSTAT_SPAY_EFILE is invoked indirectly, typically from a Korean payroll statutory reporting concurrent program or from the corresponding payroll form, rather than being called directly by customer code. Because SUBMIT_EFILE accepts the standard concurrent manager errbuf and retcode OUT parameters, it is designed for submission as a concurrent program. The package is not referenced by any other documented package, indicating it sits at the top of its call chain. Customers extending the Korean e-file output should treat these routines as internal and avoid direct calls, since parameter signatures may change between patch levels.