APPS.IEM_DIAG_EMC_SETUP_PVT dependencies on IEM_DB_SERVERS

Line 37: l_db_name iem_db_servers.db_name%type;

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;
41: l_search_dblink VARCHAR2(129);

Line 63: select count(*) into l_db_count from iem_db_servers;

59: -- Server Group
60: select count(*) into l_server_group_count from iem_server_groups;
61:
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';