Search Results hz_geo_structure_pub_uiw




Overview
Explore in AI Chat

Overview

APPS.HZ_GEO_STRUCTURE_PUB_UIW is a public PL/SQL package body within the Oracle E-Business Suite Trading Community/Receivables (HZ) schema. The suffix "UIW" denotes that the package acts as a User Interface Wrapper — a thin API layer that exposes geography and zone structure maintenance operations to Oracle Forms, Oracle AOL, or other front-end callers, while delegating the substantive business logic to the underlying HZ_GEOGRAPHY_STRUCTURE_PUB package. It forms part of the geography and zone model used by Trading Community Architecture (TCA) to define countries, geography types, hierarchical geography structures, relationship types, and zones. These definitions underpin territory assignment, tax and jurisdiction determination, shipping and receiving validation, and address resolution across EBS modules such as Order Management, Receivables, and Payables.

Key Procedures and Functions

The documented package exposes six procedures, each aligning to a specific setup or maintenance operation within the geography model:

  • CREATE_GEOGRAPHY_TYPE — Creates a new geography type (for example, a classification level such as Country, State, or City) in the geography type hierarchy used when defining geography structures.
  • CREATE_GEO_STRUCTURE — Creates a geography structure, defining the ordered hierarchy of geography types that make up a geographic model.
  • DELETE_GEO_STRUCTURE — Removes an existing geography structure definition.
  • CREATE_GEO_REL_TYPE — Creates a geography relationship type, used to represent non-hierarchical or associative relationships between geographies.
  • CREATE_ZONE_TYPE — Creates a zone type definition, establishing the classification under which zones are subsequently created and maintained.
  • UPDATE_ZONE_TYPE — Modifies an existing zone type definition.

Per the ETRM metadata, no parameter lists are published for these procedures; callers should reference the package specification in the database for exact signatures and argument ordering.

Tables Accessed

The documented dependency information identifies a single table reference through an APPS synonym: PLITBLM. This is the standard PL/SQL table (index-by table) backing structure used by the Oracle Forms/PL/SQL interface layer, rather than a business data table. The package relies on HZ_GEOGRAPHY_STRUCTURE_PUB for all persistent inserts, updates, and deletes against the HZ geography and zone tables, together with the FND_API error-handling framework and the HZ_GEO_STRUCTURE_PUB_UIW specification. Because the wrapper delegates DML to the underlying public API, direct table access from this package is deliberately minimal, preserving the separation between the UI wrapper and the PL/SQL business logic layer.

Usage Notes

HZ_GEO_STRUCTURE_PUB_UIW is typically invoked from Oracle Forms-based setup windows in the Trading Community Manager responsibility, where administrators define geography types, geography structures, relationship types, and zone types. Each procedure corresponds to a form-level save or delete action that is passed through the wrapper to HZ_GEOGRAPHY_STRUCTURE_PUB. The package is listed as referenced by one other database object, indicating it is consumed by the associated specification and by dependent packages rather than being a widely reused integration point. Customizations and third-party integrations should not call this UI wrapper directly; the supported integration entry point for geography and zone maintenance is HZ_GEOGRAPHY_STRUCTURE_PUB. Its presence in the dependency chain means changes to the underlying public API can affect this wrapper, so it should be reviewed during upgrades between EBS 12.1.1 and 12.2.2. Because the ETRM metadata documents the object as VALID but with a limited dependency footprint, developers should verify the current package specification in the target environment before relying on any behavior beyond the six documented procedures.