APPS.IEM_DP_LOG_PVT dependencies on IEM_DP_LOGS

Line 106: from iem_DP_LOGS

102: l_RFC_msg_ID := substr(p_RFC_msg_ID,1,256);
103: end if;
104:
105: select count(DP_LOG_ID) into l_log_id
106: from iem_DP_LOGS
107: where EMAIL_ACCOUNT_ID = P_acct_id
108: and NVL(ERROR_CODE, l_error_code) = l_error_code
109: and NVL(RFC822_MESSAGE_ID,l_RFC_msg_ID)=l_RFC_msg_ID
110: and NVL(ERROR_MESSAGE, l_error_msg)=l_error_msg;

Line 118: update IEM_DP_LOGS set LAST_UPDATE_DATE=sysdate

114: null;
115: end ;
116:
117: if l_log_id <> 0 then
118: update IEM_DP_LOGS set LAST_UPDATE_DATE=sysdate
119: where EMAIL_ACCOUNT_ID = P_acct_id
120: and NVL(ERROR_CODE, l_error_code) = l_error_code
121: and NVL(RFC822_MESSAGE_ID,l_RFC_msg_ID)=l_RFC_msg_ID
122: and NVL(ERROR_MESSAGE, l_error_msg)=l_error_msg;

Line 126: SELECT IEM_DP_LOGS_S1.nextval

122: and NVL(ERROR_MESSAGE, l_error_msg)=l_error_msg;
123: else
124:
125: --get next sequential number
126: SELECT IEM_DP_LOGS_S1.nextval
127: INTO l_seq_id
128: FROM dual;
129:
130: INSERT INTO IEM_DP_LOGS

Line 130: INSERT INTO IEM_DP_LOGS

126: SELECT IEM_DP_LOGS_S1.nextval
127: INTO l_seq_id
128: FROM dual;
129:
130: INSERT INTO IEM_DP_LOGS
131: (
132: DP_LOG_ID,
133: EMAIL_ACCOUNT_ID,
134: ERROR_CODE,