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.

[Home] [Help]

APPS.ECX_PURGE dependencies on ECX_ERROR_MSGS

Line 125: delete from ecx_error_msgs where error_id = v_error_id_tl(j);

121: IF (bulk_delete_last > v_error_id_tl.count) THEN
122: bulk_delete_last := v_error_id_tl.count;
123: END IF;
124: FORALL j IN bulk_delete_first..bulk_delete_last
125: delete from ecx_error_msgs where error_id = v_error_id_tl(j);
126: IF (commitFlag) THEN
127: -- dbms_output.put_line('v_error_id_tl.count Purge_Outbound commiting ecx_error_msgs i = '|| to_char(i));
128: commit;
129: END IF;

Line 127: -- dbms_output.put_line('v_error_id_tl.count Purge_Outbound commiting ecx_error_msgs i = '|| to_char(i));

123: END IF;
124: FORALL j IN bulk_delete_first..bulk_delete_last
125: delete from ecx_error_msgs where error_id = v_error_id_tl(j);
126: IF (commitFlag) THEN
127: -- dbms_output.put_line('v_error_id_tl.count Purge_Outbound commiting ecx_error_msgs i = '|| to_char(i));
128: commit;
129: END IF;
130: FORALL j IN bulk_delete_first..bulk_delete_last
131: delete from ecx_msg_logs where error_id = v_error_id_tl(j);

Line 346: delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);

342: LOOP
343: open get_in_error_id (v_in_trigger_id_tl(i));
344: fetch get_in_error_id bulk collect into v_in_error_id_tl ;
345: FORALL i IN 1..v_in_error_id_tl.count
346: delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);
347: FORALL i IN 1..v_in_error_id_tl.count
348: delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);
349: close get_in_error_id;
350: END LOOP;

Line 360: delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);

356: LOOP
357: open get_out_error_id (v_out_trigger_id_tl(i));
358: fetch get_out_error_id bulk collect into v_out_error_id_tl ;
359: FORALL i IN 1..v_out_error_id_tl.count
360: delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);
361: FORALL i IN 1..v_out_error_id_tl.count
362: delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);
363: close get_out_error_id;
364: END LOOP;

Line 378: delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);

374: close get_ext_ret_error_id;
375:
376:
377: FORALL i IN 1..v_ext_log_error_id_tl.count
378: delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);
379:
380: FORALL i IN 1..v_ext_log_error_id_tl.count
381: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
382:

Line 384: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);

380: FORALL i IN 1..v_ext_log_error_id_tl.count
381: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
382:
383: FORALL i IN 1..v_ext_ret_error_id_tl.count
384: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
385:
386: FORALL i IN 1..v_ext_ret_error_id_tl.count
387: delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);
388:

Line 549: delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);

545: LOOP
546: open get_in_error_id (v_in_trigger_id_tl(i));
547: fetch get_in_error_id bulk collect into v_in_error_id_tl ;
548: FORALL i IN 1..v_in_error_id_tl.count
549: delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);
550: FORALL i IN 1..v_in_error_id_tl.count
551: delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);
552: close get_in_error_id;
553: END LOOP;

Line 563: delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);

559: LOOP
560: open get_out_error_id (v_out_trigger_id_tl(i));
561: fetch get_out_error_id bulk collect into v_out_error_id_tl ;
562: FORALL i IN 1..v_out_error_id_tl.count
563: delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);
564: FORALL i IN 1..v_out_error_id_tl.count
565: delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);
566: close get_out_error_id;
567: END LOOP;

Line 581: delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);

577: close get_ext_ret_error_id;
578:
579:
580: FORALL i IN 1..v_ext_log_error_id_tl.count
581: delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);
582:
583: FORALL i IN 1..v_ext_log_error_id_tl.count
584: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
585:

Line 587: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);

583: FORALL i IN 1..v_ext_log_error_id_tl.count
584: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
585:
586: FORALL i IN 1..v_ext_ret_error_id_tl.count
587: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
588:
589: FORALL i IN 1..v_ext_ret_error_id_tl.count
590: delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);
591: