APPS.IEM_OP_STAT_PUB dependencies on IEM_OP_THREAD_STATS

Line 193: from IEM_OP_THREAD_STATS where

189: WHERE CONTROLLER_ID = l_CONTROLLER_ID;
190:
191: BEGIN
192: select OP_THREAD_STATS_ID into l_OP_THREAD_STATS_ID
193: from IEM_OP_THREAD_STATS where
194: CONTROLLER_ID = l_CONTROLLER_ID
195: AND THREAD_ID = p_threadID AND THREAD_TYPE = p_threadType;
196: EXCEPTION
197: WHEN OTHERS THEN

Line 204: UPDATE IEM_OP_THREAD_STATS SET

200: END IF;
201:
202:
203: IF (l_OP_THREAD_STATS_ID > 0) THEN
204: UPDATE IEM_OP_THREAD_STATS SET
205: THREAD_ID = p_threadID,
206: LAST_UPDATE_DATE = SYSDATE,
207: THREAD_TYPE = p_threadType,
208: FAILED_REASON = p_tfailed_reason,

Line 212: select IEM_OP_THREAD_STATS_S1.nextval into l_th_sequence from dual;

208: FAILED_REASON = p_tfailed_reason,
209: PROCESSED_MSG_COUNT = p_processed_msg_cnt
210: WHERE OP_THREAD_STATS_ID = l_OP_THREAD_STATS_ID;
211: ELSE
212: select IEM_OP_THREAD_STATS_S1.nextval into l_th_sequence from dual;
213: insert into IEM_OP_THREAD_STATS
214: (
215: OP_THREAD_STATS_ID,
216: THREAD_ID,

Line 213: insert into IEM_OP_THREAD_STATS

209: PROCESSED_MSG_COUNT = p_processed_msg_cnt
210: WHERE OP_THREAD_STATS_ID = l_OP_THREAD_STATS_ID;
211: ELSE
212: select IEM_OP_THREAD_STATS_S1.nextval into l_th_sequence from dual;
213: insert into IEM_OP_THREAD_STATS
214: (
215: OP_THREAD_STATS_ID,
216: THREAD_ID,
217: CONTROLLER_ID,