Search Results incl_geo_type_tbl_type

Overview

APPS.HZ_GEO_STRUCTURE_PUB_UIW is a public PL/SQL package in the Oracle E-Business Suite Trading Community Architecture (TCA) geography model. It provides the programmatic interface through which geography types, geography structures, geography relationships, and zone types are created and maintained in the HZ geography tables. These definitions form the backbone of the TCA geography hierarchy, which in turn drives address validation, tax jurisdiction determination, territory assignment, and shipping and receiving logic across Order Management, Receivables, and related modules.

The package is defined with AUTHID CURRENT_USER, meaning that privilege checking on referenced objects is performed against the invoking schema rather than the package owner. Its header declares a set of PL/SQL record and collection types that describe the shapes of the data it manipulates. The collection type incl_geo_type_tbl_type, referenced in your search, is declared as a table of VARCHAR2(30) indexed by BINARY_INTEGER — an associative array of geography type codes. It is intended to carry a list of included geography types, but within the visible source the use of this type is commented out in the zone_type_rec_type record definition, indicating that the included-geography-type attribute was not enabled in this version of the package.

Companion record types defined in the header include geography_type_rec_type, geo_structure_rec_type, geo_rel_type_rec_type, and zone_type_rec_type, each carrying fields such as geography type, parent geography type, created_by_module, and application_id.

Key Procedures and Functions

The package exposes six documented entry points:

• CREATE_GEOGRAPHY_TYPE — Creates a geography type, accepting a geography type record. Messages are governed by the standard p_init_msg_list flag and the outcome is returned via x_return_status using FND_API status constants.
• CREATE_GEO_STRUCTURE — Establishes a geography structure, defining the hierarchical relationship between a geography and its parent geography type.
• DELETE_GEO_STRUCTURE — Removes an existing geography structure entry.
• CREATE_GEO_REL_TYPE — Creates a geography relationship type, which governs which geography types may be related as parent and child and the status of that relationship.
• CREATE_ZONE_TYPE — Creates a zone type, including attributes such as geography use, the limiting geography, and the postal code range flag.
• UPDATE_ZONE_TYPE — Modifies an existing zone type definition.

Tables Accessed

The only table documented as referenced through APPS synonyms is PLITBLM, the standard TCA multi-lingual (translation) table used to hold translated name and description columns. The package writes translated geography type and zone type names there so that they can be resolved in the session language. The remaining DML is directed at the underlying HZ geography definition tables maintained by the TCA geography model.

Usage Notes

HZ_GEO_STRUCTURE_PUB_UIW is an internal implementation wrapper rather than a general-purpose public API; the "UIW" suffix indicates it is a user-interface wrapper generated to support Oracle Forms and similar callers. It is normally invoked indirectly, from TCA setup forms or from other packages — the metadata shows it is referenced by one other package — rather than being called directly from customer extensions. Oracle recommends that customers and integrators use the supported public geography APIs instead of calling this package directly, because the wrapper signature and internal behavior are subject to change without notice. Where custom code must seed geography or zone type metadata, it should do so through the supported published interface and always pass p_init_msg_list consistently with the FND_API convention.