APPS.XNP_SV_NETWORK$SMS_SV SQL Statements

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

Line: 30

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

Line: 32

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

Line: 33

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

Line: 35

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

Line: 36

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

Line: 224

     L_QRY_FIRST_ACTION varchar2(12) := 'INSERTIFNONE';

Line: 394

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

Line: 441

      ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,
                         XNP_SV_SMS_V.PORTING_ID,
                         XNP_SV_SMS_V.SUBSCRIPTION_TN,
                         XNP_SV_SMS_V.ROUTING_NUMBER
                  FROM   XNP_SV_SMS_V XNP_SV_SMS_V';

Line: 636

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
                             'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);

Line: 639

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
                             'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);

Line: 801

         SELECT XNP_SV_SMS_V.SV_SMS_ID,
                XNP_SV_SMS_V.PORTING_ID,
                XNP_SV_SMS_V.ROUTING_NUMBER_ID,
                XNP_SV_SMS_V.SUBSCRIPTION_TYPE,
                XNP_SV_SMS_V.SUBSCRIPTION_TN,
                XNP_SV_SMS_V.MEDIATOR_SP_ID,
                XNP_SV_SMS_V.ROUTING_NUMBER,
                XNP_SV_SMS_V.PROVISION_SENT_DATE,
                XNP_SV_SMS_V.CNAM_ADDRESS,
                XNP_SV_SMS_V.CNAM_SUBSYSTEM,
                XNP_SV_SMS_V.ISVM_ADDRESS,
                XNP_SV_SMS_V.ISVM_SUBSYSTEM,
                XNP_SV_SMS_V.LIDB_ADDRESS,
                XNP_SV_SMS_V.LIDB_SUBSYSTEM,
                XNP_SV_SMS_V.CLASS_ADDRESS,
                XNP_SV_SMS_V.CLASS_SUBSYSTEM,
                XNP_SV_SMS_V.WSMSC_ADDRESS,
                XNP_SV_SMS_V.WSMSC_SUBSYSTEM,
                XNP_SV_SMS_V.RN_ADDRESS,
                XNP_SV_SMS_V.RN_SUBSYSTEM,
                XNP_SV_SMS_V.PROVISION_DONE_DATE,
                XNP_SV_SMS_V.NRC_CODE,
                XNP_SV_SMS_V.NRC_NAME,
                XNP_SV_SMS_V.NRC_INTERNET,
                XNP_SV_SMS_V.ROUTING_REF,
                XNP_SV_SMS_V.ROUTING_SP_ID,
                XNP_SV_SMS_V.REC_SP_ID,
                XNP_SV_SMS_V.REC_CODE,
                XNP_SV_SMS_V.REC_NAME,
                XNP_SV_SMS_V.REC_INTERNET,
                XNP_SV_SMS_V.REC_EMAIL,
                XNP_SV_SMS_V.NRC_EMAIL,
                XNP_SV_SMS_V.INTERCONNECT_TYPE
         INTO   CURR_VAL.SV_SMS_ID,
                CURR_VAL.PORTING_ID,
                CURR_VAL.ROUTING_NUMBER_ID,
                CURR_VAL.SUBSCRIPTION_TYPE,
                CURR_VAL.SUBSCRIPTION_TN,
                CURR_VAL.MEDIATOR_SP_ID,
                CURR_VAL.ROUTING_NUMBER,
                CURR_VAL.PROVISION_SENT_DATE,
                CURR_VAL.CNAM_ADDRESS,
                CURR_VAL.CNAM_SUBSYSTEM,
                CURR_VAL.ISVM_ADDRESS,
                CURR_VAL.ISVM_SUBSYSTEM,
                CURR_VAL.LIDB_ADDRESS,
                CURR_VAL.LIDB_SUBSYSTEM,
                CURR_VAL.CLASS_ADDRESS,
                CURR_VAL.CLASS_SUBSYSTEM,
                CURR_VAL.WSMSC_ADDRESS,
                CURR_VAL.WSMSC_SUBSYSTEM,
                CURR_VAL.RN_ADDRESS,
                CURR_VAL.RN_SUBSYSTEM,
                CURR_VAL.PROVISION_DONE_DATE,
                CURR_VAL.NRC_CODE,
                CURR_VAL.NRC_NAME,
                CURR_VAL.NRC_INTERNET,
                CURR_VAL.ROUTING_REF,
                CURR_VAL.ROUTING_SP_ID,
                CURR_VAL.REC_SP_ID,
                CURR_VAL.REC_CODE,
                CURR_VAL.REC_NAME,
                CURR_VAL.REC_INTERNET,
                CURR_VAL.REC_EMAIL,
                CURR_VAL.NRC_EMAIL,
                CURR_VAL.INTERCONNECT_TYPE
         FROM   XNP_SV_SMS_V XNP_SV_SMS_V
         WHERE  XNP_SV_SMS_V.SV_SMS_ID = CURR_VAL.SV_SMS_ID
         ;

Line: 890

         XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
                             'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);