APPS.IEM_COMP_RT_STATS_PVT SQL Statements

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

Line: 19

     l_LAST_UPDATED_BY    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

Line: 20

     l_LAST_UPDATE_DATE    DATE:=SYSDATE;

Line: 43

   SELECT IEM_COMP_RT_STATS_s1.nextval
	INTO l_seq_id
	FROM dual;

Line: 47

	INSERT INTO IEM_COMP_RT_STATS
	(
	COMP_RT_STATS_ID,
	TYPE,
	PARAM,
	VALUE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE
	)
	VALUES
	(
	l_seq_id,
	p_type,
	p_param,
	p_value,
        decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
        l_LAST_UPDATE_DATE
	);

Line: 112

PROCEDURE update_item (p_api_version_number    IN   NUMBER,
 	  	      	   p_init_msg_list  IN   VARCHAR2,
	    	           p_commit	    IN   VARCHAR2,
			   p_comp_rt_stats_id IN NUMBER,
  			   p_type IN   VARCHAR2,
  			   p_param	IN   VARCHAR2,
  			   p_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_item';

Line: 126

     l_LAST_UPDATED_BY    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

Line: 127

     l_LAST_UPDATE_DATE    DATE:=SYSDATE;

Line: 131

SAVEPOINT		update_item_PVT;

Line: 148

	update IEM_COMP_RT_STATS
	set type=decode(p_type,FND_API.G_MISS_CHAR, null, null, type,p_type),
	param=decode(p_param,FND_API.G_MISS_CHAR, null, null,param,p_param),
	value=decode(p_value,FND_API.G_MISS_CHAR, null, null,value,p_value),
        LAST_UPDATE_DATE = l_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY)
	where comp_rt_stats_id=p_comp_rt_stats_id;

Line: 169

	ROLLBACK TO update_item_PVT;

Line: 176

	ROLLBACK TO update_item_PVT;

Line: 183

	ROLLBACK TO update_item_PVT;

Line: 198

 END	update_item;

Line: 200

PROCEDURE delete_item (p_api_version_number    IN   NUMBER,
 		  	      p_init_msg_list  IN   VARCHAR2,
		    	      p_commit	    IN   VARCHAR2,
			      p_comp_rt_stats_id	in number,
			      x_return_status OUT NOCOPY VARCHAR2,
  		  	      x_msg_count	      OUT NOCOPY    NUMBER,
	  	  	      x_msg_data OUT NOCOPY VARCHAR2
			 ) is
	l_api_name        		VARCHAR2(255):='delete_item';

Line: 213

SAVEPOINT		delete_item_PVT;

Line: 230

	delete from IEM_COMP_RT_STATS
	where comp_rt_stats_id=p_comp_rt_stats_id;

Line: 244

	ROLLBACK TO delete_item_PVT;

Line: 251

	ROLLBACK TO delete_item_PVT;

Line: 258

	ROLLBACK TO delete_item_PVT;

Line: 273

 END	delete_item;

Line: 275

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

Line: 287

SAVEPOINT		delete_item_PVT;

Line: 304

delete from iem_comp_rt_stats where type IN ('EMAIL_ACCOUNT', 'AGENT_ACCOUNT',
'AGENT', 'IMAP', 'SMTP', 'OES') and sysdate - last_update_date >1;

Line: 318

	ROLLBACK TO delete_item_PVT;

Line: 325

	ROLLBACK TO delete_item_PVT;

Line: 332

	ROLLBACK TO delete_item_PVT;

Line: 347

 END	delete_item_for_cache;