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.15.12020000.2 2012/07/12 11:02:33 jmaddila 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 150: delete from ecx_outbound_logs WHERE trigger_id = v_trigger_id_tl(j);

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

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

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);
214: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
215: select error_id from ecx_external_retry where msgid = p_msgid;

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

220:
221: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;
222: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;
223: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;
224: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
225: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
226: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
227: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
228: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;

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

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

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

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);
492: cursor get_ext_ret_error_id (p_msgid in ecx_doclogs.msgid%type) is
493: select error_id from ecx_external_retry where msgid = p_msgid;

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

499:
500: TYPE t_message_id_tl is TABLE of ecx_doclogs.msgid%type;
501: TYPE t_itemtype_id_tl is TABLE of ecx_doclogs.item_type%type;
502: TYPE t_itemkey_id_tl is TABLE of ecx_doclogs.item_key%type;
503: TYPE t_out_error_id_tl is TABLE of ecx_outbound_logs.error_id%type;
504: TYPE t_ext_log_error_id_tl is TABLE of ecx_external_logs.error_id%type;
505: TYPE t_ext_ret_error_id_tl is TABLE of ecx_external_retry.error_id%type;
506: TYPE t_in_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;
507: TYPE t_out_trigger_id_tl is TABLE of ecx_msg_logs.trigger_id%type;

Line 609: delete from ecx_outbound_logs WHERE out_msgid =v_msgid;

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

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

766: is
767: errname varchar2(30);
768: errmsg varchar2(2000);
769: errstack varchar2(2000);
770: --l_transactiontype ecx_outbound_logs.transaction_type%type:=transactiontype;
771: -- l_transactionsubtype ecx_outbound_logs.transaction_subtype%type:=transactionsubtype;
772: l_fromdate date:=fromdate;
773: l_todate date:=todate;
774: docommit boolean := TRUE;

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

767: errname varchar2(30);
768: errmsg varchar2(2000);
769: errstack varchar2(2000);
770: --l_transactiontype ecx_outbound_logs.transaction_type%type:=transactiontype;
771: -- l_transactionsubtype ecx_outbound_logs.transaction_subtype%type:=transactionsubtype;
772: l_fromdate date:=fromdate;
773: l_todate date:=todate;
774: docommit boolean := TRUE;
775: l_sql varchar2(500);