eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_CONFIGURATION_PUB SQL Statements

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

Line: 32


		Cursor csr_server_group is select * from iem_server_groups;

Line: 33


		Cursor csr_db_server is select * from iem_db_servers;

Line: 34


		Cursor csr_db_connection is select * from iem_db_connections;

Line: 35


		Cursor csr_email_server is select * from iem_email_servers;

Line: 36


		Cursor csr_email_account is select * from iem_email_accounts;

Line: 37


		Cursor csr_classification is select * from iem_classifications;

Line: 38


		Cursor csr_agent_account is select * from iem_agent_accounts;

Line: 40


            		select * from iem_themes where classification_id = l_classification_id ;

Line: 64


     select count(*) into l_count from iem_server_groups;

Line: 85


     select count(*) into l_count from iem_db_servers;

Line: 111


     select count(*) into l_count from iem_db_connections;

Line: 137


     select count(*) into l_count from iem_email_servers;

Line: 163


     select count(*) into l_count from iem_email_accounts;

Line: 190


     select count(*) into l_count from iem_classifications;

Line: 197


     fnd_file.put_line(fnd_file.log, 'row_id, classification_id, account_name, classification, created_by, creation_date, last_updated_by, last_update_date');

Line: 205


				select email_user||'@'||domain as account_name into l_account_name from iem_email_accounts where email_account_id= l_classification_rec.email_account_id;

Line: 211


    					l_classification_rec.last_updated_by || ', ' ||  l_classification_rec.last_update_date);

Line: 217


     				select count(*) into l_count from iem_themes where classification_id=l_classification_rec.classification_id;

Line: 222


     				fnd_file.put_line(fnd_file.log, '      row_id, theme_id, theme, score, query_response, created_by, creation_date, last_updated_by, last_update_date');

Line: 230


    					l_theme_rec.last_updated_by || ', ' ||  l_theme_rec.last_update_date);

Line: 240


     select count(*) into l_count from iem_agent_accounts;

Line: 271


     	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_ACCOUNT_SENDER_NAME',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 283


     	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_CACHE_UPDATE_FREQ',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 292


	l_Error_Message := 'IEM_CACHE_UPDATE_FREQ : ' || l_profile_value;

Line: 295


	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_DEFAULT_CUSTOMER_ID',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 307


     	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_DEFAULT_CUSTOMER_NUMBER',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 319


     	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_DEFAULT_RESOURCE_NUMBER',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 331


     	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_INTENT_RESPONSE_NUM',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 343


     	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_KNOWLEDGE_BASE',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 355


     	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_SRVRPROC_APENABLE',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 367


	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_SRVR_ARES',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 379


     	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_SRVR_AROUTE',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 392


	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_SRVR_ASRUPD',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);

Line: 404


	iem_parameters_pvt.select_profile (p_api_version_number =>1.0,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name  => 'IEM_SRVR_SRST',
  			  x_profile_value => l_profile_value,
             		  x_return_status => l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data=> l_msg_data);