Search Results per_au_add_leg_hook




Overview
Explore in AI Chat

Overview

The APPS.PER_AU_ADD_LEG_HOOK package is an Oracle E-Business Suite localization hook that supports Australian statutory address validation requirements within the Oracle HRMS (Human Resources Management System) address model. In Oracle EBS 12.1.1 and 12.2.2, address records for person and organization parties are stored in the PER_ADDRESSES table, and Oracle provides a set of country-specific "hooks" that allow legislation-specific business rules to be applied at the point an address is created or modified. The PER_AU_ADD_LEG_HOOK package is the Australian (AU) implementation of that extensibility mechanism.

Its name reflects its role: PER (the PER schema, which owns HRMS person and address data), AU (the Australian legislation), and ADD_LEG_HOOK (an "address legislative hook"). The package contains no business data of its own; it exposes validation entry points that the address maintenance layer calls so that Australian-specific checks — principally involving the region and country values held on an address — are enforced before the record is committed. It is classified in ETRM as an OTHER API, meaning it is an internal extensibility package rather than a public, supported business API.

Key Procedures and Functions

The package header declares two documented procedures. Both are void (they perform validation, not data retrieval), consistent with the hook pattern in which the caller expects either normal completion or a raised error.

  • CHECK_ADDRESS_INS — Invoked during the insertion of a new address. It receives the address style, the primary region value, and the country, and validates that the combination is acceptable for Australian address processing before the address row is created.
  • CHECK_ADDRESS_UPD — Invoked when an existing address is updated. It receives the address identifier along with the region and country values, allowing the hook to validate the modified address against the stored address record.

No parameter lists should be inferred beyond those evident in the source header; the package defines no additional documented functions.

Tables Accessed

The ETRM metadata records a single referenced table, PER_ADDRESSES, accessed through an APPS synonym. This table is the repository for address records associated with persons, organizations, and other party types in Oracle HRMS. The hook package consults this table primarily in the update path, where the incoming address identifier is used to relate the validation to the existing address row. Because it is a validation hook, the package is not expected to insert, update, or delete PER_ADDRESSES itself; the owning address-maintenance code performs the DML after the hook returns successfully.

Usage Notes

PER_AU_ADD_LEG_HOOK is not normally invoked directly by end users or by custom interfaces. It is called automatically by the Oracle HRMS address maintenance logic — typically the Forms-based address entry screens and the underlying address API layer — whenever an Australian address is inserted or updated, provided the Australian localizations/legislation are installed and enabled. Because two other packages reference it, it forms part of a small dependency chain within the PER schema's address handling.

From a customization standpoint, the package is a candidate for extension rather than replacement: developers implementing country-specific validation for Australia can inspect or extend the logic in the CHECK_ADDRESS_INS and CHECK_ADDRESS_UPD bodies, but the procedures are internal and unsupported for direct calls. Any change should be applied with care, since the address entry path depends on these hooks completing without raising unexpected exceptions. In upgrade planning between 12.1.1 and 12.2.2, the object remains a stable internal hook with an unchanged two-procedure interface.