Rem drv: <create type="pkgdefs" pos="license/mgmt_license_pkgdef.sql+"/>
Rem
Rem $Header: license_report_pkgdef.sql 01-jul-2005.17:28:12 gsbhatia Exp $
Rem
Rem license_report_pkgdef.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      license_report_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    vkgarg      03/17/05 - vkgarg_bug-3996615
Rem    vkgarg      03/10/05 - Created
Rem

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

CREATE OR REPLACE package em_licensing_report
AS

-- PROCEDURE : consolidated_report
-- Purpose : To populate the contents of the "Out of Box" Licensing Reports
-- Input Parameters
-- p_include_targets (0:Parent (Licensable) Targets, 1:ALL Targets (Include both Parent and Dependent))
-- p_agree_access (0, Agree Access Not Confirmed, 1: Agree Access Confirmed, 2 : All (do not consider agree access) 
-- OUTPUT Parameter
-- p_target_array : return an array of object and each object maps to a row in the licensing report 
PROCEDURE consolidated_report
(
    p_include_targets IN  NUMBER default 0,
    p_agree_access    IN  NUMBER DEFAULT 0,
	p_target_array    OUT em_license_report_array
);

end em_licensing_report;
/