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.CSK_DIAG_SOLUTION_PVT dependencies on DUAL

Line 193: ' from dual ';

189: sqltxt := ' select fnd_global.user_id, fnd_global.USER_NAME '||
190: ' , fnd_global.APPLICATION_SHORT_NAME '||
191: ' , fnd_global.APPLICATION_NAME '||
192: ' , fnd_global.RESP_NAME '||
193: ' from dual ';
194: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Current User Information');
195: END currentUser;
196: ------------------
197: -- cascadeDeleteTest

Line 261: select INSTR(l_index_content,'') into l_end_tag from dual;

257: if l_count_1 = 0 and l_count_2 = 0 then
258: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 30] solutions have been moved out of c1');
259: --step 40
260: l_index_content := CSK_SETUP_UTILITY_PKG.Calculate_Set_Index_Content(g_move_solutions_test_s1_aID);
261: select INSTR(l_index_content,'') into l_end_tag from dual;
262: if (l_end_tag > 0) then
263: select INSTR(l_index_content,'') into l_start_tag from dual;
264: l_categories_section := substr(l_index_content,l_start_tag+12,l_end_tag-l_start_tag-12);
265: select INSTR(l_categories_section,'a'||g_move_solutions_test_c2ID||'a') into l_count from dual;

Line 263: select INSTR(l_index_content,'') into l_start_tag from dual;

259: --step 40
260: l_index_content := CSK_SETUP_UTILITY_PKG.Calculate_Set_Index_Content(g_move_solutions_test_s1_aID);
261: select INSTR(l_index_content,'') into l_end_tag from dual;
262: if (l_end_tag > 0) then
263: select INSTR(l_index_content,'') into l_start_tag from dual;
264: l_categories_section := substr(l_index_content,l_start_tag+12,l_end_tag-l_start_tag-12);
265: select INSTR(l_categories_section,'a'||g_move_solutions_test_c2ID||'a') into l_count from dual;
266: if(l_count > 0) then
267: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 40] text index of child solution updated. ');

Line 265: select INSTR(l_categories_section,'a'||g_move_solutions_test_c2ID||'a') into l_count from dual;

261: select INSTR(l_index_content,'') into l_end_tag from dual;
262: if (l_end_tag > 0) then
263: select INSTR(l_index_content,'') into l_start_tag from dual;
264: l_categories_section := substr(l_index_content,l_start_tag+12,l_end_tag-l_start_tag-12);
265: select INSTR(l_categories_section,'a'||g_move_solutions_test_c2ID||'a') into l_count from dual;
266: if(l_count > 0) then
267: JTF_DIAGNOSTIC_COREAPI.line_out('
' ||'SUCCESS: [ 40] text index of child solution updated. ');
268: else
269: l_success := 'N';