DBA Data[Home] [Help]

APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on ZX_TDS_CALC_SERVICES_PUB_PKG

Line 3681: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j)

3677: 'cache index: ' || to_char(j));
3678: END IF;
3679:
3680: -- bug 6763074: comment out the code lines for caching because it seems
3681: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j)
3682: -- does not have the value for the current trx line
3683: --
3684: -- IF (g_data_type_tbl(i) = 'ALPHANUMERIC' AND
3685: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.EXISTS(j)) THEN

Line 3685: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.EXISTS(j)) THEN

3681: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j)
3682: -- does not have the value for the current trx line
3683: --
3684: -- IF (g_data_type_tbl(i) = 'ALPHANUMERIC' AND
3685: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.EXISTS(j)) THEN
3686: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) = g_alphanum_value_tbl(i)) THEN
3687: -- p_alphanum_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j);
3688: -- l_found_in_cache := TRUE;
3689: -- END IF;

Line 3686: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) = g_alphanum_value_tbl(i)) THEN

3682: -- does not have the value for the current trx line
3683: --
3684: -- IF (g_data_type_tbl(i) = 'ALPHANUMERIC' AND
3685: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.EXISTS(j)) THEN
3686: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) = g_alphanum_value_tbl(i)) THEN
3687: -- p_alphanum_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j);
3688: -- l_found_in_cache := TRUE;
3689: -- END IF;
3690: -- ELSIF (g_data_type_tbl(i) = 'NUMERIC' AND

Line 3687: -- p_alphanum_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j);

3683: --
3684: -- IF (g_data_type_tbl(i) = 'ALPHANUMERIC' AND
3685: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.EXISTS(j)) THEN
3686: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) = g_alphanum_value_tbl(i)) THEN
3687: -- p_alphanum_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j);
3688: -- l_found_in_cache := TRUE;
3689: -- END IF;
3690: -- ELSIF (g_data_type_tbl(i) = 'NUMERIC' AND
3691: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(j)) THEN

Line 3691: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(j)) THEN

3687: -- p_alphanum_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j);
3688: -- l_found_in_cache := TRUE;
3689: -- END IF;
3690: -- ELSIF (g_data_type_tbl(i) = 'NUMERIC' AND
3691: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(j)) THEN
3692: -- -- bug fix 6611984
3693: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) = g_numeric_value_tbl(i)) THEN
3694: -- p_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j);
3695: -- l_found_in_cache := TRUE;

Line 3693: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) = g_numeric_value_tbl(i)) THEN

3689: -- END IF;
3690: -- ELSIF (g_data_type_tbl(i) = 'NUMERIC' AND
3691: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(j)) THEN
3692: -- -- bug fix 6611984
3693: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) = g_numeric_value_tbl(i)) THEN
3694: -- p_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j);
3695: -- l_found_in_cache := TRUE;
3696: -- END IF;
3697: -- END IF;

Line 3694: -- p_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j);

3690: -- ELSIF (g_data_type_tbl(i) = 'NUMERIC' AND
3691: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(j)) THEN
3692: -- -- bug fix 6611984
3693: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) = g_numeric_value_tbl(i)) THEN
3694: -- p_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j);
3695: -- l_found_in_cache := TRUE;
3696: -- END IF;
3697: -- END IF;
3698:

Line 3820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) := p_alphanum_value;

3816: -- update trx value cache structure
3817: /* Bug 5003413 */
3818: IF g_determining_factor_class_tbl(i) in ('GEOGRAPHY', 'ACCOUNTING_FLEXFIELD') THEN
3819: IF g_data_type_tbl(i) = 'ALPHANUMERIC' THEN
3820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) := p_alphanum_value;
3821: ELSIF g_data_type_tbl(i) = 'NUMERIC' THEN
3822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) := p_numeric_value;
3823: END IF;
3824: END IF;

Line 3822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) := p_numeric_value;

3818: IF g_determining_factor_class_tbl(i) in ('GEOGRAPHY', 'ACCOUNTING_FLEXFIELD') THEN
3819: IF g_data_type_tbl(i) = 'ALPHANUMERIC' THEN
3820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) := p_alphanum_value;
3821: ELSIF g_data_type_tbl(i) = 'NUMERIC' THEN
3822: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) := p_numeric_value;
3823: END IF;
3824: END IF;
3825: /* Bug 5003413 */
3826: END IF;

Line 4176: --IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN

4172: p_parameter_code,
4173: 1,
4174: 8192); */
4175:
4176: --IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4177: -- p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4178: --ELSE
4179:
4180: ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value(

Line 4177: -- p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);

4173: 1,
4174: 8192); */
4175:
4176: --IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4177: -- p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4178: --ELSE
4179:
4180: ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value(
4181: p_structure_name,

Line 4189: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) := p_trx_numeric_value;

4185: p_return_status
4186: );
4187:
4188: --IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4189: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) := p_trx_numeric_value;
4190: --END IF;
4191: --END IF;
4192:
4193: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4261: --IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN

4257: p_parameter_code,
4258: 1,
4259: 8192); */
4260:
4261: --IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4262: -- p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4263: --ELSE
4264:
4265: ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value(

Line 4262: -- p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);

4258: 1,
4259: 8192); */
4260:
4261: --IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4262: -- p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4263: --ELSE
4264:
4265: ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value(
4266: p_structure_name,

Line 4273: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := p_trx_alphanumeric_value;

4269: p_trx_alphanumeric_value,
4270: p_return_status
4271: );
4272: --IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4273: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := p_trx_alphanumeric_value;
4274: --END IF;
4275: --END IF;
4276:
4277: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4340: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN

4336: p_parameter_code,
4337: 1,
4338: 8192);
4339:
4340: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4341: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) =
4342: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_structure_index)) THEN
4343: p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4344: l_in_cache_flg := TRUE;

Line 4341: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) =

4337: 1,
4338: 8192);
4339:
4340: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4341: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) =
4342: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_structure_index)) THEN
4343: p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4344: l_in_cache_flg := TRUE;
4345: END IF;

Line 4343: p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);

4339:
4340: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4341: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) =
4342: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_structure_index)) THEN
4343: p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4344: l_in_cache_flg := TRUE;
4345: END IF;
4346: END IF;
4347:

Line 4358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) := p_trx_numeric_value;

4354: p_return_status
4355: );
4356:
4357: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4358: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) := p_trx_numeric_value;
4359: END IF;
4360: END IF;
4361:
4362: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4426: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN

4422: p_parameter_code,
4423: 1,
4424: 8192);
4425:
4426: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4427: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) =
4428: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_structure_index)) THEN
4429: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4430: l_in_cache_flg := TRUE;

Line 4427: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) =

4423: 1,
4424: 8192);
4425:
4426: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4427: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) =
4428: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_structure_index)) THEN
4429: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4430: l_in_cache_flg := TRUE;
4431: END IF;

Line 4429: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);

4425:
4426: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4427: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) =
4428: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_structure_index)) THEN
4429: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4430: l_in_cache_flg := TRUE;
4431: END IF;
4432: END IF;
4433:

Line 4443: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := p_trx_alphanumeric_value;

4439: p_trx_alphanumeric_value,
4440: p_return_status
4441: );
4442: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4443: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := p_trx_alphanumeric_value;
4444: END IF;
4445: END IF;
4446:
4447: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 4613: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN

4609: WHEN TOO_MANY_ROWS then
4610: p_trx_alphanumeric_value := NULL;
4611: END;
4612:
4613: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4614: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) = l_trx_alphanumeric_value THEN
4615: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4616: l_in_cache_flg := TRUE;
4617: END IF;

Line 4614: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) = l_trx_alphanumeric_value THEN

4610: p_trx_alphanumeric_value := NULL;
4611: END;
4612:
4613: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4614: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) = l_trx_alphanumeric_value THEN
4615: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4616: l_in_cache_flg := TRUE;
4617: END IF;
4618: END IF;

Line 4615: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);

4611: END;
4612:
4613: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4614: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) = l_trx_alphanumeric_value THEN
4615: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4616: l_in_cache_flg := TRUE;
4617: END IF;
4618: END IF;
4619:

Line 4621: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := l_trx_alphanumeric_value;

4617: END IF;
4618: END IF;
4619:
4620: IF NOT l_in_cache_flg THEN
4621: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := l_trx_alphanumeric_value;
4622: p_trx_alphanumeric_value := l_trx_alphanumeric_value;
4623: END IF;
4624:
4625: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5094: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;

5090: p_return_status);
5091:
5092: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5093: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5094: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5095: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5096:
5097: ELSE
5098: -- Bugfix 4882676: ignore error even if fc not found

Line 5095: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;

5091:
5092: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5093: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5094: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5095: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5096:
5097: ELSE
5098: -- Bugfix 4882676: ignore error even if fc not found
5099: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5266: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;

5262:
5263: IF (l_classification_category = 'PARTY_FISCAL_CLASS' AND l_fsc_rec.fsc_code <> FND_API.G_MISS_CHAR)
5264: OR (l_classification_category <> 'PARTY_FISCAL_CLASS') THEN
5265: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5266: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5267: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5268: END IF;
5269:
5270: ELSE

Line 5267: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;

5263: IF (l_classification_category = 'PARTY_FISCAL_CLASS' AND l_fsc_rec.fsc_code <> FND_API.G_MISS_CHAR)
5264: OR (l_classification_category <> 'PARTY_FISCAL_CLASS') THEN
5265: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5266: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5267: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5268: END IF;
5269:
5270: ELSE
5271: -- Bugfix 4882676: ignore error even if fc not found

Line 5411: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;

5407:
5408: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5409: IF l_fsc_rec.fsc_code <> FND_API.G_MISS_CHAR THEN
5410: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5411: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5413: END IF;
5414: ELSE
5415: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;

5408: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5409: IF l_fsc_rec.fsc_code <> FND_API.G_MISS_CHAR THEN
5410: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5411: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5412: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5413: END IF;
5414: ELSE
5415: p_return_status := FND_API.G_RET_STS_SUCCESS;
5416: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5507: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;

5503: p_return_status);
5504:
5505: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5506: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5507: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5508: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5509: ELSE
5510: p_return_status := FND_API.G_RET_STS_SUCCESS;
5511: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 5508: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;

5504:
5505: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5506: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;
5507: j := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count + 1;
5508: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5509: ELSE
5510: p_return_status := FND_API.G_RET_STS_SUCCESS;
5511: IF (g_level_statement >= g_current_runtime_level ) THEN
5512: FND_LOG.STRING(g_level_statement,

Line 6979: l_fsc_tbl := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl;

6975: 'ZX_TDS_RULE_BASE_DETM_PVT: get_fsc_code(+)');
6976: END IF;
6977:
6978: p_found := FALSE;
6979: l_fsc_tbl := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl;
6980: l_count := l_fsc_tbl.count;
6981:
6982: FOR i IN 1.. l_count LOOP
6983: IF (l_fsc_tbl(i).classification_type = p_classification_type AND

Line 7040: l_check_condition_group_tbl ZX_TDS_CALC_SERVICES_PUB_PKG.trx_line_cond_grp_eval_tbl;

7036: p_template_evaluated OUT NOCOPY BOOLEAN,
7037: p_result OUT NOCOPY BOOLEAN)
7038: IS
7039: l_count NUMBER;
7040: l_check_condition_group_tbl ZX_TDS_CALC_SERVICES_PUB_PKG.trx_line_cond_grp_eval_tbl;
7041: BEGIN
7042:
7043: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7044:

Line 7061: l_check_condition_group_tbl := ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl;

7057: ', application_Id: ' || to_char(p_event_class_rec.application_Id) ||
7058: ', tax_event_class_code: ' || p_event_class_rec.tax_event_class_code);
7059: END IF;
7060:
7061: l_check_condition_group_tbl := ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl;
7062: l_count := l_check_condition_group_tbl.count;
7063: p_template_evaluated := FALSE;
7064: p_result := FALSE;
7065:

Line 7145: l_check_condition_group_rec ZX_TDS_CALC_SERVICES_PUB_PKG.trx_line_cond_grp_eval_rec;

7141: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
7142: )
7143: IS
7144: i BINARY_INTEGER;
7145: l_check_condition_group_rec ZX_TDS_CALC_SERVICES_PUB_PKG.trx_line_cond_grp_eval_rec;
7146:
7147: BEGIN
7148:
7149: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 7156: i := ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl.count + 1;

7152: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.insert_condition_group_result.BEGIN',
7153: 'ZX_TDS_RULE_BASE_DETM_PVT: insert_condition_group_result(+)');
7154: END IF;
7155:
7156: i := ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl.count + 1;
7157:
7158: l_check_condition_group_rec.det_factor_templ_code := p_det_factor_templ_code;
7159: l_check_condition_group_rec.condition_group_code := p_condition_group_code;
7160: l_check_condition_group_rec.trx_line_index := p_trx_line_index;

Line 7166: ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl(i) := l_check_condition_group_rec;

7162: l_check_condition_group_rec.tax_event_class_code :=
7163: p_event_class_rec.tax_event_class_code;
7164: l_check_condition_group_rec.result := p_result;
7165:
7166: ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl(i) := l_check_condition_group_rec;
7167:
7168:
7169: IF (g_level_procedure >= g_current_runtime_level ) THEN
7170: FND_LOG.STRING(g_level_procedure,

Line 7517: l_count := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.COUNT;

7513: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_trx_value_index.BEGIN',
7514: 'ZX_TDS_RULE_BASE_DETM_PVT: get_trx_value_index(+)');
7515: END IF;
7516:
7517: l_count := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.COUNT;
7518:
7519:
7520: l_tbl_index := dbms_utility.get_hash_value(
7521: p_Det_Factor_Class_Code || cache_delim ||