Edit D:\app\Administrator\product\11.2.0\dbhome_1\jlib\oracle\sysman\vdv\VdvConstants.class

??���/�?�?�?
��?	�	�?�?	�	�?�?	�	�?�?�?�PAGING_CARRIER�Ljava/lang/String;�
PAGING_PIN�PAGING_PHONE�NUM_DAYS_OF_WEEK�I�
ConstantValue����MINUTES_IN_HOUR���<�
INTERVAL_SIZE�
NUM_INTERVALS����s_sUserTable�?�s_sGeneralTable�?�
s_sUserLocale�?�s_sNotificationScheduleTable�?�s_sSMTPTable�?�s_sPageTable�?�s_sPreferredCredentials�?�s_sDfltPerms�?�s_sUserPref�?�s_sDfltNotifyPref�?�s_sPagingServersTable�?�s_sPagingCarriersTable�?�s_sDeleteInterval�?�s_sInsertInterval�?�s_sUserIdQuery�?�s_sGetAllIntervals�?�s_sUserFound�?�s_sGetLocale�?�s_sGetLocaleForUpdate�?�s_sUpdateLocaleInfo�?�s_sInsertLocaleInfo�?�s_sSelectPC�?�s_sSelectForUpdatePC�?�s_sSelectAllPC�?�s_sUpdatePC�?�s_sUpdatePC2�?�s_sInsertPC�?�s_sInsertPC2�?�s_sDeletePC�?�s_sDeleteServicePC�?�s_sSelectDP�?�s_sSelectForUpdateDP�?�s_sUpdateDP�?�s_sInsertDP�?�s_sDeleteDP�?�s_sSelectAllDfltPerms�?�s_sSelectNP�?�s_sSelectForUpdateNP�?�s_sUpdateNP�?�s_sInsertNP�?�s_sDeleteNP�?�s_sSelectAllDfltNotifyPrefs�?�s_sSelectGeneralAttr�?�s_sUpdateDisplayName�?�s_sSelectGeneralTable�?�s_sUpdateGeneralTable�?�s_sInsertGeneralTable�?�s_sSelectNotifiableUsers�?�s_sInsertUserPref�?�s_sUpdateUserPref�?�s_sSelectUserPref�?�s_sSelectAllUserPref�?�s_sUpdateEmailPrefs�?�s_sSelectEmailPagePrefs�?�s_sUpdatePagePrefs�?�s_sRetrieveEmailPagingFilters�?�s_sGetDistinctCarriers�?�s_getPrefCredStates�?�<clinit>�()V�Code�LineNumberTable�
SourceFile�VdvConstants.java�java/lang/String�CARRIER�?�?���PIN�
��NUMBER���oracle/sysman/vdv/VdvConstants�java/lang/Object�SMP_VDV_USER�SMP_VDV_GENERAL�SMP_VDV_USER_LOCALE�SMP_VDV_NOTIFICATION_SCHEDULE�SMP_VDV_SMTP_EMAIL�SMP_VDV_PAGE�SMP_VDV_PREFERRED_CREDENTIALS�SMP_VDV_DEFAULT_PERMISSIONS�SMP_VDV_USER_PREF�SMP_VDV_DEFAULT_NOTIFY_PREFS�SMP_VDM_PAGING_SERVER_INFO�SMP_VDM_PAGING_CARRIER_INFO�< DELETE FROM SMP_VDV_NOTIFICATION_SCHEDULE WHERE user_id = ?�N INSERT INTO SMP_VDV_NOTIFICATION_SCHEDULE (user_id, schedule)  VALUES (?, ?) �6 SELECT user_id  FROM SMP_VDV_USER WHERE user_name = ?�x SELECT * FROM  SMP_VDV_NOTIFICATION_SCHEDULE WHERE user_id IN  (SELECT user_id FROM SMP_VDV_USER WHERE user_name = ? ) �E SELECT COUNT(*) AS user_count FROM SMP_VDV_USER WHERE user_name = ? �?ELECT language, country, variant  FROM SMP_VDV_USER_LOCALE WHERE user_id IN ( SELECT user_id FROM SMP_VDV_USER  WHERE user_name = ? ) �{ SELECT *  FROM SMP_VDV_USER_LOCALE WHERE user_id IN ( SELECT user_id FROM SMP_VDV_USER  WHERE user_name = ? )  FOR UPDATE �? UPDATE SMP_VDV_USER_LOCALE SET user_id = ( SELECT user_id FROM SMP_VDV_USER                 WHERE user_name = ? ),     language = ? ,    country  = ? ,    variant  = ?  �? INSERT INTO SMP_VDV_USER_LOCALE (user_id, language, country, variant)  ( SELECT user_id, ?, ?, ? FROM SMP_VDV_USER   WHERE user_name = ? ) SELECT user_id, service_type, service_name, credentials FROM SMP_VDV_PREFERRED_CREDENTIALS WHERE user_id =                  ( SELECT user_id FROM SMP_VDV_USER                   WHERE user_name = ? ) AND        (service_name = ?  OR service_name = ?) AND        service_type IN ( %s ) �? SELECT * FROM SMP_VDV_PREFERRED_CREDENTIALS WHERE user_id =                  ( SELECT user_id FROM SMP_VDV_USER                   WHERE user_name = ? ) AND        service_type = ? AND        service_name = ?  FOR UPDATE �? SELECT user_id, service_type, service_name, credentials FROM SMP_VDV_PREFERRED_CREDENTIALS WHERE user_id =                  ( SELECT user_id FROM SMP_VDV_USER                   WHERE user_name = ? )  UPDATE SMP_VDV_PREFERRED_CREDENTIALS SET      credentials    = ?  WHERE   user_id      =                          (SELECT user_id FROM SMP_VDV_USER                             WHERE user_name = ? )  AND          service_type = ? AND         service_name = ?
 UPDATE SMP_VDV_PREFERRED_CREDENTIALS SET      credentials    = ?   WHERE   user_id      =                          (SELECT user_id FROM SMP_VDV_USER                             WHERE user_name = '%s' )  AND          service_type = '%s' AND         service_name = '%s' �? INSERT INTO SMP_VDV_PREFERRED_CREDENTIALS ( user_id, service_type, service_name, credentials)  (SELECT user_id, ?, ?, ? FROM SMP_VDV_USER  WHERE user_name = ? )  �? INSERT INTO SMP_VDV_PREFERRED_CREDENTIALS ( user_id, service_type, service_name, credentials)  (SELECT user_id, '%s', '%s',  ? FROM SMP_VDV_USER  WHERE user_name = '%s' )  �? DELETE FROM SMP_VDV_PREFERRED_CREDENTIALS WHERE user_id =                  ( SELECT user_id FROM SMP_VDV_USER                   WHERE user_name = ? ) AND        service_name = ? AND        service_type = ? �^ DELETE FROM SMP_VDV_PREFERRED_CREDENTIALS WHERE service_name = ? AND        service_type = ?  SELECT permission FROM SMP_VDV_DEFAULT_PERMISSIONS WHERE user_id =             ( SELECT user_id FROM SMP_VDV_USER               WHERE user_name = ? )  AND        other_user_id =             ( SELECT user_id FROM  SMP_VDV_USER                WHERE user_name = ?)  SELECT permission FROM SMP_VDV_DEFAULT_PERMISSIONS WHERE user_id =                  ( SELECT user_id FROM SMP_VDV_USER                   WHERE user_name = ? ) AND        other_user_id =             ( SELECT user_id FROM  SMP_VDV_USER                WHERE user_name = ?)  FOR UPDATE 3 UPDATE SMP_VDV_DEFAULT_PERMISSIONS SET      permission   = ?  WHERE   user_id      =                          (SELECT user_id FROM SMP_VDV_USER                             WHERE user_name = ? )  AND        other_user_id =             ( SELECT user_id FROM  SMP_VDV_USER                WHERE user_name = ?) �? INSERT INTO SMP_VDV_DEFAULT_PERMISSIONS ( user_id, other_user_id, permission)  (SELECT A.user_id, B.user_id, ? FROM SMP_VDV_USER A, SMP_VDV_USER B  WHERE A.user_name = ? AND B.user_name = ? )   DELETE FROM SMP_VDV_DEFAULT_PERMISSIONS WHERE user_id =                  ( SELECT user_id FROM SMP_VDV_USER                   WHERE user_name = ? ) AND        other_user_id =             ( SELECT user_id FROM  SMP_VDV_USER                WHERE user_name = ?)  SELECT B.user_name, permission         FROM SMP_VDV_DEFAULT_PERMISSIONS A ,SMP_VDV_USER B             WHERE A.user_id = ( SELECT user_id FROM SMP_VDV_USER                                WHERE user_name = ?) AND                   A.other_user_id = B.user_id  SELECT notify FROM SMP_VDV_DEFAULT_NOTIFY_PREFS WHERE user_id =             ( SELECT user_id FROM SMP_VDV_USER               WHERE user_name = ? )  AND        other_user_id =             ( SELECT user_id FROM  SMP_VDV_USER                WHERE user_name = ?)  SELECT notify FROM SMP_VDV_DEFAULT_NOTIFY_PREFS WHERE user_id =                  ( SELECT user_id FROM SMP_VDV_USER                   WHERE user_name = ? ) AND        other_user_id =             ( SELECT user_id FROM  SMP_VDV_USER                WHERE user_name = ?)  FOR UPDATE 0 UPDATE SMP_VDV_DEFAULT_NOTIFY_PREFS SET      notify   = ?  WHERE   user_id      =                          (SELECT user_id FROM SMP_VDV_USER                             WHERE user_name = ? )  AND        other_user_id =             ( SELECT user_id FROM  SMP_VDV_USER                WHERE user_name = ?) �? INSERT INTO SMP_VDV_DEFAULT_NOTIFY_PREFS ( user_id, other_user_id, notify)  (SELECT A.user_id, B.user_id, ? FROM SMP_VDV_USER A, SMP_VDV_USER B  WHERE A.user_name = ? AND B.user_name = ? )   DELETE FROM SMP_VDV_DEFAULT_NOTIFY_PREFS WHERE user_id =                  ( SELECT user_id FROM SMP_VDV_USER                   WHERE user_name = ? ) AND        other_user_id =             ( SELECT user_id FROM  SMP_VDV_USER                WHERE user_name = ?) �? SELECT B.user_name, notify         FROM SMP_VDV_DEFAULT_NOTIFY_PREFS A ,SMP_VDV_USER B             WHERE A.user_id = ( SELECT user_id FROM SMP_VDV_USER                                WHERE user_name = ?) AND                   A.other_user_id = B.user_id �? SELECT user_name, display_name, advanced_features, description, time_zone, time_zone_pref FROM SMP_VDV_USER A, SMP_VDV_GENERAL B                 WHERE user_name = ? AND                    A.user_id = B.user_id �? UPDATE SMP_VDV_USER SET display_name = ?  WHERE user_name = ? �? SELECT advanced_features, description, time_zone  FROM SMP_VDV_GENERAL WHERE user_id = ( SELECT user_id FROM SMP_VDV_USER                   WHERE user_name = ? )  FOR UPDATE �? UPDATE SMP_VDV_GENERAL SET advanced_features = ?, description = ?, time_zone = ?, time_zone_pref = ?  WHERE   user_id      =                          (SELECT user_id FROM SMP_VDV_USER                             WHERE user_name = ? ) �? INSERT INTO SMP_VDV_GENERAL ( user_id, advanced_features, description, time_zone, time_zone_pref )  ( SELECT user_id, ?, ?, ?, ? FROM SMP_VDV_USER   WHERE user_name = ? )�lSELECT user_name, schedule FROM SMP_VDV_USER A, SMP_VDV_NOTIFICATION_SCHEDULE B  WHERE A.user_id = B.user_id�?INSERT INTO SMP_VDV_USER_PREF ( user_id, app, name, value ) (SELECT user_id, ?, ?, ? FROM SMP_VDV_USER    WHERE user_name = ? ) �? UPDATE SMP_VDV_USER_PREF SET value = ?  WHERE app = ? AND name = ? AND  user_id  =     (SELECT user_id FROM SMP_VDV_USER    WHERE user_name = ? ) �?ELECT p.value FROM SMP_VDV_USER_PREF p,  SMP_VDV_USER u WHERE u.user_name = ? AND p.user_id = u.user_id AND p.app = ? AND p.name = ?�~SELECT p.name, p.value FROM SMP_VDV_USER_PREF p,  SMP_VDV_USER u WHERE u.user_name = ? AND p.user_id = u.user_id AND p.app = ?,UPDATE SMP_VDV_SMTP_EMAIL SET email_address = ?, subject_prefix = ?, email_length = ?,  email_filter = ?, subject_format = ?, body_header_format = ?,  body_detail_format = ?  where user_id =                          (SELECT user_id FROM SMP_VDV_USER                             WHERE user_name = ? ) bSELECT EMAIL.email_address "EMAIL_ADDRESS",  Email.subject_prefix "EMAIL_SUBJECT_PREFIX",  Email.email_length "EMAIL_LENGTH",  Email.email_filter "EMAIL_FILTER",  Email.subject_format "EMAIL_SUBJECT_FORMAT",  Email.body_header_format "EMAIL_BODY_HEADER_FORMAT",  Email.body_detail_format "EMAIL_BODY_DETAIL_FORMAT",  Page.is_page_to_email "IS_PAGE_TO_EMAIL",  Page.carrier "CARRIER" , Page.pin "PIN",  Page.page_email_id "PAGE_EMAIL_ID" , Page.page_prefix "PAGE_PREFIX",  Page.page_data_length "PAGE_DATA_LENGTH",  Page.page_filter "PAGE_FILTER",  Page.body_header_format "PAGE_BODY_HEADER_FORMAT",  Page.body_detail_format "PAGE_BODY_DETAIL_FORMAT"  from SMP_VDV_SMTP_EMAIL Email, SMP_VDV_PAGE Page  where Email.user_id =                          (SELECT user_id FROM SMP_VDV_USER                             WHERE user_name = ? )  AND Email.user_id = Page.user_id >UPDATE SMP_VDV_PAGE SET is_page_to_email = ?, carrier = ?, pin = ?,  page_email_id = ?, page_prefix = ?, page_data_length = ?,  page_filter = ?, body_header_format = ?, body_detail_format = ?  where user_id =                          (SELECT user_id FROM SMP_VDV_USER                             WHERE user_name = ? ) "SELECT Email.email_filter "EMAIL_FILTER",  Page.page_filter "PAGE_FILTER"  from SMP_VDV_SMTP_EMAIL Email, SMP_VDV_PAGE Page  where Email.user_id =                          (SELECT user_id FROM SMP_VDV_USER                             WHERE user_name = ? )  and Page.user_id = Email.user_id �*SELECT DISTINCT carrier  from SMP_VDV_PAGE�?ELECT service_type, service_name from SMP_VDV_PREFERRED_CREDENTIALS where user_id =                  (SELECT user_id FROM SMP_VDV_USER                     WHERE user_name = ? )  and ( %s ) �<init>�(Ljava/lang/String;)V��	�
���A�������
���������������������������������������������������������������������������������� �������!��"�������#��$�������%��&�������'��(�������)��*�������+��,�������-��.�������/��0�������1��2�������3��4�������5��6�������7��8�������9��:�������;��<�������=��>�������?��@�������A��B�������C��D�������E��F�������G��H�������I��J�������K��L�������M��N�������O��P�������Q��R�������S��T�������U��V�������W��X�������Y��Z�������[��\�������]��^�������_��`�������a��b�������c��d�������e��f�������g��h�������i��j�������k��l�������m��n�������o��p�������q��r�������s��t�������u��v�������w��x�������y��z�������{��|�������}��~���������?�������?��?�������?��?�������?��?�������?��?�������?��?�������?���?�?��?���E������%?�Y?�?�?�Y?�?�?�Y?�?�?����?�������?��?��?��?����?

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de