APPS.CSI_TRANSACTION_LINES_PVT SQL Statements

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

Line: 47

        	SELECT transaction_type,transaction_id,order_header_id,order_line_id
        	FROM  CSI_BATCH_TXN_LINES
        	WHERE batch_id = p_batch_id
        	AND processed_flag = 2
        	order by order_header_id,order_line_id;

Line: 65

        update CSI_BATCH_TXN_LINES
        set processed_flag = 2,last_update_date = sysdate,last_updated_by = fnd_global.user_id
        where batch_id = p_batch_id
        and processed_flag = 1;

Line: 70

        debug(' Updated '||SQL%ROWCOUNT ||' rows with batch id '||p_batch_id);

Line: 101

					UPDATE CSI_BATCH_TXN_LINES
					SET processed_flag = 4,last_update_date = sysdate,last_updated_by = fnd_global.user_id
					WHERE batch_id = p_batch_id
					AND processed_flag = 2
					and order_line_id = l_line_id_tbl(i);

Line: 125

					UPDATE CSI_BATCH_TXN_LINES
					SET processed_flag = 4,last_update_date = sysdate,last_updated_by = fnd_global.user_id
					WHERE batch_id = p_batch_id
					AND processed_flag = 2
			     		AND order_line_id = l_line_id_tbl(i);

Line: 144

				--INSERT INTO csi_batch_processing_times (worker_id, order_header_id, order_line_id, start_date, end_date,request_id,creation_date,created_by,last_update_date,last_updated_by)
				--VALUES( p_batch_id, l_header_id_tbl(i), l_line_id_tbl(i), l_start_date, sysdate,l_request_id,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);

Line: 154

		--delete processed rows from the table
		delete from csi_batch_txn_lines
		where batch_id = p_batch_id
		AND processed_flag = 2;

Line: 161

   		UPDATE csi_batch_txn_lines
		SET processed_flag = 3,last_update_date = sysdate,last_updated_by = fnd_global.user_id
		where batch_id = p_batch_id
		and processed_flag = 2;

Line: 173

    		INSERT INTO csi_batch_processing_times
   		 (worker_id, start_date, end_date,creation_date,created_by,last_update_date,last_updated_by)
    		VALUES
    		(p_batch_id, l_worker_start_date, sysdate,sysdate,fnd_global.user_id,sysdate,fnd_global.user_id);

Line: 197

    	update csi_batch_txn_lines
	set batch_id = -1,processed_flag = 0,last_update_date = sysdate,last_updated_by = fnd_global.user_id
    	where batch_id = p_batch_id;