208: WHEN no_data_found THEN
209: NULL;
210: END;
211:
212: -- update cn_imp_headers with this mapping imp_map_id
213: UPDATE cn_imp_headers
214: SET imp_map_id = l_imp_map.imp_map_id,
215: source_column_num = p_src_column_num
216: WHERE imp_header_id = p_imp_header_id
209: NULL;
210: END;
211:
212: -- update cn_imp_headers with this mapping imp_map_id
213: UPDATE cn_imp_headers
214: SET imp_map_id = l_imp_map.imp_map_id,
215: source_column_num = p_src_column_num
216: WHERE imp_header_id = p_imp_header_id
217: ;