Rem drv: <create type="pkgdefs" condition="EM_REPOS_MODE=CENTRAL"/>
Rem
Rem $Header: overview_pkgdefs.sql 06-may-2008.17:14:24 nachen Exp $
Rem
Rem overview_pkgdefs.sql
Rem
Rem Copyright (c) 2004, 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      overview_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    nachen      05/29/08 - XbranchMerge nachen_bug-7010907 from
Rem                           st_emdbsa_11.1
Rem    nachen      05/06/08 - this pkg is for grid control only
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    nachen      04/04/05 - remove load_nls_strings 
Rem    nachen      10/18/04 - remove comment out
Rem    nachen      10/14/04 - nachen_db_overview_report_1
Rem    nachen      10/13/04 - Created
Rem

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


create or replace package mgmt_database_overview
as
TYPE CURSOR_TYPE IS REF CURSOR;
	procedure create_report_definition(l_title_nlsid IN VARCHAR2, 
                                     l_description_nlsid IN VARCHAR2, 
                                     l_owner IN VARCHAR2, 
                                     l_category_nlsid IN VARCHAR2, 
                                     l_sub_category_nlsid IN VARCHAR2);
  procedure get_database_and_instance_info (result_cursor_out        OUT CURSOR_TYPE,
                                            tgt_guid_in              IN  MGMT_IP_TGT_GUID_ARRAY,
                                            start_date_in            IN DATE DEFAULT NULL,
                                            end_date_in              IN DATE DEFAULT NULL);
end mgmt_database_overview;
/

show errors;