APPS.IEM_SPV_ACTIONS_PVT SQL Statements

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

Line: 6

PROCEDURE delete_queue_msg (p_api_version_number    IN   NUMBER,
 		  	      p_init_msg_list  IN   VARCHAR2 := NULL,
		    	      p_commit	    IN   VARCHAR2 := NULL,
			      p_message_id in number,
			      p_reason_id  in number,
			      x_return_status	OUT	NOCOPY 	VARCHAR2,
  		  	      x_msg_count	OUT	NOCOPY  NUMBER,
	  	  	      x_msg_data	OUT	NOCOPY	VARCHAR2) IS

    l_api_name		varchar2(30):='delete_queue_msg';

Line: 37

    SAVEPOINT delete_queue_msg;

Line: 56

	select * into l_post_mdts from iem_rt_proc_emails where message_id=p_message_id for update;

Line: 60

	select resource_id into l_spv_resource_id from jtf_rs_resource_extns where user_id=l_current_user;

Line: 84

     		--l_interaction_rec.outcome_id        := 14; -- EMAIL DELETED

Line: 89

     		select wu.outcome_id, wu.result_id, wu.reason_id into
		l_interaction_rec.outcome_id, l_interaction_rec.result_id, l_interaction_rec.reason_id
		from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
		where aa.action_id =  31 and aa.action_item_id = 45
		and aa.default_wrap_id = wu.wrap_id;

Line: 117

               	select wu.outcome_id, wu.result_id into
		l_interaction_rec.outcome_id, l_interaction_rec.result_id
		from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
		where aa.action_id =  31 and aa.action_item_id = 45
		and aa.default_wrap_id = wu.wrap_id;

Line: 123

               	JTF_IH_PUB.Update_Interaction( p_api_version     => 1.0,
                                  p_resp_appl_id    => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
                                  p_resp_id         => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
                                  p_user_id         => nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
                                  p_login_id	    =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
                                  x_return_status   => l_return_status,
                                  x_msg_count       => l_msg_count,
                                  x_msg_data        => l_msg_data,
                                  p_interaction_rec => l_interaction_rec
				 );

Line: 143

         	l_activity_rec.action_id         := 31;	-- Deleted an inbound email

Line: 209

	/*select name into l_class_name from iem_route_classifications where route_classification_id=l_post_mdts.rt_classification_id;

Line: 216

  				 p_tofolder	=> 'Deleted',
  				 p_fromfolder => l_class_name,
		  		x_return_status	=> l_return_status,
  		    		x_msg_count	 => l_msg_count,
	  	    		x_msg_data	=> l_msg_data);

Line: 229

    	-- Delete from queue and close media items
	IEM_MAILITEM_PUB.ResolvedMessage (p_api_version_number  => 1.0,
                        	p_init_msg_list => FND_API.G_FALSE,
                                p_commit => FND_API.G_FALSE,
                                p_message_id          => l_post_mdts.message_id,
				p_action_flag	      => 'D',
				x_return_status       => l_return_status,
                                x_msg_count           => l_msg_count,
                                x_msg_data            => l_msg_data);

Line: 253

       	    ROLLBACK TO delete_queue_msg;

Line: 260

	   ROLLBACK TO delete_queue_msg;

Line: 266

	   ROLLBACK TO delete_queue_msg;

Line: 271

	  ROLLBACK TO delete_queue_msg;

Line: 279

END delete_queue_msg;

Line: 282

PROCEDURE delete_queue_msg_batch (p_api_version_number  IN   NUMBER,
 		  	      p_init_msg_list  		IN   VARCHAR2 := NULL,
		    	      p_commit	    		IN   VARCHAR2 := NULL,
			      p_message_ids_tbl 	IN  jtf_varchar2_Table_100,
			      p_reason_id		IN	NUMBER,
			      x_moved_message_count  	OUT	NOCOPY NUMBER,
			      x_return_status		OUT	NOCOPY VARCHAR2,
  		  	      x_msg_count	      	OUT	NOCOPY   NUMBER,
	  	  	      x_msg_data		OUT	NOCOPY VARCHAR2) IS

    l_api_name		varchar2(30):='delete_queue_msg_batch';

Line: 303

    SAVEPOINT delete_queue_msg_batch;

Line: 325

	iem_spv_actions_pvt.delete_queue_msg (p_api_version_number => 1.0,
 		  	      p_init_msg_list => FND_API.G_FALSE,
		    	      p_commit	=> FND_API.G_FALSE,
			      p_message_id => p_message_ids_tbl(i),
			      p_reason_id => p_reason_id,
			      x_return_status => l_return_status,
  		  	      x_msg_count => l_msg_count,
	  	  	      x_msg_data => l_msg_data) ;

Line: 352

	   ROLLBACK TO delete_queue_msg;

Line: 358

	   ROLLBACK TO delete_queue_msg;

Line: 363

	  ROLLBACK TO delete_queue_msg;

Line: 371

END delete_queue_msg_batch;