Rem
Rem $Header: ip_rca_pkgdef.sql 29-jul-2005.03:25:34 pmaddi Exp $
Rem
Rem ip_rca_pkgdef.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      ip_rca_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    pmaddi      07/29/05 - 
Rem    chyu        07/20/05 - remove the ECHO OFF statement 
Rem    gsbhatia    07/13/05 - Insert repmgr header 
Rem    pmaddi      07/03/05 - pmaddi_rca_report
Rem    pmaddi      07/03/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_rca AS

-- Declaring the cursor for later use.
TYPE CURSORTYPE IS REF CURSOR;


PROCEDURE get_most_significant_impacts(rca_impacts_cursor_out OUT CURSORTYPE,
                                    target_guid_in IN VARCHAR2,
                                    startDate IN DATE,
                                    endDate IN DATE,
												tz_console IN VARCHAR2);

PROCEDURE get_cause_impacts(rca_impacts_cursor_out OUT CURSORTYPE,
                           target_guid_in IN VARCHAR2,
                           startDate IN DATE,
                           endDate IN DATE,
									tz_console IN VARCHAR2);

end ip_rca;
/
show errors;