APPS.IEM_OP_ADMIN_PUB dependencies on IEM_RT_INTERACTIONS

Line 170: from iem_rt_interactions

166: from iem_rt_media_items
167: where rt_media_item_id = l_op_rec.rt_media_item_id;
168:
169: select resource_id, status into l_resource_id, l_action
170: from iem_rt_interactions
171: where rt_interaction_id = l_rt_interaction_id;
172: exception
173: -- If no data found because of descripancy in database
174: -- ignore those messages.

Line 406: (select rt_interaction_id from iem_rt_interactions

402: if ( p_rt_media_item_id_array(p_rt_media_item_id_array.FIRST).num = G_ALL ) then
403: begin
404: update iem_rt_media_items set expire = G_EXPIRE
405: where rt_interaction_id in
406: (select rt_interaction_id from iem_rt_interactions
407: where expire = G_PROCESSING);
408:
409: update iem_rt_interactions set expire = G_EXPIRE
410: where expire = G_PROCESSING;

Line 409: update iem_rt_interactions set expire = G_EXPIRE

405: where rt_interaction_id in
406: (select rt_interaction_id from iem_rt_interactions
407: where expire = G_PROCESSING);
408:
409: update iem_rt_interactions set expire = G_EXPIRE
410: where expire = G_PROCESSING;
411:
412: update iem_outbox_errors set expire = G_EXPIRE;
413: end;

Line 421: update iem_rt_interactions set expire = G_EXPIRE where

417: select rt_interaction_id into l_rt_interaction_id
418: from iem_rt_media_items
419: where rt_media_item_id = p_rt_media_item_id_array(i).num;
420:
421: update iem_rt_interactions set expire = G_EXPIRE where
422: rt_interaction_id = l_rt_interaction_id;
423:
424: update iem_rt_media_items set expire = G_EXPIRE where
425: rt_interaction_id = l_rt_interaction_id;

Line 554: from iem_rt_interactions where rt_interaction_id = l_rt_interaction_id;

550: v_rt_interaction_id := l_rt_interaction_id;
551:
552: select interaction_id, mc_parameter_id, status, expire, to_resource_id
553: into v_interaction_id, v_mcp_id, l_ih_status, v_rt_ih_expire, l_to_resource_id
554: from iem_rt_interactions where rt_interaction_id = l_rt_interaction_id;
555:
556: v_action := l_ih_status;
557:
558: -- to_resource_id - to agent id when transfer, to group id when redirect

Line 891: from iem_rt_interactions rti

887: where rt_media_item_id = p_rt_media_item_ids(i).num;
888:
889: select rti.mc_parameter_id, rti.interaction_id, rti.customer_id, rti.contact_id, rti.relationship_id
890: into l_mcp_id, l_interaction_id, l_customer_id, l_contact_id, l_relationship_id
891: from iem_rt_interactions rti
892: where rti.rt_interaction_id = l_rt_interaction_id;
893:
894: l_mcp_action := null;
895: if ( l_mcp_id > 0 ) then

Line 931: update iem_rt_interactions set expire = G_EXPIRE

927:
928: update iem_rt_media_items set expire = G_EXPIRE
929: where rt_interaction_id = l_rt_interaction_id;
930:
931: update iem_rt_interactions set expire = G_EXPIRE
932: where rt_interaction_id = l_rt_interaction_id;
933:
934: update iem_outbox_errors set expire = G_EXPIRE
935: where rt_media_item_id in

Line 953: update iem_rt_interactions set expire = G_ACTIVE

949: update iem_rt_media_items set expire = G_EXPIRE
950: where message_id = l_message_id and expire = 'D';
951: end if;
952:
953: update iem_rt_interactions set expire = G_ACTIVE
954: where rt_interaction_id = l_rt_interaction_id;
955:
956: if ( l_message_id > 0 ) then
957: update iem_rt_proc_emails set queue_status = null