Search Results hz_geo_struct_map_pvt




Overview
Explore in AI Chat

Overview

HZ_GEO_STRUCT_MAP_PVT is a private PL/SQL package body in the APPS schema that supports the geography structure mapping functionality within the Oracle E-Business Suite Trading Community / Receivables (HZ) module. It exists to service the HZ_GEO_STRUCT_MAP entity, which maintains the relationship between geography structures and the hierarchical geography data used throughout Oracle EBS. Geography structures underpin the classification of countries, states, provinces, counties, cities, and postal boundaries, and this mapping is foundational for address validation, tax jurisdiction determination, and territory assignment.

The package is explicitly classified as a PVT (private) API. It is intended for internal consumption by other HZ packages rather than direct invocation by external or custom code. The ETRM metadata confirms the object is VALID, owns the APPS schema, and is not referenced by any database object outside of the HZ package family.

Key Procedures and Functions

The documented package exposes four procedures, all following the standard Oracle EBS table handler pattern:

  • INSERT_ROW — Creates a new geography structure mapping record in the underlying table, performing the necessary validations and defaulting of columns before the insert is committed.
  • LOCK_ROW — Acquires a row-level lock on an existing mapping record, typically invoked prior to an update to prevent concurrent modification by competing sessions.
  • SELECT_ROW — Retrieves a single mapping row, populating output parameters with the current column values for the given key.
  • DELETE_ROW — Removes a mapping record, supporting the maintenance of geography structures when hierarchies are revised or retired.

These procedures embody the standard CRUD-style interface applied across HZ private packages. Parameter lists are not reproduced here, as the ETRM excerpt does not enumerate them; consumers should not assume signatures.

Tables Accessed

The package operates against the HZ_GEO_STRUCT_MAP table, accessed via its APPS synonym. This table stores the associations between geography structures and their constituent geography elements. The insert, select, lock, and delete operations correspond directly to the maintenance of these mappings, which are consumed at runtime by geography validation and territory logic elsewhere in the HZ schema.

Usage Notes

As a private package, HZ_GEO_STRUCT_MAP_PVT is not exposed for direct customer invocation. It is referenced by one other package, which orchestrates calls to the CRUD procedures during geography structure administration. Typical invocation occurs through Oracle Forms-based setup screens and geography maintenance flows rather than through concurrent programs. Custom code should avoid calling this package directly; instead, customers should rely on the public HZ APIs and supported setup interfaces. Dependencies include FND_API, FND_MESSAGE, FND_MSG_PUB, and APP_EXCEPTION for error handling and message propagation, and HZ_UTILITY_V2PUB for shared geography utilities, indicating the package participates in the standard EBS error-stack discipline. Because the object is VALID and documented, it is safe for reference purposes, but any modification or direct invocation risks invalidating dependent HZ packages during upgrades to 12.1.1 or 12.2.2.