Rem drv: <migrate type="data_upgrade" version="10.2.0.4.0" pos="-"/>
Rem $Header: racprov_data_upgrade_102040.sql 17-sep-2007.03:28:01 vsagar Exp $
Rem
Rem racprov_data_upgrade_102030.sql
Rem
Rem Copyright (c) 2006, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      racprov_data_upgrade_102030.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    vsagar     09/17/07  - 
Rem    ipall      08/16/07 -  Created
Rem

BEGIN
	UPDATE MGMT_PAF_APPLICATIONS
	SET URL = '/em/console/racprov/Dummy',
	RESOURCE_BUNDLE = 'oracle.sysman.pp.common.rac.rb.RacProvDeplProcRB' 
	WHERE NAME = 'RACPROV';

        COMMIT;
    
        UPDATE mgmt_paf_procedures
        SET base_guid =
          (SELECT procedure_guid
           FROM mgmt_paf_procedures procs,
              (SELECT name,
               application_name,
               MIN(version) AS
            min_version
             FROM mgmt_paf_procedures
             WHERE application_name = 'RACPROV'
             AND name = 'PROCEDURE_NAME_UNIX'
             AND is_oracle = 'Y'
             GROUP BY name,
               application_name)
          min_ver
           WHERE procs.application_name = 'RACPROV'
           AND procs.name = 'PROCEDURE_NAME_UNIX'
           AND procs.version = min_ver.min_version
           AND procs.is_oracle = 'Y')
        WHERE application_name = 'RACPROV'
         AND name = 'PROCEDURE_NAME_UNIX'
         AND is_oracle = 'Y';

        COMMIT;

        UPDATE mgmt_paf_procedures
        SET base_guid =
          (SELECT procedure_guid
           FROM mgmt_paf_procedures procs,
              (SELECT name,
               application_name,
               MIN(version) AS
            min_version
             FROM mgmt_paf_procedures
             WHERE application_name = 'RACPROV'
             AND name = 'PROCEDURE_NAME_WIN'
             AND is_oracle = 'Y'
             GROUP BY name,
               application_name)
          min_ver
           WHERE procs.application_name = 'RACPROV'
           AND procs.name = 'PROCEDURE_NAME_WIN'
           AND procs.version = min_ver.min_version
           AND procs.is_oracle = 'Y')
        WHERE application_name = 'RACPROV'
         AND name = 'PROCEDURE_NAME_WIN'
         AND is_oracle = 'Y';

        COMMIT;

        UPDATE mgmt_paf_procedures
        SET base_guid =
          (SELECT procedure_guid
           FROM mgmt_paf_procedures procs,
              (SELECT name,
               application_name,
               MIN(version) AS
            min_version
             FROM mgmt_paf_procedures
             WHERE application_name = 'RACPROV'
             AND name = 'PROCEDURE_NAME_EC'
             AND is_oracle = 'Y'
             GROUP BY name,
               application_name)
          min_ver
           WHERE procs.application_name = 'RACPROV'
           AND procs.name = 'PROCEDURE_NAME_EC'
           AND procs.version = min_ver.min_version
           AND procs.is_oracle = 'Y')
        WHERE application_name = 'RACPROV'
         AND name = 'PROCEDURE_NAME_EC'
         AND is_oracle = 'Y';

        COMMIT;

        UPDATE mgmt_paf_procedures
        SET base_guid =
          (SELECT procedure_guid
           FROM mgmt_paf_procedures procs,
              (SELECT name,
               application_name,
               MIN(version) AS
            min_version
             FROM mgmt_paf_procedures
             WHERE application_name = 'RACPROV'
             AND name = 'PROCEDURE_NAME_DN'
             AND is_oracle = 'Y'
             GROUP BY name,
               application_name)
          min_ver
           WHERE procs.application_name = 'RACPROV'
           AND procs.name = 'PROCEDURE_NAME_DN'
           AND procs.version = min_ver.min_version
           AND procs.is_oracle = 'Y')
        WHERE application_name = 'RACPROV'
         AND name = 'PROCEDURE_NAME_DN'
         AND is_oracle = 'Y';

        COMMIT;

       
	EXCEPTION WHEN OTHERS THEN NULL;
END;
/