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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31


        l_Select        VARCHAR2(2400);

Line: 35


		select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line: 37


	bulk_delete_cycles pls_integer;

Line: 38


	bulk_delete_first pls_integer;

Line: 39


	bulk_delete_last pls_integer;

Line: 43


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

Line: 47


                   l_Select := l_Select || 'and transaction_type = :transaction_type ';

Line: 50


                   l_Select := l_Select || 'and transaction_subtype = :transaction_subtype ';

Line: 53


                   l_Select := l_Select || 'and party_id = :party_id ';

Line: 56


                   l_Select := l_Select || 'and party_site_id = :party_site_id ';

Line: 59


                   l_Select := l_Select || 'and time_stamp >= :fromDate ';

Line: 62


                   l_Select := l_Select || 'and time_stamp <= :toDate ';

Line: 65


                l_Select := l_Select || ' for update nowait ';

Line: 68


                DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);

Line: 116


		bulk_delete_cycles := round(v_error_id_tl.count/commit_frequency_ecx + 0.5);

Line: 120


			For i IN 1..bulk_delete_cycles loop
				bulk_delete_first := ((i-1) * commit_frequency_ecx) + 1;

Line: 122


				bulk_delete_last := bulk_delete_first  + commit_frequency_ecx;

Line: 123


				IF (bulk_delete_last > v_error_id_tl.count) THEN
					bulk_delete_last := v_error_id_tl.count;

Line: 126


				FORALL j IN bulk_delete_first..bulk_delete_last
					delete from ecx_error_msgs where error_id = v_error_id_tl(j);

Line: 132


				FORALL j IN bulk_delete_first..bulk_delete_last
					delete from ecx_msg_logs where error_id = v_error_id_tl(j);

Line: 142


			bulk_delete_cycles := round(v_trigger_id_tl.count/commit_frequency_ecx + 0.5);

Line: 143


			For i IN 1..bulk_delete_cycles loop
				bulk_delete_first := ((i-1) * commit_frequency_ecx) + 1;

Line: 145


				bulk_delete_last := bulk_delete_first  + commit_frequency_ecx;

Line: 146


				IF (bulk_delete_last > v_trigger_id_tl.count) THEN
					bulk_delete_last := v_trigger_id_tl.count;

Line: 149


				FORALL j IN bulk_delete_first..bulk_delete_last
					delete from ecx_outbound_logs WHERE trigger_id = v_trigger_id_tl(j);

Line: 204


        l_Select        VARCHAR2(2400);

Line: 209


		select trigger_id from ecx_inbound_logs where msgid is not null and msgid = hextoraw(p_msgid);

Line: 211


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

Line: 213


		select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);

Line: 215


		select error_id from ecx_external_retry where msgid = p_msgid;

Line: 217


		select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line: 219


		select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line: 241


	bulk_delete_first pls_integer;

Line: 242


	bulk_delete_last pls_integer;

Line: 247


	is_bulk_delete_cycle boolean := false;

Line: 257


                l_Select:= 'select msgid, item_type, item_key from ecx_doclogs where 1 = 1 ' ;

Line: 260


                   l_Select := l_Select || 'and item_type = :item_type ';

Line: 263


                   l_Select := l_Select || 'and item_key = :item_key ';

Line: 266


                   l_Select := l_Select || 'and transaction_type = :transaction_type ';

Line: 269


                   l_Select := l_Select || 'and transaction_subtype = :transaction_subtype ';

Line: 272


                   l_Select := l_Select || 'and partyid = :party_id '; /*Fixed the column name from party_id to partyid while fxing Bug# 12860076 */

Line: 275


                   l_Select := l_Select || 'and party_site_id = :party_site_id ';

Line: 278


                   l_Select := l_Select || 'and time_stamp >= :fromDate ';

Line: 281


                   l_Select := l_Select || 'and time_stamp <= :toDate ';

Line: 284


                l_Select := l_Select || ' for update nowait ';

Line: 287


                DBMS_SQL.parse(l_CursorID, l_Select, DBMS_SQL.V7);

Line: 357


                                  delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);

Line: 359


                                  delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);

Line: 371


                                  delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);

Line: 373


                                  delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);

Line: 389


					delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);

Line: 392


					delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);

Line: 395


					delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);

Line: 398


					delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);

Line: 400


				delete from ecx_external_retry WHERE msgid =v_message_id_tl(i);

Line: 401


				delete from ecx_inbound_logs WHERE msgid =v_message_id_tl(i);

Line: 402


				delete from ecx_outbound_logs WHERE out_msgid =v_message_id_tl(i);

Line: 403


				delete from ecx_external_logs WHERE out_msgid =v_message_id_tl(i);

Line: 404


				delete from ecx_oxta_logmsg WHERE receipt_message_id =v_message_id_tl(i)
                                             OR sender_message_id =v_message_id_tl(i);

Line: 406


				delete from ecx_doclogs WHERE msgid = hextoraw(v_message_id_tl(i));

Line: 474


           select transaction_id from ecx_transactions;

Line: 477


           select ext_type, ext_subtype from   ecx_ext_processes ecxextpc where  ecxextpc.transaction_id = p_trans_id;

Line: 487


		select trigger_id from ecx_inbound_logs where msgid is not null and msgid = hextoraw(p_msgid);

Line: 489


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

Line: 491


		select error_id from ecx_external_logs where out_msgid is not null and out_msgid = hextoraw(p_msgid);

Line: 493


		select error_id from ecx_external_retry where msgid = p_msgid;

Line: 495


		select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line: 497


		select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line: 520


	bulk_delete_first pls_integer;

Line: 521


	bulk_delete_last pls_integer;

Line: 526


	is_bulk_delete_cycle boolean := false;

Line: 552


select msgid into v_msgid from ecx_doclogs where
 (item_type = WF_PURGE.l_itemtypeTAB(i)) and (item_key =WF_PURGE.l_itemkeyTAB(i) ) ;

Line: 564


                                  delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);

Line: 566


                                  delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);

Line: 578


                                  delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);

Line: 580


                                  delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);

Line: 596


					delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);

Line: 599


					delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);

Line: 602


					delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);

Line: 605


					delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);

Line: 607


				delete from ecx_external_retry WHERE msgid =v_msgid;

Line: 608


				delete from ecx_inbound_logs WHERE msgid =v_msgid;

Line: 609


				delete from ecx_outbound_logs WHERE out_msgid =v_msgid;

Line: 610


				delete from ecx_external_logs WHERE out_msgid =v_msgid;

Line: 611


				delete from ecx_oxta_logmsg WHERE receipt_message_id =v_msgid
                                             OR sender_message_id =v_msgid;

Line: 613


				delete from ecx_doclogs WHERE msgid = hextoraw(v_msgid);

Line: 677


         select transaction_id
          from ecx_transactions
        WHERE transaction_type = p_int_trans_type AND
              transaction_subtype = p_int_trans_subtype;

Line: 682


         select transaction_id
          from ecx_transactions
        WHERE transaction_type = p_int_trans_type;

Line: 686


          select transaction_id
	from ecx_transactions
        WHERE transaction_subtype = p_int_trans_subtype;

Line: 690


          select transaction_id from ecx_transactions;

Line: 692


           select ext_type, ext_subtype from   ecx_ext_processes ecxextpc where  ecxextpc.transaction_id = p_trans_id;