Search Results delete_gnr

Overview

HZ_GNR_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Geography Name Referencing (GNR) infrastructure within Oracle's Trading Community Architecture (TCA) and Tax modules. Geography name referencing links a flexible geography hierarchy definition (tax geography model) to an actual territory hierarchy, mapping geography identifiers to the naming conventions and reference relationships used by tax determination and location validation. The package handles the generation, searching, validation, and deletion of these geography name references, enabling jurisdictions to be resolved from address and location data.

The package is classified as OTHER in the ETRM metadata and carries a status of VALID. It depends on the FND_API foundation layer (SYS.STANDARD standard PL/SQL) and exposes six documented program units. It is referenced by four other packages: HZ_GNR_PUB, HZ_GNR_PVT, HZ_GNR_UTIL_PKG, and HZ_TAX_ASSIGNMENT_V2PUB, confirming its role as a low-level worker package within the GNR processing stack.

Key Procedures and Functions

• CREATE_GEO_NAME_REF — Creates a geography name reference record, establishing the association between a geography identifier and its referenced name within the configured geography structure.
• PROCESS_GNR_WORKER — The primary worker routine that processes geography name reference generation on a batch basis, typically invoked during concurrent processing of large geography hierarchies.
• SRCHGEO — Performs searches against geography data, returning matching geography records for a given search criterion.
• DELETE_GNR — Removes existing geography name reference records, supporting maintenance and regeneration of reference data.
• VALIDATELOC — Validates a location against the geography name reference model, confirming that the location resolves correctly within the defined hierarchy.
• VALIDATEHRLOC — Validates an HR location record against geography name reference data, supporting the intersection of Oracle HRMS locations and TCA geography structures.

Tables Accessed

The package reads and writes several core TCA and geography tables through APPS synonyms:

• HZ_GEO_NAME_REFERENCES, HZ_GEO_NAME_REFERENCE_LOG, and HZ_GEOGRAPHY_IDENTIFIERS — the principal storage for geography name reference records and their audit trail.
• HZ_GEO_STRUCT_MAP — defines the mapping arrangement of the geography structure used during reference creation.
• HZ_LOCATIONS, HZ_CUST_ACCT_SITES_ALL, HZ_PARTY_SITES, and HZ_ADDRESS_USAGES — provide location and site context used in validation and search operations.
• HR_LOCATIONS_ALL — supplies HR location records validated by VALIDATEHRLOC.
• FND_TERRITORIES — provides territory code reference data.
• PLITBLM — a PL/SQL index-by table used internally for in-memory processing.

Usage Notes

HZ_GNR_PKG is not intended for direct end-user invocation. It is called from higher-level packages within the GNR family (HZ_GNR_PUB, HZ_GNR_PVT, HZ_GNR_UTIL_PKG) and from HZ_TAX_ASSIGNMENT_V2PUB during tax assignment processing. Practically, it executes when geography name references must be generated or refreshed, such as after a geography hierarchy is defined or modified in TCA administration, or when locations require validation against the reference model. Batch generation may be triggered through concurrent programs that drive PROCESS_GNR_WORKER. Custom extensions integrating with Oracle Tax or TCA should invoke the public wrapper packages rather than HZ_GNR_PKG directly, since the package is a supporting internal component within the geography name referencing framework.