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 63: and a.message_id not in (select message_id from iem_migration_store_temp

59: from iem_post_mdts a, iem_agent_accounts b
60: where a.email_account_id = p_email_account_id and a.agent_id =
61: b.resource_id and b.agent_account_id = p_agent_account_id and
62: a.email_account_id = b.email_account_id
63: and a.message_id not in (select message_id from iem_migration_store_temp
64: where migration_id = p_inb_migration_id and message_type = 'I'
65: and mig_status = 'R');
66:
67: -- Cursor for p_rerun == 'Y' and p_type == 'O'

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

70: from iem_post_mdts a, iem_agent_accounts b
71: where a.email_account_id = p_email_account_id and a.agent_id =
72: b.resource_id and b.agent_account_id = p_agent_account_id and
73: a.email_account_id = b.email_account_id
74: and a.message_id not in (select message_id from iem_migration_store_temp
75: where migration_id = p_inb_migration_id and message_type = 'O'
76: and mig_status = 'R');
77: BEGIN
78: l_userid := NVL(to_number(FND_PROFILE.VALUE('USER_ID')), -1);

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

152: l_mig_status := 'R';
153: else
154: l_mig_status := 'E';
155: end if;
156: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
157: insert into IEM_MIGRATION_STORE_TEMP (
158: mail_id, message_id, migration_id, message_type, email_account_id,
159: agent_account_id, resource_id, folder_name, rt_media_item_id,
160: msg_uid, rfc822_message_id, from_str, to_str, reply_to_str,

Line 157: insert into IEM_MIGRATION_STORE_TEMP (

153: else
154: l_mig_status := 'E';
155: end if;
156: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
157: insert into IEM_MIGRATION_STORE_TEMP (
158: mail_id, message_id, migration_id, message_type, email_account_id,
159: agent_account_id, resource_id, folder_name, rt_media_item_id,
160: msg_uid, rfc822_message_id, from_str, to_str, reply_to_str,
161: cc_str, bcc_str, sent_date, subject, ih_media_item_id,

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

197: else
198: l_mig_status := 'E';
199: end if;
200: begin
201: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
202: insert into IEM_MIGRATION_STORE_TEMP (
203: mail_id, message_id, migration_id, message_type, email_account_id,
204: agent_account_id, resource_id, folder_name,
205: rt_media_item_id, msg_uid, created_by, creation_date,

Line 202: insert into IEM_MIGRATION_STORE_TEMP (

198: l_mig_status := 'E';
199: end if;
200: begin
201: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
202: insert into IEM_MIGRATION_STORE_TEMP (
203: mail_id, message_id, migration_id, message_type, email_account_id,
204: agent_account_id, resource_id, folder_name,
205: rt_media_item_id, msg_uid, created_by, creation_date,
206: last_update_date, last_updated_by, last_update_login, mig_status, error_text)

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

263: l_mig_status := 'R';
264: else
265: l_mig_status := 'E';
266: end if;
267: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
268: insert into IEM_MIGRATION_STORE_TEMP (
269: mail_id, message_id, migration_id, message_type, email_account_id,
270: agent_account_id, resource_id, folder_name, rt_media_item_id,
271: msg_uid, rfc822_message_id, from_str, to_str, reply_to_str,

Line 268: insert into IEM_MIGRATION_STORE_TEMP (

264: else
265: l_mig_status := 'E';
266: end if;
267: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
268: insert into IEM_MIGRATION_STORE_TEMP (
269: mail_id, message_id, migration_id, message_type, email_account_id,
270: agent_account_id, resource_id, folder_name, rt_media_item_id,
271: msg_uid, rfc822_message_id, from_str, to_str, reply_to_str,
272: cc_str, bcc_str, sent_date, subject, ih_media_item_id,

Line 284: delete from IEM_MIGRATION_STORE_TEMP where migration_id = p_inb_migration_id

280: l_bcc_str,to_char(mdts.sent_date,'DD-MON-YYYY HH24:MI:SS'), mdts.subject,
281: mdts.ih_media_item_id, mdts.message_size,
282: l_userid, sysdate, sysdate, l_userid, l_loginid, l_mig_status, l_err_msg
283: );
284: delete from IEM_MIGRATION_STORE_TEMP where migration_id = p_inb_migration_id
285: and message_id = mdts.message_id and message_type = 'I'
286: and mig_status <> 'R' and mail_id <> l_sequence;
287: end; -- inbound
288: END LOOP;

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

318: else
319: l_mig_status := 'E';
320: end if;
321: begin
322: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
323: insert into IEM_MIGRATION_STORE_TEMP (
324: mail_id, message_id, migration_id, message_type, email_account_id,
325: agent_account_id, resource_id, folder_name,
326: rt_media_item_id, msg_uid, created_by, creation_date,

Line 323: insert into IEM_MIGRATION_STORE_TEMP (

319: l_mig_status := 'E';
320: end if;
321: begin
322: select IEM_MIGRATION_STORE_TEMP_S1.nextval into l_sequence from DUAL;
323: insert into IEM_MIGRATION_STORE_TEMP (
324: mail_id, message_id, migration_id, message_type, email_account_id,
325: agent_account_id, resource_id, folder_name,
326: rt_media_item_id, msg_uid, created_by, creation_date,
327: last_update_date, last_updated_by, last_update_login, mig_status, error_text)

Line 334: delete from IEM_MIGRATION_STORE_TEMP where migration_id = p_outb_migration_id

330: l_outb_agent_account_id, l_resource_id, l_outb_folder_name,
331: l_outb_rt_media_item_id, l_outb_msg_uid,
332: l_userid, sysdate, sysdate, l_userid, l_loginid, l_mig_status, l_err_msg
333: );
334: delete from IEM_MIGRATION_STORE_TEMP where migration_id = p_outb_migration_id
335: and message_id = mdts.message_id and message_type = 'O'
336: and mig_status <> 'R' and mail_id <> l_sequence;
337: end;
338: end if; -- draft exists