APPS.IEM_DIAG_DATABASE_LINK_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 51

   JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 53

	select oracle_username into l_schema_owner from fnd_oracle_userid where read_only_flag = 'U';

Line: 55

	select db_server_id bulk collect into l_db_server_tbl from iem_db_servers;

Line: 61

		select count(*) into l_count from iem_db_connections where db_server_id=l_db_server_tbl(i) and is_admin='A';

Line: 62

		select db_name into l_db_name from iem_db_servers where db_server_id=l_db_server_tbl(i);

Line: 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);

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);

Line: 84

					l_statement := 'SELECT global_name FROM global_name@'||l_db_link;

Line: 103

		select count(*) into l_count from iem_db_connections where db_server_id=l_db_server_tbl(i) and is_admin='P';

Line: 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);

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);

Line: 126

					l_statement := 'SELECT global_name FROM global_name@'||l_db_link;