APPS.ZX_TCM_GEO_JUR_PKG dependencies on DBMS_UTILITY

Line 67: l_party_type_tbl_idx := dbms_utility.get_hash_value(p_party_type, 1, 8192);

63: -- Initialize API return status to success.
64:
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: l_party_type_tbl_idx := dbms_utility.get_hash_value(p_party_type, 1, 8192);
68:
69: IF (ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE.exists(l_party_type_tbl_idx)) THEN
70: x_loc_tbl := ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_party_type_tbl_idx).LOCATION_SOURCE_TABLE;
71:

Line 82: l_idx := dbms_utility.get_hash_value(c_party_type_rec.party_type_code, 1, 8192);

78: ELSE
79: FOR c_party_type_rec IN c_get_party_type_info
80: LOOP
81:
82: l_idx := dbms_utility.get_hash_value(c_party_type_rec.party_type_code, 1, 8192);
83:
84: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_TYPE_CODE
85: := c_party_type_rec.PARTY_TYPE_CODE;
86: ZX_GLOBAL_STRUCTURES_PKG.ZX_PARTY_TYPES_CACHE(l_idx).PARTY_SOURCE_TABLE

Line 665: l_geography_type_index := dbms_utility.get_hash_value(p_zone_type, 1, 8192);

661: l_loc_country_code := l_location_info_rec.country_code;
662:
663: END IF;
664:
665: l_geography_type_index := dbms_utility.get_hash_value(p_zone_type, 1, 8192);
666:
667: IF ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl.exists(l_geography_type_index) THEN
668: l_limited_by_geography_id :=
669: ZX_GLOBAL_STRUCTURES_PKG.g_geography_type_info_tbl(l_geography_type_index).limited_by_geography_id;

Line 703: l_tbl_index := dbms_utility.get_hash_value(

699: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
700: END IF;
701:
702: -- check if geo name reference information is there in cache
703: l_tbl_index := dbms_utility.get_hash_value(
704: TO_CHAR(p_location_id),
705: 1,
706: 8192);
707:

Line 976: l_tbl_index := dbms_utility.get_hash_value(

972: END IF;
973: IF l_country_regime_flag = 'N' or l_same_regime_loc_country = 'Y' THEN
974:
975: BEGIN
976: l_tbl_index := dbms_utility.get_hash_value(
977: p_tax_regime_code||p_tax||'1',
978: 1,
979: 8192);
980:

Line 1050: l_tbl_index := dbms_utility.get_hash_value(

1046: ORDER BY 3 desc;
1047:
1048: For i in nvl(l_geography_type.FIRST,0)..nvl(l_geography_type.LAST,-1) LOOP
1049:
1050: l_tbl_index := dbms_utility.get_hash_value(
1051: p_tax_regime_code||p_tax||to_char(i),
1052: 1,
1053: 8192);
1054: g_geography_use_info_tbl(l_tbl_index).tax_id := l_tax_id;

Line 1077: l_tbl_index := dbms_utility.get_hash_value(

1073: i := 1; -- counter for geography_type_num
1074:
1075: WHILE TRUE LOOP
1076:
1077: l_tbl_index := dbms_utility.get_hash_value(
1078: p_tax_regime_code||p_tax||to_char(i),
1079: 1,
1080: 8192);
1081:

Line 1317: l_tbl_index := dbms_utility.get_hash_value(

1313:
1314: -- Find geography id from gnr table
1315: -- ---------------------------------
1316:
1317: l_tbl_index := dbms_utility.get_hash_value(
1318: to_char(p_location_id)||p_geography_type,
1319: 1,
1320: 8192);
1321:

Line 1478: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);

1474: p_location_type||'|'||
1475: to_char(p_location_id)||'|'||
1476: p_geography_type;
1477:
1478: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1479:
1480: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
1481: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
1482: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);

Line 1586: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);

1582: location_type_tbl(i)||'|'||
1583: to_char(location_id_tbl(i))||'|'||
1584: g_geography_type_tbl(idx1);
1585:
1586: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1587:
1588: ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX) := k;
1589:
1590:

Line 1716: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);

1712: location_type_tbl(i)||'|'||
1713: to_char(location_id_tbl(i))||'|'||
1714: g_geography_type_tbl(idx1);
1715:
1716: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
1717:
1718: ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX) := k;
1719:
1720: -- Logging Infra: Statement level: "B" means "B"reak point