Rem
Rem $Header: ip_serv_pkgdef.sql 31-jul-2005.01:55:51 pmaddi Exp $
Rem
Rem ip_serv_pkgbody.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      ip_serv_pkgbody.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    pmaddi      07/31/05 - pmaddi_bug-4523007
Rem    pmaddi      07/29/05 - header removed 
Rem    pmaddi      07/21/05 - Created
Rem

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

CREATE OR REPLACE PACKAGE ip_svctest AS

TYPE CURSORTYPE IS REF CURSOR;
PROCEDURE get_service_tests(svc_tests_cursor_out OUT CURSORTYPE,
            target_guid_in IN RAW );

PROCEDURE get_test_metrics(met_tests_cursor_out OUT CURSORTYPE,
            target_guid_in IN RAW,
						test_types_in IN SMP_EMD_STRING_ARRAY,
            metric_names_in IN SMP_EMD_STRING_ARRAY,
            metric_columns_in IN SMP_EMD_STRING_ARRAY default null);

PROCEDURE get_test_data(test_bcns_summary_cursor_out OUT CURSORTYPE,
							target_guid_in IN RAW,
							txn_guid_in IN RAW default null,
							start_date_in IN DATE,
							end_date_in IN DATE,
							custom_date_type_in IN NUMBER,
							test_type_in IN VARCHAR,
							is_key_tst_type_in in NUMBER,
							is_key_bcn_type_in in NUMBER,
							metric_name_in IN VARCHAR,
			        metric_columns_in IN SMP_EMD_STRING_ARRAY);

end ip_svctest;

/
show errors;