APPS.IEM_RT_PREPROC_EMAILS_PVT SQL Statements

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

Line: 24

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

Line: 25

     l_LAST_UPDATE_DATE    DATE:=SYSDATE;

Line: 26

     l_LAST_UPDATE_LOGIN    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

Line: 38

INSERT INTO IEM_RT_PREPROC_EMAILS (
MESSAGE_ID           ,
email_account_id       ,
PRIORITY             ,
RECEIVED_DATE,
CREATED_BY          ,
CREATION_DATE       ,
LAST_UPDATED_BY     ,
LAST_UPDATE_DATE    ,
LAST_UPDATE_LOGIN
)
VALUES
(
p_message_id,
p_email_account_id,
p_priority,
p_received_date,
decode(l_CREATED_BY,null,-1,l_CREATED_BY),
sysdate,
decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
sysdate,
decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN)
 );

Line: 101

PROCEDURE delete_item (p_api_version_number    IN   NUMBER,
 		  	      p_init_msg_list  IN   VARCHAR2 ,
		    	      p_commit	    IN   VARCHAR2 ,
				 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: 122

	delete from IEM_RT_PREPROC_EMAILS
	where message_id=p_message_id;

Line: 136

	ROLLBACK TO delete_item_PVT;

Line: 143

	ROLLBACK TO delete_item_PVT;

Line: 150

	ROLLBACK TO delete_item_PVT;

Line: 165

 END	delete_item;