APPS.IEM_TEMP_STORES_PVT SQL Statements

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

Line: 46

INSERT INTO iem_temp_stores (
MESSAGE_ID           ,
email_account_id       ,
FOLDER_NAME,
FROM_STR	,
RFC822_MESSAGE_ID,
REPLY_TO_STR	,
TO_STR		,
CC_STR		,
BCC_STR		,
SENT_DATE	,
SUBJECT		,
MESSAGE_SIZE	,
MIG_STATUS	,
MIG_ERROR_TEXT	,
MESSAGE_TEXT	,
MESSAGE_CONTENT
)
VALUES
(
p_message_id,
p_email_account_id,
p_FOLDER_NAME,
p_FROM_STR	,
p_RFC822,
p_REPLY_TO ,
p_TO		,
p_CC		,
p_BCC		,
p_SENT_DATE	,
p_SUBJECT		,
p_MESSAGE_SIZE	,
p_MIG_STATUS	,
p_MIG_ERROR_TEXT	,
p_MESSAGE_TEXT	,
p_MESSAGE_CONTENT
 );

Line: 123

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: 146

	delete from iem_temp_stores
	where message_id=p_message_id;

Line: 160

	ROLLBACK TO delete_item_PVT;

Line: 167

	ROLLBACK TO delete_item_PVT;

Line: 174

	ROLLBACK TO delete_item_PVT;

Line: 189

 END	delete_item;