Search Results hr_jp_id_pkg




Overview
Explore in AI Chat

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:

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.