Search Results get_usage_api

Overview

HZ_GNR_MAP10000 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. The name follows Oracle's naming convention for generated mapping packages, and in the Oracle Trading Community Architecture (TCA) and E-Business Tax (EBTax) context the "GNR" prefix denotes geography and jurisdiction processing logic. The package serves as a validation and mapping utility within the party and tax model of the EBS data model, exposing a small, focused public API for validating geographic and tax-related data and for retrieving API usage information from Oracle's standard API framework. Because it is registered in the ETRM repository with a status of VALID and an API classification of OTHER, it is treated as a documented, callable database object rather than an internal implementation artifact.

The package is a dependent of FND_API, Oracle Application Object Library's public API framework utility package, indicating that it follows the standard EBS API programming model: bulk-processing semantics, standardized return status and message handling, and consistent exception behavior.

Key Procedures and Functions

The documented interface consists of three procedures or functions:

• GET_USAGE_API — Returns information describing how the package's API is intended to be used. This conforms to the standard EBS practice of publishing an API usage/registration routine so that callers and integration tools can introspect the interface.
• VALIDATEGEO — Validates geographic data. Depending on configuration, geography validation applies to addresses and location records created through TCA, ensuring they conform to the geography hierarchy defined in the system.
• VALIDATETAX — Validates tax-related data associated with a party, location, or transaction context, enforcing tax rules in the jurisdiction model.

No parameter lists are published in the ETRM metadata; callers should obtain the signature from the package specification in the database rather than assuming a calling convention.

Tables Accessed

The only documented table reference is PLITBLM, an APPS synonym that maps to the Oracle Financials "GL" table-name structure (the underlying object is typically a global temporary or intermediate table used by validation utilities). Because the metadata lists only this single table, HZ_GNR_MAP10000 does not appear to own large persistent data structures; its behavior is to compute validation results rather than to maintain master data. Geography and tax master data are owned by other TCA and EBTax tables.

Usage Notes

HZ_GNR_MAP10000 is referenced by zero other documented packages, and no dependent package references appear in the metadata beyond the self-reference typical of package-to-package-body dependency. This indicates the package is effectively a leaf node in the dependency graph and is called directly rather than through a wrapper. Typical invocation points include:

• TCA and EBTax validation flows triggered when address, party site, or tax registrations are created or updated.
• Concurrent programs that validate staged or imported records before they are committed.
• Custom integration code that needs to apply the same geography and tax validation rules used by the standard application.

Because the package depends on FND_API and exposes GET_USAGE_API, custom and third-party callers should follow the EBS API conventions: check the returned status, inspect the message stack on error, and treat validation routines as read-only with respect to business data.