Search Results get_business_group_id

Overview

APPS.PAY_JP_BALANCE_PKG is a Japanese localization payroll balance package within Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. Its business function is to provide balance-related lookup and retrieval services for Japanese payroll processing, exposing a set of narrowly scoped accessor functions that resolve business group context, legislation, balance and element metadata, and the numeric, character, and date values held in payroll run results, element entries, and balance dimensions. The package body caches action parameters in package-level state (for example, a low-volume flag and a cached indicator) so that repeated calls within a payroll run do not incur redundant SQL parsing. Because it reads rather than writes payroll business data, it functions primarily as a server-side utility layer used by Japanese payroll balances, run result, and element entry processing logic.

Key Procedures and Functions

The documented API surface comprises 27 functions and procedures, including two overloaded implementations of get_business_group_id — one taking an assignment action identifier, the other taking an assignment identifier plus an effective date. Both derive the business group by joining payroll action and assignment action context, or by resolving the effective-dated assignment record.

• GET_LEGISLATION_CODE — returns the legislation code governing the payroll context.
• GET_BALANCE_VALUE, GET_BALANCE_VALUE_ASG_RUN — return a balance value for a defined balance, the latter scoped to an assignment and payroll run.
• GET_RESULT_VALUE_PAY_VALUE, GET_RESULT_VALUE_CHAR, GET_RESULT_VALUE_NUMBER, GET_RESULT_VALUE_DATE — return run result values in the appropriate datatype.
• GET_ENTRY_VALUE_CHAR, GET_ENTRY_VALUE_NUMBER, GET_ENTRY_VALUE_DATE — return element entry values by datatype.
• GET_ELEMENT_TYPE_ID, GET_ELEMENT_INPUT_ID, GET_INPUT_VALUE_ID, GET_LOC_UNI_SEQ_INPUT_VALUE_ID — resolve element type, element input, and localized input value identifiers.
• GET_DEFINED_BALANCE_ID, GET_BALANCE_TYPE_ID — resolve defined balance and balance type identifiers used by the balance retrieval functions.

Tables Accessed

The package reads the core Oracle Payroll and HR tables through APPS synonyms. PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS provide the assignment action and payroll action context from which the business group is derived. PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES supply run result data, while PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F supply element entry values. PAY_BALANCE_DIMENSIONS, PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, and PAY_BALANCE_FEEDS_F provide the balance definition and dimension metadata. PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, and PAY_LINK_INPUT_VALUES_F resolve element and input value definitions. PER_ALL_ASSIGNMENTS_F (PER_ASSIGNMENTS_F in the source) resolves effective-dated assignment context. The statements are read-only lookups.

Usage Notes

PAY_JP_BALANCE_PKG is referenced by 26 other packages and is classified as OTHER in the ETRM metadata, indicating it is an internal supporting utility rather than a public API. It is typically invoked from Japanese payroll balance, run result, and element entry processing packages and from concurrent programs that precompute or report Japanese payroll balances, and it may be called from forms-based payroll inquiry. Custom code should treat it as an internal dependency, call the appropriate overload of get_business_group_id based on whether assignment action context or assignment plus effective date is available, and expect a NULL return when no matching row is found.