REM drv: <migrate type="data_upgrade" version="10.2.0.2.0" pos="-"/>
Rem $Header: paf_data_upgrade_102020.sql 31-oct-2006.15:27:02 ktamtoro Exp $
Rem
Rem paf_tables.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      paf_tables.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    ktamtoro    10/31/06 - 
Rem    ktlaw       10/27/06 - 
Rem    milshah     10/27/06 - Call only PAF 10.2.0.2 jobtypes
Rem    milshah     10/18/06 - Remove pa enteries from paf
Rem    ktamtoro    03/09/06 - Remove OCSU registration
Rem    rahgupta    02/05/06 - Bug 5012399: Start PAF Daemon Job 
Rem    ktlaw       07/22/05 - ktlaw_paf_schema_upgrade
Rem    ktlaw       07/22/05 - enable upgrade 
Rem


BEGIN 
 
  DELETE FROM MGMT_PAF_PROCEDURES ;
  DELETE FROM MGMT_DEPLOYMENT_SECTIONS where class_name = 'oracle.sysman.pp.paf.ui.ProvisioningAdvisorSection';
  DELETE FROM MGMT_PARAMETERS where parameter_name like 'paf.%' ;
  DELETE FROM MGMT_PAF_APPLICATIONS ;
  DELETE FROM MGMT_PAF_JOBTYPES ;
  COMMIT;

EXCEPTION WHEN OTHERS THEN NULL;

END;
/

-- executing all post_creation scripts in the same order as specified by the header known at this time. 
-- teams should update the following section when adding new post_creation scripts. 

@&EM_SQL_ROOT/pp/latest/asprov/asprov_out_of_box.sql
@&EM_SQL_ROOT/pp/latest/paf/paf_post_creation.sql
@&EM_SQL_ROOT/pp/latest/paf/paf_jobstep_register.sql
@&EM_SQL_ROOT/pp/latest/paf/paf_default_func.sql
@&EM_SQL_ROOT/pp/latest/paf/paf_deploy_section.sql
@&EM_SQL_ROOT/pp/latest/racprov/racprov_out_of_box.sql
@&EM_SQL_ROOT/pp/latest/deploymentProcs_sql/pp_deploymentProcs.sql

COMMIT;