Search Results ghr_person_extra_info_api




Overview
Explore in AI Chat

Overview

The APPS.GHR_PERSON_EXTRA_INFO_API package body is a public API wrapper within the Oracle E-Business Suite (EBS) Human Resources and Oracle Human Resources Management System (HRMS) architecture. Its principal role is to provide a governed, encapsulated interface for creating and updating "extra information" — the descriptive, user-defined attributes associated with a person or assignment record — while ensuring that all data changes are captured through the HRMS history and audit framework. The "GHR_" prefix denotes the global HR layer that abstracts and standardizes direct calls to the underlying HR_ schema APIs, applying consistent validation, security, and date-tracking behavior. In Oracle EBS 12.1.1 and 12.2.2, this package is classified as a valid API within the APPS schema and is documented as being referenced by nine other database objects, indicating that it functions as a shared, reusable building block for person extra information maintenance rather than as an isolated utility.

Key Procedures and Functions

The ETRM documentation identifies two documented program units within this package body:

  • CREATE_PERSON_EXTRA_INFO — Establishes a new extra information record for a person. It is the entry point used when a new user-defined detail is attached to an existing person record, and it is responsible for applying the date-effective (datetrack) semantics that HRMS enforces on all person-related data.
  • UPDATE_PERSON_EXTRA_INFO — Modifies an existing extra information record. This procedure handles changes to previously created extra information, preserving the history chain and driving the corresponding audit and datetrack rows rather than overwriting prior values.

Both procedures are thin API wrappers in intent: they validate the request, invoke the appropriate HRMS-level handling, and delegate the physical write to lower layers. Parameter lists are intentionally not documented here.

Tables Accessed

The package operates against two documented base tables, accessed through APPS synonyms:

  • PER_PEOPLE_EXTRA_INFO — The primary store for person-level extra information. CREATE and UPDATE operations write here, with the datetrack columns maintained so that point-in-time and current queries return accurate results.
  • PER_PEOPLE_F (referenced indirectly via PER_PEOPLE_EXTRA_INFO) and PER_PHONES — PER_PHONES is accessed in the context of contact and phone-related extra information associated with the person record.

The dependency listing further confirms use of GHR_HISTORY_API, GHR_SESSION, HR_API, HR_PERSON_EXTRA_INFO_API, and HR_UTILITY, which together provide the datetrack, session context, and validation services underpinning these writes.

Usage Notes

This package is typically invoked by Oracle HRMS forms, concurrent programs, and customer-written extensions that need to manipulate person extra information without bypassing HRMS business rules. Because GHR_PERSON_EXTRA_INFO_API references GHR_SESSION, callers must ensure that the HRMS session context (business group and effective date) is initialized before invocation — a requirement common to all GHR-datetracked APIs. It is not referenced by any database object per the ETRM listing, so it represents the outer API layer rather than an internal dependency. In EBS 12.1.1 and 12.2.2, custom code should call this package in preference to direct DML on PER_PEOPLE_EXTRA_INFO, since direct inserts would bypass history capture and validation. Its validity status and documented procedures make it a supported integration surface for person extra information maintenance.