APPS.XNP_NUMBER_SPLITS$NUMBER_SPLIT SQL Statements

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

Line: 49

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

Line: 51

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

Line: 52

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

Line: 54

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

Line: 55

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

Line: 129

      select L_NRE2.NUMBER_RANGE_ID
      into   CURR_VAL.NEW_NUMBER_RANGE_ID
      from   XNP_NUMBER_RANGES L_NRE2
      where  rownum = 1
      and   ( L_NRE2.OBJECT_REFERENCE = P_L_NRE2_OBJECT_REFERENCE )
      and   ( L_NRE2.STARTING_NUMBER = P_L_NRE2_STARTING_NUMBER )
      and   ( L_NRE2.ENDING_NUMBER = P_L_NRE2_ENDING_NUMBER );

Line: 167

      select L_NRE.NUMBER_RANGE_ID
      into   CURR_VAL.OLD_NUMBER_RANGE_ID
      from   XNP_NUMBER_RANGES L_NRE
      where  rownum = 1
      and   ( L_NRE.OBJECT_REFERENCE = P_L_NRE_OBJECT_REFERENCE )
      and   ( L_NRE.STARTING_NUMBER = P_L_NRE_STARTING_NUMBER )
      and   ( L_NRE.ENDING_NUMBER = P_L_NRE_ENDING_NUMBER );

Line: 308

               select L_NRE2.NUMBER_RANGE_ID NEW_NUMBER_RANGE_ID
               ,      L_NRE2.OBJECT_REFERENCE L_NRE2_OBJECT_REFERENCE
               ,      L_NRE2.STARTING_NUMBER L_NRE2_STARTING_NUMBER
               ,      L_NRE2.ENDING_NUMBER L_NRE2_ENDING_NUMBER
               from   XNP_NUMBER_RANGES L_NRE2
               where  L_NRE2.OBJECT_REFERENCE like upper(srch)
               order by L_NRE2.OBJECT_REFERENCE;

Line: 464

               select L_NRE.NUMBER_RANGE_ID OLD_NUMBER_RANGE_ID
               ,      L_NRE.OBJECT_REFERENCE L_NRE_OBJECT_REFERENCE
               ,      L_NRE.STARTING_NUMBER L_NRE_STARTING_NUMBER
               ,      L_NRE.ENDING_NUMBER L_NRE_ENDING_NUMBER
               from   XNP_NUMBER_RANGES L_NRE
               where  L_NRE.OBJECT_REFERENCE like upper(srch)
               order by L_NRE.OBJECT_REFERENCE;

Line: 562

     L_QRY_FIRST_ACTION varchar2(12) := 'INSERTIFNONE';

Line: 767

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

Line: 841

      ZONE_SQL := 'SELECT NST.NUMBER_SPLIT_ID,
                         L_NRE.OBJECT_REFERENCE,
                         L_NRE2.OBJECT_REFERENCE,
                         NST.PERMISSIVE_DIAL_START_DATE,
                         NST.PERMISSIVE_DIAL_END_DATE
                  FROM   XNP_NUMBER_SPLITS NST,
                         XNP_NUMBER_RANGES L_NRE,
                         XNP_NUMBER_RANGES L_NRE2';

Line: 1041

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
                             'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);

Line: 1044

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
                             'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);

Line: 1147

         SELECT L_NRE.OBJECT_REFERENCE,
                L_NRE2.OBJECT_REFERENCE,
                L_NRE.STARTING_NUMBER,
                L_NRE.ENDING_NUMBER,
                L_NRE2.STARTING_NUMBER,
                L_NRE2.ENDING_NUMBER
         INTO   NBT_VAL.L_NRE_OBJECT_REFERENCE,
                NBT_VAL.L_NRE2_OBJECT_REFERENCE,
                NBT_VAL.L_NRE_STARTING_NUMBER,
                NBT_VAL.L_NRE_ENDING_NUMBER,
                NBT_VAL.L_NRE2_STARTING_NUMBER,
                NBT_VAL.L_NRE2_ENDING_NUMBER
         FROM   XNP_NUMBER_SPLITS NST,
                XNP_NUMBER_RANGES L_NRE,
                XNP_NUMBER_RANGES L_NRE2
         WHERE  NST.NUMBER_SPLIT_ID = CURR_VAL.NUMBER_SPLIT_ID
         AND    L_NRE.NUMBER_RANGE_ID = NST.OLD_NUMBER_RANGE_ID
         AND    L_NRE2.NUMBER_RANGE_ID = NST.NEW_NUMBER_RANGE_ID
         ;

Line: 1169

         SELECT NST.NUMBER_SPLIT_ID,
                NST.NEW_NUMBER_RANGE_ID,
                NST.OLD_NUMBER_RANGE_ID,
                L_NRE.OBJECT_REFERENCE,
                L_NRE2.OBJECT_REFERENCE,
                NST.PERMISSIVE_DIAL_START_DATE,
                NST.PERMISSIVE_DIAL_END_DATE,
                L_NRE.STARTING_NUMBER,
                L_NRE.ENDING_NUMBER,
                L_NRE2.STARTING_NUMBER,
                L_NRE2.ENDING_NUMBER,
                NST.CONVERSION_PROCEDURE
         INTO   CURR_VAL.NUMBER_SPLIT_ID,
                CURR_VAL.NEW_NUMBER_RANGE_ID,
                CURR_VAL.OLD_NUMBER_RANGE_ID,
                NBT_VAL.L_NRE_OBJECT_REFERENCE,
                NBT_VAL.L_NRE2_OBJECT_REFERENCE,
                CURR_VAL.PERMISSIVE_DIAL_START_DATE,
                CURR_VAL.PERMISSIVE_DIAL_END_DATE,
                NBT_VAL.L_NRE_STARTING_NUMBER,
                NBT_VAL.L_NRE_ENDING_NUMBER,
                NBT_VAL.L_NRE2_STARTING_NUMBER,
                NBT_VAL.L_NRE2_ENDING_NUMBER,
                CURR_VAL.CONVERSION_PROCEDURE
         FROM   XNP_NUMBER_SPLITS NST,
                XNP_NUMBER_RANGES L_NRE,
                XNP_NUMBER_RANGES L_NRE2
         WHERE  NST.NUMBER_SPLIT_ID = CURR_VAL.NUMBER_SPLIT_ID
         AND    L_NRE.NUMBER_RANGE_ID = NST.OLD_NUMBER_RANGE_ID
         AND    L_NRE2.NUMBER_RANGE_ID = NST.NEW_NUMBER_RANGE_ID
         ;

Line: 1211

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
                             'View Number Splits'||' : '||'Number Split Details', VF_BODY_ATTRIBUTES);