Results for “person_type_id”
50+ results
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.
-
PACKAGE: APPS.HR_JP_ID_PKG 12.1.1
-
PACKAGE: APPS.HR_JP_ID_PKG 12.2.2
-
View: HRI_CL_PTY_NONPTU_B_V 12.1.1
APPS.HRI_CL_PTY_NONPTU_B_V·↳ HR_BIS·↳ PER_PERSON_TYPES·↳ PER_PERSON_TYPES_TL·Explore HRI module →
-
View: HRI_CL_PER_SUP_HX_V 12.1.1
APPS.HRI_CL_PER_SUP_HX_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore HRI module →
-
View: HRI_CL_PER_SUP_HX_V 12.2.2
APPS.HRI_CL_PER_SUP_HX_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore HRI module →
-
View: HRI_CL_PER_EMP_HX_V 12.2.2
APPS.HRI_CL_PER_EMP_HX_V·↳ HR_BIS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore HRI module →
-
View: PA_PERSON_TYPE_RES_V 12.1.1
APPS.PA_PERSON_TYPE_RES_V·↳ PA_LOOKUPS·↳ PER_PERSON_TYPES·Explore PA module →
-
View: PA_PERSON_TYPE_RES_V 12.2.2
APPS.PA_PERSON_TYPE_RES_V·↳ PA_LOOKUPS·↳ PER_PERSON_TYPES·Explore PA module →
-
View: HRI_CL_PTY_NONPTU_B_V 12.2.2
APPS.HRI_CL_PTY_NONPTU_B_V·↳ HR_BIS·↳ PER_PERSON_TYPES·↳ PER_PERSON_TYPES_TL·Explore HRI module →
-
Report view
APPS.PAY_ASGS_WITHOUT_PAYROLLS_V·↳ HR_GENERAL·↳ HR_LOCATIONS·↳ HR_ORGANIZATION_UNITS·Explore PAY module →
-
View: OKX_EMPLOYEES_V 12.1.1
APPS.OKX_EMPLOYEES_V·↳ PER_ALL_PEOPLE_F·Explore OKX module →
-
Translated person types information.
-
This view is used in the Quickpaint form to list the assignments upon which a quickpaint report will run
APPS.PER_QUICKPAINT_ASSIGNMENTS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PER module →
-
This view is used in the Quickpaint form to list the assignments upon which a quickpaint report will run
APPS.PER_QUICKPAINT_ASSIGNMENTS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PER module →
-
Translated person types information.
-
View: HRI_CL_PER_EMP_HX_V 12.1.1
APPS.HRI_CL_PER_EMP_HX_V·↳ HR_BIS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore HRI module →
-
View: PAY_KR_SEP_MASTER_V 12.2.2
This view returns employee assignment which are target for Separation Pay Process.
APPS.PAY_KR_SEP_MASTER_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_INFORMATION·↳ HR_ORGANIZATION_UNITS·Explore PAY module →
-
View: HRFV_PHONES 12.2.2
Business view template from which the flexfield view is generated.
APPS.HRFV_PHONES·↳ HRI_BPL_PERSON_TYPE·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_BIS·Explore PER module →
-
View: OKX_PER_ALL_PEOPLE_V 12.2.2
Personal information for employees, applicants and other people
APPS.OKX_PER_ALL_PEOPLE_V·↳ PER_ALL_PEOPLE_F·Explore OKX module →
-
- Retrofitted
APPS.BEN_ELIG_PER_TYP_PRTE_D·↳ BEN_ELIGY_PRFL_F·↳ BEN_ELIG_PER_TYP_PRTE_F·↳ FND_GLOBAL·Explore BEN module →
-
Person types visible to specific Business Groups.
-
View: PER_PERSON_TYPES_V 12.2.2
Used to support user interface
APPS.PER_PERSON_TYPES_V·↳ HR_API·↳ HR_LOOKUPS·↳ PER_PERSON_TYPES·Explore PER module →
-
View: PER_PERSON_TYPES_V 12.1.1
Used to support user interface
APPS.PER_PERSON_TYPES_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_LOOKUPS·Explore PER module →
-
View: HRFV_HIRES 12.1.1
Business view template from which the flexfield view is generated.
APPS.HRFV_HIRES·↳ FND_GLOBAL·↳ HRI_BPL_PERSON_TYPE·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
Person types visible to specific Business Groups.
-
- Retrofitted
APPS.BEN_ELIG_PER_TYP_PRTE_D·↳ BEN_ELIGY_PRFL_F·↳ BEN_ELIG_PER_TYP_PRTE_F·↳ FND_USER·Explore BEN module →
-
View: OKX_PER_ALL_PEOPLE_V 12.1.1
Personal information for employees, applicants and other people
APPS.OKX_PER_ALL_PEOPLE_V·↳ PER_ALL_PEOPLE_F·Explore OKX module →
-
View: HRFV_TRANSFERS_OUT 12.1.1
Business view template from which the flexfield view is generated.
APPS.HRFV_TRANSFERS_OUT·↳ FND_GLOBAL·↳ HRI_BPL_PERSON_TYPE·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
This view identifies which person type is included or excluded from an eligibility profile.
APPS.BENBV_ELIG_PER_TYP_PRTE_V·↳ BEN_ELIG_PER_TYP_PRTE_F·↳ HR_BIS·Explore BEN module →
-
Used to support user interface.
APPS.HR_CURRENT_PEOPLE_LOV_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F·↳ HR_ALL_POSITIONS_F_TL·Explore PER module →
-
Used to support user interface.
APPS.HR_CURRENT_PEOPLE_LOV_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ALL_POSITIONS_F·↳ HR_ALL_POSITIONS_F_TL·Explore PER module →
-
View: OKX_EMPLOYEE_DETAILS_V 12.2.2
APPS.OKX_EMPLOYEE_DETAILS_V·↳ PER_ADDRESSES·↳ PER_ALL_PEOPLE_F·Explore OKX module →
-
This view identifies which person type is included or excluded from an eligibility profile.
APPS.BENBV_ELIG_PER_TYP_PRTE_V·↳ BEN_ELIG_PER_TYP_PRTE_F·↳ HR_BIS·Explore BEN module →
-
View: GHR_PERSON_SUMMARY_V 12.1.1
Contains the Person Summary information.
APPS.GHR_PERSON_SUMMARY_V·↳ FND_GLOBAL·↳ FND_SESSIONS·↳ HR_API·Explore GHR module →
-
View: GHR_PERSON_SUMMARY_V 12.2.2
Contains the Person Summary information.
APPS.GHR_PERSON_SUMMARY_V·↳ FND_SESSIONS·↳ HR_API·↳ HR_GENERAL·Explore GHR module →
-
Report view
APPS.PAY_ASGS_WITHOUT_PAYROLLS_V·↳ HR_GENERAL·↳ HR_LOCATIONS·↳ HR_ORGANIZATION_UNITS·Explore PAY module →
-
View: OKX_EMPLOYEES_V 12.2.2
APPS.OKX_EMPLOYEES_V·↳ PER_ALL_PEOPLE_F·Explore OKX module →
-
Identifies the types a person may be.
-
View: HRFV_US_ADDRESSES 12.1.1
Business view template from which the flexfield view is generated.
APPS.HRFV_US_ADDRESSES·↳ FND_TERRITORIES_TL·↳ HRI_BPL_PERSON_TYPE·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
This table stores the RBS element information and the parent-child relationship.
-
View: HRFV_ADDRESSES 12.2.2
Business view template from which the flexfield view is generated.
APPS.HRFV_ADDRESSES·↳ FND_TERRITORIES_TL·↳ HRI_BPL_PERSON_TYPE·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PER module →
-
Date-effective view.
APPS.PER_PERSON_TYPE_USAGES_X·↳ PER_PERSON_TYPE_USAGES_F·Explore PER module →
-
View: PER_PERSON_TYPE_USAGES 12.1.1
Date-effective view.
APPS.PER_PERSON_TYPE_USAGES·↳ FND_SESSIONS·↳ PER_PERSON_TYPE_USAGES_F·Explore PER module →
-
View: PAY_KR_SEP_MASTER_V 12.1.1
This view returns employee assignment which are target for Separation Pay Process.
APPS.PAY_KR_SEP_MASTER_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_INFORMATION·↳ HR_ORGANIZATION_UNITS·Explore PAY module →
-
View: POS_PER_PEOPLE_X_V 12.2.2
APPS.POS_PER_PEOPLE_X_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PO module →
-
View: POS_PER_PEOPLE_X_V 12.1.1
APPS.POS_PER_PEOPLE_X_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PO module →
-
View: ICX_PER_PEOPLE_X_V 12.1.1
Obsolete
APPS.ICX_PER_PEOPLE_X_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore ICX module →