205:
206:
207:
208: cursor get_in_trigger_id (p_msgid in ecx_doclogs.msgid%type) is
209: select trigger_id from ecx_inbound_logs where msgid is not null and msgid = hextoraw(p_msgid);
210: cursor get_out_trigger_id (p_msgid in ecx_doclogs.msgid%type) is
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);
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)
405: OR sender_message_id =v_message_id_tl(i);
483: /**TYPE t_msg_id_tl is TABLE of ecx_doclogs.msgid%type;
484: v_msg_id_tl t_msg_id_tl;**/
485:
486: cursor get_in_trigger_id (p_msgid in ecx_doclogs.msgid%type) is
487: select trigger_id from ecx_inbound_logs where msgid is not null and msgid = hextoraw(p_msgid);
488: cursor get_out_trigger_id (p_msgid in ecx_doclogs.msgid%type) is
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);
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
612: OR sender_message_id =v_msgid;