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_INTERACTIONS_S1

Line 199: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

195: if ( l_email_data_rec.IH_INTERACTION_ID is not null ) then
196: l_ih_creator := 'S'; -- server created
197: end if;
198:
199: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
200: INSERT INTO iem_rt_interactions (
201: rt_interaction_id, resource_id, customer_id, contact_id, type,
202: status, expire, created_by, creation_date, last_updated_by,
203: last_update_date, last_update_login, parent_interaction_id,

Line 1102: SELECT IEM_RT_INTERACTIONS_S1.nextval INTO l_i_sequence FROM DUAL;

1098: OR p_rt_media_item_id is null) THEN
1099:
1100: -- Pure outbound message as there is no associated rt_media_item_id.
1101: -- Insert into rt tables.
1102: SELECT IEM_RT_INTERACTIONS_S1.nextval INTO l_i_sequence FROM DUAL;
1103: INSERT INTO iem_rt_interactions (
1104: rt_interaction_id, resource_id, customer_id, type,
1105: status, expire, created_by, creation_date, last_updated_by,
1106: last_update_date, last_update_login, interaction_id,

Line 2808: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

2804: select agent_id into l_tran_to_acct_id from iem_agents
2805: where resource_id = p_to_resource_id
2806: and email_account_id = l_email_account_id;
2807:
2808: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
2809: INSERT INTO iem_rt_interactions (
2810: rt_interaction_id, resource_id, customer_id, type,
2811: status, expire, created_by, creation_date, last_updated_by,
2812: last_update_date, last_update_login, contact_id, inb_tag_id,

Line 3807: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

3803: if (l_email_data_rec.IH_INTERACTION_ID is not null) then
3804: l_ih_creator := 'Y';
3805: end if;
3806:
3807: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
3808: INSERT INTO iem_rt_interactions (
3809: rt_interaction_id, resource_id, customer_id, contact_id, type,
3810: status, expire, created_by, creation_date, last_updated_by,
3811: last_update_date, last_update_login, parent_interaction_id,

Line 4619: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

4615: l_ih_creator := null;
4616: if ( p_interaction_id is not null ) then
4617: l_ih_creator := 'Y';
4618: end if;
4619: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
4620: INSERT INTO iem_rt_interactions (
4621: rt_interaction_id, resource_id, customer_id, contact_id, type,
4622: status, expire, created_by, creation_date, last_updated_by,
4623: last_update_date, last_update_login, parent_interaction_id,