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