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_INBOUND_LOGS

Line 199: select trigger_id from ecx_inbound_logs where msgid is not null and msgid = hextoraw(p_msgid);

195:
196:
197:
198: cursor get_in_trigger_id (p_msgid in ecx_doclogs.msgid%type) is
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);

Line 390: delete from ecx_inbound_logs WHERE msgid =v_message_id_tl(i);

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:
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);

Line 472: select trigger_id from ecx_inbound_logs where msgid is not null and msgid = hextoraw(p_msgid);

468: /**TYPE t_msg_id_tl is TABLE of ecx_doclogs.msgid%type;
469: v_msg_id_tl t_msg_id_tl;**/
470:
471: cursor get_in_trigger_id (p_msgid in ecx_doclogs.msgid%type) is
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);

Line 593: delete from ecx_inbound_logs WHERE msgid =v_msgid;

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:
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;