The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID') ) ;
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;
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;
SELECT IEM_DP_LOGS_S1.nextval
INTO l_seq_id
FROM dual;
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)
);