APPS.IEM_RT_PROC_EMAILS_PVT SQL Statements

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

Line: 38

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

Line: 39

     l_LAST_UPDATE_LOGIN	number:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;

Line: 58

INSERT INTO IEM_RT_PROC_EMAILS (
MESSAGE_ID           ,
EMAIL_ACCOUNT_ID    ,
PRIORITY             ,
resource_id,
GROUP_ID,
SENT_DATE            ,
RECEIVED_DATE,
RT_CLASSIFICATION_ID,
CUSTOMER_ID          ,
CONTACT_ID          ,
RELATIONSHIP_ID          ,
IH_INTERACTION_ID,
IH_MEDIA_ITEM_ID    ,
MSG_STATUS       ,
MAIL_ITEM_STATUS,
MAIL_PROC_STATUS,
CATEGORY_MAP_ID,
RULE_ID,
SUBJECT              ,
from_address          ,
from_resource_id,
CREATED_BY          ,
CREATION_DATE       ,
LAST_UPDATED_BY     ,
LAST_UPDATE_DATE    ,
LAST_UPDATE_LOGIN   ,
ATTRIBUTE1          ,
ATTRIBUTE2          ,
ATTRIBUTE3          ,
ATTRIBUTE4          ,
ATTRIBUTE5          ,
ATTRIBUTE6          ,
ATTRIBUTE7        ,
ATTRIBUTE8        ,
ATTRIBUTE9        ,
ATTRIBUTE10       ,
ATTRIBUTE11       ,
ATTRIBUTE12       ,
ATTRIBUTE13       ,
ATTRIBUTE14       ,
ATTRIBUTE15
)
VALUES
(
p_message_id,
p_email_account_id ,
p_priority  ,
p_agent_id ,
p_group_id ,
p_sent_date,
p_received_date,
p_rt_classification_id,
p_customer_id   ,
p_contact_id   ,
p_relationship_id   ,
p_interaction_id,
p_ih_media_item_id ,
p_msg_status ,
p_mail_item_status,
p_mail_proc_status,
p_category_map_id,
p_rule_id,
p_subject ,
p_sender_address ,
p_from_agent_id,
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),
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null
 );

Line: 185

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

	delete from IEM_POST_MDTS
	where message_id=p_message_id;

Line: 225

	ROLLBACK TO delete_item_PVT;

Line: 232

	ROLLBACK TO delete_item_PVT;

Line: 239

	ROLLBACK TO delete_item_PVT;

Line: 254

 END	delete_item;