eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on ZX_TDS_CALC_SERVICES_PUB_PKG

Line 411: l_count := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count;

407: FUNCTION OPTIMAL_FSC_TBL_LOCATION RETURN NUMBER IS
408: l_count NUMBER;
409: BEGIN
410: IF G_FSC_TBL_INSERT_POINTER = 0 THEN
411: l_count := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count;
412: IF l_count < G_FSC_TBL_MAX_SIZE THEN
413: RETURN l_count + 1;
414: ELSE
415: G_FSC_TBL_INSERT_POINTER := 1;

Line 3053: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

3049: -- Bug 8568734
3050: FND_MESSAGE.SET_NAME('ZX','ZX_CONSTRAINT_EVALUATION_ERROR');
3051: FND_MESSAGE.SET_TOKEN('CONDITION_GROUP',ZX_GLOBAL_STRUCTURES_PKG.g_rule_info_tbl(hash_val).condition_info_rec_tbl(j).condition_group_code);
3052: FND_MESSAGE.SET_TOKEN('ACTION_CODE', l_action_rec_tbl(i).action_code );
3053: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
3054:
3055: IF (g_level_error >= g_current_runtime_level ) THEN
3056: FND_LOG.STRING(g_level_error,
3057: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.proc_condition_group_per_templ',

Line 4028: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j)

4024: 'cache index: ' || to_char(j));
4025: END IF;
4026:
4027: -- bug 6763074: comment out the code lines for caching because it seems
4028: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j)
4029: -- does not have the value for the current trx line
4030: --
4031: -- IF (g_data_type_tbl(i) = 'ALPHANUMERIC' AND
4032: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.EXISTS(j)) THEN

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

4028: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j)
4029: -- does not have the value for the current trx line
4030: --
4031: -- IF (g_data_type_tbl(i) = 'ALPHANUMERIC' AND
4032: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.EXISTS(j)) THEN
4033: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) = g_alphanum_value_tbl(i)) THEN
4034: -- p_alphanum_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j);
4035: -- l_found_in_cache := TRUE;
4036: -- END IF;

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

4029: -- does not have the value for the current trx line
4030: --
4031: -- IF (g_data_type_tbl(i) = 'ALPHANUMERIC' AND
4032: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.EXISTS(j)) THEN
4033: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) = g_alphanum_value_tbl(i)) THEN
4034: -- p_alphanum_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j);
4035: -- l_found_in_cache := TRUE;
4036: -- END IF;
4037: -- ELSIF (g_data_type_tbl(i) = 'NUMERIC' AND

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

4030: --
4031: -- IF (g_data_type_tbl(i) = 'ALPHANUMERIC' AND
4032: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.EXISTS(j)) THEN
4033: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) = g_alphanum_value_tbl(i)) THEN
4034: -- p_alphanum_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j);
4035: -- l_found_in_cache := TRUE;
4036: -- END IF;
4037: -- ELSIF (g_data_type_tbl(i) = 'NUMERIC' AND
4038: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(j)) THEN

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

4034: -- p_alphanum_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j);
4035: -- l_found_in_cache := TRUE;
4036: -- END IF;
4037: -- ELSIF (g_data_type_tbl(i) = 'NUMERIC' AND
4038: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(j)) THEN
4039: -- -- bug fix 6611984
4040: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) = g_numeric_value_tbl(i)) THEN
4041: -- p_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j);
4042: -- l_found_in_cache := TRUE;

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

4036: -- END IF;
4037: -- ELSIF (g_data_type_tbl(i) = 'NUMERIC' AND
4038: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(j)) THEN
4039: -- -- bug fix 6611984
4040: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) = g_numeric_value_tbl(i)) THEN
4041: -- p_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j);
4042: -- l_found_in_cache := TRUE;
4043: -- END IF;
4044: -- END IF;

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

4037: -- ELSIF (g_data_type_tbl(i) = 'NUMERIC' AND
4038: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(j)) THEN
4039: -- -- bug fix 6611984
4040: -- IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) = g_numeric_value_tbl(i)) THEN
4041: -- p_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j);
4042: -- l_found_in_cache := TRUE;
4043: -- END IF;
4044: -- END IF;
4045:

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

4163: -- update trx value cache structure
4164: /* Bug 5003413 */
4165: IF g_determining_factor_class_tbl(i) in ('GEOGRAPHY', 'ACCOUNTING_FLEXFIELD') THEN
4166: IF g_data_type_tbl(i) = 'ALPHANUMERIC' THEN
4167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) := p_alphanum_value;
4168: ELSIF g_data_type_tbl(i) = 'NUMERIC' THEN
4169: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) := p_numeric_value;
4170: END IF;
4171: END IF;

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

4165: IF g_determining_factor_class_tbl(i) in ('GEOGRAPHY', 'ACCOUNTING_FLEXFIELD') THEN
4166: IF g_data_type_tbl(i) = 'ALPHANUMERIC' THEN
4167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl(j) := p_alphanum_value;
4168: ELSIF g_data_type_tbl(i) = 'NUMERIC' THEN
4169: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(j) := p_numeric_value;
4170: END IF;
4171: END IF;
4172: /* Bug 5003413 */
4173: END IF;

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

4515: p_parameter_code,
4516: 1,
4517: 8192); */
4518:
4519: --IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4520: -- p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4521: --ELSE
4522:
4523: ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value(

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

4516: 1,
4517: 8192); */
4518:
4519: --IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4520: -- p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4521: --ELSE
4522:
4523: ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value(
4524: p_structure_name,

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

4528: p_return_status
4529: );
4530:
4531: --IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4532: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) := p_trx_numeric_value;
4533: --END IF;
4534: --END IF;
4535:
4536: IF (g_level_statement >= g_current_runtime_level ) THEN

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

4600: p_parameter_code,
4601: 1,
4602: 8192); */
4603:
4604: --IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4605: -- p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4606: --ELSE
4607:
4608: ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value(

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

4601: 1,
4602: 8192); */
4603:
4604: --IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4605: -- p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4606: --ELSE
4607:
4608: ZX_GET_TAX_PARAM_DRIVER_PKG.get_driver_value(
4609: p_structure_name,

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

4612: p_trx_alphanumeric_value,
4613: p_return_status
4614: );
4615: --IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4616: -- ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := p_trx_alphanumeric_value;
4617: --END IF;
4618: --END IF;
4619:
4620: IF (g_level_statement >= g_current_runtime_level ) THEN

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

4679: p_parameter_code,
4680: 1,
4681: 8192);
4682:
4683: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4684: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) =
4685: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_structure_index)) THEN
4686: p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4687: l_in_cache_flg := TRUE;

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

4680: 1,
4681: 8192);
4682:
4683: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4684: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) =
4685: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_structure_index)) THEN
4686: p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4687: l_in_cache_flg := TRUE;
4688: END IF;

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

4682:
4683: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl.EXISTS(l_table_index) THEN
4684: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) =
4685: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_CCID(p_structure_index)) THEN
4686: p_trx_numeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index);
4687: l_in_cache_flg := TRUE;
4688: END IF;
4689: END IF;
4690:

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

4697: p_return_status
4698: );
4699:
4700: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4701: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_num_value_tbl(l_table_index) := p_trx_numeric_value;
4702: END IF;
4703: END IF;
4704:
4705: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

4765: p_parameter_code,
4766: 1,
4767: 8192);
4768:
4769: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4770: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) =
4771: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_structure_index)) THEN
4772: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4773: l_in_cache_flg := TRUE;

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

4766: 1,
4767: 8192);
4768:
4769: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4770: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) =
4771: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_structure_index)) THEN
4772: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4773: l_in_cache_flg := TRUE;
4774: END IF;

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

4768:
4769: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4770: IF (ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) =
4771: ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.ACCOUNT_STRING(p_structure_index)) THEN
4772: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4773: l_in_cache_flg := TRUE;
4774: END IF;
4775: END IF;
4776:

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

4782: p_trx_alphanumeric_value,
4783: p_return_status
4784: );
4785: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4786: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := p_trx_alphanumeric_value;
4787: END IF;
4788: END IF;
4789:
4790: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

4950: WHEN TOO_MANY_ROWS then
4951: p_trx_alphanumeric_value := NULL;
4952: END;
4953:
4954: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4955: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) = l_trx_alphanumeric_value THEN
4956: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4957: l_in_cache_flg := TRUE;
4958: END IF;

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

4951: p_trx_alphanumeric_value := NULL;
4952: END;
4953:
4954: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4955: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) = l_trx_alphanumeric_value THEN
4956: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4957: l_in_cache_flg := TRUE;
4958: END IF;
4959: END IF;

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

4952: END;
4953:
4954: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl.EXISTS(l_table_index) THEN
4955: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) = l_trx_alphanumeric_value THEN
4956: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index);
4957: l_in_cache_flg := TRUE;
4958: END IF;
4959: END IF;
4960:

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

4958: END IF;
4959: END IF;
4960:
4961: IF NOT l_in_cache_flg THEN
4962: ZX_TDS_CALC_SERVICES_PUB_PKG.g_tsrm_alphanum_value_tbl(l_table_index) := l_trx_alphanumeric_value;
4963: p_trx_alphanumeric_value := l_trx_alphanumeric_value;
4964: END IF;
4965:
4966: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

5481:
5482: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5483: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5484: j := OPTIMAL_FSC_TBL_LOCATION();
5485: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5486: ELSE
5487: -- Bugfix 4882676: ignore error even if fc not found
5488: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5489: p_trx_alphanumeric_value := l_fsc_rec.fsc_code;

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

5543:
5544: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5545: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5546: j := OPTIMAL_FSC_TBL_LOCATION();
5547: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5548: ELSE
5549: -- Bugfix 4882676: ignore error even if fc not found
5550: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5551: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

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

5714:
5715: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5716: p_trx_alphanumeric_value := Nvl(l_fsc_rec.fsc_code,FND_API.G_MISS_CHAR);
5717: j := OPTIMAL_FSC_TBL_LOCATION();
5718: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5719: ELSE
5720: -- Bugfix 4882676: ignore error even if fc not found
5721: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5722: l_fsc_rec.fsc_code := p_trx_alphanumeric_value;

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

5857: p_return_status);
5858:
5859: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5860: j := OPTIMAL_FSC_TBL_LOCATION();
5861: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5862: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5863: ELSE
5864: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5865: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

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

5955: p_return_status);
5956:
5957: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
5958: j := OPTIMAL_FSC_TBL_LOCATION();
5959: ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(j) := l_fsc_rec;
5960: p_trx_alphanumeric_value := nvl(l_fsc_rec.fsc_code, FND_API.G_MISS_CHAR);
5961: ELSE
5962: p_trx_alphanumeric_value := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;
5963: l_fsc_rec.fsc_code := FND_API.G_MISS_CHAR||FND_API.G_MISS_CHAR;

Line 7166: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

7162: -- Bug 8568734
7163: FND_MESSAGE.SET_NAME('ZX','ZX_CONSTRAINT_EVALUATION_ERROR');
7164: FND_MESSAGE.SET_TOKEN('CONDITION_GROUP',p_zx_result_rec.condition_group_code);
7165: FND_MESSAGE.SET_TOKEN('ACTION_CODE', l_action_rec_tbl(i).action_code );
7166: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
7167:
7168: IF (g_level_error >= g_current_runtime_level ) THEN
7169: FND_LOG.STRING(g_level_error,
7170: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',

Line 7275: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

7271: -- Bug 8568734
7272: FND_MESSAGE.SET_NAME('ZX','ZX_CONSTRAINT_EVALUATION_ERROR');
7273: FND_MESSAGE.SET_TOKEN('CONDITION_GROUP',p_zx_result_rec.condition_group_code);
7274: FND_MESSAGE.SET_TOKEN('ACTION_CODE', l_action_rec_tbl(i).action_code );
7275: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
7276:
7277: IF (g_level_error >= g_current_runtime_level ) THEN
7278: FND_LOG.STRING(g_level_error,
7279: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_result',

Line 7443: l_count := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count;

7439:
7440: p_found := FALSE;
7441:
7442: IF G_FSC_TBL_INSERT_POINTER = 0 THEN
7443: l_count := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count;
7444: FOR i IN REVERSE 1 .. l_count LOOP
7445: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classification_type
7446: = p_classification_type
7447: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).tax_regime_code

Line 7445: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classification_type

7441:
7442: IF G_FSC_TBL_INSERT_POINTER = 0 THEN
7443: l_count := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count;
7444: FOR i IN REVERSE 1 .. l_count LOOP
7445: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classification_type
7446: = p_classification_type
7447: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).tax_regime_code
7448: = p_tax_regime_code
7449: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classification_category

Line 7447: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).tax_regime_code

7443: l_count := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl.count;
7444: FOR i IN REVERSE 1 .. l_count LOOP
7445: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classification_type
7446: = p_classification_type
7447: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).tax_regime_code
7448: = p_tax_regime_code
7449: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classification_category
7450: = p_classification_category
7451: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classified_entity_id,0)

Line 7449: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classification_category

7445: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classification_type
7446: = p_classification_type
7447: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).tax_regime_code
7448: = p_tax_regime_code
7449: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classification_category
7450: = p_classification_category
7451: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classified_entity_id,0)
7452: = NVL(p_classified_entity_id,0)
7453: AND p_tax_determine_date

Line 7451: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classified_entity_id,0)

7447: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).tax_regime_code
7448: = p_tax_regime_code
7449: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classification_category
7450: = p_classification_category
7451: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classified_entity_id,0)
7452: = NVL(p_classified_entity_id,0)
7453: AND p_tax_determine_date
7454: >= nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).effective_from,
7455: p_tax_determine_date)

Line 7454: >= nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).effective_from,

7450: = p_classification_category
7451: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).classified_entity_id,0)
7452: = NVL(p_classified_entity_id,0)
7453: AND p_tax_determine_date
7454: >= nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).effective_from,
7455: p_tax_determine_date)
7456: AND p_tax_determine_date
7457: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).effective_to,
7458: p_tax_determine_date)

Line 7457: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).effective_to,

7453: AND p_tax_determine_date
7454: >= nvl(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).effective_from,
7455: p_tax_determine_date)
7456: AND p_tax_determine_date
7457: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).effective_to,
7458: p_tax_determine_date)
7459: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).item_org_id, 0)
7460: = NVL(p_item_org_id, 0)
7461: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).application_id

Line 7459: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).item_org_id, 0)

7455: p_tax_determine_date)
7456: AND p_tax_determine_date
7457: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).effective_to,
7458: p_tax_determine_date)
7459: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).item_org_id, 0)
7460: = NVL(p_item_org_id, 0)
7461: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).application_id
7462: = p_application_id
7463: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).event_class_code

Line 7461: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).application_id

7457: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).effective_to,
7458: p_tax_determine_date)
7459: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).item_org_id, 0)
7460: = NVL(p_item_org_id, 0)
7461: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).application_id
7462: = p_application_id
7463: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).event_class_code
7464: = p_event_class_code
7465: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).condition_value

Line 7463: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).event_class_code

7459: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).item_org_id, 0)
7460: = NVL(p_item_org_id, 0)
7461: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).application_id
7462: = p_application_id
7463: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).event_class_code
7464: = p_event_class_code
7465: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).condition_value
7466: = p_condition_value
7467: ) THEN

Line 7465: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).condition_value

7461: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).application_id
7462: = p_application_id
7463: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).event_class_code
7464: = p_event_class_code
7465: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).condition_value
7466: = p_condition_value
7467: ) THEN
7468: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).fsc_code;
7469: p_found := TRUE;

Line 7468: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).fsc_code;

7464: = p_event_class_code
7465: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).condition_value
7466: = p_condition_value
7467: ) THEN
7468: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(i).fsc_code;
7469: p_found := TRUE;
7470: EXIT;
7471: END IF;
7472: END LOOP;

Line 7475: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_type

7471: END IF;
7472: END LOOP;
7473: ELSE
7474: FOR l_search_pointer IN REVERSE 1 .. G_FSC_TBL_INSERT_POINTER LOOP
7475: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_type
7476: = p_classification_type
7477: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).tax_regime_code
7478: = p_tax_regime_code
7479: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_category

Line 7477: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).tax_regime_code

7473: ELSE
7474: FOR l_search_pointer IN REVERSE 1 .. G_FSC_TBL_INSERT_POINTER LOOP
7475: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_type
7476: = p_classification_type
7477: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).tax_regime_code
7478: = p_tax_regime_code
7479: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_category
7480: = p_classification_category
7481: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classified_entity_id,0)

Line 7479: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_category

7475: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_type
7476: = p_classification_type
7477: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).tax_regime_code
7478: = p_tax_regime_code
7479: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_category
7480: = p_classification_category
7481: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classified_entity_id,0)
7482: = NVL(p_classified_entity_id,0)
7483: AND p_tax_determine_date

Line 7481: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classified_entity_id,0)

7477: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).tax_regime_code
7478: = p_tax_regime_code
7479: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_category
7480: = p_classification_category
7481: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classified_entity_id,0)
7482: = NVL(p_classified_entity_id,0)
7483: AND p_tax_determine_date
7484: >= nvL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_from,
7485: p_tax_determine_date)

Line 7484: >= nvL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_from,

7480: = p_classification_category
7481: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classified_entity_id,0)
7482: = NVL(p_classified_entity_id,0)
7483: AND p_tax_determine_date
7484: >= nvL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_from,
7485: p_tax_determine_date)
7486: AND p_tax_determine_date
7487: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_to,
7488: p_tax_determine_date)

Line 7487: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_to,

7483: AND p_tax_determine_date
7484: >= nvL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_from,
7485: p_tax_determine_date)
7486: AND p_tax_determine_date
7487: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_to,
7488: p_tax_determine_date)
7489: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).item_org_id, 0)
7490: = NVL(p_item_org_id, 0)
7491: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id

Line 7489: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).item_org_id, 0)

7485: p_tax_determine_date)
7486: AND p_tax_determine_date
7487: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_to,
7488: p_tax_determine_date)
7489: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).item_org_id, 0)
7490: = NVL(p_item_org_id, 0)
7491: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id
7492: = p_application_id
7493: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).event_class_code

Line 7491: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id

7487: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_to,
7488: p_tax_determine_date)
7489: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).item_org_id, 0)
7490: = NVL(p_item_org_id, 0)
7491: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id
7492: = p_application_id
7493: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).event_class_code
7494: = p_event_class_code
7495: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).condition_value

Line 7493: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).event_class_code

7489: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).item_org_id, 0)
7490: = NVL(p_item_org_id, 0)
7491: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id
7492: = p_application_id
7493: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).event_class_code
7494: = p_event_class_code
7495: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).condition_value
7496: = p_condition_value
7497: ) THEN

Line 7495: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).condition_value

7491: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id
7492: = p_application_id
7493: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).event_class_code
7494: = p_event_class_code
7495: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).condition_value
7496: = p_condition_value
7497: ) THEN
7498: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).fsc_code;
7499: p_found := TRUE;

Line 7498: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).fsc_code;

7494: = p_event_class_code
7495: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).condition_value
7496: = p_condition_value
7497: ) THEN
7498: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).fsc_code;
7499: p_found := TRUE;
7500: EXIT;
7501: END IF;
7502: END LOOP;

Line 7505: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_type

7501: END IF;
7502: END LOOP;
7503: IF NOT p_found THEN
7504: FOR l_search_pointer IN REVERSE G_FSC_TBL_INSERT_POINTER+1 .. G_FSC_TBL_MAX_SIZE LOOP
7505: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_type
7506: = p_classification_type
7507: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).tax_regime_code
7508: = p_tax_regime_code
7509: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_category

Line 7507: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).tax_regime_code

7503: IF NOT p_found THEN
7504: FOR l_search_pointer IN REVERSE G_FSC_TBL_INSERT_POINTER+1 .. G_FSC_TBL_MAX_SIZE LOOP
7505: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_type
7506: = p_classification_type
7507: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).tax_regime_code
7508: = p_tax_regime_code
7509: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_category
7510: = p_classification_category
7511: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classified_entity_id,0)

Line 7509: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_category

7505: IF ( ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_type
7506: = p_classification_type
7507: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).tax_regime_code
7508: = p_tax_regime_code
7509: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_category
7510: = p_classification_category
7511: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classified_entity_id,0)
7512: = NVL(p_classified_entity_id,0)
7513: AND p_tax_determine_date

Line 7511: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classified_entity_id,0)

7507: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).tax_regime_code
7508: = p_tax_regime_code
7509: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classification_category
7510: = p_classification_category
7511: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classified_entity_id,0)
7512: = NVL(p_classified_entity_id,0)
7513: AND p_tax_determine_date
7514: >= nvL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_from,
7515: p_tax_determine_date)

Line 7514: >= nvL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_from,

7510: = p_classification_category
7511: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).classified_entity_id,0)
7512: = NVL(p_classified_entity_id,0)
7513: AND p_tax_determine_date
7514: >= nvL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_from,
7515: p_tax_determine_date)
7516: AND p_tax_determine_date
7517: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_to,
7518: p_tax_determine_date)

Line 7517: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_to,

7513: AND p_tax_determine_date
7514: >= nvL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_from,
7515: p_tax_determine_date)
7516: AND p_tax_determine_date
7517: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_to,
7518: p_tax_determine_date)
7519: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).item_org_id, 0)
7520: = NVL(p_item_org_id, 0)
7521: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id

Line 7519: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).item_org_id, 0)

7515: p_tax_determine_date)
7516: AND p_tax_determine_date
7517: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_to,
7518: p_tax_determine_date)
7519: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).item_org_id, 0)
7520: = NVL(p_item_org_id, 0)
7521: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id
7522: = p_application_id
7523: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).event_class_code

Line 7521: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id

7517: <= NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).effective_to,
7518: p_tax_determine_date)
7519: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).item_org_id, 0)
7520: = NVL(p_item_org_id, 0)
7521: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id
7522: = p_application_id
7523: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).event_class_code
7524: = p_event_class_code
7525: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).condition_value

Line 7523: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).event_class_code

7519: AND NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).item_org_id, 0)
7520: = NVL(p_item_org_id, 0)
7521: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id
7522: = p_application_id
7523: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).event_class_code
7524: = p_event_class_code
7525: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).condition_value
7526: = p_condition_value
7527: ) THEN

Line 7525: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).condition_value

7521: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).application_id
7522: = p_application_id
7523: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).event_class_code
7524: = p_event_class_code
7525: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).condition_value
7526: = p_condition_value
7527: ) THEN
7528: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).fsc_code;
7529: p_found := TRUE;

Line 7528: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).fsc_code;

7524: = p_event_class_code
7525: AND ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).condition_value
7526: = p_condition_value
7527: ) THEN
7528: p_trx_alphanumeric_value := ZX_TDS_CALC_SERVICES_PUB_PKG.g_fsc_tbl(l_search_pointer).fsc_code;
7529: p_found := TRUE;
7530: EXIT;
7531: END IF;
7532: END LOOP;

Line 7576: l_check_condition_group_tbl ZX_TDS_CALC_SERVICES_PUB_PKG.trx_line_cond_grp_eval_tbl;

7572: p_template_evaluated OUT NOCOPY BOOLEAN,
7573: p_result OUT NOCOPY BOOLEAN)
7574: IS
7575: l_count NUMBER;
7576: l_check_condition_group_tbl ZX_TDS_CALC_SERVICES_PUB_PKG.trx_line_cond_grp_eval_tbl;
7577: BEGIN
7578:
7579: IF (g_level_procedure >= g_current_runtime_level ) THEN
7580: FND_LOG.STRING(g_level_procedure,

Line 7594: l_check_condition_group_tbl := ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl;

7590: ', tax_event_class_code: ' || p_event_class_rec.tax_event_class_code);
7591: END IF;
7592: END IF;
7593:
7594: l_check_condition_group_tbl := ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl;
7595: l_count := l_check_condition_group_tbl.count;
7596: p_template_evaluated := FALSE;
7597: p_result := FALSE;
7598:

Line 7678: l_check_condition_group_rec ZX_TDS_CALC_SERVICES_PUB_PKG.trx_line_cond_grp_eval_rec;

7674: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE
7675: )
7676: IS
7677: i BINARY_INTEGER;
7678: l_check_condition_group_rec ZX_TDS_CALC_SERVICES_PUB_PKG.trx_line_cond_grp_eval_rec;
7679:
7680: BEGIN
7681:
7682: IF (g_level_procedure >= g_current_runtime_level ) THEN

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

7684: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.insert_condition_group_result.BEGIN',
7685: 'ZX_TDS_RULE_BASE_DETM_PVT: insert_condition_group_result(+)');
7686: END IF;
7687:
7688: i := ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl.count + 1;
7689:
7690: l_check_condition_group_rec.det_factor_templ_code := p_det_factor_templ_code;
7691: l_check_condition_group_rec.condition_group_code := p_condition_group_code;
7692: l_check_condition_group_rec.trx_line_index := p_trx_line_index;

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

7694: l_check_condition_group_rec.tax_event_class_code :=
7695: p_event_class_rec.tax_event_class_code;
7696: l_check_condition_group_rec.result := p_result;
7697:
7698: ZX_TDS_CALC_SERVICES_PUB_PKG.g_check_cond_grp_tbl(i) := l_check_condition_group_rec;
7699:
7700:
7701: IF (g_level_procedure >= g_current_runtime_level ) THEN
7702: FND_LOG.STRING(g_level_procedure,

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

8042: 'ZX.PLSQL.ZX_TDS_RULE_BASE_DETM_PVT.get_trx_value_index.BEGIN',
8043: 'ZX_TDS_RULE_BASE_DETM_PVT: get_trx_value_index(+)');
8044: END IF;
8045:
8046: l_count := ZX_TDS_CALC_SERVICES_PUB_PKG.g_trx_alphanum_value_tbl.COUNT;
8047:
8048:
8049: l_tbl_index := dbms_utility.get_hash_value(
8050: p_Det_Factor_Class_Code || cache_delim ||