eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_OP_ADMIN_PUB dependencies on IEM_RT_MEDIA_ITEMS

Line 166: from iem_rt_media_items

162: l_action := null;
163: l_name := null;
164: begin
165: select rt_interaction_id into l_rt_interaction_id
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

Line 404: update iem_rt_media_items set expire = G_EXPIRE

400: ----------------------code ------------------
401: if ( p_rt_media_item_id_array.COUNT > 0 ) then
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:

Line 418: from iem_rt_media_items

414: else
415: for i in p_rt_media_item_id_array.FIRST..p_rt_media_item_id_array.LAST loop
416: begin
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;

Line 424: update iem_rt_media_items set expire = G_EXPIRE where

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;
426:
427: update iem_outbox_errors set expire = G_EXPIRE where
428: rt_media_item_id = p_rt_media_item_id_array(i).num;

Line 548: from iem_rt_media_items where rt_media_item_id = p_rt_media_item_id;

544: select rt_interaction_id, resource_id, message_id, media_id,
545: to_char(creation_date, DATE_FORMAT), status
546: into l_rt_interaction_id, v_resource_id, v_mdt_msg_id, v_media_id,
547: v_create_date, v_rt_media_status
548: from iem_rt_media_items where rt_media_item_id = p_rt_media_item_id;
549:
550: v_rt_interaction_id := l_rt_interaction_id;
551:
552: select interaction_id, mc_parameter_id, status, expire, to_resource_id

Line 562: from iem_rt_media_items

558: -- to_resource_id - to agent id when transfer, to group id when redirect
559:
560: begin
561: select rt_media_item_id into v_outb_rt_media_item_id
562: from iem_rt_media_items
563: where rt_interaction_id = l_rt_interaction_id and email_type='O';
564: exception
565: when NO_DATA_FOUND then
566: v_outb_rt_media_item_id := null;

Line 571: from iem_rt_media_items

567: end;
568:
569: begin
570: select rt_media_item_id into v_inb_rt_media_item_id
571: from iem_rt_media_items
572: where rt_interaction_id = l_rt_interaction_id and email_type='I'
573: and expire <> G_DORMANT;
574: exception
575: when NO_DATA_FOUND then

Line 582: from iem_rt_media_items where rt_media_item_id = v_inb_rt_media_item_id;

578:
579: if ( v_inb_rt_media_item_id is not null ) then
580: select message_id, media_id, to_char(creation_date, DATE_FORMAT), status
581: into v_mdt_msg_id, v_media_id, v_create_date, v_rt_media_status
582: from iem_rt_media_items where rt_media_item_id = v_inb_rt_media_item_id;
583: end if;
584:
585: no_post_mdts := 1;
586: if ( v_mdt_msg_id > 0) then

Line 608: from iem_rt_media_items where rt_media_item_id = l_rt_media_item_id;

604: end if;
605:
606: select email_account_id, agent_account_id
607: into l_email_acct_id, l_agent_acct_id
608: from iem_rt_media_items where rt_media_item_id = l_rt_media_item_id;
609:
610: if (l_email_acct_id > 0) then
611: select from_name into v_master_acct_name from iem_mstemail_accounts
612: where email_account_id = l_email_acct_id;

Line 628: from iem_rt_media_items

624:
625:
626: if ( l_ih_status = 'T' or l_ih_status = 'H' or l_ih_status = 'E' ) then -- transfer
627: select agent_account_id, resource_id into l_agent_acct_id, v_to_resource_id
628: from iem_rt_media_items
629: where media_id = v_media_id and rt_media_item_id <> p_rt_media_item_id
630: and expire <> G_EXPIRE
631: and rownum < 2;
632:

Line 640: from iem_rt_media_items

636:
637: if ( l_ih_status = 'X' ) then
638: select email_account_id, db_server_id
639: into v_to_master_acct_id, l_reroute_type
640: from iem_rt_media_items
641: where rt_interaction_id = l_rt_interaction_id
642: and status = G_NEWREROUTE and expire = G_DORMANT;
643:
644: if (l_reroute_type = 76) AND (l_to_resource_id > 0) then

Line 886: from iem_rt_media_items

882: ----------------------code ------------------
883: for i in p_rt_media_item_ids.first..p_rt_media_item_ids.last loop
884:
885: select rt_interaction_id into l_rt_interaction_id
886: from iem_rt_media_items
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

Line 907: from iem_rt_media_items

903: if (l_mcp_action = 'autoreply') then
904:
905: select media_id
906: into l_inb_media_id
907: from iem_rt_media_items
908: where rt_interaction_id = l_rt_interaction_id
909: and email_type = 'I';
910:
911: IEM_EMAIL_PROC_PVT. ReprocessAutoreply(

Line 928: update iem_rt_media_items set expire = G_EXPIRE

924: if ( l_status = FND_API.G_RET_STS_ERROR ) then
925: raise IEM_MDT_PROC_EX;
926: end if;
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;

Line 936: (select rt_media_item_id from iem_rt_media_items

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
936: (select rt_media_item_id from iem_rt_media_items
937: where rt_interaction_id = l_rt_interaction_id);
938:
939: else
940:

Line 942: from iem_rt_media_items

938:
939: else
940:
941: select message_id into l_message_id
942: from iem_rt_media_items
943: where rt_media_item_id = p_rt_media_item_ids(i).num and email_type = 'I';
944:
945: update iem_rt_media_items set expire = G_ACTIVE, status = 'U'
946: where rt_interaction_id = l_rt_interaction_id and expire <> 'D';

Line 945: update iem_rt_media_items set expire = G_ACTIVE, status = 'U'

941: select message_id into l_message_id
942: from iem_rt_media_items
943: where rt_media_item_id = p_rt_media_item_ids(i).num and email_type = 'I';
944:
945: update iem_rt_media_items set expire = G_ACTIVE, status = 'U'
946: where rt_interaction_id = l_rt_interaction_id and expire <> 'D';
947:
948: if ( l_message_id > 0 ) then
949: update iem_rt_media_items set expire = G_EXPIRE

Line 949: update iem_rt_media_items set expire = G_EXPIRE

945: update iem_rt_media_items set expire = G_ACTIVE, status = 'U'
946: where rt_interaction_id = l_rt_interaction_id and expire <> 'D';
947:
948: if ( l_message_id > 0 ) then
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

Line 963: (select rt_media_item_id from iem_rt_media_items

959: end if;
960:
961: update iem_outbox_errors set expire = G_EXPIRE
962: where rt_media_item_id in
963: (select rt_media_item_id from iem_rt_media_items
964: where rt_interaction_id = l_rt_interaction_id);
965:
966: end if; -- message not auto-replied
967: end loop;