APPS.IEM_MIGRATION_PVT dependencies on IEM_DB_CONNECTIONS

Line 15: iem_email_accounts a,iem_db_connections b

11:
12:
13: procedure build_migration_queue(x_status out nocopy varchar2) IS
14: cursor c_account is select email_account_id,email_user,domain,EMAIL_PASSWORD,db_link from
15: iem_email_accounts a,iem_db_connections b
16: where a.db_server_id=b.db_server_id
17: and b.is_admin='A'
18: and upper(a.email_user)<>'INTENT';
19: l_email_account_id number;

Line 625: from iem_db_connections a, iem_email_accounts b

621: --dbms_output.put_line('Directionis:'|| l_direction);
622: if l_folder_type='Q' THEN
623: BEGIN
624: select a.db_link into l_dblink
625: from iem_db_connections a, iem_email_accounts b
626: where a.db_server_id=b.db_Server_id
627: and b.email_account_id = l_email_account_id and a.is_admin='A';
628: -- Check normal processing or error Processing
629: select count(*) into l_qcount from iem_migration_store_temp

Line 811: from iem_email_accounts a,iem_db_connections b

807: select to_date(value,'YYYY/MM/DD HH24:MI:SS') into l_hist_date from
808: iem_comp_rt_Stats where type='HISTORICAL' and param='LASTRUN' ;
809: select a.email_user,a.domain,a.email_password,'@'||DB_LINK
810: into l_user,l_domain,l_pass,l_dblink
811: from iem_email_accounts a,iem_db_connections b
812: where a.email_account_id=l_email_account_id
813: and a.db_server_id=b.db_server_id
814: and b.is_admin='A';
815: l_mig_status:=null;

Line 1551: l_dblink iem_db_connections.db_link%type;

1547: l_msg_count number;
1548: l_ret_status varchar2(10);
1549: l_msg_data varchar2(1000);
1550: l_deleted_flag varchar2(1);
1551: l_dblink iem_db_connections.db_link%type;
1552: l_weight number;
1553: l_sc_lang iem_mstemail_accounts.sc_lang%type;
1554: cursor c_rule is select email_user,domain from iem_email_accounts
1555: where upper(email_user) not in ('ACKNOWLEDGEMENTS');

Line 1583: from iem_db_connections a, iem_email_accounts b

1579: a.server_group_id=v1.server_group_id;
1580: if l_dblink is null then -- not required to get the dblink repeatedly
1581: if upper(v1.email_user) not in ('ACKNOWLEDGEMENTS') then
1582: select a.db_link into l_dblink
1583: from iem_db_connections a, iem_email_accounts b
1584: where a.db_server_id=b.db_Server_id
1585: and b.email_account_id = l_email_account_id and a.is_admin='A';
1586: end if;
1587: end if;

Line 1857: --select '@'||db_link into l_db_link from iem_db_connections where db_link=p_link;

1853: l_pass varchar2(100);
1854:
1855: l_logmessage varchar2(1000);
1856: begin
1857: --select '@'||db_link into l_db_link from iem_db_connections where db_link=p_link;
1858: --from iem_db_connections where db_link='oes11i@appsto_oo';
1859:
1860: l_folder := p_folder;
1861: l_user := p_user;

Line 1858: --from iem_db_connections where db_link='oes11i@appsto_oo';

1854:
1855: l_logmessage varchar2(1000);
1856: begin
1857: --select '@'||db_link into l_db_link from iem_db_connections where db_link=p_link;
1858: --from iem_db_connections where db_link='oes11i@appsto_oo';
1859:
1860: l_folder := p_folder;
1861: l_user := p_user;
1862: l_domain := p_domain;