Rem
Rem $Header: group_cpf_pkgdef.sql 24-nov-2004.03:14:33 mningomb Exp $
Rem
Rem critical_jobstatus_pkgdef.sql
Rem
Rem Copyright (c) 2002, 2004, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      critical_jobstatus_pkgdef.sql
Rem
Rem    DESCRIPTION
Rem      PL/SQL for checking status of critical job
Rem
Rem    NOTES
Rem    
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem       mningomb 11/24/04 - mningomb_cpfps
Rem       mningomb 11/17/04 - 
Rem    mningomb   10/21/04    Created
Rem

CREATE OR REPLACE PACKAGE GROUP_PATCH_ADVISORIES
  IS

  TYPE advisories_ref_cur IS REF CURSOR;

   PROCEDURE get_group_patch_advisories
   ( p_group_name in varchar2,
     p_group_type in varchar2,
     p_advisories OUT advisories_ref_cur);

   PROCEDURE get_group_advisories_count
   ( p_group_name in varchar2,
     p_group_type in varchar2,
     p_advisories OUT varchar2);

  PROCEDURE get_group_affected_homes_count
  (  p_group_name in varchar2,
     p_group_type in varchar2,
     p_homes OUT varchar2); 
 
END; 
/
show errors