Search Results hz_geography_type

Overview

ZX_TCM_GEO_JUR_PKG is a Tax Configuration Manager (TCM) helper package in the Oracle E-Business Suite E‑Business Tax (E‑Tax / ZX) module. Its responsibility is to resolve the relationship between geographic locations, geography types, and jurisdictions so that the tax engine can determine which jurisdiction applies to a given transaction, place of supply, or party location. The package name — "GEO" for geography and "JUR" for jurisdiction — reflects that core role.

The user's search term "own_hq" relates to place-of-supply and party-location resolution logic that this package supports. Tax determination frequently needs to distinguish a party's own headquarters (own_hq) location from ship-to, bill-to, or point-of-sale locations, and that distinction is handled by the location and geography resolution routines implemented here. This package supplies the geographic and jurisdictional inputs that callers such as ZX_LINES_DET_FACTORS population logic require to identify the correct taxing jurisdiction for a line.

The package uses the standard EBS logging infrastructure (FND_LOG) through module constant 'ZX.PLSQL.ZX_TCM_GEO_JUR_PKG', and caches session-level geography-use and geo-name-reference information to reduce repeated lookups during tax processing.

Key Procedures and Functions

The package exposes six documented entry points:

• GET_POS_LOC_OR_SITE — Determines whether a given party type resolves to a point-of-sale location or a site, returning the corresponding location or site indicator. This directly supports the "own_hq" style distinction between a party's own headquarters and externally used locations.
• GET_TAX_JURISDICTIONS — Returns the set of jurisdictions applicable to a given tax and geography context, using the cached geography-use information.
• GET_ZONE — Resolves the geographic zone (jurisdiction zone) associated with a location identifier, leveraging the session-level geo name reference cache.
• GET_MASTER_GEOGRAPHY — Retrieves the master geography record for a given geography input, establishing the canonical geography in the hierarchy.
• RETRIEVE_GEO_VALUE — Extracts a specific geography value or attribute from geography data for use in downstream tax logic.
• POPULATE_LOC_GEOGRAPHY_INFO — Populates the location geography information structure that subsequent tax determination steps consume.

An internal routine, GET_LOCATION_INFO, is declared for loading location details into ZX_GLOBAL_STRUCTURES_PKG.LOC_INFO_REC_TYPE.

Tables Accessed

The package reads core geography and jurisdiction reference data through APPS synonyms. HZ_GEOGRAPHIES, HZ_GEOGRAPHY_TYPES_B, and HZ_GEO_NAME_REFERENCES provide the geographic hierarchy and naming used by GET_MASTER_GEOGRAPHY, GET_ZONE, and RETRIEVE_GEO_VALUE. Locations are sourced from HZ_LOCATIONS and HR_LOCATIONS_ALL, which support point-of-sale, site, and headquarters (own_hq) resolution. Jurisdictions come from ZX_JURISDICTIONS_B and ZX_JURISDICTIONS_GT. Party classification is drawn from ZX_PARTY_TYPES and HZ_RELATIONSHIP_TYPES. ZX_LINES_DET_FACTORS represents the tax line detail output consumed by the tax engine. Logging uses FND_LOG_MESSAGES, with DBMS_UTILITY, DUAL, and PLITBLM as utility references.

Usage Notes

ZX_TCM_GEO_JUR_PKG is classified as OTHER in the ETRM API registry and is not a public, customer-callable API. It is invoked internally by the E‑Tax engine and is referenced by eleven other packages, indicating it functions as a shared low-level service within the ZX module. It is typically executed during tax determination — when the engine resolves party and location context (including own_hq versus ship-to/site) and identifies governing jurisdictions. Implementers extending tax logic should call documented public ZX APIs rather than this package directly, though it may be traced during debugging of geography or jurisdiction resolution issues.