DBA Data[Home] [Help]

APPS.IEM_PARAMETERS_PVT SQL Statements

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

Line: 5

PROCEDURE select_profile (p_api_version_number  IN   NUMBER,
 		          p_init_msg_list  	IN   VARCHAR2 := FND_API.G_FALSE,
		          p_commit	    	IN   VARCHAR2 := FND_API.G_FALSE,
  			  p_profile_name    	IN   VARCHAR2,
  			  x_profile_value OUT NOCOPY  VARCHAR2,
             		  x_return_status OUT NOCOPY  VARCHAR2,
  		  	  x_msg_count	       OUT NOCOPY  NUMBER,
	  	  	  x_msg_data	 OUT NOCOPY  VARCHAR2
			 ) is
	l_api_name        		VARCHAR2(255):='select_profile';
Line: 19

SAVEPOINT		select_profile_PVT;
Line: 52

	ROLLBACK TO select_profile_PVT;
Line: 60

	ROLLBACK TO select_profile_PVT;
Line: 68

	ROLLBACK TO select_profile_PVT;
Line: 83

 END	select_profile;
Line: 86

PROCEDURE update_profile (p_api_version_number  IN   NUMBER,
 		          p_init_msg_list  	IN   VARCHAR2,
		          p_commit	    	IN   VARCHAR2,
  			  p_profile_name    	IN   VARCHAR2,
  			  p_profile_value	IN   VARCHAR2,
             		  x_return_status OUT NOCOPY VARCHAR2,
  		  	  x_msg_count	       OUT NOCOPY NUMBER,
	  	  	  x_msg_data	 OUT NOCOPY VARCHAR2
			 ) is
	l_api_name        		VARCHAR2(255):='update_profile';
Line: 104

	PROFILE_NOT_UPDATED EXCEPTION;
Line: 108

SAVEPOINT		update_profile_PVT;
Line: 128

   	select count(*) into l_count from hz_parties where party_number=p_profile_value;
Line: 135

	select party_id into l_party_id from hz_parties where party_number=p_profile_value;
Line: 138

		raise PROFILE_NOT_UPDATED;
Line: 141

   /*	select party_type into l_party_type from hz_parties where party_number=p_profile_value;
Line: 149

   		raise PROFILE_NOT_UPDATED;
Line: 157

		select count(*) into l_count from jtf_rs_resource_extns where resource_number=p_profile_value;
Line: 164

		select resource_id into l_resource_id from jtf_rs_resource_extns where resource_number=p_profile_value;
Line: 167

			raise PROFILE_NOT_UPDATED;
Line: 173

   		raise PROFILE_NOT_UPDATED;
Line: 180

   	raise PROFILE_NOT_UPDATED;
Line: 195

        ROLLBACK TO update_profile_PVT;
Line: 202

        ROLLBACK TO update_profile_PVT;
Line: 208

   WHEN PROFILE_NOT_UPDATED THEN
        ROLLBACK TO update_profile_PVT;
Line: 211

        FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_INTENT_N_NOT_UPDATED');
Line: 217

	ROLLBACK TO update_profile_PVT;
Line: 225

	ROLLBACK TO update_profile_PVT;
Line: 233

	ROLLBACK TO update_profile_PVT;
Line: 248

 END	update_profile;
Line: 250

 PROCEDURE update_profile_wrap (p_api_version_number  IN   NUMBER,
 		          p_init_msg_list  	IN   VARCHAR2,
		          p_commit	    	IN   VARCHAR2,
  			  p_profile_name_tbl 	IN   jtf_varchar2_Table_100,
  			  p_profile_value_tbl	IN   jtf_varchar2_Table_100,
             		  x_return_status OUT NOCOPY VARCHAR2,
  		  	  x_msg_count	       OUT NOCOPY NUMBER,
	  	  	  x_msg_data	 OUT NOCOPY VARCHAR2
			 ) is
	l_api_name        		VARCHAR2(255):='update_profile_wrap';
Line: 264

	PROFILE_NOT_UPDATED EXCEPTION;
Line: 268

SAVEPOINT		update_profile_PVT;
Line: 287

     	iem_parameters_pvt.update_profile (p_api_version_number => l_api_version_number,
 		          p_init_msg_list => FND_API.G_FALSE,
		          p_commit => FND_API.G_FALSE,
  			  p_profile_name => p_profile_name_tbl(i),
  			  p_profile_value => p_profile_value_tbl(i),
             		  x_return_status=> l_return_status,
  		  	  x_msg_count => l_msg_count,
	  	  	  x_msg_data => l_msg_data);
Line: 297

        	raise PROFILE_NOT_UPDATED;
Line: 314

   WHEN PROFILE_NOT_UPDATED THEN
        ROLLBACK TO update_profile_PVT;
Line: 321

	ROLLBACK TO update_profile_PVT;
Line: 329

	ROLLBACK TO update_profile_PVT;
Line: 337

	ROLLBACK TO update_profile_PVT;
Line: 352

 END	update_profile_wrap;