APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on DBMS_UTILITY

Line 6599: --l_jursidiction_id_indx := dbms_utility.get_hash_value(to_char(l_location_id)|| l_location_type,1,8192);

6595: l_location_id := NULL;
6596: l_location_type := NULL;
6597: END IF;
6598:
6599: --l_jursidiction_id_indx := dbms_utility.get_hash_value(to_char(l_location_id)|| l_location_type,1,8192);
6600:
6601: IF l_location_id is not null then
6602:
6603: --IF l_jursidiction_id_tbl.EXISTS(l_jursidiction_id_indx)

Line 6642: l_tbl_index := dbms_utility.get_hash_value(to_char(l_tax_id) || '1',1,8192);

6638: --WHERE geography_type = l_geography_type
6639: --AND geography_use <> 'MASTER_REF'
6640: --AND rownum = 1;
6641: BEGIN
6642: l_tbl_index := dbms_utility.get_hash_value(to_char(l_tax_id) || '1',1,8192);
6643:
6644: IF g_geography_use_info_tbl.EXISTS(l_tbl_index) AND
6645: g_geography_use_info_tbl(l_tbl_index).tax_id = l_tax_id THEN
6646: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 6661: l_tbl_index := dbms_utility.get_hash_value(l_tax_id || to_char(i),1,8192);

6657: BULK COLLECT INTO l_geography_type, l_geography_use, l_geography_type_num;
6658:
6659: FOR i IN NVL(l_geography_type.FIRST,0)..nvl(l_geography_type.LAST,-1) LOOP
6660:
6661: l_tbl_index := dbms_utility.get_hash_value(l_tax_id || to_char(i),1,8192);
6662:
6663: g_geography_use_info_tbl(l_tbl_index).tax_id := l_tax_id;
6664: g_geography_use_info_tbl(l_tbl_index).GEOGRAPHY_TYPE_NUM := i;
6665: g_geography_use_info_tbl(l_tbl_index).GEOGRAPHY_TYPE := l_geography_type(i);

Line 6682: l_tbl_index := dbms_utility.get_hash_value(l_tax_id || to_char(i),1,8192);

6678: --IF l_geography_type IS NOT NULL THEN
6679: i := 1;
6680: l_jurisdiction_found := FALSE;
6681: WHILE NOT l_jurisdiction_found LOOP
6682: l_tbl_index := dbms_utility.get_hash_value(l_tax_id || to_char(i),1,8192);
6683: IF NOT g_geography_use_info_tbl.EXISTS(l_tbl_index) THEN
6684: EXIT;
6685: ELSE
6686: --IF l_geo_use_count = 0 THEN