Search Results update_pl_address_style

Overview

APPS.PER_PL_ADDRESS is a PL/SQL package body that supports the maintenance of person addresses, with a particular emphasis on the validation rules governing address records in Oracle EBS Human Resources. The package encapsulates the logic required to detect duplicate or overlapping address entries and to validate the mandatory attributes of an address before it is created or modified. Its naming and contents tie it to the person address ("PL") functionality, and the presence of internal error messages such as HR_PL_DUPLICATE_ADDRESS and HR_PL_ADDRESS_TYPE_NULL confirms that it operates within the HR message dictionary (application 800).

The package is classified as OTHER in the ETRM metadata rather than as a public API, and it is referenced by three other packages, indicating that it functions primarily as a supporting validation utility for higher-level address processing routines rather than as a standalone integration point.

Key Procedures and Functions

• CHECK_ADDRESS_UNIQUE — Determines whether a proposed address overlaps an existing address for the same person and address type across the supplied effective date range. When an overlap is detected and no override has been requested, it raises the HR_PL_DUPLICATE_ADDRESS error. The procedure accepts an overlap-validation override flag, added to support the resolution of an earlier defect, allowing callers to bypass the duplicate check when required.
• CHECK_PL_ADDRESS — Performs attribute-level validation of a person address. Its documented behaviour includes verifying that the address type is populated, raising HR_PL_ADDRESS_TYPE_NULL when it is not, and checking that required address elements such as the street name are supplied. It likewise observes the overlap-validation override parameter.
• CREATE_PL_ADDRESS — Provides the creation path for a person address record, invoking the validation logic before the address is persisted.
• UPDATE_PL_ADDRESS — Provides the modification path for an existing person address, applying the same validation and uniqueness rules to the changed data.
• UPDATE_PL_ADDRESS_STYLE — Handles updates relating to the address style associated with the record, allowing the formatting or style attribute of a person address to be maintained.

Tables Accessed

The documented table reference is PER_ADDRESSES, accessed through its APPS synonym. CHECK_ADDRESS_UNIQUE queries PER_ADDRESSES with an EXISTS subquery to identify any existing row that shares the person identifier and address type and whose date_from/date_to range intersects the proposed effective dates. The nvl fallback to 31-12-4712 in the source ensures that open-ended addresses are correctly treated as extending to the end of time. The create, update, and style procedures rely on the same table to persist and amend address rows.

Usage Notes

Typical invocation occurs from the Oracle HRMS person address maintenance forms, where the validation procedures are called before a row is committed, ensuring that duplicate or incomplete addresses are rejected with a user-facing HR message. Custom code performing bulk address loads or conversions can call the same procedures to enforce identical validation rules, although the package's OTHER classification means it is not a formally supported public API and its signature should be treated as subject to change between releases. Because the metadata is drawn from an older source header, implementers should verify parameter behaviour against the specific 12.1.1 or 12.2.2 installation, particularly the overlap-validation override introduced for defect 4210646.