text: prompt --application/pages/page_10035
  begin
  --   Manifest
  --     PAGE: 10035
  --   Manifest End
  wwv_flow_api.component_begin (
   p_version_yyyy_mm_dd=>'2021.04.15'
  ,p_release=>'21.1.2'
  ,p_default_workspace_id=>32532315908301997117
  ,p_default_application_id=>105814
  ,p_default_id_offset=>0
  ,p_default_owner=>'WKSP_PERSONALWEBSITE'
  );
  wwv_flow_api.create_page(
   p_id=>10035
  ,p_user_interface_id=>wwv_flow_api.id(32836083202359656461)
  ,p_name=>'Automations Log'
  ,p_alias=>'AUTOMATIONS-LOG'
  ,p_page_mode=>'MODAL'
  ,p_step_title=>'Automations Log'
  ,p_autocomplete_on_off=>'OFF'
  ,p_group_id=>wwv_flow_api.id(32836089347820656474)
  ,p_page_template_options=>'#DEFAULT#:ui-dialog--stretch:t-Dialog--noPadding'
  ,p_required_role=>wwv_flow_api.id(32836087487010656472)
  ,p_required_patch=>wwv_flow_api.id(32836084891811656469)
  ,p_protection_level=>'C'
  ,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
  '<p>This page provides an interactive report of the automations log.</p>',
  '<p>Review logged information about previous automation executions. The log contains start and end timestamps as well as details about processed rows (successful and with errors). Drill down into Messages to see individual messages for processed rows.'
  ||'</p>',
  ''))
  ,p_last_updated_by=>'MADANYX@GMAIL.COM'
  ,p_last_upd_yyyymmddhh24miss=>'20210909201404'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(32836167790380656829)
  ,p_plug_name=>'Automations Log'
  ,p_region_template_options=>'#DEFAULT#:t-IRR-region--noBorders'
  ,p_plug_template=>wwv_flow_api.id(32835991444824656414)
  ,p_plug_display_sequence=>10
  ,p_plug_display_point=>'BODY'
  ,p_query_type=>'SQL'
  ,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
  'select l.id,',
  '       l.start_timestamp,',
  '       a.name automation_name,',
  '       l.status,',
  '       l.successful_row_count,',
  '       l.error_row_count,',
  '       (select count(1) from apex_automation_msg_log m where m.automation_log_id = l.id) msg_count,',
  '       l.is_job,',
  '       l.end_timestamp',
  '  from apex_appl_automations a, apex_automation_log l',
  ' where a.automation_id = l.automation_id',
  ' and l.application_id = :APP_ID'))
  ,p_plug_source_type=>'NATIVE_IR'
  ,p_prn_page_header=>'Automations Log'
  );
  wwv_flow_api.create_worksheet(
   p_id=>wwv_flow_api.id(32836168688410656829)
  ,p_name=>'Automations Log'
  ,p_max_row_count=>'1000000'
  ,p_max_row_count_message=>'The maximum row count for this report is #MAX_ROW_COUNT# rows.  Please apply a filter to reduce the number of records in your query.'
  ,p_no_data_found_message=>'No data found.'
  ,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_download_formats=>'CSV:HTML:EMAIL:XLSX:PDF:RTF'
  ,p_owner=>'MADANYX@GMAIL.COM'
  ,p_internal_uid=>32836168688410656829
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(32836168757230656830)
  ,p_db_column_name=>'ID'
  ,p_display_order=>10
  ,p_column_identifier=>'A'
  ,p_column_label=>'ID'
  ,p_column_type=>'NUMBER'
  ,p_display_text_as=>'HIDDEN'
  ,p_heading_alignment=>'RIGHT'
  ,p_column_alignment=>'RIGHT'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(32836169067872656831)
  ,p_db_column_name=>'START_TIMESTAMP'
  ,p_display_order=>20
  ,p_column_identifier=>'B'
  ,p_column_label=>'Started'
  ,p_column_type=>'DATE'
  ,p_heading_alignment=>'LEFT'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(32836169471849656831)
  ,p_db_column_name=>'AUTOMATION_NAME'
  ,p_display_order=>30
  ,p_column_identifier=>'C'
  ,p_column_label=>'Automation'
  ,p_column_type=>'STRING'
  ,p_heading_alignment=>'LEFT'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(32836169872449656831)
  ,p_db_column_name=>'STATUS'
  ,p_display_order=>40
  ,p_column_identifier=>'D'
  ,p_column_label=>'Status'
  ,p_column_type=>'STRING'
  ,p_heading_alignment=>'LEFT'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(32836170260447656832)
  ,p_db_column_name=>'SUCCESSFUL_ROW_COUNT'
  ,p_display_order=>50
  ,p_column_identifier=>'E'
  ,p_column_label=>'Successful Rows'
  ,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(32836170633712656832)
  ,p_db_column_name=>'ERROR_ROW_COUNT'
  ,p_display_order=>60
  ,p_column_identifier=>'F'
  ,p_column_label=>'Error Rows'
  ,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(32836171078583656832)
  ,p_db_column_name=>'MSG_COUNT'
  ,p_display_order=>70
  ,p_column_identifier=>'G'
  ,p_column_label=>'Messages'
  ,p_column_link=>'f?p=&APP_ID.:10036:&SESSION.:::RP,10036:P10036_LOG_ID:#ID#'
  ,p_column_linktext=>'#MSG_COUNT#'
  ,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(32836171446020656833)
  ,p_db_column_name=>'IS_JOB'
  ,p_display_order=>80
  ,p_column_identifier=>'H'
  ,p_column_label=>'Scheduled'
  ,p_column_type=>'STRING'
  ,p_heading_alignment=>'LEFT'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_column(
   p_id=>wwv_flow_api.id(32836171829573656833)
  ,p_db_column_name=>'END_TIMESTAMP'
  ,p_display_order=>90
  ,p_column_identifier=>'I'
  ,p_column_label=>'Ended'
  ,p_column_type=>'DATE'
  ,p_heading_alignment=>'LEFT'
  ,p_tz_dependent=>'N'
  );
  wwv_flow_api.create_worksheet_rpt(
   p_id=>wwv_flow_api.id(32836172850269656834)
  ,p_application_user=>'APXWS_DEFAULT'
  ,p_report_seq=>10
  ,p_report_alias=>'328361729'
  ,p_status=>'PUBLIC'
  ,p_is_default=>'Y'
  ,p_report_columns=>'START_TIMESTAMP:AUTOMATION_NAME:STATUS:SUCCESSFUL_ROW_COUNT:ERROR_ROW_COUNT:MSG_COUNT'
  ,p_sort_column_1=>'START_TIMESTAMP'
  ,p_sort_direction_1=>'DESC'
  );
  wwv_flow_api.create_page_button(
   p_id=>wwv_flow_api.id(32836173767435656835)
  ,p_button_sequence=>20
  ,p_button_plug_id=>wwv_flow_api.id(32836167790380656829)
  ,p_button_name=>'RESET_REPORT'
  ,p_button_action=>'REDIRECT_PAGE'
  ,p_button_template_options=>'t-Button--iconLeft'
  ,p_button_template_id=>wwv_flow_api.id(32836058863771656446)
  ,p_button_image_alt=>'Reset'
  ,p_button_position=>'RIGHT_OF_IR_SEARCH_BAR'
  ,p_button_redirect_url=>'f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.::&DEBUG.:&APP_PAGE_ID.,RR::'
  ,p_icon_css_classes=>'fa-undo-alt'
  );
  wwv_flow_api.component_end;
  end;
  /
  