The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT INSTR(p_theme_str, '', 1,1) INTO l_loc_t FROM DUAL;
SELECT SUBSTR(p_theme_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;
SELECT INSTR(l_work_str, '', 1, 1) INTO l_loc_s FROM DUAL;
SELECT SUBSTR(l_work_str,1,l_loc_s-1) INTO p_themes(l_count).THEME FROM DUAL;
SELECT SUBSTR(l_work_str,l_loc_s+3) INTO p_themes(l_count).WEIGHT FROM DUAL;
SELECT SUBSTR(p_theme_str,l_loc_t+3) INTO l_theme_str FROM DUAL;
SELECT INSTR(p_highlight_str, '', 1,1) INTO l_loc_t FROM DUAL;
SELECT SUBSTR(p_highlight_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;
SELECT INSTR(l_work_str, '', 1, 1) INTO l_loc_s FROM DUAL;
SELECT SUBSTR(l_work_str,1,l_loc_s-1) INTO p_highlight_buf(l_count).offset FROM DUAL;
SELECT SUBSTR(l_work_str,l_loc_s+3) INTO p_highlight_buf(l_count).length FROM DUAL;
SELECT SUBSTR(p_highlight_str,l_loc_t+3) INTO l_highlight_str FROM DUAL;
SELECT INSTR(p_part_str, '', 1,1) INTO l_loc_t FROM DUAL;
SELECT SUBSTR(p_part_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;
SELECT SUBSTR(p_part_str,l_loc_t+3) INTO l_part_str FROM DUAL;
SELECT INSTR(l_work_str, '', 1, 1) INTO l_loc_s FROM DUAL;
SELECT SUBSTR(l_work_str,1,l_loc_s-1) INTO p_parts(l_count).part_number FROM DUAL;
SELECT SUBSTR(l_work_str,l_loc_s+3) INTO l_temp_str FROM DUAL;
SELECT INSTR(l_temp_str, '', 1, 1) INTO l_loc_f FROM DUAL;
SELECT SUBSTR(l_temp_str,1,l_loc_f-1) INTO p_parts(l_count).content_type FROM DUAL;
SELECT SUBSTR(l_temp_str,l_loc_f+3) INTO l_work_str FROM DUAL;
SELECT INSTR(l_work_str, '', 1, 1) INTO l_loc_g FROM DUAL;
SELECT SUBSTR(l_work_str,1, l_loc_g-1) INTO p_parts(l_count).is_binary FROM DUAL;
SELECT SUBSTR(l_work_str,l_loc_g+3) INTO l_temp_str FROM DUAL;
SELECT INSTR(l_temp_str, '', 1, 1) INTO l_loc_h FROM DUAL;
SELECT SUBSTR(l_temp_str,1, l_loc_h-1) INTO p_parts(l_count).att_size FROM DUAL;
SELECT SUBSTR(l_temp_str,l_loc_h+3) INTO p_parts(l_count).att_name FROM DUAL;
SELECT INSTR(p_header_str, '', 1,1) INTO l_loc_t FROM DUAL;
SELECT SUBSTR(p_header_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;
SELECT INSTR(l_work_str, '', 1, 1) INTO l_loc_s FROM DUAL;
SELECT SUBSTR(l_work_str,1,l_loc_s-1) INTO p_headers(l_count).hdr_name FROM DUAL;
SELECT SUBSTR(l_work_str,l_loc_s+3) INTO p_headers(l_count).hdr_value FROM DUAL;
SELECT SUBSTR(p_header_str,l_loc_t+3) INTO l_header_str FROM DUAL;
SELECT INSTR(p_id_str, '', 1,1) INTO l_loc_t FROM DUAL;
SELECT SUBSTR(p_id_str,1, l_loc_t-1) INTO p_messages(l_count) FROM DUAL;
SELECT SUBSTR(p_id_str,l_loc_t+3) INTO l_id_str FROM DUAL;