[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select wrl.location_id,
wrl.region_id
from wsh_region_locations wrl
where wrl.location_id = cp_loc_id
and wrl.region_type = cp_region_type;
g_message_tab.DELETE;
l_origin_location_id_tab.DELETE;
l_origin_region_id_tab.DELETE;
l_loc_region_id_origin_tab.DELETE;
l_destination_location_id_tab.DELETE;
l_destination_region_id_tab.DELETE;
l_loc_region_id_dest_tab.DELETE;
l_region_idx_loc_orig_tab.DELETE;
l_region_idx_loc_dest_tab.DELETE;
l_search_tab.DELETE;
l_result_table.DELETE;
msg_message_type_tab.DELETE;
msg_message_code_tab.DELETE;
msg_message_text_tab.DELETE;
msg_location_region_flag_tab.DELETE;
msg_level_tab.DELETE;
msg_table_origin_id_tab.DELETE;
msg_table_destination_id_tab.DELETE;
msg_input_origin_id_tab.DELETE;
msg_input_destination_tab.DELETE;
l_origin_location_id_tab.DELETE;
l_origin_region_id_tab.DELETE;
l_loc_region_id_origin_tab.DELETE;
l_destination_location_id_tab.DELETE;
l_destination_region_id_tab.DELETE;
l_loc_region_id_dest_tab.DELETE;
l_result_table.DELETE;
g_message_tab.DELETE;
g_message_tab.DELETE;
select flm.origin_id,
flm.destination_id,
flm.identifier_type,
flm.distance,
flm.distance_uom,
flm.transit_time,
flm.transit_time_uom
from fte_location_mileages flm
where flm.origin_id = cp_origin_id
and flm.destination_id = cp_destination_id
and flm.identifier_type = cp_identifier_type;
l_rslt_origin_id_tab.DELETE;
l_rslt_destination_id_tab.DELETE;
l_rslt_identifier_type_tab.DELETE;
l_rslt_distance_tab.DELETE;
l_rslt_distance_uom_tab.DELETE;
l_rslt_transit_time_tab.DELETE;
l_rslt_transit_time_uom_tab.DELETE;
l_result_table.DELETE;
msg_message_type_tab.DELETE;
msg_message_code_tab.DELETE;
msg_message_text_tab.DELETE;
msg_location_region_flag_tab.DELETE;
msg_level_tab.DELETE;
msg_table_origin_id_tab.DELETE;
msg_table_destination_id_tab.DELETE;
msg_input_origin_id_tab.DELETE;
msg_input_destination_tab.DELETE;