Search Results iec_hz_phone_area_codes_pkg




Overview
Explore in AI Chat

Overview

IEC_HZ_PHONE_AREA_CODES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that encapsulates the data-maintenance logic for the HZ_PHONE_AREA_CODES entity, the Trading Community Architecture (TCA) table that stores valid telephone area codes and their descriptions by territory and country. In EBS 12.1.1 and 12.2.2, telephone number validation and formatting for parties, sites, contacts, and accounts relies on this seed data, so the package provides the standard, supported interface through which area code rows are inserted, locked, updated, deleted, loaded, and translated. By centralizing these operations, the package protects the integrity of the reference data that downstream telephony-facing setup — such as country code and area code combinations used on customer and supplier records — depends on. Its header signature indicates it was last revised in the 11i/12.0 era (version 120.1) and registered with the "noship" flag, confirming it is shipped as part of the standard product file set.

Key Procedures and Functions

The package exposes seven documented procedures, all of which are public cursor-style entry points rather than functions returning values:

  • INSERT_ROW — Creates a new phone area code record for a given territory, phone country code, and area code, capturing the description, audit columns, and object version number.
  • LOCK_ROW — Acquires a pessimistic lock on an existing area code row so that concurrent updates do not overwrite each other; it is invoked before an update in the standard TCA pattern.
  • UPDATE_ROW — Modifies the description of an existing area code record while refreshing the audit columns and incrementing the object version number.
  • DELETE_ROW — Removes an area code record identified by the territory code and area code keys.
  • LOAD_ROW — Loads a seed row during the standard seed-data upload process, accepting an owner parameter that governs which application's data is being loaded.
  • LOAD_SEED_ROW — Performs the actual seed insertion during the upload cycle for a specific upload mode, again taking an owner parameter.
  • TRANSLATE_ROW — Populates translated descriptions for an existing area code row, keyed by territory, country code, and area code.

All procedures share the same business key: territory code, phone country code, and area code, with the description as the principal non-key attribute.

Tables Accessed

The package operates on two documented tables, both accessed through APPS synonyms:

  • HZ_PHONE_AREA_CODES — The primary table. INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOAD_ROW, LOAD_SEED_ROW, and TRANSLATE_ROW all read and write rows here, while LOCK_ROW selects the row for update. This table holds the valid area code and description combinations used in telephone number validation.
  • FND_LANGUAGES — Referenced to support the multilingual description handling exercised by TRANSLATE_ROW and the seed-load procedures, ensuring translated descriptions are written only for installed and active languages.

No additional tables are documented as referenced by this package.

Usage Notes

IEC_HZ_PHONE_AREA_CODES_PKG is not typically invoked directly by end users. Its most common invocation paths are: the TCA administration forms that maintain phone area codes, the standard seed-data loader (FNDLOAD / loader concurrent programs) that calls LOAD_ROW and LOAD_SEED_ROW to populate or refresh area code reference data by owner, and concurrent translation processes that call TRANSLATE_ROW to maintain descriptions in supported languages. Custom code that must add or correct area code data should call these procedures rather than issuing direct DML against HZ_PHONE_AREA_CODES, since the procedures enforce the audit columns, object version number, and locking conventions that Oracle EBS expects. The package is referenced by zero other packages per the ETRM metadata, confirming it is a leaf-level data-maintenance API rather than a shared utility. The query that surfaced this object — a search for a consumer mobile number in Noida — has no relationship to the package's function; such data resides in party or contact telephone records, not in the area code reference table itself.