Search Results hr_person_type_usage_info




Overview
Explore in AI Chat

Overview

HR_PERSON_TYPE_USAGE_INFO is an Oracle EBS Application Object Library (APPS) package body that encapsulates the business rules governing person type usages within Oracle Human Resources. Its central responsibility is to resolve, classify, and validate the relationship between a person (or a system-level user) and the person type assigned to them. Because person types in EBS carry significant downstream meaning — they determine which processing rules, restrictions, and user-facing behaviours apply to an individual — this package acts as a controlled access point for that information rather than allowing direct table reads.

The package is classified under the general "OTHER" API category in the ETRM documentation and holds a VALID status at version 12.1.1 and 12.2.2. It is heavily embedded in the application: it references a substantial set of HR and Payroll tables and is itself referenced by 79 other database objects, indicating that it is a foundational utility consumed broadly across HRMS modules.

Key Procedures and Functions

The documented interface exposes 16 procedures and functions. The principal accessors resolve person type context for a session or a specific person:

Validation and classification functions include ISNONCOREHRPERSONTYPE, which determines whether a person type falls outside core HR processing, IS_PERSON_OF_TYPE, which tests whether a given person matches a specified type, and IS_PERSON_A_WORKER, which classifies a person as a worker. FUTSYSPERTYPECHGEXISTS checks for the existence of a future-dated system person type change, supporting date-effective integrity. GET_WORKER_NUMBER retrieves the worker's identifying number, and GET_PERSON_ACTIONS returns the permissible actions for a person, supporting form-level action enablement.

Tables Accessed

The package reads from a defined set of HRMS tables via APPS synonyms. PER_PERSON_TYPES and its translation table PER_PERSON_TYPES_TL supply the person type definitions and their language-specific names. PER_PERSON_TYPE_USAGES_F holds the date-effective assignment of a type to a person and is the central fact table. PER_ALL_PEOPLE_F provides the person record itself, while PER_PERIODS_OF_SERVICE and PER_PERIODS_OF_PLACEMENT supply employment and placement context used to distinguish workers. PER_FORM_FUNCTIONS links form-level behaviour to person type rules, and PAY_RESTRICTION_VALUES supplies payroll restriction checks. PLITBLM and the STANDARD/HR_API, HR_GENERAL and HR_UTILITY dependencies provide the standard HRMS utility framework used across the product.

Usage Notes

HR_PERSON_TYPE_USAGE_INFO is typically invoked indirectly. Oracle HRMS forms call it to determine which person types a user may select, to default the person type on entry, and to enable or disable person actions. Concurrent programs and other HRMS packages reference it when validating person type usage during data loading or processing. Custom code should not replicate its logic against the underlying tables; instead, calling these documented functions preserves date-effective and system-versus-user-defined semantics. Because the package is referenced by 79 objects, changes to person type configuration can propagate widely, and any extension should treat these functions as the supported interface.