Search Results delete_geo_identifier

Overview

APPS.HZ_GEOGRAPHY_PUB_UIW is the user-interface wrapper package body for the Oracle E-Business Suite Geography public API, HZ_GEOGRAPHY_PUB. Its principal role is to act as a thin, UI-facing veneer over the underlying business logic housed in HZ_GEOGRAPHY_PUB, exposing the same operations to Oracle Forms and other front-end callers while managing the standard PL/SQL API error-handling contract. The package is classified under ETRM as an API of type OTHER and is owned by the APPS schema.

The package supports the creation and maintenance of the geography model in Oracle EBS: master geography relations (hierarchies between geographies such as country, state, and city), geography identifiers, geography ranges, and zone definitions and membership. Each documented procedure follows the conventional EBS API signature pattern, taking p_init_msg_list to control message stack initialization, accepting an inbound record type, and returning x_return_status, x_msg_count, and x_msg_data to communicate outcome and diagnostics. The documented source shows each UIW procedure copying the caller's record into the corresponding HZ_GEOGRAPHY_PUB record type before delegating to the base package, which keeps the public contract stable while insulating UI callers from internal record definitions.

Key Procedures and Functions

• CREATE_MASTER_RELATION — Creates a relationship between a geography and its parent geography in the master geography hierarchy. It accepts a master relation record and returns the new relationship identifier along with the standard return status and message outputs.
• UPDATE_RELATIONSHIP — Modifies an existing geography relationship, permitting changes to its effective dating and related attributes.
• CREATE_GEO_IDENTIFIER — Creates an identifier record associated with a geography, such as a coded or alternate designation used for external reference.
• UPDATE_GEO_IDENTIFIER — Updates an existing geography identifier record.
• DELETE_GEO_IDENTIFIER — Removes a geography identifier record. This is the procedure referenced by the search term delete_geo_identifier; it is the documented deletion entry point for geography identifiers at the UIW layer.
• CREATE_MASTER_GEOGRAPHY — Creates a master geography record, the top-level entity to which relations, identifiers, and ranges attach.
• UPDATE_GEOGRAPHY — Updates an existing master geography record.
• CREATE_GEOGRAPHY_RANGE — Creates a geography range, defining numeric or code ranges associated with a geography for matching and validation.
• UPDATE_GEOGRAPHY_RANGE — Updates an existing geography range definition.
• CREATE_ZONE_RELATION — Creates a relationship between a zone and a geography, establishing zone membership.
• CREATE_ZONE — Creates a zone, the grouping construct used for tax, shipping, and territory determination.

All eleven documented routines are procedures; none are documented as functions, and none expose parameters directly at the UIW layer beyond the conventions noted above.

Tables Accessed

The ETRM metadata documents a single table reference for this package: PLITBLM, accessed through an APPS synonym. PLITBLM is the standard EBS PL/SQL API message and error stack table, used by the message-handling infrastructure to accumulate and retrieve messages generated during API calls. Its presence here confirms that HZ_GEOGRAPHY_PUB_UIW participates in the standard message-stack pattern. Persistent geography, identifier, relationship, range, and zone data are not written directly by the UIW layer; those operations are performed by the delegated calls into HZ_GEOGRAPHY_PUB, which owns the base geography tables.

Usage Notes

HZ_GEOGRAPHY_PUB_UIW is invoked from geography maintenance user interfaces and from custom code that prefers the UI-facing wrapper over the base public API. Callers should initialize the message list according to their needs, pass a fully populated record type, and inspect x_return_status before committing. When x_return_status indicates error, x_msg_count and x_msg_data should be examined, or FND_MSG_PUB used to retrieve the full stack. Because the package delegates to HZ_GEOGRAPHY_PUB, behavior, validation, and error semantics mirror the base API. The ETRM metadata records that this package is referenced by one other package, indicating limited but defined reuse. The header comment in the source dates the original creation to 2005, and the package remains documented through EBS 12.1.1 and 12.2.2.