[Home] [Help]
17: and b.is_admin='A'
18: and upper(a.email_user)<>'INTENT';
19: l_email_account_id number;
20: cursor c_folder is
21: select name||','||a.route_classification_id name from iem_route_classifications a,iem_account_route_class b
22: where a.route_classification_id=b.route_classification_id
23: and b.email_account_id=l_email_account_id
24: union
25: select 'Inbox' from dual
539: l_error_text varchar2(500);
540: l_commit_cntr number := 0;
541: l_direction varchar2(100);
542: cursor c_queue is
543: select a.* from iem_post_mdts a,iem_route_classifications b
544: where a.email_account_id=l_email_account_id and a.agent_id=0
545: and a.rt_classification_id=b.route_classification_id and
546: b.name=l_folder_name and a.message_id not in (select message_id from iem_migration_store_temp
547: where migration_id=p_migration_id)
545: and a.rt_classification_id=b.route_classification_id and
546: b.name=l_folder_name and a.message_id not in (select message_id from iem_migration_store_temp
547: where migration_id=p_migration_id)
548: union -- select records which are also errors out
549: select a.* from iem_post_mdts a,iem_route_classifications b
550: where a.email_account_id=l_email_account_id and a.agent_id=0
551: and a.rt_classification_id=b.route_classification_id and
552: b.name=l_folder_name and a.message_id in (select message_id from iem_migration_store_temp
553: where migration_id=p_migration_id and mig_status='E' and dp_status is null);
1788: l_last_update_login);
1789: END LOOP;
1790: -- Update Deleted flag of IEM_ROUTE_CLASSFICATIONS
1791:
1792: update iem_route_classifications
1793: set deleted_flag='N'
1794: where deleted_flag is null; -- So that can be re runnable..
1795: -- Reset the Sequence to have highest email account id id
1796: select nvl(max(email_account_id),0) into l_max_id from iem_mstemail_accounts;