text: prompt --application/pages/page_10000
  begin
  --   Manifest
  --     PAGE: 10000
  --   Manifest End
  wwv_flow_api.component_begin (
   p_version_yyyy_mm_dd=>'2021.04.15'
  ,p_release=>'21.1.6'
  ,p_default_workspace_id=>9690978936188613
  ,p_default_application_id=>122
  ,p_default_id_offset=>0
  ,p_default_owner=>'ILA'
  );
  wwv_flow_api.create_page(
   p_id=>10000
  ,p_user_interface_id=>wwv_flow_api.id(12856543716571017)
  ,p_name=>'Administration'
  ,p_alias=>'ADMIN'
  ,p_step_title=>'Administration'
  ,p_autocomplete_on_off=>'OFF'
  ,p_group_id=>wwv_flow_api.id(12861550718571051)
  ,p_page_template_options=>'#DEFAULT#'
  ,p_required_role=>wwv_flow_api.id(12859902314571040)
  ,p_protection_level=>'C'
  ,p_deep_linking=>'N'
  ,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2(
  '<p>The administration page allows application owners (Administrators) to configure the application and maintain common data used across the application.',
  'By selecting one of the available settings, administrators can potentially change how the application is displayed and/or features available to the end users.</p>',
  '<p>Access to this page should be limited to Administrators only.</p>'))
  ,p_last_updated_by=>'HAYDEN'
  ,p_last_upd_yyyymmddhh24miss=>'20211210134205'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(12910938383572840)
  ,p_plug_name=>'Breadcrumb'
  ,p_region_template_options=>'#DEFAULT#:t-BreadcrumbRegion--useBreadcrumbTitle'
  ,p_component_template_options=>'#DEFAULT#'
  ,p_plug_template=>wwv_flow_api.id(12776345678570948)
  ,p_plug_display_sequence=>10
  ,p_plug_display_point=>'REGION_POSITION_01'
  ,p_menu_id=>wwv_flow_api.id(12709350054570888)
  ,p_plug_source_type=>'NATIVE_BREADCRUMB'
  ,p_menu_template_id=>wwv_flow_api.id(12833487033570986)
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(12913391507572842)
  ,p_plug_name=>'Column 1'
  ,p_region_template_options=>'#DEFAULT#'
  ,p_escape_on_http_output=>'Y'
  ,p_plug_template=>wwv_flow_api.id(12736193818570924)
  ,p_plug_display_sequence=>10
  ,p_plug_display_point=>'BODY'
  ,p_plug_query_num_rows=>15
  ,p_attribute_01=>'N'
  ,p_attribute_02=>'HTML'
  ,p_attribute_03=>'Y'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(12913742850572842)
  ,p_plug_name=>'User Interface'
  ,p_parent_plug_id=>wwv_flow_api.id(12913391507572842)
  ,p_region_template_options=>'#DEFAULT#:t-Region--noPadding:t-Region--scrollBody'
  ,p_component_template_options=>'#DEFAULT#:u-colors'
  ,p_escape_on_http_output=>'Y'
  ,p_plug_template=>wwv_flow_api.id(12766940493570943)
  ,p_plug_display_sequence=>50
  ,p_plug_display_point=>'BODY'
  ,p_list_id=>wwv_flow_api.id(12911500189572841)
  ,p_plug_source_type=>'NATIVE_LIST'
  ,p_list_template_id=>wwv_flow_api.id(12815093002570973)
  ,p_plug_query_num_rows=>15
  ,p_required_patch=>wwv_flow_api.id(12858830357571037)
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(12914159127572843)
  ,p_plug_name=>'Column 2'
  ,p_region_template_options=>'#DEFAULT#'
  ,p_escape_on_http_output=>'Y'
  ,p_plug_template=>wwv_flow_api.id(12736193818570924)
  ,p_plug_display_sequence=>20
  ,p_plug_new_grid_row=>false
  ,p_plug_display_point=>'BODY'
  ,p_plug_query_num_rows=>15
  ,p_attribute_01=>'N'
  ,p_attribute_02=>'HTML'
  ,p_attribute_03=>'Y'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(12914526148572843)
  ,p_plug_name=>'Access Control'
  ,p_parent_plug_id=>wwv_flow_api.id(12914159127572843)
  ,p_region_template_options=>'#DEFAULT#:t-Region--noPadding:t-Region--scrollBody'
  ,p_escape_on_http_output=>'Y'
  ,p_plug_template=>wwv_flow_api.id(12766940493570943)
  ,p_plug_display_sequence=>60
  ,p_plug_display_point=>'BODY'
  ,p_plug_query_num_rows=>15
  ,p_required_patch=>wwv_flow_api.id(12858008643571037)
  ,p_attribute_01=>'N'
  ,p_attribute_02=>'HTML'
  ,p_attribute_03=>'Y'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(12915374145572844)
  ,p_plug_name=>'ACL Information'
  ,p_parent_plug_id=>wwv_flow_api.id(12914526148572843)
  ,p_region_css_classes=>'margin-sm'
  ,p_region_template_options=>'#DEFAULT#:t-Alert--colorBG:t-Alert--horizontal:t-Alert--noIcon:t-Alert--warning:t-Alert--accessibleHeading'
  ,p_component_template_options=>'#DEFAULT#'
  ,p_escape_on_http_output=>'Y'
  ,p_plug_template=>wwv_flow_api.id(12732241293570920)
  ,p_plug_display_sequence=>10
  ,p_plug_display_point=>'BODY'
  ,p_plug_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
  'declare',
  '    l_acl_scope   varchar2(45);',
  'begin',
  '    l_acl_scope   := apex_app_setting.get_value( p_name => ''ACCESS_CONTROL_SCOPE'' );',
  '',
  '    if l_acl_scope = ''ALL_USERS'' then',
  '        sys.htp.p( apex_lang.message(''APEX.FEATURE.ACL.INFO.ALL_USERS'') );',
  '    elsif l_acl_scope = ''ACL_ONLY'' then',
  '        sys.htp.p( apex_lang.message(''APEX.FEATURE.ACL.INFO.ACL_ONLY'') );',
  '    else',
  '        sys.htp.p( apex_lang.message(''APEX.FEATURE.ACL.INFO.ACL_VALUE_INVALID'', l_acl_scope) );',
  '    end if;',
  'end;'))
  ,p_plug_source_type=>'NATIVE_PLSQL'
  ,p_plug_query_num_rows=>15
  );
  wwv_flow_api.create_report_region(
   p_id=>wwv_flow_api.id(12915747952572844)
  ,p_name=>'User Counts Report'
  ,p_parent_plug_id=>wwv_flow_api.id(12914526148572843)
  ,p_template=>wwv_flow_api.id(12766940493570943)
  ,p_display_sequence=>20
  ,p_region_template_options=>'#DEFAULT#:t-Region--removeHeader:t-Region--stacked:t-Region--scrollBody:t-Region--noPadding'
  ,p_component_template_options=>'#DEFAULT#:t-AVPList--rightAligned'
  ,p_display_point=>'BODY'
  ,p_source_type=>'NATIVE_SQL_REPORT'
  ,p_query_type=>'SQL'
  ,p_source=>wwv_flow_string.join(wwv_flow_t_varchar2(
  'select r.role_name, (select count(*) from apex_appl_acl_user_roles ur where r.role_id = ur.role_id) user_count, r.role_id',
  'from  APEX_APPL_ACL_ROLES r',
  'where r.application_id = :APP_ID',
  'group by r.role_name, r.role_id',
  'order by 2 desc, 1'))
  ,p_ajax_enabled=>'Y'
  ,p_lazy_loading=>false
  ,p_query_row_template=>wwv_flow_api.id(12802057720570965)
  ,p_query_options=>'DERIVED_REPORT_COLUMNS'
  ,p_query_no_data_found=>'no data found'
  ,p_query_row_count_max=>500
  );
  wwv_flow_api.create_report_columns(
   p_id=>wwv_flow_api.id(12916412721572845)
  ,p_query_column_id=>1
  ,p_column_alias=>'ROLE_NAME'
  ,p_column_display_sequence=>1
  ,p_column_heading=>'Role Name'
  ,p_heading_alignment=>'LEFT'
  );
  wwv_flow_api.create_report_columns(
   p_id=>wwv_flow_api.id(12916870429572846)
  ,p_query_column_id=>2
  ,p_column_alias=>'USER_COUNT'
  ,p_column_display_sequence=>2
  ,p_column_heading=>'User Count'
  ,p_column_format=>'999G999G999G999G999G999G990'
  ,p_heading_alignment=>'LEFT'
  );
  wwv_flow_api.create_report_columns(
   p_id=>wwv_flow_api.id(12917261414572846)
  ,p_query_column_id=>3
  ,p_column_alias=>'ROLE_ID'
  ,p_column_display_sequence=>3
  ,p_column_heading=>'Role Id'
  ,p_heading_alignment=>'LEFT'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(12920223399573662)
  ,p_plug_name=>'Access Control Actions'
  ,p_parent_plug_id=>wwv_flow_api.id(12914526148572843)
  ,p_region_template_options=>'#DEFAULT#'
  ,p_component_template_options=>'#DEFAULT#:u-colors'
  ,p_escape_on_http_output=>'Y'
  ,p_plug_template=>wwv_flow_api.id(12735988894570924)
  ,p_plug_display_sequence=>30
  ,p_plug_display_point=>'BODY'
  ,p_list_id=>wwv_flow_api.id(12912257521572841)
  ,p_plug_source_type=>'NATIVE_LIST'
  ,p_list_template_id=>wwv_flow_api.id(12815093002570973)
  ,p_plug_query_num_rows=>15
  );
  wwv_flow_api.create_page_button(
   p_id=>wwv_flow_api.id(12914915542572844)
  ,p_button_sequence=>10
  ,p_button_plug_id=>wwv_flow_api.id(12914526148572843)
  ,p_button_name=>'ADD_USER'
  ,p_button_action=>'REDIRECT_PAGE'
  ,p_button_template_options=>'#DEFAULT#:t-Button--noUI:t-Button--iconLeft'
  ,p_button_template_id=>wwv_flow_api.id(12832109121570985)
  ,p_button_image_alt=>'Add'
  ,p_button_position=>'REGION_TEMPLATE_EDIT'
  ,p_button_redirect_url=>'f?p=&APP_ID.:10022:&SESSION.::&DEBUG.:RP,10022::'
  ,p_icon_css_classes=>'fa-user-plus'
  );
  wwv_flow_api.create_page_da_event(
   p_id=>wwv_flow_api.id(12919353286573661)
  ,p_name=>'Refresh on Dialog Close'
  ,p_event_sequence=>10
  ,p_triggering_element_type=>'BUTTON'
  ,p_triggering_button_id=>wwv_flow_api.id(12914915542572844)
  ,p_bind_type=>'bind'
  ,p_bind_event_type=>'apexafterclosedialog'
  );
  wwv_flow_api.create_page_da_action(
   p_id=>wwv_flow_api.id(12919808883573661)
  ,p_event_id=>wwv_flow_api.id(12919353286573661)
  ,p_event_result=>'TRUE'
  ,p_action_sequence=>10
  ,p_execute_on_page_init=>'N'
  ,p_action=>'NATIVE_REFRESH'
  ,p_affected_elements_type=>'REGION'
  ,p_affected_region_id=>wwv_flow_api.id(12915747952572844)
  );
  wwv_flow_api.component_end;
  end;
  /
  