APPS.IEM_MGINBOX_PUB dependencies on IEM_RT_MEDIA_ITEMS

Line 56: and a.message_id in (select message_id from iem_rt_media_items a,

52: from iem_post_mdts a, iem_agent_accounts b
53: where a.email_account_id = p_email_account_id and a.agent_id =
54: b.resource_id and b.agent_account_id = p_agent_account_id and
55: a.email_account_id = b.email_account_id
56: and a.message_id in (select message_id from iem_rt_media_items a,
57: iem_rt_interactions b where a.rt_interaction_id=b.rt_interaction_id
58: and a.email_type='I' and b.expire='N');
59:
60: -- Cursor for p_rerun == 'Y' and p_type == 'I'

Line 70: and a.message_id in (select message_id from iem_rt_media_items a,

66: a.email_account_id = b.email_account_id
67: and a.message_id not in (select message_id from iem_migration_store_temp
68: where migration_id = p_inb_migration_id and message_type = 'I'
69: and mig_status = 'R')
70: and a.message_id in (select message_id from iem_rt_media_items a,
71: iem_rt_interactions b where a.rt_interaction_id=b.rt_interaction_id
72: and a.email_type='I' and b.expire='N');
73:
74: -- Cursor for p_rerun == 'Y' and p_type == 'O'

Line 129: from iem_rt_media_items rtm, iem_rt_interactions rti

125: rtm.agent_account_id, rtm.resource_id, rtm.folder_name,
126: rtm.folder_uid
127: into l_rt_media_item_id, l_rt_interaction_id, l_agent_account_id,
128: l_resource_id, l_folder_name, l_msg_uid
129: from iem_rt_media_items rtm, iem_rt_interactions rti
130: where rtm.message_id = mdts.message_id and rtm.email_type ='I'
131: and rtm.rt_interaction_id = rti.rt_interaction_id
132: and rti.expire = 'N';
133: exception

Line 135: l_err_msg := substr('Error in query iem_rt_media_items and iem_rt_interactions'||SQLERRM,1,1000);

131: and rtm.rt_interaction_id = rti.rt_interaction_id
132: and rti.expire = 'N';
133: exception
134: when others then
135: l_err_msg := substr('Error in query iem_rt_media_items and iem_rt_interactions'||SQLERRM,1,1000);
136: l_rt_media_item_id:=null;
137: l_rt_interaction_id:=null;
138: l_agent_account_id:=null;
139: l_resource_id:=null;

Line 196: from iem_rt_media_items rtm, iem_msg_parts part

192: begin
193: select rtm.rt_media_item_id, rtm.agent_account_id, rtm.folder_name,
194: rtm.folder_uid into l_outb_rt_media_item_id,
195: l_outb_agent_account_id, l_outb_folder_name, l_outb_msg_uid
196: from iem_rt_media_items rtm, iem_msg_parts part
197: where rtm.rt_interaction_id = l_rt_interaction_id
198: and rtm.email_type = 'O' and rtm.folder_uid > 0
199: and rtm.folder_name = 'Drafts'
200: and part.ref_key = rtm.rt_media_item_id

Line 250: from iem_rt_media_items rtm, iem_rt_interactions rti

246: rtm.agent_account_id, rtm.resource_id, rtm.folder_name,
247: rtm.folder_uid
248: into l_rt_media_item_id, l_rt_interaction_id, l_agent_account_id,
249: l_resource_id, l_folder_name, l_msg_uid
250: from iem_rt_media_items rtm, iem_rt_interactions rti
251: where rtm.message_id = mdts.message_id and rtm.email_type ='I'
252: and rtm.rt_interaction_id = rti.rt_interaction_id
253: and rti.expire = 'N';
254: exception

Line 262: l_err_msg := substr('Error in query iem_rt_media_items and iem_rt_interactions'||SQLERRM,1,1000);

258: l_agent_account_id:=null;
259: l_resource_id:=null;
260: l_folder_name:=null;
261: l_msg_uid:=null;
262: l_err_msg := substr('Error in query iem_rt_media_items and iem_rt_interactions'||SQLERRM,1,1000);
263: end;
264:
265: begin
266: select a.db_link into l_dblink

Line 325: from iem_rt_media_items rtm, iem_msg_parts part

321: l_err_msg := null;
322: select rtm.rt_media_item_id, rtm.agent_account_id, rtm.folder_name,
323: rtm.folder_uid into l_outb_rt_media_item_id,
324: l_outb_agent_account_id, l_outb_folder_name, l_outb_msg_uid
325: from iem_rt_media_items rtm, iem_msg_parts part
326: where rtm.rt_interaction_id = l_rt_interaction_id
327: and rtm.email_type = 'O' and rtm.folder_uid > 0
328: and rtm.folder_name = 'Drafts'
329: and part.ref_key = rtm.rt_media_item_id