APPS.IEM_REROUTE_PUB dependencies on IEM_RT_PREPROC_EMAILS

Line 200: iem_Rt_preproc_emails_pvt.create_item(

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' ,
203: p_commit=>'F' ,
204: p_message_id=>p_msgid,

Line 217: update iem_rt_preproc_emails

213: RAISE INSERT_MDT_EXCEPTION;
214: END IF;
215: -- Later the below update statement will be added to above create_item api 09/30/04 RT
216:
217: update iem_rt_preproc_emails
218: set msg_status='REROUTE',
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

Line 397: iem_Rt_preproc_emails_pvt.create_item(

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' ,
401: p_message_id=>p_msgid,

Line 414: update iem_rt_preproc_emails

410: RAISE REROUTING_FAILS;
411: END IF;
412: -- Later the below update statement will be added to above create_item api 09/30/04 RT
413:
414: update iem_rt_preproc_emails
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;