set define off
set verify off
set serveroutput on size 1000000
set feedback off
begin wwv_flow.g_import_in_progress := true; end;
/
--application/set_environment
prompt APPLICATION 4550 - APEX - Login
--
-- Application Export:
-- Application: 4550
-- Name: APEX - Login
-- Date and Time: 07:46 Tuesday May 19, 2009
-- Exported By:
-- Flashback: 0
-- Export Type: Application Export
-- Version: 3.2.1.00.08
-- Import:
-- Using application builder
-- or
-- Using SQL*Plus as the Oracle user APEX_030200 or as the owner (parsing schema) of the application.
-- Application Statistics:
-- Pages: 9
-- Items: 19
-- Computations: 1
-- Validations: 18
-- Processes: 23
-- Regions: 28
-- Buttons: 12
-- Shared Components
-- Breadcrumbs: 0
-- Entries 0
-- Items: 3
-- Computations: 1
-- Processes: 0
-- Parent Tabs: 0
-- Tab Sets: 0
-- Tabs: 0
-- NavBars: 0
-- Lists: 4
-- Shortcuts: 3
-- Themes: 1
-- Templates:
-- Page: 2
-- List: 1
-- Report: 1
-- Label: 3
-- Region: 11
-- Messages: 0
-- Build Options: 1
-- AAAA PPPPP EEEEEE XX XX
-- AA AA PP PP EE XX XX
-- AA AA PP PP EE XX XX
-- AAAAAAAAAA PPPPP EEEE XXXX
-- AA AA PP EE XX XX
-- AA AA PP EE XX XX
-- AA AA PP EEEEEE XX XX
prompt Set Credentials...
begin
-- Assumes you are running the script connected to SQL*Plus as the Oracle user APEX_030200 or as the owner (parsing schema) of the application.
wwv_flow_api.set_security_group_id(p_security_group_id=>10);
end;
/
begin wwv_flow.g_import_in_progress := true; end;
/
begin
select value into wwv_flow_api.g_nls_numeric_chars from nls_session_parameters where parameter='NLS_NUMERIC_CHARACTERS';
end;
/
begin execute immediate 'alter session set nls_numeric_characters=''.,''';
end;
/
begin wwv_flow.g_browser_language := 'en-us'; end;
/
prompt Check Compatibility...
begin
-- This date identifies the minimum version required to import this file.
wwv_flow_api.set_version(p_version_yyyy_mm_dd=>'2009.01.12');
end;
/
prompt Set Application ID...
begin
-- SET APPLICATION ID
wwv_flow.g_flow_id := 4550;
wwv_flow_api.g_id_offset := 0;
null;
end;
/
--application/delete_application
begin
-- Remove Application
wwv_flow_api.remove_flow(4550);
end;
/
begin
wwv_flow_audit.remove_audit_trail(4550);
null;
end;
/
--application/create_application
begin
wwv_flow_api.create_flow(
p_id => 4550,
p_display_id=> 4550,
p_owner => 'APEX_030200',
p_name => 'APEX - Login',
p_alias => 'LOGIN',
p_application_group=>91050719712959059,
p_application_group_name=>'APEX Product',
p_application_group_comment=>'Applications shipped with the APEX product distribution',
p_page_view_logging => 'YES',
p_default_page_template=> 9095301378087765 + wwv_flow_api.g_id_offset,
p_printer_friendly_template=> 60929357198712420 + wwv_flow_api.g_id_offset,
p_error_template => 60929357198712420 + wwv_flow_api.g_id_offset,
p_charset => 'utf-8',
p_page_protection_enabled_y_n=> 'N',
p_checksum_salt_last_reset => '20090519073429',
p_max_session_length_sec=> 28800,
p_home_link => 'f?p=4550:1:&SESSION.',
p_flow_language => 'en-us',
p_flow_language_derived_from=> 'BROWSER',
p_flow_image_prefix => '/i/',
p_documentation_banner=> 'Developers:'||chr(10)||
''||chr(10)||
'Michael Hichwa, Joel Kallman, Sergio Leunissen, Christina Cho, Scott Spadafore, Marc Sewtz, Jason Straub, Tyler Muth, Raj Mattamal, Sharon Kennedy, Carl Backstrom, Kris Rice, Syme Kutz, Karen Ryan, Scott Spendolini, Terri Winters.'||chr(10)||
''||chr(10)||
'Contributors:'||chr(10)||
''||chr(10)||
'William Dwight, Tim Hoechst, Thomas Kyte, Chris Beck, David Bliss, Jason Rhodes, Sean Dillon, Ken Jacobs, Darcy Menard, Sudha Kannan.',
p_authentication => 'CUSTOM2',
p_login_url => 'development_service_home_login',
p_logout_url => 'wwv_flow_custom_auth_std.logout?p_this_flow=&FLOW_ID.&p_next_flow_page_sess=4550:8:&SESSION.',
p_application_tab_set=> 1,
p_logo_image => '#IMAGE_PREFIX#htmldb/apex_logo.gif',
p_logo_image_attributes => 'width="300" height="30" alt="&PRODUCT_NAME."',
p_public_url_prefix => '',
p_public_user => 'APEX_PUBLIC_USER',
p_dbauth_url_prefix => '',
p_proxy_server => '',
p_cust_authentication_process=> '.'||to_char(487415230967122 + wwv_flow_api.g_id_offset)||'.',
p_cust_authentication_page=> '',
p_custom_auth_login_url=> '',
p_flow_version => '&PRODUCT_NAME. ',
p_flow_status => 'AVAILABLE_W_EDIT_LINK',
p_flow_unavailable_text=> 'This application is currently unavailable.',
p_build_status => 'RUN_AND_BUILD',
p_exact_substitutions_only=> 'N',
p_vpd => '',
p_csv_encoding => 'Y',
p_theme_id => 3,
p_substitution_string_01 => 'PRODUCT_NAME',
p_substitution_value_01 => 'Application Express',
p_substitution_string_02 => 'REGISTER_LINK',
p_substitution_value_02 => 'development_service_signup',
p_substitution_string_03 => 'CLOSE',
p_substitution_value_03 => 'Close',
p_substitution_string_04 => 'DATE_FORMAT',
p_substitution_value_04 => 'mm/dd/yyyy',
p_substitution_string_05 => 'LONG_DATE_FORMAT',
p_substitution_value_05 => 'fmDay, Month dd, yyyy',
p_substitution_string_06 => 'TIME_FORMAT',
p_substitution_value_06 => 'hh:mi:ss AM',
p_substitution_string_07 => 'DATE_TIME_FORMAT',
p_substitution_value_07 => 'mm/dd/yyyy hh:mi:ss AM',
p_substitution_string_08 => 'RETURN_TO_APPLICATION',
p_substitution_value_08 => 'Return to Application',
p_substitution_string_09 => 'MSG_LANGUAGE',
p_substitution_value_09 => 'Language',
p_substitution_string_10 => 'MSG_COMPANY',
p_substitution_value_10 => 'Workspace: &COMPANY.',
p_substitution_string_11 => 'MSG_COPYRIGHT',
p_substitution_value_11 => 'Copyright © 1999, 2009, Oracle. All rights reserved.',
p_last_updated_by => '',
p_last_upd_yyyymmddhh24miss=> '20090518133142',
p_required_roles=> wwv_flow_utilities.string_to_table2(''));
end;
/
prompt ...authorization schemes
--
begin
null;
end;
/
--application/shared_components/navigation/navigation_bar
prompt ...navigation bar entries
--
begin
null;
end;
/
prompt ...application processes
--
prompt ...application items
--
--application/shared_components/logic/application_items/error_occurred
begin
wwv_flow_api.create_flow_item(
p_id=> 47291523209584096 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> 'ERROR_OCCURRED',
p_data_type=> 'VARCHAR',
p_is_persistent=> 'Y',
p_protection_level=> '',
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_item_comment=> '');
null;
end;
/
--application/shared_components/logic/application_items/f4550_service_request_url
begin
wwv_flow_api.create_flow_item(
p_id=> 16763020509404219 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> 'F4550_SERVICE_REQUEST_URL',
p_data_type=> 'VARCHAR',
p_is_persistent=> 'Y',
p_protection_level=> '',
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_item_comment=> '');
null;
end;
/
--application/shared_components/logic/application_items/fsp_after_login_url
begin
wwv_flow_api.create_flow_item(
p_id=> 510231751281890 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> 'FSP_AFTER_LOGIN_URL',
p_data_type=> 'VARCHAR',
p_is_persistent=> 'Y',
p_protection_level=> '',
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_item_comment=> 'Used by Custom2 authentication for deep linking support');
null;
end;
/
prompt ...application level computations
--
begin
--application/shared_components/logic/application_computations/f4550_service_request_url
wwv_flow_api.create_flow_computation (
p_id => 16766113976430755 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_computation_sequence => 10,
p_computation_item => 'F4550_SERVICE_REQUEST_URL',
p_computation_point => 'ON_NEW_INSTANCE',
p_computation_type => 'FUNCTION_BODY',
p_computation_processed=> 'REPLACE_EXISTING',
p_computation => 'declare l_url varchar2(255) := null;'||chr(10)||
'begin'||chr(10)||
'l_url := wwv_flow_platform.get_preference(''SERVICE_REQUEST_FLOW'');'||chr(10)||
'if l_url = ''EMAIL'' then'||chr(10)||
' l_url := ''4700'';'||chr(10)||
'end if;'||chr(10)||
'return ''f?p=''||l_url||'':1'';'||chr(10)||
'end;',
p_compute_when=> 'nvl(wwv_flow_platform.get_preference(''SERVICE_REQUEST_FLOW''),''MANUAL'') <> ''MANUAL''',
p_compute_when_type=> 'PLSQL_EXPRESSION',
p_computation_error_message=>'',
p_computation_comment=> '',
p_required_patch=> null + wwv_flow_api.g_id_offset);
end;
/
prompt ...Application Tabs
--
begin
null;
end;
/
prompt ...Application Parent Tabs
--
begin
null;
end;
/
prompt ...Shared Lists of values
--
--application/shared_components/user_interface/lov/hr_or_new
begin
wwv_flow_api.create_list_of_values (
p_id => 20203615154961597 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_lov_name => 'HR_OR_NEW',
p_lov_query=> '.'||to_char(20203615154961597 + wwv_flow_api.g_id_offset)||'.');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>20203830364961608 + wwv_flow_api.g_id_offset,
p_lov_id=>20203615154961597 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>10,
p_lov_disp_value=>'Unlock the HR sample user account',
p_lov_return_value=>'HR',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>20204016953961621 + wwv_flow_api.g_id_offset,
p_lov_id=>20203615154961597 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>20,
p_lov_disp_value=>'Create a new user account',
p_lov_return_value=>'NEW',
p_lov_data_comment=> '');
null;
end;
/
--application/shared_components/user_interface/lov/language_pref
begin
wwv_flow_api.create_list_of_values (
p_id => 91126801753691270 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_lov_name => 'LANGUAGE_PREF',
p_lov_query=> '.'||to_char(91126801753691270 + wwv_flow_api.g_id_offset)||'.');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>91127127653691273 + wwv_flow_api.g_id_offset,
p_lov_id=>91126801753691270 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>1,
p_lov_disp_value=>'Chinese (China)',
p_lov_return_value=>'zh-cn',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>91127305990691273 + wwv_flow_api.g_id_offset,
p_lov_id=>91126801753691270 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>2,
p_lov_disp_value=>'Chinese (Taiwan)',
p_lov_return_value=>'zh-tw',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>91127504317691273 + wwv_flow_api.g_id_offset,
p_lov_id=>91126801753691270 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>3,
p_lov_disp_value=>'English',
p_lov_return_value=>'en',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>91127702350691274 + wwv_flow_api.g_id_offset,
p_lov_id=>91126801753691270 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>4,
p_lov_disp_value=>'French',
p_lov_return_value=>'fr',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>91127924193691274 + wwv_flow_api.g_id_offset,
p_lov_id=>91126801753691270 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>5,
p_lov_disp_value=>'German',
p_lov_return_value=>'de',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>91128105057691274 + wwv_flow_api.g_id_offset,
p_lov_id=>91126801753691270 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>6,
p_lov_disp_value=>'Italian',
p_lov_return_value=>'it',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>91128314741691274 + wwv_flow_api.g_id_offset,
p_lov_id=>91126801753691270 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>7,
p_lov_disp_value=>'Japanese',
p_lov_return_value=>'ja',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>91128529839691275 + wwv_flow_api.g_id_offset,
p_lov_id=>91126801753691270 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>8,
p_lov_disp_value=>'Korean',
p_lov_return_value=>'ko',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>91128730790691277 + wwv_flow_api.g_id_offset,
p_lov_id=>91126801753691270 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>9,
p_lov_disp_value=>'Portugese (Brazil)',
p_lov_return_value=>'pt-br',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>91128912347691277 + wwv_flow_api.g_id_offset,
p_lov_id=>91126801753691270 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>10,
p_lov_disp_value=>'Spanish',
p_lov_return_value=>'es',
p_lov_data_comment=> '');
null;
end;
/
--application/shared_components/user_interface/lov/roles
begin
wwv_flow_api.create_list_of_values (
p_id => 20420213496266810 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_lov_name => 'ROLES',
p_lov_query=> '.'||to_char(20420213496266810 + wwv_flow_api.g_id_offset)||'.');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>20420400631266813 + wwv_flow_api.g_id_offset,
p_lov_id=>20420213496266810 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>10,
p_lov_disp_value=>'Database Development (RESOURCE)',
p_lov_return_value=>'RESOURCE',
p_lov_data_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_static_lov_data (
p_id=>20420610391266814 + wwv_flow_api.g_id_offset,
p_lov_id=>20420213496266810 + wwv_flow_api.g_id_offset,
p_lov_disp_sequence=>20,
p_lov_disp_value=>'Administrative (DBA)',
p_lov_return_value=>'DBA',
p_lov_data_comment=> '');
null;
end;
/
prompt ...Application Trees
--
--application/pages/page_groups
prompt ...page groups
--
begin
wwv_flow_api.create_page_group(
p_id=>222575208632450607 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_group_name=>'Login',
p_group_desc=>'Login page, accept username and password from user.');
wwv_flow_api.create_page_group(
p_id=>222579123308464377 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_group_name=>'Logout',
p_group_desc=>'Confirm logout event.');
wwv_flow_api.create_page_group(
p_id=>222577907724459883 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_group_name=>'Password Management',
p_group_desc=>'Allow for reseting or changing password.');
null;
end;
/
--application/pages/page_00001
prompt ...PAGE 1: Login Home Page
--
begin
declare
h varchar2(32767) := null;
ph varchar2(32767) := null;
begin
h:=h||'start_login.htm';
ph:=ph||'';
wwv_flow_api.create_page(
p_id => 1,
p_flow_id=> wwv_flow.g_flow_id,
p_tab_set=> '',
p_name => 'Login Home Page',
p_step_title=> '&PRODUCT_NAME. Login',
p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS',
p_first_item=> 'AUTO_FIRST_ITEM',
p_include_apex_css_js_yn=>'Y',
p_autocomplete_on_off => 'OFF',
p_group_id => 222575208632450607+ wwv_flow_api.g_id_offset,
p_help_text => ' ',
p_html_page_header => ' ',
p_step_template => 9095301378087765+ wwv_flow_api.g_id_offset,
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_last_updated_by => 'SSPADAFO',
p_last_upd_yyyymmddhh24miss => '20090107165717',
p_page_is_public_y_n=> 'Y',
p_page_comment => 'intro_login');
wwv_flow_api.set_page_help_text(p_flow_id=>wwv_flow.g_flow_id,p_flow_step_id=>1,p_text=>h);
wwv_flow_api.set_html_page_header(p_flow_id=>wwv_flow.g_flow_id,p_flow_step_id=>1,p_text=>ph);
end;
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 174366009353 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 1,
p_plug_name=> 'Title',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 2,
p_plug_display_column=> 1,
p_plug_display_point=> 'REGION_POSITION_01',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> '',
p_plug_query_row_count_max => 500,
p_plug_display_condition_type => '',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 5734329754154454 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 1,
p_plug_name=> 'Tasks',
p_region_name=>'',
p_plug_template=> 155944222672692886+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 17,
p_plug_display_column=> 1,
p_plug_display_point=> 'REGION_POSITION_03',
p_plug_source=> s,
p_plug_source_type=> 115315832368341144 + wwv_flow_api.g_id_offset,
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> '',
p_plug_query_row_count_max => 500,
p_plug_column_width => 'valign="top"',
p_plug_display_condition_type => '',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||':F4550_P1_PASSWORD := null;';
wwv_flow_api.create_page_plug (
p_id=> 23202206656699152 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 1,
p_plug_name=> 'reset',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 40,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_HEADER',
p_plug_source=> s,
p_plug_source_type=> 'PLSQL_PROCEDURE',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 30251320176465048 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 1,
p_plug_name=> 'Login',
p_region_name=>'',
p_plug_template=> 21134717674904665+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 20,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> '',
p_plug_query_row_count_max => 500,
p_plug_column_width => 'valign="top"',
p_plug_display_condition_type => '',
p_plug_header=> 'Enter Application Express workspace and credentials. ''||task_name||'' '') d'||chr(10)||
'from wwv_flow_customized_tasks where displayed = ''Y'' and display_location = ''WORKSPACE_LOGIN'' order by display_sequence';
wwv_flow_api.create_report_region (
p_id=> 59842604093647546 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 1,
p_name=> 'Site-Specific Tasks',
p_region_name=>'',
p_template=> 155944222672692886+ wwv_flow_api.g_id_offset,
p_display_sequence=> 30,
p_display_column=> 1,
p_display_point=> 'REGION_POSITION_03',
p_source=> s,
p_source_type=> 'SQL_QUERY',
p_display_error_message=> '#SQLERRM#',
p_display_when_condition=> 'select 1 from wwv_flow_customized_tasks where displayed = ''Y'' and display_location = ''WORKSPACE_LOGIN''',
p_display_condition_type=> 'EXISTS',
p_plug_caching=> 'NOT_CACHED',
p_customized=> '0',
p_translate_title=> 'Y',
p_query_row_template=> 59856615437669702+ wwv_flow_api.g_id_offset,
p_query_headings_type=> 'COLON_DELMITED_LIST',
p_query_num_rows=> '15',
p_query_options=> 'DERIVED_REPORT_COLUMNS',
p_query_show_nulls_as=> ' - ',
p_query_break_cols=> '0',
p_query_no_data_found=> 'No data found.',
p_query_num_rows_type=> '0',
p_query_row_count_max=> '500',
p_pagination_display_position=> 'BOTTOM_RIGHT',
p_csv_output=> 'N',
p_query_asc_image=> 'blue_arrow_down.gif',
p_query_asc_image_attr=> 'width="13" height="12"',
p_query_desc_image=> 'blue_arrow_up.gif',
p_query_desc_image_attr=> 'width="13" height="12"',
p_comment=>'');
end;
/
declare
s varchar2(32767) := null;
begin
s := null;
wwv_flow_api.create_report_columns (
p_id=> 59843226474647566 + wwv_flow_api.g_id_offset,
p_region_id=> 59842604093647546 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_query_column_id=> 1,
p_form_element_id=> null,
p_column_alias=> 'D',
p_column_display_sequence=> 1,
p_column_heading=> 'D',
p_column_alignment=>'LEFT',
p_heading_alignment=>'LEFT',
p_default_sort_column_sequence=>0,
p_disable_sort_column=>'Y',
p_sum_column=> 'N',
p_hidden_column=> 'N',
p_display_as=>'WITHOUT_MODIFICATION',
p_pk_col_source=> s,
p_column_comment=>'');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 107302106181329608 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 1,
p_plug_name=> 'Getting Started',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 50,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_translate_title=> 'N',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'htp.prn(wwv_flow_platform.get_preference( p_preference_name => ''LOGIN_MESSAGE''));';
wwv_flow_api.create_page_plug (
p_id=> 138313119334276541 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 1,
p_plug_name=> 'Login Message',
p_region_name=>'',
p_plug_template=> 308969701495595527+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 60,
p_plug_display_column=> 1,
p_plug_display_point=> 'BEFORE_BOX_BODY',
p_plug_source=> s,
p_plug_source_type=> 'PLSQL_PROCEDURE',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
begin
wwv_flow_api.create_page_button(
p_id => 22004211512581791 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_button_sequence=> 10,
p_button_plug_id => 30251320176465048+wwv_flow_api.g_id_offset,
p_button_name => 'LOGIN_BUTTON',
p_button_image_alt=> 'Login',
p_button_position=> 'BELOW_BOX',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> '',
p_button_cattributes=>'tabindex="4" class="htmldbButton"',
p_required_patch => null + wwv_flow_api.g_id_offset);
wwv_flow_api.create_page_button(
p_id => 107299518863323821 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_button_sequence=> 20,
p_button_plug_id => 30251320176465048+wwv_flow_api.g_id_offset,
p_button_name => 'GETTING_STARTED',
p_button_image => 'template:'||to_char(20301506730451152+wwv_flow_api.g_id_offset),
p_button_image_alt=> 'Click here to learn how to get started',
p_button_position=> 'REGION_TEMPLATE_CREATE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> 'javascript:popupURL(''wwv_flow_help.show_help?p_lang=&BROWSER_LANGUAGE.&p_session=&SESSION.&p_flow_id=4550&p_step_id=1'');',
p_required_patch => null + wwv_flow_api.g_id_offset);
end;
/
begin
wwv_flow_api.create_page_branch(
p_id=>9141131880673724 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 1,
p_branch_action=> 'f?p=&APP_ID.:11:&SESSION.::&DEBUG.:::',
p_branch_point=> 'BEFORE_HEADER',
p_branch_type=> 'REDIRECT_URL',
p_branch_sequence=> 10,
p_save_state_before_branch_yn=>'N',
p_required_patch=> 9152708051846605 + wwv_flow_api.g_id_offset,
p_branch_comment=> 'Created 27-SEP-2005 22:56 by SSPADAFO');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Enter your workspace. The workspace name is case insensitive.
'||chr(10)||
'This is an online development service which provides access to a virtual private database. Since the same username may exist in multiple workspaces, you are required to enter your workspace when using this service.
';
wwv_flow_api.create_page_item(
p_id=>30250621039456935 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 1,
p_name=>'F4550_P1_COMPANY',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 10,
p_item_plug_id => 30251320176465048+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Workspace',
p_source=>'wwv_flow_utilities.get_company_from_cookie;',
p_source_type=> 'FUNCTION',
p_display_as=> 'TEXT',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 40,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_tag_attributes => 'tabindex="1"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 44225917854582269+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_escape_on_http_input => 'N',
p_help_text => h,
p_item_comment => '');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Enter your username. The username is case insensitive.
'||chr(10)||
'Once you are authenticated and assuming you have the proper credentials, you can create additional users.
';
wwv_flow_api.create_page_item(
p_id=>30251012844458645 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 1,
p_name=>'F4550_P1_USERNAME',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 10,
p_item_plug_id => 30251320176465048+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Username',
p_source=>'wwv_flow_utilities.get_un_from_cookie',
p_source_type=> 'FUNCTION',
p_display_as=> 'TEXT',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 40,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_tag_attributes => 'tabindex="2"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 44225917854582269+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_help_text => h,
p_item_comment => '');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Enter your password. Passwords are case sensitive. This password is specific to this service. Note that each workspace can have multiple users.
'||chr(10)||
'If you forget your password, select Reset Password .
';
wwv_flow_api.create_page_item(
p_id=>30251520608467092 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 1,
p_name=>'F4550_P1_PASSWORD',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 30,
p_item_plug_id => 30251320176465048+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Password',
p_source_type=> 'STATIC',
p_display_as=> 'PASSWORD_WITH_SUBMIT_DNSS',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 40,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_tag_attributes => 'tabindex="3"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 44225917854582269+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_escape_on_http_input => 'Y',
p_help_text => h,
p_item_comment => '');
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 14794408194619070 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_validation_name => 'F4550_P1_COMPANY Not Null',
p_validation_sequence=> 1,
p_validation => 'F4550_P1_COMPANY',
p_validation_type => 'ITEM_NOT_NULL',
p_error_message => 'Workspace must be specified.',
p_associated_item=> 30250621039456935 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD',
p_validation_comment=> 'generated 06-MAY-2002 18:28');
null;
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 14794718743619076 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_validation_name => 'F4550_P1_USERNAME Not Null',
p_validation_sequence=> 2,
p_validation => 'F4550_P1_USERNAME',
p_validation_type => 'ITEM_NOT_NULL',
p_error_message => 'Username must be specified.',
p_associated_item=> 30251012844458645 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD',
p_validation_comment=> 'generated 06-MAY-2002 18:28');
null;
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 14795009696619077 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_validation_name => 'F4550_P1_PASSWORD Not Null',
p_validation_sequence=> 3,
p_validation => 'F4550_P1_PASSWORD',
p_validation_type => 'ITEM_NOT_NULL',
p_error_message => 'Password must be specified.',
p_associated_item=> 30251520608467092 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD',
p_validation_comment=> 'generated 06-MAY-2002 18:28');
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'begin'||chr(10)||
' if :F4550_P1_COMPANY = ''INTERNAL'' and '||chr(10)||
' #OWNER#.wwv_flow_security.disable_admin_login then'||chr(10)||
' sys.owa_util.mime_header(''text/html'',false);'||chr(10)||
' sys.owa_util.redirect_url(''f?p=4550:10'');'||chr(10)||
' end if;'||chr(10)||
' if wwv_flow_security.disable_workspace_login then'||chr(10)||
' #OWNER#.wwv_flow.g_unrecoverable_error := true;'||chr(10)||
' sys.owa_util.status_line(404, ''Page Not Found'');'||chr(10)||
' sys.owa_util.http_he';
p:=p||'ader_close;'||chr(10)||
' end if;'||chr(10)||
'end;';
wwv_flow_api.create_page_process(
p_id => 362587120355512597 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_process_sequence=> 10,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'PLSQL',
p_process_name=> 'disabled login check',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'declare l_p varchar2(256) := v(''F4550_P1_PASSWORD'');'||chr(10)||
'begin'||chr(10)||
' wwv_flow_login.builder ('||chr(10)||
' p_username => :F4550_P1_USERNAME,'||chr(10)||
' p_workspace=> :F4550_P1_COMPANY,'||chr(10)||
' p_password => l_p);'||chr(10)||
''||chr(10)||
'end;';
wwv_flow_api.create_page_process(
p_id => 359371008265397285 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_process_sequence=> 11,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'PLSQL',
p_process_name=> 'Login',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'declare'||chr(10)||
' l_last_agent varchar2(4000) := sys.owa_util.get_cgi_env(''HTTP_USER_AGENT'');'||chr(10)||
' l_last_ip varchar2(4000) := sys.owa_util.get_cgi_env(''REMOTE_ADDR'');'||chr(10)||
' l_user varchar2(255) := #OWNER#.v(''USER'');'||chr(10)||
' l_sgid number;'||chr(10)||
'begin'||chr(10)||
'for c1 in (select PROVISIONING_COMPANY_ID '||chr(10)||
' from #OWNER#.WWV_FLOW_COMPANIES '||chr(10)||
' where SHORT_NAME = upper(:F4550_P1_COMPANY)) loop'||chr(10)||
' l_sgid :=';
p:=p||' c1.PROVISIONING_COMPANY_ID;'||chr(10)||
''||chr(10)||
'update #OWNER#.wwv_flow_fnd_user '||chr(10)||
' set last_login = sysdate, '||chr(10)||
' BUILDER_LOGIN_COUNT = nvl(BUILDER_LOGIN_COUNT,0) + 1,'||chr(10)||
' last_agent = l_last_agent,'||chr(10)||
' last_ip = l_last_ip'||chr(10)||
'where USER_NAME = l_user and '||chr(10)||
' SECURITY_GROUP_ID = l_sgid;'||chr(10)||
'end loop;'||chr(10)||
'exception when others then null;'||chr(10)||
'end;';
wwv_flow_api.create_page_process(
p_id => 79900621516189928 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_process_sequence=> 15,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'PLSQL',
p_process_name=> 'Log Login',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'1';
wwv_flow_api.create_page_process(
p_id => 491225097024458 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_process_sequence=> 20,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'CLEAR_CACHE_FOR_PAGES',
p_process_name=> 'clear',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'begin'||chr(10)||
' if not #OWNER#.wwv_flow_security.ip_check then'||chr(10)||
' #OWNER#.wwv_flow.g_unrecoverable_error := true;'||chr(10)||
' sys.owa_util.status_line(404, ''Page Not Found'');'||chr(10)||
' sys.owa_util.http_header_close;'||chr(10)||
' end if;'||chr(10)||
'end;';
wwv_flow_api.create_page_process(
p_id => 297447517593238309 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_process_sequence=> 30,
p_process_point=> 'BEFORE_HEADER',
p_process_type=> 'PLSQL',
p_process_name=> 'ip range check',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'begin'||chr(10)||
' if wwv_flow_security.disable_workspace_login then'||chr(10)||
' #OWNER#.wwv_flow.g_unrecoverable_error := true;'||chr(10)||
' sys.owa_util.status_line(404, ''Page Not Found'');'||chr(10)||
' sys.owa_util.http_header_close;'||chr(10)||
' sys.htp.p(wwv_flow_lang.system_message(''WWV_FLOW_FND_USER_API.CHECK_USER''));'||chr(10)||
' end if;'||chr(10)||
'end;';
wwv_flow_api.create_page_process(
p_id => 362585625418504590 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 1,
p_process_sequence=> 40,
p_process_point=> 'BEFORE_HEADER',
p_process_type=> 'PLSQL',
p_process_name=> 'disabled login check',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
---------------------------------------
-- ...updatable report columns for page 1
--
begin
null;
end;
null;
end;
/
--application/pages/page_00002
prompt ...PAGE 2: No Cookie
--
begin
declare
h varchar2(32767) := null;
ph varchar2(32767) := null;
begin
h := null;
ph := null;
wwv_flow_api.create_page(
p_id => 2,
p_flow_id=> wwv_flow.g_flow_id,
p_tab_set=> '',
p_name => 'No Cookie',
p_alias => 'NOCOOKIE',
p_step_title=> 'No Cookie',
p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS',
p_first_item=> 'NO_FIRST_ITEM',
p_include_apex_css_js_yn=>'Y',
p_autocomplete_on_off => '',
p_help_text => '',
p_html_page_header => '',
p_step_template => '',
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_last_updated_by => '',
p_last_upd_yyyymmddhh24miss => '20080818110607',
p_page_is_public_y_n=> 'N',
p_page_comment => '');
end;
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 134636703889796037 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 2,
p_plug_name=> 'No Cookies',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 10,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
begin
null;
end;
/
begin
null;
end;
/
begin
---------------------------------------
-- ...updatable report columns for page 2
--
begin
null;
end;
null;
end;
/
--application/pages/page_00003
prompt ...PAGE 3: Change Password
--
begin
declare
h varchar2(32767) := null;
ph varchar2(32767) := null;
begin
h := null;
ph := null;
wwv_flow_api.create_page(
p_id => 3,
p_flow_id=> wwv_flow.g_flow_id,
p_tab_set=> '',
p_name => 'Change Password',
p_step_title=> 'Change Password',
p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS',
p_first_item=> 'AUTO_FIRST_ITEM',
p_include_apex_css_js_yn=>'Y',
p_autocomplete_on_off => 'OFF',
p_help_text => '',
p_html_page_header => '',
p_step_template => 9095301378087765+ wwv_flow_api.g_id_offset,
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_last_updated_by => 'JASON',
p_last_upd_yyyymmddhh24miss => '20081230133302',
p_page_is_public_y_n=> 'Y',
p_page_comment => '');
end;
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'Password for user &P11_USERNAME. changed.';
wwv_flow_api.create_page_plug (
p_id=> 9191423473355180 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 3,
p_plug_name=> 'Confirm',
p_region_name=>'',
p_plug_template=> 249669609896384376+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 20,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1939532588110834+ wwv_flow_api.g_id_offset,
p_plug_query_headings_type=> '',
p_plug_query_row_count_max => 500,
p_plug_column_width => 'valign="top"',
p_plug_display_condition_type => 'REQUEST_EQUALS_CONDITION',
p_plug_display_when_condition => 'CONFIRM',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||':F4550_P3_PASSWORD := null;'||chr(10)||
':P3_OLD_PASSWORD := null;'||chr(10)||
':F4550_P3_CONFIRM_PASSWORD := null;';
wwv_flow_api.create_page_plug (
p_id=> 20491613569572633 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 3,
p_plug_name=> 'reset',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 30,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_HEADER',
p_plug_source=> s,
p_plug_source_type=> 'PLSQL_PROCEDURE',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 97733238886811093 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 3,
p_plug_name=> 'Change Password',
p_region_name=>'',
p_plug_template=> 249669128792384373+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 10,
p_plug_display_column=> 1,
p_plug_display_point=> 'BEFORE_BOX_BODY',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1939532588110834+ wwv_flow_api.g_id_offset,
p_plug_query_headings_type=> '',
p_plug_query_row_count_max => 500,
p_plug_column_width => 'valign="top"',
p_plug_display_condition_type => 'REQUEST_NOT_IN_CONDITION',
p_plug_display_when_condition => 'CONFIRM,LOCKED',
p_plug_header=> 'The account password has expired and must be changed.
',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
begin
wwv_flow_api.create_page_button(
p_id => 97746535656858508 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 3,
p_button_sequence=> 10,
p_button_plug_id => 9191423473355180+wwv_flow_api.g_id_offset,
p_button_name => 'Done',
p_button_image_alt=> 'Done',
p_button_position=> 'REGION_TEMPLATE_CLOSE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> 'f?p=&APP_ID.:11:&SESSION.::&DEBUG.:11,3::',
p_required_patch => null + wwv_flow_api.g_id_offset);
wwv_flow_api.create_page_button(
p_id => 9206729762461036 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 3,
p_button_sequence=> 5,
p_button_plug_id => 97733238886811093+wwv_flow_api.g_id_offset,
p_button_name => 'Cancel',
p_button_image_alt=> 'Cancel',
p_button_position=> 'REGION_TEMPLATE_CREATE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> 'f?p=&APP_ID.:11:&SESSION.::&DEBUG.:::',
p_required_patch => null + wwv_flow_api.g_id_offset);
wwv_flow_api.create_page_button(
p_id => 97747647431861978 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 3,
p_button_sequence=> 20,
p_button_plug_id => 97733238886811093+wwv_flow_api.g_id_offset,
p_button_name => 'Save',
p_button_image_alt=> 'Apply Changes',
p_button_position=> 'REGION_TEMPLATE_CREATE',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> '',
p_required_patch => null + wwv_flow_api.g_id_offset);
end;
/
begin
wwv_flow_api.create_page_branch(
p_id=>167163108516013326 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 3,
p_branch_action=> 'f?p=&FLOW_ID.:3:&SESSION.:CONFIRM:&DEBUG.:::&success_msg=#SUCCESS_MSG#',
p_branch_point=> 'AFTER_PROCESSING',
p_branch_type=> 'REDIRECT_URL',
p_branch_when_button_id=>97747647431861978+ wwv_flow_api.g_id_offset,
p_branch_sequence=> 20,
p_save_state_before_branch_yn=>'N',
p_branch_comment=> 'Created 24-JUN-2004 21:21 by SSPADAFO');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Enter the old password';
wwv_flow_api.create_page_item(
p_id=>9182307711312734 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 3,
p_name=>'P3_OLD_PASSWORD',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 15,
p_item_plug_id => 97733238886811093+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'NO',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Old Password',
p_source_type=> 'STATIC',
p_display_as=> 'PASSWORD_DNSS',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 30,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 44225917854582269+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_escape_on_http_input => 'Y',
p_help_text => h,
p_item_comment => '');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Name of the user to have password changed';
wwv_flow_api.create_page_item(
p_id=>97737538442826475 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 3,
p_name=>'F4550_P3_USER_NAME',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 10,
p_item_plug_id => 97733238886811093+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'User Name',
p_source_type=> 'STATIC',
p_display_as=> 'DISPLAY_ONLY_HTML',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 30,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_tag_attributes => 'class="fielddatabold"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 44225917854582269+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'I',
p_escape_on_http_input => 'Y',
p_help_text => h,
p_item_comment => '');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Enter the new password';
wwv_flow_api.create_page_item(
p_id=>97738659564831833 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 3,
p_name=>'F4550_P3_PASSWORD',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 20,
p_item_plug_id => 97733238886811093+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'NO',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'New Password',
p_source_type=> 'STATIC',
p_display_as=> 'PASSWORD_DNSS',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 30,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 44225917854582269+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_escape_on_http_input => 'Y',
p_help_text => h,
p_item_comment => '');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Reenter the new password';
wwv_flow_api.create_page_item(
p_id=>97739354173834337 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 3,
p_name=>'F4550_P3_CONFIRM_PASSWORD',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 30,
p_item_plug_id => 97733238886811093+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'NO',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Confirm Password',
p_source_type=> 'STATIC',
p_display_as=> 'PASSWORD_DNSS',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 30,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 44225917854582269+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_escape_on_http_input => 'Y',
p_help_text => h,
p_item_comment => '');
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 9202515863428641 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 3,
p_validation_name => 'P3_OLD_PASSWORD',
p_validation_sequence=> 10,
p_validation => 'P3_OLD_PASSWORD',
p_validation_type => 'ITEM_NOT_NULL',
p_error_message => 'Old password must be specified.',
p_when_button_pressed=> 97747647431861978 + wwv_flow_api.g_id_offset,
p_associated_item=> 9182307711312734 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 97742065159844462 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 3,
p_validation_name => 'F4550_P3_PASSWORD Not Null',
p_validation_sequence=> 20,
p_validation => 'F4550_P3_PASSWORD',
p_validation_type => 'ITEM_NOT_NULL',
p_error_message => 'New password must be specified.',
p_when_button_pressed=> 97747647431861978 + wwv_flow_api.g_id_offset,
p_associated_item=> 97738659564831833 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> 'generated 07-AUG-2002 16:59');
null;
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 97742336858844467 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 3,
p_validation_name => 'F4550_P3_CONFIRM_PASSWORD Not Null',
p_validation_sequence=> 30,
p_validation => 'F4550_P3_CONFIRM_PASSWORD',
p_validation_type => 'ITEM_NOT_NULL',
p_error_message => 'Confirm Password must be specified.',
p_associated_item=> 97739354173834337 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> 'generated 07-AUG-2002 16:59');
null;
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 97743950494851242 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 3,
p_validation_name => 'passwd = confirm passwd',
p_validation_sequence=> 40,
p_validation => 'if v(''F4550_P3_PASSWORD'') != v(''F4550_P3_CONFIRM_PASSWORD'') then'||chr(10)||
' :F4550_P3_PASSWORD := null;'||chr(10)||
' :F4550_P3_CONFIRM_PASSWORD := null;'||chr(10)||
' return false;'||chr(10)||
'else'||chr(10)||
' return true;'||chr(10)||
'end if;',
p_validation_type => 'FUNC_BODY_RETURNING_BOOLEAN',
p_error_message => 'Confirmation password does not match password.',
p_when_button_pressed=> 97747647431861978 + wwv_flow_api.g_id_offset,
p_associated_item=> 97739354173834337 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> '');
null;
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 9224322920790224 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 3,
p_validation_name => 'check old password',
p_validation_sequence=> 50,
p_validation => 'if wwv_flow_security.check_db_password('||chr(10)||
' p_username=>v(''F4550_P3_USER_NAME''),'||chr(10)||
' p_password=>v(''P3_OLD_PASSWORD'')) in (''0'',''PASSWORD EXPIRED'') then'||chr(10)||
' return true;'||chr(10)||
'else'||chr(10)||
' return false;'||chr(10)||
'end if;',
p_validation_type => 'FUNC_BODY_RETURNING_BOOLEAN',
p_error_message => 'Old password is not correct.',
p_validation_condition=> ':F4550_P3_PASSWORD is not null and :F4550_P3_CONFIRM_PASSWORD is not null',
p_validation_condition_type=> 'PLSQL_EXPRESSION',
p_when_button_pressed=> 97747647431861978 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> '');
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'declare '||chr(10)||
' l_sql varchar2(100);'||chr(10)||
' l_p varchar2(256) := v(''F4550_P3_PASSWORD'');'||chr(10)||
'begin'||chr(10)||
' begin'||chr(10)||
' wwv_flow.update_cache_with_write(''F4550_P3_PASSWORD'',null);'||chr(10)||
' wwv_flow.update_cache_with_write(''P3_OLD_PASSWORD'',null);'||chr(10)||
' wwv_flow.update_cache_with_write(''F4550_P3_CONFIRM_PASSWORD'',null);'||chr(10)||
' end;'||chr(10)||
' l_sql := ''alter user ''||:F4550_P3_USER_NAME||'' identified by ''||l_p;'||chr(10)||
'execute immediate l_sql;'||chr(10)||
'end;';
wwv_flow_api.create_page_process(
p_id => 97750634955873615 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 3,
p_process_sequence=> 10,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'PLSQL',
p_process_name=> 'change password',
p_process_sql_clob => p,
p_process_error_message=> 'Error changing password.',
p_process_when_button_id=>97747647431861978 + wwv_flow_api.g_id_offset,
p_process_when=>':F4550_P3_PASSWORD = :F4550_P3_CONFIRM_PASSWORD',
p_process_when_type=>'PLSQL_EXPRESSION',
p_process_success_message=> 'Password changed.',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'3';
wwv_flow_api.create_page_process(
p_id => 60831518199464684 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 3,
p_process_sequence=> 20,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'CLEAR_CACHE_FOR_PAGES',
p_process_name=> 'clear',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_when_button_id=>97747647431861978 + wwv_flow_api.g_id_offset,
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
---------------------------------------
-- ...updatable report columns for page 3
--
begin
null;
end;
null;
end;
/
--application/pages/page_00004
prompt ...PAGE 4: Find My Workspace
--
begin
declare
h varchar2(32767) := null;
ph varchar2(32767) := null;
begin
h := null;
ph := null;
wwv_flow_api.create_page(
p_id => 4,
p_flow_id=> wwv_flow.g_flow_id,
p_tab_set=> '',
p_name => 'Find My Workspace',
p_alias => 'REQUESTWORKSPACE',
p_step_title=> 'Find My Workspace',
p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS',
p_first_item=> 'AUTO_FIRST_ITEM',
p_include_apex_css_js_yn=>'Y',
p_autocomplete_on_off => '',
p_help_text => '',
p_html_page_header => '',
p_step_template => '',
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_last_updated_by => 'CBCHO',
p_last_upd_yyyymmddhh24miss => '20071120070307',
p_page_is_public_y_n=> 'Y',
p_page_comment => '');
end;
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 22878608880410975 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 4,
p_plug_name=> 'Find My Workspace',
p_region_name=>'',
p_plug_template=> 249669128792384373+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 10,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_header=> 'You will receive all workspace names associated with this email address.',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
begin
wwv_flow_api.create_page_button(
p_id => 22883630052445491 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 4,
p_button_sequence=> 10,
p_button_plug_id => 22878608880410975+wwv_flow_api.g_id_offset,
p_button_name => 'CANCEL',
p_button_image_alt=> 'Cancel',
p_button_position=> 'BOTTOM',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> '',
p_required_patch => null + wwv_flow_api.g_id_offset);
wwv_flow_api.create_page_button(
p_id => 26487014153670357 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 4,
p_button_sequence=> 20,
p_button_plug_id => 22878608880410975+wwv_flow_api.g_id_offset,
p_button_name => 'CREATE',
p_button_image_alt=> 'Find Workspace',
p_button_position=> 'BOTTOM',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> '',
p_required_patch => null + wwv_flow_api.g_id_offset);
end;
/
begin
wwv_flow_api.create_page_branch(
p_id=>26487310047670358 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 4,
p_branch_action=> 'f?p=&APP_ID.:1:&SESSION.::&DEBUG.:4::&success_msg=#SUCCESS_MSG#',
p_branch_point=> 'AFTER_PROCESSING',
p_branch_type=> 'REDIRECT_URL',
p_branch_when_button_id=>26487014153670357+ wwv_flow_api.g_id_offset,
p_branch_sequence=> 10,
p_save_state_before_branch_yn=>'N',
p_branch_comment=> '');
wwv_flow_api.create_page_branch(
p_id=>22891903920551475 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 4,
p_branch_action=> 'f?p=&APP_ID.:1:&SESSION.::&DEBUG.:::',
p_branch_point=> 'BEFORE_COMPUTATION',
p_branch_type=> 'REDIRECT_URL',
p_branch_when_button_id=>22883630052445491+ wwv_flow_api.g_id_offset,
p_branch_sequence=> 10,
p_save_state_before_branch_yn=>'N',
p_branch_comment=> 'Created 13-DEC-2006 01:54 by RAJU');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Enter the email address associated with your workspace. We will send your workspace name to this email.';
wwv_flow_api.create_page_item(
p_id=>22881822648433869 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 4,
p_name=>'F4550_P4_EMAIL',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 10,
p_item_plug_id => 22878608880410975+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Your email address in our database',
p_source_type=> 'STATIC',
p_display_as=> 'TEXT',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 30,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 14882217773748275+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_help_text => h,
p_item_comment => '');
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 22955710724969695 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 4,
p_validation_name => 'F4550_P4_EMAIL must be valid',
p_validation_sequence=> 10,
p_validation => 'declare'||chr(10)||
' l_at number;'||chr(10)||
' l_dot number;'||chr(10)||
'begin'||chr(10)||
' l_at := instr(nvl(:F4550_P4_EMAIL,''x''),''@'');'||chr(10)||
' l_dot := instr(nvl(:F4550_P4_EMAIL,''x''),''.'',l_at);'||chr(10)||
' return l_at > 1 and l_dot > 1 and (l_dot - l_at) > 1;'||chr(10)||
'end;',
p_validation_type => 'FUNC_BODY_RETURNING_BOOLEAN',
p_error_message => 'Email format incorrect.',
p_when_button_pressed=> 26487014153670357 + wwv_flow_api.g_id_offset,
p_associated_item=> 22881822648433869 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> '');
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'wwv_flow_fnd_developer_api.f4550_send_workspace ('||chr(10)||
' p_email_address => :F4550_P4_EMAIL );';
wwv_flow_api.create_page_process(
p_id => 22891011754544211 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 4,
p_process_sequence=> 10,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'PLSQL',
p_process_name=> 'send workspace name',
p_process_sql_clob => p,
p_process_error_message=> 'Error',
p_process_when_button_id=>26487014153670357 + wwv_flow_api.g_id_offset,
p_process_success_message=> 'If &F4550_P4_EMAIL. exists in our records, we will send the workspace names associated with this email address. If you are having problems receiving the workspace names, please contact your administrator.',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
---------------------------------------
-- ...updatable report columns for page 4
--
begin
null;
end;
null;
end;
/
--application/pages/page_00007
prompt ...PAGE 7: Reset Password
--
begin
declare
h varchar2(32767) := null;
ph varchar2(32767) := null;
begin
h := null;
ph := null;
wwv_flow_api.create_page(
p_id => 7,
p_flow_id=> wwv_flow.g_flow_id,
p_tab_set=> '',
p_name => 'Reset Password',
p_step_title=> 'Reset Password',
p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS',
p_first_item=> 'AUTO_FIRST_ITEM',
p_include_apex_css_js_yn=>'Y',
p_autocomplete_on_off => '',
p_group_id => 222577907724459883+ wwv_flow_api.g_id_offset,
p_help_text => '',
p_html_page_header => '',
p_step_template => '',
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_last_updated_by => '',
p_last_upd_yyyymmddhh24miss => '20080818110607',
p_page_is_public_y_n=> 'Y',
p_page_comment => '');
end;
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 47285769528327391 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 7,
p_plug_name=> 'Reset Password',
p_region_name=>'',
p_plug_template=> 249669128792384373+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 20,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> '',
p_plug_query_row_count_max => 500,
p_plug_column_width => 'valign="top"',
p_plug_display_condition_type => '',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'115315832368341144';
wwv_flow_api.create_page_plug (
p_id=> 74608502164703922 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 7,
p_plug_name=> 'Tasks',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 30,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 74614416147717398 + wwv_flow_api.g_id_offset,
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'COLON_DELMITED_LIST',
p_plug_query_row_count_max => 500,
p_plug_display_condition_type => '',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
begin
wwv_flow_api.create_page_button(
p_id => 14635328375431475 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 7,
p_button_sequence=> 1,
p_button_plug_id => 47285769528327391+wwv_flow_api.g_id_offset,
p_button_name => 'Cancel',
p_button_image_alt=> 'Cancel',
p_button_position=> 'BOTTOM',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> 'f?p=&APP_ID.:1:&SESSION.::&DEBUG.:::',
p_required_patch => null + wwv_flow_api.g_id_offset);
wwv_flow_api.create_page_button(
p_id => 47286811980358498 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 7,
p_button_sequence=> 10,
p_button_plug_id => 47285769528327391+wwv_flow_api.g_id_offset,
p_button_name => 'resetpassword',
p_button_image_alt=> 'Reset Password',
p_button_position=> 'BOTTOM',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> '',
p_required_patch => null + wwv_flow_api.g_id_offset);
end;
/
begin
wwv_flow_api.create_page_branch(
p_id=>60120000609053928 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 7,
p_branch_action=> 'f?p=&APP_ID.:7:&SESSION.::&DEBUG.:::',
p_branch_point=> 'AFTER_PROCESSING',
p_branch_type=> 'REDIRECT_URL',
p_branch_sequence=> 1,
p_branch_condition_type=> 'ITEM_IS_NOT_NULL',
p_branch_condition=> 'ERROR_OCCURRED',
p_save_state_before_branch_yn=>'N',
p_branch_comment=> 'Created 12-JAN-2007 17:19 by MIKE');
wwv_flow_api.create_page_branch(
p_id=>60096028904579631 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 7,
p_branch_action=> 'f?p=&APP_ID.:1:&SESSION.::&DEBUG.:::&success_msg=#SUCCESS_MSG#',
p_branch_point=> 'AFTER_PROCESSING',
p_branch_type=> 'REDIRECT_URL',
p_branch_sequence=> 99,
p_save_state_before_branch_yn=>'N',
p_branch_comment=> 'Created 12-JAN-2007 16:00 by MIKE');
end;
/
declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>22923025971699756 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 7,
p_name=>'F4550_P7_ERROR_TEXT',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 5,
p_item_plug_id => 47285769528327391+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'You did not provide a valid combination of workspace name and email address. ',
p_source_type=> 'STATIC',
p_display_as=> 'DISPLAY_ONLY_HTML',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 30,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_display_when=>'ERROR_OCCURRED',
p_display_when_type=>'ITEM_IS_NOT_NULL',
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_item_comment => '');
end;
/
declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>22936513812743509 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 7,
p_name=>'F4550_P7_NEWTABLE',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 7,
p_item_plug_id => 47285769528327391+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_source_type=> 'STATIC',
p_display_as=> 'STOP_AND_START_HTML_TABLE',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 30,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_display_when=>'ERROR_OCCURRED',
p_display_when_type=>'ITEM_IS_NOT_NULL',
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_item_comment => '');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Enter your workspace. If you do not know your workspace, use the Find My Workspace link.';
wwv_flow_api.create_page_item(
p_id=>47286220449334625 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 7,
p_name=>'F4550_P7_COMPANY',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 20,
p_item_plug_id => 47285769528327391+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Workspace',
p_source_type=> 'STATIC',
p_display_as=> 'TEXT',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 30,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 14882217773748275+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_escape_on_http_input => 'N',
p_help_text => h,
p_item_comment => '');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Enter your email address so we can email you your password.';
wwv_flow_api.create_page_item(
p_id=>47286414702337991 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 7,
p_name=>'F4550_P7_EMAIL',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 10,
p_item_plug_id => 47285769528327391+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Your email address in our database',
p_source_type=> 'STATIC',
p_display_as=> 'TEXT',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 30,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 14882217773748275+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_help_text => h,
p_item_comment => '');
end;
/
begin
wwv_flow_api.create_page_computation(
p_id=> 22910528694672171 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 7,
p_computation_sequence => 10,
p_computation_item=> 'ERROR_OCCURRED',
p_computation_point=> 'AFTER_FOOTER',
p_computation_type=> 'STATIC_ASSIGNMENT',
p_computation_processed=> 'REPLACE_EXISTING',
p_computation=> '',
p_compute_when => '',
p_compute_when_type=>'%null%');
null;
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 74605102595685181 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 7,
p_validation_name => 'F4550_P7_EMAIL Not Null',
p_validation_sequence=> 1,
p_validation => 'F4550_P7_EMAIL',
p_validation_type => 'ITEM_NOT_NULL',
p_error_message => 'Email must be specified.',
p_associated_item=> 47286414702337991 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> 'generated 23-JAN-2007 07:29');
null;
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 74605307525685181 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 7,
p_validation_name => 'F4550_P7_COMPANY Not Null',
p_validation_sequence=> 2,
p_validation => 'F4550_P7_COMPANY',
p_validation_type => 'ITEM_NOT_NULL',
p_error_message => 'Workspace must be specified.',
p_associated_item=> 47286220449334625 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION',
p_validation_comment=> 'generated 23-JAN-2007 07:29');
null;
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 359674223295887132 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 7,
p_validation_name => 'do not allow internal',
p_validation_sequence=> 10,
p_validation => 'nvl(upper(:F4550_P7_COMPANY),''x'') != ''INTERNAL''',
p_validation_type => 'PLSQL_EXPRESSION',
p_error_message => 'Password reset operation not supported for INTERNAL workspace.',
p_associated_item=> 47286220449334625 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD',
p_validation_comment=> '');
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'wwv_flow_fnd_developer_api.f4550_reset_password ('||chr(10)||
' p_email_address=> :F4550_P7_EMAIL,'||chr(10)||
' p_workspace_name=> :F4550_P7_COMPANY );';
wwv_flow_api.create_page_process(
p_id => 47291128490577452 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 7,
p_process_sequence=> 10,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'PLSQL',
p_process_name=> 'change password',
p_process_sql_clob => p,
p_process_error_message=> 'Unable to reset password.',
p_process_when_button_id=>47286811980358498 + wwv_flow_api.g_id_offset,
p_process_success_message=> 'Reset password request has been sent for processing.',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
---------------------------------------
-- ...updatable report columns for page 7
--
begin
null;
end;
null;
end;
/
--application/pages/page_00008
prompt ...PAGE 8: Logout Confirmation
--
begin
declare
h varchar2(32767) := null;
ph varchar2(32767) := null;
begin
h := null;
ph := null;
wwv_flow_api.create_page(
p_id => 8,
p_flow_id=> wwv_flow.g_flow_id,
p_tab_set=> '',
p_name => 'Logout Confirmation',
p_step_title=> 'Logout Confirmation',
p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS',
p_first_item=> 'AUTO_FIRST_ITEM',
p_include_apex_css_js_yn=>'Y',
p_autocomplete_on_off => '',
p_group_id => 222579123308464377+ wwv_flow_api.g_id_offset,
p_help_text => '',
p_html_page_header => '',
p_step_template => '',
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_last_updated_by => '',
p_last_upd_yyyymmddhh24miss => '20080818110607',
p_page_is_public_y_n=> 'Y',
p_page_comment => '');
end;
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'htp.p('''' || wwv_flow_lang.system_message(''YOU_ARE_NOW_LOGGED_OUT'') || '' '');'||chr(10)||
'htp.prn(''''||wwv_flow_lang.system_message(''LOGIN'')||'' '');';
wwv_flow_api.create_page_plug (
p_id=> 47289611174520429 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 8,
p_plug_name=> 'Logout Confirmation',
p_region_name=>'',
p_plug_template=> 308969701495595527+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 10,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'PLSQL_PROCEDURE',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> '',
p_plug_query_row_count_max => 500,
p_plug_column_width => 'valign="top"',
p_plug_display_condition_type => '',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
begin
null;
end;
/
begin
wwv_flow_api.create_page_branch(
p_id=>9143113011706116 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 8,
p_branch_action=> 'f?p=&APP_ID.:9:&SESSION.::&DEBUG.:::',
p_branch_point=> 'BEFORE_HEADER',
p_branch_type=> 'REDIRECT_URL',
p_branch_sequence=> 10,
p_save_state_before_branch_yn=>'N',
p_required_patch=> 9152708051846605 + wwv_flow_api.g_id_offset,
p_branch_comment=> 'Created 27-SEP-2005 23:02 by SSPADAFO');
wwv_flow_api.create_page_branch(
p_id=>47290514531564696 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 8,
p_branch_action=> '&P8_NEXTPAGE.',
p_branch_point=> 'BEFORE_VALIDATION',
p_branch_type=> 'BRANCH_TO_STEP',
p_branch_sequence=> 10,
p_save_state_before_branch_yn=>'N',
p_branch_comment=> 'Created 22-MAR-2001 19:57 by MIKE');
end;
/
declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>72005820105419587 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 8,
p_name=>'P8_NEXTPAGE',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 10,
p_item_plug_id => 47289611174520429+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default => '1',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_source_type=> 'STATIC',
p_display_as=> 'HIDDEN',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> null,
p_cMaxlength=> 2000,
p_cHeight=> null,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'LEFT',
p_field_alignment => 'LEFT',
p_is_persistent=> 'Y',
p_item_comment => '');
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'delete from wwv_flow_sessions$ where id = :flow_session;';
wwv_flow_api.create_page_process(
p_id => 48179495483070440 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 8,
p_process_sequence=> 20,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'PLSQL',
p_process_name=> 'clean up session state',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
---------------------------------------
-- ...updatable report columns for page 8
--
begin
null;
end;
null;
end;
/
--application/pages/page_00009
prompt ...PAGE 9: Logout Confirmation
--
begin
declare
h varchar2(32767) := null;
ph varchar2(32767) := null;
begin
h := null;
ph := null;
wwv_flow_api.create_page(
p_id => 9,
p_flow_id=> wwv_flow.g_flow_id,
p_tab_set=> '',
p_name => 'Logout Confirmation',
p_step_title=> 'Logout Confirmation',
p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS',
p_first_item=> 'AUTO_FIRST_ITEM',
p_include_apex_css_js_yn=>'Y',
p_autocomplete_on_off => '',
p_help_text => '',
p_html_page_header => '',
p_step_template => 9095301378087765+ wwv_flow_api.g_id_offset,
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_last_updated_by => 'CBCHO',
p_last_upd_yyyymmddhh24miss => '20071120070307',
p_page_is_public_y_n=> 'Y',
p_page_comment => '');
end;
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'htp.p('''' || wwv_flow_lang.system_message(''YOU_ARE_NOW_LOGGED_OUT'') || '' '');'||chr(10)||
'htp.prn(''''||wwv_flow_lang.system_message(''LOGIN'')||'' '');';
wwv_flow_api.create_page_plug (
p_id=> 322068013750423668 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 9,
p_plug_name=> 'Logout Confirmation',
p_region_name=>'',
p_plug_template=> 308969701495595527+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 10,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'PLSQL_PROCEDURE',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> '',
p_plug_query_row_count_max => 500,
p_plug_column_width => 'valign="top"',
p_plug_display_condition_type => '',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
begin
null;
end;
/
begin
wwv_flow_api.create_page_branch(
p_id=>322068917107467935 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 9,
p_branch_action=> '&P9_NEXTPAGE.',
p_branch_point=> 'BEFORE_VALIDATION',
p_branch_type=> 'BRANCH_TO_STEP',
p_branch_sequence=> 10,
p_save_state_before_branch_yn=>'N',
p_branch_comment=> 'Created 22-MAR-2001 19:57 by MIKE');
end;
/
declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>346784222681322826 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 9,
p_name=>'P9_NEXTPAGE',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 10,
p_item_plug_id => 322068013750423668+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default => '11',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_source_type=> 'STATIC',
p_display_as=> 'HIDDEN',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> null,
p_cMaxlength=> 2000,
p_cHeight=> null,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'LEFT',
p_field_alignment => 'LEFT',
p_is_persistent=> 'Y',
p_item_comment => '');
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'delete from wwv_flow_sessions$ where id = :flow_session;';
wwv_flow_api.create_page_process(
p_id => 322957898058973679 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 9,
p_process_sequence=> 20,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'PLSQL',
p_process_name=> 'clean up session state',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
---------------------------------------
-- ...updatable report columns for page 9
--
begin
null;
end;
null;
end;
/
--application/pages/page_00010
prompt ...PAGE 10: Internal Administration Login
--
begin
declare
h varchar2(32767) := null;
ph varchar2(32767) := null;
begin
h := null;
ph:=ph||'';
wwv_flow_api.create_page(
p_id => 10,
p_flow_id=> wwv_flow.g_flow_id,
p_tab_set=> '',
p_name => 'Internal Administration Login',
p_step_title=> '&PRODUCT_NAME. Administration Services',
p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS',
p_first_item=> 'AUTO_FIRST_ITEM',
p_include_apex_css_js_yn=>'Y',
p_autocomplete_on_off => 'OFF',
p_group_id => 222575208632450607+ wwv_flow_api.g_id_offset,
p_help_text => '',
p_html_page_header => ' ',
p_step_template => 9095301378087765+ wwv_flow_api.g_id_offset,
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_last_updated_by => 'SSPADAFO',
p_last_upd_yyyymmddhh24miss => '20090107165733',
p_page_is_public_y_n=> 'Y',
p_page_comment => '');
wwv_flow_api.set_html_page_header(p_flow_id=>wwv_flow.g_flow_id,p_flow_step_id=>10,p_text=>ph);
end;
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 1043922209309491 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 10,
p_plug_name=> '&PRODUCT_NAME. Administration Services',
p_region_name=>'',
p_plug_template=> 14581217810376673+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 3,
p_plug_display_column=> 1,
p_plug_display_point=> 'REGION_POSITION_02',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> '',
p_plug_query_row_count_max => 500,
p_plug_column_width => 'valign="top"',
p_plug_display_condition_type => '',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||':P10_PASSWORD := null;';
wwv_flow_api.create_page_plug (
p_id=> 23205800319914944 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 10,
p_plug_name=> 'reset',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 23,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_HEADER',
p_plug_source=> s,
p_plug_source_type=> 'PLSQL_PROCEDURE',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'Using this interface the administrator can manage all aspects of the service including creating, removing, and managing workspaces.';
wwv_flow_api.create_page_plug (
p_id=> 61702507141217977 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 10,
p_plug_name=> 'Login Message',
p_region_name=>'',
p_plug_template=> 61771527068337270+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 1,
p_plug_display_column=> 1,
p_plug_display_point=> 'REGION_POSITION_02',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'61885431289518270';
wwv_flow_api.create_page_plug (
p_id=> 61888212026522164 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 10,
p_plug_name=> 'Tasks',
p_region_name=>'',
p_plug_template=> 155944222672692886+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 13,
p_plug_display_column=> 1,
p_plug_display_point=> 'REGION_POSITION_03',
p_plug_source=> s,
p_plug_source_type=> 61885431289518270 + wwv_flow_api.g_id_offset,
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'COLON_DELMITED_LIST',
p_plug_query_row_count_max => 500,
p_plug_display_condition_type => 'NEVER',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
begin
wwv_flow_api.create_page_button(
p_id => 1045428295309521 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 10,
p_button_sequence=> 20,
p_button_plug_id => 1043922209309491+wwv_flow_api.g_id_offset,
p_button_name => 'LOGIN_BUTTON',
p_button_image_alt=> 'Login',
p_button_position=> 'BOTTOM',
p_button_alignment=> 'RIGHT',
p_button_redirect_url=> '',
p_button_condition_type=> 'NEVER',
p_required_patch => null + wwv_flow_api.g_id_offset);
end;
/
begin
null;
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Enter your username. The username is case insensitive. Once you are authenticated and assuming you have the proper credentials you can create additional usernames.';
wwv_flow_api.create_page_item(
p_id=>1046305318309559 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 10,
p_name=>'P10_USERNAME',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 10,
p_item_plug_id => 1043922209309491+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Username',
p_source_type=> 'STATIC',
p_display_as=> 'TEXT',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 25,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 44225917854582269+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_help_text => h,
p_item_comment => '');
end;
/
declare
h varchar2(32767) := null;
begin
h := null;
h:=h||'Enter your password. Passwords are case sensitive. If you forget your password click on the "forget your password" link. Note that each workspace can have multiple users.';
wwv_flow_api.create_page_item(
p_id=>1046904764309561 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 10,
p_name=>'P10_PASSWORD',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 30,
p_item_plug_id => 1043922209309491+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'YES',
p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS',
p_prompt=>'Password',
p_source_type=> 'STATIC',
p_display_as=> 'PASSWORD_WITH_SUBMIT_DNSS',
p_lov_columns=> 1,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> 25,
p_cMaxlength=> 2000,
p_cHeight=> 1,
p_cAttributes=> 'nowrap="nowrap"',
p_begin_on_new_line => 'YES',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'RIGHT',
p_field_alignment => 'LEFT',
p_field_template => 44225917854582269+wwv_flow_api.g_id_offset,
p_is_persistent=> 'Y',
p_lov_display_extra=>'NO',
p_protection_level => 'N',
p_escape_on_http_input => 'Y',
p_help_text => h,
p_item_comment => '');
end;
/
declare
h varchar2(32767) := null;
begin
wwv_flow_api.create_page_item(
p_id=>359654713065770666 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id=> 10,
p_name=>'P10_LOGIN',
p_data_type=> 'VARCHAR',
p_accept_processing=> 'REPLACE_EXISTING',
p_item_sequence=> 40,
p_item_plug_id => 1043922209309491+wwv_flow_api.g_id_offset,
p_use_cache_before_default=> 'NO',
p_item_default => 'LOGIN_BUTTON',
p_prompt=>'Login',
p_source=>'LOGIN_BUTTON',
p_source_type=> 'STATIC',
p_display_as=> 'BUTTON',
p_lov_columns=> null,
p_lov_display_null=> 'NO',
p_lov_translated=> 'N',
p_cSize=> null,
p_cMaxlength=> 2000,
p_cHeight=> null,
p_begin_on_new_line => 'NO',
p_begin_on_new_field=> 'YES',
p_colspan => 1,
p_rowspan => 1,
p_label_alignment => 'LEFT',
p_field_alignment => 'LEFT',
p_is_persistent=> 'N',
p_item_comment => '');
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 1047801276309579 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 10,
p_validation_name => 'P10_USERNAME Not Null',
p_validation_sequence=> 2,
p_validation => 'P10_USERNAME',
p_validation_type => 'ITEM_NOT_NULL',
p_error_message => 'Username must be specified.',
p_associated_item=> 1046305318309559 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD',
p_validation_comment=> 'generated 06-MAY-2002 18:28');
null;
end;
/
begin
wwv_flow_api.create_page_validation(
p_id => 1048123136309580 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_flow_step_id => 10,
p_validation_name => 'P10_PASSWORD Not Null',
p_validation_sequence=> 3,
p_validation => 'P10_PASSWORD',
p_validation_type => 'ITEM_NOT_NULL',
p_error_message => 'Password must be specified.',
p_associated_item=> 1046904764309561 + wwv_flow_api.g_id_offset,
p_error_display_location=>'INLINE_WITH_FIELD',
p_validation_comment=> 'generated 06-MAY-2002 18:28');
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'begin'||chr(10)||
' if wwv_flow_security.disable_admin_login then'||chr(10)||
' #OWNER#.wwv_flow.g_unrecoverable_error := true;'||chr(10)||
' sys.owa_util.status_line(404, ''Page Not Found'');'||chr(10)||
' sys.owa_util.http_header_close;'||chr(10)||
' end if;'||chr(10)||
'end;';
wwv_flow_api.create_page_process(
p_id => 239007203778570571 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 10,
p_process_sequence=> 10,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'PLSQL',
p_process_name=> 'disabled login check',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'declare l_p varchar2(256) := #OWNER#.v(''P10_PASSWORD'');'||chr(10)||
'begin'||chr(10)||
' #OWNER#.wwv_flow_login.administrator ('||chr(10)||
' p_username => :P10_USERNAME,'||chr(10)||
' p_password => l_p);'||chr(10)||
'end;';
wwv_flow_api.create_page_process(
p_id => 359608213674439626 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 10,
p_process_sequence=> 20,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'PLSQL',
p_process_name=> 'Login',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'10';
wwv_flow_api.create_page_process(
p_id => 1048720322309594 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 10,
p_process_sequence=> 30,
p_process_point=> 'AFTER_SUBMIT',
p_process_type=> 'CLEAR_CACHE_FOR_PAGES',
p_process_name=> 'clear Items on this page',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'begin'||chr(10)||
' if not #OWNER#.wwv_flow_security.ip_check then'||chr(10)||
' #OWNER#.wwv_flow.g_unrecoverable_error := true;'||chr(10)||
' sys.owa_util.status_line(404, ''Page Not Found'');'||chr(10)||
' sys.owa_util.http_header_close;'||chr(10)||
' end if;'||chr(10)||
'end;';
wwv_flow_api.create_page_process(
p_id => 297445926120231391 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 10,
p_process_sequence=> 30,
p_process_point=> 'BEFORE_HEADER',
p_process_type=> 'PLSQL',
p_process_name=> 'ip range check',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
declare
p varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
p:=p||'begin'||chr(10)||
' if #OWNER#.wwv_flow_security.disable_admin_login then'||chr(10)||
' #OWNER#.wwv_flow.g_unrecoverable_error := true;'||chr(10)||
' sys.owa_util.status_line(404, ''Page Not Found'');'||chr(10)||
' sys.owa_util.http_header_close;'||chr(10)||
' sys.htp.p(wwv_flow_lang.system_message(''WWV_FLOW_FND_USER_API.CHECK_USER''));'||chr(10)||
' end if;'||chr(10)||
'end;';
wwv_flow_api.create_page_process(
p_id => 362591402740535889 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_flow_step_id => 10,
p_process_sequence=> 40,
p_process_point=> 'BEFORE_HEADER',
p_process_type=> 'PLSQL',
p_process_name=> 'disabled login check',
p_process_sql_clob => p,
p_process_error_message=> '',
p_process_success_message=> '',
p_process_is_stateful_y_n=>'N',
p_process_comment=>'');
end;
null;
end;
/
begin
---------------------------------------
-- ...updatable report columns for page 10
--
begin
null;
end;
null;
end;
/
--application/pages/page_00011
prompt ...PAGE 11: Login Home Page
--
begin
declare
h varchar2(32767) := null;
ph varchar2(32767) := null;
begin
h := null;
ph:=ph||''||chr(10)||
''||chr(10)||
'';
wwv_flow_api.create_page(
p_id => 11,
p_flow_id=> wwv_flow.g_flow_id,
p_tab_set=> '',
p_name => 'Login Home Page',
p_step_title=> '&PRODUCT_NAME. Login',
p_html_page_onload=>'onload="pg11_CheckCookie(this);"',
p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS',
p_first_item=> 'AUTO_FIRST_ITEM',
p_include_apex_css_js_yn=>'Y',
p_autocomplete_on_off => 'OFF',
p_help_text => '',
p_html_page_header => ' ',
p_step_template => 9095301378087765+ wwv_flow_api.g_id_offset,
p_required_patch=> null + wwv_flow_api.g_id_offset,
p_last_updated_by => 'JASON',
p_last_upd_yyyymmddhh24miss => '20081230133602',
p_page_is_public_y_n=> 'Y',
p_page_comment => '');
wwv_flow_api.set_html_page_header(p_flow_id=>wwv_flow.g_flow_id,p_flow_step_id=>11,p_text=>ph);
end;
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'2370922717381617';
wwv_flow_api.create_page_plug (
p_id=> 2372620770390552 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 11,
p_plug_name=> 'Links',
p_region_name=>'',
p_plug_template=> 155944222672692886+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 30,
p_plug_display_column=> 1,
p_plug_display_point=> 'REGION_POSITION_03',
p_plug_source=> s,
p_plug_source_type=> 9101817486130207 + wwv_flow_api.g_id_offset,
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'COLON_DELMITED_LIST',
p_plug_query_row_count_max => 500,
p_plug_display_condition_type => '',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 2376609950406299 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 11,
p_plug_name=> 'Welcome',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 40,
p_plug_display_column=> 1,
p_plug_display_point=> 'REGION_POSITION_02',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||':P11_PASSWORD := null;';
wwv_flow_api.create_page_plug (
p_id=> 20499119792848842 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 11,
p_plug_name=> 'reset',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 50,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_HEADER',
p_plug_source=> s,
p_plug_source_type=> 'PLSQL_PROCEDURE',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 20982304569513152 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 11,
p_plug_name=> ' ',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 30,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'htp.prn(wwv_flow_platform.get_preference( p_preference_name => ''LOGIN_MESSAGE''));';
wwv_flow_api.create_page_plug (
p_id=> 21359618388559040 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 11,
p_plug_name=> 'Warning:',
p_region_name=>'',
p_plug_template=> 308969701495595527+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 60,
p_plug_display_column=> 1,
p_plug_display_point=> 'BEFORE_FOOTER',
p_plug_source=> s,
p_plug_source_type=> 'PLSQL_PROCEDURE',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'htp.prn('''');'||chr(10)||
'htp.prn(''''||wwv_flow_lang.system_message(''4550_JAVASCRIPT_ENABLED'')||''
'');'||chr(10)||
'htp.prn('' '');';
wwv_flow_api.create_page_plug (
p_id=> 27757202486631095 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 11,
p_plug_name=> 'No Javascript Enabled',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 1,
p_plug_display_column=> 1,
p_plug_display_point=> 'REGION_POSITION_01',
p_plug_source=> s,
p_plug_source_type=> 'PLSQL_PROCEDURE',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'htp.prn(''''||wwv_flow_lang.system_message(''4550_COOKIES_ENABLED'')||''
'');';
wwv_flow_api.create_page_plug (
p_id=> 27775212881838952 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 11,
p_plug_name=> 'No Cookies Enabled',
p_region_name=>'',
p_plug_template=> 0,
p_plug_display_sequence=> 70,
p_plug_display_column=> 1,
p_plug_display_point=> 'REGION_POSITION_01',
p_plug_source=> s,
p_plug_source_type=> 'PLSQL_PROCEDURE',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> 'QUERY_COLUMNS',
p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS',
p_plug_query_row_count_max => 500,
p_plug_query_show_nulls_as => ' - ',
p_plug_display_condition_type => '',
p_pagination_display_position=>'BOTTOM_RIGHT',
p_plug_customized=>'0',
p_plug_caching=> 'NOT_CACHED',
p_plug_comment=> '');
end;
/
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s := null;
wwv_flow_api.create_page_plug (
p_id=> 305029722752368287 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_page_id=> 11,
p_plug_name=> 'Database Login',
p_region_name=>'',
p_plug_template=> 21134717674904665+ wwv_flow_api.g_id_offset,
p_plug_display_sequence=> 20,
p_plug_display_column=> 1,
p_plug_display_point=> 'AFTER_SHOW_ITEMS',
p_plug_source=> s,
p_plug_source_type=> 'STATIC_TEXT',
p_translate_title=> 'Y',
p_plug_display_error_message=> '#SQLERRM#',
p_plug_query_row_template=> 1,
p_plug_query_headings_type=> '',
p_plug_query_row_count_max => 500,
p_plug_column_width => 'valign="top"',
p_plug_display_condition_type => '',
p_plug_header=> 'Enter your database username and password. #TITLE# &MSG_JSCRIPT. #FORM_OPEN#&MSG_LANGUAGE.: &BROWSER_LANGUAGE.
'||chr(10)||
'#FLOW_VERSION#
'||chr(10)||
''||chr(10)||
'
'||chr(10)||
'
&MSG_COPYRIGHT.
'||chr(10)||
'
'||chr(10)||
'
#LOGO#
'||chr(10)||
'
'||chr(10)||
'
'||chr(10)||
'
'||chr(10)||
'#SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#
'||chr(10)||
''||chr(10)||
'
'||chr(10)||
''||chr(10)||
'#REGION_POSITION_01# '||chr(10)||
'
#REGION_POSITION_02##REGION_POSITION_04##BOX_BODY# '||chr(10)||
'
#REGION_POSITION_03##REGION_POSITION_05#
'||chr(10)||
'
'||chr(10)||
'
#SUCCESS_MESSAGE#
#MESSAGE#
#MESSAGE# '||chr(10)||
'#RETURN_TO_APPLICATION# ',
p_reference_id=> 80966020820422852,
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
--application/shared_components/user_interface/templates/page/login_page_standard_from_4999
prompt ......Page template 60929357198712420
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
c1:=c1||''||chr(10)||
'#TITLE# &MSG_JSCRIPT. #FORM_OPEN#&MSG_LANGUAGE.: &BROWSER_LANGUAGE.
'||chr(10)||
'#FLOW_VERSION#
'||chr(10)||
''||chr(10)||
'
'||chr(10)||
'
&MSG_COPYRIGHT.
'||chr(10)||
'
'||chr(10)||
'
#LOGO#
'||chr(10)||
'
'||chr(10)||
'
'||chr(10)||
'
'||chr(10)||
'#SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#
'||chr(10)||
''||chr(10)||
'
'||chr(10)||
''||chr(10)||
'#REGION_POSITION_01# '||chr(10)||
'
#REGION_POSITION_02##REGION_POSITION_04##BOX_BODY# '||chr(10)||
'
#REGION_POSITION_03##REGION_POSITION_05#
'||chr(10)||
'
'||chr(10)||
'
#SUCCESS_MESSAGE#
#MESSAGE#
#MESSAGE# '||chr(10)||
'#RETURN_TO_APPLICATION# ',
p_reference_id=> 80966020820422852,
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
prompt ...button templates
--
--application/shared_components/user_interface/templates/button/a_button_login_page_only
prompt ......Button Template 20301506730451152
declare
t varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
t:=t||'#LABEL# ';
wwv_flow_api.create_button_templates (
p_id=>20301506730451152 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_template=>t,
p_template_name=> ' button login page only',
p_translate_this_template => 'N',
p_theme_id => 3,
p_theme_class_id => 0,
p_template_comment => ' ');
end;
/
---------------------------------------
prompt ...region templates
--
--application/shared_components/user_interface/templates/region/4999_report_region_c_htmldbrr
prompt ......region template 14581217810376673
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'#TITLE# #CLOSE# #EDIT##DELETE##CREATE##CREATE2# #PREVIOUS##NEXT# #BODY#
';
t2:=t2||'class="htmldbInstruct"';
wwv_flow_api.create_plug_template (
p_id => 14581217810376673 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> '4999, Report Region (c:htmldbRR) ',
p_plug_table_bgcolor => '#FFFFFF',
p_theme_id => 3,
p_theme_class_id => 9,
p_plug_heading_bgcolor => '#FFFFFF',
p_plug_font_size => '-1',
p_reference_id=> 17354512447599941,
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2:=t2||'class="htmldbInstruct"';
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 14581217810376673 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/gray_box_c_htmldbgbr_no_top_link
prompt ......region template 20998922571674600
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
''||chr(10)||
'#TITLE# '||chr(10)||
'#CLOSE# #EDIT##EXPAND##HELP##DELETE##COPY# '||chr(10)||
' '||chr(10)||
' '||chr(10)||
''||chr(10)||
''||chr(10)||
'#BODY# '||chr(10)||
' '||chr(10)||
''||chr(10)||
'#CREATE# '||chr(10)||
' '||chr(10)||
' '||chr(10)||
'
';
t2:=t2||' ';
wwv_flow_api.create_plug_template (
p_id => 20998922571674600 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Gray Box (c:htmldbGBR) (No Top Link)',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 0,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2:=t2||' ';
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 20998922571674600 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/login_region
prompt ......region template 21134717674904665
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
'#TITLE# '||chr(10)||
' '||chr(10)||
''||chr(10)||
'#BODY# '||chr(10)||
' '||chr(10)||
''||chr(10)||
'#CREATE# '||chr(10)||
' '||chr(10)||
'
';
t2:=t2||' ';
wwv_flow_api.create_plug_template (
p_id => 21134717674904665 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Login Region',
p_plug_table_bgcolor => '#F7F7E7',
p_theme_id => 3,
p_theme_class_id => 0,
p_plug_heading_bgcolor => '#F7F7E7',
p_plug_font_size => '-1',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2:=t2||' ';
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 21134717674904665 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/login_region_4550_1
prompt ......region template 21235720615514804
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'#TITLE# #BODY##CLOSE# #EDIT##DELETE##CREATE##CREATE2#
#P';
t:=t||'REVIOUS##NEXT#
';
t2:=t2||'class="instructiontext"';
wwv_flow_api.create_plug_template (
p_id => 21235720615514804 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Login Region (4550:1)',
p_plug_table_bgcolor => '#FFFFFF',
p_theme_id => 3,
p_theme_class_id => 0,
p_plug_heading_bgcolor => '#FFFFFF',
p_plug_font_size => '-1',
p_reference_id=> 21231024255484301,
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2:=t2||'class="instructiontext"';
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 21235720615514804 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/untitled_fixed_width_c_htmldbuntitledfixed_600_from_4999
prompt ......region template 61771527068337270
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'#BODY#
';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 61771527068337270 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Untitled Fixed Width (c:htmldbUntitledFixed) (600) From 4999',
p_plug_table_bgcolor => '',
p_theme_id => 0,
p_theme_class_id => 0,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_reference_id=> 73709023269539317,
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 61771527068337270 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/tasks_c_htmldbtasks_from_4999
prompt ......region template 155944222672692886
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'';
t2:=t2||' ';
wwv_flow_api.create_plug_template (
p_id => 155944222672692886 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Tasks (c:htmldbTasks) From 4999',
p_plug_table_bgcolor => '#F7F7E7',
p_theme_id => 3,
p_theme_class_id => 0,
p_plug_heading_bgcolor => '#F7F7E7',
p_plug_font_size => '-1',
p_reference_id=> 30436620668141833,
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2:=t2||' ';
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 155944222672692886 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/wizard_box_fail
prompt ......region template 164531513018211411
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'#TITLE# #CLOSE# #DELETE##EDIT##CHANGE##PREVIOUS##NEXT##CREATE# #BODY#
';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 164531513018211411 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Wizard Box (Fail)',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 12,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_reference_id=> 160023608986860686,
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 164531513018211411 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/wizard_box
prompt ......region template 249669128792384373
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'#TITLE# #CLOSE# #DELETE##EDIT##CHANGE##PREVIOUS##NEXT##CREATE# #BODY#
';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 249669128792384373 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Wizard Box',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 12,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_reference_id=> 18253116293565611,
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 249669128792384373 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/wizard_box_confirm
prompt ......region template 249669609896384376
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'#TITLE# #CLOSE# #DELETE##EDIT##CHANGE##PREVIOUS##NEXT##CREATE# #BODY#
';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 249669609896384376 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Wizard Box (Confirm)',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 12,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_reference_id=> 186682507972859454,
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 249669609896384376 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/report_region_600px_c_htmldbrr600_buttons_bottom
prompt ......region template 249678929399401352
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'#TITLE# #BODY# #CLOSE# #EDIT##DELETE##CREATE##CREATE2# #BODY#
';
t2:=t2||' ';
wwv_flow_api.create_plug_template (
p_id => 308969701495595527 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Instructions 600px c:(htmldbInstruct600) From 4999',
p_plug_table_bgcolor => '#FFFFFF',
p_theme_id => 3,
p_theme_class_id => 0,
p_plug_heading_bgcolor => '#FFFFFF',
p_plug_font_size => '-1',
p_reference_id=> 354966506413573024,
p_translate_this_template => 'N',
p_template_comment => 'No region formatting');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2:=t2||' ';
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 308969701495595527 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
prompt ...List Templates
--
--application/shared_components/user_interface/templates/list/unordered_list
prompt ......list template 85971030932131423
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'#TEXT# #TEXT# ',
p_list_template_after_rows=>' ',
p_reference_id=>60219508156141083,
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
prompt ...report templates
--
--application/shared_components/user_interface/templates/report/quick_pick_c_htmldbquickpick_li_from_4999
prompt ......report template 59856615437669702
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'#COLUMN_VALUE# ';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 59856615437669702 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'Quick Pick (c:htmldbQuickPick) (li) from 4999',
p_row_template1=> c1,
p_row_template_condition1=> '',
p_row_template2=> c2,
p_row_template_condition2=> '',
p_row_template3=> c3,
p_row_template_condition3=> '',
p_row_template4=> c4,
p_row_template_condition4=> '',
p_row_template_before_rows=>'',
p_row_template_after_rows =>' ',
p_row_template_table_attr =>'OMIT',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'OMIT',
p_row_template_display_cond1=>'NOT_CONDITIONAL',
p_row_template_display_cond2=>'NOT_CONDITIONAL',
p_row_template_display_cond3=>'NOT_CONDITIONAL',
p_row_template_display_cond4=>'NOT_CONDITIONAL',
p_theme_id => 0,
p_theme_class_id => 0,
p_reference_id=> 17383712077884846,
p_translate_this_template => 'N',
p_row_template_comment=> '');
end;
null;
end;
/
begin
begin
wwv_flow_api.create_row_template_patch (
p_id => 59856615437669702 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'OMIT',
p_row_template_after_last =>'OMIT');
exception when others then null;
end;
null;
end;
/
prompt ...label templates
--
--application/shared_components/user_interface/templates/label/htmldb_greenarealabel
prompt ......label template 9107221009165036
begin
begin
wwv_flow_api.create_field_template (
p_id=> 9107221009165036 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'htmldb_GreenAreaLabel',
p_template_body1=>'',
p_template_body2=>' ',
p_template_body2=>' ',
p_page_footer_text =>'
Row(s) #FIRST_ROW# - #LAST_ROW#
',
p_result_rows_per_pg=>200,
p_before_result_set=>'',
p_theme_id => 3,
p_theme_class_id => 1,
p_reference_id => 17343114994581872,
p_translate_this_template => 'N',
p_after_result_set =>'
');
end;
null;
end;
/
prompt ...calendar templates
--
prompt ...application themes
--
--application/shared_components/user_interface/themes/green_2_0
prompt ......theme 75129413870047038
begin
wwv_flow_api.create_theme (
p_id =>75129413870047038 + wwv_flow_api.g_id_offset,
p_flow_id =>wwv_flow.g_flow_id,
p_theme_id => 3,
p_theme_name=>'Green 2.0',
p_default_page_template=>9095301378087765 + wwv_flow_api.g_id_offset,
p_error_template=>60929357198712420 + wwv_flow_api.g_id_offset,
p_printer_friendly_template=>60929357198712420 + wwv_flow_api.g_id_offset,
p_breadcrumb_display_point=>'',
p_sidebar_display_point=>'',
p_login_template=>null + wwv_flow_api.g_id_offset,
p_default_button_template=>null + wwv_flow_api.g_id_offset,
p_default_region_template=>null + wwv_flow_api.g_id_offset,
p_default_chart_template =>null + wwv_flow_api.g_id_offset,
p_default_form_template =>null + wwv_flow_api.g_id_offset,
p_default_reportr_template => null,
p_default_tabform_template=>null + wwv_flow_api.g_id_offset,
p_default_wizard_template=>null + wwv_flow_api.g_id_offset,
p_default_menur_template=>null + wwv_flow_api.g_id_offset,
p_default_listr_template=>null + wwv_flow_api.g_id_offset,
p_default_report_template => null,
p_default_label_template=>null + wwv_flow_api.g_id_offset,
p_default_menu_template=>null + wwv_flow_api.g_id_offset,
p_default_calendar_template=>null + wwv_flow_api.g_id_offset,
p_default_list_template=>null + wwv_flow_api.g_id_offset,
p_default_option_label=>null + wwv_flow_api.g_id_offset,
p_default_required_label=>null + wwv_flow_api.g_id_offset);
end;
/
prompt ...build options used by application 4550
--
begin
--application/shared_components/logic/build_options/xe
wwv_flow_api.create_build_option (
p_id=> 9152708051846605 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_build_option_name=> 'XE',
p_build_option_status=> 'EXCLUDE',
p_build_option_comment=> '');
end;
/
--application/shared_components/globalization/messages
prompt ...messages used by application: 4550
--
--application/shared_components/globalization/dyntranslations
prompt ...dynamic translations used by application: 4550
--
--application/shared_components/globalization/language
prompt ...Language Maps for Application 4550
--
begin
wwv_flow_api.create_language_map(
p_id => 72247424865976156 + wwv_flow_api.g_id_offset,
p_primary_language_flow_id => 4550,
p_translation_flow_id => 4551,
p_translation_flow_language_cd=> 'es',
p_translation_image_directory => '',
p_translation_comments => 'Development Service Login - Spanish');
wwv_flow_api.create_language_map(
p_id => 72247515181976156 + wwv_flow_api.g_id_offset,
p_primary_language_flow_id => 4550,
p_translation_flow_id => 4552,
p_translation_flow_language_cd=> 'fr',
p_translation_image_directory => '',
p_translation_comments => 'Development Service Login - French');
wwv_flow_api.create_language_map(
p_id => 72247626970976156 + wwv_flow_api.g_id_offset,
p_primary_language_flow_id => 4550,
p_translation_flow_id => 4553,
p_translation_flow_language_cd=> 'de',
p_translation_image_directory => '',
p_translation_comments => 'Development Service Login - German');
wwv_flow_api.create_language_map(
p_id => 72247714631976157 + wwv_flow_api.g_id_offset,
p_primary_language_flow_id => 4550,
p_translation_flow_id => 4554,
p_translation_flow_language_cd=> 'it',
p_translation_image_directory => '',
p_translation_comments => 'Development Service Login - Italian');
wwv_flow_api.create_language_map(
p_id => 72247823189976157 + wwv_flow_api.g_id_offset,
p_primary_language_flow_id => 4550,
p_translation_flow_id => 4555,
p_translation_flow_language_cd=> 'pt-br',
p_translation_image_directory => '',
p_translation_comments => 'Development Service Login - Brazilian Portugese');
wwv_flow_api.create_language_map(
p_id => 72247920708976157 + wwv_flow_api.g_id_offset,
p_primary_language_flow_id => 4550,
p_translation_flow_id => 4556,
p_translation_flow_language_cd=> 'zh-cn',
p_translation_image_directory => '',
p_translation_comments => 'Development Service Login - Simplified Chinese');
wwv_flow_api.create_language_map(
p_id => 72248005893976157 + wwv_flow_api.g_id_offset,
p_primary_language_flow_id => 4550,
p_translation_flow_id => 4557,
p_translation_flow_language_cd=> 'zh-tw',
p_translation_image_directory => '',
p_translation_comments => 'Development Service Login - Traditional Chinese');
wwv_flow_api.create_language_map(
p_id => 72248123976976157 + wwv_flow_api.g_id_offset,
p_primary_language_flow_id => 4550,
p_translation_flow_id => 4558,
p_translation_flow_language_cd=> 'ko',
p_translation_image_directory => '',
p_translation_comments => 'Development Service Login - Korean');
wwv_flow_api.create_language_map(
p_id => 72248208931976157 + wwv_flow_api.g_id_offset,
p_primary_language_flow_id => 4550,
p_translation_flow_id => 4559,
p_translation_flow_language_cd=> 'ja',
p_translation_image_directory => '',
p_translation_comments => 'Development Service Login - Japanese');
end;
/
prompt ...Shortcuts
--
--application/shared_components/user_interface/shortcuts/thedate
begin
declare
c1 varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
c1:=c1||'return to_char(sysdate, ''MM.DD.YYYY'')';
wwv_flow_api.create_shortcut (
p_id=> 174421670078 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_shortcut_name=> 'THEDATE',
p_shortcut_type=> 'FUNCTION_BODY',
p_shortcut=> c1);
end;
null;
end;
/
--application/shared_components/user_interface/shortcuts/item_help
begin
declare
c1 varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
c1:=c1||'
#SUCCESS_MESSAGE#
#P';
t:=t||'REVIOUS##NEXT#
';
wwv_flow_api.create_shortcut (
p_id=> 14805026971629745 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_shortcut_name=> 'ITEM_HELP',
p_shortcut_type=> 'HTML_TEXT',
p_error_text=> 'Unable to show help.',
p_reference_id=> 24184979678,
p_shortcut=> c1);
end;
null;
end;
/
--application/shared_components/user_interface/shortcuts/welcometext
begin
declare
c1 varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
c1:=c1||'Gain instant access to an integrated online application development suite. With &PRODUCT_NAME. you can build robust dynamic web applications and leverage the full power of the Oracle database all from your favorite browser.';
wwv_flow_api.create_shortcut (
p_id=> 47306820184100081 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_shortcut_name=> 'WELCOMETEXT',
p_shortcut_type=> 'HTML_TEXT',
p_shortcut=> c1);
end;
null;
end;
/
prompt ...web services (9iR2 or better)
--
prompt ...shared queries
--
prompt ...report layouts
--
prompt ...authentication schemes
--
--application/shared_components/security/authentication/internal_4550
prompt ......scheme 487415230967122
begin
declare
s1 varchar2(32767) := null;
s2 varchar2(32767) := null;
s3 varchar2(32767) := null;
s4 varchar2(32767) := null;
s5 varchar2(32767) := null;
begin
s1:=s1||'return wwv_flow_security.internal_page_sentry;';
s2 := null;
s3 := null;
s4:=s4||'-BUILTIN-';
s5:=s5||'owa_cookie.send('||chr(10)||
' name=>''ORA_WWV_REMEMBER_UN'','||chr(10)||
' value=>upper(:F4550_P1_USERNAME)||'':''||:F4550_P1_COMPANY,'||chr(10)||
' expires=> sysdate+180,'||chr(10)||
' path=> owa_util.get_cgi_env(''SCRIPT_NAME''));';
wwv_flow_api.create_auth_setup (
p_id=> 487415230967122 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> '$INTERNAL-4550$',
p_description=>'Scheme for internal application 4550 using custom Login Page and account credentials verification',
p_page_sentry_function=> s1,
p_sess_verify_function=> s2,
p_pre_auth_process=> s3,
p_auth_function=> s4,
p_post_auth_process=> s5,
p_invalid_session_page=>'1',
p_invalid_session_url=>'',
p_cookie_name=>'ORA_WWV_USER',
p_cookie_path=>'&CGI_SCRIPT_NAME.',
p_cookie_domain=>'',
p_use_secure_cookie_yn=>'',
p_ldap_host=>'',
p_ldap_port=>'',
p_ldap_string=>'',
p_attribute_01=>'',
p_attribute_02=>'wwv_flow_custom_auth_std.logout?p_this_flow=&FLOW_ID.&p_next_flow_page_sess=4550:8:&SESSION.',
p_attribute_03=>'',
p_attribute_04=>'',
p_attribute_05=>'',
p_attribute_06=>'',
p_attribute_07=>'',
p_attribute_08=>'',
p_required_patch=>'');
end;
null;
end;
/
--application/end_environment
commit;
commit;
begin
execute immediate 'alter session set nls_numeric_characters='''||wwv_flow_api.g_nls_numeric_chars||'''';
end;
/
set verify on
set feedback on
prompt ...done