APPS.IEM_REROUTE_PUB dependencies on IEM_RT_PROC_EMAILS

Line 28: l_old_id iem_rt_proc_emails.rt_classification_id%type;

24: x_return_status OUT NOCOPY VARCHAR2,
25: x_msg_data OUT NOCOPY VARCHAR2) IS
26: l_api_name VARCHAR2(255):='iem_mail_reroute_class';
27: l_api_version_number NUMBER:=1.0;
28: l_old_id iem_rt_proc_emails.rt_classification_id%type;
29: l_ret_status varchar2(10);
30: l_msg_count number;
31: l_counter number;
32: l_count number;

Line 35: l_post_rec iem_rt_proc_emails%rowtype;

31: l_counter number;
32: l_count number;
33: l_msg_data varchar2(1000);
34: l_folder_name varchar2(300);
35: l_post_rec iem_rt_proc_emails%rowtype;
36: l_search varchar2(100); -- search pattern in subject
37: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
38: l_activity_rec JTF_IH_PUB.activity_rec_type;
39: l_resource_id number;

Line 135: from iem_rt_proc_emails

131: IF l_ret_status<>'S' THEN
132: raise FAILED_CREATE_INTERACTION;
133: END IF;
134: select * into l_post_rec
135: from iem_rt_proc_emails
136: where message_id=p_msgid;
137: -- Add a Activity for EMAILPROCESSING
138:
139: l_activity_rec.start_date_time := SYSDATE;

Line 190: update iem_rt_proc_emails

186: END IF;
187: ELSE -- supervisor requeue case
188: l_group_id:=p_group_id;
189: end if;
190: update iem_rt_proc_emails
191: set resource_id=0,
192: msg_status='REROUTE',
193: group_id=l_group_id,
194: IH_INTERACTION_ID=l_interaction_id

Line 198: from iem_rt_proc_emails

194: IH_INTERACTION_ID=l_interaction_id
195: where message_id=p_msgid;
196: ELSE
197: select * into l_post_rec
198: from iem_rt_proc_emails
199: where message_id=p_msgid;
200: iem_Rt_preproc_emails_pvt.create_item(
201: p_api_version_number => 1.0,
202: p_init_msg_list=>'F' ,

Line 223: delete from iem_rt_proc_emails where message_id=p_msgid;

219: IH_INTERACTION_ID=p_interaction_id,
220: IH_MEDIA_ITEM_ID=l_post_rec.ih_media_item_id,
221: RT_CLASSIFICATION_ID=p_class_id
222: where message_id=p_msgid;
223: delete from iem_rt_proc_emails where message_id=p_msgid;
224: END IF;
225:
226: -- Standard Check Of p_commit.
227: IF p_commit='T' THEN

Line 341: l_post_Rec iem_rt_proc_emails%rowtype;

337: l_msg_count number;
338: l_msg_data varchar2(100);
339: l_media_id number;
340: l_received_date date;
341: l_post_Rec iem_rt_proc_emails%rowtype;
342: REROUTING_FAILS EXCEPTION;
343: INSERT_HIST_EXCEPTION EXCEPTION;
344:
345: BEGIN

Line 396: select * into l_post_rec from iem_rt_proc_emails where message_id=p_msgid;

392: raise INSERT_HIST_EXCEPTION;
393: END IF;
394: delete from iem_email_classifications where message_id=p_msgid;
395: delete from iem_kb_Results where message_id=p_msgid;
396: select * into l_post_rec from iem_rt_proc_emails where message_id=p_msgid;
397: iem_Rt_preproc_emails_pvt.create_item(
398: p_api_version_number => 1.0,
399: p_init_msg_list=>'F' ,
400: p_commit=>'F' ,

Line 419: delete from iem_rt_proc_emails where message_id=p_msgid;

415: set msg_status='REROUTE',
416: IH_INTERACTION_ID=p_interaction_id,
417: IH_MEDIA_ITEM_ID=l_post_rec.ih_media_item_id
418: where message_id=p_msgid;
419: delete from iem_rt_proc_emails where message_id=p_msgid;
420: -- Standard Check Of p_commit.
421: IF p_commit='T' THEN
422: COMMIT WORK;
423: END IF;

Line 514: update iem_rt_proc_emails

510: END IF;
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512: IF p_msg_ids_tbl.count>0 THEN
513: FOR i IN p_msg_ids_tbl.first..p_msg_ids_tbl.last LOOP
514: update iem_rt_proc_emails
515: set group_id=p_group_id
516: where message_id=to_number(p_msg_ids_tbl(i));
517: l_upd_count:=l_upd_count+1;
518: END LOOP;