Rem
Rem $Header: sdosemdmh.sql 23-jun-2007.09:33:15 sdas Exp $
Rem
Rem sdosemdmh.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      sdosemdmh.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    sdas        06/23/07 - fix security issues
Rem    sdas        06/18/07 - upgrade: save 10.2 models in network tablespace
Rem    sdas        06/16/07 - move save and restore functionality
Rem                           from catsem10i to the upgrade package
Rem    alwu        06/04/07 - add logic to support downgrade
Rem    sdas        05/11/07 - data migration from 10.2 to 11
Rem    sdas        05/11/07 - Created
Rem

CREATE OR REPLACE PACKAGE sem_upgrade_to_11 authid current_user AS
  PROCEDURE unload_all_into_staging_tables(downgrade BOOLEAN DEFAULT FALSE);
  PROCEDURE empty_app_tabs_drop_RDF_cols(downgrade BOOLEAN DEFAULT FALSE);

  PROCEDURE setup_for_loading_in_11;
  PROCEDURE create_all_models_in_11;
  PROCEDURE load_from_all_staging_tables;

  PROCEDURE save_10_2_RDF_network_for_11;
  PROCEDURE restore_10_2_RDF_network_in_11;
END sem_upgrade_to_11;
/
show errors;