Search Results trad_hq

Overview

The APPS.ZX_TDS_RULE_BASE_DETM_PVT package body is a private (PVT-classified) PL/SQL engine component within Oracle E-Business Tax (EBTax), the tax determination framework delivered with Oracle EBS 12.1.1 and 12.2.2. Its purpose is to evaluate the rule base that drives tax determination. In EBTax, a tax rule is expressed as a condition group, which is a set of ordered conditions that must be satisfied before an outcome (a determining factor such as a tax regime, tax, tax status, rate, or jurisdiction) is applied to a transaction line. This package resolves the individual expressions inside those condition groups: it reads transaction parameter values, compares them against the values defined in the rule base, and returns the determining factor code that the calling engine should apply.

The "TDS" in the name reflects the package's heritage in the tax determination service (TDS) rule engine, and _DETM_PVT indicates the determination phase of processing. Because it is a private package, it is not a public API; it is invoked exclusively by other EBTax engine packages that drive rule evaluation.

Key Procedures and Functions

• RULE_BASE_PROCESS — The main driving routine. It orchestrates evaluation of a rule base against a given transaction context, iterating condition groups and returning the resulting determining factor.
• GET_TSRM_NUM_VALUE — Retrieves the numeric parameter value associated with a condition (for example, a tax rate threshold or an amount-based condition) for comparison during rule evaluation.
• GET_TSRM_ALPHANUM_VALUE — Retrieves the alphanumeric parameter value for a condition, used where the condition compares string-based attributes such as product classification or tax registration data.
• GET_TRX_VALUE_INDEX — Resolves the index or position of a transaction attribute so the engine can locate the correct value within the condition structure being evaluated.
• INIT_CEC_PARAMS — Initialises the parameters for the condition/event class (CEC) context at the start of a determination run, populating the working variables the engine needs.
• EVALUATE_IF_FIRST_PARTY — Evaluates whether the party on the transaction is the first party, supporting the party-type conditions used in rule base logic.

Earlier versions of the package body also expose helper routines such as GET_TSRM_PARAMETER_VALUE, GET_FSC_CODE, GET_FC, and GET_REGISTRATION_STATUS, which resolve flexible classification codes, determining factors, and registration statuses respectively.

Tables Accessed

The package reads and writes across the core EBTax configuration schema, primarily through APPS synonyms:

• ZX_CONDITIONS and ZX_CONDITION_GROUPS_B — the condition and condition-group definitions that form the rule base being evaluated, the central object of this package.
• ZX_DETERMINING_FACTORS_B, ZX_DET_FACTOR_TEMPL_B, ZX_DET_FACTOR_TEMPL_DTL — the determining factor values and their templates, which are the outputs of successful condition evaluation.
• ZX_RULES_B, ZX_TAXES_B, ZX_REGIMES_B, ZX_STATUS_B, ZX_PARAMETERS_B — the rule, tax, regime, status, and parameter definitions referenced by conditions.
• ZX_LINES and ZX_PROCESS_RESULTS — the transaction line context and the determination results written back by the engine.
• FND_ID_FLEX_SEGMENTS, MTL_SYSTEM_ITEMS, XLE_ENTITY_PROFILES — supporting lookups for key flexfield segments, inventory items, and legal entity information used in condition comparisons.

Usage Notes

Because it is a private package, ZX_TDS_RULE_BASE_DETM_PVT is not called directly from Oracle Forms or concurrent programs. It is invoked by the EBTax tax determination engine—typically during ZX_API_PUB calls such as Determine_Tax—when a transaction is processed and the engine must resolve which tax applies. It is referenced by seven other packages, which call it in sequence as part of the rule evaluation flow. Customisations should not call this package directly; developers needing equivalent functionality should use the public EBTax APIs, since private packages may change between patch levels on 12.1.1 and 12.2.2.