Rem DO NOT PUT HEADER HERE BECAUSE THIS IS REFERENCED BY
Rem ip_data_upgrade.sql ALREADY.
Rem
Rem $Header: sysdash_outofbox_reports.sql 28-aug-2005.22:28:38 vmotamar Exp $
Rem
Rem sysdash_outofbox_reports.sql
Rem
Rem Copyright (c) 2005, Oracle.  All rights reserved.  
Rem
Rem    NAME
Rem      sysdash_outofbox_reports.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      The piece of code mentioned in the bug is present in v102010/ip of 
Rem      EMCORE Beta branch. Currently it is present in v102020/ip of EMCORE
Rem      Main branch. Moving it to v102010/ip of EMCORE Main branch.
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    vmotamar    08/28/05 - Created
Rem

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

DECLARE 
    l_param_values  MGMT_IP_PARAM_VALUE_LIST;
    l_report_guid   RAW(16);
    l_element_guid  RAW(16);

--------------------SYSTEM MONITORING DASHBOARD HIDDEN REPORT BEGIN-----------------------
  
BEGIN
    l_report_guid := mgmt_ip.create_report_definition (
      p_title_nlsid                   => 'Dashboard_Service_Title_NLSID',
      p_description_nlsid             => 'Dashboard_Service_Desc_NLSID',
      p_owner                         => mgmt_user.GET_REPOSITORY_OWNER,
      p_category_nlsid                => 'IPMSG_MONITORING_CATEGORY', 
      p_sub_category_nlsid            => 'IPMSG_DASHBOARDS_CATEGORY',
      p_internal_use_only             =>  1,
      p_style                         => 'DASHBOARD',
      p_help_topic_id                 => 'info_pub_gc_cs_ob_smd',
      p_show_navigation               => 0,
      p_public_report                 => 1
        );

    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.SysDashSelectedTarget',
      null);
    l_param_values(2) := MGMT_IP_PARAM_VALUE_RECORD(
      'oracle.sysman.eml.ip.render.elem.SysDashRefreshTime',
      '2');
    l_param_values(3) := MGMT_IP_PARAM_VALUE_RECORD(
      'oracle.sysman.eml.ip.render.elem.SysDashTargetViewType',
      'Full');
      
    l_element_guid := mgmt_ip.add_element_to_report_def (
      p_report_guid         => l_report_guid,
      p_element_name_nlsid  => 'IPMSG_SYSTEM_DASHBOARD',
      p_element_type_nlsid  => 'IPMSG_SYSTEM_DASHBOARD_TARGET_TYPE',
      p_header_nlslid       => null,
      p_element_order       => 1, 
      p_element_row         => 1, 
      p_parameters          => l_param_values,
      p_targets             => null
        );      
COMMIT;  

--------------------SYSTEM MONITORING DASHBOARD HIDDEN REPORT END----------------------------

END;
/