APPS.HZ_GNR_PVT dependencies on HZ_GNR_UTIL_PKG

Line 105: l_map_tbl hz_gnr_util_pkg.maploc_rec_tbl_type;

101: x_not_validated_geo_type OUT NOCOPY VARCHAR2,
102: x_rec_count_flag OUT NOCOPY VARCHAR2,
103: x_success_geo_level OUT NOCOPY NUMBER) IS
104:
105: l_map_tbl hz_gnr_util_pkg.maploc_rec_tbl_type;
106: l_query_temp VARCHAR2(10000);
107: l_query VARCHAR2(10000);
108: l_status VARCHAR2(10);
109: l_success_geo_level NUMBER;

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

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

Line 4174: l_postal_code := hz_gnr_util_pkg.postal_code_to_validate(p_country_code,p_postal_code);

4170: BEGIN
4171:
4172: -- ER#7240974: get Postal Code value from postal_code_to_validate Function.
4173:
4174: l_postal_code := hz_gnr_util_pkg.postal_code_to_validate(p_country_code,p_postal_code);
4175:
4176: -- FND Logging for debug purpose
4177: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4178: hz_utility_v2pub.debug