APPS.IEM_MGINBOX_PUB dependencies on DUAL

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