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_OUTBOUND_LOGS

Line 4: -- Delete records from ecx_outbound_logs which don't have item_type, item_key

1: package body ECX_PURGE as
2: /* $Header: ECXPRGB.pls 120.4.12010000.3 2008/10/08 21:12:12 cpeixoto ship $*/
3: -- procedure PURGE
4: -- Delete records from ecx_outbound_logs which don't have item_type, item_key
5: -- (To delete records which don't have an entry in ecx_doclogs)
6: -- IN:
7: -- transaction_type - transaction type to delete, or null for all transaction type
8: -- transaction_subtype - transaction subtype to delete, or null for all transaction subtype

Line 23: TYPE t_trigger_id_tl is TABLE of ecx_outbound_logs.trigger_id%type;

19: fromDate in date,
20: toDate in date,
21: commitFlag in boolean) IS
22:
23: TYPE t_trigger_id_tl is TABLE of ecx_outbound_logs.trigger_id%type;
24: TYPE t_error_id_tl is TABLE of ecx_msg_logs.error_id%type;
25:
26: v_trigger_id_tl t_trigger_id_tl := t_trigger_id_tl();
27: v_error_id_tl t_error_id_tl;

Line 32: l_trigger_ID ecx_outbound_logs.trigger_id%type;

28:
29: l_CursorID number;
30: l_result NUMBER;
31: l_Select VARCHAR2(2400);
32: l_trigger_ID ecx_outbound_logs.trigger_id%type;
33:
34: cursor get_out_error_id (p_trigger_id in ecx_outbound_logs.TRIGGER_ID%type) is
35: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
36:

Line 34: cursor get_out_error_id (p_trigger_id in ecx_outbound_logs.TRIGGER_ID%type) is

30: l_result NUMBER;
31: l_Select VARCHAR2(2400);
32: l_trigger_ID ecx_outbound_logs.trigger_id%type;
33:
34: cursor get_out_error_id (p_trigger_id in ecx_outbound_logs.TRIGGER_ID%type) is
35: select error_id from ecx_msg_logs where trigger_id = p_trigger_id;
36:
37: bulk_delete_cycles pls_integer;
38: bulk_delete_first pls_integer;

Line 43: l_Select:= 'select trigger_id from ecx_outbound_logs where 1=1 ';

39: bulk_delete_last pls_integer;
40:
41: begin
42:
43: l_Select:= 'select trigger_id from ecx_outbound_logs where 1=1 ';
44:
45:
46: if transaction_type is not null then
47: l_Select := l_Select || 'and transaction_type = :transaction_type ';

Line 148: delete from ecx_outbound_logs WHERE trigger_id = v_trigger_id_tl(j);

144: IF (bulk_delete_last > v_trigger_id_tl.count) THEN
145: bulk_delete_last := v_trigger_id_tl.count;
146: END IF;
147: FORALL j IN bulk_delete_first..bulk_delete_last
148: delete from ecx_outbound_logs WHERE trigger_id = v_trigger_id_tl(j);
149: IF (commitFlag) THEN
150: commit;
151: END IF;
152: end loop;

Line 201: select trigger_id from ecx_outbound_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);

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

Line 214: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;

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

Line 391: delete from ecx_outbound_logs WHERE out_msgid =v_message_id_tl(i);

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);
395: delete from ecx_doclogs WHERE msgid = hextoraw(v_message_id_tl(i));

Line 474: select trigger_id from ecx_outbound_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);

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

Line 488: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;

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

Line 594: delete from ecx_outbound_logs WHERE out_msgid =v_msgid;

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;
598: delete from ecx_doclogs WHERE msgid = hextoraw(v_msgid);

Line 755: --l_transactiontype ecx_outbound_logs.transaction_type%type:=transactiontype;

751: is
752: errname varchar2(30);
753: errmsg varchar2(2000);
754: errstack varchar2(2000);
755: --l_transactiontype ecx_outbound_logs.transaction_type%type:=transactiontype;
756: -- l_transactionsubtype ecx_outbound_logs.transaction_subtype%type:=transactionsubtype;
757: l_fromdate date:=fromdate;
758: l_todate date:=todate;
759: docommit boolean := TRUE;

Line 756: -- l_transactionsubtype ecx_outbound_logs.transaction_subtype%type:=transactionsubtype;

752: errname varchar2(30);
753: errmsg varchar2(2000);
754: errstack varchar2(2000);
755: --l_transactiontype ecx_outbound_logs.transaction_type%type:=transactiontype;
756: -- l_transactionsubtype ecx_outbound_logs.transaction_subtype%type:=transactionsubtype;
757: l_fromdate date:=fromdate;
758: l_todate date:=todate;
759: docommit boolean := TRUE;
760: l_sql varchar2(500);