APPS.XNP_MSG_DIAGNOSTICS$XNP_MSGS SQL Statements

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

Line: 50

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

Line: 52

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

Line: 53

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

Line: 55

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

Line: 56

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

Line: 222

      select L_MTE.MSG_CODE
      into   CURR_VAL.MSG_CODE
      from   XNP_MSG_TYPES_B L_MTE
      where  rownum = 1
      and   ( L_MTE.MSG_CODE = P_MSG_CODE )
      and   ( L_MTE.MSG_TYPE = P_L_MTE_MSG_TYPE );

Line: 362

               select L_MTE.MSG_CODE MSG_CODE
               ,      L_MTE.MSG_TYPE L_MTE_MSG_TYPE
               ,      L_MTE.PRIORITY PRIORITY
               ,      L_MTE.LAST_COMPILED_DATE LAST_COMPILED_DATE
               ,      L_MTE.DEFAULT_PROCESS_LOGIC L_MTE_DEFAULT_PROCESS_LOGIC
               ,      L_MTE.IN_PROCESS_LOGIC L_MTE_IN_PROCESS_LOGIC
               ,      L_MTE.VALIDATE_LOGIC L_MTE_VALIDATE_LOGIC
               ,      L_MTE.OUT_PROCESS_LOGIC L_MTE_OUT_PROCESS_LOGIC
               from   XNP_MSG_TYPES_B L_MTE
               where  L_MTE.MSG_CODE like upper(srch)
               order by L_MTE.MSG_CODE;

Line: 568

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

Line: 641

      ZONE_SQL := 'SELECT MSG.MSG_ID,
                         ''xnp_web_utils.show_msg_body?p_msg_id=''||MSG.MSG_ID,
                         MSG.MSG_CODE,
                         MSG.MSG_STATUS,
                         MSG.DIRECTION_INDICATOR,
                         MSG.REFERENCE_ID,
                         MSG.OPP_REFERENCE_ID,
                         MSG.MSG_VERSION,
                         MSG.MSG_CREATION_DATE,
                         MSG.SEND_RCV_DATE,
                         MSG.RECIPIENT_NAME,
                         MSG.SENDER_NAME,
                         MSG.ADAPTER_NAME,
                         MSG.FE_NAME
                  FROM   XNP_MSGS MSG,
                         XNP_MSG_TYPES_B L_MTE';

Line: 898

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
                             'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);

Line: 901

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
                             'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);

Line: 1098

         SELECT L_MTE.MSG_TYPE,
                L_MTE.PRIORITY,
                L_MTE.LAST_COMPILED_DATE,
--                decode (MSG.MSG_STATUS, 'FAILED',  'xnp_message.fix?p_msg_id='||MSG.MSG_ID, NULL),
                decode (MSG.MSG_STATUS, 'FAILED',  ' xnp_msg_diagnostics$xnp_msgs.retry_message', NULL),
                L_MTE.DEFAULT_PROCESS_LOGIC,
                L_MTE.IN_PROCESS_LOGIC,
                L_MTE.VALIDATE_LOGIC,
                L_MTE.OUT_PROCESS_LOGIC
         INTO   NBT_VAL.L_MTE_MSG_TYPE,
                NBT_VAL.PRIORITY,
                NBT_VAL.LAST_COMPILED_DATE,
                NBT_VAL.RESEND_LINK,
                NBT_VAL.L_MTE_DEFAULT_PROCESS_LOGIC,
                NBT_VAL.L_MTE_IN_PROCESS_LOGIC,
                NBT_VAL.L_MTE_VALIDATE_LOGIC,
                NBT_VAL.L_MTE_OUT_PROCESS_LOGIC
         FROM   XNP_MSGS MSG,
                XNP_MSG_TYPES_B L_MTE
         WHERE  MSG.MSG_ID = CURR_VAL.MSG_ID
         AND    L_MTE.MSG_CODE = MSG.MSG_CODE
         ;

Line: 1123

         SELECT MSG.MSG_ID,
                MSG.MSG_CODE,
                L_MTE.MSG_TYPE,
                MSG.MSG_STATUS,
                MSG.DIRECTION_INDICATOR,
                MSG.REFERENCE_ID,
                MSG.OPP_REFERENCE_ID,
                MSG.MSG_VERSION,
                MSG.MSG_CREATION_DATE,
                MSG.SEND_RCV_DATE,
                MSG.RECIPIENT_NAME,
                MSG.SENDER_NAME,
                MSG.ADAPTER_NAME,
                MSG.FE_NAME,
                MSG.ORDER_ID,
                MSG.WI_INSTANCE_ID,
                MSG.FA_INSTANCE_ID,
                L_MTE.PRIORITY,
                L_MTE.LAST_COMPILED_DATE,
                MSG.DESCRIPTION,
--                decode (MSG.MSG_STATUS, 'FAILED',  'xnp_message.fix?p_msg_id='||MSG.MSG_ID, NULL),
                decode (MSG.MSG_STATUS, 'FAILED',  ' xnp_msg_diagnostics$xnp_msgs.retry_message', NULL),
                MSG.BODY_TEXT,
                L_MTE.DEFAULT_PROCESS_LOGIC,
                L_MTE.IN_PROCESS_LOGIC,
                L_MTE.VALIDATE_LOGIC,
                L_MTE.OUT_PROCESS_LOGIC
         INTO   CURR_VAL.MSG_ID,
                CURR_VAL.MSG_CODE,
                NBT_VAL.L_MTE_MSG_TYPE,
                CURR_VAL.MSG_STATUS,
                CURR_VAL.DIRECTION_INDICATOR,
                CURR_VAL.REFERENCE_ID,
                CURR_VAL.OPP_REFERENCE_ID,
                CURR_VAL.MSG_VERSION,
                CURR_VAL.MSG_CREATION_DATE,
                CURR_VAL.SEND_RCV_DATE,
                CURR_VAL.RECIPIENT_NAME,
                CURR_VAL.SENDER_NAME,
                CURR_VAL.ADAPTER_NAME,
                CURR_VAL.FE_NAME,
                CURR_VAL.ORDER_ID,
                CURR_VAL.WI_INSTANCE_ID,
                CURR_VAL.FA_INSTANCE_ID,
                NBT_VAL.PRIORITY,
                NBT_VAL.LAST_COMPILED_DATE,
                CURR_VAL.DESCRIPTION,
                NBT_VAL.RESEND_LINK,
                CURR_VAL_BODY_TEXT, -- CLOB changes --
                NBT_VAL.L_MTE_DEFAULT_PROCESS_LOGIC,
                NBT_VAL.L_MTE_IN_PROCESS_LOGIC,
                NBT_VAL.L_MTE_VALIDATE_LOGIC,
                NBT_VAL.L_MTE_OUT_PROCESS_LOGIC
         FROM   XNP_MSGS MSG,
                XNP_MSG_TYPES_B L_MTE
         WHERE  MSG.MSG_ID = CURR_VAL.MSG_ID
         AND    L_MTE.MSG_CODE = MSG.MSG_CODE
         ;

Line: 1194

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
                             'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);