The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_block_data(1)('ACTION') := 'UPDATE';
l_break_block_data.DELETE;
l_line_block_data.DELETE;
l_break_block_data.DELETE;
l_block_data.DELETE;
l_block_data.DELETE;
l_action := 'UPDATE';
l_lane_tbl(i).action := 'UPDATE';
SELECT postal_code_from, postal_code_to
INTO l_postal_code_from, l_postal_code_to
FROM wsh_regions_tl
WHERE region_id = l_lane_tbl(i).origin_id
AND language = USERENV('LANG');
l_lane_tbl.DELETE;
l_lane_rate_chart_tbl.DELETE;
l_lane_commodity_tbl.DELETE;
l_lane_service_tbl.DELETE;
IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id => l_lane_tbl(i).origin_id,
p_parent_region_id => l_lane_tbl(i).origin_id,
p_supplier_id => -1,
p_validate_flag => TRUE,
p_postal_code_from => l_postal_code_from_num,
p_postal_code_to => l_postal_code_to_num) = -1) THEN
l_lane_tbl.DELETE;
l_lane_rate_chart_tbl.DELETE;
l_lane_commodity_tbl.DELETE;
l_lane_service_tbl.DELETE;
SELECT postal_code_from, postal_code_to
INTO l_postal_code_from, l_postal_code_to
FROM wsh_regions_tl
WHERE region_id = l_lane_tbl(i).destination_id
AND language = USERENV('LANG');
l_lane_tbl.DELETE;
l_lane_rate_chart_tbl.DELETE;
l_lane_commodity_tbl.DELETE;
l_lane_service_tbl.DELETE;
IF (FTE_REGION_ZONE_LOADER.INSERT_PARTY_REGION(p_region_id => l_lane_tbl(i).destination_id,
p_parent_region_id => l_lane_tbl(i).destination_id,
p_supplier_id => -1,
p_validate_flag => TRUE,
p_postal_code_from => l_postal_code_from_num,
p_postal_code_to => l_postal_code_to_num) = -1) THEN
l_lane_tbl.DELETE;
l_lane_rate_chart_tbl.DELETE;
l_lane_commodity_tbl.DELETE;
l_lane_service_tbl.DELETE;
FTE_LANE_PKG.insert_lane_tables(p_lane_tbl => l_lane_tbl,
p_lane_rate_chart_tbl => l_lane_rate_chart_tbl,
p_lane_commodity_tbl => l_lane_commodity_tbl,
p_lane_service_tbl => l_lane_service_tbl,
x_status => x_status,
x_error_msg => x_error_msg);
l_lane_tbl.DELETE;
l_lane_rate_chart_tbl.DELETE;
l_lane_commodity_tbl.DELETE;
l_lane_service_tbl.DELETE;
l_lane_tbl.DELETE;
l_lane_rate_chart_tbl.DELETE;
l_lane_commodity_tbl.DELETE;
l_lane_service_tbl.DELETE;
l_rate_line_data.DELETE;