Rem drv: <create type="pkgdefs"/>
Rem
Rem $Header: upgrade_pkgdefs.sql 24-oct-2005.16:30:28 ychan Exp $
Rem
Rem upgrade_pkgdefs.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      upgrade_pkgdefs.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    ychan    10/24/05 - Add proc 
Rem    ychan    09/30/05 - Fix bug 4642958 
Rem    ysun     08/22/05 - Add RAC support
Rem    ychan    08/15/05 - Add header 
Rem    ychan    08/09/05 - Add const 
Rem    ychan    07/12/05 - Clean up 
Rem    ychan    06/14/05 - Created
Rem

CREATE OR REPLACE PACKAGE mgmt_db_upgrade
AS
  TYPE COLL_LIST IS TABLE OF VARCHAR2(50);
  COLL9i_INST COLL_LIST  := COLL_LIST('instance_throughput_9i', 'instance_efficiency_9i', 'wait_bottlenecks_9i', 'sga_pool_wastage_9i', 'Database_Resource_Usage_9i', 'problemTbsp_9i', 'UserBlock_9i', 'rac_global_cache_9i');
  COLL10g_INST COLL_LIST  := COLL_LIST('instance_throughput_10i', 'instance_efficiency_10i', 'wait_bottlenecks_10i', 'sga_pool_wastage_10i', 'Database_Resource_Usage_10i', 'problemTbsp_10i_Loc', 'UserBlock_10i', 'rac_global_cache_10i');

  COLL9i_RAC COLL_LIST  := COLL_LIST( 'problemTbsp_9i');
  COLL10g_RAC COLL_LIST  := COLL_LIST('problemTbsp_10i_Loc');

  -- Module name used for logging
  MODULE_NAME CONSTANT VARCHAR2(20) := 'MGMT_DB_UPGRADE';
   
  FUNCTION get_9i_coll(p_target_type IN VARCHAR2) return COLL_LIST; 
  FUNCTION get_10g_coll(p_target_type IN VARCHAR2) return COLL_LIST; 

  PROCEDURE change_ver_inst(p_obj IN mgmt_target_property_cbk_obj);

  PROCEDURE change_ver_rac(p_obj IN mgmt_target_property_cbk_obj);
  
  PROCEDURE change_ver_inst(p_obj IN mgmt_target_meta_ver_cbk_obj); 

  PROCEDURE change_ver_rac(p_obj IN mgmt_target_meta_ver_cbk_obj); 
  
  PROCEDURE handle_version_change(p_obj IN mgmt_target_meta_ver_cbk_obj, p_target_type IN VARCHAR2); 
  
END mgmt_db_upgrade;
/

show errors;