Rem drv: <migrate type="data_upgrade" version="10.2.0.3.0"/>
Rem $Header: paf_data_upgrade_102030.sql 30-oct-2006.10:56:58 ktlaw Exp $
Rem
Rem paf_data_upgrade_102030.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      paf_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    ktlaw       10/27/06 - bug 5629858
Rem    milshah     10/27/06 - Call necessary PAF jobtypes only
Rem    ktamtoro    10/05/06 - Backport ktamtoro_bug-5381533 from main
Rem    ktamtoro    09/14/06 - Backport ktamtoro_bug-5496888 from main
Rem    zsamar      08/18/06 - Backport zsamar_groups from main
Rem    rlemos      10/03/06 - Add job command to print out email content
Rem    rlemos      09/27/06 - Add default value for notification flag
Rem    ktamtoro    09/14/06 - Add default value for staging area
Rem    zsamar      08/10/06 -
Rem    ktlaw       06/02/06 -
Rem    rahgupta    06/07/06 - add entires for paf job types changes
Rem    zsamar      04/21/06 - Created
Rem

@&EM_SQL_ROOT/pp/latest/paf/paf_post_creation_102030.sql

BEGIN

  --Adding default value for staging area to MGMT_PARAMETERS
  INSERT INTO MGMT_PARAMETERS
      VALUES ( 'paf.stagingArea', '%emd_root%',
               'Default staging area', 1 );

  --Adding default value for notification flag to MGMT_PARAMETERS
  INSERT INTO MGMT_PARAMETERS
      VALUES ( 'paf.notification', 'false',
               'Default notification flag', 1 );

   COMMIT;
EXCEPTION WHEN OTHERS THEN NULL;
END;
/

-- Executing all post data upgrade scripts
@&EM_SQL_ROOT/pp/latest/paf/paf_clonejob_register.sql

COMMIT;