APPS.IEM_DIAG_EMC_SETUP_PVT dependencies on IEM_DB_CONNECTIONS

Line 36: l_db_link iem_db_connections.db_link%type;

32: l_i_account_count number := 0;
33: fixInfo VARCHAR2(4000);
34: isFatal VARCHAR2(50);
35: dummy_num NUMBER;
36: l_db_link iem_db_connections.db_link%type;
37: l_db_name iem_db_servers.db_name%type;
38: l_db_server_tbl jtf_varchar2_Table_100:=jtf_varchar2_Table_100();
39: l_count number;
40: l_link_count number;

Line 66: select count(*) into l_oo_count from iem_db_connections where is_admin='A';

62: -- Database Server
63: select count(*) into l_db_count from iem_db_servers;
64:
65: -- Database Links
66: select count(*) into l_oo_count from iem_db_connections where is_admin='A';
67: select count(*) into l_oraoffice_count from iem_db_connections where is_admin='P';
68: select count(*) into l_apps_count from iem_db_connections where is_admin='O';
69:
70: -- Email Servers

Line 67: select count(*) into l_oraoffice_count from iem_db_connections where is_admin='P';

63: select count(*) into l_db_count from iem_db_servers;
64:
65: -- Database Links
66: select count(*) into l_oo_count from iem_db_connections where is_admin='A';
67: select count(*) into l_oraoffice_count from iem_db_connections where is_admin='P';
68: select count(*) into l_apps_count from iem_db_connections where is_admin='O';
69:
70: -- Email Servers
71: select count(*) into l_imap_count from iem_email_servers where server_type_id=10001;

Line 68: select count(*) into l_apps_count from iem_db_connections where is_admin='O';

64:
65: -- Database Links
66: select count(*) into l_oo_count from iem_db_connections where is_admin='A';
67: select count(*) into l_oraoffice_count from iem_db_connections where is_admin='P';
68: select count(*) into l_apps_count from iem_db_connections where is_admin='O';
69:
70: -- Email Servers
71: select count(*) into l_imap_count from iem_email_servers where server_type_id=10001;
72: select count(*) into l_smtp_count from iem_email_servers where server_type_id=10002;