Rem DO NOT ADD HEADER HERE, and DO NOT DELETE THIS FILE EITHER.  THIS FILE
Rem IS BEING REFERENCED FROM policy_data_upgrade.sql
Rem
Rem $Header: policy_post_creation.sql 24-jul-2007.16:47:03 rrawat Exp $
Rem
Rem policy_post_creation.sql
Rem
Rem Copyright (c) 2004, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      policy_post_creation.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    rrawat      07/24/07 - Backport rrawat_bug-5357750 from main
Rem    rrawat      07/16/07 - Bug-5357750
Rem    niramach    08/03/05 - niramach_bugfix-4527462
Rem    niramach    08/01/05 - Move the delta between beta and production to v102020 
Rem    chyu        07/19/05 - modifying the new rep manager header 
Rem    gsbhatia    07/03/05 - Remove repmgr header 
Rem    niramach    05/24/05 - niramach_bug-4388599
Rem    niramach    05/18/05 - Register EM_POLICY module for logging errors. 
Rem    rpinnama    05/12/05 - Move the policy init to v102010/policy_init directory
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    rpinnama    01/06/05 - Add target type addition callback 
Rem    jsadras     10/14/04 - performance module 
Rem    rpinnama    09/02/04 - rpinnama_add_policy_api_4
Rem    rpinnama    08/27/04 - Created
Rem

SET ECHO ON
--
-- Register the module for logging errors.
-- 
BEGIN
  mgmt_log.register_logging_module (EM_POLICY.G_MODULE_NAME,
    'Clear Expired Suppressions','EM_POLICY.CLEAR_EXPIRED_SUPPRESSIONS');
  COMMIT;
END;
/

BEGIN
  INSERT INTO MGMT_PARAMETERS
    (parameter_name, parameter_value, parameter_comment)
  VALUES
    ('policy_purge_batchsize_parameter', '10000', ' Policy Purge Batch Size for MGMT_VIOLATIONS ' );

  COMMIT;
EXCEPTION
  -- Dont set the value to 10000 if its already set  
  WHEN OTHERS THEN NULL;
END;
/