Results for “addr_attribute”

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

Overview

The APPS.HR_AE_PERSON_ADDRESS_API package is a public Oracle E-Business Suite PL/SQL API that manages person address records specific to the United Arab Emirates (UAE) legislative and localization requirements. It belongs to the PER (Human Resources) product family and is registered under the display name "Address for UAE." Its principal business function is to create and maintain structured UAE address data for a person, capturing country-specific address elements such as the emirate, city or village, region or area, street, building, flat number, and PO Box. This level of detail is required for UAE payroll, statutory reporting, and HR record-keeping, where a generic free-text address is insufficient.

The package operates as a localization (localization "AE" identifier) alternative to the global create_person_address API, and the header comments explicitly direct developers to that base API for additional explanation. It is licensed for use with Oracle Human Resources, meaning it should be invoked within the HR application context only.

Key Procedures and Functions

The ETRM documentation registers two public procedures for this package:

• CREATE_AE_PERSON_ADDRESS — Creates a UAE-formatted address for a specified person. It accepts parameters including p_validate (which, when true, leaves the database unchanged for testing purposes), p_effective_date, p_person_id, p_primary_flag, p_date_from and p_date_to, p_address_type, p_comments, and UAE-specific address elements such as p_address_line1, p_address_line2, p_emirate, p_city_village, p_region_area, p_street, p_building, p_flat_number, and p_po_box. On success it produces a valid person address; on failure it raises an error and writes nothing. The p_validate flag allows callers to dry-run validation before committing.
• UPDATE_AE_PERSON_ADDRESS — Modifies an existing UAE person address. As with the create routine, it follows the datetracked/effective-dated pattern typical of HR person data, consistent with the p_effective_date parameter exposed on the create API.

No other procedures or functions are documented in the ETRM metadata for this package.

Tables Accessed

The only documented table referenced by this package (through APPS synonyms) is PER_ADDRESSES. This is the core Human Resources table that stores person address records, including the address type, primary flag, effective start and end dates, and the individual address attribute columns. The API writes new rows on creation and updates existing rows through the update routine, enforcing the business rules associated with UAE address formatting on that table.

Usage Notes

The package is typically invoked from Oracle Forms within the HR localization layer, from concurrent programs performing mass address maintenance or data migration, and from custom PL/SQL code that must persist UAE addresses programmatically. Because it is classified as a public API and licensed for Oracle Human Resources only, custom integrations should call this package rather than inserting directly into PER_ADDRESSES, thereby preserving validation, effective-dating, and audit integrity.

Callers should always supply a valid p_person_id, an p_effective_date, and accurate UAE address components. The p_validate parameter should be used in testing or pre-commit scenarios to confirm data validity without affecting the database. The ETRM metadata records no dependent packages referencing this API, so it is intended to be consumed by external callers rather than called internally by other delivered APIs.