Search Results zx_event_class_rectype




Overview
Explore in AI Chat

Overview

ZX_GLOBAL_STRUCTURES_PKG is a foundational PL/SQL package in the Oracle E-Business Suite E‑Business Tax (E‑Tax / ZX) module. It declares the shared global data types and record structures that the rest of the ZX application programming interface relies upon, and provides initialization routines for the transient tables and PL/SQL tables used during tax determination, tax calculation, and tax reporting. As evidenced by the declaration section, the package defines strongly typed, index-by-BINARY_INTEGER PL/SQL table types covering the common column widths used throughout the tax schema — NUMBER, DATE, and VARCHAR2 variants ranging from VARCHAR2(1) up to VARCHAR2(2000). These typed collections allow other ZX packages to pass sets of values between procedures without repeated local type declarations, ensuring consistent semantics across the module. The package also caches event class mapping information for the duration of a session via the ZX_EVENT_CLASS_RECTYPE record structure. With the owner set to APPS and an API classification of OTHER, the package is an internal utility intended for use by Oracle EBS tax code rather than a public, customer-callable API.

Key Procedures and Functions

The documented procedures reflect two broad responsibilities: initializing working/global temporary structures, and retrieving configuration information from the tax setup repository.

  • INIT_TAX_REGIME_TBL — initializes the PL/SQL table that holds tax regime definitions so downstream tax processing can iterate over applicable regimes.
  • INIT_DETAIL_TAX_REGIME_TBL — initializes the detail-level tax regime table used for more granular regime handling.
  • INIT_TRX_LINE_DIST_TBL — initializes the transaction line distribution table that carries tax distribution amounts.
  • INIT_TRX_LINE_APP_REGIME_TBL — initializes the transaction-line/applied-regime association table.
  • INIT_TRX_HEADERS_GT — initializes the global temporary table populated with transaction header data.
  • INIT_TRX_LINES_GT — initializes the global temporary table populated with transaction line data.
  • DELETE_TRX_LINE_DIST_TBL — clears the transaction line distribution table, typically as part of cleanup between processing runs.
  • GET_PRODUCT_OPTIONS_INFO — returns product options information used by tax processing to determine applicable configuration.
  • GET_REGIMES_USAGES_INFO — returns information about regime usages, describing how regimes are applied for given contexts.

Tables Accessed

The package reads configuration and reference data through APPS synonyms. Tax setup is sourced from ZX_ACCOUNTS, ZX_CONDITIONS, ZX_CONDITION_GROUPS_B, ZX_DETERMINING_FACTORS_B, and ZX_DET_FACTOR_TEMPL_B, which together define the tax rules, conditions, and determining factors. Party and location context is obtained from HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_GEOGRAPHIES, HZ_GEOGRAPHY_TYPES_B, and HZ_GEO_NAME_REFERENCES, while country validation uses FND_TERRITORIES. Supplier-related context comes from AP_SUPPLIERS and AP_SUPPLIER_SITES, and inventory item information is read from MTL_SYSTEM_ITEMS_B. These reads support the initialization procedures and the getter functions.

Usage Notes

ZX_GLOBAL_STRUCTURES_PKG is referenced by 49 other packages, making it one of the more widely depended-upon structures in the E‑Tax codebase. It is invoked internally when the E‑Tax engine processes transactions — for example, during tax determination on sales and purchasing documents — to initialize the transient collections and global temporary tables, and to fetch product option and regime usage configuration. It is not a user-facing API and is not intended to be called directly from forms or custom concurrent programs; instead, customizations should use the supported ZX public APIs. The header comment and the Bug 10384862 marker on VARCHAR2_300_tbl_type indicate that the type definitions have been amended over time through bug fixes, so the exact set of declared types is version-dependent between 12.1.1 and 12.2.2. Direct use of these global types in custom code is discouraged because their definition is controlled by Oracle and may change during patching.