Search Results pre_get_balance_value

Overview

PAY_KR_REPORT_PKG is a Korean localization package within the Oracle EBS Payroll (PAY) application, owned by the APPS schema. Its header, dated 2005, identifies it as a non-shipped ("noship") component, which indicates it is a supporting utility consumed internally by other payroll objects rather than directly by an end user. The package serves the reporting requirements specific to Korean payroll legislation, providing the logic needed to resolve balance values, database item values, and user entity identifiers for a given business group. It encapsulates the Korean-specific mapping between payroll balance names and defined balances, and between user entities and their corresponding cross-balance or database item entities, so that report generation can retrieve correctly scoped values. The API is classified as OTHER and is referenced by twenty other packages, confirming its role as a shared foundation library for Korean payroll reporting.

Key Procedures and Functions

The package exposes twenty-two documented procedures and functions. Central to the user's search term is PRE_GET_DBITEM_VALUE, a procedure that accepts a business group identifier and performs preparatory setup for subsequent database item value retrieval; the package-level flag g_pre_get_dbitem_value_perf indicates this preparation is performance-sensitive and can be toggled. Its sibling, PRE_GET_BALANCE_VALUE, performs the analogous preparatory work for balance value retrieval, governed by g_pre_get_balance_value_perf. LEGISLATION_CODE returns the legislation code for a business group. The lookup functions GET_DEFINED_BALANCE_ID, GET_XBAL_USER_ENTITY_ID, GET_USER_ENTITY_ID, and GET_XDBITEM_USER_ENTITY_ID resolve defined balance identifiers and user entity identifiers from names or related identifiers. GET_LATEST_ASSACT returns the latest assignment action within a date range and action type, while GET_BALANCE_VALUE_ASG_RUN returns a balance value based on an assignment action and balance type. The remaining documented entries—GET_ARCHIVE_ITEMS, GET_BALANCE_VALUE, GET_DBITEM_VALUE, GET_RESULT_VALUE_DATE, GET_RESULT_VALUE_NUMBER, GET_RESULT_VALUE_CHAR, GET_RESULT_VALUE, and GET_SEP_PREV_EMP_INFO—provide archive item access, balance and database item retrieval, typed result value accessors, and prior employee separation information.

Tables Accessed

The package reads and writes through APPS synonyms across core payroll and FastFormula tables. Payroll transaction data is drawn from PAY_RUN_RESULTS, PAY_ASSIGNMENT_ACTIONS, PAY_ACTION_INTERLOCKS, PAY_INPUT_VALUES_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, and PAY_ELEMENT_TYPES_F. Balance definition and feeding structures are accessed via PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, PAY_BALANCE_DIMENSIONS, and PAY_BALANCE_FEEDS_F. FastFormula metadata and archive storage are represented by FF_DATABASE_ITEMS, FF_USER_ENTITIES, and FF_ARCHIVE_ITEMS. FND_SESSIONS provides session context. These tables support the resolution of balance IDs, user entity IDs, and the underlying values required by Korean payroll reports.

Usage Notes

PAY_KR_REPORT_PKG is not intended for direct customer invocation. It is typically called from Korean payroll report logic, concurrent programs, and other payroll packages that require locale-specific balance and database item resolution. Custom code referencing it should call PRE_GET_DBITEM_VALUE or PRE_GET_BALANCE_VALUE before retrieval to benefit from the performance caching implied by the package flags, and should always pass a valid business group identifier. Because the package is marked noship, its signature may change without notice and it should be treated as an internal dependency rather than a supported public API.