Rem drv: <migrate type="schema_upgrade" version="10.2.0.1" pos="admin_data_upgrade.sql-"/>
Rem
Rem $Header: sdk_schema_upgrade.sql 23-aug-2005.09:23:02 jsadras Exp $
Rem
Rem sdk_schema_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      sdk_schema_upgrade.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    jsadras     08/23/05 - jsadras_bug-4493312
Rem    jsadras     08/17/05 - Created, mgmt_target_meta_ver_cbk_obj/array
Rem

--
--Callback objects for type meta version/category prop change
--
DROP TYPE MGMT_TARGET_META_VER_CBK_ARRAY 
/

CREATE OR REPLACE TYPE MGMT_TARGET_META_VER_CBK_OBJ AS OBJECT (
 target_guid        RAW(16),
 target_type        VARCHAR2(64),
 from_meta_ver      VARCHAR2(64),
 to_meta_ver        VARCHAR2(64),
 from_catprop_array mgmt_short_string_array,
 to_catprop_array   mgmt_short_string_array,
 STATIC FUNCTION NEW(p_target_guid        RAW,
                     p_target_type        VARCHAR2,
                     p_from_meta_ver      VARCHAR2,
                     p_to_meta_ver        VARCHAR2,
                     p_from_catprop_array mgmt_short_string_array,
                     p_to_catprop_array   mgmt_short_string_array
                     )
 RETURN MGMT_TARGET_META_VER_CBK_OBJ
);
/

CREATE OR REPLACE TYPE MGMT_TARGET_META_VER_CBK_ARRAY AS TABLE OF MGMT_TARGET_META_VER_CBK_OBJ
/


--
-- Callback objects for tzrgn update callback
--
CREATE OR REPLACE TYPE MGMT_TZRGN_UPDATE_CBK_OBJ AS OBJECT
(
  target_guid   RAW(16),
  target_type   VARCHAR2(64),
  from_tzrgn    VARCHAR2(64),
  to_tzrgn      VARCHAR2(64),
  STATIC FUNCTION NEW(p_target_guid    RAW,
                      p_target_type    VARCHAR2,
                      p_from_tzrgn     VARCHAR2,
                      p_to_tzrgn       VARCHAR2
                     )
 RETURN MGMT_TZRGN_UPDATE_CBK_OBJ
);
/

CREATE OR REPLACE TYPE MGMT_TARGET_PROPERTY_CBK_OBJ AS OBJECT (
  target_guid        RAW(16),
  property_name      VARCHAR2(64),
  old_property_value VARCHAR2(1024),   
  new_property_value VARCHAR2(1024),   
  STATIC FUNCTION NEW(p_target_guid        IN RAW,
                      p_property_name      IN VARCHAR2,
                      p_old_property_value IN VARCHAR2,
                      p_new_property_value IN VARCHAR2
                      )
  RETURN MGMT_TARGET_PROPERTY_CBK_OBJ
) ;
/