Rem drv: <create type="pkgdefs" pos="template_pkgdef.sql+"/>
Rem
Rem $Header: em_comparison_ui_pkgdef.sql 23-mar-2007.03:55:01 ssukavan Exp $
Rem
Rem em_comparison_ui_pkgdef.sql
Rem
Rem Copyright (c) 2006, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      em_comparison_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    ssukavan    03/23/07 - Adding new constants.
Rem    paachary    03/30/06 - Created
Rem

CREATE OR REPLACE PACKAGE em_comparison_ui
AS
    TYPE cursor_type IS REF CURSOR;
    NO_GUID CONSTANT VARCHAR2(32)  := '00000000000000000000000000000000';

    PROCEDURE set_comparison_summary_details(   p_job_id          IN VARCHAR2, 
                                                p_execution_id    IN VARCHAR2, 
                                                p_template_owner  IN VARCHAR2, 
                                                p_job_owner       IN VARCHAR2, 
                                                p_template_name   IN VARCHAR2, 
                                                p_target_type     IN VARCHAR2, 
                                                p_target_name     IN VARCHAR2, 
                                                p_job_name        IN VARCHAR2, 
                                                p_job_type        IN VARCHAR2, 
                                                p_result          IN VARCHAR2, 
                                                p_area_of_diff    IN VARCHAR2,
                                                p_apply_option    IN VARCHAR2);

    PROCEDURE get_comparison_summary_details(p_execution_id        IN VARCHAR2,
                                             p_comp_summary_cursor OUT cursor_type,
                                             p_return_count        OUT NUMBER);

    PROCEDURE get_last_applied_targets(p_template_name  IN VARCHAR2,
                                       p_template_owner IN VARCHAR2,
                                       p_apply_option   OUT NUMBER,
                                       p_targets_list   OUT cursor_type);

END em_comparison_ui;
/

show errors;