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 4700 - APEX - New Service Signup -- -- Application Export: -- Application: 4700 -- Name: APEX - New Service Signup -- 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: 20 -- Computations: 3 -- Validations: 22 -- Processes: 2 -- Regions: 18 -- Buttons: 24 -- Shared Components -- Breadcrumbs: 0 -- Entries 0 -- Items: 2 -- Computations: 1 -- Processes: 0 -- Parent Tabs: 1 -- Tab Sets: 1 -- Tabs: 1 -- NavBars: 0 -- Lists: 2 -- Shortcuts: 1 -- Themes: 1 -- Templates: -- Page: 3 -- List: 3 -- Report: 0 -- Label: 2 -- Region: 3 -- 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 := 4700; wwv_flow_api.g_id_offset := 0; null; end; / --application/delete_application begin -- Remove Application wwv_flow_api.remove_flow(4700); end; / begin wwv_flow_audit.remove_audit_trail(4700); null; end; / --application/create_application begin wwv_flow_api.create_flow( p_id => 4700, p_display_id=> 4700, p_owner => 'APEX_030200', p_name => 'APEX - New Service Signup', p_alias => 'NEW_SERVICE', 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=> 108132430112395957 + wwv_flow_api.g_id_offset, p_printer_friendly_template=> 4674102852 + wwv_flow_api.g_id_offset, p_default_region_template=> 4688102857 + wwv_flow_api.g_id_offset, p_error_template => 108132430112395957 + wwv_flow_api.g_id_offset, p_charset => 'utf-8', p_checksum_salt_last_reset => '20090519073429', p_max_session_length_sec=> 28800, p_home_link => 'f?p=4700:10:&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 => '', 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(108165525079033088 + wwv_flow_api.g_id_offset)||'.', p_cust_authentication_page=> '', p_custom_auth_login_url=> '', p_flow_version => '&PRODUCT_NAME. 3.2.1.00.08', 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=> 'Y', p_vpd => '', p_csv_encoding => 'Y', p_theme_id => 3, p_default_label_template => 187206412134572319 + wwv_flow_api.g_id_offset, p_default_list_template => 4794278052 + wwv_flow_api.g_id_offset, p_substitution_string_01 => 'PRODUCT_NAME', p_substitution_value_01 => 'Application Express', p_substitution_string_02 => 'DONE', p_substitution_value_02 => 'Done', p_substitution_string_03 => 'MSG_COMPANY', p_substitution_value_03 => 'Workspace: &COMPANY.', p_substitution_string_04 => 'CLOSE', p_substitution_value_04 => 'Close', p_substitution_string_05 => 'DATE_FORMAT', p_substitution_value_05 => 'mm/dd/yyyy', p_substitution_string_06 => 'LONG_DATE_FORMAT', p_substitution_value_06 => 'fmDay, Month dd, yyyy', p_substitution_string_07 => 'TIME_FORMAT', p_substitution_value_07 => 'hh:mi:ss AM', p_substitution_string_08 => 'DATE_TIME_FORMAT', p_substitution_value_08 => 'mm/dd/yyyy hh:mi:ss AM', p_substitution_string_09 => 'RETURN_TO_APPLICATION', p_substitution_value_09 => 'Return to Application', p_substitution_string_10 => 'MSG_LANGUAGE', p_substitution_value_10 => 'Language', p_last_updated_by => '', p_last_upd_yyyymmddhh24miss=> '20090518133144', 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/f4700_req_new_schema begin wwv_flow_api.create_flow_item( p_id=> 103247625354177724 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'F4700_REQ_NEW_SCHEMA', p_data_type=> 'VARCHAR', p_is_persistent=> 'Y', p_protection_level=> 'N', p_required_patch=> null + wwv_flow_api.g_id_offset, p_item_comment=> ''); null; end; / --application/shared_components/logic/application_items/help_page begin wwv_flow_api.create_flow_item( p_id=> 318946157429 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'HELP_PAGE', p_data_type=> 'VARCHAR', p_is_persistent=> 'Y', p_protection_level=> '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_item_comment=> 'flow page that you would like help for.'); null; end; / prompt ...application level computations -- begin --application/shared_components/logic/application_computations/f4700_req_new_schema wwv_flow_api.create_flow_computation ( p_id => 103248202067189926 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_computation_sequence => 10, p_computation_item => 'F4700_REQ_NEW_SCHEMA', p_computation_point => 'ON_NEW_INSTANCE', p_computation_type => 'FUNCTION_BODY', p_computation_processed=> 'REPLACE_EXISTING', p_computation => 'declare l_schema_status varchar2(255) := null;'||chr(10)|| 'begin'||chr(10)|| 'l_schema_status := wwv_flow_platform.get_preference(''REQ_NEW_SCHEMA'');'||chr(10)|| 'return l_schema_status;'||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 --application/shared_components/navigation/tabs/standard/t_home wwv_flow_api.create_tab ( p_id=> 11449918469894500 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'HOME', p_tab_sequence=> 10, p_tab_name=> 'T_HOME', p_tab_text => 'Request Service', p_tab_step => 10, p_tab_also_current_for_pages => '20,25,40,1,27,30', p_tab_parent_tabset=>'TOP', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment => ''); end; / prompt ...Application Parent Tabs -- begin --application/shared_components/navigation/tabs/parent/t_top wwv_flow_api.create_toplevel_tab ( p_id=> 11450003334894502 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'TOP', p_tab_sequence=> 20, p_tab_name => 'T_TOP', p_tab_text => '&PRODUCT_NAME.', p_tab_target=> 'f?p=4700:10:&SESSION.:', p_current_on_tabset=> 'HOME', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment=> ''); end; / prompt ...Shared Lists of values -- --application/shared_components/user_interface/lov/new_or_existing_schema begin wwv_flow_api.create_list_of_values ( p_id => 150771414457811401 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_lov_name => 'NEW_OR_EXISTING_SCHEMA', p_lov_query=> '.'||to_char(150771414457811401 + wwv_flow_api.g_id_offset)||'.'); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>150771702466811402 + wwv_flow_api.g_id_offset, p_lov_id=>150771414457811401 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>1, p_lov_disp_value=>'Use an existing schema from the database', p_lov_return_value=>'NO', p_lov_data_comment=> ''); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>150771902162811402 + wwv_flow_api.g_id_offset, p_lov_id=>150771414457811401 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>2, p_lov_disp_value=>'Request a new schema', p_lov_return_value=>'YES', p_lov_data_comment=> ''); null; end; / prompt ...Application Trees -- --application/pages/page_groups prompt ...page groups -- begin null; end; / --application/pages/page_00001 prompt ...PAGE 1: Request Workspace - First Page -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 1, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'HOME', p_name => 'Request Workspace - First Page', p_step_title=> 'Request 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=> 'N', p_page_comment => ''); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'Welcome to &PRODUCT_NAME. Registration. Please complete this request form to gain access to &PRODUCT_NAME.. After the request has been reviewed by the &PRODUCT_NAME. site administrator, your account password or other status information will be sent to you in an email.'; wwv_flow_api.create_page_plug ( p_id=> 11481918919027098 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_plug_name=> '&PRODUCT_NAME. Registration', p_region_name=>'', p_plug_template=> 4688102857+ 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=> '', 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 := null; wwv_flow_api.create_page_plug ( p_id=> 60576931321681806 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_plug_name=> 'Navigation', p_region_name=>'', p_plug_template=> 0, p_plug_display_sequence=> 20, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 4762183464 + 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 => '', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / begin wwv_flow_api.create_page_button( p_id => 11484024561036668 + 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 => 11481918919027098+wwv_flow_api.g_id_offset, p_button_name => 'QUIT', p_button_image_alt=> 'Cancel', p_button_position=> 'REGION_TEMPLATE_CLOSE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=4550:1', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 11483819050036659 + 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 => 11481918919027098+wwv_flow_api.g_id_offset, p_button_name => 'NEXT', p_button_image_alt=> 'Next >', p_button_position=> 'REGION_TEMPLATE_NEXT', 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=>66683221933097168 + 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.:10:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_when_button_id=>11483819050036659+ wwv_flow_api.g_id_offset, p_branch_sequence=> 10, p_save_state_before_branch_yn=>'N', p_branch_comment=> 'Created 19-JAN-2007 16:08 by SBKENNED'); end; / begin --------------------------------------- -- ...updatable report columns for page 1 -- begin null; end; null; end; / --application/pages/page_00003 prompt ...PAGE 3: Request Workspace - Confirmation -- 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 => 'Request Workspace - Confirmation', p_step_title=> 'Request Workspace', p_step_sub_title => '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 => '', 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=> '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=> 60540130725446991 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 3, p_plug_name=> 'Navigation', p_region_name=>'', p_plug_template=> 0, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 4762183464 + 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 => '', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'60555613032506142'; wwv_flow_api.create_page_plug ( p_id=> 60559100827521617 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 3, p_plug_name=> 'Confirmation', p_region_name=>'', p_plug_template=> 60551104085502857+ 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=> 60555613032506142 + 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 null; end; / begin null; end; / begin wwv_flow_api.create_page_validation( p_id => 60542102714447006 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 3, p_validation_name => 'Verification code', p_validation_sequence=> 10, p_validation => 'begin'||chr(10)|| 'for c1 in'||chr(10)|| ' (select * from wwv_flow_request_verifications'||chr(10)|| 'where session_id = :APP_SESSION) loop'||chr(10)|| ' if c1.verification_string = :P3_verification_code then'||chr(10)|| ' return true;'||chr(10)|| ' else '||chr(10)|| ' return false;'||chr(10)|| ' end if;'||chr(10)|| 'end loop;'||chr(10)|| 'return false;'||chr(10)|| 'end;', p_validation_type => 'FUNC_BODY_RETURNING_BOOLEAN', p_error_message => 'Invalid Verification Code', p_associated_item=> 60541510567447001 + wwv_flow_api.g_id_offset, p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION', p_validation_comment=> ''); null; end; / begin --------------------------------------- -- ...updatable report columns for page 3 -- begin null; end; null; end; / --application/pages/page_00010 prompt ...PAGE 10: Request Workspace - Administrator -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 10, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'HOME', p_name => 'Request Workspace - Administrator', p_step_title=> 'Request 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=> '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=> 303415113933 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 10, p_plug_name=> 'Navigation', p_region_name=>'', p_plug_template=> 0, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 4762183464 + wwv_flow_api.g_id_offset, p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'COLON_DELMITED_LIST', p_plug_query_row_count_max => 500, p_plug_column_width => 'nowrap="nowrap"', 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=> 317861684012 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 10, p_plug_name=> '&PRODUCT_NAME. Registration', p_region_name=>'', p_plug_template=> 4688102857+ 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=> '

Please identify the administrator who will manage the requested service. Once the request is approved, the administrator will have the privilege to set up other administrators and developers.

', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / begin wwv_flow_api.create_page_button( p_id => 318063805793 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 10, p_button_sequence=> 1, p_button_plug_id => 317861684012+wwv_flow_api.g_id_offset, p_button_name => 'Cancel', p_button_image_alt=> 'Cancel', p_button_position=> 'REGION_TEMPLATE_CLOSE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=4550:1', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 317910858512 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 10, p_button_sequence=> 10, p_button_plug_id => 317861684012+wwv_flow_api.g_id_offset, p_button_name => 'Proceed', p_button_image_alt=> 'Next >', p_button_position=> 'REGION_TEMPLATE_NEXT', 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 => 60582700331710649 + 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 => 317861684012+wwv_flow_api.g_id_offset, p_button_name => 'Back', p_button_image_alt=> '< Previous', p_button_position=> 'REGION_TEMPLATE_PREVIOUS', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=&APP_ID.:1:&SESSION.::&DEBUG.:::', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>66684507519102505 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 10, p_branch_action=> 'f?p=&APP_ID.:20:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_when_button_id=>317910858512+ wwv_flow_api.g_id_offset, p_branch_sequence=> 10, p_save_state_before_branch_yn=>'N', p_branch_comment=> 'Created 19-JAN-2007 16:09 by SBKENNED'); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'Enter the first name of the administrative user who will be managing this service. This need only be the initial admininstrator, you can change the primary administrative contact at any time.'; wwv_flow_api.create_page_item( p_id=>317887807410 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 10, p_name=>'ADMIN_FIRST_NAME', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 317861684012+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'First Name', 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 => 187206506383572320+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||'Enter the last name of the administrative user who will be managing this service. This need only be the initial admininstrator, you can change the primary administrative contact at any time.'; wwv_flow_api.create_page_item( p_id=>317891809893 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 10, p_name=>'ADMIN_LAST_NAME', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 30, p_item_plug_id => 317861684012+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Last Name', 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 => 187206506383572320+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||'Enter the email address of the administrative user who will be managing this service. This email account will be sent the initial login information. This need only be the initial admininstrator, you can change the primary administrative contact at any time.'; wwv_flow_api.create_page_item( p_id=>317897816033 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 10, p_name=>'ADMIN_EMAIL', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 50, p_item_plug_id => 317861684012+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Email', 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 => 187206506383572320+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=>172161311548860690 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 10, p_name=>'P10_EMAIL_NOTE', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 60, p_item_plug_id => 317861684012+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'NO', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source=>'wwv_flow_lang.system_message(''F4700.EMAIL_NOTE'')', p_source_type=> 'FUNCTION', p_display_as=> 'DISPLAY_ONLY_ESCAPE_SC', 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 => 187206412134572319+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_item_comment => ''); end; / begin wwv_flow_api.create_page_validation( p_id => 85897954908 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 10, p_validation_name => 'ADMIN_EMAIL Not Null', p_validation_sequence=> 1, p_validation => 'ADMIN_EMAIL', p_validation_type => 'ITEM_NOT_NULL', p_error_message => 'Email must be specified.', p_associated_item=> 317897816033 + wwv_flow_api.g_id_offset, p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION', p_validation_comment=> 'generated 21-FEB-2001 19:21'); null; end; / begin wwv_flow_api.create_page_validation( p_id => 85893949306 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 10, p_validation_name => 'ADMIN_FIRST_NAME Not Null', p_validation_sequence=> 2, p_validation => 'ADMIN_FIRST_NAME', p_validation_type => 'ITEM_NOT_NULL', p_error_message => 'First Name must be specified.', p_associated_item=> 317887807410 + wwv_flow_api.g_id_offset, p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION', p_validation_comment=> 'generated 21-FEB-2001 19:20'); null; end; / begin wwv_flow_api.create_page_validation( p_id => 85895949307 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 10, p_validation_name => 'ADMIN_LAST_NAME Not Null', p_validation_sequence=> 3, p_validation => 'ADMIN_LAST_NAME', p_validation_type => 'ITEM_NOT_NULL', p_error_message => 'Last Name must be specified.', p_associated_item=> 317891809893 + wwv_flow_api.g_id_offset, p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION', p_validation_comment=> 'generated 21-FEB-2001 19:20'); null; end; / begin wwv_flow_api.create_page_validation( p_id => 200716226993770297 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 10, p_validation_name => 'ADMIN_EMAIL must be valid', p_validation_sequence=> 13, p_validation => 'declare'||chr(10)|| ' l_at number;'||chr(10)|| ' l_dot number;'||chr(10)|| 'begin'||chr(10)|| ' l_at := instr(nvl(:ADMIN_EMAIL,''x''),''@'');'||chr(10)|| ' l_dot := instr(nvl(:ADMIN_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 => 'Invalid email address.', p_validation_condition=> 'ADMIN_EMAIL', p_validation_condition_type=> 'ITEM_IS_NOT_NULL', p_when_button_pressed=> 317910858512 + wwv_flow_api.g_id_offset, p_associated_item=> 317897816033 + 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 => 82851232592633865 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 10, p_validation_name => 'ADMIN_EMAIL contains no spaces', p_validation_sequence=> 23, p_validation => 'ADMIN_EMAIL', p_validation_type => 'ITEM_CONTAINS_NO_SPACES', p_error_message => 'Email address must not contain spaces', p_validation_condition=> 'ADMIN_EMAIL', p_validation_condition_type=> 'ITEM_IS_NOT_NULL', p_when_button_pressed=> 317910858512 + wwv_flow_api.g_id_offset, p_associated_item=> 317897816033 + wwv_flow_api.g_id_offset, p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION', p_validation_comment=> ''); null; end; / begin --------------------------------------- -- ...updatable report columns for page 10 -- begin null; end; null; end; / --application/pages/page_00020 prompt ...PAGE 20: Request Workspace - Workspace -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 20, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'HOME', p_name => 'Request Workspace - Workspace', p_step_title=> 'Request 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 => 'RAJU', p_last_upd_yyyymmddhh24miss => '20071121232253', 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=> 318018076313 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 20, p_plug_name=> 'Navigation', p_region_name=>'', p_plug_template=> 0, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 4762183464 + 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 => '', 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=> 318020076313 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 20, p_plug_name=> '&PRODUCT_NAME. Registration', p_region_name=>'', p_plug_template=> 4688102857+ 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=> '

Please enter the workspace name you would like to have. When your service is approved, you will login using a workspace / username / password combination.

', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / begin wwv_flow_api.create_page_button( p_id => 318069824396 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 20, p_button_sequence=> 1, p_button_plug_id => 318020076313+wwv_flow_api.g_id_offset, p_button_name => 'Cancel', p_button_image_alt=> 'Cancel', p_button_position=> 'REGION_TEMPLATE_CLOSE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=4550:1', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 318000076307 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 20, p_button_sequence=> 10, p_button_plug_id => 318020076313+wwv_flow_api.g_id_offset, p_button_name => 'Proceed', p_button_image_alt=> 'Next >', p_button_position=> 'REGION_TEMPLATE_NEXT', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 4897434514 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 20, p_button_sequence=> 5, p_button_plug_id => 318020076313+wwv_flow_api.g_id_offset, p_button_name => 'Back', p_button_image_alt=> '< Previous', p_button_position=> 'REGION_TEMPLATE_PREVIOUS', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=&APP_ID.:10:&SESSION.::&DEBUG.:::', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>103266820730242631 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 20, p_branch_action=> 'f?p=&APP_ID.:25:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_when_button_id=>318000076307+ wwv_flow_api.g_id_offset, p_branch_sequence=> 5, p_branch_condition_type=> 'VAL_OF_ITEM_IN_COND_EQ_COND2', p_branch_condition=> 'F4700_REQ_NEW_SCHEMA', p_branch_condition_text=>'Y', p_save_state_before_branch_yn=>'N', p_branch_comment=> 'Created 13-NOV-2007 01:44 by RAJU'); wwv_flow_api.create_page_branch( p_id=>66686503841110936 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 20, p_branch_action=> 'f?p=&APP_ID.:40:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_sequence=> 10, p_save_state_before_branch_yn=>'N', p_branch_comment=> 'Created 19-JAN-2007 16:10 by SBKENNED'); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'Enter the workspace name you would like to have. When your service is provisioned, you will login using a workspace / username / password combination.'||chr(10)|| ''||chr(10)|| 'A workspace is a virtual area in the database where a team of developers can work on multiple applications. A workspace may have privileges in one or more schemas.'; wwv_flow_api.create_page_item( p_id=>11425313649770094 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 20, p_name=>'COMPANY_NAME', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 1, p_item_plug_id => 318020076313+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=> 'ALWAYS_NULL', p_display_as=> 'TEXT_WITH_ENTER_SUBMIT', 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 => 187206506383572320+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_computation( p_id=> 103266130295235904 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 20, p_computation_sequence => 10, p_computation_item=> 'NEW_SCHEMA', p_computation_point=> 'AFTER_SUBMIT', p_computation_type=> 'STATIC_ASSIGNMENT', p_computation_processed=> 'REPLACE_EXISTING', p_computation=> 'YES', p_compute_when => 'F4700_REQ_NEW_SCHEMA', p_compute_when_text=>'Y', p_compute_when_type=>'VAL_OF_ITEM_IN_COND_EQ_COND2'); null; end; / begin wwv_flow_api.create_page_validation( p_id => 11428213434779559 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 20, p_validation_name => 'COMPANY_NAME Not Null', p_validation_sequence=> 1, p_validation => 'COMPANY_NAME', p_validation_type => 'ITEM_NOT_NULL', p_error_message => 'Workspace must be specified.', p_associated_item=> 11425313649770094 + wwv_flow_api.g_id_offset, p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION', p_validation_comment=> 'generated 12-DEC-2002 18:18'); null; end; / begin wwv_flow_api.create_page_validation( p_id => 16917802136315321 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 20, p_validation_name => 'company doesn''t already exist', p_validation_sequence=> 10, p_validation => 'for c1 in (select null'||chr(10)|| ' from wwv_flow_provision_company'||chr(10)|| ' where company_name = upper(:COMPANY_NAME)) loop'||chr(10)|| ' return false;'||chr(10)|| ' exit;'||chr(10)|| 'end loop;'||chr(10)|| 'for c1 in (select null'||chr(10)|| ' from wwv_flow_companies'||chr(10)|| ' where short_name = upper(:COMPANY_NAME) ) loop'||chr(10)|| ' return false;'||chr(10)|| ' exit;'||chr(10)|| 'end loop;'||chr(10)|| ''||chr(10)|| 'return true;', p_validation_type => 'FUNC_BODY_RETURNING_BOOLEAN', p_error_message => 'A workspace named &COMPANY_NAME. already exists.', p_associated_item=> 11425313649770094 + 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 => 111462914137977065 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 20, p_validation_name => 'Invalid characters in workspace name', p_validation_sequence=> 20, p_validation => 'COMPANY_NAME', p_validation2 => '<>', p_validation_type => 'ITEM_IN_VALIDATION_CONTAINS_NO_CHAR_IN_STRING2', p_error_message => 'Invalid workspace name.', p_when_button_pressed=> 318000076307 + wwv_flow_api.g_id_offset, p_associated_item=> 11425313649770094 + wwv_flow_api.g_id_offset, p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION', p_validation_comment=> ''); null; end; / begin --------------------------------------- -- ...updatable report columns for page 20 -- begin null; end; null; end; / --application/pages/page_00025 prompt ...PAGE 25: Request Workspace - Identify Schema -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 25, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'HOME', p_name => 'Request Workspace - Identify Schema', p_step_title=> 'Request 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 => 'JASON', p_last_upd_yyyymmddhh24miss => '20071207075206', 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=> 4861831036 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 25, p_plug_name=> 'Navigation', p_region_name=>'', p_plug_template=> 0, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 4762183464 + 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 => '', 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=> 4863831037 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 25, p_plug_name=> '&PRODUCT_NAME. Registration', p_region_name=>'', p_plug_template=> 4688102857+ 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; / begin wwv_flow_api.create_page_button( p_id => 4839831015 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_button_sequence=> 1, p_button_plug_id => 4863831037+wwv_flow_api.g_id_offset, p_button_name => 'Cancel', p_button_image_alt=> 'Cancel', p_button_position=> 'REGION_TEMPLATE_CLOSE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=4550:1', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 4841831018 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_button_sequence=> 10, p_button_plug_id => 4863831037+wwv_flow_api.g_id_offset, p_button_name => 'Proceed', p_button_image_alt=> 'Next >', p_button_position=> 'REGION_TEMPLATE_NEXT', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 103271221441394134 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_button_sequence=> 3, p_button_plug_id => 4863831037+wwv_flow_api.g_id_offset, p_button_name => 'BACK', p_button_image_alt=> '< Previous', p_button_position=> 'REGION_TEMPLATE_PREVIOUS', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=&APP_ID.:20:&SESSION.::&DEBUG.:::', p_button_condition=> 'F4700_REQ_NEW_SCHEMA', p_button_condition2=> 'Y', p_button_condition_type=> 'VAL_OF_ITEM_IN_COND_EQ_COND2', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 4893430263 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_button_sequence=> 5, p_button_plug_id => 4863831037+wwv_flow_api.g_id_offset, p_button_name => 'Back', p_button_image_alt=> '< Previous', p_button_position=> 'REGION_TEMPLATE_PREVIOUS', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=&APP_ID.:40:&SESSION.::&DEBUG.:::', p_button_condition=> 'F4700_REQ_NEW_SCHEMA', p_button_condition2=> 'Y', p_button_condition_type=> 'VAL_OF_ITEM_IN_COND_NOT_EQ_COND2', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>177096326383922599 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 25, p_branch_action=> 'f?p=&APP_ID.:26:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_when_button_id=>4841831018+ wwv_flow_api.g_id_offset, p_branch_sequence=> 10, p_branch_condition_type=> 'FUNCTION_BODY', p_branch_condition=> 'if :NEW_SCHEMA = ''YES'' then'||chr(10)|| ' return false;'||chr(10)|| 'else'||chr(10)|| ' for c1 in (select 1 from dual where'||chr(10)|| ' wwv_flow_provisioning.restricted_schema_i(:P25_SCHEMA,:COMPANY_NAME) = ''1'''||chr(10)|| 'union all '||chr(10)|| 'select 1 from wwv_flow_company_schemas where schema = :P25_SCHEMA) loop'||chr(10)|| ' return true;'||chr(10)|| ' end loop;'||chr(10)|| ' return false;'||chr(10)|| 'end if;', p_save_state_before_branch_yn=>'N', p_branch_comment=> 'Created 27-APR-2005 05:12 by SSPADAFO'); wwv_flow_api.create_page_branch( p_id=>66700008567178536 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 25, p_branch_action=> 'f?p=&APP_ID.:27:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_sequence=> 20, p_save_state_before_branch_yn=>'N', p_branch_comment=> 'Created 19-JAN-2007 16:21 by SBKENNED'); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'Select the amount of disk space you will require. Once your schema is created, you can request additional space if necessary.'; wwv_flow_api.create_page_item( p_id=>4849831028 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 25, p_name=>'DATABASE_SIZE', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 4863831037+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default => 'declare'||chr(10)|| ' l_default number;'||chr(10)|| 'begin'||chr(10)|| ' for c1 in (select req_size'||chr(10)|| ' from wwv_flow_workspace_req_size'||chr(10)|| ' where request_type = ''N'''||chr(10)|| ' and default_size = ''Y'') loop'||chr(10)|| ' l_default := c1.req_size;'||chr(10)|| ' exit;'||chr(10)|| ' end loop;'||chr(10)|| ' return l_default;'||chr(10)|| 'end;', p_item_default_type => 'PLSQL_FUNCTION_BODY', p_prompt=>'Initial Space Allocation (MB):', p_source_type=> 'STATIC', p_display_as=> 'COMBOBOX', p_lov => 'select req_size d, req_size r'||chr(10)|| ' from wwv_flow_workspace_req_size'||chr(10)|| ' where request_type = ''N'''||chr(10)|| ' and display = ''Y'''||chr(10)|| ' order by to_number(req_size)', 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_attributes2=> 'class="instructiontext"', p_begin_on_new_line => 'YES', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT-TOP', p_field_alignment => 'LEFT-BOTTOM', p_display_when=>'NEW_SCHEMA', p_display_when2=>'YES', p_display_when_type=>'VAL_OF_ITEM_IN_COND_EQ_COND2', p_field_template => 187206412134572319+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||'The schema is the Oracle database user that will own your database objects. Please spend some time selecting this name because changing schemas can be an involved task. When your service is provisioned, you will receive your schema''s password and your login password. Once your workspace has been created, you can add additional schemas to it.'||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| 'Valid schema names must conform to the following g'; h:=h||'uidelines:'||chr(10)|| ''||chr(10)|| ' - Must be from 1 to 30 bytes long'||chr(10)|| ''||chr(10)|| ' - Cannot contain quotation marks'||chr(10)|| ''||chr(10)|| ' - Must begin with an alphabetic character'||chr(10)|| ''||chr(10)|| ' - Can only contain alphanumeric characters, with the exception of'||chr(10)|| ''||chr(10)|| ' (_) underscore, ($) dollar, and (#) pound signs.'||chr(10)|| ''||chr(10)|| ' - Cannot be an oracle reserved word'||chr(10)|| ''||chr(10)|| ' - Cannot be DUAL'; wwv_flow_api.create_page_item( p_id=>320269887457 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 25, p_name=>'SCHEMA_NAME', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 4863831037+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'New schema to create', p_source_type=> 'STATIC', p_display_as=> 'TEXT_WITH_ENTER_SUBMIT', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 30, 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=>'NEW_SCHEMA', p_display_when2=>'YES', p_display_when_type=>'VAL_OF_ITEM_IN_COND_EQ_COND2', p_field_template => 187206506383572320+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||'Enter the name of the schema you wish to make accessible to your new &PRODUCT_NAME. workspace. Once your workspace has been created, you can add additional schemas to it.'||chr(10)|| ''; wwv_flow_api.create_page_item( p_id=>11472001772984287 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 25, p_name=>'EXISTING_SCHEMA_NAME', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 30, p_item_plug_id => 4863831037+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Use this existing schema', p_source_type=> 'STATIC', p_display_as=> 'TEXT_WITH_ENTER_SUBMIT', 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=>'NEW_SCHEMA', p_display_when2=>'NO', p_display_when_type=>'VAL_OF_ITEM_IN_COND_EQ_COND2', p_field_template => 187206506383572320+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=>172217307242398784 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 25, p_name=>'NEW_SCHEMA_HINT', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 2, p_item_plug_id => 4863831037+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source=>'wwv_flow_lang.system_message(''F4700.NEW_SCHEMA_HINT'')', p_source_type=> 'FUNCTION', p_display_as=> 'DISPLAY_ONLY_ESCAPE_SC', 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_display_when=>'NEW_SCHEMA', p_display_when2=>'YES', p_display_when_type=>'VAL_OF_ITEM_IN_COND_EQ_COND2', p_field_template => 187206412134572319+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_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>172222728497414363 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 25, p_name=>'EXISTING_SCHEMA_HINT', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 4, p_item_plug_id => 4863831037+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source=>'wwv_flow_lang.system_message(''F4700.EXISTING_SCHEMA_HINT'')', p_source_type=> 'FUNCTION', p_display_as=> 'DISPLAY_ONLY_ESCAPE_SC', 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_display_when=>'NEW_SCHEMA', p_display_when2=>'NO', p_display_when_type=>'VAL_OF_ITEM_IN_COND_EQ_COND2', p_field_template => 187206412134572319+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_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>172226501055425374 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 25, p_name=>'NEW_TABLE', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 6, p_item_plug_id => 4863831037+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_field_template => 187206412134572319+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_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>177097216171957551 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 25, p_name=>'P25_SCHEMA', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 40, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'New schema to create', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 30, 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 => 187206506383572320+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_item_comment => ''); end; / begin wwv_flow_api.create_page_computation( p_id=> 177098721282977925 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 25, p_computation_sequence => 10, p_computation_item=> 'P25_SCHEMA', p_computation_point=> 'AFTER_SUBMIT', p_computation_type=> 'FUNCTION_BODY', p_computation_processed=> 'REPLACE_EXISTING', p_computation=> 'begin'||chr(10)|| 'return nvl(upper(:EXISTING_SCHEMA_NAME),upper(:SCHEMA_NAME));'||chr(10)|| 'end;', p_compute_when => '', p_compute_when_type=>''); null; end; / begin wwv_flow_api.create_page_validation( p_id => 174995802627402506 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'new schema name not null', p_validation_sequence=> 5, p_validation => 'SCHEMA_NAME', p_validation_type => 'ITEM_NOT_NULL', p_error_message => 'Schema name must be specified.', p_validation_condition=> ':NEW_SCHEMA = ''YES''', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_associated_item=> 320269887457 + 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 => 174996724098408796 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'existing schema name not null', p_validation_sequence=> 7, p_validation => 'EXISTING_SCHEMA_NAME', p_validation_type => 'ITEM_NOT_NULL', p_error_message => 'Schema name must be specified.', p_validation_condition=> ':NEW_SCHEMA = ''NO''', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_associated_item=> 11472001772984287 + 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 => 16910421773188557 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'schema exists', p_validation_sequence=> 10, p_validation => 'select null from sys.user$ where name = upper(:EXISTING_SCHEMA_NAME) and type#=1', p_validation_type => 'EXISTS', p_error_message => 'Schema &EXISTING_SCHEMA_NAME. does not exist.', p_validation_condition=> ':NEW_SCHEMA = ''NO''', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_associated_item=> 11472001772984287 + 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 => 175002332334505711 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'name not an existing role', p_validation_sequence=> 15, p_validation => 'select null from sys.user$ where name = upper(:EXISTING_SCHEMA_NAME) and type#=0', p_validation_type => 'NOT_EXISTS', p_error_message => 'Invalid Schema', p_validation_condition=> ':NEW_SCHEMA = ''NO''', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION', p_validation_comment=> ''); null; end; / begin wwv_flow_api.create_page_validation( p_id => 31864751459513493 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'new schema does not exist', p_validation_sequence=> 20, p_validation => 'select 1 from sys.user$ where name = upper(:SCHEMA_NAME)', p_validation_type => 'NOT_EXISTS', p_error_message => 'Invalid Schema', p_validation_condition=> ':NEW_SCHEMA = ''YES''', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_associated_item=> 320269887457 + 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 => 175703518948689391 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'schema is not restricted when admin is restricted', p_validation_sequence=> 25, p_validation => 'if :NEW_SCHEMA = ''YES'' then'||chr(10)|| ' for c1 in (select 1 from dual where'||chr(10)|| ' wwv_flow_provisioning.restricted_schema_i(upper(:SCHEMA_NAME),:COMPANY_NAME) = ''1'') loop'||chr(10)|| ' return false;'||chr(10)|| ' end loop;'||chr(10)|| ' return true;'||chr(10)|| 'else'||chr(10)|| ' for c1 in (select 1 from dual where'||chr(10)|| ' wwv_flow_provisioning.site_admin_is_restricted_i = ''1'' and'||chr(10)|| ' wwv_flow_provisioning.restricted_schema_i(upper(:EXISTING_SCHEMA_NAME),:COMPANY_NAME) = ''1'') loop'||chr(10)|| ' return false;'||chr(10)|| ' end loop;'||chr(10)|| ' return true;'||chr(10)|| 'end if;', p_validation_type => 'FUNC_BODY_RETURNING_BOOLEAN', p_error_message => 'Invalid Schema'||chr(10)|| '', p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION', p_validation_comment=> ''); null; end; / begin wwv_flow_api.create_page_validation( p_id => 31865013913542993 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'no spaces in name', p_validation_sequence=> 30, p_validation => 'SCHEMA_NAME', p_validation_type => 'ITEM_CONTAINS_NO_SPACES', p_error_message => 'Schema name must not contain spaces.', p_validation_condition=> ':NEW_SCHEMA = ''YES''', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_associated_item=> 320269887457 + 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 => 47216914721574906 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'schema name cant contain quotes', p_validation_sequence=> 100, p_validation => 'instr(:SCHEMA_NAME,'''''''')+instr(:SCHEMA_NAME,''"'') = 0', p_validation_type => 'PLSQL_EXPRESSION', p_error_message => 'Schema name must not contain quotation marks.', p_validation_condition=> ':NEW_SCHEMA = ''YES'' and'||chr(10)|| ':SCHEMA_NAME is not null', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_associated_item=> 320269887457 + 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 => 47217711926597880 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'cannot be an oracle reserved word', p_validation_sequence=> 110, p_validation => 'not wwv_flow_provision.is_reserved(:SCHEMA_NAME)', p_validation_type => 'PLSQL_EXPRESSION', p_error_message => 'Schema name (&SCHEMA_NAME.) is an Oracle reserved word. Enter a different schema.', p_validation_condition=> ':NEW_SCHEMA = ''YES'' and'||chr(10)|| ':SCHEMA_NAME is not null', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_associated_item=> 320269887457 + 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 => 59988904879054677 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'schema name is valid', p_validation_sequence=> 120, p_validation => 'wwv_flow_utilities.is_valid_identifier(:SCHEMA_NAME)', p_validation_type => 'PLSQL_EXPRESSION', p_error_message => 'Schema name is not valid. Specify another name.', p_validation_condition=> ':NEW_SCHEMA = ''YES'' and'||chr(10)|| ':SCHEMA_NAME is not null', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_associated_item=> 320269887457 + 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 => 175009024256995482 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 25, p_validation_name => 'new schema not used in existing workspace', p_validation_sequence=> 130, p_validation => 'select 1 from wwv_flow_company_schemas where schema = upper(:SCHEMA_NAME)', p_validation_type => 'NOT_EXISTS', p_error_message => 'Invalid Schema', p_validation_condition=> ':NEW_SCHEMA = ''YES'' and'||chr(10)|| ':SCHEMA_NAME is not null', p_validation_condition_type=> 'PLSQL_EXPRESSION', 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||':schema_name := trim(replace(:schema_name,''-'',''_''));'||chr(10)|| ':schema_name := replace(:schema_name,''&'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''\'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''/'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''['','''');'||chr(10)|| ':schema_name := replace(:schema_name,'']'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''('','''');'||chr(10)|| ':schema_name := replace(:schema_name,'')'','''');'||chr(10)|| ':schema_name := replace(:'; p:=p||'schema_name,''&'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''\'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''/'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''+'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''='','''');'||chr(10)|| ':schema_name := replace(:schema_name,''*'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''&'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''$'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''&'','''');'||chr(10)|| ':schema_nam'; p:=p||'e := replace(:schema_name,'';'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''%'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''#'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''@'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''!'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''~'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''`'','''');'||chr(10)|| ':schema_name := replace(:schema_name,'''''''','''');'||chr(10)|| ':schema_name := replace(:schema_name,'':'','''; p:=p||''');'||chr(10)|| ':schema_name := replace(:schema_name,''"'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''?'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''<'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''>'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''{'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''}'','''');'||chr(10)|| ':schema_name := replace(:schema_name,''.'','''');'||chr(10)|| ':schema_name := replace(:schema_name,'','','''');'||chr(10)|| ':schema_name := replace(:sch'; p:=p||'ema_name,''^'','''');'; wwv_flow_api.create_page_process( p_id => 13059725120036431 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 25, p_process_sequence=> 10, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'PLSQL', p_process_name=> 'remove bad char from schema name', 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 25 -- begin null; end; null; end; / --application/pages/page_00026 prompt ...PAGE 26: Request Workspace - Schema Warnings -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 26, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> '', p_name => 'Request Workspace - Schema Warnings', p_step_title=> 'Request 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=> '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=> 177082230240844373 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 26, p_plug_name=> 'Navigation', p_region_name=>'', p_plug_template=> 0, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 4762183464 + 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 => '', 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=> 177082418885844385 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 26, p_plug_name=> 'Warning', p_region_name=>'', p_plug_template=> 4688102857+ 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; / begin wwv_flow_api.create_page_button( p_id => 177082609759844393 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 26, p_button_sequence=> 1, p_button_plug_id => 177082418885844385+wwv_flow_api.g_id_offset, p_button_name => 'Cancel', p_button_image_alt=> 'Cancel', p_button_position=> 'REGION_TEMPLATE_CLOSE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=4550:1', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 177082802719844403 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 26, p_button_sequence=> 10, p_button_plug_id => 177082418885844385+wwv_flow_api.g_id_offset, p_button_name => 'Proceed', p_button_image_alt=> 'Next >', p_button_position=> 'REGION_TEMPLATE_NEXT', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 177083008639844403 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 26, p_button_sequence=> 5, p_button_plug_id => 177082418885844385+wwv_flow_api.g_id_offset, p_button_name => 'Back', p_button_image_alt=> '< Previous', p_button_position=> 'REGION_TEMPLATE_PREVIOUS', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=&APP_ID.:25:&SESSION.::&DEBUG.:::', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>66706514632218067 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 26, p_branch_action=> 'f?p=&APP_ID.:27:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_sequence=> 10, p_save_state_before_branch_yn=>'N', p_branch_comment=> 'Created 19-JAN-2007 16:28 by SBKENNED'); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>177084702792844420 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 26, p_name=>'P26_RESTRICTED_SCHEMA_WARNING', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 2, p_item_plug_id => 177082418885844385+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'NO', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_post_element_text=>'

', p_source=>'wwv_flow_lang.system_message(p_name=>''F4700.P26_WARN_RESTRICTED_SCHEMA'',p0=>v(''PRODUCT_NAME''))', p_source_type=> 'FUNCTION', p_display_as=> 'DISPLAY_ONLY_ESCAPE_SC', 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_display_when=>'select 1 from dual where'||chr(10)|| ' wwv_flow_provisioning.restricted_schema_i(:P25_SCHEMA,:COMPANY_NAME) = ''1''', p_display_when_type=>'EXISTS', p_field_template => 187206412134572319+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_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>177084927778844420 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 26, p_name=>'P26_SHARED_SCHEMA_WARNING', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 4, p_item_plug_id => 177082418885844385+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'NO', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source=>'wwv_flow_lang.system_message(p_name=>''F4700.P26_WARN_SHARED_SCHEMA'',p0=>v(''PRODUCT_NAME''))', p_source_type=> 'FUNCTION', p_display_as=> 'DISPLAY_ONLY_ESCAPE_SC', 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_display_when=>'select 1 from wwv_flow_company_schemas where schema = upper(:P25_SCHEMA)', p_display_when_type=>'EXISTS', p_field_template => 187206412134572319+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_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>177095520711911576 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 26, p_name=>'P26_SCHEMA', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 14, p_item_plug_id => 177082418885844385+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=> 'HIDDEN', 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 => 'NO', 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_lov_display_extra=>'NO', p_protection_level => 'N', p_escape_on_http_input => 'Y', p_item_comment => ''); end; / begin --------------------------------------- -- ...updatable report columns for page 26 -- begin null; end; null; end; / --application/pages/page_00027 prompt ...PAGE 27: Request Workspace - Project Description -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 27, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'HOME', p_name => 'Request Workspace - Project Description', p_step_title=> 'Request 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=> '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=> 109193847235 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 27, p_plug_name=> 'Navigation', p_region_name=>'', p_plug_template=> 0, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 4762183464 + 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 => '', 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=> 109195847236 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 27, p_plug_name=> '&PRODUCT_NAME. Registration', p_region_name=>'', p_plug_template=> 4688102857+ 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=> '

This information helps the &PRODUCT_NAME. administrator understand how you intend to use this service.

&P27_MORE_JUSTIFICATION.', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / begin wwv_flow_api.create_page_button( p_id => 109153847210 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 27, p_button_sequence=> 1, p_button_plug_id => 109195847236+wwv_flow_api.g_id_offset, p_button_name => 'Cancel', p_button_image_alt=> 'Cancel', p_button_position=> 'REGION_TEMPLATE_CLOSE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=4550:1', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 109155847214 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 27, p_button_sequence=> 10, p_button_plug_id => 109195847236+wwv_flow_api.g_id_offset, p_button_name => 'Proceed', p_button_image_alt=> 'Next >', p_button_position=> 'REGION_TEMPLATE_NEXT', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 109157847214 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 27, p_button_sequence=> 5, p_button_plug_id => 109195847236+wwv_flow_api.g_id_offset, p_button_name => 'Back', p_button_image_alt=> '< Previous', p_button_position=> 'REGION_TEMPLATE_PREVIOUS', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=&APP_ID.:25:&SESSION.::&DEBUG.:::', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>66702007660187721 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 27, p_branch_action=> 'f?p=&APP_ID.:30:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_when_button_id=>109155847214+ wwv_flow_api.g_id_offset, p_branch_sequence=> 10, p_save_state_before_branch_yn=>'N', p_branch_comment=> 'Created 19-JAN-2007 16:23 by SBKENNED'); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'Enter the purpose of your request for service. This information is for use by the &PRODUCT_NAME. administrator.'; wwv_flow_api.create_page_item( p_id=>109173847225 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 27, p_name=>'PROJECT_DESCRIPTION', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 109195847236+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Why are you requesting this service?', p_source_type=> 'STATIC', p_display_as=> 'TEXTAREA_WITH_SPELL_CHECK', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 50, p_cMaxlength=> 2000, p_cHeight=> 8, 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 => 'ABOVE', p_field_alignment => 'LEFT', p_field_template => 187206506383572320+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||'If your company or service agreement requires that you justify your request, please provide a justification.'; wwv_flow_api.create_page_item( p_id=>109175847225 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 27, p_name=>'PROJECT_JUSTIFICATION', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 109195847236+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Service request justification, optional', p_source_type=> 'STATIC', p_display_as=> 'TEXTAREA_WITH_SPELL_CHECK', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 50, p_cMaxlength=> 2000, p_cHeight=> 8, 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 => 'ABOVE', p_field_alignment => 'LEFT', p_display_when_type=>'NEVER', p_field_template => 187206412134572319+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=>177451430104093580 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 27, p_name=>'P27_MORE_JUSTIFICATION', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 30, p_item_plug_id => 109195847236+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=> '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 => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'LEFT', p_field_alignment => 'LEFT', p_display_when_type=>'NEVER', p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_escape_on_http_input => 'Y', p_item_comment => ''); end; / begin wwv_flow_api.create_page_computation( p_id=> 177458508913257768 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 27, p_computation_sequence => 10, p_computation_item=> 'P27_MORE_JUSTIFICATION', p_computation_point=> 'BEFORE_HEADER', p_computation_type=> 'FUNCTION_BODY', p_computation_processed=> 'REPLACE_EXISTING', p_computation=> 'declare x varchar2(32767) := null;'||chr(10)|| 'begin'||chr(10)|| ' if wwv_flow_provisioning.restricted_schema_i(:P25_SCHEMA,:COMPANY_NAME) = ''1'' then'||chr(10)|| ' x := wwv_flow_lang.system_message(''F4700.P26_JUSTIFY_RESTRICTED_SCHEMA'');'||chr(10)|| ' end if; '||chr(10)|| ' for c1 in (select 1 from wwv_flow_company_schemas '||chr(10)|| ' where schema = :P25_SCHEMA) loop'||chr(10)|| ' if x is not null then x := x||''

''; end if;'||chr(10)|| ' x := x||wwv_flow_lang.system_message(''F4700.P26_JUSTIFY_SHARED_SCHEMA'');'||chr(10)|| ' exit;'||chr(10)|| ' end loop;'||chr(10)|| ' return x||''

'';'||chr(10)|| 'end;', p_compute_when => '', p_compute_when_type=>''); null; end; / begin wwv_flow_api.create_page_validation( p_id => 109236958762 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 27, p_validation_name => 'PROJECT_DESCRIPTION Not Null', p_validation_sequence=> 1, p_validation => 'PROJECT_DESCRIPTION', p_validation_type => 'ITEM_NOT_NULL', p_error_message => 'You must explain why you are requesting this service.', p_associated_item=> 109173847225 + wwv_flow_api.g_id_offset, p_error_display_location=>'INLINE_WITH_FIELD_AND_NOTIFICATION', p_validation_comment=> 'generated 23-FEB-2001 12:53'); null; end; / begin --------------------------------------- -- ...updatable report columns for page 27 -- begin null; end; null; end; / --application/pages/page_00030 prompt ...PAGE 30: Request Workspace - Confirmation -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 30, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'HOME', p_name => 'Request Workspace - Confirmation', p_step_title=> 'Request Workspace', p_allow_duplicate_submissions=>'N', p_on_dup_submission_goto_url=>'', 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 => 'SSPADAFO', p_last_upd_yyyymmddhh24miss => '20081029181432', 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=> 318115852998 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 30, p_plug_name=> 'Navigation', p_region_name=>'', p_plug_template=> 0, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 4762183464 + 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 => '', 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.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p(''<'; s:=s||'/table>'');'||chr(10)|| 'htp.p(''

'' || wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.ACCEPT'')||''

'');'||chr(10)|| ''||chr(10)|| ''||chr(10)|| 'htp.p(''

''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.WORKSPACE_INFO'')||'':

'');'||chr(10)|| ' htp.p(''

'||chr(10)|| '
'');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'ht'; s:=s||'p.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p(''
''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.NAME'')||''''||htf.escape_sc(:COMPANY_NAME)||''
''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.DESCRIPTION'')||''''||htf.escape_sc(substr(:PROJECT_DESCRIPTION,1,50))||''...
'');'||chr(10)|| ''||chr(10)|| 'htp.p(''

''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.ADMIN_I'; s:=s||'NFO'')||'':

'');'||chr(10)|| ' htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p(''
''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.FIRST_NAME'')||''''||htf.escape_sc(:ADMIN_FIRST_NAME)||''
''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.LAST_NAME'')|'; s:=s||'|''''||htf.escape_sc(:ADMIN_LAST_NAME)||''
''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.EMAIL'')||''''||htf.escape_sc(:ADMIN_EMAIL)||''
'');'||chr(10)|| ''||chr(10)|| 'htp.p(''

''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.SCHEMA_INFO'')||'':'; s:=s||'

'');'||chr(10)|| ' htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'if :NEW_SCHEMA = ''NO'' then'||chr(10)|| ' htp.p('''');'||chr(10)|| 'else'||chr(10)|| ' htp.p('''');'||chr(10)|| 'end if;'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p('''');'||chr(10)|| 'if :NEW_SCHEMA = ''YES'' then'||chr(10)|| ' htp.p('''');'||chr(10)|| 'else'||chr(10)|| ' htp.p('''');'||chr(10)|| 'end if;'||chr(10)|| 'htp.p('''');'||chr(10)|| 'if :'; s:=s||'NEW_SCHEMA = ''YES'' then'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p('''');'||chr(10)|| 'end if;'||chr(10)|| 'htp.p(''
''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.REUSE_SCHEMA'')||''''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.YES'')||''''||wwv_flow_lang.sy'; s:=s||'stem_message(p_name=>''SERVICE_SIGNUP.NO'')||''
''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.SCHEMA_NAME'')||''''||htf.escape_sc(:SCHEMA_NAME)||''''||htf.escape_sc(:EXISTING_SCHEMA_NAME)||''
''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.DB_SIZE'')||''''||htf.escape_sc(:DATABASE_SIZE)||''
'');'||chr(10)|| ''||chr(10)|| 'if :NEW_SCHEMA = ''NO'' then'||chr(10)|| ' declare l_count pls_integer;'||chr(10)|| ' begin'||chr(10)|| ' select count(*) into l_count from wwv_flow_company_schemas where schema '; s:=s||'= upper(:EXISTING_SCHEMA_NAME);'||chr(10)|| ' if l_count > 0 then'||chr(10)|| ' htp.p(''

''||wwv_flow_lang.system_message(p_name=>''WARNING'')||'':

'');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p(''
''||wwv_flow_lang.system_message(p_name=>''F4700.SCHEMA_USED_BY_WORKSPACES'',p0=>l_count)||'''');'||chr(10)|| ' htp.p(''
'');'||chr(10)|| ' end if;'||chr(10)|| ' end; '||chr(10)|| ' if wwv_flow_provisioning.restricted_schema(upper(:EXISTING_SCHEMA_NAME),:COMPANY_NAME) then'||chr(10)|| ' htp.p(''

''||wwv_flow_lang.system_message(p_name=>''WARNING'')||'':

'');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' '; s:=s||' htp.p('''');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p(''
''||wwv_flow_lang.system_message(p_name=>''F4700.SCHEMA_RESTRICTED'')||''
'');'||chr(10)|| ' end if;'||chr(10)|| 'else'||chr(10)|| ' if wwv_flow_provisioning.restricted_schema(upper(:SCHEMA_NAME),:COMPANY_NAME) then'||chr(10)|| ' htp.p(''

''||wwv_flow_lang.system_message(p_name=>''WARNING'')||'':

'');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p('''');'||chr(10)|| ' htp.p(''
''||wwv_flow_lang.system_message(p_name=>''F4700.SCHEMA_RESTRICTED'')||''
'');'||chr(10)|| ' end if;'||chr(10)|| 'end if;'; wwv_flow_api.create_page_plug ( p_id=> 94840826419648214 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 30, p_plug_name=> 'Confirmation', p_region_name=>'', p_plug_template=> 4688102857+ 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=> 'code remove for justification'||chr(10)|| 'htp.p('''');'||chr(10)|| 'htp.p(''''||wwv_flow_lang.system_message(p_name=>''SERVICE_SIGNUP.JUSTIFICATION'')||'''');'||chr(10)|| 'htp.p(''''||htf.escape_sc(substr(:PROJECT_JUSTIFICATION,1,50))||''...'');'||chr(10)|| 'htp.p('''');'); end; / begin wwv_flow_api.create_page_button( p_id => 318079852987 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 30, p_button_sequence=> 1, p_button_plug_id => 94840826419648214+wwv_flow_api.g_id_offset, p_button_name => 'Cancel', p_button_image_alt=> 'Cancel', p_button_position=> 'REGION_TEMPLATE_CLOSE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=4550:1', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 318141939408 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 30, p_button_sequence=> 20, p_button_plug_id => 94840826419648214+wwv_flow_api.g_id_offset, p_button_name => 'Accept', p_button_image_alt=> 'Submit Request', p_button_position=> 'REGION_TEMPLATE_CREATE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 318938118262 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 30, p_button_sequence=> 2, p_button_plug_id => 94840826419648214+wwv_flow_api.g_id_offset, p_button_name => 'Back_button', p_button_image_alt=> '< Previous', p_button_position=> 'REGION_TEMPLATE_PREVIOUS', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=&FLOW_ID.:27:&SESSION.::&DEBUG.:::', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>60145132142214439 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 30, p_branch_action=> 'f?p=&APP_ID.:3:&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=> ''); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'You are required to enter the verification code you see in the box.'||chr(10)|| 'Please be careful while entering the letters as they are case sensitive.'; wwv_flow_api.create_page_item( p_id=>29906703634753342 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 30, p_name=>'P30_VERIFICATION_CODE', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 94840826419648214+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'NO', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Verification Code: ', p_source_type=> 'STATIC', p_display_as=> 'TEXT', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 10, p_cMaxlength=> 5, 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 => 187206506383572320+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 => 29962128538283685 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 30, p_validation_name => 'Verification code', p_validation_sequence=> 10, p_validation => 'begin'||chr(10)|| 'for c1 in'||chr(10)|| ' (select * from wwv_flow_request_verifications'||chr(10)|| 'where session_id = :APP_SESSION) loop'||chr(10)|| ' if c1.verification_string = :P30_verification_code then'||chr(10)|| ' return true;'||chr(10)|| ' else '||chr(10)|| ' return false;'||chr(10)|| ' end if;'||chr(10)|| 'end loop;'||chr(10)|| 'return false;'||chr(10)|| 'end;', p_validation_type => 'FUNC_BODY_RETURNING_BOOLEAN', p_error_message => 'Invalid Verification Code', p_associated_item=> 29906703634753342 + 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_schema varchar2(255);'||chr(10)|| 'begin'||chr(10)|| ' if :NEW_SCHEMA = ''YES'' then'||chr(10)|| ' l_schema := :SCHEMA_NAME;'||chr(10)|| ' else'||chr(10)|| ' l_schema := :EXISTING_SCHEMA_NAME;'||chr(10)|| ' end if;'||chr(10)|| 'wwv_flow_provisioning.make_request ('||chr(10)|| ' p_COMPANY_NAME => :COMPANY_NAME,'||chr(10)|| ' p_ADMIN_FIRST_NAME => :ADMIN_FIRST_NAME,'||chr(10)|| ' p_ADMIN_LAST_NAME => :ADMIN_LAST_NAME,'||chr(10)|| ' p_ADMIN_EMAIL => :ADMIN_EMAIL,'||chr(10)|| ' p_ADMIN_PHONE => :ADMIN_PHONE,'||chr(10)|| ' p_ADMIN_USERID => :A'; p:=p||'DMIN_EMAIL,'||chr(10)|| ' p_COMPANY_ADDRESS => null,'||chr(10)|| ' p_CITY => null,'||chr(10)|| ' p_STATE => null,'||chr(10)|| ' p_ZIP => null,'||chr(10)|| ' p_COUNTRY => null,'||chr(10)|| ' p_COMPANY_TYPE => null, '||chr(10)|| ' p_COMPANY_PHONE => null,'||chr(10)|| ' p_COMPANY_FAX => null,'||chr(10)|| ' p_DATABASE_SIZE=> :DATABASE_SIZE, '||chr(10)|| ' p_SCHEMA_NAME=> l_schema,'||chr(10)|| ' p_project_description=> :PROJECT_DESCRIPTION,'||chr(10)|| ' p_project_justification=> :PROJECT_JUSTIFICATION'||chr(10)|| ' );'||chr(10)|| ' --'||chr(10)|| ' wwv_flow_mail.push_queue_ba'; p:=p||'ckground;'||chr(10)|| 'end;'; wwv_flow_api.create_page_process( p_id => 16952718581632268 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 30, p_process_sequence=> 10, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'PLSQL', p_process_name=> 'make request', p_process_sql_clob => p, p_process_error_message=> 'Error requesting &MSG_COMPANY..', p_process_success_message=> '&MSG_COMPANY. &COMPANY_NAME. requested. After the request has been reviewed, the administrator account password or other status information will be sent to the email address: &ADMIN_EMAIL..', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin --------------------------------------- -- ...updatable report columns for page 30 -- begin null; end; null; end; / --application/pages/page_00040 prompt ...PAGE 40: Request Workspace - New or Existing Schema -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 40, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'HOME', p_name => 'Request Workspace - New or Existing Schema', p_step_title=> 'Request 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 => '20071120070308', 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=> 318719223870 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 40, p_plug_name=> '&PRODUCT_NAME. Registration', p_region_name=>'', p_plug_template=> 4688102857+ 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=> '

Identify if your requested workspace should have privilege in an existing database schema, or, if you are requesting the creation of a new database schema.

', 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=> 318723223878 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 40, p_plug_name=> 'Navigation', p_region_name=>'', p_plug_template=> 0, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 4762183464 + 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 => '', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / begin wwv_flow_api.create_page_button( p_id => 101384848266 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 40, p_button_sequence=> 1, p_button_plug_id => 318719223870+wwv_flow_api.g_id_offset, p_button_name => 'CANCEL', p_button_image_alt=> 'Cancel', p_button_position=> 'REGION_TEMPLATE_CLOSE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=4550:1', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 318709223867 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 40, p_button_sequence=> 3, p_button_plug_id => 318719223870+wwv_flow_api.g_id_offset, p_button_name => 'NEXT_STEP', p_button_image_alt=> 'Next >', p_button_position=> 'REGION_TEMPLATE_NEXT', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 101391869900 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 40, p_button_sequence=> 2, p_button_plug_id => 318719223870+wwv_flow_api.g_id_offset, p_button_name => 'Back', p_button_image_alt=> '< Previous', p_button_position=> 'REGION_TEMPLATE_PREVIOUS', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=&APP_ID.:20:&SESSION.::&DEBUG.:::', p_button_cattributes=>'class="button10"', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>66692613453132594 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 40, p_branch_action=> 'f?p=&APP_ID.:25:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_when_button_id=>318709223867+ wwv_flow_api.g_id_offset, p_branch_sequence=> 10, p_save_state_before_branch_yn=>'N', p_branch_comment=> 'Created 19-JAN-2007 16:14 by SBKENNED'); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'No help text available'; wwv_flow_api.create_page_item( p_id=>11463031938945752 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 40, p_name=>'NEW_SCHEMA', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 318719223870+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>' ', p_source=>'YES', p_source_type=> 'STATIC', p_display_as=> 'RADIOGROUP', p_named_lov=> 'NEW_OR_EXISTING_SCHEMA', p_lov => '.'||to_char(150771414457811401 + wwv_flow_api.g_id_offset)||'.', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'Y', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> 1, p_cAttributes=> 'nowrap="nowrap"', p_tag_attributes2=> 'class="instructiontext"', 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_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_help_text => h, p_item_comment => ''); end; / begin --------------------------------------- -- ...updatable report columns for page 40 -- begin null; end; null; end; / prompt ...lists -- --application/shared_components/navigation/lists/provisionnewservice begin wwv_flow_api.create_list ( p_id=> 4762183464 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'ProvisionNewService', p_list_status=> 'PUBLIC', p_list_displayed=> 'BY_DEFAULT', p_display_row_template_id=> 91248625890266048 + wwv_flow_api.g_id_offset); wwv_flow_api.create_list_item ( p_id=> 60577706518684017 + wwv_flow_api.g_id_offset, p_list_id=> 4762183464 + wwv_flow_api.g_id_offset, p_list_item_type=> 'LINK', p_list_item_status=> 'PUBLIC', p_item_displayed=> 'BY_DEFAULT', p_list_item_display_sequence=>0, p_list_item_link_text=> 'Welcome', p_list_item_link_target=> 'f?p=&APP_ID.:1:&SESSION.::&DEBUG.::::', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_current_for_pages=> '1', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 4770195076 + wwv_flow_api.g_id_offset, p_list_id=> 4762183464 + wwv_flow_api.g_id_offset, p_list_item_type=> 'LINK', p_list_item_status=> 'PUBLIC', p_item_displayed=> 'BY_DEFAULT', p_list_item_display_sequence=>1, p_list_item_link_text=> 'Identify Administrator', p_list_item_link_target=> 'f?p=4700:10:&SESSION.', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_current_for_pages=> '10', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 4768193355 + wwv_flow_api.g_id_offset, p_list_id=> 4762183464 + wwv_flow_api.g_id_offset, p_list_item_type=> 'LINK', p_list_item_status=> 'PUBLIC', p_item_displayed=> 'BY_DEFAULT', p_list_item_display_sequence=>2, p_list_item_link_text=> 'Name Workspace', p_list_item_link_target=> 'f?p=&APP_ID.:20:&SESSION.::&DEBUG.::::', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_current_for_pages=> '20', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 4836827003 + wwv_flow_api.g_id_offset, p_list_id=> 4762183464 + wwv_flow_api.g_id_offset, p_list_item_type=> 'LINK', p_list_item_status=> 'PUBLIC', p_item_displayed=> 'BY_DEFAULT', p_list_item_display_sequence=>4, p_list_item_link_text=> 'Select Database Schema', p_list_item_link_target=> 'f?p=&APP_ID.:25:&SESSION.::&DEBUG.::::', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_current_for_pages=> '25,26,40', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 109218886058 + wwv_flow_api.g_id_offset, p_list_id=> 4762183464 + wwv_flow_api.g_id_offset, p_list_item_type=> 'LINK', p_list_item_status=> 'PUBLIC', p_item_displayed=> 'BY_DEFAULT', p_list_item_display_sequence=>5, p_list_item_link_text=> 'Justify Request', p_list_item_link_target=> 'f?p=&APP_ID.:27:&SESSION.::&DEBUG.::::', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_current_for_pages=> '27', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 4764187459 + wwv_flow_api.g_id_offset, p_list_id=> 4762183464 + wwv_flow_api.g_id_offset, p_list_item_type=> 'LINK', p_list_item_status=> 'PUBLIC', p_item_displayed=> 'BY_DEFAULT', p_list_item_display_sequence=>6, p_list_item_link_text=> 'Confirmation', p_list_item_link_target=> 'f?p=&APP_ID.:30:&SESSION.::&DEBUG.::::', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_current_for_pages=> '30,3', p_list_item_owner=> ''); null; end; / --application/shared_components/navigation/lists/confirmed_list begin wwv_flow_api.create_list ( p_id=> 60555613032506142 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'Confirmed List', p_list_status=> 'PUBLIC', p_list_displayed=> 'BY_DEFAULT', p_display_row_template_id=> 66657631629028386 + wwv_flow_api.g_id_offset); wwv_flow_api.create_list_item ( p_id=> 60556328270510578 + wwv_flow_api.g_id_offset, p_list_id=> 60555613032506142 + wwv_flow_api.g_id_offset, p_list_item_type=> 'LINK', p_list_item_status=> 'PUBLIC', p_item_displayed=> 'BY_DEFAULT', p_list_item_display_sequence=>10, p_list_item_link_text=> 'Return to &PRODUCT_NAME. Login Page', p_list_item_link_target=> 'f?p=4550:1:&SESION.', p_list_item_icon => 'htmldb/icons/pt_page.png', p_list_item_icon_attributes=> 'alt="" width="20" height="20"', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 60556713163515635 + wwv_flow_api.g_id_offset, p_list_id=> 60555613032506142 + wwv_flow_api.g_id_offset, p_list_item_type=> 'LINK', p_list_item_status=> 'PUBLIC', p_item_displayed=> 'BY_DEFAULT', p_list_item_display_sequence=>20, p_list_item_link_text=> '&PRODUCT_NAME. Oracle Technology Network Home Page', p_list_item_link_target=> 'http://www.oracle.com/technology/products/database/application_express/', p_list_item_icon => 'htmldb/icons/pt_page.png', p_list_item_icon_attributes=> 'alt="" width="20" height="20"', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 60557022860518470 + wwv_flow_api.g_id_offset, p_list_id=> 60555613032506142 + wwv_flow_api.g_id_offset, p_list_item_type=> 'LINK', p_list_item_status=> 'PUBLIC', p_item_displayed=> 'BY_DEFAULT', p_list_item_display_sequence=>30, p_list_item_link_text=> '&PRODUCT_NAME. Discussion Forum', p_list_item_link_target=> 'http://forums.oracle.com/forums/forum.jspa?forumID=137', p_list_item_icon => 'htmldb/icons/pt_page.png', p_list_item_icon_attributes=> 'alt="" width="20" height="20"', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_owner=> ''); null; end; / --application/shared_components/navigation/breadcrumbs prompt ...breadcrumbs -- prompt ...page templates for application: 4700 -- --application/shared_components/user_interface/templates/page/printer_friendly prompt ......Page template 4674102852 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##HEAD##FORM_OPEN#'; c2:=c2||''||chr(10)|| ''; c3:=c3||'
#BOX_BODY#'; wwv_flow_api.create_template( p_id=> 4674102852 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'printer-friendly', p_body_title=> '', p_header_template=> c1, p_box=> c3, p_footer_template=> c2, p_success_message=> '
#SUCCESS_MESSAGE#
', p_current_tab=> '', p_current_tab_font_attr=> '', p_non_current_tab=> '', p_non_current_tab_font_attr => '', p_top_current_tab=> '', p_top_current_tab_font_attr => '', p_top_non_curr_tab=> '', p_top_non_curr_tab_font_attr=> '', p_current_image_tab=> '', p_non_current_image_tab=> '', p_notification_message=> '
#MESSAGE#
', p_navigation_bar=> '#BAR_BODY#', p_navbar_entry=> '', p_app_tab_before_tabs=>'', p_app_tab_current_tab=>'', p_app_tab_non_current_tab=>'', p_app_tab_after_tabs=>'', p_region_table_cattributes=> ' summary="" cellpadding="0" border="0" cellspacing="2" width="100%"', p_theme_id => 3, p_theme_class_id => 5, p_error_page_template => '
'||chr(10)|| '
'||chr(10)|| '
#MESSAGE#
'||chr(10)|| '#RETURN_TO_APPLICATION#', p_reference_id=> 80874804748045950, p_translate_this_template => 'N', p_template_comment => ''); end; null; end; / --application/shared_components/user_interface/templates/page/columbus_login_and_logout_page prompt ......Page template 108132430112395957 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##HEAD##FORM_OPEN#'||chr(10)|| ''; c2:=c2||'
&MSG_LANGUAGE.: &BROWSER_LANGUAGE.
'||chr(10)|| '
#FLOW_VERSION#
'||chr(10)|| '
'||chr(10)|| '

'||chr(10)|| '
&MSG_COPYRIGHT.
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '#FORM_CLOSE#'||chr(10)|| '
'||chr(10)|| ''||chr(10)|| ''; c3:=c3||'
#LOGO#
'||chr(10)|| '

'||chr(10)|| '

'||chr(10)|| '

'||chr(10)|| ''||chr(10)|| '
#SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#
'||chr(10)|| '
'||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| '
#REGION_POSITION_01#

#REGION_POSITION_02##REGION_POSITION_04##BOX_BODY#

#REGION_POSITION_03##REGION_POSITION_05#
'||chr(10)|| '
'; wwv_flow_api.create_template( p_id=> 108132430112395957 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> '(Columbus) Login and Logout Page', p_body_title=> '', p_header_template=> c1, p_box=> c3, p_footer_template=> c2, p_success_message=> '
#SUCCESS_MESSAGE#
', p_current_tab=> '', p_current_tab_font_attr=> '', p_non_current_tab=> '', p_non_current_tab_font_attr => '', p_top_current_tab=> '', p_top_current_tab_font_attr => '', p_top_non_curr_tab=> '', p_top_non_curr_tab_font_attr=> '', p_current_image_tab=> '', p_non_current_image_tab=> '', p_notification_message=> '
#MESSAGE#
', p_navigation_bar=> '#BAR_BODY#', p_navbar_entry=> '', p_app_tab_before_tabs=>'', p_app_tab_current_tab=>'', p_app_tab_non_current_tab=>'', p_app_tab_after_tabs=>'', p_region_table_cattributes=> ' summary="" cellpadding="0" border="0" cellspacing="2" width="100%"', p_theme_id => 3, p_theme_class_id => 6, p_error_page_template => '
'||chr(10)|| '
'||chr(10)|| '
#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/green_look_no_sidebar_from_4999 prompt ......Page template 258573723069846308 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##HEAD##FORM_OPEN#'; c2:=c2||'
&MSG_LANGUAGE.: &BROWSER_LANGUAGE.
'||chr(10)|| '
#FLOW_VERSION#
'||chr(10)|| '
'||chr(10)|| '
&MSG_COMPANY.&MSG_USER.: &USER.
'||chr(10)|| '
&MSG_COPYRIGHT.
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '#FORM_CLOSE#'||chr(10)|| '
'||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''; c3:=c3||''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| '
#LOGO##NAVIGATION_BAR#'||chr(10)|| '
#REGION_POSITION_07#
'||chr(10)|| '
'||chr(10)|| '

'||chr(10)|| '
#REGION_POSITION_08##CUSTOMIZE#
'||chr(10)|| ''||chr(10)|| '
#SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#
'||chr(10)|| '
'||chr(10)|| '
#REGION_POSITION_01#
'||chr(10)|| ''; c3:=c3||''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| '
#REGION_POSITION_02##BOX_BODY#

#REGION_POSITION_03##REGION_POSITION_05#
'||chr(10)|| '
#REGION_POSITION_04#
'||chr(10)|| '
'; wwv_flow_api.create_template( p_id=> 258573723069846308 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'Green Look (No SideBar) From 4999', p_body_title=> '', p_header_template=> c1, p_box=> c3, p_footer_template=> c2, p_success_message=> '
#SUCCESS_MESSAGE#
'||chr(10)|| '', p_current_tab=> '', p_current_tab_font_attr=> '', p_non_current_tab=> '', p_non_current_tab_font_attr => '', p_top_current_tab=> '', p_top_current_tab_font_attr => '', p_top_non_curr_tab=> '', p_top_non_curr_tab_font_attr=> '', p_current_image_tab=> '', p_non_current_image_tab=> '', p_notification_message=> '
#MESSAGE#
'||chr(10)|| '', p_navigation_bar=> '#BAR_BODY#', p_navbar_entry=> '#TEXT#', p_app_tab_before_tabs=>'', p_app_tab_current_tab=>'', p_app_tab_non_current_tab=>'', p_app_tab_after_tabs=>'', p_region_table_cattributes=> ' summary="" cellpadding="0" border="0" cellspacing="2" width="100%"', p_breadcrumb_def_reg_pos => 'REGION_POSITION_08', p_theme_id => 3, p_theme_class_id => 1, p_error_page_template => '
'||chr(10)|| '
'||chr(10)|| '
#MESSAGE#
'||chr(10)|| '#RETURN_TO_APPLICATION#', p_reference_id=> 18525411970780075, p_translate_this_template => 'N', p_template_comment => ''); end; null; end; / prompt ...button templates -- --------------------------------------- prompt ...region templates -- --application/shared_components/user_interface/templates/region/wizard_box prompt ......region template 4688102857 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 => 4688102857 + 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=> 4688102857 + 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 60551104085502857 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 => 60551104085502857 + 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=> 60551104085502857 + 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/info_c_htmldbinfo_from_4999 prompt ......region template 94734804379445706 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#
'; t2:=t2||' '; wwv_flow_api.create_plug_template ( p_id => 94734804379445706 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_template => t, p_page_plug_template_name=> 'Info (c:htmldbInfo) From 4999', p_plug_table_bgcolor => '#F7F7E7', p_theme_id => 3, p_theme_class_id => 2, p_plug_heading_bgcolor => '#F7F7E7', p_plug_font_size => '-1', p_reference_id=> 17355419405599943, 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=> 94734804379445706 + 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/standard_list_c_htmldbstandardlist_from_4999 prompt ......list template 4794278052 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#'; t2:=t2||'#TEXT#'; t3 := null; t4 := null; t5 := null; t6 := null; t7 := null; t8 := null; wwv_flow_api.create_list_template ( p_id=>4794278052 + wwv_flow_api.g_id_offset, p_flow_id=>wwv_flow.g_flow_id, p_list_template_current=>t, p_list_template_noncurrent=> t2, p_list_template_name=>'Standard List (c:htmldbStandardList) From 4999', p_theme_id => 3, p_theme_class_id => 0, p_list_template_before_rows=>''||chr(10)|| '', p_list_template_after_rows=>'
', p_reference_id=>17385324891888482, p_translate_this_template => 'N', p_list_template_comment=>''); end; null; end; / --application/shared_components/user_interface/templates/list/unordered_list_from_4999 prompt ......list template 66657631629028386 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#
    • '; t2:=t2||'
  • #TEXT#
    • '; t3 := null; t4 := null; t5 := null; t6 := null; t7 := null; t8 := null; wwv_flow_api.create_list_template ( p_id=>66657631629028386 + wwv_flow_api.g_id_offset, p_flow_id=>wwv_flow.g_flow_id, p_list_template_current=>t, p_list_template_noncurrent=> t2, p_list_template_name=>'Unordered List from 4999', p_theme_id => 3, p_theme_class_id => 1, p_list_template_before_rows=>'', p_reference_id=>60219508156141083, p_translate_this_template => 'N', p_list_template_comment=>''); end; null; end; / --application/shared_components/user_interface/templates/list/wizard_sidebar_c_htmldbwizbar prompt ......list template 91248625890266048 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#
    '; t2:=t2||'
    #TEXT#
    '; t3 := null; t4 := null; t5 := null; t6 := null; t7 := null; t8 := null; wwv_flow_api.create_list_template ( p_id=>91248625890266048 + wwv_flow_api.g_id_offset, p_flow_id=>wwv_flow.g_flow_id, p_list_template_current=>t, p_list_template_noncurrent=> t2, p_list_template_name=>'Wizard Sidebar (c:htmldbWizBar)', p_theme_id => 3, p_theme_class_id => 0, p_list_template_before_rows=>'
    ', p_list_template_after_rows=>'
    ', p_between_items=>'
    Down
    ', p_reference_id=>60218330803141060, p_translate_this_template => 'N', p_list_template_comment=>''); end; null; end; / prompt ...report templates -- prompt ...label templates -- --application/shared_components/user_interface/templates/label/formfield_nonrequired prompt ......label template 187206412134572319 begin begin wwv_flow_api.create_field_template ( p_id=> 187206412134572319 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_template_name=>'FormField_Nonrequired', p_template_body1=>'', p_on_error_before_label=>'', p_on_error_after_label=>'', p_theme_id => 3, p_theme_class_id => 0, p_reference_id=> 17388415351892041, p_translate_this_template=> 'N', p_template_comment=> ''); end; null; end; / --application/shared_components/user_interface/templates/label/formfield_required prompt ......label template 187206506383572320 begin begin wwv_flow_api.create_field_template ( p_id=> 187206506383572320 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_template_name=>'FormField_Required', p_template_body1=>'', p_on_error_before_label=>'', p_on_error_after_label=>'', p_theme_id => 3, p_theme_class_id => 0, p_reference_id=> 17388508175892042, p_translate_this_template=> 'N', p_template_comment=> ''); end; null; end; / prompt ...breadcrumb templates -- --application/shared_components/user_interface/templates/popuplov prompt ...popup list of values templates -- prompt ......template 14663214008465131 begin begin wwv_flow_api.create_popup_lov_template ( p_id=> 14663214008465131 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_popup_icon=>'#IMAGE_PREFIX#htmldb/icons/view_small.gif', p_popup_icon_attr=>'width="18" height="18" alt="#LIST_OF_VALUES#" title="#LIST_OF_VALUES#"', p_popup_icon2=>'', p_popup_icon_attr2=>'', p_page_name=>'winlov', p_page_title=>'Search Dialog', p_page_html_head=>''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| ''||chr(10)|| '', p_page_body_attr=>'onload="first_field()" class="htmldbPopup"', p_before_field_text=>'', p_page_heading_text=>'
    ', p_page_footer_text =>'
    ', p_filter_width =>'20', p_filter_max_width =>'100', p_filter_text_attr =>'', p_find_button_text =>'Search', p_find_button_image=>'', p_find_button_attr =>'', p_close_button_text=>'Close', p_close_button_image=>'', p_close_button_attr=>'', p_next_button_text =>'Next >', p_next_button_image=>'', p_next_button_attr =>'', p_prev_button_text =>'< Previous', p_prev_button_image=>'', p_prev_button_attr =>'', p_after_field_text=>'', p_scrollbars=>'1', p_resizable=>'1', p_width =>'400', p_height=>'500', p_result_row_x_of_y=>'
    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 75131326757053015 begin wwv_flow_api.create_theme ( p_id =>75131326757053015 + 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=>108132430112395957 + wwv_flow_api.g_id_offset, p_error_template=>108132430112395957 + wwv_flow_api.g_id_offset, p_printer_friendly_template=>4674102852 + 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=>4688102857 + 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=>187206412134572319 + 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=>4794278052 + 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 4700 -- begin --application/shared_components/logic/build_options/company_address wwv_flow_api.create_build_option ( p_id=> 46948758488708852 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_build_option_name=> 'company address', p_build_option_status=> 'EXCLUDE', p_build_option_comment=> 'we can avoid asking internal Oracle folks for address info'); end; / --application/shared_components/globalization/messages prompt ...messages used by application: 4700 -- --application/shared_components/globalization/dyntranslations prompt ...dynamic translations used by application: 4700 -- --application/shared_components/globalization/language prompt ...Language Maps for Application 4700 -- begin wwv_flow_api.create_language_map( p_id => 72249221944976158 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => 4700, p_translation_flow_id => 4701, p_translation_flow_language_cd=> 'es', p_translation_image_directory => '', p_translation_comments => 'New Service Signup (generic) - Spanish'); wwv_flow_api.create_language_map( p_id => 72249331462976158 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => 4700, p_translation_flow_id => 4702, p_translation_flow_language_cd=> 'fr', p_translation_image_directory => '', p_translation_comments => 'New Service Signup (generic) - French'); wwv_flow_api.create_language_map( p_id => 72249422093976158 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => 4700, p_translation_flow_id => 4703, p_translation_flow_language_cd=> 'de', p_translation_image_directory => '', p_translation_comments => 'New Service Signup (generic) - German'); wwv_flow_api.create_language_map( p_id => 72249524286976158 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => 4700, p_translation_flow_id => 4704, p_translation_flow_language_cd=> 'it', p_translation_image_directory => '', p_translation_comments => 'New Service Signup (generic) - Italian'); wwv_flow_api.create_language_map( p_id => 72249616486976158 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => 4700, p_translation_flow_id => 4705, p_translation_flow_language_cd=> 'pt-br', p_translation_image_directory => '', p_translation_comments => 'New Service Signup (generic) - Brazilian Portugese'); wwv_flow_api.create_language_map( p_id => 72249708847976158 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => 4700, p_translation_flow_id => 4706, p_translation_flow_language_cd=> 'zh-cn', p_translation_image_directory => '', p_translation_comments => 'New Service Signup (generic) - Simplified Chinese'); wwv_flow_api.create_language_map( p_id => 72249804429976158 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => 4700, p_translation_flow_id => 4707, p_translation_flow_language_cd=> 'zh-tw', p_translation_image_directory => '', p_translation_comments => 'New Service Signup (generic) - Traditional Chinese'); wwv_flow_api.create_language_map( p_id => 72249911966976158 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => 4700, p_translation_flow_id => 4708, p_translation_flow_language_cd=> 'ko', p_translation_image_directory => '', p_translation_comments => 'New Service Signup (generic) - Korean'); wwv_flow_api.create_language_map( p_id => 72250029723976159 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => 4700, p_translation_flow_id => 4709, p_translation_flow_language_cd=> 'ja', p_translation_image_directory => '', p_translation_comments => 'New Service Signup (generic) - Japanese'); end; / prompt ...Shortcuts -- --application/shared_components/user_interface/shortcuts/item_help begin declare c1 varchar2(32767) := null; l_clob clob; l_length number := 1; begin c1:=c1||''; wwv_flow_api.create_shortcut ( p_id=> 187203309767569784 + 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; / prompt ...web services (9iR2 or better) -- prompt ...shared queries -- prompt ...report layouts -- prompt ...authentication schemes -- --application/shared_components/security/authentication/database prompt ......scheme 108165525079033088 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||'-DATABASE-'; s2 := null; s3 := null; s4 := null; s5 := null; wwv_flow_api.create_auth_setup ( p_id=> 108165525079033088 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'Database', p_description=>'Based on authentication scheme from gallery:No Authentication (using DAD)', 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=>'', p_invalid_session_url=>'', p_cookie_name=>'', p_cookie_path=>'', p_cookie_domain=>'', p_use_secure_cookie_yn=>'', p_ldap_host=>'', p_ldap_port=>'', p_ldap_string=>'', p_attribute_01=>'', p_attribute_02=>'', 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