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_AGENT_INBOX_MGMT_PVT dependencies on IEM_RT_PROC_EMAILS

Line 53: l_message_id iem_rt_proc_emails.message_id%type;

49:
50: l_index number := 1;
51: l_count number;
52:
53: l_message_id iem_rt_proc_emails.message_id%type;
54: l_email_account_id iem_rt_proc_emails.email_account_id%type;
55: l_sender_name iem_rt_proc_emails.from_address%type;
56: l_subject iem_rt_proc_emails.subject%type;
57: l_classification_name iem_route_classifications.name%type;

Line 54: l_email_account_id iem_rt_proc_emails.email_account_id%type;

50: l_index number := 1;
51: l_count number;
52:
53: l_message_id iem_rt_proc_emails.message_id%type;
54: l_email_account_id iem_rt_proc_emails.email_account_id%type;
55: l_sender_name iem_rt_proc_emails.from_address%type;
56: l_subject iem_rt_proc_emails.subject%type;
57: l_classification_name iem_route_classifications.name%type;
58: l_customer_name hz_parties.party_name%type;

Line 55: l_sender_name iem_rt_proc_emails.from_address%type;

51: l_count number;
52:
53: l_message_id iem_rt_proc_emails.message_id%type;
54: l_email_account_id iem_rt_proc_emails.email_account_id%type;
55: l_sender_name iem_rt_proc_emails.from_address%type;
56: l_subject iem_rt_proc_emails.subject%type;
57: l_classification_name iem_route_classifications.name%type;
58: l_customer_name hz_parties.party_name%type;
59: l_received_date varchar2(500);

Line 56: l_subject iem_rt_proc_emails.subject%type;

52:
53: l_message_id iem_rt_proc_emails.message_id%type;
54: l_email_account_id iem_rt_proc_emails.email_account_id%type;
55: l_sender_name iem_rt_proc_emails.from_address%type;
56: l_subject iem_rt_proc_emails.subject%type;
57: l_classification_name iem_route_classifications.name%type;
58: l_customer_name hz_parties.party_name%type;
59: l_received_date varchar2(500);
60: l_real_received_date iem_rt_proc_emails.received_date%type;

Line 60: l_real_received_date iem_rt_proc_emails.received_date%type;

56: l_subject iem_rt_proc_emails.subject%type;
57: l_classification_name iem_route_classifications.name%type;
58: l_customer_name hz_parties.party_name%type;
59: l_received_date varchar2(500);
60: l_real_received_date iem_rt_proc_emails.received_date%type;
61: l_message_uid iem_rt_proc_emails.message_id%type;
62: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
63: l_rt_media_item_id iem_rt_media_items.rt_media_item_id%type;
64: l_agent_id iem_rt_proc_emails.resource_id%type;

Line 61: l_message_uid iem_rt_proc_emails.message_id%type;

57: l_classification_name iem_route_classifications.name%type;
58: l_customer_name hz_parties.party_name%type;
59: l_received_date varchar2(500);
60: l_real_received_date iem_rt_proc_emails.received_date%type;
61: l_message_uid iem_rt_proc_emails.message_id%type;
62: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
63: l_rt_media_item_id iem_rt_media_items.rt_media_item_id%type;
64: l_agent_id iem_rt_proc_emails.resource_id%type;
65:

Line 64: l_agent_id iem_rt_proc_emails.resource_id%type;

60: l_real_received_date iem_rt_proc_emails.received_date%type;
61: l_message_uid iem_rt_proc_emails.message_id%type;
62: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
63: l_rt_media_item_id iem_rt_media_items.rt_media_item_id%type;
64: l_agent_id iem_rt_proc_emails.resource_id%type;
65:
66: l_cursorID INTEGER;
67: l_dummy INTEGER;
68: BEGIN

Line 137: from iem_rt_proc_emails a, iem_route_classifications b, hz_parties c, jtf_rs_resource_extns_vl d, iem_rt_media_items e

133: l_query_string1 := 'select a.message_id, a.email_account_id, a.from_address, a.subject, b.name as classification_name,
134: c.party_name as customer_name,
135: to_char(a.received_date, ''MM/DD/RRRR HH24:MI:SS'') as received_date, a.received_date as real_received_date, a.message_id,
136: d.resource_name, e.rt_media_item_id, a.resource_id
137: from iem_rt_proc_emails a, iem_route_classifications b, hz_parties c, jtf_rs_resource_extns_vl d, iem_rt_media_items e
138: where a.resource_id <> 0 and a.message_id=e.message_id and e.expire=''N'' and a.email_account_id=:email_account_id
139: and a.rt_classification_id=b.route_classification_id and a.customer_id=c.party_id and a.resource_id=d.resource_id ';
140:
141: l_customer_string2 := ' and UPPER(c.party_name) like UPPER(:customer_name)';

Line 150: from iem_rt_proc_emails a, iem_route_classifications b, jtf_rs_resource_extns_vl d, iem_rt_media_items e

146: l_query_string1 := 'select a.message_id, a.email_account_id, a.from_address, a.subject, b.name as classification_name,
147: decode(a.customer_id, -1, '''', 0, '''', (select party_name from hz_parties where party_id=a.customer_id) ) as customer_name,
148: to_char(a.received_date, ''MM/DD/RRRR HH24:MI:SS'') as received_date, a.received_date as real_received_date, a.message_id, d.resource_name,
149: e.rt_media_item_id, a.resource_id
150: from iem_rt_proc_emails a, iem_route_classifications b, jtf_rs_resource_extns_vl d, iem_rt_media_items e
151: where a.resource_id <> 0 and a.message_id=e.message_id and e.expire=''N'' and a.email_account_id=:email_account_id
152: and a.rt_classification_id=b.route_classification_id and a.resource_id=d.resource_id ';
153: end if;
154:

Line 400: from iem_rt_proc_emails a, iem_route_classifications b, hz_parties c, jtf_rs_resource_extns_vl d, iem_rt_media_items e

396:
397: if (p_customer_name is not null) then
398:
399: l_query_string1 := 'select count(*)
400: from iem_rt_proc_emails a, iem_route_classifications b, hz_parties c, jtf_rs_resource_extns_vl d, iem_rt_media_items e
401: where a.resource_id <> 0 and a.message_id=e.message_id and e.expire=''N'' and a.email_account_id=:email_account_id
402: and a.rt_classification_id=b.route_classification_id and a.customer_id=c.party_id and a.resource_id=d.resource_id ';
403:
404: l_customer_string2 := ' and UPPER(c.party_name) like UPPER(:customer_name)';

Line 410: from iem_rt_proc_emails a, iem_route_classifications b, jtf_rs_resource_extns_vl d, iem_rt_media_items e

406:
407: else
408:
409: l_query_string1 := 'select count(*)
410: from iem_rt_proc_emails a, iem_route_classifications b, jtf_rs_resource_extns_vl d, iem_rt_media_items e
411: where a.resource_id <> 0 and a.message_id=e.message_id and e.expire=''N'' and a.email_account_id=:email_account_id
412: and a.rt_classification_id=b.route_classification_id and a.resource_id=d.resource_id ';
413: end if;
414:

Line 706: select count(*) into l_fetched_emails from iem_rt_proc_emails a

702: DBMS_SQL.COLUMN_VALUE(l_cursorID, 2, l_resource_name);
703: DBMS_SQL.COLUMN_VALUE(l_cursorID, 3, l_last_login_time);
704: DBMS_SQL.COLUMN_VALUE(l_cursorID, 4, l_real_last_login_time);
705:
706: select count(*) into l_fetched_emails from iem_rt_proc_emails a
707: where a.email_account_id=p_email_account_id and a.queue_status is null and resource_id = l_resource_id;
708:
709: x_resource_count(l_index).resource_id :=l_resource_id;
710: x_resource_count(l_index).resource_name := l_resource_name;

Line 737: from IEM_AGENTS agact, iem_rt_proc_emails pm,

733: end if;
734:
735: l_string1 := 'select resource_id, fetched_emails, resource_name from
736: ( SELECT agact.resource_id, count(*) fetched_emails, concat(concat(rs.source_last_name, '',''), rs.source_first_name) as resource_name
737: from IEM_AGENTS agact, iem_rt_proc_emails pm,
738: jtf_rs_resource_extns rs, fnd_responsibility resp,fnd_user_resp_groups respgrp, fnd_user fu
739: WHERE pm.resource_id=agact.resource_id
740: and agact.resource_id = rs.resource_id and rs.user_id=respgrp.user_id and respgrp.user_id=fu.user_id
741: and pm.email_account_id=agact.email_account_id and pm.queue_status is null

Line 776: l_string3 := ' and agact.resource_id not in (select pm.resource_id from iem_rt_proc_emails pm where pm.email_account_id=:email_account_id and pm.queue_status is null) ) ';

772: and rel.role_resource_type = ''RS_INDIVIDUAL''
773: and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
774: and trunc(nvl(rel.end_date_active, sysdate)) ) ';
775:
776: l_string3 := ' and agact.resource_id not in (select pm.resource_id from iem_rt_proc_emails pm where pm.email_account_id=:email_account_id and pm.queue_status is null) ) ';
777:
778: if (p_transferrer_id <> -1) then
779: -- l_string11 := ' and agact.resource_id <> ' || p_transferrer_id;
780: l_string11 := ' and agact.resource_id <> :transferrer_id ';