Search Results init_trx_lines_gt

Overview

ZX_GLOBAL_STRUCTURES_PKG is a PL/SQL package in the APPS schema that forms part of the Oracle E-Business Suite ETRM (E-Business Tax / Tax Regime) infrastructure. Its role is to initialize and manage the transient global temporary structures — collection types and Global Temporary Table (GTT) rows — that the tax determination and tax calculation engines rely upon when processing transactions. In EBS 12.1.1 and 12.2.2, ETRM evaluates tax regimes, determining factors, conditions, and product options for each transaction line; this package prepares the in-memory and session-scoped data structures that carry that navigation context. The package body is documented as VALID and is classified as an OTHER API rather than a public user-callable interface, indicating it is intended for internal engine consumption. It is referenced by 49 other database objects, reflecting its central position in the tax data-preparation layer, while it does not itself reference any higher-level object.

Key Procedures and Functions

• INIT_TAX_REGIME_TBL — Initializes the collection that holds tax regime information used during determination.
• INIT_DETAIL_TAX_REGIME_TBL — Initializes the detailed tax regime collection, populating finer-grained regime metadata.
• INIT_TRX_LINE_DIST_TBL — Initializes the transaction line distribution collection used to accumulate tax distribution lines.
• INIT_TRX_LINE_APP_REGIME_TBL — Initializes the collection associating transaction lines with their applicable regimes.
• INIT_TRX_HEADERS_GT — Seeds the ZX_TRX_HEADERS_GT global temporary table with header-level transaction data for the current session.
• INIT_TRX_LINES_GT — Seeds the ZX_TRANSACTION_LINES_GT global temporary table with line-level transaction data.
• DELETE_TRX_LINE_DIST_TBL — Clears the transaction line distribution structure, typically between processing iterations.
• GET_PRODUCT_OPTIONS_INFO — Retrieves product option configuration used in tax determination.
• GET_REGIMES_USAGES_INFO — Retrieves regime usage information that governs which regimes apply.

The package additionally depends on FND_API and FND_LOG for the standard API error-handling and logging framework, DBMS_UTILITY for PL/SQL utilities, and PLITBLM for character table conversion helpers.

Tables Accessed

The package reads setup and master data through APPS synonyms. ZX_REGIMES_B and ZX_REGIMES_USAGES supply regime definitions and their usages; ZX_PRODUCT_OPTIONS_ALL provides product option configuration; ZX_LINES_DET_FACTORS supplies line-level determining factors; ZX_ACCOUNTS, ZX_CONDITIONS, ZX_CONDITION_GROUPS_B, ZX_DETERMINING_FACTORS_B and ZX_DET_FACTOR_TEMPL_B provide the tax condition and determining-factor model. Party and location data are drawn from AP_SUPPLIERS, AP_SUPPLIER_SITES, HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_GEOGRAPHIES, HZ_GEOGRAPHY_TYPES_B, HZ_GEO_NAME_REFERENCES and FND_TERRITORIES, while MTL_SYSTEM_ITEMS_B supplies item context. The GTTs ZX_TRX_HEADERS_GT and ZX_TRANSACTION_LINES_GT are written by the INIT routines and subsequently read by the tax engine to perform determination and calculation.

Usage Notes

Because the object is classified as OTHER and is not referenced by any database object, it is invoked internally within the ETRM call stack rather than as a standalone entry point. Typical invocation occurs during tax engine initialization — triggered by transaction processing flows such as order entry, invoicing, and payables — where the engine first populates the header and line GTTs and the associated collections before evaluating regimes and conditions. FND_LOG calls support diagnostic tracing when ETRM debugging profiles are enabled. Custom code should not call this package directly; developers requiring regime or product option information should use the supported public ETRM APIs (for example ZX_API_PUB or ZX_TAX_DETERMINATION-related interfaces) and treat ZX_GLOBAL_STRUCTURES_PKG as an internal implementation artifact whose signature may change across patches or 12.1.1 to 12.2.2 upgrades.