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.6'
,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_inline_css=>wwv_flow_string.join(wwv_flow_t_varchar2(
'.hr-text {',
' border: 0;',
' font-size: 14px;',
' height: 1.5em;',
' line-height: 1em;',
' position: relative;',
' text-align: center;',
'}',
'',
'.hr-text::before {',
' content: "";',
' background: linear-gradient(to right, transparent, white, transparent);',
' position: absolute;',
' left: 0;',
' top: 50%;',
' width: 100%;',
' height: 1px;',
'}',
'',
'.hr-text::after {',
' background-color: #1a1a1a;',
' color: white;',
' content: attr(data-content);',
' line-height: 1.5em;',
' padding: 0 7px;',
' position: relative;',
'}'))
,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=>'20240221174720'
);
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_plug(
p_id=>wwv_flow_imp.id(3289264850056427)
,p_plug_name=>'Button Container'
,p_region_name=>'button-container'
,p_parent_plug_id=>wwv_flow_imp.id(16217689979515449)
,p_region_template_options=>'#DEFAULT#:t-ButtonRegion--noUI'
,p_plug_template=>wwv_flow_imp.id(16065140485514661)
,p_plug_display_sequence=>30
,p_plug_display_point=>'SUB_REGIONS'
,p_attribute_01=>'N'
,p_attribute_02=>'HTML'
);
wwv_flow_imp_page.create_page_button(
p_id=>wwv_flow_imp.id(3286652512056401)
,p_button_sequence=>20
,p_button_plug_id=>wwv_flow_imp.id(3289264850056427)
,p_button_name=>'AUTHING_SSO'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#:t-Button--noUI:t-Button--iconLeft'
,p_button_template_id=>wwv_flow_imp.id(16189438884515099)
,p_button_is_hot=>'Y'
,p_button_image_alt=>''
,p_button_redirect_url=>'f?p=&APP_ID.:1:&SESSION.:APEX_AUTHENTICATION=Authing:&DEBUG.:::'
,p_grid_new_row=>'Y'
);
wwv_flow_imp_page.create_page_button(
p_id=>wwv_flow_imp.id(3286848992056403)
,p_button_sequence=>40
,p_button_plug_id=>wwv_flow_imp.id(3289264850056427)
,p_button_name=>'AZURE_SSO'
,p_button_action=>'REDIRECT_PAGE'
,p_button_template_options=>'#DEFAULT#:t-Button--noUI:t-Button--iconRight'
,p_button_template_id=>wwv_flow_imp.id(16189438884515099)
,p_button_is_hot=>'Y'
,p_button_image_alt=>'
'
,p_button_redirect_url=>'f?p=&APP_ID.:1:&SESSION.:APEX_AUTHENTICATION=Azure:&DEBUG.:::'
,p_grid_new_row=>'N'
,p_grid_new_column=>'Y'
);
wwv_flow_imp_page.create_page_button(
p_id=>wwv_flow_imp.id(16220375374515553)
,p_button_sequence=>10
,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'
);
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; /