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 DUAL

Line 126: p_classification_id) into l_classification_id from DUAL;

122: --Future: Call Media Check [check if max interactions reached]
123:
124: --Set the l_classification_id to null if it is a NOP per 9i standard
125: select decode(p_classification_id,G_NUM_NOP2, null,
126: p_classification_id) into l_classification_id from DUAL;
127:
128: --Call MailItem to get the next available message.
129: IEM_MAILITEM_PUB.GetMailItem( p_api_version_number=> 1.0,
130: p_init_msg_list => 'F',

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 217: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;

213: );
214: -- db_server id used by mid-tier to locate accounts
215: l_db_server_id := -1;
216:
217: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
218: INSERT INTO iem_rt_media_items (
219: rt_interaction_id, rt_media_item_id, resource_id,
220: media_id, message_id, rfc822_message_id, folder_name,
221: folder_uid, email_account_id, db_server_id, email_type,

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 1126: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;

1122: decode(p_action_id, G_NUM_NOP, null, p_action_id),
1123: decode(p_relationship_id, G_NUM_NOP, null, p_relationship_id)
1124: );
1125:
1126: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
1127: INSERT INTO iem_rt_media_items (
1128: rt_interaction_id, rt_media_item_id, resource_id,
1129: media_id, message_id, rfc822_message_id, folder_name,
1130: folder_uid, email_account_id,agent_account_id,

Line 1160: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;

1156:
1157: IF (UPPER(l_email_type) = G_INBOUND) THEN
1158:
1159: -- Draft/Reply to an existing Inbound.
1160: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
1161: INSERT INTO iem_rt_media_items (
1162: rt_interaction_id, rt_media_item_id, resource_id,
1163: media_id, message_id, rfc822_message_id, folder_name,
1164: folder_uid, email_account_id,agent_account_id,

Line 1820: select decode(p_result_id,-1, NULL, p_result_id) into l_result_id from DUAL;

1816:
1817: -- Open IH
1818: IF (l_interaction_id IS NULL) THEN
1819:
1820: select decode(p_result_id,-1, NULL, p_result_id) into l_result_id from DUAL;
1821: select decode(p_reason_id,-1, NULL, p_reason_id) into l_reason_id from DUAL;
1822: if (l_parent_ih_id < 0) then
1823: l_parent_ih_id := null;
1824: end if;

Line 1821: select decode(p_reason_id,-1, NULL, p_reason_id) into l_reason_id from DUAL;

1817: -- Open IH
1818: IF (l_interaction_id IS NULL) THEN
1819:
1820: select decode(p_result_id,-1, NULL, p_result_id) into l_result_id from DUAL;
1821: select decode(p_reason_id,-1, NULL, p_reason_id) into l_reason_id from DUAL;
1822: if (l_parent_ih_id < 0) then
1823: l_parent_ih_id := null;
1824: end if;
1825:

Line 2220: select decode(p_activity_type_id,-1, NULL, p_activity_type_id) into l_activity_type_id from DUAL;

2216: if ( l_spv_resource_id > 0 ) then
2217: l_resource_id := l_spv_resource_id;
2218: end if;
2219:
2220: select decode(p_activity_type_id,-1, NULL, p_activity_type_id) into l_activity_type_id from DUAL;
2221: select decode(p_result_id,-1, NULL, p_result_id) into l_result_id from DUAL;
2222: select decode(p_reason_id,-1, NULL, p_reason_id) into l_reason_id from DUAL;
2223:
2224: IF (l_action_id < 0) THEN

Line 2221: select decode(p_result_id,-1, NULL, p_result_id) into l_result_id from DUAL;

2217: l_resource_id := l_spv_resource_id;
2218: end if;
2219:
2220: select decode(p_activity_type_id,-1, NULL, p_activity_type_id) into l_activity_type_id from DUAL;
2221: select decode(p_result_id,-1, NULL, p_result_id) into l_result_id from DUAL;
2222: select decode(p_reason_id,-1, NULL, p_reason_id) into l_reason_id from DUAL;
2223:
2224: IF (l_action_id < 0) THEN
2225: l_action_id := p_action_id;

Line 2222: select decode(p_reason_id,-1, NULL, p_reason_id) into l_reason_id from DUAL;

2218: end if;
2219:
2220: select decode(p_activity_type_id,-1, NULL, p_activity_type_id) into l_activity_type_id from DUAL;
2221: select decode(p_result_id,-1, NULL, p_result_id) into l_result_id from DUAL;
2222: select decode(p_reason_id,-1, NULL, p_reason_id) into l_reason_id from DUAL;
2223:
2224: IF (l_action_id < 0) THEN
2225: l_action_id := p_action_id;
2226: END IF;

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 2762: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;

2758: l_relationship_id
2759: FROM iem_rt_interactions
2760: WHERE rt_interaction_id = l_rt_interaction_id;
2761:
2762: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
2763: INSERT INTO iem_rt_media_items (
2764: rt_interaction_id, rt_media_item_id, resource_id,
2765: media_id, message_id, rfc822_message_id, folder_name,
2766: db_server_id, agent_account_id, email_type, status, expire, version,

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 3751: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;

3747: );
3748: -- db_server id used by mid-tier to locate accounts
3749: l_db_server_id := -1;
3750:
3751: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
3752: INSERT INTO iem_rt_media_items (
3753: rt_interaction_id, rt_media_item_id, resource_id,
3754: media_id, message_id, rfc822_message_id, folder_name,
3755: folder_uid, email_account_id, db_server_id, email_type,

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,

Line 4561: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;

4557: );
4558: -- db_server id used by mid-tier to locate accounts
4559: l_db_server_id := -1;
4560:
4561: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
4562: INSERT INTO iem_rt_media_items (
4563: rt_interaction_id, rt_media_item_id, resource_id,
4564: media_id, message_id, rfc822_message_id, folder_name,
4565: folder_uid, email_account_id, db_server_id, email_type,