APPS.IEM_EML_CLASSIFICATIONS_PVT SQL Statements

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

Line: 41

         p_LAST_UPDATED_BY    NUMBER,
         p_LAST_UPDATE_DATE    DATE,
     p_LAST_UPDATE_LOGIN    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):='create_item';

Line: 70

   select count(*) into l_count from iem_email_classifications
   where message_id=p_message_id
   and classification_id=p_classification_id;

Line: 74

	INSERT INTO IEM_EMAIL_CLASSIFICATIONS
	(
	MESSAGE_ID,
	EMAIL_ACCOUNT_ID ,
	CLASSIFICATION_ID ,
	SCORE   ,
	CREATED_BY  ,
	CREATION_DATE ,
	LAST_UPDATED_BY ,
	LAST_UPDATE_DATE ,
	LAST_UPDATE_LOGIN
	)
	VALUES
	(
	p_message_id,
	p_email_account_id,
	p_classification_id,
	p_score,
    	DECODE(p_created_by,null,-1,p_created_by),
	sysdate,
    	DECODE(p_LAST_UPDATED_BY,null,-1,p_last_updated_by),
    	sysdate,
    	DECODE(p_LAST_UPDATE_LOGIN,null,-1,p_last_update_login)
	);

Line: 166

PROCEDURE delete_item (p_api_version_number    IN   NUMBER,
 		  	      p_init_msg_list  IN   VARCHAR2 ,
		    	      p_commit	    IN   VARCHAR2 ,
			 p_email_account_id IN   NUMBER,
  			 p_classification_id	IN   NUMBER,
		      p_message_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: 198

	DELETE FROM IEM_EMAIL_CLASSIFICATIONS
	where message_id=p_message_id
	and   classification_id=p_classification_id
	and email_account_id=p_email_account_id;

Line: 220

	--ROLLBACK TO delete_item_PVT;

Line: 227

	--ROLLBACK TO delete_item_PVT;

Line: 259

 SELECT    a.classification_id,b.intent,a.score
 FROM      IEM_EMAIL_CLASSIFICATIONS a,IEM_INTENTS b
 WHERE     a.classification_id=b.intent_id
 AND       a.message_id = p_message_id
 AND       a.email_account_id = p_email_account_id;

Line: 357

 SELECT    a.classification_id,b.intent,a.score
 FROM      IEM_EMAIL_CLASSIFICATIONS a,IEM_INTENTS b
 WHERE     a.classification_id=b.intent_id
 AND       a.message_id = p_message_id
 AND       a.email_account_id = p_email_account_id;

Line: 382

	select category_map_id into l_category_map_id
	FROM IEM_RT_PROC_EMAILS
	WHERE MESSAGE_ID=p_message_id;

Line: 483

         p_LAST_UPDATED_BY    NUMBER ,
         p_LAST_UPDATE_DATE    DATE,
     p_LAST_UPDATE_LOGIN    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):='create_item';

Line: 512

   select count(*) into l_count from iem_email_classifications
   where message_id=p_message_id
   and classification_id=p_classification_id;

Line: 516

	INSERT INTO IEM_EMAIL_CLASSIFICATIONS
	(
	MESSAGE_ID,
	EMAIL_ACCOUNT_ID ,
	CLASSIFICATION_ID ,
	SCORE   ,
	CLASSIFICATION_STRING,
	CREATED_BY  ,
	CREATION_DATE ,
	LAST_UPDATED_BY ,
	LAST_UPDATE_DATE ,
	LAST_UPDATE_LOGIN
	)
	VALUES
	(
	p_message_id,
	p_email_account_id,
	p_classification_id,
	p_score,
	p_class_string,
    	DECODE(p_created_by,null,-1,p_created_by),
	sysdate,
    	DECODE(p_LAST_UPDATED_BY,null,-1,p_last_updated_by),
    	sysdate,
    	DECODE(p_LAST_UPDATE_LOGIN,null,-1,p_last_update_login)
	);