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: 114

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

Line: 118

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

Line: 120

				bulk_delete_last := bulk_delete_first  + commit_frequency_ecx;

Line: 121

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

Line: 124

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

Line: 130

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

Line: 140

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

Line: 141

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

Line: 143

				bulk_delete_last := bulk_delete_first  + commit_frequency_ecx;

Line: 144

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

Line: 147

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

Line: 194

        l_Select        VARCHAR2(2400);

Line: 199

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

Line: 201

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

Line: 203

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

Line: 205

		select error_id from ecx_external_retry where msgid = p_msgid;

Line: 207

		select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line: 209

		select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line: 231

	bulk_delete_first pls_integer;

Line: 232

	bulk_delete_last pls_integer;

Line: 237

	is_bulk_delete_cycle boolean := false;

Line: 247

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

Line: 250

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

Line: 253

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

Line: 256

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

Line: 259

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

Line: 262

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

Line: 265

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

Line: 268

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

Line: 271

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

Line: 274

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

Line: 277

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

Line: 346

                                  delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);

Line: 348

                                  delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);

Line: 360

                                  delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);

Line: 362

                                  delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);

Line: 378

					delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);

Line: 381

					delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);

Line: 384

					delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);

Line: 387

					delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);

Line: 389

				delete from ecx_external_retry WHERE msgid =v_message_id_tl(i);

Line: 390

				delete from ecx_inbound_logs WHERE msgid =v_message_id_tl(i);

Line: 391

				delete from ecx_outbound_logs WHERE out_msgid =v_message_id_tl(i);

Line: 392

				delete from ecx_external_logs WHERE out_msgid =v_message_id_tl(i);

Line: 393

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

Line: 395

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

Line: 459

           select transaction_id from ecx_transactions;

Line: 462

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

Line: 472

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

Line: 474

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

Line: 476

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

Line: 478

		select error_id from ecx_external_retry where msgid = p_msgid;

Line: 480

		select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line: 482

		select error_id from ecx_msg_logs where trigger_id = p_trigger_id;

Line: 505

	bulk_delete_first pls_integer;

Line: 506

	bulk_delete_last pls_integer;

Line: 511

	is_bulk_delete_cycle boolean := false;

Line: 537

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: 549

                                  delete from ecx_error_msgs where error_id =v_in_error_id_tl(i);

Line: 551

                                  delete from ecx_msg_logs where error_id =v_in_error_id_tl(i);

Line: 563

                                  delete from ecx_error_msgs where error_id =v_out_error_id_tl(i);

Line: 565

                                  delete from ecx_msg_logs where error_id =v_out_error_id_tl(i);

Line: 581

					delete from ecx_error_msgs where error_id = v_ext_log_error_id_tl(i);

Line: 584

					delete from ecx_msg_logs where error_id = v_ext_log_error_id_tl(i);

Line: 587

					delete from ecx_error_msgs where error_id = v_ext_ret_error_id_tl(i);

Line: 590

					delete from ecx_msg_logs where error_id = v_ext_ret_error_id_tl(i);

Line: 592

				delete from ecx_external_retry WHERE msgid =v_msgid;

Line: 593

				delete from ecx_inbound_logs WHERE msgid =v_msgid;

Line: 594

				delete from ecx_outbound_logs WHERE out_msgid =v_msgid;

Line: 595

				delete from ecx_external_logs WHERE out_msgid =v_msgid;

Line: 596

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

Line: 598

				delete from ecx_doclogs WHERE msgid = hextoraw(v_msgid);

Line: 662

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

Line: 667

         select transaction_id
          from ecx_transactions
        WHERE transaction_type = p_int_trans_type;

Line: 671

          select transaction_id
	from ecx_transactions
        WHERE transaction_subtype = p_int_trans_subtype;

Line: 675

          select transaction_id from ecx_transactions;

Line: 677

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