text: prompt --application/pages/page_00012
  begin
  --   Manifest
  --     PAGE: 00012
  --   Manifest End
  wwv_flow_api.component_begin (
   p_version_yyyy_mm_dd=>'2021.10.15'
  ,p_release=>'21.2.2'
  ,p_default_workspace_id=>9690978936188613
  ,p_default_application_id=>130
  ,p_default_id_offset=>3010675395498185750
  ,p_default_owner=>'ILA'
  );
  wwv_flow_api.create_page(
   p_id=>12
  ,p_user_interface_id=>wwv_flow_api.id(5594253093425280902)
  ,p_name=>'Top Users'
  ,p_alias=>'TOP-USERS'
  ,p_step_title=>'Top Users'
  ,p_reload_on_submit=>'A'
  ,p_warn_on_unsaved_changes=>'N'
  ,p_first_item=>'AUTO_FIRST_ITEM'
  ,p_autocomplete_on_off=>'ON'
  ,p_group_id=>wwv_flow_api.id(5767351206324175852)
  ,p_page_template_options=>'#DEFAULT#'
  ,p_protection_level=>'C'
  ,p_help_text=>'No help is available for this page.'
  ,p_last_upd_yyyymmddhh24miss=>'20200116130021'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(4752284716036455194)
  ,p_plug_name=>'Top Users'
  ,p_region_template_options=>'#DEFAULT#'
  ,p_escape_on_http_output=>'Y'
  ,p_plug_template=>wwv_flow_api.id(4439219934126548197)
  ,p_plug_display_sequence=>30
  ,p_plug_new_grid_row=>false
  ,p_plug_new_grid_column=>false
  ,p_plug_source_type=>'NATIVE_JET_CHART'
  ,p_plug_query_num_rows=>15
  ,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
  ,p_plug_display_condition_type=>'VAL_OF_ITEM_IN_COND_EQ_COND2'
  ,p_plug_display_when_condition=>'P12_VIEW_AS'
  ,p_plug_display_when_cond2=>'CHART'
  );
  wwv_flow_api.create_jet_chart(
   p_id=>wwv_flow_api.id(4752284777460455195)
  ,p_region_id=>wwv_flow_api.id(4752284716036455194)
  ,p_chart_type=>'donut'
  ,p_animation_on_display=>'none'
  ,p_animation_on_data_change=>'none'
  ,p_data_cursor=>'auto'
  ,p_data_cursor_behavior=>'auto'
  ,p_hide_and_show_behavior=>'none'
  ,p_hover_behavior=>'none'
  ,p_stack=>'off'
  ,p_stack_label=>'off'
  ,p_connect_nulls=>'Y'
  ,p_value_position=>'auto'
  ,p_value_format_type=>'decimal'
  ,p_value_decimal_places=>0
  ,p_value_format_scaling=>'auto'
  ,p_sorting=>'label-asc'
  ,p_fill_multi_series_gaps=>true
  ,p_tooltip_rendered=>'Y'
  ,p_show_series_name=>true
  ,p_show_group_name=>true
  ,p_show_value=>true
  ,p_show_label=>true
  ,p_show_row=>true
  ,p_show_start=>true
  ,p_show_end=>true
  ,p_show_progress=>true
  ,p_show_baseline=>true
  ,p_legend_rendered=>'on'
  ,p_legend_position=>'end'
  ,p_overview_rendered=>'off'
  ,p_pie_other_threshold=>.02
  ,p_pie_selection_effect=>'highlight'
  ,p_horizontal_grid=>'auto'
  ,p_vertical_grid=>'auto'
  ,p_gauge_orientation=>'circular'
  ,p_gauge_plot_area=>'on'
  ,p_show_gauge_value=>true
  );
  wwv_flow_api.create_jet_chart_series(
   p_id=>wwv_flow_api.id(4752284953648455196)
  ,p_chart_id=>wwv_flow_api.id(4752284777460455195)
  ,p_seq=>10
  ,p_name=>'Top Users'
  ,p_data_source_type=>'SQL'
  ,p_data_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
  'select',
  '    lower(USERID)                   as THE_USER,',
  '    count(*)                        as PAGE_EVENTS,',
  '    median(ELAP)                    as MEDIAN_ELAPSED,',
  '    sum(NUM_ROWS)                   as ROWS_FETCHED,',
  '    sum(decode(IR_SEARCH,null,0,1)) as IR_SEARCHES,',
  '    sum(decode(SQLERRM,null,0,1))   as ERRORS,',
  '    sum(CONTENT_LENGTH)             as CONTENT_SERVED,',
  '    max(time_stamp)                 as MOST_RECENT',
  'from',
  '    apex_activity_log l',
  'where',
  '    flow_id = :app_id  and ',
  '    time_stamp > sysdate - to_number(:P12_SINCE,''9999999990.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')',
  'and',
  '    userid is not null',
  'group by',
  '    lower(userid)',
  'order by 2 desc'))
  ,p_items_value_column_name=>'PAGE_EVENTS'
  ,p_items_label_column_name=>'THE_USER'
  ,p_items_label_rendered=>true
  ,p_items_label_position=>'outsideSlice'
  ,p_items_label_display_as=>'ALL'
  ,p_threshold_display=>'onIndicator'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(7576833013180557183)
  ,p_plug_name=>'Button Bar'
  ,p_region_template_options=>'#DEFAULT#:t-ButtonRegion--noPadding:t-ButtonRegion--noUI'
  ,p_plug_template=>wwv_flow_api.id(4439206381386548176)
  ,p_plug_display_sequence=>10
  ,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
  ,p_attribute_01=>'N'
  ,p_attribute_02=>'HTML'
  ,p_attribute_03=>'N'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(8869870921005844484)
  ,p_plug_name=>'Breadcrumb'
  ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
  ,p_component_template_options=>'#DEFAULT#'
  ,p_plug_template=>wwv_flow_api.id(4439222394230548202)
  ,p_plug_display_sequence=>20
  ,p_plug_display_point=>'REGION_POSITION_01'
  ,p_menu_id=>wwv_flow_api.id(8850087331635351449)
  ,p_plug_source_type=>'NATIVE_BREADCRUMB'
  ,p_menu_template_id=>wwv_flow_api.id(4439237769043548253)
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(8869871323980844485)
  ,p_plug_name=>'Top Users'
  ,p_region_template_options=>'#DEFAULT#:js-showMaximizeButton'
  ,p_plug_template=>wwv_flow_api.id(4439219427293548192)
  ,p_plug_display_sequence=>40
  ,p_plug_new_grid_row=>false
  ,p_plug_new_grid_column=>false
  ,p_query_type=>'SQL'
  ,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
  'select',
  '    lower(USERID)                   as THE_USER,',
  '    count(*)                        as PAGE_EVENTS,',
  '    median(ELAP)                    as MEDIAN_ELAPSED,',
  '    sum(NUM_ROWS)                   as ROWS_FETCHED,',
  '    sum(decode(IR_SEARCH,null,0,1)) as IR_SEARCHES,',
  '    sum(decode(SQLERRM,null,0,1))   as ERRORS,',
  '    sum(CONTENT_LENGTH)             as CONTENT_SERVED,',
  '    max(time_stamp)                 as MOST_RECENT',
  'from',
  '    apex_activity_log l',
  'where',
  '    flow_id = :app_id  and ',
  '    time_stamp > sysdate - to_number(:P12_SINCE,''9999999990.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')',
  'and',
  '    userid is not null',
  'group by',
  '    lower(userid)'))
  ,p_plug_source_type=>'NATIVE_IR'
  ,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
  ,p_plug_display_condition_type=>'VAL_OF_ITEM_IN_COND_EQ_COND2'
  ,p_plug_display_when_condition=>'P12_VIEW_AS'
  ,p_plug_display_when_cond2=>'REPORT'
  );
  wwv_flow_api.create_worksheet(
   p_id=>wwv_flow_api.id(8869871441471844485)
  ,p_name=>'Top Users'
  ,p_max_row_count=>'10000'
  ,p_max_row_count_message=>'This query returns more than #MAX_ROW_COUNT# rows, please filter your data to ensure complete results.'
  ,p_no_data_found_message=>'No data found.'
  ,p_allow_save_rpt_public=>'Y'
  ,p_allow_report_categories=>'N'
  ,p_show_nulls_as=>'-'
  ,p_pagination_type=>'ROWS_X_TO_Y'
  ,p_pagination_display_pos=>'BOTTOM_RIGHT'
  ,p_report_list_mode=>'TABS'
  ,p_lazy_loading=>false
  ,p_show_detail_link=>'N'
  ,p_show_notify=>'Y'
  ,p_show_calendar=>'N'
  ,p_download_formats=>'CSV:HTML'
  ,p_enable_mail_download=>'Y'
  ,p_allow_exclude_null_values=>'N'
  ,p_allow_hide_extra_columns=>'N'
  ,p_icon_view_columns_per_row=>1
  ,p_owner=>'PATRICKM'
  ,p_internal_uid=>3753948556023392056
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(8869872328826844488)
  ,p_db_column_name=>'MOST_RECENT'
  ,p_display_order=>8
  ,p_column_identifier=>'H'
  ,p_column_label=>'Most Recent'
  ,p_column_type=>'DATE'
  ,p_heading_alignment=>'LEFT'
  ,p_format_mask=>'SINCE'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(5714494506591983384)
  ,p_db_column_name=>'THE_USER'
  ,p_display_order=>9
  ,p_column_identifier=>'I'
  ,p_column_label=>'The User'
  ,p_column_type=>'STRING'
  ,p_heading_alignment=>'LEFT'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(5714494595584983388)
  ,p_db_column_name=>'PAGE_EVENTS'
  ,p_display_order=>10
  ,p_column_identifier=>'J'
  ,p_column_label=>'Page Events'
  ,p_column_type=>'NUMBER'
  ,p_heading_alignment=>'RIGHT'
  ,p_column_alignment=>'RIGHT'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(5714494707003983388)
  ,p_db_column_name=>'MEDIAN_ELAPSED'
  ,p_display_order=>11
  ,p_column_identifier=>'K'
  ,p_column_label=>'Median Elapsed'
  ,p_column_type=>'NUMBER'
  ,p_heading_alignment=>'RIGHT'
  ,p_column_alignment=>'RIGHT'
  ,p_format_mask=>'999G999G999G999G999G990D0000'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(5714494810271983388)
  ,p_db_column_name=>'ROWS_FETCHED'
  ,p_display_order=>12
  ,p_column_identifier=>'L'
  ,p_column_label=>'Rows Fetched'
  ,p_column_type=>'NUMBER'
  ,p_heading_alignment=>'RIGHT'
  ,p_column_alignment=>'RIGHT'
  ,p_format_mask=>'999G999G999G999G999G990'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(5714494902549983389)
  ,p_db_column_name=>'IR_SEARCHES'
  ,p_display_order=>13
  ,p_column_identifier=>'M'
  ,p_column_label=>'Ir Searches'
  ,p_column_type=>'NUMBER'
  ,p_heading_alignment=>'RIGHT'
  ,p_column_alignment=>'RIGHT'
  ,p_format_mask=>'999G999G999G999G999G990'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(5714495009593983389)
  ,p_db_column_name=>'ERRORS'
  ,p_display_order=>14
  ,p_column_identifier=>'N'
  ,p_column_label=>'Errors'
  ,p_column_type=>'NUMBER'
  ,p_heading_alignment=>'RIGHT'
  ,p_column_alignment=>'RIGHT'
  ,p_format_mask=>'999G999G999G999G999G990'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(5714495117637983390)
  ,p_db_column_name=>'CONTENT_SERVED'
  ,p_display_order=>15
  ,p_column_identifier=>'O'
  ,p_column_label=>'Content Served'
  ,p_column_type=>'NUMBER'
  ,p_heading_alignment=>'RIGHT'
  ,p_column_alignment=>'RIGHT'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_rpt(
   p_id=>wwv_flow_api.id(8869872429366844697)
  ,p_application_user=>'APXWS_DEFAULT'
  ,p_report_seq=>10
  ,p_report_alias=>'9206333'
  ,p_status=>'PUBLIC'
  ,p_is_default=>'Y'
  ,p_display_rows=>15
  ,p_report_columns=>'THE_USER:PAGE_EVENTS:MEDIAN_ELAPSED:ROWS_FETCHED:IR_SEARCHES:ERRORS:MOST_RECENT'
  ,p_sort_column_1=>'MOST_RECENT'
  ,p_sort_direction_1=>'DESC'
  ,p_sort_column_2=>'PAGE_EVENTS'
  ,p_sort_direction_2=>'DESC'
  ,p_sort_column_3=>'Page_Events'
  ,p_sort_direction_3=>'DESC'
  ,p_sort_column_4=>'Page Events'
  ,p_sort_direction_4=>'DESC'
  );
  wwv_flow_api.create_page_button(
   p_id=>wwv_flow_api.id(7576886102060601276)
  ,p_button_sequence=>10
  ,p_button_plug_id=>wwv_flow_api.id(8869871323980844485)
  ,p_button_name=>'RESET_REPORT'
  ,p_button_action=>'REDIRECT_PAGE'
  ,p_button_template_options=>'#DEFAULT#'
  ,p_button_template_id=>wwv_flow_api.id(4439236916357548246)
  ,p_button_image_alt=>'Reset'
  ,p_button_position=>'RIGHT_OF_IR_SEARCH_BAR'
  ,p_button_redirect_url=>'f?p=&APP_ID.:12:&SESSION.::&DEBUG.:RP,12,RIR::'
  ,p_icon_css_classes=>'fa-undo-alt'
  );
  wwv_flow_api.create_page_item(
   p_id=>wwv_flow_api.id(5138045270055145984)
  ,p_name=>'P12_VIEW_AS'
  ,p_item_sequence=>20
  ,p_item_plug_id=>wwv_flow_api.id(7576833013180557183)
  ,p_item_default=>'REPORT'
  ,p_prompt=>'View As'
  ,p_source=>'REPORT'
  ,p_source_type=>'STATIC'
  ,p_display_as=>'NATIVE_SELECT_LIST'
  ,p_lov=>'STATIC2:Chart;CHART,Report;REPORT'
  ,p_cHeight=>1
  ,p_begin_on_new_line=>'N'
  ,p_field_template=>wwv_flow_api.id(4439236719731548242)
  ,p_item_template_options=>'#DEFAULT#'
  ,p_lov_display_extra=>'YES'
  ,p_encrypt_session_state_yn=>'N'
  ,p_attribute_01=>'REDIRECT_SET_VALUE'
  );
  wwv_flow_api.create_page_item(
   p_id=>wwv_flow_api.id(7576833210619557186)
  ,p_name=>'P12_SINCE'
  ,p_item_sequence=>10
  ,p_item_plug_id=>wwv_flow_api.id(7576833013180557183)
  ,p_item_default=>'00001.0000000000'
  ,p_prompt=>'Timeframe'
  ,p_source=>'00001.0000000000'
  ,p_source_type=>'STATIC'
  ,p_display_as=>'NATIVE_SELECT_LIST'
  ,p_named_lov=>'TIMEFRAME (2 WEEKS)'
  ,p_lov=>wwv_flow_string.join(wwv_flow_t_varchar2(
  'select wwv_flow_lang.system_message(''N_MINUTES'',''15'') d, ',
  'trim(to_char(15/(24*60),''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_MINUTES'',''30'') d, ',
  'trim(to_char(30/(24*60),''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_HOUR'',''1'') d, ',
  'trim(to_char(1/24,''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_MINUTES'',''90'') d, ',
  'trim(to_char(90/(24*60),''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_HOURS'',''2'') d, ',
  'trim(to_char(1/12,''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,''''''))  t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_HOURS'',''3'') d, ',
  'trim(to_char(3/24,''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,''''''))  t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_HOURS'',''4'') d, ',
  'trim(to_char(4/24,''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,''''''))  t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_HOURS'',''5'') d, ',
  'trim(to_char(5/24,''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,''''''))  t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_HOURS'',''6'') d, ',
  'trim(to_char(6/24,''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_HOURS'',''8'') d, ',
  'trim(to_char(8/24,''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_HOURS'',''10'') d, ',
  'trim(to_char(10/24,''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_HOURS'',''12'') d, ',
  'trim(to_char(12/24,''00000.99999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_HOURS'',''16'') d, ',
  'trim(to_char(16/24,''00000.9999999999'',''NLS_NUMERIC_CHARACTERS=''''.,'''''')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_DAY'',''1'') d, trim(to_char(1,''00000.9999999999'')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_DAYS'',''2'') d, trim(to_char(2,''00000.9999999999'')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_DAYS'',''3'') d, trim(to_char(3,''00000.9999999999'')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_DAYS'',''4'') d, trim(to_char(4,''00000.9999999999'')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_DAYS'',''5'') d, trim(to_char(5,''00000.9999999999'')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_WEEK'',''1'') d, trim(to_char(7,''00000.9999999999'')) t from dual',
  'union all ',
  'select wwv_flow_lang.system_message(''N_WEEKS'',''2'') d, trim(to_char(14,''00000.9999999999'')) t from dual',
  'order by 2'))
  ,p_cHeight=>1
  ,p_field_template=>wwv_flow_api.id(4439236719731548242)
  ,p_item_template_options=>'#DEFAULT#'
  ,p_lov_display_extra=>'YES'
  ,p_protection_level=>'S'
  ,p_encrypt_session_state_yn=>'N'
  ,p_attribute_01=>'SUBMIT'
  ,p_attribute_03=>'Y'
  );
  wwv_flow_api.component_end;
  end;
  /
  