APPS.IEM_PP_QUEUE_PVT SQL Statements

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

Line: 24

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

Line: 25

G_LAST_UPDATE_LOGIN    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;

Line: 85

   	SELECT IEM_RT_PP_QUEUES_s1.nextval
	INTO l_seq_id
	FROM dual;

Line: 89

	INSERT INTO IEM_RT_PP_QUEUES
	(
	EMAIL_ID,
	MSG_UID,
	EMAIL_ACCOUNT_ID,
    SUBJECT,
    FROM_ADDRESS,
    MSG_SIZE ,
    FLAG,
    RETRY_COUNT,
    ACTION,
	RFC822_MESSAGE_ID,
	RECEIVED_DATE,
    CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
	)
	VALUES
	(
	l_seq_id,
	p_msg_uid,
	p_email_acct_id,
	p_subject,
    p_from,
    p_size,
    p_flag,
    p_retry_count,
    l_action,
	substr(p_rfc822_msgId,1,256),   -- Fix for bug 6633789
	p_received_date,
    decode(G_created_updated_by,null,-1,G_created_updated_by),
	sysdate,
    decode(G_created_updated_by,null,-1,G_created_updated_by),
    sysdate,
    decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
	);

Line: 132

	INSERT INTO IEM_RT_PP_QUEUE_DTLS
	(
	EMAIL_ID,
	ATTACHMENT_NAME,
	ATTACHMENT_SIZE,
    	ATTACHMENT_TYPE,
    	CREATED_BY,
     CREATION_DATE,
    LAST_UPDATED_BY,
   	LAST_UPDATE_DATE,
   	LAST_UPDATE_LOGIN
	)
	VALUES
	(
	l_seq_id,
	p_attach_name_tbl(i),
	decode(p_attach_size_tbl(i), null, 0, to_number(p_attach_size_tbl(i))),
	p_attach_type_tbl(i),
	decode(G_created_updated_by,null,-1,G_created_updated_by),
    sysdate,
   	decode(G_created_updated_by,null,-1,G_created_updated_by),
   	sysdate,
   	decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
	);

Line: 265

	for x in ( select email_id
 	from IEM_RT_PP_QUEUES
    where flag = 'N' and retry_count < 5
 	order by creation_date)
    LOOP
        BEGIN
	        select * into l_queue_rec from IEM_RT_PP_QUEUES
	        where email_id=x.email_id and flag = 'N' FOR UPDATE NOWAIT;

Line: 285

        update IEM_RT_PP_QUEUES set flag ='A', retry_count=retry_count+1 where email_id=l_queue_rec.email_id;

Line: 384

	 delete IEM_RT_PP_QUEUE_DTLS where email_id in
	 		( select email_id from iem_rt_pp_queues where flag = 'S'
			  and email_account_id=p_acct_id );

Line: 388

	 delete IEM_RT_PP_QUEUES where flag = 'S' and email_account_id=p_acct_id ;

Line: 506

   for y in ( select  email_account_id, count(*) total,
  	  	   	 nvl(max(sysdate-creation_date),0) wait_time
 			 from IEM_RT_PP_QUEUES
    		 where flag = 'N' and retry_count < 5
 	 		 group by  email_account_id order by wait_time desc )
   loop

	 l_acct_id := y.email_account_id;

Line: 515

	 FOR x in ( select email_id
 	 	from IEM_RT_PP_QUEUES
    	where flag = 'N' and retry_count < 5 and email_account_id=y.email_account_id
 		order by creation_date)
     LOOP

		BEGIN
	        select * into l_queue_rec from IEM_RT_PP_QUEUES
	        where email_id=x.email_id and flag = 'N' FOR UPDATE NOWAIT;

Line: 537

			update IEM_RT_PP_QUEUES set flag ='A', retry_count=retry_count+1
				   where email_id=l_queue_rec.email_id;

Line: 661

	   select count(*) into l_count from iem_rt_pp_queues
		   where EMAIL_ID= p_queue_ids(j) and retry_count > 4;

Line: 665

   	   	   update iem_rt_pp_queues set flag=p_flag where EMAIL_ID= p_queue_ids(j);

Line: 667

	   		   update iem_rt_pp_queues set flag='N' where EMAIL_ID= p_queue_ids(j);

Line: 759

   update iem_rt_pp_queues set flag='N' where flag='A' and retry_count<=4;