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 2746: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;

2742: select agent_id into l_tran_to_acct_id from iem_agents
2743: where resource_id = p_to_resource_id
2744: and email_account_id = l_email_account_id;
2745:
2746: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
2747: INSERT INTO iem_rt_interactions (
2748: rt_interaction_id, resource_id, customer_id, type,
2749: status, expire, created_by, creation_date, last_updated_by,
2750: last_update_date, last_update_login, contact_id, inb_tag_id,

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

3728: if (l_email_data_rec.IH_INTERACTION_ID is not null) then
3729: l_ih_creator := 'Y';
3730: end if;
3731:
3732: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
3733: INSERT INTO iem_rt_interactions (
3734: rt_interaction_id, resource_id, customer_id, contact_id, type,
3735: status, expire, created_by, creation_date, last_updated_by,
3736: last_update_date, last_update_login, parent_interaction_id,

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

4540: l_ih_creator := null;
4541: if ( p_interaction_id is not null ) then
4542: l_ih_creator := 'Y';
4543: end if;
4544: select IEM_RT_INTERACTIONS_S1.nextval into l_i_sequence from DUAL;
4545: INSERT INTO iem_rt_interactions (
4546: rt_interaction_id, resource_id, customer_id, contact_id, type,
4547: status, expire, created_by, creation_date, last_updated_by,
4548: last_update_date, last_update_login, parent_interaction_id,