Search Results update_geo_identifier

Overview

HZ_GEOGRAPHY_PUB_UIW_JW is a public PL/SQL package in the Oracle E-Business Suite Trading Community Architecture (TCA) / Receivables geography model. It belongs to the geography hierarchy framework that manages the relationships between countries, states, provinces, counties, cities, and postal code ranges. The package name prefix "HZ" identifies the Trading Community Model, while "GEOGRAPHY_PUB" classifies it as a public API surface, and "UIW_JW" denotes that it is a user-interface wrapper (UIW) generated to bridge the multi-row JTF PL/SQL table structures used by Oracle Forms with the underlying geography API logic.

The package acts as a service-layer wrapper for creating and maintaining geographic master references, geo-identifiers, geography master records, geography ranges, and the hierarchical zone relations used by geography zone assignment. It is classified in ETRM as API classification OTHER, meaning it is intended primarily for internal consumption by the geography UI rather than as a fully supported public integration interface.

Key Procedures and Functions

The documented package exposes thirteen procedures. Four are Rosetta table copy utilities that convert between JTF collection types and the package's internal geography and zone relation table types: ROSETTA_TABLE_COPY_IN_P2 and ROSETTA_TABLE_COPY_OUT_P2 handle the parent geography table, while ROSETTA_TABLE_COPY_IN_P6 and ROSETTA_TABLE_COPY_OUT_P6 handle the zone relation table by unpacking and repacking its number, varchar and date column arrays.

The remaining nine procedures form the business API. CREATE_MASTER_RELATION creates a master relationship and returns a relationship identifier. CREATE_GEO_IDENTIFIER and UPDATE_GEO_IDENTIFIER insert and maintain unique geo-identifier records tied to geography master entries. CREATE_MASTER_GEOGRAPHY and UPDATE_GEOGRAPHY manage the master geography definition itself. CREATE_GEOGRAPHY_RANGE and UPDATE_GEOGRAPHY_RANGE manage the numeric or alphanumeric ranges (such as postal code ranges) that define a geography. CREATE_ZONE_RELATION and CREATE_ZONE support the creation of zones and the relationships between parent and child zones. All procedures follow the standard EBS API convention of accepting p_init_msg_list and returning x_return_status, x_msg_count and x_msg_data. The user's search term, create_zone_relation, therefore maps directly to the zone hierarchy setup procedure.

Tables Accessed

The only table referenced through APPS synonyms in the documented metadata is PLITBLM, the standard Oracle Forms/PLSQL temporary table used for holding intermediate UI state. The actual DML against the TCA geography model tables (such as HZ_GEOGRAPHIES, HZ_GEOGRAPHY_IDENTIFIERS, HZ_GEOGRAPHY_RANGES, HZ_ZONES and their relations) is performed within the underlying geography public APIs to which these wrapper procedures delegate, which is why the wrapper itself shows limited table references.

Usage Notes

HZ_GEOGRAPHY_PUB_UIW_JW is typically invoked by the Geography maintenance Form in the Administrator responsibility, which calls the wrapper so that block-level JTF tables are translated into the API parameters. It is documented as referenced by zero other packages, confirming its role as a top-of-stack UI entry point rather than a reusable dependency. Custom code should generally call the underlying HZ_GEOGRAPHY_PUB APIs directly rather than this UIW wrapper, since it is characteristic of an unreleased 120.2-era wrapper (header dated 2006) and is not a formally supported public integration interface.