Rem drv: <migrate type="data_upgrade" version="10.2.0.4.0" pos="-"/>
Rem
Rem asprov_data_upgrade_102030.sql

BEGIN
	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 = 'AS Provisioning'
	     AND name = 'MYJ2EECOMPANY_DEPLOY_ORACLE_SOFTWARE'
	     AND is_oracle = 'Y'
	     GROUP BY name,
	       application_name)
	  min_ver
	   WHERE procs.application_name = 'AS Provisioning'
	   AND procs.name = 'MYJ2EECOMPANY_DEPLOY_ORACLE_SOFTWARE'
	   AND procs.version = min_ver.min_version
	   AND procs.is_oracle = 'Y')
	WHERE application_name = 'AS Provisioning'
	 AND name = 'MYJ2EECOMPANY_DEPLOY_ORACLE_SOFTWARE'
	 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 = 'AS Provisioning'
	     AND name = 'ASPROV_1013_DEPLOY_ORACLE_SOFTWARE'
	     AND is_oracle = 'Y'
	     GROUP BY name,
	       application_name)
	  min_ver
	   WHERE procs.application_name = 'AS Provisioning'
	   AND procs.name = 'ASPROV_1013_DEPLOY_ORACLE_SOFTWARE'
	   AND procs.version = min_ver.min_version
	   AND procs.is_oracle = 'Y')
	WHERE application_name = 'AS Provisioning'
	 AND name = 'ASPROV_1013_DEPLOY_ORACLE_SOFTWARE'
	 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 = 'AS Provisioning'
	     AND name = 'AS_SOA_DEPLOY_ORACLE_SOFTWARE'
	     AND is_oracle = 'Y'
	     GROUP BY name,
	       application_name)
	  min_ver
	   WHERE procs.application_name = 'AS Provisioning'
	   AND procs.name = 'AS_SOA_DEPLOY_ORACLE_SOFTWARE'
	   AND procs.version = min_ver.min_version
	   AND procs.is_oracle = 'Y')
	WHERE application_name = 'AS Provisioning'
	 AND name = 'AS_SOA_DEPLOY_ORACLE_SOFTWARE'
	 AND is_oracle = 'Y';

	COMMIT;

	EXCEPTION WHEN OTHERS THEN NULL;
END;
/