REM drv: <create type="pkgdefs"/>
Rem
Rem $Header: ts_pkgdefs.sql 13-mar-2006.21:58:40 vsagar Exp $
Rem
Rem ts_pkgdefs.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      ts_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    vsagar      01/03/06 -
Rem    tasingh     12/08/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 PACKAGE MGMT_ASPROV_TS_PKG
IS

TYPE OUTPUT_REF_CURSOR IS REF CURSOR;

  --
  -- NAME: get_targets_info
  --
  -- PACKAGE: mgmt_ts_pkg
  --
  -- PURPOSE:
  --   Get the targets matching the search criteria.
  --
  -- IN PARAMETERS:
  --   p_target_type VARCHAR2 the Target Type.
  --   p_target_name VARCHAR2 the Target Name.
  --   p_on_host     VARCHAR2 the host name on which the target is running.
  --   p_version     VARCHAR2 the target's version.
  --   p_platform_id VARCHAR2 the platform ID of the host on which target is
  --                          running.
  --
  -- OUT PARAMETERS:
  --   None.
  --
  -- ERROR CODES:
  --   None.
  --
  -- NOTES:
  --   None.
  --
FUNCTION get_targets(
  p_target_type in VARCHAR2,
  p_target_name in VARCHAR2,
  p_on_host     in VARCHAR2,
  p_version     in VARCHAR2,
  p_platform_id in VARCHAR2,
  p_vendor      in VARCHAR2,
  p_base_version in VARCHAR2
) RETURN OUTPUT_REF_CURSOR;

END;
/

show errors