Rem
Rem $Header: group_eval_pkgdef.sql 15-mar-2005.13:21:09 rpatti Exp $
Rem
Rem group_eval_pkgdef.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      group_eval_pkgdef.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    rpatti      03/15/05 - remove references to comp_target_def table 
Rem    rpatti      10/25/04 - fix typo 
Rem    rpatti      10/15/04 - support the new summary metrics 
Rem    rpinnama    05/16/02 - rpinnama_reorg_rep_scripts_2
Rem    rpinnama    05/16/02 - Created
Rem

--
--   This package holds the collection pl/sql evaluation functions
--      used to evaluate the values of a summary metric for a 
--      composite target.
--
CREATE OR REPLACE PACKAGE EMD_COMPOSITE_TARGETS
IS

-- Package level Type Definition 
   TYPE cursorType IS     REF CURSOR;

-- PURPOSE
--   Procedure to evaluate summary metric values for a given group
--
-- PARAMETERS
--  IN: 
--  target_guid : the group guid
--  metric_guid : the metric being calculated
--  coll_name   : this differentiates for us the multiple 
--                 collections one for each member type/metric combo
--  OUT:
--  metric_result:  array of resulting metric/keyvalue - values.
--
-- NOTES
--
PROCEDURE EVALUATE_SUMMARY_METRICS
(
  v_target_guid         IN RAW,
  v_metric_guid         IN RAW,
  v_coll_name           IN VARCHAR2,
  v_metric_result       OUT MGMT_METRIC_VALUE_ARRAY
);

END EMD_COMPOSITE_TARGETS; 
/
show errors;