DBA Data[Home] [Help]

APPS.ECX_PURGE dependencies on ECX_OXTA_LOGMSG

Line 404: delete from ecx_oxta_logmsg WHERE receipt_message_id =v_message_id_tl(i)

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);
406: delete from ecx_doclogs WHERE msgid = hextoraw(v_message_id_tl(i));
407:
408: IF (l_commitFlag and (mod(i,commit_frequency_ecx) = 0 or (i = v_message_id_tl.count))) THEN

Line 611: delete from ecx_oxta_logmsg WHERE receipt_message_id =v_msgid

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;
613: delete from ecx_doclogs WHERE msgid = hextoraw(v_msgid);
614:
615: /** IF (l_commitFlag and (mod(i,commit_frequency_ecx) = 0 or (i = v_msg_id_tl.count))) THEN