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

Line 61: l_email_data_rec IEM_RT_PROC_EMAILS%ROWTYPE;

57: l_created_by NUMBER;
58: l_last_updated_by NUMBER;
59: l_last_update_login NUMBER;
60:
61: l_email_data_rec IEM_RT_PROC_EMAILS%ROWTYPE;
62: l_status VARCHAR2(300);
63: l_msg_count NUMBER;
64: l_msg_data VARCHAR2(300);
65:

Line 237: -- open the row at IEM_RT_PROC_EMAILS

233: G_INBOUND, G_UNMOVED, G_ACTIVE,0, l_created_by, SYSDATE,
234: l_last_updated_by, SYSDATE, l_last_update_login
235: );
236:
237: -- open the row at IEM_RT_PROC_EMAILS
238: UPDATE IEM_RT_PROC_EMAILS SET queue_status = NULL
239: WHERE message_id = l_email_data_rec.MESSAGE_ID;
240:
241: -- Return Media Values to the JSPs.

Line 238: UPDATE IEM_RT_PROC_EMAILS SET queue_status = NULL

234: l_last_updated_by, SYSDATE, l_last_update_login
235: );
236:
237: -- open the row at IEM_RT_PROC_EMAILS
238: UPDATE IEM_RT_PROC_EMAILS SET queue_status = NULL
239: WHERE message_id = l_email_data_rec.MESSAGE_ID;
240:
241: -- Return Media Values to the JSPs.
242: x_rt_media_item_id := l_m_sequence;

Line 332: x_message_id OUT NOCOPY NUMBER, -- change to iem_rt_proc_emails.message_id since 11.5.11

328: x_rt_media_item_id OUT NOCOPY NUMBER,
329: x_rt_interaction_id OUT NOCOPY NUMBER,
330: x_oes_id OUT NOCOPY NUMBER,
331: x_folder_name OUT NOCOPY VARCHAR2,
332: x_message_id OUT NOCOPY NUMBER, -- change to iem_rt_proc_emails.message_id since 11.5.11
333: x_customer_id OUT NOCOPY NUMBER,
334: x_interaction_id OUT NOCOPY NUMBER,
335: x_service_request_id OUT NOCOPY NUMBER,
336: x_mc_parameter_id OUT NOCOPY NUMBER,

Line 688: FROM IEM_RT_PROC_EMAILS

684: FROM iem_rt_interactions
685: WHERE rt_interaction_id = x_rt_interaction_id;
686:
687: SELECT rt_classification_id into x_route_classification_id
688: FROM IEM_RT_PROC_EMAILS
689: WHERE message_id = x_mdt_message_id;
690:
691: SELECT name into x_route_classification
692: FROM iem_route_classifications

Line 1389: -- Update IEM_RT_PROC_EMAILS mail_item_status to 'S' for 'Saved' inbound

1385: raise badAccountType;
1386: end if;
1387:
1388:
1389: -- Update IEM_RT_PROC_EMAILS mail_item_status to 'S' for 'Saved' inbound
1390: if (p_status = 'V') then
1391:
1392: if ( l_email_type = G_OUTBOUND ) then
1393: SELECT message_id

Line 1400: UPDATE IEM_RT_PROC_EMAILS SET mail_item_status = 'S' where message_id = l_msg_id;

1396: WHERE rt_interaction_id = l_rt_interaction_id
1397: AND email_type = G_INBOUND;
1398: end if;
1399:
1400: UPDATE IEM_RT_PROC_EMAILS SET mail_item_status = 'S' where message_id = l_msg_id;
1401: end if;
1402:
1403: -- Add email_open mlcs if it is an 'assign' or 'transfer' or 'autoroute'
1404: if (((l_rt_status = 'R') OR (l_rt_status = 'G') OR (l_rt_status = 'O')) AND

Line 1426: -- Update IEM_RT_PROC_EMAILS mail_item_status to 'R' for 'Read'

1422: x_msg_data => l_msg_data,
1423: x_milcs_id => x_milcs_id,
1424: p_media_lc_rec => l_media_lc_rec);
1425:
1426: -- Update IEM_RT_PROC_EMAILS mail_item_status to 'R' for 'Read'
1427: UPDATE IEM_RT_PROC_EMAILS SET mail_item_status = 'R' where message_id = l_msg_id;
1428:
1429: l_uwq_act_code := 'EMAIL_OPENED';
1430:

Line 1427: UPDATE IEM_RT_PROC_EMAILS SET mail_item_status = 'R' where message_id = l_msg_id;

1423: x_milcs_id => x_milcs_id,
1424: p_media_lc_rec => l_media_lc_rec);
1425:
1426: -- Update IEM_RT_PROC_EMAILS mail_item_status to 'R' for 'Read'
1427: UPDATE IEM_RT_PROC_EMAILS SET mail_item_status = 'R' where message_id = l_msg_id;
1428:
1429: l_uwq_act_code := 'EMAIL_OPENED';
1430:
1431: else

Line 1463: -- Update IEM_RT_PROC_EMAILS mail_item_status to 'R' for 'Read'

1459: x_msg_data => l_msg_data,
1460: x_milcs_id => x_milcs_id,
1461: p_media_lc_rec => l_media_lc_rec);
1462:
1463: -- Update IEM_RT_PROC_EMAILS mail_item_status to 'R' for 'Read'
1464: UPDATE IEM_RT_PROC_EMAILS SET mail_item_status = 'R' where message_id = l_msg_id;
1465:
1466: l_uwq_act_code := 'EMAIL_FETCHED';
1467:

Line 1464: UPDATE IEM_RT_PROC_EMAILS SET mail_item_status = 'R' where message_id = l_msg_id;

1460: x_milcs_id => x_milcs_id,
1461: p_media_lc_rec => l_media_lc_rec);
1462:
1463: -- Update IEM_RT_PROC_EMAILS mail_item_status to 'R' for 'Read'
1464: UPDATE IEM_RT_PROC_EMAILS SET mail_item_status = 'R' where message_id = l_msg_id;
1465:
1466: l_uwq_act_code := 'EMAIL_FETCHED';
1467:
1468: end if;

Line 2789: update IEM_RT_PROC_EMAILS set queue_status = null

2785:
2786: -- Reset queue_status to null is not really needed for once its
2787: -- agent id set to 0, queue_status is disregarded. But just play safe.
2788: if ( (UPPER(p_action) = 'X') AND (m_reroute_type = 76) ) then
2789: update IEM_RT_PROC_EMAILS set queue_status = null
2790: where message_id = l_mdt_message_id;
2791: end if;
2792: end;
2793: ELSIF (UPPER(p_action) = 'T') THEN

Line 2875: UPDATE IEM_RT_PROC_EMAILS

2871: WHERE rt_interaction_id = l_rt_interaction_id;
2872:
2873: -- Update mdt. Set the new owner of mailItem and from_agent_id and status
2874: -- and open queue_status.
2875: UPDATE IEM_RT_PROC_EMAILS
2876: SET resource_id = p_to_resource_id,
2877: from_resource_id = l_reroute_resource_id,
2878: mail_item_status = 'T',
2879: queue_status = null,

Line 3653: l_email_data_rec IEM_RT_PROC_EMAILS%ROWTYPE;

3649: l_created_by NUMBER;
3650: l_last_updated_by NUMBER;
3651: l_last_update_login NUMBER;
3652:
3653: l_email_data_rec IEM_RT_PROC_EMAILS%ROWTYPE;
3654: l_status VARCHAR2(300);
3655: l_msg_count NUMBER;
3656: l_msg_data VARCHAR2(300);
3657:

Line 3725: --Update IEM_RT_PROC_EMAILS with to_agent_id, from_agent_id and status 'A'

3721: else
3722: l_mail_item_status := 'A';
3723: end if;
3724:
3725: --Update IEM_RT_PROC_EMAILS with to_agent_id, from_agent_id and status 'A'
3726: IEM_MAILITEM_PUB.GetQueueItemData (p_api_version_number => 1.0,
3727: p_init_msg_list => 'F',
3728: p_commit => 'F',
3729: p_message_id => p_message_id,

Line 3793: from iem_mstemail_accounts acct, iem_rt_proc_emails proc

3789:
3790: -- Employee Search. shramana
3791: select acct.account_type
3792: into l_acct_type
3793: from iem_mstemail_accounts acct, iem_rt_proc_emails proc
3794: where proc.message_id = p_message_id
3795: and acct.email_account_id = proc.email_account_id;
3796:
3797: if(l_acct_type = 'I') then

Line 3847: UPDATE IEM_RT_PROC_EMAILS SET queue_status = NULL WHERE message_id = p_message_id;

3843: l_last_updated_by, SYSDATE, l_last_update_login
3844: );
3845:
3846: -- update post_mdts to set queue_status to null in case it is not clear
3847: UPDATE IEM_RT_PROC_EMAILS SET queue_status = NULL WHERE message_id = p_message_id;
3848:
3849:
3850: --Add MLCS 'email assigned' using to_resource_id and 'email_assign' using resource_id
3851: if ( l_mail_item_status = 'A' ) then

Line 4100: UPDATE IEM_RT_PROC_EMAILS SET queue_status = 'Q'

4096: AND expire = G_ACTIVE;
4097:
4098: -- mark the post_mdts to 'Q' to prevent this from considered by getmailitemcount().
4099: if ( l_message_id is not null ) then
4100: UPDATE IEM_RT_PROC_EMAILS SET queue_status = 'Q'
4101: WHERE message_id = l_message_id;
4102: end if;
4103:
4104: END IF;

Line 4473: p_message_id IN NUMBER, -- IEM_RT_PROC_EMAILS.message_id

4469:
4470: PROCEDURE createRTItem (p_api_version_number IN NUMBER,
4471: p_init_msg_list IN VARCHAR2,
4472: p_commit IN VARCHAR2,
4473: p_message_id IN NUMBER, -- IEM_RT_PROC_EMAILS.message_id
4474: p_to_resource_id IN NUMBER, -- agent id you want to stamp to IEM_RT_PROC_EMAILS.agent_id
4475: p_from_resource_id IN NUMBER, -- agent id you want to stamp to IEM_RT_PROC_EMAILS.from_agent_id
4476: p_status IN VARCHAR2, -- this will be stamp to IEM_RT_PROC_EMAILS.mail_item_status
4477: p_reason IN VARCHAR2, -- 'O' for auto-route

Line 4474: p_to_resource_id IN NUMBER, -- agent id you want to stamp to IEM_RT_PROC_EMAILS.agent_id

4470: PROCEDURE createRTItem (p_api_version_number IN NUMBER,
4471: p_init_msg_list IN VARCHAR2,
4472: p_commit IN VARCHAR2,
4473: p_message_id IN NUMBER, -- IEM_RT_PROC_EMAILS.message_id
4474: p_to_resource_id IN NUMBER, -- agent id you want to stamp to IEM_RT_PROC_EMAILS.agent_id
4475: p_from_resource_id IN NUMBER, -- agent id you want to stamp to IEM_RT_PROC_EMAILS.from_agent_id
4476: p_status IN VARCHAR2, -- this will be stamp to IEM_RT_PROC_EMAILS.mail_item_status
4477: p_reason IN VARCHAR2, -- 'O' for auto-route
4478: p_interaction_id IN NUMBER,

Line 4475: p_from_resource_id IN NUMBER, -- agent id you want to stamp to IEM_RT_PROC_EMAILS.from_agent_id

4471: p_init_msg_list IN VARCHAR2,
4472: p_commit IN VARCHAR2,
4473: p_message_id IN NUMBER, -- IEM_RT_PROC_EMAILS.message_id
4474: p_to_resource_id IN NUMBER, -- agent id you want to stamp to IEM_RT_PROC_EMAILS.agent_id
4475: p_from_resource_id IN NUMBER, -- agent id you want to stamp to IEM_RT_PROC_EMAILS.from_agent_id
4476: p_status IN VARCHAR2, -- this will be stamp to IEM_RT_PROC_EMAILS.mail_item_status
4477: p_reason IN VARCHAR2, -- 'O' for auto-route
4478: p_interaction_id IN NUMBER,
4479: x_return_status OUT NOCOPY VARCHAR2,

Line 4476: p_status IN VARCHAR2, -- this will be stamp to IEM_RT_PROC_EMAILS.mail_item_status

4472: p_commit IN VARCHAR2,
4473: p_message_id IN NUMBER, -- IEM_RT_PROC_EMAILS.message_id
4474: p_to_resource_id IN NUMBER, -- agent id you want to stamp to IEM_RT_PROC_EMAILS.agent_id
4475: p_from_resource_id IN NUMBER, -- agent id you want to stamp to IEM_RT_PROC_EMAILS.from_agent_id
4476: p_status IN VARCHAR2, -- this will be stamp to IEM_RT_PROC_EMAILS.mail_item_status
4477: p_reason IN VARCHAR2, -- 'O' for auto-route
4478: p_interaction_id IN NUMBER,
4479: x_return_status OUT NOCOPY VARCHAR2,
4480: x_msg_count OUT NOCOPY NUMBER,

Line 4492: l_email_data_rec IEM_RT_PROC_EMAILS%ROWTYPE;

4488: l_created_by NUMBER;
4489: l_last_updated_by NUMBER;
4490: l_last_update_login NUMBER;
4491:
4492: l_email_data_rec IEM_RT_PROC_EMAILS%ROWTYPE;
4493: l_status VARCHAR2(300);
4494: l_msg_count NUMBER;
4495: l_msg_data VARCHAR2(300);
4496:

Line 4548: -- Update IEM_RT_PROC_EMAILS with to_agent_id, from_agent_id and p_status

4544: x_return_status := FND_API.G_RET_STS_SUCCESS;
4545:
4546: -----------------------Code------------------------
4547:
4548: -- Update IEM_RT_PROC_EMAILS with to_agent_id, from_agent_id and p_status
4549: IEM_MAILITEM_PUB.GetQueueItemData (p_api_version_number => 1.0,
4550: p_init_msg_list => 'F',
4551: p_commit => 'F',
4552: p_message_id => p_message_id,