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_MGINBOX_PUB dependencies on IEM_MIGRATION_STORE_TEMP

Line 67: and a.message_id not in (select message_id from iem_migration_store_temp

63: from iem_post_mdts a, iem_agent_accounts b
64: where a.email_account_id = p_email_account_id and a.agent_id =
65: b.resource_id and b.agent_account_id = p_agent_account_id and
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

Line 81: and a.message_id not in (select message_id from iem_migration_store_temp

77: from iem_post_mdts a, iem_agent_accounts b
78: where a.email_account_id = p_email_account_id and a.agent_id =
79: b.resource_id and b.agent_account_id = p_agent_account_id and
80: a.email_account_id = b.email_account_id
81: and a.message_id not in (select message_id from iem_migration_store_temp
82: where migration_id = p_inb_migration_id and message_type = 'O'
83: and mig_status = 'R');
84: BEGIN
85: l_userid := NVL(to_number(FND_PROFILE.VALUE('USER_ID')), -1);

Line 172: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;

168: l_mig_status := 'R';
169: else
170: l_mig_status := 'E';
171: end if;
172: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
173: insert into IEM_MIGRATION_STORE_TEMP (
174: mail_id, message_id, migration_id, message_type, email_account_id,
175: agent_account_id, resource_id, folder_name, rt_media_item_id,
176: msg_uid, rfc822_message_id, from_str, to_str, reply_to_str,

Line 173: insert into IEM_MIGRATION_STORE_TEMP (

169: else
170: l_mig_status := 'E';
171: end if;
172: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
173: insert into IEM_MIGRATION_STORE_TEMP (
174: mail_id, message_id, migration_id, message_type, email_account_id,
175: agent_account_id, resource_id, folder_name, rt_media_item_id,
176: msg_uid, rfc822_message_id, from_str, to_str, reply_to_str,
177: cc_str, bcc_str, sent_date, subject, ih_media_item_id,

Line 217: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;

213: else
214: l_mig_status := 'E';
215: end if;
216: begin
217: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
218: insert into IEM_MIGRATION_STORE_TEMP (
219: mail_id, message_id, migration_id, message_type, email_account_id,
220: agent_account_id, resource_id, folder_name,
221: rt_media_item_id, msg_uid, created_by, creation_date,

Line 218: insert into IEM_MIGRATION_STORE_TEMP (

214: l_mig_status := 'E';
215: end if;
216: begin
217: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
218: insert into IEM_MIGRATION_STORE_TEMP (
219: mail_id, message_id, migration_id, message_type, email_account_id,
220: agent_account_id, resource_id, folder_name,
221: rt_media_item_id, msg_uid, created_by, creation_date,
222: last_update_date, last_updated_by, last_update_login, mig_status, error_text)

Line 291: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;

287: l_mig_status := 'R';
288: else
289: l_mig_status := 'E';
290: end if;
291: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
292: insert into IEM_MIGRATION_STORE_TEMP (
293: mail_id, message_id, migration_id, message_type, email_account_id,
294: agent_account_id, resource_id, folder_name, rt_media_item_id,
295: msg_uid, rfc822_message_id, from_str, to_str, reply_to_str,

Line 292: insert into IEM_MIGRATION_STORE_TEMP (

288: else
289: l_mig_status := 'E';
290: end if;
291: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
292: insert into IEM_MIGRATION_STORE_TEMP (
293: mail_id, message_id, migration_id, message_type, email_account_id,
294: agent_account_id, resource_id, folder_name, rt_media_item_id,
295: msg_uid, rfc822_message_id, from_str, to_str, reply_to_str,
296: cc_str, bcc_str, sent_date, subject, ih_media_item_id,

Line 308: delete from IEM_MIGRATION_STORE_TEMP where migration_id = p_inb_migration_id

304: l_bcc_str,to_char(mdts.sent_date,'DD-MON-YYYY HH24:MI:SS') || ' GMT', mdts.subject,
305: mdts.ih_media_item_id, mdts.message_size,
306: l_userid, sysdate, sysdate, l_userid, l_loginid, l_mig_status, l_err_msg
307: );
308: delete from IEM_MIGRATION_STORE_TEMP where migration_id = p_inb_migration_id
309: and message_id = mdts.message_id and message_type = 'I'
310: and mig_status <> 'R' and mail_id <> l_sequence;
311: end; -- inbound
312: END LOOP;

Line 346: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;

342: else
343: l_mig_status := 'E';
344: end if;
345: begin
346: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
347: insert into IEM_MIGRATION_STORE_TEMP (
348: mail_id, message_id, migration_id, message_type, email_account_id,
349: agent_account_id, resource_id, folder_name,
350: rt_media_item_id, msg_uid, created_by, creation_date,

Line 347: insert into IEM_MIGRATION_STORE_TEMP (

343: l_mig_status := 'E';
344: end if;
345: begin
346: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
347: insert into IEM_MIGRATION_STORE_TEMP (
348: mail_id, message_id, migration_id, message_type, email_account_id,
349: agent_account_id, resource_id, folder_name,
350: rt_media_item_id, msg_uid, created_by, creation_date,
351: last_update_date, last_updated_by, last_update_login, mig_status, error_text)

Line 358: delete from IEM_MIGRATION_STORE_TEMP where migration_id = p_outb_migration_id

354: l_outb_agent_account_id, l_resource_id, l_outb_folder_name,
355: l_outb_rt_media_item_id, l_outb_msg_uid,
356: l_userid, sysdate, sysdate, l_userid, l_loginid, l_mig_status, l_err_msg
357: );
358: delete from IEM_MIGRATION_STORE_TEMP where migration_id = p_outb_migration_id
359: and message_id = mdts.message_id and message_type = 'O'
360: and mig_status <> 'R' and mail_id <> l_sequence;
361: end;
362: end if; -- draft exists