APPS.HZ_GNR_PVT dependencies on HZ_GNR_UTIL_PKG

Line 101: l_map_tbl hz_gnr_util_pkg.maploc_rec_tbl_type;

97: x_not_validated_geo_type OUT NOCOPY VARCHAR2,
98: x_rec_count_flag OUT NOCOPY VARCHAR2,
99: x_success_geo_level OUT NOCOPY NUMBER) IS
100:
101: l_map_tbl hz_gnr_util_pkg.maploc_rec_tbl_type;
102: l_query_temp VARCHAR2(10000);
103: l_query VARCHAR2(10000);
104: l_status VARCHAR2(10);
105: l_success_geo_level NUMBER;

Line 221: l_query_temp := HZ_GNR_UTIL_PKG.getQuery(l_map_tbl, l_map_tbl, l_status);

217:
218: IF (l_geo_struct_tbl(i).v_param_value IS NOT NULL) THEN
219: l_param_details_tbl(i).geo_type := l_geo_struct_tbl(i).v_geo_type;
220: l_param_details_tbl(i).geo_value := UPPER(REPLACE(l_geo_struct_tbl(i).v_param_value,'%',''));
221: l_query_temp := HZ_GNR_UTIL_PKG.getQuery(l_map_tbl, l_map_tbl, l_status);
222: l_query := 'SELECT COUNT(*) FROM ('||l_query_temp||')';
223: l_param_details_tbl(i).query_text := l_query;
224:
225: -- ns_debug.put_line('----------------------------------------');