Rem drv: <create type="types"/>
Rem
Rem $Header: ts_type.sql 13-mar-2006.21:58:40 vsagar Exp $
Rem
Rem ts_type.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      ts_type.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    vsagar      03/11/06 - vsagar_dev060307
Rem    vsagar      01/03/06 - 
Rem    tasingh     12/09/05 - Created
Rem

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

create or replace type ASPROV_TS_REC_TYPE is OBJECT
  (
    target_guid         RAW(16),
    target_type         VARCHAR2(64),
    type_display_name   VARCHAR2(128),
    target_name         VARCHAR2(256),
    display_name        VARCHAR2(256),
    host_name           VARCHAR2(256),
    emd_url             VARCHAR2(1024),
    timezone_region     VARCHAR2(64),
    cur_status          NUMBER,
    property_value      VARCHAR2(1024),
    platform_name      VARCHAR2(1024),
    platform_id        NUMBER(10),
    property_value_2      VARCHAR2(1024)
  );
/

create or replace type ASPROV_TS_REC_ARRAY is table of ASPROV_TS_REC_TYPE;
/