Rem drv: <create type="pkgdefs" pos="target/target_pkgdef.sql+"/>
Rem
Rem $Header: emcore/source/oracle/sysman/emdrep/sql/core/latest/target/target_ui_pkgdef.sql /st_emcore_10.2.0.4.3db11.2.0.2/1 2010/04/26 20:30:59 bram Exp $
Rem
Rem  target_ui_pkgdef.sql
Rem
Rem Copyright (c) 2004, 2010, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem       target_ui_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       gsbhatia 07/01/05 - New repmgr header impl 
Rem    narkumar    01/05/05 -SQL for aggregate Only 
Rem    narkumar    12/28/04 - Added SQL Query as a parameter 
Rem    narkumar    12/09/04 - Limiting Child Type 
Rem    narkumar    12/03/04 - modified for maximum rows
Rem    narkumar    11/04/04 -Added function for advance search 
Rem    narkumar    09/22/04 - narkumar_targetselectoritem4
Rem    narkumar    08/27/04 - Created
Rem

CREATE OR REPLACE PACKAGE   EM_TARGET_UI
IS

TYPE cursor_type IS REF CURSOR;
TYPE targets_cursor IS REF CURSOR;
g_max_row_num  CONSTANT  NUMBER := 201;

FUNCTION get_value_string(p_package_variable IN VARCHAR2)
RETURN VARCHAR2 ;

PROCEDURE get_targets_info(p_target_guids   IN  mgmt_user_guid_array,
                           p_targets_cursor OUT cursor_type);

FUNCTION get_targets_by_host_with_priv(p_priv_name    IN VARCHAR2,
                                        p_target_type IN VARCHAR2,
                                        p_target_name IN VARCHAR2,
                                        p_host_name   IN VARCHAR2, 
                                        p_target_types IN  MGMT_SHORT_STRING_ARRAY, 
                                        p_max_row_num IN NUMBER,
                                        p_sql_query IN VARCHAR2 default null,
                                        p_sql_for_aggregate IN NUMBER)
RETURN targets_cursor;

FUNCTION  get_targets_by_host_assoc(p_priv_name IN VARCHAR2,
                                    p_target_type IN VARCHAR2,
                                    p_target_name IN VARCHAR2,
                                    p_host_name IN VARCHAR2,
                                    p_target_types IN  MGMT_SHORT_STRING_ARRAY,
                                    p_max_row_num IN NUMBER,
                                    p_sql_query IN VARCHAR2 default null,
                                    p_sql_for_aggregate IN NUMBER,
                                    p_child_type IN VARCHAR2,
                                    p_child_name IN VARCHAR2,
                                    p_child_types IN   MGMT_SHORT_STRING_ARRAY
                                    )
RETURN TARGETS_CURSOR;
PROCEDURE get_types_in_target_selection(p_priv_name        IN  VARCHAR2,
                                        p_target_types_cur OUT cursor_type);
--

END  EM_TARGET_UI;
/
show err