Search Results create_hk_person_address

Overview

The APPS.HR_HK_PERSON_ADDRESS_API package body provides the localized application programming interface for maintaining person addresses within the Oracle E-Business Suite Human Resources (HR) module for the Hong Kong (HK) legislative and business context. Its primary role is to encapsulate the business rules and data validation logic required to create and update address records for persons (employees, applicants, and other person types) while respecting Hong Kong-specific address conventions, such as the treatment of district and area fields and county validation.

As an API-classified object, the package exposes a controlled, supported entry point for address maintenance, shielding callers from the underlying PER_ADDRESSES table structure. This enforces data integrity, maintains the effective-dating model used throughout Oracle HRMS, and centralizes Hong Kong-specific validation such as the optional county-validation switch.

Key Procedures and Functions

The package documents two public procedures:

• CREATE_HK_PERSON_ADDRESS — Creates a new address record for a person in the Hong Kong context. It accepts parameters covering effective dating, primary-flag designation, overlap-validation override, county validation, and the full complement of address attributes (address lines, district, area, country, telephone numbers, and descriptive flexfield attribute columns). The p_validate parameter permits a validation-only pass without committing data, which is standard practice for HRMS APIs.
• UPDATE_HK_PERSON_ADDRESS — Modifies an existing Hong Kong person address record. It follows the same effective-dating and validation conventions as the create procedure, allowing controlled changes to address details while preserving the historical date-tracked record.

Both procedures adhere to the standard HRMS API pattern of supporting validation-only execution and effective-date-driven processing.

Tables Accessed

The package operates against PER_ADDRESSES, referenced through its APPS synonym. This is the core Oracle HRMS table storing person address information, including effective start and end dates, primary-address indicators, address type, and the address line, district, area, and country fields. The package reads from and writes to this table to persist new or modified address records. Because PER_ADDRESSES is date-tracked, the API manages the insertion and update of rows in accordance with Oracle's effective-dating conventions rather than performing simple DML.

Usage Notes

This package is typically invoked from the Oracle HRMS forms that manage person addresses when operating under a Hong Kong business group, from concurrent programs that process address data in bulk, or from custom PL/SQL code that requires a supported, validated mechanism for creating or updating addresses. When calling from custom code, developers should always pass a valid p_effective_date, respect the validation-only mode using p_validate, and supply the required address line and country parameters. Direct DML against PER_ADDRESSES should be avoided in favor of this API to ensure that Hong Kong-specific business rules and date-tracking logic are applied consistently.