Rem
Rem $Header: rca_oob_reports.sql 10-mar-2006.03:46:20 pmaddi Exp $
Rem
Rem rca_oob_reports.sql
Rem
Rem Copyright (c) 2005, 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      rca_oob_reports.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    pmaddi    03/10/06 - Backport pmaddi_bug-4606201 from main 
Rem    pmaddi    09/14/05 - Changing IPMSG_ANY_TARGET_TYPE to 
Rem                         IPMSG_SERVICE_TARGET_TYPES 
Rem    pmaddi    07/31/05 - pmaddi_bug-4523007
Rem    pmaddi    07/21/05 - Created
Rem

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


DECLARE
i_parameters MGMT_IP_PARAM_VALUE_LIST ;
p_parameters MGMT_IP_PARAM_VALUE_LIST ;
p_parameters1 MGMT_IP_PARAM_VALUE_LIST ;
p_parameters2 MGMT_IP_PARAM_VALUE_LIST ;
p_parameters3 MGMT_IP_PARAM_VALUE_LIST ;
l_service_types MGMT_IP_TARGET_TYPES := MGMT_IP_TARGET_TYPES();
l_param_values MGMT_IP_PARAM_VALUE_LIST ;

l_report_definition_guid RAW(16);
l_elem_guid RAW(16);
target_guid RAW(16);
target_name VARCHAR2(256);
l_index         NUMBER;

--CURSOR servicesCursor IS
--      SELECT TARGET_TYPE
--      FROM mgmt_type_properties
--      WHERE PROPERTY_NAME ='is_service' and property_value=1;
BEGIN



l_service_types := MGMT_IP_TARGET_TYPES();
l_service_types.extend(3);
l_service_types(1) := 'generic_service';
l_service_types(2) := 'aggregate_service';
l_service_types(3) := 'website';
--FOR record IN servicesCursor
--   LOOP
--         l_index := l_index + 1;
--    l_service_types.extend(1);
--		l_service_types(l_index) := record.TARGET_TYPE;
--END LOOP;


--rca reports

BEGIN
MGMT_IP.delete_report_by_title('SYSMAN', 'IPMSG_RCAIMPACTS_REPORT', 0);
EXCEPTION WHEN OTHERS THEN NULL;
END;

l_param_values := MGMT_IP_PARAM_VALUE_LIST();
			   l_param_values.extend(3);
				l_param_values(1) := MGMT_IP_PARAM_VALUE_RECORD(
			    'oracle.sysman.eml.ip.render.elem.TimePeriodOption',
				  'true');
			   l_param_values(2) := MGMT_IP_PARAM_VALUE_RECORD(
					'oracle.sysman.eml.ip.render.elem.TimePeriodUserCust',
					'true');
			  	l_param_values(3) := MGMT_IP_PARAM_VALUE_RECORD(
					'oracle.sysman.eml.ip.render.elem.TimePeriodParam',
					'0:1');
l_report_definition_guid := mgmt_ip.create_report_definition (
													p_title_nlsid                   => 'IPMSG_RCAIMPACTS_REPORT',
													p_description_nlsid             => 'IPMSG_RCAIMPACTS_REPORT',
													p_owner => 'SYSMAN',
													p_category_nlsid => 'IPMSG_MONITORING_CATEGORY', 
													p_sub_category_nlsid => 'IPMSG_RCA_SUBCAT',
													p_late_binding_target_types => NULL,
													p_internal_use_only => 0,
													p_public_report => 0,
													p_system_report => 1,
													p_style => 'BLAF',
													p_show_navigation => 1,
													p_product_name => 'EM',
													p_component_name =>'Rca Report',
													p_version => '10.2',													
													p_parameters    =>  l_param_values);

i_parameters := MGMT_IP_PARAM_VALUE_LIST();
i_parameters.extend(4);
i_parameters(1) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TextParamBean.textMessage','IPMSG_RCAIMPACTS_REPORT_HELP');
i_parameters(2) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TextParamBean.textStyle','OraInstructionText');
i_parameters(3) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TextParamBean.textDestination','');
i_parameters(4) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TextParamBean.textResourceBundleName', 'oracle.sysman.resources.eml.ip.emr.webapps.IPWebappsResource');

p_parameters := MGMT_IP_PARAM_VALUE_LIST();
p_parameters.extend(8);
p_parameters(1) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TimePeriodParam','0:0');
p_parameters(2) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TimePeriodOption','true');
p_parameters(3) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TimezoneRegion','');
p_parameters(4) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TimePeriodUserCust','false');
p_parameters(5) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TargetsParamController.InternalTargetType','null');
p_parameters(6) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.SetTargetsOption.InheritOrOverride','oracle.sysman.eml.ip.render.elem.SetTargetsOption.InheritOrOverride.InheritTargetsSelectedByViewer');
p_parameters(7) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TimePeriodOption.InheritOrOverride','oracle.sysman.eml.ip.render.elem.TimePeriodOption.InheritOrOverride.InheritReportTimePeriod');
p_parameters(8) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.webapps.rca.RcaParamBean.type','Impacts');

l_elem_guid := MGMT_IP.add_element_to_report_def(l_report_definition_guid, 'IPMSG_STYLED_TEXT', 
                                                 'IPMSG_ANY_TARGET_TYPE', '', 
                                                 1, 1, 
                                                 i_parameters, null, '');

l_elem_guid := MGMT_IP.add_element_to_report_def(l_report_definition_guid, 'IPMSG_RCAIMPACTS_ELEM', 
                                                 'IPMSG_SERVICE_TARGET_TYPES', '', 
                                                 2,2,
                                                 p_parameters, null,  p_header_nlsid =>'IPMSG_RCAIMPACTS_IMP_ELEM_DESC');

p_parameters(8) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.webapps.rca.RcaParamBean.type','Outage');

l_elem_guid := MGMT_IP.add_element_to_report_def(l_report_definition_guid, 'IPMSG_RCAIMPACTS_ELEM', 
                                                 'IPMSG_SERVICE_TARGET_TYPES', '', 
                                                 3,3,
                                                 p_parameters, null,  p_header_nlsid =>'IPMSG_RCAIMPACTS_DUR_ELEM_DESC');


BEGIN
MGMT_IP.delete_report_by_title('SYSMAN', 'IPMSG_RCAIMPACTS_REPORT_ST', 0);
EXCEPTION WHEN OTHERS THEN NULL;
END;

l_report_definition_guid := mgmt_ip.create_report_definition (
													p_title_nlsid                   => 'IPMSG_RCAIMPACTS_REPORT_ST',
													p_description_nlsid             => 'IPMSG_RCAIMPACTS_REPORT_ST',
													p_owner => 'SYSMAN',
													p_category_nlsid => 'IPMSG_MONITORING_CATEGORY', 
													p_sub_category_nlsid => 'IPMSG_RCA_SUBCAT',
													p_late_binding_target_types => l_service_types,
													p_internal_use_only => 0,
													p_public_report => 0,
													p_system_report => 1,
													p_style => 'BLAF',
													p_show_navigation => 1,
													p_product_name => 'EM',
													p_component_name =>'Rca Report',
													p_version => '10.2',													
													p_parameters    =>  l_param_values);

i_parameters := MGMT_IP_PARAM_VALUE_LIST();
i_parameters.extend(4);
i_parameters(1) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TextParamBean.textMessage','IPMSG_RCAIMPACTS_REPORT_ST_HELP');
i_parameters(2) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TextParamBean.textStyle','OraInstructionText');
i_parameters(3) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TextParamBean.textDestination','');
i_parameters(4) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TextParamBean.textResourceBundleName', 'oracle.sysman.resources.eml.ip.emr.webapps.IPWebappsResource');

p_parameters := MGMT_IP_PARAM_VALUE_LIST();
p_parameters.extend(8);
p_parameters(1) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TimePeriodParam','0:0');
p_parameters(2) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TimePeriodOption','true');
p_parameters(3) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TimezoneRegion','');
p_parameters(4) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TimePeriodUserCust','false');
p_parameters(5) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TargetsParamController.InternalTargetType','null');
p_parameters(6) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.SetTargetsOption.InheritOrOverride','oracle.sysman.eml.ip.render.elem.SetTargetsOption.InheritOrOverride.InheritTargetsSelectedByViewer');
p_parameters(7) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.TimePeriodOption.InheritOrOverride','oracle.sysman.eml.ip.render.elem.TimePeriodOption.InheritOrOverride.InheritReportTimePeriod');
p_parameters(8) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.webapps.rca.RcaParamBean.type','Impacts');

l_elem_guid := MGMT_IP.add_element_to_report_def(l_report_definition_guid, 'IPMSG_STYLED_TEXT', 
                                                 'IPMSG_ANY_TARGET_TYPE', '', 
                                                 1, 1, 
                                                 i_parameters, null, '');

l_elem_guid := MGMT_IP.add_element_to_report_def(l_report_definition_guid, 'IPMSG_RCAIMPACTS_ELEM_ST', 
                                                 'IPMSG_SERVICE_TARGET_TYPES', '', 
                                                 2,2,
                                                 p_parameters, null,  p_header_nlsid =>'IPMSG_RCAIMPACTS_IMP_ELEM_DESC');

p_parameters(8) := new mgmt_ip_param_value_record('oracle.sysman.eml.ip.render.elem.webapps.rca.RcaParamBean.type','Outage');

l_elem_guid := MGMT_IP.add_element_to_report_def(l_report_definition_guid, 'IPMSG_RCAIMPACTS_ELEM_ST', 
                                                 'IPMSG_SERVICE_TARGET_TYPES', '', 
                                                 3,3,
                                                 p_parameters, null,  p_header_nlsid =>'IPMSG_RCAIMPACTS_DUR_ELEM_DESC');



COMMIT;
END;
/