Rem drv: <migrate type="pre_data_upgrade" version="10.2.0.0"/>
Rem
Rem $Header: assoc_post_creation.sql 21-jul-2005.10:21:20 chyu Exp $
Rem
Rem assoc_post_creation.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      assoc_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    chyu        07/19/05 - modifying the new rep manager header 
Rem    pmodi       04/15/05 - Add two tables to delete exception list 
Rem    pmodi       02/17/05 - pmodi_em_group_migration1
Rem    pmodi       02/16/05 - Created
Rem





BEGIN
  DECLARE del_exceptions SMP_EMD_STRING_ARRAY := SMP_EMD_STRING_ARRAY();

  BEGIN
    del_exceptions.extend(7);
    del_exceptions(1) := 'MGMT_TARGET_ASSOCS';
    del_exceptions(2) := 'MGMT_FLAT_TARGET_ASSOC';
    del_exceptions(3) := 'MGMT_TARGET_PENDING_ASSOCS';
    del_exceptions(4) := 'MGMT_TARGET_ASSOC_ERROR';
    del_exceptions(5) := 'MGMT_TARGET_ASSOC_PROP';
    del_exceptions(6) := 'MGMT_TARGET_ASSOC_INSTANCE';
    del_exceptions(7) := 'MGMT_TARGET_TEMP_LIST';
    MGMT_ADMIN.add_target_deletion_exceptions(del_exceptions);
    commit;
  EXCEPTION
    WHEN OTHERS 
      THEN 
        dbms_output.put_line( 'EXCEPTION registering delete_exception '|| SQLCODE );
        RAISE;
  END;
END;   
/

show error;

BEGIN
  mgmt_admin.add_target_addition_callback('em_assoc.update_pending_assoc');
  commit;
EXCEPTION
  WHEN OTHERS 
    THEN 
      dbms_output.put_line( 'EXCEPTION registering add_target callback '|| SQLCODE );
      RAISE;
END;
/
show error;

BEGIN
  em_target.add_tgt_pre_deletion_callback('em_assoc.delete_target');
  commit;
EXCEPTION
  WHEN OTHERS 
    THEN 
      dbms_output.put_line( 'EXCEPTION registering  pre_delete_target callback '|| SQLCODE );
      RAISE;
END;
/
show error;
-- Register logging modules.
BEGIN
  mgmt_log.register_logging_module ('ASSOC','Association');

  COMMIT;
END;
/
show error;

BEGIN
  mgmt_target.add_tgt_relocation_callback('em_assoc.handle_relocated_target');
  commit;
EXCEPTION
  WHEN OTHERS 
    THEN 
      dbms_output.put_line( 'EXCEPTION registering handle_relocated_target callback '|| SQLCODE );
      RAISE;
END;
/
show error;

BEGIN
  emd_loader.add_plsql_handler_for_rowset(p_rowset_name => 'MGMT_TARGET_MEMBERSHIPS', p_proc_name => 'em_assoc.add_member_from_loader');
  commit;
EXCEPTION
  WHEN OTHERS
    THEN
      dbms_output.put_line( 'EXCEPTION add handler for membership rowset callback '|| SQLCODE );
      RAISE;
END;
/
show error;

BEGIN
  emd_loader.add_plsql_handler_for_rowset(p_rowset_name => 'MGMT_TARGET_ASSOCS', p_proc_name => 'em_assoc.add_assoc_from_loader');
  commit;
EXCEPTION
  WHEN OTHERS
    THEN
      dbms_output.put_line( 'EXCEPTION add handler for assoc rowset callback '|| SQLCODE );
      RAISE;
END;
/
show error;