Search Results pay_kr_bal_init_pkg




Overview
Explore in AI Chat

Overview

APPS.PAY_KR_BAL_INIT_PKG is a Korean localization package within the Oracle E-Business Suite Payroll (PAY) module. It supports the balance initialization process required for Korean payroll statutory reporting and year-end settlement processing. The package addresses the need to establish payroll element structures that carry forward or initialize balance information for employees, typically during the setup of a new payroll year or when migrating opening balances into the system. It is declared with AUTHID CURRENT_USER, meaning its unqualified database references resolve against the privileges of the invoking schema rather than the package owner. The package header (pykrbini.pkh) carries a version identifier indicating it has been stable since the 2002-era codebase, and it is categorized under the OTHER API classification, signifying it is not a formally published public API but rather an internal utility invoked by localization-specific processes.

Key Procedures and Functions

The package exposes a single documented procedure, CREATE_STRUCTURE, available in two overloaded forms.

  • CREATE_STRUCTURE (first overload) — Accepts a batch identifier, a classification identifier, and an element name prefix. Its purpose is to construct element structures derived from the batch and classification context, using the supplied prefix to name the generated elements.
  • CREATE_STRUCTURE (second overload) — Mirrors the first overload but adds the standard concurrent program output parameters (errbuf and retcode) so the procedure can be invoked directly as a concurrent program. The core inputs remain the batch identifier, classification identifier, and element name prefix.

Both overloads share the same functional intent: to generate or populate the payroll element definitions and associated input values needed to represent balance initialization data for the given batch. The prefix parameter allows the naming convention of generated elements to reflect the specific batch or classification being processed.

Tables Accessed

The package interacts with several core and localization-related Payroll tables through APPS synonyms:

These tables together allow the package to read batch input, resolve classifications, and write the resulting element, input value, and balance feed definitions.

Usage Notes

Because CREATE_STRUCTURE includes an errbuf/retcode overload, the package is typically invoked as a concurrent program from the Korean Payroll responsibility, most commonly as part of balance initialization or year-end processing runs. The non-concurrent overload supports internal or custom PL/SQL invocation where the calling code manages error handling directly. The package is referenced by no other documented packages, so it functions as a leaf-level utility rather than a shared dependency. Developers extending Korean localization functionality should treat it as an internal component, invoke the concurrent-enabled overload when scheduling, and avoid assuming API stability given its OTHER classification and long-standing header version.