Search Results ghr_person_address_api




Overview
Explore in AI Chat

Overview

GHR_PERSON_ADDRESS_API is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a public API for creating and updating person address records, with a design focus on United States address formats. The package name prefix "GHR" indicates it belongs to the Global Human Resources layer of Oracle HRMS, and the "_API" suffix confirms its classification as a programmatic interface intended for supported, upgrade-safe integration rather than direct table manipulation.

The package is oriented toward address records that conform to the United States address structure, including the additional address elements and validation conventions that apply to US addresses within Oracle HRMS. For address maintenance in other legislations, Oracle typically exposes separate or localized APIs, so GHR_PERSON_ADDRESS_API should be treated as the US-specific entry point for person address creation and amendment.

The ETRM record shows the package as VALID, with dependencies on APPS.HR_API and the SYS.STANDARD package, and a documented dependency on the PER_ADDRESSES table via APPS synonyms. The package itself is referenced by no other packaged objects, indicating it is a leaf-level API invoked directly by callers rather than as part of an internal package hierarchy.

Key Procedures and Functions

The documented interface consists of four procedures, all centered on US person addresses:

  • CREATE_US_PERSON_ADDRESS — Creates a new United States person address record for a person. This is the primary entry point for inserting a US-format address through supported API logic.
  • CREATE_US_INT_PERSON_ADDRESS — Creates a new United States international person address record. The "_INT" variant indicates support for the international address structure, which accommodates address styles and formats outside the standard domestic US layout.
  • UPDATE_US_PERSON_ADDRESS — Updates an existing United States person address record, allowing modifications to a person's current US-format address data.
  • UPDATE_US_INT_PERSON_ADDRESS — Updates an existing United States international person address record, applying changes to an international-format address.

Parameter lists are not enumerated in the available metadata and should be confirmed against the package specification in the target instance before invocation.

Tables Accessed

The documented table reference is PER_ADDRESSES, accessed through APPS synonyms. PER_ADDRESSES is the core Oracle HRMS table that stores address records for persons and other entities, holding address lines, postal attributes, and the address style and date-effective context associated with each row.

The create procedures insert new rows into PER_ADDRESSES, while the update procedures modify existing rows. Because the package performs this work through the HR_API dependency rather than through raw DML alone, address creation and amendment are subject to the standard HRMS business logic, validation, and date-tracking behavior associated with the PER_ADDRESSES entity.

Usage Notes

GHR_PERSON_ADDRESS_API is typically invoked from custom PL/SQL code, interfaces, or conversion routines that must add or change US person addresses while respecting Oracle HRMS validation and audit conventions. Direct insertion into PER_ADDRESSES is not a supported practice, so the API provides the sanctioned path for such operations.

Because the ETRM record shows the package is referenced by no other documented packages, callers should invoke the individual procedures directly. Integration developers should verify the exact parameter signatures in the local package specification, as the metadata provides procedure names and purposes but not arguments. The presence of separate domestic and international variants means the correct procedure must be selected based on the address format being maintained.