APPS.IEM_REROUTE_PUB SQL Statements

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

Line: 53

INSERT_HIST_EXCEPTION	EXCEPTION;

Line: 54

INSERT_MDT_EXCEPTION	EXCEPTION;

Line: 84

         		p_LAST_UPDATED_BY  =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
          	p_LAST_UPDATE_DATE  =>SYSDATE,
          	p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
         		p_ATTRIBUTE1   =>null,
          	p_ATTRIBUTE2   =>null,
          	p_ATTRIBUTE3   =>null,
          	p_ATTRIBUTE4   =>null,
          	p_ATTRIBUTE5   =>null,
          	p_ATTRIBUTE6   =>null,
          	p_ATTRIBUTE7   =>null,
          	p_ATTRIBUTE8   =>null,
          	p_ATTRIBUTE9   =>null,
          	p_ATTRIBUTE10  =>null,
          	p_ATTRIBUTE11  =>null,
          	p_ATTRIBUTE12  =>null,
          	p_ATTRIBUTE13  =>null,
          	p_ATTRIBUTE14  =>null,
          	p_ATTRIBUTE15  =>null,
		      x_return_status=>l_ret_status	,
  		 	 x_msg_count=>l_msg_count	      ,
	  	  	 x_msg_data=>l_msg_data);

Line: 106

		RAISE INSERT_HIST_EXCEPTION;

Line: 134

	select * into l_post_rec
	from iem_rt_proc_emails
	where message_id=p_msgid;

Line: 145

					select wu.outcome_id, wu.result_id, wu.reason_id INTO
 					l_activity_rec.outcome_id, l_activity_rec.result_id, l_activity_rec.reason_id
        				from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
        				where aa.action_id =l_activity_rec.action_id
					and aa.action_item_id = l_activity_rec.action_item_id
        				and aa.default_wrap_id = wu.wrap_id;

Line: 173

	select count(*) into l_count from
 	jtf_rs_group_members c,iem_agents d
	where group_id=l_post_rec.group_id
	and delete_flag = 'N' and c.resource_id<>p_agent_id and c.resource_id = d.resource_id
	and d.email_account_id = l_post_rec.email_account_id
	and d.resource_id not in (select agent_id from iem_reroute_hists where message_id=p_msgid);

Line: 190

		update iem_rt_proc_emails
		set resource_id=0,
		msg_status='REROUTE',
		group_id=l_group_id,
		IH_INTERACTION_ID=l_interaction_id
		where message_id=p_msgid;

Line: 197

	select * into l_post_rec
	from iem_rt_proc_emails
	where message_id=p_msgid;

Line: 213

		RAISE INSERT_MDT_EXCEPTION;

Line: 215

	-- Later the below update statement will be added  to above create_item api 09/30/04 RT

	update iem_rt_preproc_emails
	set msg_status='REROUTE',
	IH_INTERACTION_ID=p_interaction_id,
	IH_MEDIA_ITEM_ID=l_post_rec.ih_media_item_id,
	RT_CLASSIFICATION_ID=p_class_id
	where message_id=p_msgid;

Line: 223

	delete from iem_rt_proc_emails where message_id=p_msgid;

Line: 236

 EXCEPTION WHEN INSERT_HIST_EXCEPTION  THEN
	rollback to IEM_MAIL_REROUTE_PVT;

Line: 238

           FND_MESSAGE.SET_NAME('IEM','IEM_INSERT_HIST_EXCEPTION');

Line: 243

 WHEN INSERT_MDT_EXCEPTION  THEN
	rollback to IEM_MAIL_REROUTE_PVT;

Line: 245

           FND_MESSAGE.SET_NAME('IEM','IEM_INSERT_MDT_EXCEPTION');

Line: 343

	INSERT_HIST_EXCEPTION	EXCEPTION;

Line: 370

         		p_LAST_UPDATED_BY  =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
          	p_LAST_UPDATE_DATE  =>SYSDATE,
          	p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
         		p_ATTRIBUTE1   =>null,
          	p_ATTRIBUTE2   =>null,
          	p_ATTRIBUTE3   =>null,
          	p_ATTRIBUTE4   =>null,
          	p_ATTRIBUTE5   =>null,
          	p_ATTRIBUTE6   =>null,
          	p_ATTRIBUTE7   =>null,
          	p_ATTRIBUTE8   =>null,
          	p_ATTRIBUTE9   =>null,
          	p_ATTRIBUTE10  =>null,
          	p_ATTRIBUTE11  =>null,
          	p_ATTRIBUTE12  =>null,
          	p_ATTRIBUTE13  =>null,
          	p_ATTRIBUTE14  =>null,
          	p_ATTRIBUTE15  =>null,
		      x_return_status=>l_ret_status	,
  		 	 x_msg_count=>l_msg_count	      ,
	  	  	 x_msg_data=>l_msg_data);

Line: 392

			raise INSERT_HIST_EXCEPTION;

Line: 394

		delete from iem_email_classifications where message_id=p_msgid;

Line: 395

		delete from iem_kb_Results where message_id=p_msgid;

Line: 396

select * into l_post_rec from iem_rt_proc_emails where message_id=p_msgid;

Line: 412

	-- Later the below update statement will be added  to above create_item api 09/30/04 RT

	update iem_rt_preproc_emails
	set msg_status='REROUTE',
	IH_INTERACTION_ID=p_interaction_id,
	IH_MEDIA_ITEM_ID=l_post_rec.ih_media_item_id
	where message_id=p_msgid;

Line: 419

 delete from iem_rt_proc_emails where message_id=p_msgid;

Line: 430

 EXCEPTION WHEN INSERT_HIST_EXCEPTION  THEN
	rollback to IEM_MAIL_REROUTE_PVT;

Line: 432

           FND_MESSAGE.SET_NAME('IEM','IEM_REROUTE_INSERT_FAILS');

Line: 514

		update iem_rt_proc_emails
		set group_id=p_group_id
		where message_id=to_number(p_msg_ids_tbl(i));