Results for “id_flex_num”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.HR_JP_ID_PKG is a Japanese localization package body within the Oracle E-Business Suite Human Resources and Payroll schema. It functions as a consolidated data-access and caching layer that resolves the primary and foreign key identifiers required by Japanese payroll and HR processing logic. Rather than embedding repeated lookups against flexfield, element, balance, backpay, and organization tables into every calling module, the package centralizes these retrievals and exposes them through typed record structures and narrow ID-returning functions.

The package is classified by ETRM as an OTHER API, indicating it is a supporting utility package rather than a formal public HR API. Its status is VALID in release 12.1.1 and 12.2.2, and it references 23 other packages while not itself being referenced by any database object, which places it at the leaf end of the dependency chain. Its defined procedures and functions number 111 in the documented metadata.

Key Procedures and Functions

The documented entry points fall into recognizable functional clusters, each pairing a record-returning routine with an ID-returning counterpart:

• LATEST_SQL — captures the most recently executed SQL statement text, used for diagnostics and error reporting within the package.
• KEYFLEX_COMBINATION_ID — resolves a key flexfield combination identifier for a supplied flexfield context.
• BUSINESS_GROUP_REC — returns the business group context used to scope subsequent legislative lookups.
• LEGISLATION_CODE and ID_FLEX_NUM — identify the Japanese legislation and the applicable key flexfield structure.
• DEFAULT_CURRENCY_CODE — returns the default currency for the operating context.
• ELEMENT_SET_REC / ELEMENT_SET_ID — retrieve payroll element set definitions and their identifiers.
• BACKPAY_SET_REC / BACKPAY_SET_ID — retrieve backpay set definitions and identifiers.
• CLASSIFICATION_REC / CLASSIFICATION_ID — return element classification details and keys.
• ELEMENT_TYPE_REC / ELEMENT_TYPE_ID — resolve element type records and identifiers.
• BALANCE_TYPE_REC / BALANCE_TYPE_ID — return balance type definitions and identifiers.
• BALANCE_DIMENSION_REC / BALANCE_DIMENSION_ID — return balance dimension definitions and identifiers.
• ASSIGNMENT_STATUS_TYPE_REC / ASSIGNMENT_STATUS_TYPE_ID — return assignment status type records and their identifiers.

Tables Accessed

The package reads from several families of application tables via APPS synonyms. Payroll configuration data is drawn from PAY_ELEMENT_TYPES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_SETS, PAY_ELEMENT_CLASSIFICATIONS, PAY_INPUT_VALUES_F, PAY_BALANCE_TYPES, PAY_BALANCE_DIMENSIONS, PAY_BALANCE_FEEDS_F, PAY_DEFINED_BALANCES, PAY_BACKPAY_SETS and PAY_BACKPAY_RULES, PAY_GRADE_RULES_F, PAY_FORMULA_RESULT_RULES_F, PAY_SUB_CLASSIFICATION_RULES_F, PAY_STATUS_PROCESSING_RULES_F, PAY_CONSOLIDATION_SETS, PAY_RATES, and related payroll and payment-method tables.

Flexfield resolution depends on FND_FLEX_VALUES, FND_FLEX_VALUE_SETS, FND_FLEX_KEYVAL, FND_CURRENCIES, FF_FORMULAS_F, FF_FORMULA_TYPES, and FF_FUNCTIONS. Human resources data is sourced from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, PER_BUSINESS_GROUPS, PER_GRADES, PER_JOBS, PER_POSITIONS, PER_PAY_BASES, PER_PERSON_TYPES, PER_ASSIGNMENT_STATUS_TYPES, PER_ADDRESSES, HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION, HR_LOCATIONS_ALL, and HR_ASSIGNMENT_SETS. Japanese-specific bank data is read from PER_JP_BANK_LOOKUPS. These tables supply the values the package caches and returns as IDs and record structures.

Usage Notes

HR_JP_ID_PKG is an internal supporting package. It is typically invoked indirectly by Japanese payroll and HR forms, concurrent programs, and localization routines that require resolved identifiers for element types, balance types, dimensions, backpay sets, classifications, and assignment status types without reissuing the underlying queries. Custom extensions that mirror Japanese payroll configuration should call the documented ID and record functions rather than querying the base tables directly, preserving consistency with standard localization behavior.