Search Results igc_etax_util_pkg




Overview
Explore in AI Chat

Overview

IGC_ETAX_UTIL_PKG is a public PL/SQL package in the APPS schema that provides the utility layer between Oracle Procurement Contract (IGC) header and line data and the E-Business Tax (EBTax / ZX) calculation engine. Its purpose is to translate IGC purchasing and contract transactions into the interface tables required by the EBTax tax determination and calculation process, invoke that process, and return the resulting tax lines. In Oracle EBS 12.1.1 and 12.2.2, E-Business Tax replaced the legacy tax engines, and this package is one of the adapters that lets the IGC module participate in the centralized tax services model.

The package declares a set of module-specific constants that frame how the tax event is presented to EBTax: application id 8407, entity code IGC_CC_HEADERS, event class PURCHASE_TRANSACTION_TAX_QUOTE with event type CREATE, line-level tax determination (IGC_TRX_LEVEL_TYPE = 'LINE'), line class INVOICE, and the tax quote flag set to 'Y'. A batch limit constant of 1000 bounds the volume of records processed in a single pass. This constant set makes the package the authoritative definition of how IGC contract tax quotes are represented inside the ZX engine. The header comment carries a version string from 2008, indicating the package has been stable across the 11i-to-12.x lineage.

Key Procedures and Functions

  • SET_TAX_SECURITY_CONTEXT — Establishes the tax security context for the session and returns the applicable tax effective date. The effective date drives the list of values for tax drivers and tax-related attributes; the procedure also returns a standard return status, message count, and message data payload.
  • POPULATE_HEADERS_GT — Gathers the additional header-level information needed to populate ZX_TRANSACTION_HEADERS_GT, the global temporary table consumed by EBTax. This is the procedure most closely associated with the user's search term.
  • POPULATE_LINES_GT — Performs the equivalent enrichment for transaction lines, loading ZX_TRANSACTION_LINES_GT and related distribution tables so that line-level tax determination can proceed.
  • CALCULATE_TAX — Invokes the EBTax calculation services against the prepared interface data and retrieves the resulting tax lines and detail records.
  • GET_CC_DEF_TAX_CLASSIFICATION — Returns the default tax classification for a contract or document header, supplying the classification value that EBTax requires during tax determination.

Tables Accessed

The package reads the IGC transaction model through IGC_CC_HEADERS and IGC_CC_ACCT_LINES, resolving accounting context with GL_CODE_COMBINATIONS, GL_LEDGERS, and HR_ALL_ORGANIZATION_UNITS. Currency conversion data is drawn from FND_CURRENCIES. On the tax side it references ZX_ACCT_TX_CLS_DEFS for account-to-tax-classification defaults and ZX_LINES and ZX_LINES_DET_FACTORS for calculated tax results and their determining factors. It writes the interface global temporary tables ZX_TRANSACTION_HEADERS_GT (via the ZX_TRX_HEADERS_GT synonym), ZX_TRANSACTION_LINES_GT, ZX_DETAIL_TAX_LINES_GT, ZX_ITM_DISTRIBUTIONS_GT, and ZX_REC_NREC_DIST_GT, and it uses the PL/SQL table type PLITBLM for bulk collections during processing.

Usage Notes

IGC_ETAX_UTIL_PKG is not designed for direct end-user invocation. It is called from within the IGC purchasing and contract flows whenever a tax quote is required — typically during contract entry or modification when tax must be displayed or validated. The package is referenced by three other packages, which form the internal call chain into the tax engine. Because it uses AUTHID CURRENT_USER, privileges are resolved against the calling schema rather than APPS, a consideration for any custom code that invokes it. Customizations should treat the package as an internal implementation detail of the IGC-to-EBTax integration and should call the higher-level IGC APIs instead of these procedures directly.