DBA Data[Home] [Help]

APPS.IEM_DBLINK_PVT SQL Statements

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

Line: 121

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

select count(*) into l_dblink_count from iem_db_connections where db_username=p_db_username and db_server_id=p_db_server_id;
Line: 130

   select * INTO l_iem_server_rec from IEM_DB_SERVERS where DB_SERVER_ID = p_db_server_id;
Line: 136

	select CONCAT(l_iem_server_rec.service_name, '@appsto_oo') into l_glname from DUAL;
Line: 139

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

     select CONCAT(l_iem_server_rec.service_name, '@appsto_ora') into l_glname from DUAL;
Line: 158

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

	l_statement := 'SELECT global_name FROM global_name@'||l_glname;
Line: 211

	select count(*) into l_count from iem_db_connections where UPPER(db_link) = UPPER(l_glname) and db_server_id = p_db_server_id;
Line: 248

   	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 265

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 281

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 297

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 315

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 331

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 348

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 365

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 400

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 416

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 432

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 448

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 465

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 482

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 499

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 516

     	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 537

	  select count(*) into l_count from all_db_links where upper(owner)=upper(l_schema_owner) and UPPER(db_link) = UPPER(l_glname);
Line: 591

PROCEDURE delete_link (p_api_version_number  IN   NUMBER,
 		  	      p_init_msg_list  		IN   VARCHAR2,
		    	      p_commit	    			IN   VARCHAR2,
			 	 p_db_connection_id 	IN   NUMBER,
			      x_return_status	 OUT NOCOPY VARCHAR2,
  		  	      x_msg_count	       OUT NOCOPY    NUMBER,
	  	  	      x_msg_data		 OUT NOCOPY VARCHAR2
			 ) is
			 TYPE LinkCur Is REF CURSOR;
Line: 600

	l_api_name        		VARCHAR2(255):='delete_link';
Line: 633

   select * INTO l_iem_dbconn_rec from IEM_DB_CONNECTIONS where DB_CONNECTION_ID = p_db_connection_id;
Line: 650

SAVEPOINT		delete_link_pvt;
Line: 652

	IEM_DB_CONNECTIONS_PVT.delete_item(
			p_api_version_number => 1.0,
			p_db_conn_id => p_db_connection_id,
			x_msg_count => x_msg_count,
			x_return_status => x_return_status,
			x_msg_data => x_msg_data);
Line: 673

       IEM_DB_CONNECTIONS_PVT.delete_item(
			p_api_version_number => 1.0,
			p_db_conn_id => p_db_connection_id,
			x_msg_count => x_msg_count,
			x_return_status => x_return_status,
			x_msg_data => x_msg_data);
Line: 686

	  ROLLBACK TO delete_link_pvt;
Line: 693

	  ROLLBACK TO delete_link_pvt;
Line: 704

	   --ROLLBACK TO delete_link_pvt;
Line: 719

END delete_link;