DBA Data[Home] [Help]

APPS.IEM_DP_LOG_PVT SQL Statements

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

Line: 17

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

G_LAST_UPDATE_LOGIN    NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;
Line: 105

   select count(DP_LOG_ID) into l_log_id
   		  from iem_DP_LOGS
   		  where EMAIL_ACCOUNT_ID = P_acct_id
   		  and NVL(ERROR_CODE, l_error_code) = l_error_code
		  and NVL(RFC822_MESSAGE_ID,l_RFC_msg_ID)=l_RFC_msg_ID
   		  and NVL(ERROR_MESSAGE, l_error_msg)=l_error_msg;
Line: 118

   	  update IEM_DP_LOGS set LAST_UPDATE_DATE=sysdate
   	  	  where EMAIL_ACCOUNT_ID = P_acct_id
   		  and NVL(ERROR_CODE, l_error_code) = l_error_code
		  and NVL(RFC822_MESSAGE_ID,l_RFC_msg_ID)=l_RFC_msg_ID
   		  and NVL(ERROR_MESSAGE, l_error_msg)=l_error_msg;
Line: 126

   	SELECT IEM_DP_LOGS_S1.nextval
	INTO l_seq_id
	FROM dual;
Line: 130

	INSERT INTO IEM_DP_LOGS
	(
	DP_LOG_ID,
	EMAIL_ACCOUNT_ID,
	ERROR_CODE,
	ERROR_MESSAGE,
	MSG_SUBJECT,
	MSG_RECEIVED_DATE,
	RFC822_MESSAGE_ID,
    CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
	)
	VALUES
	(
	l_seq_id,
	P_ACCT_ID,
	P_error_code,
	l_error_msg,
    l_subject,
	p_received_date,
    l_RFC_msg_ID,
    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)
	);