APPS.HZ_GEO_STRUCT_MAP_PUB dependencies on HZ_GEO_STRUCTURE_LEVELS

Line 150: FROM hz_geo_structure_levels

146: x_ret_status OUT NOCOPY VARCHAR2) IS
147: CURSOR determine_geo_element_col(p_parent_geo_type VARCHAR2,
148: p_country VARCHAR2) IS
149: SELECT geography_type, geography_element_column
150: FROM hz_geo_structure_levels
151: WHERE country_code = p_country
152: START WITH parent_geography_type = p_parent_geo_type
153: AND country_code = p_country
154: CONNECT BY PRIOR geography_type = parent_geography_type

Line 157: l_geo_element_col hz_geo_structure_levels.geography_element_column%TYPE;

153: AND country_code = p_country
154: CONNECT BY PRIOR geography_type = parent_geography_type
155: AND country_code = p_country;
156: l_geo_type hz_geography_types_b.geography_type%TYPE;
157: l_geo_element_col hz_geo_structure_levels.geography_element_column%TYPE;
158:
159: BEGIN
160:
161: x_ret_status := FND_API.G_RET_STS_SUCCESS;

Line 166: FROM hz_geo_structure_levels

162:
163: BEGIN
164: SELECT geography_element_column
165: INTO p_geo_element_col
166: FROM hz_geo_structure_levels
167: WHERE geography_type = p_geography_type
168: AND parent_geography_type = p_parent_geography_type
169: AND country_code = p_country;
170:

Line 219: FROM hz_geo_structure_levels

215: l_temp VARCHAR2(100);
216:
217: CURSOR c_determine_geo_element_col(c_geo_type VARCHAR2, c_country VARCHAR2) IS
218: SELECT level+1 seq_num
219: FROM hz_geo_structure_levels
220: WHERE geography_type = c_geo_type
221: START WITH parent_geography_type = 'COUNTRY'
222: AND country_code = c_country
223: CONNECT BY PRIOR geography_type = parent_geography_type

Line 321: -- Modified the below code to derive loc_seq_num from hz_geo_structure_levels

317:
318: i := p_geo_struct_map_dtl_tbl.first;
319: WHILE i IS NOT NULL LOOP
320:
321: -- Modified the below code to derive loc_seq_num from hz_geo_structure_levels
322: -- The new loc_seq_num will override the passed loc_seq_num value.
323: l_loc_seq_num := NULL;
324: IF p_geo_struct_map_dtl_tbl(i).geo_type = 'COUNTRY' then
325: l_loc_seq_num := 1;

Line 904: FROM hz_geo_structure_levels

900: WHERE map_id = c_map_id;
901:
902: CURSOR c_determine_geo_element_col(c_geo_type VARCHAR2, c_country VARCHAR2) IS
903: SELECT level+1 seq_num, geography_element_column
904: FROM hz_geo_structure_levels
905: WHERE geography_type = c_geo_type
906: START WITH parent_geography_type = 'COUNTRY'
907: AND country_code = c_country
908: CONNECT BY PRIOR geography_type = parent_geography_type

Line 964: -- Added the below code to derive loc_seq_num from hz_geo_structure_levels

960:
961: i := p_geo_struct_map_dtl_tbl.first;
962: WHILE i IS NOT NULL LOOP
963:
964: -- Added the below code to derive loc_seq_num from hz_geo_structure_levels
965: -- The new loc_seq_num will override the passed loc_seq_num value.
966: l_loc_seq_num := NULL;
967: IF p_geo_struct_map_dtl_tbl(i).geo_type = 'COUNTRY' then
968: l_loc_seq_num := 1;