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

Line 21: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,

17: CURSOR c1 IS
18: SELECT a.EMAIL_ACCOUNT_ID,a.RT_CLASSIFICATION_ID,
19: b.USER_NAME,c.name,count(*) Total,
20: nvl(max(sysdate-a.received_date)*24*60,0) wait_time
21: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,
22: iem_route_classifications c,iem_agents d
23: WHERE a.resource_id=0
24: and a.email_account_id=b.email_account_id
25: and a.rt_classification_id=c.route_classification_id

Line 35: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,

31: CURSOR c_11 IS
32: SELECT a.EMAIL_ACCOUNT_ID,a.RT_CLASSIFICATION_ID,
33: b.USER_NAME,c.name,count(*) Total,
34: nvl(max(sysdate-a.received_date)*24*60,0) wait_time
35: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,
36: iem_route_classifications c,iem_agents d
37: WHERE a.resource_id=0
38: and a.email_account_id=b.email_account_id
39: and a.rt_classification_id=c.route_classification_id

Line 52: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,

48: select a.email_account_id,a.rt_classification_id,
49: b.USER_NAME,c.name,Count(*) Total,
50: nvl(max(sysdate-a.received_date)*24*60,0) wait_time,
51: max(decode(a.mail_item_status,'A',1,'N',1,'T',1,0)) email_status
52: FROM iem_rt_proc_emails a,iem_mstemail_accounts b,
53: iem_route_classifications c
54: WHERE a.resource_id=p_resource_id
55: and a.email_account_id=b.email_account_id
56: and a.rt_classification_id=c.route_classification_id

Line 240: FROM iem_rt_proc_emails a,iem_route_classifications b

236: l_tbl t_number_table:=t_number_table();
237: i_tbl jtf_number_table:=jtf_number_table();
238: CURSOR c1 IS
239: SELECT a.RT_CLASSIFICATION_ID,b.name,COUNT(*) TOTAL
240: FROM iem_rt_proc_emails a,iem_route_classifications b
241: where a.email_account_id=p_email_account_id
242: and a.resource_id =0
243: and a.rt_classification_id=b.route_classification_id
244: AND a.group_id in (select * from TABLE(cast(i_tbl as jtf_number_table)))

Line 368: from iem_rt_proc_emails a,iem_route_classifications b

364: x_msg_data OUT NOCOPY VARCHAR2)
365:
366: IS
367: cursor c2 is select a.rt_classification_id,b.name,count(*) total
368: from iem_rt_proc_emails a,iem_route_classifications b
369: where a.email_account_id=p_email_account_id
370: and a.resource_id=0
371: and a.rt_classification_id=b.route_classification_id
372: group by rt_classification_id,b.name;

Line 513: from iem_rt_proc_emails

509: i_tbl(j):=l_tbl(j);
510: END LOOP;
511: select COUNT(*)
512: INTO x_count
513: from iem_rt_proc_emails
514: where email_account_id=p_email_account_id
515: and rt_classification_id=p_classification_id
516: and resource_id=0
517: and group_id in (select * from TABLE(cast(i_tbl as jtf_number_table)));

Line 578: x_email_data out NOCOPY iem_rt_proc_emails%rowtype,

574: p_resource_id in number,
575: p_tbl in t_number_table:=NULL,
576: p_rt_classification in number,
577: p_account_id in number,
578: x_email_data out NOCOPY iem_rt_proc_emails%rowtype,
579: x_tag_key_value OUT NOCOPY keyVals_tbl_type,
580: x_encrypted_id OUT NOCOPY VARCHAR2,
581: x_return_status OUT NOCOPY VARCHAR2,
582: x_msg_count OUT NOCOPY NUMBER,

Line 620: 'select /FIRST_ROWS/ * from iem_rt_proc_emails p where message_id not in (select message_id from iem_reroute_hists where resource_id=:res1 ) and email_account_id=:id

616: x_return_status := FND_API.G_RET_STS_SUCCESS;
617: IF (p_tbl is null) and (nvl(p_account_id,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) and
618: (nvl(p_rt_classification,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) THEN
619: OPEN email_dtl_cur FOR
620: 'select /*FIRST_ROWS*/ * from iem_rt_proc_emails p where message_id not in (select message_id from iem_reroute_hists where resource_id=:res1 ) and email_account_id=:id
621: and rt_classification_id=:rt
622: and resource_id=0
623: and ( p.group_id = 0
624: or exists (

Line 647: 'select /FIRST_ROWS/ * from iem_rt_proc_emails p where message_id not in (select message_id from iem_reroute_hists where resource_id=:res1 ) and email_account_id=:id

643: END LOOP;
644: close email_dtl_cur;
645: ELSE
646: OPEN email_dtl_cur FOR
647: 'select /*FIRST_ROWS*/ * from iem_rt_proc_emails p where message_id not in (select message_id from iem_reroute_hists where resource_id=:res1 ) and email_account_id=:id
648: and resource_id=0
649: and ( p.group_id = 0
650: or exists (
651: select null

Line 692: UPDATE iem_rt_proc_emails

688: x_tag_key_value(l_index).datatype:=l_tag_key_value(i).datatype;
689: l_index:=l_index+1;
690: END LOOP;
691: END IF;
692: UPDATE iem_rt_proc_emails
693: set resource_id=p_resource_id,
694: queue_status='G'
695: where message_id=x_email_data.message_id ;
696: IF x_email_data.ih_interaction_id is not null then -- updating interaction with resource id

Line 792: FROM iem_rt_proc_emails

788: SAVEPOINT dispose_mail_item_PVT;
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790: BEGIN -- Close the Media Item
791: SELECT IH_MEDIA_ITEM_ID into l_media_id
792: FROM iem_rt_proc_emails
793: WHERE MESSAGE_ID=p_message_id;
794: SELECT * into l_media_data
795: FROM JTF_IH_MEDIA_ITEMS
796: WHERE MEDIA_ID=l_media_id;

Line 818: DELETE FROM iem_rt_proc_emails

814: l_media_rec);
815: EXCEPTION WHEN OTHERS THEN
816: NULL;
817: END ;
818: DELETE FROM iem_rt_proc_emails
819: WHERE MESSAGE_ID=p_message_id;
820: delete from iem_reroute_hists
821: where message_id=p_message_id;
822: delete from iem_kb_results where message_id=p_message_id;

Line 955: p_email_data in iem_rt_proc_emails%rowtype,

951:
952: PROCEDURE UpdateMailItem (p_api_version_number IN NUMBER,
953: p_init_msg_list IN VARCHAR2 ,
954: p_commit IN VARCHAR2 ,
955: p_email_data in iem_rt_proc_emails%rowtype,
956: x_return_status OUT NOCOPY VARCHAR2,
957: x_msg_count OUT NOCOPY NUMBER,
958: x_msg_data OUT NOCOPY VARCHAR2) IS
959:

Line 977: UPDATE iem_rt_proc_emails

973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975: SAVEPOINT update_item_PVT;
976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977: UPDATE iem_rt_proc_emails
978: SET
979: resource_id =p_email_data.resource_id,
980: PRIORITY =p_email_data.priority,
981: MSG_STATUS =p_email_data.msg_status,

Line 1057: x_email_data out NOCOPY iem_rt_proc_emails%rowtype,

1053: p_commit IN VARCHAR2 ,
1054: p_message_id in number,
1055: p_account_id in number,
1056: p_agent_id in number,
1057: x_email_data out NOCOPY iem_rt_proc_emails%rowtype,
1058: x_return_status OUT NOCOPY VARCHAR2,
1059: x_msg_count OUT NOCOPY NUMBER,
1060: x_msg_data OUT NOCOPY VARCHAR2) IS
1061:

Line 1079: FROM iem_rt_proc_emails

1075: IF p_agent_id<>0 THEN -- Not a supervisor mode
1076: BEGIN
1077: SELECT *
1078: INTO x_email_data
1079: FROM iem_rt_proc_emails
1080: WHERE message_id=p_message_id;
1081: EXCEPTION WHEN NO_DATA_FOUND THEN
1082: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
1083: FND_MSG_PUB.ADD;

Line 1091: FROM iem_rt_proc_emails

1087: ELSE -- Supervisor Mode
1088: BEGIN
1089: SELECT *
1090: INTO x_email_data
1091: FROM iem_rt_proc_emails
1092: WHERE message_id=p_message_id;
1093: EXCEPTION WHEN NO_DATA_FOUND THEN
1094: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
1095: FND_MSG_PUB.ADD;

Line 1204: FROM iem_rt_proc_emails a,

1200: to_char(to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS''),''MM/DD/RRRR HH24:MI:SS''),a.mail_item_status,
1201: -- to_char(to_date(substr(a.sent_Date,5,length(a.sent_Date)-13)||substr(a.sent_date,25,4),''Mon DD hh24:mi:ssyyyy''),''MM/DD/RRRR HH24:MI:SS''),a.mail_item_status,
1202: a.from_resource_id,
1203: decode(a.mail_item_status,''R'',1,''S'',1,0) read_status,d.description
1204: FROM iem_rt_proc_emails a,
1205: IEM_RT_MEDIA_ITEMS b,
1206: IEM_ROUTE_CLASSIFICATIONS c,
1207: FND_LOOKUPS d
1208: WHERE A.RT_CLASSIFICATION_ID=C.ROUTE_CLASSIFICATION_ID AND B.EXPIRE=:expire AND A.MESSAGE_ID=B.MESSAGE_ID and a.resource_id=:id and a.email_account_id=:account_id and

Line 1287: x_email_data out NOCOPY iem_rt_proc_emails%rowtype,

1283: p_message_id in number,
1284: p_from_agent_id in number,
1285: p_to_agent_id in number,
1286: p_mail_item_status in varchar2,
1287: x_email_data out NOCOPY iem_rt_proc_emails%rowtype,
1288: x_tag_key_value OUT NOCOPY keyVals_tbl_type,
1289: x_encrypted_id OUT NOCOPY VARCHAR2,
1290: x_return_status OUT NOCOPY VARCHAR2,
1291: x_msg_count OUT NOCOPY NUMBER,

Line 1313: FROM iem_rt_proc_emails

1309: END IF;
1310: SAVEPOINT select_data_PVT;
1311: x_return_status := FND_API.G_RET_STS_SUCCESS;
1312: SELECT * INTO x_email_data
1313: FROM iem_rt_proc_emails
1314: WHERE message_id=p_message_id
1315: AND resource_id=0 for update;
1316: update iem_rt_proc_emails
1317: set from_resource_id=p_from_agent_id,

Line 1316: update iem_rt_proc_emails

1312: SELECT * INTO x_email_data
1313: FROM iem_rt_proc_emails
1314: WHERE message_id=p_message_id
1315: AND resource_id=0 for update;
1316: update iem_rt_proc_emails
1317: set from_resource_id=p_from_agent_id,
1318: resource_id=p_to_agent_id,
1319: mail_item_status=p_mail_item_status
1320: where message_id=p_message_id;

Line 1392: x_email_data out NOCOPY iem_rt_proc_emails%rowtype,

1388: p_resource_id in number,
1389: p_tbl in t_number_table:=NULL,
1390: p_rt_classification in number,
1391: p_account_id in number,
1392: x_email_data out NOCOPY iem_rt_proc_emails%rowtype,
1393: x_return_status OUT NOCOPY VARCHAR2,
1394: x_msg_count OUT NOCOPY NUMBER,
1395: x_msg_data OUT NOCOPY VARCHAR2) IS
1396: begin

Line 1405: x_email_data out NOCOPY iem_rt_proc_emails%rowtype,

1401: p_init_msg_list IN VARCHAR2 ,
1402: p_commit IN VARCHAR2 ,
1403: p_resource_id in number,
1404: p_acct_rt_class_id in number,
1405: x_email_data out NOCOPY iem_rt_proc_emails%rowtype,
1406: x_return_status OUT NOCOPY VARCHAR2,
1407: x_msg_count OUT NOCOPY NUMBER,
1408: x_msg_data OUT NOCOPY VARCHAR2) IS
1409: begin

Line 1420: l_msg_rec iem_rt_proc_emails%rowtype;

1416: p_action_flag in varchar2,
1417: x_return_status OUT NOCOPY VARCHAR2,
1418: x_msg_count OUT NOCOPY NUMBER,
1419: x_msg_data OUT NOCOPY VARCHAR2) IS
1420: l_msg_rec iem_rt_proc_emails%rowtype;
1421: l_header_rec iem_ms_base_headers%rowtype;
1422: l_msg_text iem_ms_msgbodys.value%type;
1423: l_ret_status varchar2(10);
1424: l_msg_data varchar2(1000);

Line 1450: select * into l_msg_rec from iem_rt_proc_emails

1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: END IF;
1448: SAVEPOINT select_data_PVT;
1449: x_return_status := FND_API.G_RET_STS_SUCCESS;
1450: select * into l_msg_rec from iem_rt_proc_emails
1451: where message_id=p_message_id;
1452: -- Close The Media Item
1453: BEGIN
1454: SELECT * into l_media_data

Line 1537: delete from iem_rt_proc_emails where message_id=p_message_id;

1533: IF l_ret_status<>'S' THEN
1534: raise insert_arch_dtl_error;
1535: END IF;
1536: -- Delete All RUN TIME DATA and MESSAGE DATA FROM PRIMARY STORE
1537: delete from iem_rt_proc_emails where message_id=p_message_id;
1538: delete from iem_email_classifications where message_id=p_message_id;
1539: delete from iem_kb_results where message_id=p_message_id;
1540: delete from iem_ms_base_headers where message_id=p_message_id;
1541: delete from iem_ms_msgbodys where message_id=p_message_id;