APPS.IEM_CLIENT_PUB dependencies on IEM_RT_MEDIA_ITEMS_S1

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 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 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 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 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,