Rem
Rem $Header: patching_jobs_util_spec.sql 22-mar-2007.23:34:10 kavkrish Exp $
Rem
Rem patching_jobs_util_spec.sql
Rem
Rem Copyright (c) 2005, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      patching_jobs_util_spec.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    kavkrish    03/22/07 - bug-5943583 : Adding argument for  'FUNCTION_GET_SIDS' 
Rem    abhalla     08/07/06 - Backport abhalla_coretxn4 from main
Rem    abhalla     07/30/06 - fixing bug 4870388, changing method
Rem                           function_get_sids to return all sids of a home
Rem    shgangul    09/08/05 - Bug 4596343: Filter listeners based on 
Rem                           machine name as well 
Rem    abhalla     05/04/05 - Make non-jobowner to add new parameters 
Rem    mningomb    04/13/05 - mningomb_dbpatch
Rem    mningomb    04/10/05 - 
Rem    shgangul    04/01/05 - Added procedures to get listeners and sids
Rem    mningomb    03/29/05 - Created
Rem

CREATE OR REPLACE TYPE TOKEN_LIST IS TABLE OF VARCHAR2(256)
/
CREATE OR REPLACE PACKAGE MGMT_OH_PATCHING_UTIL
IS

--TYPE TOKEN_LIST IS TABLE OF VARCHAR2(100);
PROCEDURE filter_homes_creds_on_host(p_job_id RAW,
                 p_execution_id RAW,
                 index_of_node int,
                 job_owner varchar2
                );
PROCEDURE filter_home_targets(p_job_id RAW,
                 p_execution_id RAW,
                 index_of_node int,
                 index_of_home int,
                 job_owner varchar2
                );
FUNCTION function_get_listeners
                (p_dest_home MGMT_TARGET_PROPERTIES.PROPERTY_VALUE%TYPE,
                 p_machine_name MGMT_TARGET_PROPERTIES.PROPERTY_VALUE%TYPE
                 )
         RETURN VARCHAR2;
FUNCTION function_get_sids
                (p_dest_home MGMT_TARGET_PROPERTIES.PROPERTY_VALUE%TYPE,
                 p_host_name MGMT_TARGETS.HOST_NAME%TYPE)
         RETURN VARCHAR2;
END; -- Package spec
/
show errors