prompt --application/pages/page_09999 begin -- Manifest -- PAGE: 09999 -- Manifest End wwv_flow_imp.component_begin ( p_version_yyyy_mm_dd=>'2023.10.31' ,p_release=>'23.2.0' ,p_default_workspace_id=>16017191443360494 ,p_default_application_id=>10001 ,p_default_id_offset=>0 ,p_default_owner=>'STUDENT' ); wwv_flow_imp_page.create_page( p_id=>9999 ,p_name=>'Login Page' ,p_alias=>'LOGIN' ,p_step_title=>'Study Performance Tracking App - Log In' ,p_warn_on_unsaved_changes=>'N' ,p_first_item=>'AUTO_FIRST_ITEM' ,p_autocomplete_on_off=>'OFF' ,p_step_template=>wwv_flow_imp.id(16035138628514548) ,p_page_template_options=>'#DEFAULT#' ,p_page_is_public_y_n=>'Y' ,p_protection_level=>'C' ,p_page_component_map=>'12' ,p_last_updated_by=>'STUDENT_DEV' ,p_last_upd_yyyymmddhh24miss=>'20231219180643' ); wwv_flow_imp_page.create_page_plug( p_id=>wwv_flow_imp.id(16217689979515449) ,p_plug_name=>'Study Performance Tracking App' ,p_icon_css_classes=>'app-icon' ,p_region_template_options=>'#DEFAULT#' ,p_plug_template=>wwv_flow_imp.id(16114256328514805) ,p_plug_display_sequence=>10 ,p_attribute_01=>'N' ,p_attribute_02=>'TEXT' ,p_attribute_03=>'Y' ); wwv_flow_imp_page.create_page_button( p_id=>wwv_flow_imp.id(16220375374515553) ,p_button_sequence=>40 ,p_button_plug_id=>wwv_flow_imp.id(16217689979515449) ,p_button_name=>'LOGIN' ,p_button_action=>'SUBMIT' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_imp.id(16189347253515098) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Sign In' ,p_button_position=>'NEXT' ,p_button_alignment=>'LEFT' ,p_grid_new_row=>'Y' ,p_grid_new_column=>'Y' ); wwv_flow_imp_page.create_page_button( p_id=>wwv_flow_imp.id(3286652512056401) ,p_button_sequence=>50 ,p_button_plug_id=>wwv_flow_imp.id(16217689979515449) ,p_button_name=>'AUTHING_SSO' ,p_button_action=>'REDIRECT_PAGE' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_imp.id(16189347253515098) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'WeChat QR Scanning (Authing)' ,p_button_position=>'NEXT' ,p_button_redirect_url=>'f?p=&APP_ID.:1:&SESSION.:APEX_AUTHENTICATION=Authing:&DEBUG.:::' ); wwv_flow_imp_page.create_page_button( p_id=>wwv_flow_imp.id(3286848992056403) ,p_button_sequence=>60 ,p_button_plug_id=>wwv_flow_imp.id(16217689979515449) ,p_button_name=>'AZURE_SSO' ,p_button_action=>'REDIRECT_PAGE' ,p_button_template_options=>'#DEFAULT#' ,p_button_template_id=>wwv_flow_imp.id(16189347253515098) ,p_button_is_hot=>'Y' ,p_button_image_alt=>'Azure SSO' ,p_button_position=>'NEXT' ,p_button_redirect_url=>'f?p=&APP_ID.:1:&SESSION.:APEX_AUTHENTICATION=Azure:&DEBUG.:::' ); wwv_flow_imp_page.create_page_branch( p_id=>wwv_flow_imp.id(3287257585056407) ,p_branch_name=>'Redirect with Language' ,p_branch_action=>'f?p=&APP_ID.:9999:&SESSION.::&DEBUG.:::&success_msg=#SUCCESS_MSG#' ,p_branch_point=>'AFTER_PROCESSING' ,p_branch_type=>'REDIRECT_URL' ,p_branch_sequence=>10 ,p_branch_condition_type=>'REQUEST_EQUALS_CONDITION' ,p_branch_condition=>'RefreshLanguage' ); wwv_flow_imp_page.create_page_item( p_id=>wwv_flow_imp.id(9889450997144031) ,p_name=>'P9999_LANGUAGE' ,p_is_required=>true ,p_item_sequence=>40 ,p_item_plug_id=>wwv_flow_imp.id(16217689979515449) ,p_item_default=>'NVL(APEX_UTIL.get_session_lang, ''en'')' ,p_item_default_type=>'EXPRESSION' ,p_item_default_language=>'PLSQL' ,p_prompt=>'Language' ,p_display_as=>'NATIVE_RADIOGROUP' ,p_lov=>unistr('STATIC:\7B80\4F53\4E2D\6587;zh-cn,English;en') ,p_field_template=>wwv_flow_imp.id(16186811375515083) ,p_item_template_options=>'#DEFAULT#:t-Form-fieldContainer--radioButtonGroup' ,p_lov_display_extra=>'NO' ,p_attribute_01=>'2' ,p_attribute_02=>'NONE' ); wwv_flow_imp_page.create_page_item( p_id=>wwv_flow_imp.id(16218084204515495) ,p_name=>'P9999_USERNAME' ,p_item_sequence=>10 ,p_item_plug_id=>wwv_flow_imp.id(16217689979515449) ,p_prompt=>'Username' ,p_placeholder=>'Username' ,p_display_as=>'NATIVE_TEXT_FIELD' ,p_cSize=>40 ,p_cMaxlength=>100 ,p_label_alignment=>'RIGHT' ,p_field_template=>wwv_flow_imp.id(16186508615515074) ,p_item_icon_css_classes=>'fa-user' ,p_item_template_options=>'#DEFAULT#' ,p_is_persistent=>'N' ,p_attribute_01=>'N' ,p_attribute_02=>'N' ,p_attribute_03=>'N' ,p_attribute_04=>'TEXT' ,p_attribute_05=>'NONE' ); wwv_flow_imp_page.create_page_item( p_id=>wwv_flow_imp.id(16218479153515499) ,p_name=>'P9999_PASSWORD' ,p_item_sequence=>20 ,p_item_plug_id=>wwv_flow_imp.id(16217689979515449) ,p_prompt=>'Password' ,p_placeholder=>'Password' ,p_display_as=>'NATIVE_PASSWORD' ,p_cSize=>40 ,p_cMaxlength=>100 ,p_label_alignment=>'RIGHT' ,p_field_template=>wwv_flow_imp.id(16186508615515074) ,p_item_icon_css_classes=>'fa-key' ,p_item_template_options=>'#DEFAULT#' ,p_is_persistent=>'N' ,p_attribute_01=>'Y' ); wwv_flow_imp_page.create_page_item( p_id=>wwv_flow_imp.id(16219468817515516) ,p_name=>'P9999_REMEMBER' ,p_item_sequence=>30 ,p_item_plug_id=>wwv_flow_imp.id(16217689979515449) ,p_prompt=>'Remember username' ,p_display_as=>'NATIVE_CHECKBOX' ,p_named_lov=>'LOGIN_REMEMBER_USERNAME' ,p_lov=>'.'||wwv_flow_imp.id(16218684043515500)||'.' ,p_label_alignment=>'RIGHT' ,p_display_when=>'apex_authentication.persistent_cookies_enabled' ,p_display_when2=>'PLSQL' ,p_display_when_type=>'EXPRESSION' ,p_field_template=>wwv_flow_imp.id(16186508615515074) ,p_item_template_options=>'#DEFAULT#' ,p_is_persistent=>'N' ,p_lov_display_extra=>'NO' ,p_help_text=>wwv_flow_string.join(wwv_flow_t_varchar2( '

', 'If you select this checkbox, the application will save your username in a persistent browser cookie named "LOGIN_USERNAME_COOKIE".', 'When you go to the login page the next time,', 'the username field will be automatically populated with this value.', '

', '

', 'If you deselect this checkbox and your username is already saved in the cookie,', 'the application will overwrite it with an empty value.', 'You can also use your browser''s developer tools to completely remove the cookie.', '

')) ,p_attribute_01=>'1' ); wwv_flow_imp_page.create_page_da_event( p_id=>wwv_flow_imp.id(3286903660056404) ,p_name=>'When Value Changed' ,p_event_sequence=>10 ,p_triggering_element_type=>'ITEM' ,p_triggering_element=>'P9999_LANGUAGE' ,p_bind_type=>'bind' ,p_execution_type=>'IMMEDIATE' ,p_bind_event_type=>'change' ); wwv_flow_imp_page.create_page_da_action( p_id=>wwv_flow_imp.id(3287065751056405) ,p_event_id=>wwv_flow_imp.id(3286903660056404) ,p_event_result=>'TRUE' ,p_action_sequence=>10 ,p_execute_on_page_init=>'N' ,p_name=>'Change Session Language' ,p_action=>'NATIVE_EXECUTE_PLSQL_CODE' ,p_attribute_01=>wwv_flow_string.join(wwv_flow_t_varchar2( 'BEGIN', ' APEX_UTIL.SET_SESSION_LANG(:P9999_LANGUAGE);', 'END;', '')) ,p_attribute_02=>'P9999_LANGUAGE' ,p_attribute_05=>'PLSQL' ,p_wait_for_result=>'Y' ); wwv_flow_imp_page.create_page_da_action( p_id=>wwv_flow_imp.id(3287167098056406) ,p_event_id=>wwv_flow_imp.id(3286903660056404) ,p_event_result=>'TRUE' ,p_action_sequence=>20 ,p_execute_on_page_init=>'N' ,p_name=>'Refresh' ,p_action=>'NATIVE_SUBMIT_PAGE' ,p_attribute_01=>'ChangeLanguage' ,p_attribute_02=>'Y' ); wwv_flow_imp_page.create_page_process( p_id=>wwv_flow_imp.id(16221198190515587) ,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(:P9999_USERNAME),', ' p_consent => :P9999_REMEMBER = ''Y'' );')) ,p_process_clob_language=>'PLSQL' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ,p_process_when=>'ChangeLanguage' ,p_process_when_type=>'REQUEST_NOT_EQUAL_CONDITION' ,p_internal_uid=>16221198190515587 ); wwv_flow_imp_page.create_page_process( p_id=>wwv_flow_imp.id(16220713697515582) ,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 => :P9999_USERNAME,', ' p_password => :P9999_PASSWORD );')) ,p_process_clob_language=>'PLSQL' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ,p_process_when=>'ChangeLanguage' ,p_process_when_type=>'REQUEST_NOT_EQUAL_CONDITION' ,p_internal_uid=>16220713697515582 ); wwv_flow_imp_page.create_page_process( p_id=>wwv_flow_imp.id(9889583465144032) ,p_process_sequence=>30 ,p_process_point=>'AFTER_SUBMIT' ,p_process_type=>'NATIVE_PLSQL' ,p_process_name=>'SetSessionLang' ,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2( 'BEGIN', ' APEX_UTIL.SET_SESSION_LANG(:P9999_LANGUAGE);', 'END;', '')) ,p_process_clob_language=>'PLSQL' ,p_error_display_location=>'INLINE_IN_NOTIFICATION' ,p_internal_uid=>9889583465144032 ); wwv_flow_imp_page.create_page_process( p_id=>wwv_flow_imp.id(16221934395515589) ,p_process_sequence=>40 ,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_internal_uid=>16221934395515589 ); wwv_flow_imp_page.create_page_process( p_id=>wwv_flow_imp.id(16221504106515588) ,p_process_sequence=>10 ,p_process_point=>'BEFORE_HEADER' ,p_process_type=>'NATIVE_PLSQL' ,p_process_name=>'Get Username Cookie' ,p_process_sql_clob=>wwv_flow_string.join(wwv_flow_t_varchar2( ':P9999_USERNAME := apex_authentication.get_login_username_cookie;', ':P9999_REMEMBER := case when :P9999_USERNAME is not null then ''Y'' end;')) ,p_process_clob_language=>'PLSQL' ,p_internal_uid=>16221504106515588 ); wwv_flow_imp.component_end; end; /