APPS.IEM_DIAG_DATABASE_LINK_PVT dependencies on ALL_DB_LINKS

Line 74: select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_dblink);

70: select a.db_link into l_db_link from iem_db_connections a, iem_db_servers b where a.db_server_id=b.db_server_id and a.is_admin='A' and a.db_server_id=l_db_server_tbl(i);
71:
72: l_search_dblink := l_db_link || '%';
73:
74: select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_dblink);
75:
76: if (l_link_count = 0) then
77: statusStr := 'FAILURE';
78: errOO2 := errOO2 || l_db_link || ', ';

Line 116: select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_dblink);

112: select a.db_link into l_db_link from iem_db_connections a, iem_db_servers b where a.db_server_id=b.db_server_id and a.is_admin='P' and a.db_server_id=l_db_server_tbl(i);
113:
114: l_search_dblink := l_db_link || '%';
115:
116: select count(*)into l_link_count from all_db_links where upper(owner)=upper(l_schema_owner) and db_link like UPPER(l_search_dblink);
117:
118: if (l_link_count = 0) then
119: statusStr := 'FAILURE';
120: errOra2 := errOra2 || l_db_link || ', ';