APPS.IEM_MGINBOX_PUB dependencies on DUAL

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