Rem
Rem $Header: serv_oob_reports.sql 09-oct-2006.03:55:56 gsambamu Exp $
Rem
Rem serv_oob_reports.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      serv_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    gsambamu    10/09/06 - Backport gsambamu_bug-5516168 from main
Rem    gsambamu    09/27/06 - Bug Fix 5516168: Modified the report owner to be
Rem                           the REP OWNER
Rem    yxie        04/10/06 - Created
Rem

SET ECHO ON
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_repository_owner VARCHAR2(256) := MGMT_USER.GET_REPOSITORY_OWNER;

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
--      AND TARGET_TYPE = 'aggregate_service';
BEGIN



l_service_types := MGMT_IP_TARGET_TYPES();
l_service_types.extend(3);
l_service_types(1) := 'generic_service';
l_service_types(2) := 'website';
l_service_types(3) := 'formsapp';

--service reports

BEGIN
MGMT_IP.delete_report_by_title('SYSMAN', 'IPMSG_SERV_TEST_REP', 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:0');
l_report_definition_guid := mgmt_ip.create_report_definition (
													p_title_nlsid                   => 'IPMSG_SERV_TEST_REP',
													p_description_nlsid             => 'IPMSG_SERV_TEST_REP',
													p_owner => l_repository_owner,
													p_category_nlsid => 'IPMSG_MONITORING_CATEGORY', 
													p_sub_category_nlsid => 'IPMSG_SERV_TEST_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 =>'Service Tests',
													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_SERV_TESTSUMM_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.tp.viewBy','2');

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_SERV_TEST_ELEM', 
                                                 'IPMSG_SERVICE_TARGET_TYPES', '', 
                                                 2,2,
                                                 p_parameters, null,  p_header_nlsid =>'IPMSG_SERV_TEST_ELEM_HDR');

BEGIN
MGMT_IP.delete_report_by_title('SYSMAN', 'IPMSG_SERV_TEST_REP_BCN', 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:0');
l_report_definition_guid := mgmt_ip.create_report_definition (
													p_title_nlsid                   => 'IPMSG_SERV_TEST_REP_BCN',
													p_description_nlsid             => 'IPMSG_SERV_TEST_REP_BCN',
													p_owner => l_repository_owner,
													p_category_nlsid => 'IPMSG_MONITORING_CATEGORY', 
													p_sub_category_nlsid => 'IPMSG_SERV_TEST_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 =>'Service Tests',
													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_SERV_TESTSUMM_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.tp.viewBy','1');

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_SERV_TEST_ELEM', 
                                                 'IPMSG_SERVICE_TARGET_TYPES', '', 
                                                 2,2,
                                                 p_parameters, null,  p_header_nlsid =>'IPMSG_SERV_TEST_ELEM_HDR');

COMMIT;
END;
/