APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_GEO_STRUCT_MAP_DTL

Line 608: FROM hz_geo_struct_map map, hz_geo_struct_map_dtl dtl

604: l_geo_structure_rec GEO_STRUCTURE_REC_TYPE;
605: l_object_version_number NUMBER;
606: CURSOR c_geo_structure_map IS
607: SELECT distinct map.map_id
608: FROM hz_geo_struct_map map, hz_geo_struct_map_dtl dtl
609: WHERE map.country_code = l_country_code
610: AND map.map_id = dtl.map_id;
611: l_geo_structure_map c_geo_structure_map%ROWTYPE;
612:

Line 740: UPDATE hz_geo_struct_map_dtl

736: OPEN c_geo_structure_map;
737: LOOP
738: FETCH c_geo_structure_map INTO l_geo_structure_map;
739: EXIT WHEN c_geo_structure_map%NOTFOUND;
740: UPDATE hz_geo_struct_map_dtl
741: SET geo_element_col=p_geography_element_column
742: WHERE geography_type= p_geography_type
743: AND map_id = l_geo_structure_map.map_id;
744: END LOOP;

Line 1192: from hz_geo_struct_map_dtl

1188: where map_id = l_map_id;
1189: if l_map_id is not null then
1190: select loc_seq_num,loc_component,geography_type
1191: bulk collect into l_geo_struct_map_dtl_tbl
1192: from hz_geo_struct_map_dtl
1193: where map_id = l_map_id
1194: and geography_type = p_geography_type;
1195:
1196: if l_geo_struct_map_dtl_tbl.COUNT > 0 then

Line 1213: delete hz_geo_struct_map_dtl

1209: END IF;
1210: end if;
1211: end if;
1212: /*
1213: delete hz_geo_struct_map_dtl
1214: where map_id = l_map_id
1215: and geography_type = p_geography_type;
1216:
1217: open c_get_addr_usg;