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 2246: select decode(p_activity_type_id,-1, NULL, p_activity_type_id) into l_activity_type_id from DUAL;

2242: if ( l_spv_resource_id > 0 ) then
2243: l_resource_id := l_spv_resource_id;
2244: end if;
2245:
2246: select decode(p_activity_type_id,-1, NULL, p_activity_type_id) into l_activity_type_id from DUAL;
2247: select decode(p_result_id,-1, NULL, p_result_id) into l_result_id from DUAL;
2248: select decode(p_reason_id,-1, NULL, p_reason_id) into l_reason_id from DUAL;
2249:
2250: IF (l_action_id < 0) THEN

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

2243: l_resource_id := l_spv_resource_id;
2244: end if;
2245:
2246: select decode(p_activity_type_id,-1, NULL, p_activity_type_id) into l_activity_type_id from DUAL;
2247: select decode(p_result_id,-1, NULL, p_result_id) into l_result_id from DUAL;
2248: select decode(p_reason_id,-1, NULL, p_reason_id) into l_reason_id from DUAL;
2249:
2250: IF (l_action_id < 0) THEN
2251: l_action_id := p_action_id;

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

2244: end if;
2245:
2246: select decode(p_activity_type_id,-1, NULL, p_activity_type_id) into l_activity_type_id from DUAL;
2247: select decode(p_result_id,-1, NULL, p_result_id) into l_result_id from DUAL;
2248: select decode(p_reason_id,-1, NULL, p_reason_id) into l_reason_id from DUAL;
2249:
2250: IF (l_action_id < 0) THEN
2251: l_action_id := p_action_id;
2252: END IF;

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

2820: l_relationship_id
2821: FROM iem_rt_interactions
2822: WHERE rt_interaction_id = l_rt_interaction_id;
2823:
2824: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
2825: INSERT INTO iem_rt_media_items (
2826: rt_interaction_id, rt_media_item_id, resource_id,
2827: media_id, message_id, rfc822_message_id, folder_name,
2828: db_server_id, agent_account_id, email_type, status, expire, version,

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

3822: );
3823: -- db_server id used by mid-tier to locate accounts
3824: l_db_server_id := -1;
3825:
3826: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
3827: INSERT INTO iem_rt_media_items (
3828: rt_interaction_id, rt_media_item_id, resource_id,
3829: media_id, message_id, rfc822_message_id, folder_name,
3830: folder_uid, email_account_id, db_server_id, email_type,

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,

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

4632: );
4633: -- db_server id used by mid-tier to locate accounts
4634: l_db_server_id := -1;
4635:
4636: select IEM_RT_MEDIA_ITEMS_S1.nextval into l_m_sequence from DUAL;
4637: INSERT INTO iem_rt_media_items (
4638: rt_interaction_id, rt_media_item_id, resource_id,
4639: media_id, message_id, rfc822_message_id, folder_name,
4640: folder_uid, email_account_id, db_server_id, email_type,