Search Results hz_geography_validate_pvt

Overview

HZ_GEOGRAPHY_PUB is the public PL/SQL API package in the Oracle E-Business Suite Applications (APPS) schema that governs the creation and maintenance of geography and zone data within the Oracle Trading Community Architecture (TCA) model. Geographies represent the hierarchical political and administrative structures (country, state, county, city, postal code) used throughout EBS for address validation, tax jurisdiction determination, territory assignment, and party location management. The package is classified as a PUB (public) API, meaning it is intended as a supported interface for external callers — both standard EBS modules and customer extensions — rather than an internal utility. It is a member of the HZ (Trading Community) module family and is dependent on the FND_API framework for its standard return-status and message-handling conventions, as well as on MDSYS.SDO_GEOMETRY for spatial geometry handling. The object is documented as VALID in the ETRM repository for release 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented API exposes eleven procedures and functions covering geography master data, identifiers, ranges, and zone relationships:

CREATE_MASTER_GEOGRAPHY — Creates a top-level master geography record, typically for a country or other root-level administrative entity.
CREATE_MASTER_RELATION — Establishes a relationship between a master geography and its related hierarchy nodes.
CREATE_GEO_IDENTIFIER — Adds an identifier (for example, a postal or ISO code) to an existing geography.
UPDATE_GEO_IDENTIFIER — Modifies an existing geography identifier.
DELETE_GEO_IDENTIFIER — Removes a geography identifier.
UPDATE_GEOGRAPHY — Updates attributes of an existing geography record.
UPDATE_RELATIONSHIP — Modifies an existing geography relationship.
CREATE_GEOGRAPHY_RANGE — Defines a numeric or alphanumeric range associated with a geography, commonly used for postal code or address range matching.
UPDATE_GEOGRAPHY_RANGE — Modifies an existing geography range definition.
CREATE_ZONE_RELATION — Creates a relationship linking a geography to a zone, supporting zone-based processing such as tax or territory rules.
CREATE_ZONE — Creates a zone entity used within the geography hierarchy model.

Each procedure follows the FND_API standard, returning a success/failure status and error message via the conventional API output parameters.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

HZ_GEOGRAPHIES — the core geography master table.
HZ_GEOGRAPHY_IDENTIFIERS — geography identifier values.
HZ_GEOGRAPHY_RANGES — range definitions for geographies.
HZ_GEOGRAPHY_TYPES_B — valid geography type definitions.
HZ_GEO_STRUCTURE_LEVELS — hierarchy level definitions for the geography structure.
HZ_HIERARCHY_NODES — nodes within the geography hierarchy.
HZ_RELATIONSHIPS and HZ_RELATIONSHIP_TYPES — relationship records and their type definitions.
FND_TIMEZONES_B — time zone reference data associated with geographies.
DUAL and PLITBLM — utility objects used for PL/SQL convenience and bulk operations.

Usage Notes

HZ_GEOGRAPHY_PUB is invoked primarily by the TCA geography maintenance UI, the geography validation infrastructure (notably HZ_GEOGRAPHY_VALIDATE_PVT, the object referenced in the originating search), the UI wrapper HZ_GEOGRAPHY_PUB_UIW, and migration utilities such as ZX_GEO_JUR_MIGR_PKG and ZX_HR_LOCATIONS_GNR_HOOK. The ETRM metadata confirms that it is referenced by four other packages. Customers and integrators should call this public API, rather than inserting directly into the underlying HZ tables, to ensure validation, hierarchy consistency, and FND_API-compliant error handling.

PACKAGE: APPS.HZ_GEOGRAPHY_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:HZ_GEOGRAPHY_PUB, status:VALID,
PACKAGE: APPS.HZ_GEOGRAPHY_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:HZ_GEOGRAPHY_PUB, status:VALID,
PACKAGE BODY: APPS.HZ_GEOGRAPHY_VALIDATE_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_GEOGRAPHY_VALIDATE_PVT, status:VALID,
PACKAGE BODY: APPS.HZ_GEOGRAPHY_VALIDATE_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_GEOGRAPHY_VALIDATE_PVT, status:VALID,
PACKAGE: APPS.HZ_GEOGRAPHY_VALIDATE_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:HZ_GEOGRAPHY_VALIDATE_PVT, status:VALID,
PACKAGE: APPS.HZ_GEOGRAPHY_VALIDATE_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:HZ_GEOGRAPHY_VALIDATE_PVT, status:VALID,
PACKAGE: APPS.HZ_GEO_STRUCTURE_VALIDATE_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:HZ_GEO_STRUCTURE_VALIDATE_PVT, status:VALID,
SYNONYM: APPS.HZ_GEO_STRUCTURE_LEVELS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_GEO_STRUCTURE_LEVELS, status:VALID,
SYNONYM: APPS.HZ_GEO_STRUCTURE_LEVELS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_GEO_STRUCTURE_LEVELS, status:VALID,
SYNONYM: APPS.HZ_GEOGRAPHY_IDENTIFIERS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_GEOGRAPHY_IDENTIFIERS, status:VALID,
PACKAGE: APPS.HZ_GEO_STRUCTURE_VALIDATE_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:HZ_GEO_STRUCTURE_VALIDATE_PVT, status:VALID,
SYNONYM: APPS.HZ_GEOGRAPHY_IDENTIFIERS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_GEOGRAPHY_IDENTIFIERS, status:VALID,
PACKAGE BODY: APPS.HZ_GEOGRAPHY_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_GEOGRAPHY_PUB, status:VALID,
SYNONYM: APPS.FND_TIMEZONES_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_TIMEZONES_B, status:VALID,
SYNONYM: APPS.FND_TIMEZONES_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_TIMEZONES_B, status:VALID,
PACKAGE BODY: APPS.HZ_GEOGRAPHY_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:HZ_GEOGRAPHY_PUB, status:VALID,
SYNONYM: APPS.HZ_GEOGRAPHIES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_GEOGRAPHIES, status:VALID,
SYNONYM: APPS.HZ_GEOGRAPHIES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_GEOGRAPHIES, status:VALID,
PACKAGE: APPS.HZ_GEOGRAPHY_VALIDATE_PVT 12.1.1
PACKAGE: APPS.HZ_GEOGRAPHY_VALIDATE_PVT 12.2.2
SYNONYM: APPS.FND_TERRITORIES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_TERRITORIES, status:VALID,
SYNONYM: APPS.FND_TERRITORIES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_TERRITORIES, status:VALID,
PACKAGE: APPS.HZ_UTILITY_V2PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:HZ_UTILITY_V2PUB, status:VALID,
APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHY_VALIDATE_PVT 12.1.1
APPS.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on HZ_GEOGRAPHY_VALIDATE_PVT 12.1.1
APPS.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on HZ_GEOGRAPHY_VALIDATE_PVT 12.2.2
APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_GEOGRAPHY_VALIDATE_PVT 12.2.2
PACKAGE: APPS.HZ_UTILITY_V2PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:HZ_UTILITY_V2PUB, status:VALID,
PACKAGE BODY: APPS.HZ_GEOGRAPHY_VALIDATE_PVT 12.1.1
PACKAGE BODY: APPS.HZ_GEOGRAPHY_VALIDATE_PVT 12.2.2
SYNONYM: APPS.HZ_RELATIONSHIPS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:HZ_RELATIONSHIPS, status:VALID,
SYNONYM: APPS.HZ_RELATIONSHIPS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:HZ_RELATIONSHIPS, status:VALID,
SYNONYM: APPS.FND_LANGUAGES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FND_LANGUAGES, status:VALID,
SYNONYM: APPS.FND_LANGUAGES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:FND_LANGUAGES, status:VALID,
PACKAGE: APPS.FND_MSG_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_MSG_PUB, status:VALID,
PACKAGE: APPS.FND_MSG_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_MSG_PUB, status:VALID,
SYNONYM: PUBLIC.PLITBLM 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
SYNONYM: PUBLIC.PLITBLM 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.FND_MESSAGE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_MESSAGE, status:VALID,
PACKAGE: APPS.FND_MESSAGE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_MESSAGE, status:VALID,
PACKAGE: APPS.FND_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,
PACKAGE: APPS.FND_API 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,