Search Results g_usage_tbl

Overview

APPS.HZ_GNR_GEN_PKG is a PL/SQL package body in the Oracle E-Business Suite Trading Community (Receivables/Customer) module that belongs to the Geography Name Referencing (GNR) infrastructure. Its principal business function is to dynamically generate PL/SQL source code — both package specifications and package bodies — for geography-related validation and usage logic. This is a code-generator ("gen" in the name) rather than an ordinary runtime API: it emits the text of other PL/SQL packages into a buffer, formats it, and validates the generated specification and body.

The package is classified in ETRM as OTHER and is owned by APPS. A striking structural characteristic is that nearly all of its declarations are private. The package body declares private global variables for mapping records, mapping detail rows, and usage rows, together with a package name and indentation variables. It then forward-references a set of private helper procedures whose names reveal a text-generation engine: genSpec, genBody, genPkgSpecHdr, genPkgSpecTail, procBegin, procEnd, funcBegin, funcEnd, validateSpec, validateBody, plus formatting utilities l, li, and functions such as useCode. The user search term "fix_child" relates to the child-record maintenance patterns this generator emulates for hierarchy and usage data.

Key Procedures and Functions

The ETRM metadata documents a single public entry point:

• GENPKG — The sole documented procedure. It is the driver that constructs and emits the generated PL/SQL package text, orchestrating the private genSpec and genBody helpers and validating the result via validateSpec and validateBody.

The numerous private routines shown in the source (for example genPkgSpecHdr, procBegin, funcBegin, l, li) support line writing, indentation, and header/footer formatting and are not exposed to callers. Parameter lists are not documented and are therefore not asserted here.

Tables Accessed

The package reads the following tables via APPS synonyms, all within the Trading Community geography model:

• HZ_GEOGRAPHIES — Master geography records supplying the elements the generated code references.
• HZ_GEO_STRUCT_MAP — Geography structure mapping definitions.
• HZ_GEO_STRUCT_MAP_DTL — Child (detail) rows of the structure map, central to the hierarchy/child-handling logic.
• HZ_ADDRESS_USAGES — Address usage definitions governing validation rules.
• HZ_ADDRESS_USAGE_DTLS — Detail rows of address usages.
• PLITBLM — The standard EBS PL/SQL table used as the buffer for assembling generated source lines.

Usage Notes

HZ_GNR_GEN_PKG is an internal infrastructure package rather than an end-user API. It is normally invoked during geography name referencing setup and regeneration, when geography structures or address usages change and the corresponding validation packages must be rebuilt. The ETRM metadata records that it is referenced by three other packages, confirming its role as a shared generator dependency. It is not typically called directly from Oracle Forms; its output — generated PL/SQL packages — is what applications invoke at runtime. Customizations should avoid modifying this package and instead rely on the supported geography setup flows, since regeneration may overwrite generated artifacts. Because the header indicates a build dated 2009 (120.32), behavior is consistent across EBS 12.1.1 and 12.2.2.