Rem
Rem $Header: rca_oob_reports.sql 09-oct-2006.03:55:50 gsambamu Exp $
Rem
Rem rca_oob_reports.sql
Rem
Rem Copyright (c) 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 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;
BEGIN
l_service_types := MGMT_IP_TARGET_TYPES();
l_service_types.extend(4);
l_service_types(1) := 'generic_service';
l_service_types(2) := 'aggregate_service';
l_service_types(3) := 'website';
l_service_types(4) := 'formsapp';
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 => l_repository_owner,
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');
-- Drop the report IPMSG_RCAIMPACTS_REPORT
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 => l_repository_owner,
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');
COMMIT;
END;
/