APPS.XNP_TIMERS$XNP_TIMER_REGISTRY SQL Statements

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

Line: 46

   VF_UPDATE_BUT_CAPTION  constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);

Line: 48

   VF_DELETE_BUT_CAPTION  constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);

Line: 49

   VF_UPDATE_BUT_ACTION   constant varchar2(10)  := 'UPDATE';

Line: 51

   VF_DELETE_BUT_ACTION   constant varchar2(10)  := 'DELETE';

Line: 52

   VF_VERIFIED_DELETE     constant varchar2(100) := 'VerifiedDelete';

Line: 163

      select MESSAGE_TYPES_2.MSG_CODE
      into   CURR_VAL.TIMER_MESSAGE_CODE
      from   XNP_MSG_TYPES_B MESSAGE_TYPES_2
      where  rownum = 1
      and   ( MESSAGE_TYPES_2.MSG_CODE = P_TIMER_MESSAGE_CODE )
      and    MSG_TYPE = 'TIMER';

Line: 198

      select MSG_CODE
      into   CURR_VAL.NEXT_TIMER
      from   XNP_MSG_TYPES_B
      where  rownum = 1
      and    MSG_TYPE = 'TIMER'
      and   ( MSG_CODE = P_NEXT_TIMER
      or     (MSG_CODE is null and P_NEXT_TIMER is null) );

Line: 339

               select MESSAGE_TYPES_2.MSG_CODE TIMER_MESSAGE_CODE
               from   XNP_MSG_TYPES_B MESSAGE_TYPES_2
               where  ((MESSAGE_TYPES_2.MSG_CODE like uu||'%' or
                        MESSAGE_TYPES_2.MSG_CODE like ul||'%' or
                        MESSAGE_TYPES_2.MSG_CODE like lu||'%' or
                        MESSAGE_TYPES_2.MSG_CODE like ll||'%') and
                        upper(MESSAGE_TYPES_2.MSG_CODE) like upper(srch))
               and    MSG_TYPE = 'TIMER'
               order by MESSAGE_TYPES_2.MSG_CODE;

Line: 493

               select MSG_CODE NEXT_TIMER
               from   XNP_MSG_TYPES_B
               where  ((MSG_CODE like uu||'%' or
                        MSG_CODE like ul||'%' or
                        MSG_CODE like lu||'%' or
                        MSG_CODE like ll||'%') and
                        upper(MSG_CODE) like upper(srch))
               and    MSG_TYPE = 'TIMER'
               order by MSG_CODE;

Line: 680

      I_QUERY := 'SELECT count(*)' ||
                 substr(ZONE_SQL, I_FROM_POS);

Line: 762

      ZONE_SQL := 'SELECT TIMER_REGISTRY.TIMER_ID,
                         TIMER_REGISTRY.ORDER_ID,
                         TIMER_REGISTRY.REFERENCE_ID,
                         ''xnp_web_utils.show_msg_body?p_msg_id=''||TIMER_REGISTRY.TIMER_ID,
                         TIMER_REGISTRY.TIMER_MESSAGE_CODE,
                         TIMER_REGISTRY.STATUS,
                         TIMER_REGISTRY.START_TIME,
                         TIMER_REGISTRY.END_TIME,
                         TIMER_REGISTRY.NEXT_TIMER
                  FROM   XNP_TIMER_REGISTRY TIMER_REGISTRY,
                         XNP_MSG_TYPES_B MESSAGE_TYPES_2';

Line: 956

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
                             'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);

Line: 959

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
                             'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);

Line: 1074

         SELECT TIMER_REGISTRY.TIMER_ID,
                TIMER_REGISTRY.ORDER_ID,
                TIMER_REGISTRY.REFERENCE_ID,
                TIMER_REGISTRY.WI_INSTANCE_ID,
                TIMER_REGISTRY.FA_INSTANCE_ID,
                TIMER_REGISTRY.TIMER_MESSAGE_CODE,
                TIMER_REGISTRY.STATUS,
                TIMER_REGISTRY.START_TIME,
                TIMER_REGISTRY.END_TIME,
                TIMER_REGISTRY.NEXT_TIMER
         INTO   CURR_VAL.TIMER_ID,
                CURR_VAL.ORDER_ID,
                CURR_VAL.REFERENCE_ID,
                CURR_VAL.WI_INSTANCE_ID,
                CURR_VAL.FA_INSTANCE_ID,
                CURR_VAL.TIMER_MESSAGE_CODE,
                CURR_VAL.STATUS,
                CURR_VAL.START_TIME,
                CURR_VAL.END_TIME,
                CURR_VAL.NEXT_TIMER
         FROM   XNP_TIMER_REGISTRY TIMER_REGISTRY,
                XNP_MSG_TYPES_B MESSAGE_TYPES_2
         WHERE  TIMER_REGISTRY.TIMER_ID = CURR_VAL.TIMER_ID
         AND    MESSAGE_TYPES_2.MSG_CODE = TIMER_REGISTRY.TIMER_MESSAGE_CODE
         ;

Line: 1112

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
                             'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);