APPS.HZ_GEOGRAPHY_STRUCTURE_PUB dependencies on HZ_GEO_STRUCT_MAP

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 785: l_geo_struct_map_dtl_tbl HZ_GEO_STRUCT_MAP_PUB.geo_struct_map_dtl_tbl_type;

781: l_geography_from VARCHAR2(30);
782: l_location_table_name VARCHAR2(30);
783: l_country VARCHAR2(2);
784: l_address_style VARCHAR2(30);
785: l_geo_struct_map_dtl_tbl HZ_GEO_STRUCT_MAP_PUB.geo_struct_map_dtl_tbl_type;
786:
787:
788: CURSOR c_get_geo_map is
789: Select map_id

Line 790: from hz_geo_struct_map

786:
787:
788: CURSOR c_get_geo_map is
789: Select map_id
790: from hz_geo_struct_map
791: where country_code = l_country_code;
792:
793: CURSOR c_get_addr_usg is
794: SELECT usage_id

Line 1187: from hz_geo_struct_map

1183: select map_id,loc_tbl_name,country_code,
1184: address_style
1185: into l_map_id,l_location_table_name,l_country,
1186: l_address_style
1187: from hz_geo_struct_map
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

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 1198: HZ_GEO_STRUCT_MAP_PUB.delete_geo_struct_mapping(l_map_id,

1194: and geography_type = p_geography_type;
1195:
1196: if l_geo_struct_map_dtl_tbl.COUNT > 0 then
1197:
1198: HZ_GEO_STRUCT_MAP_PUB.delete_geo_struct_mapping(l_map_id,
1199: l_location_table_name,
1200: l_country,
1201: l_address_style,
1202: l_geo_struct_map_dtl_tbl,

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;