text: prompt --application/pages/page_00101
  begin
  wwv_flow_api.create_page(
   p_id=>101
  ,p_user_interface_id=>wwv_flow_api.id(327304041051455600)
  ,p_name=>'Login Page'
  ,p_alias=>'LOGIN_DESKTOP'
  ,p_page_mode=>'MODAL'
  ,p_step_title=>'Welcome to SOCK.com'
  ,p_warn_on_unsaved_changes=>'N'
  ,p_step_sub_title_type=>'TEXT_WITH_SUBSTITUTIONS'
  ,p_first_item=>'AUTO_FIRST_ITEM'
  ,p_autocomplete_on_off=>'OFF'
  ,p_inline_css=>wwv_flow_string.join(wwv_flow_t_varchar2(
  '.login_image{ width: 100%;',
  '             /* height: auto;*/',
  '}'))
  ,p_page_template_options=>'#DEFAULT#'
  ,p_dialog_chained=>'Y'
  ,p_overwrite_navigation_list=>'N'
  ,p_page_is_public_y_n=>'Y'
  ,p_cache_mode=>'NOCACHE'
  ,p_last_updated_by=>'defaultUser'
  ,p_last_upd_yyyymmddhh24miss=>'20000101000000'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(327304516221455601)
  ,p_plug_name=>'Welcome to SOCK.com !'
  ,p_icon_css_classes=>'fa-hipster'
  ,p_region_template_options=>'#DEFAULT#'
  ,p_plug_template=>wwv_flow_api.id(327270258891455548)
  ,p_plug_display_sequence=>11
  ,p_include_in_reg_disp_sel_yn=>'N'
  ,p_plug_display_point=>'BODY'
  ,p_plug_query_row_template=>1
  ,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
  ,p_attribute_01=>'N'
  ,p_attribute_02=>'TEXT'
  ,p_attribute_03=>'Y'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(329188789323265843)
  ,p_plug_name=>'Not registered yet ?'
  ,p_region_template_options=>'#DEFAULT#:is-expanded:t-Region--scrollBody'
  ,p_plug_template=>wwv_flow_api.id(327265108815455542)
  ,p_plug_display_sequence=>21
  ,p_include_in_reg_disp_sel_yn=>'N'
  ,p_plug_display_point=>'BODY'
  ,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
  ,p_attribute_01=>'N'
  ,p_attribute_02=>'HTML'
  );
  wwv_flow_api.create_page_plug(
   p_id=>wwv_flow_api.id(394557490786987643)
  ,p_plug_name=>'LOGIN IMAGE'
  ,p_region_template_options=>'#DEFAULT#'
  ,p_plug_template=>wwv_flow_api.id(327260456234455539)
  ,p_plug_display_sequence=>10
  ,p_include_in_reg_disp_sel_yn=>'Y'
  ,p_plug_display_point=>'BODY'
  ,p_plug_query_options=>'DERIVED_REPORT_COLUMNS'
  ,p_attribute_01=>'N'
  ,p_attribute_02=>'HTML'
  );
  wwv_flow_api.create_page_button(
   p_id=>wwv_flow_api.id(351684728887319214)
  ,p_button_sequence=>10
  ,p_button_plug_id=>wwv_flow_api.id(329188789323265843)
  ,p_button_name=>'REGISTER'
  ,p_button_action=>'REDIRECT_PAGE'
  ,p_button_template_options=>'#DEFAULT#:t-Button--iconLeft'
  ,p_button_template_id=>wwv_flow_api.id(327293304788455585)
  ,p_button_image_alt=>'Go to registration page'
  ,p_button_position=>'BODY'
  ,p_button_redirect_url=>'f?p=&APP_ID.:100:&SESSION.::&DEBUG.:RP::'
  ,p_icon_css_classes=>'fa-hand-o-right'
  ,p_grid_new_row=>'Y'
  );
  wwv_flow_api.create_page_button(
   p_id=>wwv_flow_api.id(327304807205455601)
  ,p_button_sequence=>30
  ,p_button_plug_id=>wwv_flow_api.id(327304516221455601)
  ,p_button_name=>'LOGIN'
  ,p_button_action=>'SUBMIT'
  ,p_button_template_options=>'#DEFAULT#'
  ,p_button_template_id=>wwv_flow_api.id(327293267790455585)
  ,p_button_is_hot=>'Y'
  ,p_button_image_alt=>'Log In'
  ,p_button_position=>'REGION_TEMPLATE_NEXT'
  );
  wwv_flow_api.create_page_item(
   p_id=>wwv_flow_api.id(327304602637455601)
  ,p_name=>'P101_USER_EMAIL'
  ,p_is_required=>true
  ,p_item_sequence=>10
  ,p_item_plug_id=>wwv_flow_api.id(327304516221455601)
  ,p_prompt=>'User email'
  ,p_placeholder=>'email'
  ,p_post_element_text=>'<span class="t-Login-iconValidation a-Icon icon-check"></span>'
  ,p_display_as=>'NATIVE_TEXT_FIELD'
  ,p_cSize=>40
  ,p_cMaxlength=>100
  ,p_field_template=>wwv_flow_api.id(327292604839455582)
  ,p_item_icon_css_classes=>'fa-user'
  ,p_item_template_options=>'#DEFAULT#'
  ,p_attribute_01=>'Y'
  ,p_attribute_02=>'N'
  ,p_attribute_04=>'TEXT'
  ,p_attribute_05=>'NONE'
  );
  wwv_flow_api.create_page_item(
   p_id=>wwv_flow_api.id(327304729032455601)
  ,p_name=>'P101_USER_PASSWORD'
  ,p_is_required=>true
  ,p_item_sequence=>20
  ,p_item_plug_id=>wwv_flow_api.id(327304516221455601)
  ,p_prompt=>'User password'
  ,p_placeholder=>'password'
  ,p_post_element_text=>'<span class="t-Login-iconValidation a-Icon icon-check"></span>'
  ,p_display_as=>'NATIVE_PASSWORD'
  ,p_cSize=>40
  ,p_cMaxlength=>100
  ,p_field_template=>wwv_flow_api.id(327292604839455582)
  ,p_item_icon_css_classes=>'fa-key'
  ,p_item_template_options=>'#DEFAULT#'
  ,p_attribute_01=>'Y'
  ,p_attribute_02=>'N'
  );
  wwv_flow_api.create_page_item(
   p_id=>wwv_flow_api.id(394557590149987644)
  ,p_name=>'P101_IMAGE'
  ,p_item_sequence=>10
  ,p_item_plug_id=>wwv_flow_api.id(394557490786987643)
  ,p_prompt=>'Image'
  ,p_source=>'#APP_IMAGES#assorted_socks_2.png'
  ,p_source_type=>'STATIC'
  ,p_display_as=>'NATIVE_DISPLAY_IMAGE'
  ,p_tag_css_classes=>'login_image'
  ,p_grid_label_column_span=>0
  ,p_field_template=>wwv_flow_api.id(327292794678455582)
  ,p_item_template_options=>'#DEFAULT#'
  ,p_attribute_01=>'URL'
  );
  wwv_flow_api.create_page_process(
   p_id=>wwv_flow_api.id(327305030725455601)
  ,p_process_sequence=>10
  ,p_process_point=>'AFTER_SUBMIT'
  ,p_process_type=>'NATIVE_PLSQL'
  ,p_process_name=>'Set Username Cookie'
  ,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
  'apex_authentication.send_login_username_cookie (',
  '    p_username => lower(:P101_USER_EMAIL) );'))
  ,p_error_display_location=>'INLINE_IN_NOTIFICATION'
  );
  wwv_flow_api.create_page_process(
   p_id=>wwv_flow_api.id(327304911824455601)
  ,p_process_sequence=>20
  ,p_process_point=>'AFTER_SUBMIT'
  ,p_process_type=>'NATIVE_PLSQL'
  ,p_process_name=>'Login'
  ,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2(
  'apex_authentication.login(',
  '    p_username => :P101_USER_EMAIL,',
  '    p_password => :P101_USER_PASSWORD );'))
  ,p_error_display_location=>'INLINE_IN_NOTIFICATION'
  ,p_process_when=>'P101_USER_EMAIL'
  ,p_process_when_type=>'ITEM_IS_NOT_NULL'
  );
  wwv_flow_api.create_page_process(
   p_id=>wwv_flow_api.id(327305205636455601)
  ,p_process_sequence=>30
  ,p_process_point=>'AFTER_SUBMIT'
  ,p_process_type=>'NATIVE_SESSION_STATE'
  ,p_process_name=>'Clear Page(s) Cache'
  ,p_attribute_01=>'CLEAR_CACHE_CURRENT_PAGE'
  ,p_error_display_location=>'INLINE_IN_NOTIFICATION'
  ,p_process_when_type=>'NEVER'
  );
  wwv_flow_api.create_page_process(
   p_id=>wwv_flow_api.id(327305183925455601)
  ,p_process_sequence=>10
  ,p_process_point=>'BEFORE_HEADER'
  ,p_process_type=>'NATIVE_PLSQL'
  ,p_process_name=>'Get Username Cookie'
  ,p_process_sql_clob=>':P101_USER_EMAIL := apex_authentication.get_login_username_cookie;'
  );
  end;
  /
  