eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_IM_WRAPPERS_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30


       SELECT INSTR(p_theme_str, '', 1,1) INTO l_loc_t FROM DUAL;

Line: 31


       SELECT SUBSTR(p_theme_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;

Line: 32


	  SELECT INSTR(l_work_str, '', 1, 1) INTO l_loc_s FROM DUAL;

Line: 33

SELECT SUBSTR(l_work_str,1,l_loc_s-1) INTO p_themes(l_count).THEME FROM DUAL;

Line: 34

SELECT SUBSTR(l_work_str,l_loc_s+3) INTO p_themes(l_count).WEIGHT FROM DUAL;

Line: 36

SELECT SUBSTR(p_theme_str,l_loc_t+3) INTO l_theme_str FROM DUAL;

Line: 84

SELECT INSTR(p_highlight_str, '', 1,1) INTO l_loc_t FROM DUAL;

Line: 85

SELECT SUBSTR(p_highlight_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;

Line: 86

SELECT INSTR(l_work_str, '', 1, 1) INTO l_loc_s FROM DUAL;

Line: 87

SELECT SUBSTR(l_work_str,1,l_loc_s-1) INTO p_highlight_buf(l_count).offset FROM DUAL;

Line: 88

SELECT SUBSTR(l_work_str,l_loc_s+3) INTO p_highlight_buf(l_count).length FROM DUAL;

Line: 90

SELECT SUBSTR(p_highlight_str,l_loc_t+3) INTO l_highlight_str FROM DUAL;

Line: 137

SELECT INSTR(p_part_str, '', 1,1) INTO l_loc_t FROM DUAL;

Line: 138

SELECT SUBSTR(p_part_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;

Line: 140

SELECT SUBSTR(p_part_str,l_loc_t+3) INTO l_part_str FROM DUAL;

Line: 142

SELECT INSTR(l_work_str, '', 1, 1) INTO l_loc_s FROM DUAL;

Line: 143

SELECT SUBSTR(l_work_str,1,l_loc_s-1) INTO p_parts(l_count).part_number FROM DUAL;

Line: 145

SELECT SUBSTR(l_work_str,l_loc_s+3) INTO l_temp_str FROM DUAL;

Line: 147

SELECT INSTR(l_temp_str, '', 1, 1) INTO l_loc_f FROM DUAL;

Line: 148

SELECT SUBSTR(l_temp_str,1,l_loc_f-1) INTO p_parts(l_count).content_type FROM DUAL;

Line: 150

SELECT SUBSTR(l_temp_str,l_loc_f+3) INTO l_work_str FROM DUAL;

Line: 153

SELECT INSTR(l_work_str, '', 1, 1) INTO l_loc_g FROM DUAL;

Line: 154

SELECT SUBSTR(l_work_str,1, l_loc_g-1) INTO p_parts(l_count).is_binary FROM DUAL;

Line: 157

SELECT SUBSTR(l_work_str,l_loc_g+3) INTO l_temp_str FROM DUAL;

Line: 159

SELECT INSTR(l_temp_str, '', 1, 1) INTO l_loc_h FROM DUAL;

Line: 160

SELECT SUBSTR(l_temp_str,1, l_loc_h-1) INTO p_parts(l_count).att_size FROM DUAL;

Line: 162

SELECT SUBSTR(l_temp_str,l_loc_h+3) INTO p_parts(l_count).att_name FROM DUAL;

Line: 205

SELECT INSTR(p_header_str, '', 1,1) INTO l_loc_t FROM DUAL;

Line: 206

SELECT SUBSTR(p_header_str,1, l_loc_t-1) INTO l_work_str FROM DUAL;

Line: 207

SELECT INSTR(l_work_str, '', 1, 1) INTO l_loc_s FROM DUAL;

Line: 208

SELECT SUBSTR(l_work_str,1,l_loc_s-1) INTO p_headers(l_count).hdr_name FROM DUAL;

Line: 209

SELECT SUBSTR(l_work_str,l_loc_s+3) INTO p_headers(l_count).hdr_value FROM DUAL;

Line: 211

SELECT SUBSTR(p_header_str,l_loc_t+3) INTO l_header_str FROM DUAL;

Line: 254

SELECT INSTR(p_id_str, '', 1,1) INTO l_loc_t FROM DUAL;

Line: 255

SELECT SUBSTR(p_id_str,1, l_loc_t-1) INTO p_messages(l_count) FROM DUAL;

Line: 257

SELECT SUBSTR(p_id_str,l_loc_t+3) INTO l_id_str FROM DUAL;