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_LOGS

Line 203: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);

199: select trigger_id from ecx_inbound_logs where msgid is not null and msgid = hextoraw(p_msgid);
200: cursor get_out_trigger_id (p_msgid in ecx_doclogs.msgid%type) is
201: select trigger_id from ecx_outbound_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
202: cursor get_ext_log_error_id (p_msgid in ecx_doclogs.msgid%type) is
203: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
204: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
205: select error_id from ecx_external_retry where msgid = p_msgid;
206: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
207: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line 215: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;

211: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;
212: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;
213: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;
214: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
215: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
216: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
217: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
218: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
219: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;

Line 392: delete from ecx_external_logs WHERE out_msgid =v_message_id_tl(i);

388:
389: delete from ecx_external_retry WHERE msgid =v_message_id_tl(i);
390: delete from ecx_inbound_logs WHERE msgid =v_message_id_tl(i);
391: delete from ecx_outbound_logs WHERE out_msgid =v_message_id_tl(i);
392: delete from ecx_external_logs WHERE out_msgid =v_message_id_tl(i);
393: delete from ecx_oxta_logmsg WHERE receipt_message_id =v_message_id_tl(i)
394: OR sender_message_id =v_message_id_tl(i);
395: delete from ecx_doclogs WHERE msgid = hextoraw(v_message_id_tl(i));
396:

Line 476: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);

472: select trigger_id from ecx_inbound_logs where msgid is not null and msgid = hextoraw(p_msgid);
473: cursor get_out_trigger_id (p_msgid in ecx_doclogs.msgid%type) is
474: select trigger_id from ecx_outbound_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
475: cursor get_ext_log_error_id (p_msgid in ecx_doclogs.msgid%type) is
476: select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);
477: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
478: select error_id from ecx_external_retry where msgid = p_msgid;
479: cursor get_in_error_id (p_trigger_id in ecx_msg_logs.trigger_id%type) is
480: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line 489: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;

485: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;
486: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;
487: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;
488: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
489: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
490: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
491: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
492: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
493: TYPE t_in_error_id_tl is TABLE of ecx_msg_logs.error_id%type;

Line 595: delete from ecx_external_logs WHERE out_msgid =v_msgid;

591:
592: delete from ecx_external_retry WHERE msgid =v_msgid;
593: delete from ecx_inbound_logs WHERE msgid =v_msgid;
594: delete from ecx_outbound_logs WHERE out_msgid =v_msgid;
595: delete from ecx_external_logs WHERE out_msgid =v_msgid;
596: delete from ecx_oxta_logmsg WHERE receipt_message_id =v_msgid
597: OR sender_message_id =v_msgid;
598: delete from ecx_doclogs WHERE msgid = hextoraw(v_msgid);
599: