APPS.IEM_OP_STAT_PUB SQL Statements

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

Line: 60

   select IEM_OP_CONTROLLER_STATS_S1.nextval into l_con_sequence from dual;

Line: 66

   insert into IEM_OP_CONTROLLER_STATS
   (
     CONTROLLER_ID,
     JSERV_ID,
     JSERV_PORT,
     APACHE_HOST,
     APACHE_PORT,
     START_TIME,
     FAILED_REASON,
     LAST_UPDATE_DATE
   )
   values
   (
     l_CONTROLLER_ID,
     p_jservID,
     p_jservPort,
     p_apacheHost,
     p_apachePort,
     SYSDATE,
     p_cfailed_reason,
     SYSDATE
   );

Line: 187

     UPDATE IEM_OP_CONTROLLER_STATS SET
       LAST_UPDATE_DATE = SYSDATE
     WHERE CONTROLLER_ID = l_CONTROLLER_ID;

Line: 192

     select OP_THREAD_STATS_ID into l_OP_THREAD_STATS_ID
       from IEM_OP_THREAD_STATS where
       CONTROLLER_ID = l_CONTROLLER_ID
       AND THREAD_ID = p_threadID AND THREAD_TYPE = p_threadType;

Line: 204

     UPDATE IEM_OP_THREAD_STATS SET
       THREAD_ID = p_threadID,
       LAST_UPDATE_DATE = SYSDATE,
       THREAD_TYPE = p_threadType,
       FAILED_REASON = p_tfailed_reason,
       PROCESSED_MSG_COUNT = p_processed_msg_cnt
     WHERE OP_THREAD_STATS_ID = l_OP_THREAD_STATS_ID;

Line: 212

     select IEM_OP_THREAD_STATS_S1.nextval into l_th_sequence from dual;

Line: 213

     insert into IEM_OP_THREAD_STATS
     (
       OP_THREAD_STATS_ID,
       THREAD_ID,
       CONTROLLER_ID,
       START_TIME,
       PROCESSED_MSG_COUNT,
       THREAD_TYPE,
       FAILED_REASON,
       LAST_UPDATE_DATE
     )
     values
     (
       l_th_sequence,
       p_threadID,
       l_CONTROLLER_ID,
       SYSDATE,
       p_processed_msg_cnt,
       p_threadType,
       p_tfailed_reason,
       SYSDATE
    );