Results for “hr_person”

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

Overview

APPS.HR_PERSON is a server-side PL/SQL package body within the Oracle E-Business Suite Human Resources (HRMS) schema. Its primary business function is to provide the core application logic for creating, validating, and maintaining person records in the PER schema. In Oracle EBS, a "person" is the fundamental entity that underlies every employee, applicant, contingent worker, and contact in the system. The HR_PERSON package centralizes the validation and derivation rules that govern how person data is accepted and stored, ensuring data integrity across the person model that feeds payroll, benefits, and self-service functions.

The package carries a status of VALID in both the 12.1.1 and 12.2.2 releases, and it is classified under the generic API classification OTHER within ETRM. It is not a standalone public API in the same sense as the HR_PERSON_API, but rather the internal implementation body that supports person-related operations across the application. The package body leverages shared infrastructure from HR_API, HR_UTILITY, and HR_PERSON_INTERNAL, indicating that it operates as a lower-level component within the HR person processing stack.

Key Procedures and Functions

The documented package exposes 21 procedures and functions, grouped broadly into generation, validation, and deletion logic.

Number and Name Generation

• GENERATE_NUMBER — Produces a system-generated person number based on the configured numbering method.
• DERIVE_FULL_NAME — Derives or constructs a person's full name from the component name fields.

Validation Logic

• VALIDATE_NATIONAL_IDENTIFIER — Verifies national identifier values against the applicable format and uniqueness rules.
• VALIDATE_DOB — Validates date of birth values for range and business rules.
• VALIDATE_SEX_AND_TITLE — Checks the consistency between a person's sex and their title.
• VALIDATE_UNIQUE_NUMBER — Enforces uniqueness of the person number.
• VALIDATE_ADDRESS — Validates address data associated with the person.
• CHECK_NI_UNIQUE — Confirms that a national identifier is unique within the appropriate scope.

Pre-Delete Validation

• WEAK_PREDEL_VALIDATION and STRONG_PREDEL_VALIDATION — Perform pre-deletion checks to determine whether a person can be removed, with differing levels of strictness.
• DELETE_A_PERSON — Executes the actual deletion of a person record after validations pass.
• PEOPLE_DEFAULT_DELETES and APPLICANT_DEFAULT_DELETES — Handle default deletion logic for people versus applicants.

Person Type Checks

• CHK_FUTURE_PERSON_TYPE and FPT_CHECK_FT_PERSON_TYPE — Validate rules concerning future-dated person type changes.
• CHECK_CONTACT — Validates contact-specific person attributes.
• PRODUCT_INSTALLED — Verifies that a required product or module is installed before proceeding.

Tables Accessed

The package reads and writes the core person tables through APPS synonyms. PER_ALL_PEOPLE_F is the primary dated table holding person attributes; PER_PERSON_TYPES and PER_PERSON_TYPE_USAGES_F govern the classification of a person as employee, applicant, or contact. PER_ADDRESSES stores address records, while PER_NUMBER_GENERATION_CONTROLS drives number generation. PER_PERIODS_OF_SERVICE and PER_PERIODS_OF_PLACEMENT support service-related validations. HR_ORGANIZATION_INFORMATION is accessed for organizational context, and FND_SESSIONS supplies session information. USER_OBJECTS is queried for object existence checks.

Usage Notes

HR_PERSON is typically invoked indirectly through the public HR_PERSON_API and related DML packages, as well as by Oracle Forms such as the People and Assignment forms. It is referenced by 15 other packages, confirming its role as a shared internal dependency. Custom code should call the supported public API rather than HR_PERSON directly, since the internal procedures may change between patch levels without public notice. The package is not referenced by any database object outside the listed dependency set, reinforcing that it functions as a private implementation body.