Search Results x_description

Overview

The APPS.IEC_HZ_PHONE_AREA_CODES_PKG package body provides the server-side data access layer for the HZ_PHONE_AREA_CODES table, which stores the telephone area code definitions used by Oracle E-Business Suite telephony and customer relationship management functionality. Area codes are referenced when validating and formatting contact telephone numbers captured against parties, accounts, and contacts in the Trading Community Architecture (TCA) model. The package encapsulates the standard EBS table-handler pattern: insert, lock, update, delete, and seed-data load operations are exposed as discrete program units so that Oracle Forms, concurrent programs, and integration code can manipulate area code records without embedding direct DML. In ETRM terms the package is classified as OTHER rather than a public API, meaning it is intended for internal use by the owning product rather than as a supported integration interface.

Key Procedures and Functions

The package exposes seven documented program units:

• INSERT_ROW — Inserts a new area code record into HZ_PHONE_AREA_CODES, populating territory code, phone country code, area code, description, and the standard WHO columns (created by, creation date, last updated by, last update date, last update login, object version number), then returns the new ROWID to the caller.
• LOCK_ROW — Acquires a FOR UPDATE NOWAIT lock on the identified row so that optimistic concurrency can be enforced before an update. It compares the stored phone country code, description, and object version number, and raises a form-level record-deleted exception when the row no longer exists.
• UPDATE_ROW — Applies modified attribute values to an existing area code row, including the description and audit columns.
• DELETE_ROW — Physically removes the identified area code row.
• LOAD_ROW — Loads a single row from seed or external data, inserting or updating as required; used by data-migration and setup-loading utilities.
• LOAD_SEED_ROW — A seed-data variant of the load routine that handles translated seed rows, ensuring the base record and its language-specific description are consistent.
• TRANSLATE_ROW — Maintains the translated description for a given language, allowing the area code description to be presented in the session's language.

Tables Accessed

The package reads and writes HZ_PHONE_AREA_CODES through the APPS synonym; this is the primary entity table holding territory code, phone country code, area code, description, and audit columns. It also references FND_LANGUAGES, the Oracle Application Object Library language repository, which supports the translation and seed-load procedures by validating and resolving the language in which a translated description is stored.

Usage Notes

Because the package follows the generated table-handler convention, it is invoked primarily from the Oracle Forms screen that maintains phone area code setup, where the INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW procedures back the block-level DML events. The LOAD_ROW, LOAD_SEED_ROW, and TRANSLATE_ROW procedures are typically driven by concurrent programs and seed-data loaders during implementation, patching, or language installation. In the context of a search for x_description, the relevant column is DESCRIPTION: it is passed as X_DESCRIPTION into INSERT_ROW, LOCK_ROW, and the translated variants, and is the field the LOCK_ROW cursor compares to detect concurrent modification. Custom code should treat this package as internal and, where a supported interface is required, use the TCA public APIs instead of calling these procedures directly.