Search Results get_default_tax_code

Overview

JG_ZZ_TAX is a Latin American localization (JG/ZX tax integration) PL/SQL package owned by APPS and classified as OTHER in the ETRM repository for Oracle EBS 12.1.1 and 12.2.2. Its principal business function is to recalculate and default tax information on receivable transactions for countries whose localization requires regulatory tax treatment—principally Brazil, Argentina, and Colombia, plus other countries supported by Oracle's Latin American tax engine. The package bridges the Receivables transaction model (RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_TYPES_ALL) with the E-Business Tax engine (ZX_PRODUCT_OPTIONS_ALL, AR_VAT_TAX_ALL), enabling the correct derivation of tax codes, tax methods, and fiscal classifications at line level.

The body carries the header identifier jgzzrtxb.pls, version 120.10.12010000.1 (2008/07/28), and includes an FND_LOG instrumentation framework (g_current_runtime_level, g_level_statement, g_level_procedure, g_level_unexpected) that writes debug messages via FND_LOG.STRING. This diagnostic layer is significant because tax localization logic is frequently enabled or debugged in production to isolate country-specific calculation discrepancies.

Key Procedures and Functions

• RECALCULATE_TAX — a function returning VARCHAR2 that serves as the entry point referenced by the search term "recalculate_tax". It determines the applicable country code by calling JG_ZZ_SHARED_PKG.GET_COUNTRY with the ORG_ID from ZX_PRODUCT_INTEGRATION_PKG.old_line_rec. When the country resolves to BR, AR, or CO, it proceeds with localization-specific tax recalculation; otherwise it returns 'N'. Older logic that queried ZX_PRODUCT_OPTIONS_ALL for tax_method_code (for example an 'LTE' method check) was removed as redundant under Bug 5015952, though the surrounding structure and comments remain in the body.
• GET_DEFAULT_TAX_CODE — returns the default tax code applicable to a transaction line, consulting E-Business Tax configuration (AR_VAT_TAX_ALL / ZX_PRODUCT_OPTIONS_ALL) so that lines created without an explicit tax code still receive a valid, localization-compliant default.

The body also references ZX_PRODUCT_INTEGRATION_PKG.old_line_rec, indicating tight coupling with the E-Business Tax product integration layer.

Tables Accessed

• AR_VAT_TAX_ALL — the VAT/tax registration and rate repository used to validate and resolve applicable tax codes.
• RA_CUSTOMER_TRX_LINES — the Receivables transaction line table whose tax attributes are recalculated or defaulted.
• RA_CUST_TRX_TYPES_ALL — the transaction type definition table used to determine whether the transaction class (invoice, credit memo, debit memo) qualifies for recalculation.
• ZX_PRODUCT_OPTIONS_ALL — E-Business Tax product options holding tax method and configuration settings that govern calculation behaviour.

Usage Notes

JG_ZZ_TAX is invoked primarily from the Receivables Transaction workbench and from Latin American localization flows that call the tax recalculation API when a transaction line is entered, adjusted, or validated. It may also be called from concurrent tax reconciliation programs and from custom PL/SQL extensions that need to reapply tax defaults. The package is referenced by one other package in ETRM, and because RECALCULATE_TAX depends on ZX_PRODUCT_INTEGRATION_PKG.old_line_rec, it must be called in a context where that global line record has been populated—typically within the standard tax integration callout stack rather than as standalone code. In 12.2.2 the E-Business Tax integration remains unchanged for this package, so behaviour is consistent between 12.1.1 and 12.2.2.