Search Results update_lookup_values

Overview

APPS.ZX_RATES_PKG is the Oracle E-Business Tax (EBTax) repository-level PL/SQL package that manages tax rate definitions stored in the ZX_RATES_B and ZX_RATES_TL tables. In Oracle EBS 12.1.1 and 12.2.2, tax rates are the configurable percentages or amounts applied to a tax regime, tax, and tax jurisdiction combination during tax determination. This package encapsulates the DML logic that the E-Business Tax setup forms and internal setup utilities use to create, maintain, and delete those rate records, while also synchronizing the human-readable lookup values that drive list-of-values presentation in the Tax Rate setup UI. The package header signature and private procedures are shipped under the standard APPS schema, and the source header identifies the file as zxcratesb.pls, with the most recent reference build at 120.29.12020000.2 (December 2012). It is classified in ETRM as an OTHER API, meaning it is an internal supporting package rather than a public, versioned, inbound API, and it is referenced by zero other packages according to the repository metadata.

Key Procedures and Functions

The documented metadata lists seven procedures and functions within the package body:

• INSERT_ROW — Inserts a new tax rate record into the rate base and translation tables, establishing both the language-independent and language-dependent rows required by the ZX_RATES_B/ZX_RATES_TL pair.
• LOCK_ROW — Acquires a row-level lock on an existing tax rate record so that concurrent updates cannot corrupt the rate definition.
• UPDATE_ROW — Updates the attributes of an existing tax rate record.
• DELETE_ROW — Removes a tax rate record, including its translated rows and associated setup references.
• ADD_LANGUAGE — Inserts the translated (TL) row for a tax rate in an additional installed language, drawing on FND_LANGUAGES to determine the target languages.
• INSERT_LOOKUP_VALUES — Creates the corresponding rows in FND_LOOKUP_VALUES so that the tax rate code, description, and meaning appear correctly in the rate lookup used by the E-Business Tax setup forms and by tax determination lookups.
• POPULATE_ID_TCC_MAPPING_ALL — Populates the ZX_ID_TCC_MAPPING_ALL table, which maps tax rate codes to tax regime, tax, and jurisdiction combinations used during tax determination.

The excerpt also documents the private helper UPDATE_LOOKUP_VALUES_PVT, which updates description and meaning in FND_LOOKUP_VALUES and, when no matching lookup row exists (SQL%ROWCOUNT = 0), calls INSERT_LOOKUP_VALUES to create it. This establishes the close coupling between ZX_RATES_PKG and the FND_LOOKUP_VALUES table that the user's search for "insert_lookup_values" targets.

Tables Accessed

Per the ETRM metadata, the package reads and writes the following tables through APPS synonyms:

• ZX_RATES_B — base (language-independent) tax rate definitions.
• ZX_RATES_TL — translated name and description columns for tax rates.
• ZX_TAXES_B — parent tax definitions to which rates belong.
• ZX_ID_TCC_MAPPING_ALL and ZX_ID_TCC_MAPPING_ALL_S — the rate-to-regime/tax/jurisdiction mapping table and its sequence.
• ZX_PARTY_TAX_PROFILE — party-level tax profile information relevant to rate applicability.
• FND_LOOKUP_VALUES — the lookup table populated and updated by INSERT_LOOKUP_VALUES and UPDATE_LOOKUP_VALUES_PVT.
• FND_LANGUAGES — the installed language list used by ADD_LANGUAGE.
• DUAL — used for single-row queries and sequence evaluations.

Usage Notes

ZX_RATES_PKG is invoked from the E-Business Tax setup forms and from internal setup utilities rather than being called directly by customer code. Its procedures are not documented as public, versioned APIs, so customizations should not depend on their signatures. Insertion or update of a tax rate through the standard UI triggers ADD_LANGUAGE and INSERT_LOOKUP_VALUES so that the FND_LOOKUP_VALUES entry remains consistent with the ZX_RATES row; concurrent maintenance is protected by LOCK_ROW. POPULATE_ID_TCC_MAPPING_ALL must run whenever rate-to-tax mapping data requires regeneration, because the mapping table governs tax determination lookups. In 12.2.2 the same behavior applies, and the source header notes fixes such as bug 6992215 (introduction of the lookup update path) and bug 9705409 (removal of the end_date_active update), which indicate the package evolves with E-Business Tax patch levels. Because no other packages reference it, direct calls from custom code should be treated as unsupported.