DBA Data[Home] [Help]

APPS.ECX_PURGE dependencies on ECX_OXTA_LOGMSG

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

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:
397: IF (l_commitFlag and (mod(i,commit_frequency_ecx) = 0 or (i = v_message_id_tl.count))) THEN

Line 596: delete from ecx_oxta_logmsg WHERE receipt_message_id =v_msgid

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:
600: /** IF (l_commitFlag and (mod(i,commit_frequency_ecx) = 0 or (i = v_msg_id_tl.count))) THEN