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_EXTERNAL_RETRY

Line 215: select error_id from ecx_external_retry where msgid = p_msgid;

211: select trigger_id from ecx_outbound_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
212: cursor get_ext_log_error_id (p_msgid in ecx_doclogs.msgid%type) is
213: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
214: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
215: select error_id from ecx_external_retry where msgid = p_msgid;
216: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
217: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
218: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
219: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line 226: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;

222: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;
223: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;
224: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
225: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
226: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
227: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
228: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
229: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
230:

Line 400: delete from ecx_external_retry WHERE msgid =v_message_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:
400: delete from ecx_external_retry WHERE msgid =v_message_id_tl(i);
401: delete from ecx_inbound_logs WHERE msgid =v_message_id_tl(i);
402: delete from ecx_outbound_logs WHERE out_msgid =v_message_id_tl(i);
403: delete from ecx_external_logs WHERE out_msgid =v_message_id_tl(i);
404: delete from ecx_oxta_logmsg WHERE receipt_message_id =v_message_id_tl(i)

Line 493: select error_id from ecx_external_retry where msgid = p_msgid;

489: select trigger_id from ecx_outbound_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
490: cursor get_ext_log_error_id (p_msgid in ecx_doclogs.msgid%type) is
491: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
492: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
493: select error_id from ecx_external_retry where msgid = p_msgid;
494: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
495: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
496: cursor get_out_error_id (p_trigger_id in ecx_msg_logs.ERROR_ID%type) is
497: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line 505: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;

501: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;
502: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;
503: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
504: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
505: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
506: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
507: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
508: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
509:

Line 607: delete from ecx_external_retry WHERE msgid =v_msgid;

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:
607: delete from ecx_external_retry WHERE msgid =v_msgid;
608: delete from ecx_inbound_logs WHERE msgid =v_msgid;
609: delete from ecx_outbound_logs WHERE out_msgid =v_msgid;
610: delete from ecx_external_logs WHERE out_msgid =v_msgid;
611: delete from ecx_oxta_logmsg WHERE receipt_message_id =v_msgid