Rem drv: <migrate type="data_upgrade" version="10.2.0.3" />
Rem
Rem $Header: service_data_upgrade.sql 16-feb-2006.20:58:11 skkunise Exp $
Rem
Rem service_data_upgrade.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      service_data_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    skkunise    02/15/06 - adding has_business property 
Rem    skkunise    02/15/06 - Created
Rem

BEGIN
DECLARE
PROCEDURE add_prop_def(p_service_type IN VARCHAR2, 
                       p_property_name IN VARCHAR2,
                       p_type_meta_ver IN VARCHAR2)
AS
BEGIN
   BEGIN
      INSERT INTO mgmt_target_prop_defs(target_type, type_meta_ver,
                       property_name, 
                       property_display_name, hidden_flag)
      VALUES(p_service_type, p_type_meta_ver, p_property_name, p_property_name, 1);
   EXCEPTION
      WHEN DUP_VAL_ON_INDEX THEN
          NULL;
   END;
END;

PROCEDURE add_svc_prop_defs(p_service_type IN VARCHAR2,
                            p_type_meta_ver IN VARCHAR2)
AS
BEGIN
   add_prop_def(p_service_type, 
                EM_SERVICE.G_SVC_HAS_BUSINESS,
                p_type_meta_ver);
END;

BEGIN
   --add property def for aggregate service
   add_svc_prop_defs(MGMT_GLOBAL.G_AGGREGATE_SERVICE_TYPE, '1.0');
   add_svc_prop_defs(MGMT_GLOBAL.G_GENERIC_SERVICE_TYPE, '1.0');
   add_svc_prop_defs(MGMT_GLOBAL.G_GENERIC_SERVICE_TYPE, '3.0');
   COMMIT;
END;
END;
/
show errors;