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.ECX_PURGE dependencies on ECX_ERROR_MSGS

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

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

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

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

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

353: LOOP
354: open get_in_error_id (v_in_trigger_id_tl(i));
355: fetch get_in_error_id bulk collect into v_in_error_id_tl ;
356: FORALL i IN 1..v_in_error_id_tl.count
357: delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);
358: FORALL i IN 1..v_in_error_id_tl.count
359: delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);
360: close get_in_error_id;
361: END LOOP;

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

367: LOOP
368: open get_out_error_id (v_out_trigger_id_tl(i));
369: fetch get_out_error_id bulk collect into v_out_error_id_tl ;
370: FORALL i IN 1..v_out_error_id_tl.count
371: delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);
372: FORALL i IN 1..v_out_error_id_tl.count
373: delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);
374: close get_out_error_id;
375: END LOOP;

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

385: close get_ext_ret_error_id;
386:
387:
388: FORALL i IN 1..v_ext_log_error_id_tl.count
389: delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);
390:
391: FORALL i IN 1..v_ext_log_error_id_tl.count
392: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
393:

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

391: FORALL i IN 1..v_ext_log_error_id_tl.count
392: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
393:
394: FORALL i IN 1..v_ext_ret_error_id_tl.count
395: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
396:
397: FORALL i IN 1..v_ext_ret_error_id_tl.count
398: delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);
399:

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

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

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

574: LOOP
575: open get_out_error_id (v_out_trigger_id_tl(i));
576: fetch get_out_error_id bulk collect into v_out_error_id_tl ;
577: FORALL i IN 1..v_out_error_id_tl.count
578: delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);
579: FORALL i IN 1..v_out_error_id_tl.count
580: delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);
581: close get_out_error_id;
582: END LOOP;

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

592: close get_ext_ret_error_id;
593:
594:
595: FORALL i IN 1..v_ext_log_error_id_tl.count
596: delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);
597:
598: FORALL i IN 1..v_ext_log_error_id_tl.count
599: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
600:

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

598: FORALL i IN 1..v_ext_log_error_id_tl.count
599: delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);
600:
601: FORALL i IN 1..v_ext_ret_error_id_tl.count
602: delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);
603:
604: FORALL i IN 1..v_ext_ret_error_id_tl.count
605: delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);
606: