664: p_geography_type;
665:
666: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
667:
668: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
669: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
670: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
671: x_geo_val_found := TRUE;
672: ELSE
665:
666: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
667:
668: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
669: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
670: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
671: x_geo_val_found := TRUE;
672: ELSE
673: x_geo_val_found := FALSE;
666: TABLEIDX := dbms_utility.get_hash_value(hash_string,1,TABLE_SIZE);
667:
668: IF (ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl.EXISTS(TABLEIDX)) THEN
669: loc_info_idx := ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl(TABLEIDX);
670: x_geography_value := ZX_GLOBAL_STRUCTURES_PKG.location_info_tbl.geography_value(loc_info_idx);
671: x_geo_val_found := TRUE;
672: ELSE
673: x_geo_val_found := FALSE;
674: END IF;
1029: l_location_id_tbl(1):= l_poo_location_id_tbl(i);
1030: END IF;
1031:
1032:
1033: /* Check existence of input combination in table ZX_GLOBAL_STRUCTURES_PKG.location_hash_tbl */
1034:
1035: RETRIEVE_GEO_VALUE(l_event_class_mapping_id_tbl(i),
1036: l_trx_id_tbl(i),
1037: l_trx_line_id_tbl(i),