set define off set verify off set feedback off begin wwv_flow.g_import_in_progress := true; end; / --application/set_environment prompt APPLICATION 4950 - XE_ADMIN -- -- Application Export: -- Application: 4950 -- Name: XE_ADMIN -- Date and Time: 09:40 Wednesday August 8, 2012 -- Exported By: -- Flashback: 0 -- Export Type: Application Export -- Version: 4.1.0.00.32 -- Instance ID: 63124222479190 -- Import: -- Using application builder -- or -- Using SQL*Plus as the Oracle user APEX_040200 or as the owner (parsing schema) of the application. -- Application Statistics: -- Pages: 10 -- Items: 11 -- Computations: 3 -- Validations: 9 -- Processes: 7 -- Regions: 26 -- Buttons: 3 -- Dynamic Actions: 0 -- Shared Components -- Breadcrumbs: 1 -- Entries 8 -- Items: 1 -- Computations: 0 -- Processes: 0 -- Parent Tabs: 0 -- Tab Sets: 1 -- Tabs: 6 -- NavBars: 1 -- Lists: 2 -- Shortcuts: 0 -- Themes: 1 -- Templates: -- Page: 4 -- List: 2 -- Report: 2 -- Label: 2 -- Region: 6 -- Messages: 0 -- Build Options: 0 -- 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_040200 or as the owner (parsing schema) of the application. wwv_flow_api.set_security_group_id(p_security_group_id=>nvl(wwv_flow_application_install.get_workspace_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'; 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=>'2011.02.12'); end; / prompt Set Application ID... begin -- SET APPLICATION ID wwv_flow.g_flow_id := nvl(wwv_flow_application_install.get_application_id,4950); wwv_flow_api.g_id_offset := nvl(wwv_flow_application_install.get_offset,0); null; end; / --application/delete_application begin -- Remove Application wwv_flow_api.remove_flow(nvl(wwv_flow_application_install.get_application_id,4950)); end; / begin wwv_flow_audit.remove_audit_trail(nvl(wwv_flow_application_install.get_application_id,4950)); null; end; / --application/create_application begin wwv_flow_api.create_flow( p_id => nvl(wwv_flow_application_install.get_application_id,4950), p_display_id=> nvl(wwv_flow_application_install.get_application_id,4950), p_owner => nvl(wwv_flow_application_install.get_schema,'APEX_040200'), p_name => nvl(wwv_flow_application_install.get_application_name,'XE_ADMIN'), p_alias => nvl(wwv_flow_application_install.get_application_alias,'F4950'), p_page_view_logging => 'YES', p_default_page_template=> 936881728833865360 + wwv_flow_api.g_id_offset, p_printer_friendly_template=> 936882328801865361 + wwv_flow_api.g_id_offset, p_default_region_template=> 936890925366865374 + wwv_flow_api.g_id_offset, p_error_template=> 936880509857865357 + wwv_flow_api.g_id_offset, p_page_protection_enabled_y_n=> 'Y', p_checksum_salt_last_reset => '20120802154608', p_max_session_length_sec=> 28800, p_compatibility_mode=> '4.0', p_home_link=> 'f?p=&APP_ID.:1:&SESSION.', p_flow_language=> 'en', p_flow_language_derived_from=> 'SESSION', p_allow_feedback_yn=> 'N', p_date_format=> 'DS HH24:MI:SS', p_flow_image_prefix => nvl(wwv_flow_application_install.get_image_prefix,'/i/'), p_publish_yn=> 'N', p_documentation_banner=> '', p_authentication=> 'PLUGIN', p_authentication_id=> 936873424775859940 + wwv_flow_api.g_id_offset, p_login_url=> '', p_logout_url=> 'wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:1', p_application_tab_set=> 0, p_logo_image => 'TEXT: Oracle Database XE 11.2', p_public_url_prefix => '', p_public_user=> 'APEX_PUBLIC_USER', p_dbauth_url_prefix => '', p_proxy_server=> nvl(wwv_flow_application_install.get_proxy,''), p_cust_authentication_process=> '', p_cust_authentication_page=> '', p_custom_auth_login_url=> '', p_flow_version=> '&PRODUCT_NAME. 4.2.0.00.27', p_flow_status=> 'AVAILABLE_W_EDIT_LINK', p_flow_unavailable_text=> 'This application is currently unavailable at this time.', p_build_status=> 'RUN_AND_BUILD', p_exact_substitutions_only=> 'Y', p_browser_cache=>'Y', p_browser_frame=>'A', p_vpd=> '', p_vpd_teardown_code=> '', p_security_scheme => 936944301397349617+ wwv_flow_api.g_id_offset, p_csv_encoding=> 'Y', p_auto_time_zone=> 'N', p_default_error_display_loc=> 'INLINE_WITH_FIELD_AND_NOTIFICATION', p_theme_id => 21, p_default_label_template => 936904524832865485 + wwv_flow_api.g_id_offset, p_default_report_template => 936902514655865394 + wwv_flow_api.g_id_offset, p_default_list_template => 936898727314865389 + wwv_flow_api.g_id_offset, p_default_menu_template => 936904805731865485 + wwv_flow_api.g_id_offset, p_default_button_template => 936883817777865362 + wwv_flow_api.g_id_offset, p_default_chart_template => 936887900653865370 + wwv_flow_api.g_id_offset, p_default_form_template => 936888203598865371 + wwv_flow_api.g_id_offset, p_default_wizard_template => 936893605622865377 + wwv_flow_api.g_id_offset, p_default_tabform_template => 936890925366865374 + wwv_flow_api.g_id_offset, p_default_reportr_template =>936890925366865374 + wwv_flow_api.g_id_offset, p_default_menur_template => 936886425092865365 + wwv_flow_api.g_id_offset, p_default_listr_template => 936887629418865370 + wwv_flow_api.g_id_offset, p_default_irr_template => 936889721148865373 + wwv_flow_api.g_id_offset, p_last_updated_by => 'SYSTEM', p_last_upd_yyyymmddhh24miss=> '20120802154608', 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 wwv_flow_api.create_icon_bar_item( p_id => 936873516092859941 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_icon_sequence=> 200, p_icon_image => '', p_icon_subtext=> 'Logout', p_icon_target=> '&LOGOUT_URL.', p_icon_image_alt=> 'Logout', p_icon_height=> 32, p_icon_width=> 32, p_icon_height2=> 24, p_icon_width2=> 24, p_nav_entry_is_feedback_yn => 'N', p_icon_bar_disp_cond=> '', p_icon_bar_disp_cond_type=> 'USER_IS_NOT_PUBLIC_USER', p_begins_on_new_line=> 'NO', p_cell_colspan => 1, p_onclick=> '', p_icon_bar_comment=> ''); end; / prompt ...application processes -- prompt ...application items -- --application/shared_components/logic/application_items/fsp_after_login_url begin wwv_flow_api.create_flow_item( p_id=> 936879119828860198 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'FSP_AFTER_LOGIN_URL', p_data_type=> 'VARCHAR', p_is_persistent=> 'Y', p_protection_level=> '', p_item_comment=> ''); null; end; / prompt ...application level computations -- begin null; end; / prompt ...Application Tabs -- begin --application/shared_components/navigation/tabs/standard/t_home wwv_flow_api.create_tab ( p_id=> 936874932281859972 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'TS1', p_tab_sequence=> 10, p_tab_name=> 'T_HOME', p_tab_text => 'Home', p_tab_step => 1, p_tab_also_current_for_pages => '', p_tab_parent_tabset=>'', p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_storage wwv_flow_api.create_tab ( p_id=> 936875503075859981 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'TS1', p_tab_sequence=> 20, p_tab_name=> 'T_STORAGE', p_tab_text => 'Storage', p_tab_step => 2, p_tab_also_current_for_pages => '9', p_tab_parent_tabset=>'', p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_sessions wwv_flow_api.create_tab ( p_id=> 936876723442859987 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'TS1', p_tab_sequence=> 40, p_tab_name=> 'T_SESSIONS', p_tab_text => 'Sessions', p_tab_step => 4, p_tab_also_current_for_pages => '10', p_tab_parent_tabset=>'', p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_backups wwv_flow_api.create_tab ( p_id=> 936877320524859990 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'TS1', p_tab_sequence=> 50, p_tab_name=> 'T_BACKUPS', p_tab_text => 'Backups', p_tab_step => 5, p_tab_also_current_for_pages => '', p_tab_parent_tabset=>'', p_display_condition_type=> 'NEVER', p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_parameters wwv_flow_api.create_tab ( p_id=> 936877901253859994 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'TS1', p_tab_sequence=> 60, p_tab_name=> 'T_PARAMETERS', p_tab_text => 'Parameters', p_tab_step => 6, p_tab_also_current_for_pages => '', p_tab_parent_tabset=>'', p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_apex wwv_flow_api.create_tab ( p_id=> 936878512390859998 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'TS1', p_tab_sequence=> 70, p_tab_name=> 'T_APEX', p_tab_text => 'Application Express', p_tab_step => 7, p_tab_also_current_for_pages => '', p_tab_parent_tabset=>'', p_tab_comment => ''); end; / prompt ...Application Parent Tabs -- begin null; end; / prompt ...Shared Lists of values -- --application/shared_components/user_interface/lov/create_db_user begin wwv_flow_api.create_list_of_values ( p_id => 15455101519405880 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_lov_name => 'CREATE_DB_USER', p_lov_query=> '.'||to_char(15455101519405880 + wwv_flow_api.g_id_offset)||'.'); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>15455329328405906 + wwv_flow_api.g_id_offset, p_lov_id=>15455101519405880 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>10, p_lov_disp_value=>'Create New', p_lov_return_value=>'NEW', p_lov_data_comment=> ''); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>15455513718405910 + wwv_flow_api.g_id_offset, p_lov_id=>15455101519405880 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>20, p_lov_disp_value=>'Use Existing', p_lov_return_value=>'EXISTING', p_lov_data_comment=> ''); null; end; / --application/shared_components/user_interface/lov/links begin wwv_flow_api.create_list_of_values ( p_id => 937422414360735746 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_lov_name => 'LINKS', p_lov_query=> '.'||to_char(937422414360735746 + wwv_flow_api.g_id_offset)||'.'); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>937422625396735753 + wwv_flow_api.g_id_offset, p_lov_id=>937422414360735746 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>1, p_lov_disp_value=>'Online Help', p_lov_return_value=>'http://www.oracle.com/pls/xe112/homepage ', p_lov_data_comment=> ''); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>937422801110735758 + wwv_flow_api.g_id_offset, p_lov_id=>937422414360735746 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>2, p_lov_disp_value=>'Learning Library', p_lov_return_value=>'http://apex.oracle.com/pls/apex/f?p=44785:1', p_lov_data_comment=> ''); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>937423000487735758 + wwv_flow_api.g_id_offset, p_lov_id=>937422414360735746 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>3, p_lov_disp_value=>'Oracle SQL Developer ', p_lov_return_value=>'http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html', p_lov_data_comment=> ''); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>937423203925735758 + wwv_flow_api.g_id_offset, p_lov_id=>937422414360735746 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>4, p_lov_disp_value=>'Oracle Express Edition', p_lov_return_value=>'http://www.oracle.com/technetwork/database/express-edition/downloads/index.html', p_lov_data_comment=> ''); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>937423417002735758 + wwv_flow_api.g_id_offset, p_lov_id=>937422414360735746 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>5, p_lov_disp_value=>'Oracle Application Express', p_lov_return_value=>'http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html', p_lov_data_comment=> ''); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>937423631042735758 + wwv_flow_api.g_id_offset, p_lov_id=>937422414360735746 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>6, p_lov_disp_value=>'Oracle JDeveloper 11g ', p_lov_return_value=>'http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html', p_lov_data_comment=> ''); null; end; / begin wwv_flow_api.create_static_lov_data ( p_id=>937423821055735758 + wwv_flow_api.g_id_offset, p_lov_id=>937422414360735746 + wwv_flow_api.g_id_offset, p_lov_disp_sequence=>7, p_lov_disp_value=>'Pre-built Developer VMs ', p_lov_return_value=>'http://www.oracle.com/technetwork/community/developer-vm/index.html', p_lov_data_comment=> ''); null; end; / --application/shared_components/user_interface/lov/list_all_database_schemas begin wwv_flow_api.create_list_of_values ( p_id => 937299511375696571 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_lov_name => 'LIST_ALL_DATABASE_SCHEMAS', p_reference_id=> 41061720511468543, p_lov_query=> 'declare q varchar2(32767);'||unistr('\000a')|| ' l_flows_schema varchar2(30) := wwv_flow.g_flow_schema_owner;'||unistr('\000a')|| 'begin'||unistr('\000a')|| ' q := ''select name n, name r from sys.user$ u where type#=1 and name <> ''''''||l_flows_schema||'''''' and name not in (''''HTMLDB_PUBLIC_USER'''',''''PUBLIC_USER'''',''''FLOWS_FILES'''',''''SCHEDULER'''',''''PEOPLE'''',''''APEX_PUBLIC_USER'''')'';'||unistr('\000a')|| ' q := q||'' and name not in (select schema from wwv_flow_restricted_schemas where not exists (select 1 from wwv_flow_rschema_exceptions where schema_id = (select id from wwv_flow_restricted_schemas where schema = u.name))) '';'||unistr('\000a')|| ' q := q||'' and (upper(name) not like ''''FLOWS_%'''' or length(name) != 12 or not REGEXP_LIKE(substr(name,7),''''[0-9]{6}'''')) '';'||unistr('\000a')|| ' q := q||'' and (upper(name) not like ''''APEX_%'''' or length(name) != 11 or not REGEXP_LIKE(substr(name,6),''''[0-9]{6}'''')) '';'||unistr('\000a')|| ' q := q ||'' order by 1'';'||unistr('\000a')|| ' return q;'||unistr('\000a')|| 'end;'); null; end; / prompt ...Application Trees -- --application/pages/page_groups prompt ...page groups -- begin null; end; / --application/pages/page_00000 prompt ...PAGE 0: 0 -- begin wwv_flow_api.create_page ( p_flow_id => wwv_flow.g_flow_id ,p_id => 0 ,p_name => '0' ,p_step_title => '0' ,p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS' ,p_first_item => 'NO_FIRST_ITEM' ,p_include_apex_css_js_yn => 'Y' ,p_cache_page_yn => 'N' ,p_last_updated_by => 'SHAKEEB' ,p_last_upd_yyyymmddhh24miss => '20110701054532' ); null; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||''; wwv_flow_api.create_page_plug ( p_id=> 937217219722611775 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 0, p_plug_name=> 'Global Styles', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 0, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_HEADER', p_plug_source=> s, p_plug_source_type=> 'STATIC_TEXT', p_translate_title=> 'Y', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows => 15, p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / begin null; end; / begin null; end; / begin --------------------------------------- -- ...updatable report columns for page 0 -- begin null; end; null; end; / --application/pages/page_00001 prompt ...PAGE 1: Home -- begin wwv_flow_api.create_page ( p_flow_id => wwv_flow.g_flow_id ,p_id => 1 ,p_tab_set => 'TS1' ,p_name => 'Home' ,p_step_title => 'Home' ,p_allow_duplicate_submissions => 'Y' ,p_step_sub_title => 'Home' ,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 => 'ON' ,p_html_page_header => ''||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| '' ,p_javascript_code_onload => 'loadNews();' ,p_page_is_public_y_n => 'Y' ,p_protection_level => 'N' ,p_cache_page_yn => 'N' ,p_cache_timeout_seconds => 21600 ,p_cache_by_user_yn => 'N' ,p_help_text => 'No help is available for this page.' ,p_page_comment => '' ,p_last_updated_by => 'JOEL' ,p_last_upd_yyyymmddhh24miss => '20110531110540' ); null; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'sys.htp.p(apex_util.get_language_selector_list);'; wwv_flow_api.create_page_plug ( p_id=> 5282314929679031 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_plug_name=> 'Language Selector', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 0, p_plug_display_sequence=> 50, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_05', p_plug_source=> s, p_plug_source_type=> 'PLSQL_PROCEDURE', p_translate_title=> 'Y', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 8539302203854106 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_plug_name=> 'Main Links', p_region_name=>'mainlinks', p_region_attributes=> 'style="width: 66%; float: left; margin-right: 1%"', p_escape_on_http_output=>'N', p_plug_template=> 936891504925865375+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 5, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 8538002419844773 + wwv_flow_api.g_id_offset, p_list_template_id=> 8548028083899041+ wwv_flow_api.g_id_offset, p_translate_title=> 'Y', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'
'; wwv_flow_api.create_page_plug ( p_id=> 937226916671790631 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_plug_name=> 'News', p_region_name=>'', p_region_attributes=> 'style="width: 49%; float: left; margin-right: 1%"', p_escape_on_http_output=>'N', p_plug_template=> 936890925366865374+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 30, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'STATIC_TEXT', p_translate_title=> 'Y', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'COLON_DELMITED_LIST', p_plug_query_num_rows => 15, p_plug_query_row_count_max => 500, p_plug_display_condition_type => '', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'
'; wwv_flow_api.create_page_plug ( p_id=> 937248222454359940 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_plug_name=> 'OTN News', p_region_name=>'', p_region_attributes=> 'style="clear: none; width: 50%; _width: 48%; float: left;"', p_escape_on_http_output=>'N', p_plug_template=> 936890925366865374+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 40, 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_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows => 15, p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 937441813363811043 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_plug_name=> 'Links', p_region_name=>'tasksregion', p_region_attributes=> 'style="float: left; clear: none; width: 33%; _width: 31%;"', p_escape_on_http_output=>'N', p_plug_template=> 936892120369865376+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 11, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 937440212637810959 + wwv_flow_api.g_id_offset, p_translate_title=> 'Y', 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 declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'declare'||unistr('\000a')|| ' l_secure_vc varchar2(1) := null;'||unistr('\000a')|| 'begin'||unistr('\000a')|| ' sys.htp.init;'||unistr('\000a')|| ' sys.owa_util.mime_header(''text/html'', FALSE);'||unistr('\000a')|| ' sys.htp.p(''Access-Control-Allow-Credentials: true'');'||unistr('\000a')|| ''||unistr('\000a')|| ' sys.htp.p(''Access-Control-Allow-Origin: http://www.oracle.com'');'||unistr('\000a')|| ' sys.htp.p(''Access-Control-Allow-Methods: GET'');'||unistr('\000a')|| ''||unistr('\000a')|| ' if nvl(:REQUEST,''X'') = ''CREATE_WORKSPACE'' then'||unistr('\000a')|| ' if nvl(wwv_flow_platform.get_prefe'; p:=p||'rence( p_preference_name => ''REQUIRE_HTTPS'' ),''N'') = ''Y'' then'||unistr('\000a')|| ' l_secure_vc := ''Y'';'||unistr('\000a')|| ' end if;'||unistr('\000a')|| ''||unistr('\000a')|| ' if nvl(wwv_flow_platform.get_preference(''WORKSPACE_NAME_USER_COOKIE''),''Y'') = ''Y'' then'||unistr('\000a')|| ' owa_cookie.send('||unistr('\000a')|| ' name=>''ORA_WWV_REMEMBER_UN'','||unistr('\000a')|| ' value=>upper(:P7_APEX_USERNAME)||'':''||:P7_DATABASE_SCHEMA,'||unistr('\000a')|| ' expires=> sysdate+180,'||unistr('\000a')|| ' '; p:=p||' path=> owa_util.get_cgi_env(''SCRIPT_NAME''),'||unistr('\000a')|| ' secure=> l_secure_vc);'||unistr('\000a')|| ' end if;'||unistr('\000a')|| ' end if;'||unistr('\000a')|| ''||unistr('\000a')|| ' sys.owa_util.http_header_close;'||unistr('\000a')|| 'end;'; wwv_flow_api.create_page_process( p_id => 937602027170839803 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 1, p_process_sequence=> 10, p_process_point=> 'BEFORE_HEADER', p_process_type=> 'PLSQL', p_process_name=> 'Set Cookie and Origin', p_process_sql_clob => p, p_process_error_message=> '', p_error_display_location=> 'ON_ERROR_PAGE', p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin --------------------------------------- -- ...updatable report columns for page 1 -- begin null; end; null; end; / --application/pages/page_00002 prompt ...PAGE 2: Storage -- begin wwv_flow_api.create_page ( p_flow_id => wwv_flow.g_flow_id ,p_id => 2 ,p_tab_set => 'TS1' ,p_name => 'Storage' ,p_step_title => 'Storage' ,p_allow_duplicate_submissions => 'Y' ,p_step_sub_title => 'Storage' ,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 => 'ON' ,p_required_role => 936944301397349617 + wwv_flow_api.g_id_offset ,p_page_is_public_y_n => 'N' ,p_protection_level => 'N' ,p_cache_page_yn => 'N' ,p_cache_timeout_seconds => 21600 ,p_cache_by_user_yn => 'N' ,p_help_text => 'No help is available for this page.' ,p_last_updated_by => 'JOEL' ,p_last_upd_yyyymmddhh24miss => '20110302134113' ); null; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 936875820119859983 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_plug_name=> 'Breadcrumbs', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936886425092865365+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 1, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 'M'|| to_char(936874627069859959 + wwv_flow_api.g_id_offset), p_menu_template_id=> 936904805731865485+ 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_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||'select a.tablespace_name ,'||unistr('\000a')|| ' round(nvl(b.bytes_free, 0) / 1024 / 1024) megs_free,'||unistr('\000a')|| ' round((a.bytes_alloc - nvl(b.bytes_free, 0)) / 1024 / 1024) megs_used,'||unistr('\000a')|| ' 100 - round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_used,'||unistr('\000a')|| ' round(maxbytes/1048576) Max'||unistr('\000a')|| 'from ( select f.tablespace_name,'||unistr('\000a')|| ' sum(f.bytes) bytes_alloc,'||unistr('\000a')|| ' sum(decode(f.autoextensible, ''YES'; s:=s||''',f.maxbytes,''NO'', f.bytes)) maxbytes'||unistr('\000a')|| ' from dba_data_files f'||unistr('\000a')|| ' group by tablespace_name) a,'||unistr('\000a')|| ' ( select f.tablespace_name,'||unistr('\000a')|| ' sum(f.bytes) bytes_free'||unistr('\000a')|| ' from dba_free_space f'||unistr('\000a')|| ' group by tablespace_name) b'||unistr('\000a')|| 'where a.tablespace_name = b.tablespace_name (+)'||unistr('\000a')|| 'union all'||unistr('\000a')|| 'select '||unistr('\000a')|| 'h.tablespace_name,'||unistr('\000a')|| ' round(sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)'; s:=s||') / 1048576) megs_free,'||unistr('\000a')|| ' round(sum(nvl(p.bytes_used, 0))/ 1048576) megs_used,'||unistr('\000a')|| ' 100 - round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100) pct_used,'||unistr('\000a')|| ' round(sum(f.maxbytes) / 1048576) max'||unistr('\000a')|| 'from sys.v_$TEMP_SPACE_HEADER h, sys.v_$Temp_extent_pool p, dba_temp_files f'||unistr('\000a')|| 'where p.file_id(+) = h.file_id'||unistr('\000a')|| 'and p.tablespace_name(+) = '; s:=s||'h.tablespace_name'||unistr('\000a')|| 'and f.file_id = h.file_id'||unistr('\000a')|| 'and f.tablespace_name = h.tablespace_name'||unistr('\000a')|| 'group by h.tablespace_name'; wwv_flow_api.create_page_plug ( p_id=> 937123318739076710 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_plug_name=> 'Tablespace Usage in Megabytes', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 0, p_plug_display_sequence=> 11, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'DYNAMIC_QUERY', p_translate_title=> 'Y', p_rest_enabled=> 'N', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'COLON_DELMITED_LIST', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare a1 varchar2(32767) := null; begin a1:=a1||'select a.tablespace_name ,'||unistr('\000a')|| ' round(nvl(b.bytes_free, 0) / 1024 / 1024) megs_free,'||unistr('\000a')|| ' round((a.bytes_alloc - nvl(b.bytes_free, 0)) / 1024 / 1024) megs_used,'||unistr('\000a')|| ' 100 - round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_used,'||unistr('\000a')|| ' round(maxbytes/1048576) Max'||unistr('\000a')|| 'from ( select f.tablespace_name,'||unistr('\000a')|| ' sum(f.bytes) bytes_alloc,'||unistr('\000a')|| ' sum(decode(f.autoextensible, ''YES'; a1:=a1||''',f.maxbytes,''NO'', f.bytes)) maxbytes'||unistr('\000a')|| ' from dba_data_files f'||unistr('\000a')|| ' group by tablespace_name) a,'||unistr('\000a')|| ' ( select f.tablespace_name,'||unistr('\000a')|| ' sum(f.bytes) bytes_free'||unistr('\000a')|| ' from dba_free_space f'||unistr('\000a')|| ' group by tablespace_name) b'||unistr('\000a')|| 'where a.tablespace_name = b.tablespace_name (+)'||unistr('\000a')|| 'union all'||unistr('\000a')|| 'select '||unistr('\000a')|| 'h.tablespace_name,'||unistr('\000a')|| ' round(sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)'; a1:=a1||') / 1048576) megs_free,'||unistr('\000a')|| ' round(sum(nvl(p.bytes_used, 0))/ 1048576) megs_used,'||unistr('\000a')|| ' 100 - round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100) pct_used,'||unistr('\000a')|| ' round(sum(f.maxbytes) / 1048576) max'||unistr('\000a')|| 'from sys.v_$TEMP_SPACE_HEADER h, sys.v_$Temp_extent_pool p, dba_temp_files f'||unistr('\000a')|| 'where p.file_id(+) = h.file_id'||unistr('\000a')|| 'and p.tablespace_name(+) = '; a1:=a1||'h.tablespace_name'||unistr('\000a')|| 'and f.file_id = h.file_id'||unistr('\000a')|| 'and f.tablespace_name = h.tablespace_name'||unistr('\000a')|| 'group by h.tablespace_name'; wwv_flow_api.create_worksheet( p_id=> 937123400172076710+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_region_id=> 937123318739076710+wwv_flow_api.g_id_offset, p_name=> 'Tablespace Usage', p_folder_id=> null, p_alias=> '', p_report_id_item=> '', p_max_row_count=> '10000', p_max_row_count_message=> 'This query returns more than #MAX_ROW_COUNT# rows, please filter your data to ensure complete results.', p_no_data_found_message=> 'No data found.', p_max_rows_per_page=>'', p_search_button_label=>'', p_sort_asc_image=>'', p_sort_asc_image_attr=>'', p_sort_desc_image=>'', p_sort_desc_image_attr=>'', p_sql_query => a1, p_status=>'AVAILABLE_FOR_OWNER', p_allow_report_saving=>'Y', p_allow_save_rpt_public=>'N', p_allow_report_categories=>'N', p_show_nulls_as=>'-', p_pagination_type=>'ROWS_X_TO_Y', p_pagination_display_pos=>'BOTTOM_RIGHT', p_show_finder_drop_down=>'Y', p_show_display_row_count=>'N', p_show_search_bar=>'Y', p_show_search_textbox=>'Y', p_show_actions_menu=>'Y', p_report_list_mode=>'TABS', p_show_detail_link=>'N', p_show_select_columns=>'Y', p_show_rows_per_page=>'Y', p_show_filter=>'Y', p_show_sort=>'Y', p_show_control_break=>'Y', p_show_highlight=>'Y', p_show_computation=>'Y', p_show_aggregate=>'Y', p_show_chart=>'Y', p_show_group_by=>'Y', p_show_notify=>'N', p_show_calendar=>'N', p_show_flashback=>'N', p_show_reset=>'Y', p_show_download=>'Y', p_show_help=>'Y', p_download_formats=>'CSV:HTML:EMAIL', p_allow_exclude_null_values=>'N', p_allow_hide_extra_columns=>'N', p_icon_view_enabled_yn=>'N', p_icon_view_columns_per_row=>1, p_detail_view_enabled_yn=>'N', p_owner=>'JOEL'); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937123622755076834+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_worksheet_id => 937123400172076710+wwv_flow_api.g_id_offset, p_db_column_name =>'TABLESPACE_NAME', p_display_order =>1, p_column_identifier =>'A', p_column_label =>'Tablespace', p_report_label =>'Tablespace', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_column_link =>'f?p=&APP_ID.:9:&SESSION.::&DEBUG.:RP,9:P9_TBLSPACE_NAME:#TABLESPACE_NAME#', p_column_linktext =>'#TABLESPACE_NAME#', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937123831064076836+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_worksheet_id => 937123400172076710+wwv_flow_api.g_id_offset, p_db_column_name =>'MEGS_FREE', p_display_order =>3, p_column_identifier =>'C', p_column_label =>'Free Space (MB)', p_report_label =>'Free Space (MB)', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'NUMBER', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'RIGHT', p_format_mask =>'999G999G999G999G999G999G990', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937123927304076836+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_worksheet_id => 937123400172076710+wwv_flow_api.g_id_offset, p_db_column_name =>'MEGS_USED', p_display_order =>4, p_column_identifier =>'D', p_column_label =>'Used Space (MB)', p_report_label =>'Used Space (MB)', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'NUMBER', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'RIGHT', p_format_mask =>'999G999G999G999G999G999G990', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937124125278076836+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_worksheet_id => 937123400172076710+wwv_flow_api.g_id_offset, p_db_column_name =>'PCT_USED', p_display_order =>6, p_column_identifier =>'F', p_column_label =>'Percent Used', p_report_label =>'Percent Used', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'NUMBER', p_display_as =>'TEXT', p_display_text_as =>'WITHOUT_MODIFICATION', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_format_mask =>'PCT_GRAPH:cccccc:777777:150', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937124221148076837+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_worksheet_id => 937123400172076710+wwv_flow_api.g_id_offset, p_db_column_name =>'MAX', p_display_order =>7, p_column_identifier =>'G', p_column_label =>'Maximum (MB)', p_report_label =>'Maximum (MB)', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'NUMBER', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'RIGHT', p_format_mask =>'999G999G999G999G999G999G990', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / declare rc1 varchar2(32767) := null; begin rc1:=rc1||'TABLESPACE_NAME:MEGS_ALLOC:MEGS_FREE:MEGS_USED:PCT_FREE:PCT_USED:MAX'; wwv_flow_api.create_worksheet_rpt( p_id => 937124405338077122+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_worksheet_id => 937123400172076710+wwv_flow_api.g_id_offset, p_session_id => null, p_base_report_id => null+wwv_flow_api.g_id_offset, p_application_user => 'APXWS_DEFAULT', p_report_seq =>10, p_report_alias =>'9371245', p_status =>'PUBLIC', p_category_id =>null+wwv_flow_api.g_id_offset, p_is_default =>'Y', p_display_rows =>15, p_report_columns =>rc1, p_sort_column_1 =>'MEGS_USED', p_sort_direction_1 =>'DESC', p_sort_column_2 =>'PCT_USED', p_sort_direction_2 =>'DESC', p_flashback_enabled =>'N', p_calendar_display_column =>''); end; / begin null; end; / begin null; end; / begin --------------------------------------- -- ...updatable report columns for page 2 -- begin null; end; null; end; / --application/pages/page_00004 prompt ...PAGE 4: Sessions -- begin wwv_flow_api.create_page ( p_flow_id => wwv_flow.g_flow_id ,p_id => 4 ,p_tab_set => 'TS1' ,p_name => 'Sessions' ,p_step_title => 'Sessions' ,p_allow_duplicate_submissions => 'Y' ,p_step_sub_title => 'Sessions' ,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 => 'ON' ,p_required_role => 936944301397349617 + wwv_flow_api.g_id_offset ,p_page_is_public_y_n => 'N' ,p_protection_level => 'N' ,p_cache_page_yn => 'N' ,p_cache_timeout_seconds => 21600 ,p_cache_by_user_yn => 'N' ,p_help_text => 'No help is available for this page.' ,p_last_updated_by => 'JOEL' ,p_last_upd_yyyymmddhh24miss => '20110302103909' ); null; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 936877028529859988 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_plug_name=> 'Breadcrumbs', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936886425092865365+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 1, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 'M'|| to_char(936874627069859959 + wwv_flow_api.g_id_offset), p_menu_template_id=> 936904805731865485+ 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_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||'with vs as (select rownum rnum,'||unistr('\000a')|| ' sid,'||unistr('\000a')|| ' serial#,'||unistr('\000a')|| ' status,'||unistr('\000a')|| ' username,'||unistr('\000a')|| ' '; s:=s||' last_call_et,'||unistr('\000a')|| ' command,'||unistr('\000a')|| ' machine,'||unistr('\000a')|| ' osuser,'||unistr('\000a')|| ' '; s:=s||' module,'||unistr('\000a')|| ' action,'||unistr('\000a')|| ' resource_consumer_group,'||unistr('\000a')|| ' client_info,'||unistr('\000a')|| ' client_identifier,'||unistr('\000a')|| ' '; s:=s||' type,'||unistr('\000a')|| ' terminal'||unistr('\000a')|| ' from v$session) '||unistr('\000a')|| ' select vs.sid ,serial# serial,'||unistr('\000a')|| ' '; s:=s||' vs.username "Username",'||unistr('\000a')|| ' case when vs.status = ''ACTIVE'' '||unistr('\000a')|| ' then last_call_et '||unistr('\000a')|| ' else null end "Seconds in Wait",'||unistr('\000a')|| ' '; s:=s||' decode(vs.command, '||unistr('\000a')|| ' 0,null, '||unistr('\000a')|| ' 1,''CRE TAB'', '||unistr('\000a')|| ' 2,''INSERT'', '||unistr('\000a')|| ' 3,''SELECT'', '||unistr('\000a')|| ' '; s:=s||' 4,''CRE CLUSTER'', '||unistr('\000a')|| ' 5,''ALT CLUSTER'', '||unistr('\000a')|| ' 6,''UPDATE'', '||unistr('\000a')|| ' 7,''DELETE'', '||unistr('\000a')|| ' 8,''DRP CLUSTER'', '||unistr('\000a')|| ' '; s:=s||' 9,''CRE INDEX'', '||unistr('\000a')|| ' 10,''DROP INDEX'', '||unistr('\000a')|| ' 11,''ALT INDEX'', '||unistr('\000a')|| ' 12,''DROP TABLE'', '||unistr('\000a')|| ' 13,''CRE '; s:=s||'SEQ'', '||unistr('\000a')|| ' 14,''ALT SEQ'', '||unistr('\000a')|| ' 15,''ALT TABLE'', '||unistr('\000a')|| ' 16,''DROP SEQ'', '||unistr('\000a')|| ' 17,''GRANT'', '||unistr('\000a')|| ' '; s:=s||' 18,''REVOKE'', '||unistr('\000a')|| ' 19,''CRE SYN'', '||unistr('\000a')|| ' 20,''DROP SYN'', '||unistr('\000a')|| ' 21,''CRE VIEW'', '||unistr('\000a')|| ' 22,''DROP VIEW'', '||unistr('\000a')|| ' '; s:=s||' 23,''VAL INDEX'', '||unistr('\000a')|| ' 24,''CRE PROC'', '||unistr('\000a')|| ' 25,''ALT PROC'', '||unistr('\000a')|| ' 26,''LOCK TABLE'', '||unistr('\000a')|| ' 28,''RENAME'', '||unistr('\000a')|| ' '; s:=s||' 29,''COMMENT'', '||unistr('\000a')|| ' 30,''AUDIT'', '||unistr('\000a')|| ' 31,''NOAUDIT'', '||unistr('\000a')|| ' 32,''CRE DBLINK'', '||unistr('\000a')|| ' 3'; s:=s||'3,''DROP DBLINK'', '||unistr('\000a')|| ' 34,''CRE DB'', '||unistr('\000a')|| ' 35,''ALTER DB'', '||unistr('\000a')|| ' 36,''CRE RBS'', '||unistr('\000a')|| ' 37,''ALT RBS'', '||unistr('\000a')|| ' '; s:=s||' 38,''DROP RBS'', '||unistr('\000a')|| ' 39,''CRE TBLSPC'', '||unistr('\000a')|| ' 40,''ALT TBLSPC'', '||unistr('\000a')|| ' 41,''DROP TBLSPC'', '||unistr('\000a')|| ' 42,''ALT SESSION'', '||unistr('\000a')|| ' '; s:=s||' 43,''ALT USER'', '||unistr('\000a')|| ' 44,''COMMIT'', '||unistr('\000a')|| ' 45,''ROLLBACK'', '||unistr('\000a')|| ' 46,''SAVEPOINT'', '||unistr('\000a')|| ' 47,'; s:=s||'''PL/SQL EXEC'', '||unistr('\000a')|| ' 48,''SET XACTN'', '||unistr('\000a')|| ' 49,''SWITCH LOG'', '||unistr('\000a')|| ' 50,''EXPLAIN'', '||unistr('\000a')|| ' 51,''CRE USER'', '||unistr('\000a')|| ' '; s:=s||' 52,''CRE ROLE'', '||unistr('\000a')|| ' 53,''DROP USER'', '||unistr('\000a')|| ' 54,''DROP ROLE'', '||unistr('\000a')|| ' 55,''SET ROLE'', '||unistr('\000a')|| ' 56,''CRE SCHEMA'', '||unistr('\000a')|| ' '; s:=s||' 57,''CRE CTLFILE'', '||unistr('\000a')|| ' 58,''ALTER TRACING'', '||unistr('\000a')|| ' 59,''CRE TRIGGER'', '||unistr('\000a')|| ' 60,''ALT TRIGGER'', '||unistr('\000a')|| ' '; s:=s||' 61,''DRP TRIGGER'', '||unistr('\000a')|| ' 62,''ANALYZE TAB'', '||unistr('\000a')|| ' 63,''ANALYZE IX'', '||unistr('\000a')|| ' 64,''ANALYZE CLUS'', '||unistr('\000a')|| ' 65,''CRE PROFILE'', '||unistr('\000a')|| ' '; s:=s||' 66,''DRP PROFILE'', '||unistr('\000a')|| ' 67,''ALT PROFILE'', '||unistr('\000a')|| ' 68,''DRP PROC'', '||unistr('\000a')|| ' 69,''DRP PROC'', '||unistr('\000a')|| ' 70,'''; s:=s||'ALT RESOURCE'', '||unistr('\000a')|| ' 71,''CRE SNPLOG'', '||unistr('\000a')|| ' 72,''ALT SNPLOG'', '||unistr('\000a')|| ' 73,''DROP SNPLOG'', '||unistr('\000a')|| ' 74,''CREATE SNAP'', '||unistr('\000a')|| ' '; s:=s||' 75,''ALT SNAP'', '||unistr('\000a')|| ' 76,''DROP SNAP'', '||unistr('\000a')|| ' 79,''ALTER ROLE'', '||unistr('\000a')|| ' 79,''ALTER ROLE'', '||unistr('\000a')|| ' 85,''TRUNC TAB'', '||unistr('\000a')|| ' '; s:=s||' 86,''TRUNC CLUST'', '||unistr('\000a')|| ' 88,''ALT VIEW'', '||unistr('\000a')|| ' 91,''CRE FUNC'', '||unistr('\000a')|| ' 92,''ALT FUNC'', '||unistr('\000a')|| ' '; s:=s||' 93,''DROP FUNC'', '||unistr('\000a')|| ' 94,''CRE PKG'', '||unistr('\000a')|| ' 95,''ALT PKG'', '||unistr('\000a')|| ' 96,''DROP PKG'', '||unistr('\000a')|| ' 97,''CRE PKG BODY'', '||unistr('\000a')|| ' '; s:=s||' 98,''ALT PKG BODY'', '||unistr('\000a')|| ' 99,''DRP PKG BODY'', '||unistr('\000a')|| ' to_char(vs.command)) "Command",'||unistr('\000a')|| ' vs.machine "Machine",'||unistr('\000a')|| ' '; s:=s||' vs.osuser "OS User", '||unistr('\000a')|| ' lower(vs.status) "Status",'||unistr('\000a')|| ' vs.module "Module",'||unistr('\000a')|| ' vs.action "Action",'||unistr('\000a')|| ' vs.resource_consumer_group,'||unistr('\000a')|| ' '; s:=s||' vs.client_info,'||unistr('\000a')|| ' vs.client_identifier'||unistr('\000a')|| ' from vs '||unistr('\000a')|| ' where vs.USERNAME is not null'||unistr('\000a')|| ' and n'; s:=s||'vl(vs.osuser,''x'') <> ''SYSTEM'''||unistr('\000a')|| ' and vs.type <> ''BACKGROUND'''||unistr('\000a')|| ' order by 1'; wwv_flow_api.create_page_plug ( p_id=> 937084424859177512 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_plug_name=> 'Sessions', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936889721148865373+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 11, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'DYNAMIC_QUERY', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'COLON_DELMITED_LIST', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare a1 varchar2(32767) := null; begin a1:=a1||'with vs as (select rownum rnum,'||unistr('\000a')|| ' sid,'||unistr('\000a')|| ' serial#,'||unistr('\000a')|| ' status,'||unistr('\000a')|| ' username,'||unistr('\000a')|| ' '; a1:=a1||' last_call_et,'||unistr('\000a')|| ' command,'||unistr('\000a')|| ' machine,'||unistr('\000a')|| ' osuser,'||unistr('\000a')|| ' '; a1:=a1||' module,'||unistr('\000a')|| ' action,'||unistr('\000a')|| ' resource_consumer_group,'||unistr('\000a')|| ' client_info,'||unistr('\000a')|| ' client_identifier,'||unistr('\000a')|| ' '; a1:=a1||' type,'||unistr('\000a')|| ' terminal'||unistr('\000a')|| ' from v$session) '||unistr('\000a')|| ' select vs.sid ,serial# serial,'||unistr('\000a')|| ' '; a1:=a1||' vs.username "Username",'||unistr('\000a')|| ' case when vs.status = ''ACTIVE'' '||unistr('\000a')|| ' then last_call_et '||unistr('\000a')|| ' else null end "Seconds in Wait",'||unistr('\000a')|| ' '; a1:=a1||' decode(vs.command, '||unistr('\000a')|| ' 0,null, '||unistr('\000a')|| ' 1,''CRE TAB'', '||unistr('\000a')|| ' 2,''INSERT'', '||unistr('\000a')|| ' 3,''SELECT'', '||unistr('\000a')|| ' '; a1:=a1||' 4,''CRE CLUSTER'', '||unistr('\000a')|| ' 5,''ALT CLUSTER'', '||unistr('\000a')|| ' 6,''UPDATE'', '||unistr('\000a')|| ' 7,''DELETE'', '||unistr('\000a')|| ' 8,''DRP CLUSTER'', '||unistr('\000a')|| ' '; a1:=a1||' 9,''CRE INDEX'', '||unistr('\000a')|| ' 10,''DROP INDEX'', '||unistr('\000a')|| ' 11,''ALT INDEX'', '||unistr('\000a')|| ' 12,''DROP TABLE'', '||unistr('\000a')|| ' 13,''CRE '; a1:=a1||'SEQ'', '||unistr('\000a')|| ' 14,''ALT SEQ'', '||unistr('\000a')|| ' 15,''ALT TABLE'', '||unistr('\000a')|| ' 16,''DROP SEQ'', '||unistr('\000a')|| ' 17,''GRANT'', '||unistr('\000a')|| ' '; a1:=a1||' 18,''REVOKE'', '||unistr('\000a')|| ' 19,''CRE SYN'', '||unistr('\000a')|| ' 20,''DROP SYN'', '||unistr('\000a')|| ' 21,''CRE VIEW'', '||unistr('\000a')|| ' 22,''DROP VIEW'', '||unistr('\000a')|| ' '; a1:=a1||' 23,''VAL INDEX'', '||unistr('\000a')|| ' 24,''CRE PROC'', '||unistr('\000a')|| ' 25,''ALT PROC'', '||unistr('\000a')|| ' 26,''LOCK TABLE'', '||unistr('\000a')|| ' 28,''RENAME'', '||unistr('\000a')|| ' '; a1:=a1||' 29,''COMMENT'', '||unistr('\000a')|| ' 30,''AUDIT'', '||unistr('\000a')|| ' 31,''NOAUDIT'', '||unistr('\000a')|| ' 32,''CRE DBLINK'', '||unistr('\000a')|| ' 3'; a1:=a1||'3,''DROP DBLINK'', '||unistr('\000a')|| ' 34,''CRE DB'', '||unistr('\000a')|| ' 35,''ALTER DB'', '||unistr('\000a')|| ' 36,''CRE RBS'', '||unistr('\000a')|| ' 37,''ALT RBS'', '||unistr('\000a')|| ' '; a1:=a1||' 38,''DROP RBS'', '||unistr('\000a')|| ' 39,''CRE TBLSPC'', '||unistr('\000a')|| ' 40,''ALT TBLSPC'', '||unistr('\000a')|| ' 41,''DROP TBLSPC'', '||unistr('\000a')|| ' 42,''ALT SESSION'', '||unistr('\000a')|| ' '; a1:=a1||' 43,''ALT USER'', '||unistr('\000a')|| ' 44,''COMMIT'', '||unistr('\000a')|| ' 45,''ROLLBACK'', '||unistr('\000a')|| ' 46,''SAVEPOINT'', '||unistr('\000a')|| ' 47,'; a1:=a1||'''PL/SQL EXEC'', '||unistr('\000a')|| ' 48,''SET XACTN'', '||unistr('\000a')|| ' 49,''SWITCH LOG'', '||unistr('\000a')|| ' 50,''EXPLAIN'', '||unistr('\000a')|| ' 51,''CRE USER'', '||unistr('\000a')|| ' '; a1:=a1||' 52,''CRE ROLE'', '||unistr('\000a')|| ' 53,''DROP USER'', '||unistr('\000a')|| ' 54,''DROP ROLE'', '||unistr('\000a')|| ' 55,''SET ROLE'', '||unistr('\000a')|| ' 56,''CRE SCHEMA'', '||unistr('\000a')|| ' '; a1:=a1||' 57,''CRE CTLFILE'', '||unistr('\000a')|| ' 58,''ALTER TRACING'', '||unistr('\000a')|| ' 59,''CRE TRIGGER'', '||unistr('\000a')|| ' 60,''ALT TRIGGER'', '||unistr('\000a')|| ' '; a1:=a1||' 61,''DRP TRIGGER'', '||unistr('\000a')|| ' 62,''ANALYZE TAB'', '||unistr('\000a')|| ' 63,''ANALYZE IX'', '||unistr('\000a')|| ' 64,''ANALYZE CLUS'', '||unistr('\000a')|| ' 65,''CRE PROFILE'', '||unistr('\000a')|| ' '; a1:=a1||' 66,''DRP PROFILE'', '||unistr('\000a')|| ' 67,''ALT PROFILE'', '||unistr('\000a')|| ' 68,''DRP PROC'', '||unistr('\000a')|| ' 69,''DRP PROC'', '||unistr('\000a')|| ' 70,'''; a1:=a1||'ALT RESOURCE'', '||unistr('\000a')|| ' 71,''CRE SNPLOG'', '||unistr('\000a')|| ' 72,''ALT SNPLOG'', '||unistr('\000a')|| ' 73,''DROP SNPLOG'', '||unistr('\000a')|| ' 74,''CREATE SNAP'', '||unistr('\000a')|| ' '; a1:=a1||' 75,''ALT SNAP'', '||unistr('\000a')|| ' 76,''DROP SNAP'', '||unistr('\000a')|| ' 79,''ALTER ROLE'', '||unistr('\000a')|| ' 79,''ALTER ROLE'', '||unistr('\000a')|| ' 85,''TRUNC TAB'', '||unistr('\000a')|| ' '; a1:=a1||' 86,''TRUNC CLUST'', '||unistr('\000a')|| ' 88,''ALT VIEW'', '||unistr('\000a')|| ' 91,''CRE FUNC'', '||unistr('\000a')|| ' 92,''ALT FUNC'', '||unistr('\000a')|| ' '; a1:=a1||' 93,''DROP FUNC'', '||unistr('\000a')|| ' 94,''CRE PKG'', '||unistr('\000a')|| ' 95,''ALT PKG'', '||unistr('\000a')|| ' 96,''DROP PKG'', '||unistr('\000a')|| ' 97,''CRE PKG BODY'', '||unistr('\000a')|| ' '; a1:=a1||' 98,''ALT PKG BODY'', '||unistr('\000a')|| ' 99,''DRP PKG BODY'', '||unistr('\000a')|| ' to_char(vs.command)) "Command",'||unistr('\000a')|| ' vs.machine "Machine",'||unistr('\000a')|| ' '; a1:=a1||' vs.osuser "OS User", '||unistr('\000a')|| ' lower(vs.status) "Status",'||unistr('\000a')|| ' vs.module "Module",'||unistr('\000a')|| ' vs.action "Action",'||unistr('\000a')|| ' vs.resource_consumer_group,'||unistr('\000a')|| ' '; a1:=a1||' vs.client_info,'||unistr('\000a')|| ' vs.client_identifier'||unistr('\000a')|| ' from vs '||unistr('\000a')|| ' where vs.USERNAME is not null'||unistr('\000a')|| ' and n'; a1:=a1||'vl(vs.osuser,''x'') <> ''SYSTEM'''||unistr('\000a')|| ' and vs.type <> ''BACKGROUND'''||unistr('\000a')|| ' order by 1'; wwv_flow_api.create_worksheet( p_id=> 937084525148177512+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_region_id=> 937084424859177512+wwv_flow_api.g_id_offset, p_name=> 'Sessions', p_folder_id=> null, p_alias=> '', p_report_id_item=> '', p_max_row_count=> '10000', p_max_row_count_message=> 'This query returns more than #MAX_ROW_COUNT# rows, please filter your data to ensure complete results.', p_no_data_found_message=> 'No data found.', p_max_rows_per_page=>'', p_search_button_label=>'', p_sort_asc_image=>'', p_sort_asc_image_attr=>'', p_sort_desc_image=>'', p_sort_desc_image_attr=>'', p_sql_query => a1, p_status=>'AVAILABLE_FOR_OWNER', p_allow_report_saving=>'Y', p_allow_save_rpt_public=>'N', p_allow_report_categories=>'N', p_show_nulls_as=>'-', p_pagination_type=>'ROWS_X_TO_Y', p_pagination_display_pos=>'BOTTOM_RIGHT', p_show_finder_drop_down=>'Y', p_show_display_row_count=>'N', p_show_search_bar=>'Y', p_show_search_textbox=>'Y', p_show_actions_menu=>'Y', p_report_list_mode=>'TABS', p_show_detail_link=>'N', p_show_select_columns=>'Y', p_show_rows_per_page=>'Y', p_show_filter=>'Y', p_show_sort=>'Y', p_show_control_break=>'Y', p_show_highlight=>'Y', p_show_computation=>'Y', p_show_aggregate=>'Y', p_show_chart=>'Y', p_show_group_by=>'Y', p_show_notify=>'N', p_show_calendar=>'N', p_show_flashback=>'N', p_show_reset=>'Y', p_show_download=>'Y', p_show_help=>'Y', p_download_formats=>'CSV:HTML:EMAIL', p_allow_exclude_null_values=>'N', p_allow_hide_extra_columns=>'N', p_icon_view_enabled_yn=>'N', p_icon_view_columns_per_row=>1, p_detail_view_enabled_yn=>'N', p_owner=>'KRIS'); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937084714206177530+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'SID', p_display_order =>1, p_column_identifier =>'A', p_column_label =>'SID', p_report_label =>'SID', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_column_link =>'f?p=&APP_ID.:10:&SESSION.::&DEBUG.:RP,10:P10_SID:#SID#', p_column_linktext =>'#SID#', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'NUMBER', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'RIGHT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937084821572177531+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'SERIAL', p_display_order =>2, p_column_identifier =>'B', p_column_label =>'Serial #', p_report_label =>'Serial #', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'NUMBER', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'RIGHT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937084921797177531+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'Username', p_display_order =>3, p_column_identifier =>'C', p_column_label =>'Username', p_report_label =>'Username', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937085007212177531+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'Seconds in Wait', p_display_order =>4, p_column_identifier =>'D', p_column_label =>'Seconds In Wait', p_report_label =>'Seconds In Wait', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'NUMBER', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'RIGHT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937085118986177531+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'Command', p_display_order =>5, p_column_identifier =>'E', p_column_label =>'Command', p_report_label =>'Command', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937085208663177532+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'Machine', p_display_order =>6, p_column_identifier =>'F', p_column_label =>'Machine', p_report_label =>'Machine', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937085311673177532+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'OS User', p_display_order =>7, p_column_identifier =>'G', p_column_label =>'OS User', p_report_label =>'OS User', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937085416800177532+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'Status', p_display_order =>8, p_column_identifier =>'H', p_column_label =>'Status', p_report_label =>'Status', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937085519245177532+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'Module', p_display_order =>9, p_column_identifier =>'I', p_column_label =>'Module', p_report_label =>'Module', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937085626100177536+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'Action', p_display_order =>10, p_column_identifier =>'J', p_column_label =>'Action', p_report_label =>'Action', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937085707457177537+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'RESOURCE_CONSUMER_GROUP', p_display_order =>11, p_column_identifier =>'K', p_column_label =>'Resource Consumer Group', p_report_label =>'Resource Consumer Group', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937085807371177537+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'CLIENT_INFO', p_display_order =>12, p_column_identifier =>'L', p_column_label =>'Client Info', p_report_label =>'Client Info', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937085916570177537+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_db_column_name =>'CLIENT_IDENTIFIER', p_display_order =>13, p_column_identifier =>'M', p_column_label =>'Client Identifier', p_report_label =>'Client Identifier', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / declare rc1 varchar2(32767) := null; begin rc1:=rc1||'SID:SERIAL:Username:Command:Machine:Status:Module:Action:CLIENT_INFO:CLIENT_IDENTIFIER'; wwv_flow_api.create_worksheet_rpt( p_id => 937086003626177844+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_worksheet_id => 937084525148177512+wwv_flow_api.g_id_offset, p_session_id => null, p_base_report_id => null+wwv_flow_api.g_id_offset, p_application_user => 'APXWS_DEFAULT', p_report_seq =>10, p_report_alias =>'9370861', p_status =>'PUBLIC', p_category_id =>null+wwv_flow_api.g_id_offset, p_is_default =>'Y', p_display_rows =>15, p_report_columns =>rc1, p_sort_column_1 =>'Status', p_sort_direction_1 =>'ASC', p_sort_column_2 =>'SID', p_sort_direction_2 =>'ASC', p_flashback_enabled =>'N', p_calendar_display_column =>''); end; / begin null; end; / begin null; end; / begin --------------------------------------- -- ...updatable report columns for page 4 -- begin null; end; null; end; / --application/pages/page_00005 prompt ...PAGE 5: Backups -- begin wwv_flow_api.create_page ( p_flow_id => wwv_flow.g_flow_id ,p_id => 5 ,p_tab_set => 'TS1' ,p_name => 'Backups' ,p_step_title => 'Backups' ,p_allow_duplicate_submissions => 'Y' ,p_step_sub_title => 'Backups' ,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 => 'ON' ,p_required_role => 936944301397349617 + wwv_flow_api.g_id_offset ,p_page_is_public_y_n => 'N' ,p_protection_level => 'N' ,p_cache_page_yn => 'N' ,p_cache_timeout_seconds => 21600 ,p_cache_by_user_yn => 'N' ,p_help_text => 'No help is available for this page.' ,p_last_updated_by => 'JOEL' ,p_last_upd_yyyymmddhh24miss => '20110302103924' ); null; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 936877611653859991 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 5, p_plug_name=> 'Breadcrumbs', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936886425092865365+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 1, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 'M'|| to_char(936874627069859959 + wwv_flow_api.g_id_offset), p_menu_template_id=> 936904805731865485+ 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_display_condition_type => '', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / begin null; end; / begin null; end; / begin --------------------------------------- -- ...updatable report columns for page 5 -- begin null; end; null; end; / --application/pages/page_00006 prompt ...PAGE 6: Parameters -- begin wwv_flow_api.create_page ( p_flow_id => wwv_flow.g_flow_id ,p_id => 6 ,p_tab_set => 'TS1' ,p_name => 'Parameters' ,p_step_title => 'Parameters' ,p_allow_duplicate_submissions => 'Y' ,p_step_sub_title => 'Parameters' ,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 => 'ON' ,p_required_role => 936944301397349617 + wwv_flow_api.g_id_offset ,p_page_is_public_y_n => 'N' ,p_protection_level => 'N' ,p_cache_page_yn => 'N' ,p_cache_timeout_seconds => 21600 ,p_cache_by_user_yn => 'N' ,p_help_text => 'No help is available for this page.' ,p_last_updated_by => 'JOEL' ,p_last_upd_yyyymmddhh24miss => '20110302103943' ); null; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 936878227075859995 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_plug_name=> 'Breadcrumbs', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936886425092865365+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 1, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 'M'|| to_char(936874627069859959 + wwv_flow_api.g_id_offset), p_menu_template_id=> 936904805731865485+ 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_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||'select name "Parameter",'||unistr('\000a')|| ' value "Value",'||unistr('\000a')|| ' update_comment "Comment",'||unistr('\000a')|| ' decode(type,1,''Boolean'',2,'' String'',3,''Integer'',4,''Parameter file'',5,''Reserved'',6,''Big integer'') "Type" ,'||unistr('\000a')|| ' description "Description",'||unistr('\000a')|| ' decode(ISDEFAULT,''TRUE'',''No'',''FALSE'',''Yes'') "Modified",'||unistr('\000a')|| ' decode(issys_modifiable,''IMMEDIATE'',''Yes'','''; s:=s||'No'') "Dynamic" '||unistr('\000a')|| ' from V$SYSTEM_PARAMETER Paramters order by 1'; wwv_flow_api.create_page_plug ( p_id=> 937093016818257176 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_plug_name=> 'Initialization Parameters', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936889721148865373+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 11, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'DYNAMIC_QUERY', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'COLON_DELMITED_LIST', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare a1 varchar2(32767) := null; begin a1:=a1||'select name "Parameter",'||unistr('\000a')|| ' value "Value",'||unistr('\000a')|| ' update_comment "Comment",'||unistr('\000a')|| ' decode(type,1,''Boolean'',2,'' String'',3,''Integer'',4,''Parameter file'',5,''Reserved'',6,''Big integer'') "Type" ,'||unistr('\000a')|| ' description "Description",'||unistr('\000a')|| ' decode(ISDEFAULT,''TRUE'',''No'',''FALSE'',''Yes'') "Modified",'||unistr('\000a')|| ' decode(issys_modifiable,''IMMEDIATE'',''Yes'','''; a1:=a1||'No'') "Dynamic" '||unistr('\000a')|| ' from V$SYSTEM_PARAMETER Paramters order by 1'; wwv_flow_api.create_worksheet( p_id=> 937093123339257176+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_region_id=> 937093016818257176+wwv_flow_api.g_id_offset, p_name=> 'Initialization Parameters', p_folder_id=> null, p_alias=> '', p_report_id_item=> '', p_max_row_count=> '10000', p_max_row_count_message=> 'This query returns more than #MAX_ROW_COUNT# rows, please filter your data to ensure complete results.', p_no_data_found_message=> 'No data found.', p_max_rows_per_page=>'', p_search_button_label=>'', p_sort_asc_image=>'', p_sort_asc_image_attr=>'', p_sort_desc_image=>'', p_sort_desc_image_attr=>'', p_sql_query => a1, p_status=>'AVAILABLE_FOR_OWNER', p_allow_report_saving=>'Y', p_allow_save_rpt_public=>'N', p_allow_report_categories=>'N', p_show_nulls_as=>'-', p_pagination_type=>'ROWS_X_TO_Y', p_pagination_display_pos=>'BOTTOM_RIGHT', p_show_finder_drop_down=>'Y', p_show_display_row_count=>'N', p_show_search_bar=>'Y', p_show_search_textbox=>'Y', p_show_actions_menu=>'Y', p_report_list_mode=>'TABS', p_show_detail_link=>'N', p_show_select_columns=>'Y', p_show_rows_per_page=>'Y', p_show_filter=>'Y', p_show_sort=>'Y', p_show_control_break=>'Y', p_show_highlight=>'Y', p_show_computation=>'Y', p_show_aggregate=>'Y', p_show_chart=>'Y', p_show_group_by=>'Y', p_show_notify=>'N', p_show_calendar=>'N', p_show_flashback=>'N', p_show_reset=>'Y', p_show_download=>'Y', p_show_help=>'Y', p_download_formats=>'CSV:HTML:EMAIL', p_allow_exclude_null_values=>'N', p_allow_hide_extra_columns=>'N', p_icon_view_enabled_yn=>'N', p_icon_view_columns_per_row=>1, p_detail_view_enabled_yn=>'N', p_owner=>'KRIS'); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937093327564257181+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_worksheet_id => 937093123339257176+wwv_flow_api.g_id_offset, p_db_column_name =>'Parameter', p_display_order =>1, p_column_identifier =>'A', p_column_label =>'Parameter', p_report_label =>'Parameter', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937093421142257182+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_worksheet_id => 937093123339257176+wwv_flow_api.g_id_offset, p_db_column_name =>'Value', p_display_order =>2, p_column_identifier =>'B', p_column_label =>'Value', p_report_label =>'Value', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937093508655257182+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_worksheet_id => 937093123339257176+wwv_flow_api.g_id_offset, p_db_column_name =>'Comment', p_display_order =>3, p_column_identifier =>'C', p_column_label =>'Comment', p_report_label =>'Comment', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937093602289257183+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_worksheet_id => 937093123339257176+wwv_flow_api.g_id_offset, p_db_column_name =>'Type', p_display_order =>4, p_column_identifier =>'D', p_column_label =>'Type', p_report_label =>'Type', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937093721240257183+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_worksheet_id => 937093123339257176+wwv_flow_api.g_id_offset, p_db_column_name =>'Description', p_display_order =>5, p_column_identifier =>'E', p_column_label =>'Description', p_report_label =>'Description', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937093813062257183+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_worksheet_id => 937093123339257176+wwv_flow_api.g_id_offset, p_db_column_name =>'Modified', p_display_order =>6, p_column_identifier =>'F', p_column_label =>'Modified', p_report_label =>'Modified', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937093908362257183+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_worksheet_id => 937093123339257176+wwv_flow_api.g_id_offset, p_db_column_name =>'Dynamic', p_display_order =>7, p_column_identifier =>'G', p_column_label =>'Dynamic', p_report_label =>'Dynamic', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / declare rc1 varchar2(32767) := null; begin rc1:=rc1||'Parameter:Value:Type:Description:Dynamic'; wwv_flow_api.create_worksheet_rpt( p_id => 937094017487257470+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_worksheet_id => 937093123339257176+wwv_flow_api.g_id_offset, p_session_id => null, p_base_report_id => null+wwv_flow_api.g_id_offset, p_application_user => 'APXWS_DEFAULT', p_report_seq =>10, p_report_alias =>'9370941', p_status =>'PUBLIC', p_category_id =>null+wwv_flow_api.g_id_offset, p_is_default =>'Y', p_display_rows =>100000, p_report_columns =>rc1, p_sort_column_1 =>'0', p_sort_direction_1 =>'DESC', p_sort_column_2 =>'0', p_sort_direction_2 =>'ASC', p_sort_column_3 =>'0', p_sort_direction_3 =>'ASC', p_sort_column_4 =>'0', p_sort_direction_4 =>'ASC', p_sort_column_5 =>'0', p_sort_direction_5 =>'ASC', p_sort_column_6 =>'0', p_sort_direction_6 =>'ASC', p_flashback_enabled =>'N', p_calendar_display_column =>''); end; / begin wwv_flow_api.create_worksheet_condition( p_id => 937651219409152562+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_worksheet_id => 937093123339257176+wwv_flow_api.g_id_offset, p_report_id => 937094017487257470+wwv_flow_api.g_id_offset, p_condition_type =>'FILTER', p_allow_delete =>'Y', p_column_name =>'Modified', p_operator =>'=', p_expr =>'Yes', p_condition_sql =>'"Modified" = #APXWS_EXPR#', p_condition_display =>'#APXWS_COL_NAME# = ''Yes'' ', p_enabled =>'Y', p_column_format =>''); end; / begin null; end; / begin null; end; / begin --------------------------------------- -- ...updatable report columns for page 6 -- begin null; end; null; end; / --application/pages/page_00007 prompt ...PAGE 7: Application Express -- begin wwv_flow_api.create_page ( p_flow_id => wwv_flow.g_flow_id ,p_id => 7 ,p_tab_set => 'TS1' ,p_name => 'Application Express' ,p_step_title => 'Application Express' ,p_allow_duplicate_submissions => 'Y' ,p_step_sub_title => 'APEX' ,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 => 'ON' ,p_html_page_header => '' ,p_step_template => 936881728833865360 + wwv_flow_api.g_id_offset ,p_required_role => 936944301397349617 + wwv_flow_api.g_id_offset ,p_page_is_public_y_n => 'N' ,p_protection_level => 'N' ,p_cache_page_yn => 'N' ,p_cache_timeout_seconds => 21600 ,p_cache_by_user_yn => 'N' ,p_help_text => 'No help is available for this page.' ,p_last_updated_by => 'JOEL' ,p_last_upd_yyyymmddhh24miss => '20110701043153' ); null; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 936878629697859998 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 7, p_plug_name=> 'Create Application Express Workspace', p_region_name=>'', p_region_attributes=> 'style="float: left; width: 66%; margin-right: 1%"', p_escape_on_http_output=>'N', p_plug_template=> 936890925366865374+ 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_query_row_template=> 1, p_plug_query_headings_type=> 'COLON_DELMITED_LIST', p_plug_query_row_count_max => 500, p_plug_display_condition_type => '', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 936878821576859999 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 7, p_plug_name=> 'Breadcrumbs', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936886425092865365+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 1, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 'M'|| to_char(936874627069859959 + wwv_flow_api.g_id_offset), p_menu_template_id=> 936904805731865485+ 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_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||'

To get started with Oracle Application Express, create a workspace. You will need to specify:

'||unistr('\000a')|| ''||unistr('\000a')|| '

Once created, you will be able to login to your Application Express workspace using these credentials

'||unistr('\000a')|| ''; wwv_flow_api.create_page_plug ( p_id=> 937503817727080193 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 7, p_plug_name=> 'Getting Started', p_region_name=>'', p_region_attributes=> 'style="float: left; clear: none; width: 32%"', p_escape_on_http_output=>'N', p_plug_template=> 936890925366865374+ 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_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows => 15, p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / begin wwv_flow_api.create_page_button( p_id => 936914611479905091 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_button_sequence=> 10, p_button_plug_id => 936878629697859998+wwv_flow_api.g_id_offset, p_button_name => 'CANCEL', p_button_action => 'REDIRECT_PAGE', p_button_image => 'template:'||to_char(936883817777865362+wwv_flow_api.g_id_offset), p_button_is_hot=>'N', p_button_image_alt=> 'Cancel', p_button_position=> 'REGION_TEMPLATE_CLOSE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=&APP_ID.:1:&SESSION.::&DEBUG.:::', p_button_execute_validations=>'Y', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 936914804766905093 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_button_sequence=> 20, p_button_plug_id => 936878629697859998+wwv_flow_api.g_id_offset, p_button_name => 'CREATE', p_button_action => 'SUBMIT', p_button_image => 'template:'||to_char(936884428414865363+wwv_flow_api.g_id_offset), p_button_is_hot=>'N', p_button_image_alt=> 'Create Workspace', p_button_position=> 'REGION_TEMPLATE_CREATE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_execute_validations=>'Y', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 937706913288725746 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_button_sequence=> 30, p_button_plug_id => 937503817727080193+wwv_flow_api.g_id_offset, p_button_name => 'APEX_LOGIN', p_button_action => 'REDIRECT_URL', p_button_image => 'template:'||to_char(936883817777865362+wwv_flow_api.g_id_offset), p_button_is_hot=>'N', p_button_image_alt=> 'Already have an account? Login Here', p_button_position=> 'REGION_TEMPLATE_NEXT', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '&P7_HOST_URL.', p_button_execute_validations=>'N', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>937379822858501709 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_branch_action=> 'f?p=&APP_ID.:1:&SESSION.:CREATE_WORKSPACE:&DEBUG.:::&success_msg=#SUCCESS_MSG#', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_when_button_id=>936914804766905093+ wwv_flow_api.g_id_offset, p_branch_sequence=> 99, p_save_state_before_branch_yn=>'Y', p_branch_comment=> 'Created 02-MAR-2011 07:03 by JASON'); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'Enter the database username. The database username must be a valid Oracle identifier. Example: SCOTT'; wwv_flow_api.create_page_item( p_id=>936913701783902285 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_name=>'P7_DATABASE_SCHEMA', p_data_type=> 'VARCHAR', p_is_required=> true, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 936878629697859998+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Database Username', p_source_type=> 'STATIC', p_display_as=> 'NATIVE_POPUP_LOV', p_named_lov=> 'LIST_ALL_DATABASE_SCHEMAS', p_lov=> 'declare q varchar2(32767);'||unistr('\000a')|| ' l_flows_schema varchar2(30) := wwv_flow.g_flow_schema_owner;'||unistr('\000a')|| 'begin'||unistr('\000a')|| ' q := ''select name n, name r from sys.user$ u where type#=1 and name <> ''''''||l_flows_schema||'''''' and name not in (''''HTMLDB_PUBLIC_USER'''',''''PUBLIC_USER'''',''''FLOWS_FILES'''',''''SCHEDULER'''',''''PEOPLE'''',''''APEX_PUBLIC_USER'''')'';'||unistr('\000a')|| ' q := q||'' and name not in (select schema from wwv_flow_restricted_schemas where not exists (select 1 from wwv_flow_rschema_exceptions where schema_id = (select id from wwv_flow_restricted_schemas where schema = u.name))) '';'||unistr('\000a')|| ' q := q||'' and (upper(name) not like ''''FLOWS_%'''' or length(name) != 12 or not REGEXP_LIKE(substr(name,7),''''[0-9]{6}'''')) '';'||unistr('\000a')|| ' q := q||'' and (upper(name) not like ''''APEX_%'''' or length(name) != 11 or not REGEXP_LIKE(substr(name,6),''''[0-9]{6}'''')) '';'||unistr('\000a')|| ' q := q ||'' order by 1'';'||unistr('\000a')|| ' return q;'||unistr('\000a')|| 'end;', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, 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=> 936904703644865485+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_escape_on_http_output => 'Y', p_help_text=> h, p_attribute_01 => 'ENTERABLE', p_attribute_02 => 'FIRST_ROWSET', p_show_quick_picks=>'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'Enter the username you will use to login to the Application Express workspace.'; wwv_flow_api.create_page_item( p_id=>936913910804902285 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_name=>'P7_APEX_USERNAME', p_data_type=> 'VARCHAR', p_is_required=> true, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 936878629697859998+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Application Express Username', p_source_type=> 'STATIC', p_display_as=> 'NATIVE_TEXT_FIELD', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, 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=> 936904703644865485+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'YES', p_protection_level => 'N', p_escape_on_http_output => 'Y', p_help_text=> h, p_attribute_01 => 'N', p_attribute_02 => 'N', p_show_quick_picks=>'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'Enter the password you will use to login to the Application Express workspace. This same password will be used for the associated database user.'; wwv_flow_api.create_page_item( p_id=>936914124355902286 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_name=>'P7_APEX_PASSWORD', p_data_type=> 'VARCHAR', p_is_required=> true, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 30, p_item_plug_id => 936878629697859998+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Password', p_source_type=> 'STATIC', p_display_as=> 'NATIVE_PASSWORD', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, 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=> 936904703644865485+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'YES', p_protection_level => 'N', p_escape_on_http_output => 'Y', p_help_text=> h, p_attribute_01 => 'N', p_attribute_02 => 'Y', p_show_quick_picks=>'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'Confirm the password you will use to login to the Application Express workspace.'; wwv_flow_api.create_page_item( p_id=>936914300623902286 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_name=>'P7_APEX_PASSWORD_CONF', p_data_type=> 'VARCHAR', p_is_required=> true, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 40, p_item_plug_id => 936878629697859998+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Confirm Password', p_source_type=> 'STATIC', p_display_as=> 'NATIVE_PASSWORD', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, 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=> 936904703644865485+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'YES', p_protection_level => 'N', p_escape_on_http_output => 'Y', p_help_text=> h, p_attribute_01 => 'N', p_attribute_02 => 'Y', p_show_quick_picks=>'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin h := null; h:=h||'Specify if you would like to create an Application Express workspace with an existing database user or create a new database user. A valid Oracle identifier must be specified, and you are not able to use a reserved database username like SYS or SYSTEM.'; wwv_flow_api.create_page_item( p_id=>937125502960104841 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_name=>'P7_DB_USER', p_data_type=> 'VARCHAR', p_is_required=> false, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 5, p_item_plug_id => 936878629697859998+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default=> 'NEW', p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Database User', p_source_type=> 'STATIC', p_display_as=> 'NATIVE_RADIOGROUP', p_named_lov=> 'CREATE_DB_USER', p_lov=> '.'||to_char(15455101519405880 + wwv_flow_api.g_id_offset)||'.', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, 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-CENTER', p_field_template=> 936904524832865485+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'YES', p_protection_level => 'N', p_escape_on_http_output => 'Y', p_help_text=> h, p_attribute_01 => '1', p_attribute_02 => 'NONE', p_show_quick_picks=>'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>937572311690617712 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_name=>'P7_HOST_URL', p_data_type=> 'VARCHAR', p_is_required=> false, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 50, p_item_plug_id => 936878629697859998+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=> 'NATIVE_HIDDEN', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> null, p_cMaxlength=> 4000, p_cHeight=> null, 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_attribute_01 => 'Y', p_item_comment => ''); end; / begin wwv_flow_api.create_page_computation( p_id=> 937625526534943689 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_computation_sequence => 20, p_computation_item=> 'P7_HOST_URL', p_computation_point=> 'AFTER_HEADER', p_computation_type=> 'PLSQL_EXPRESSION', p_computation_processed=> 'REPLACE_EXISTING', p_computation=> 'wwv_flow_utilities.host_url(''SCRIPT'')', p_compute_when => '', p_compute_when_type=>''); null; end; / begin wwv_flow_api.create_page_computation( p_id=> 937572526234621914 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_computation_sequence => 5, p_computation_item=> 'P7_HOST_URL', p_computation_point=> 'AFTER_SUBMIT', p_computation_type=> 'PLSQL_EXPRESSION', p_computation_processed=> 'REPLACE_EXISTING', p_computation=> 'wwv_flow_utilities.host_url(''SCRIPT'')', p_compute_when => '', p_compute_when_type=>''); null; end; / begin wwv_flow_api.create_page_computation( p_id=> 937373011356242914 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_computation_sequence => 10, p_computation_item=> 'P7_DATABASE_SCHEMA', p_computation_point=> 'AFTER_SUBMIT', p_computation_type=> 'PLSQL_EXPRESSION', p_computation_processed=> 'REPLACE_EXISTING', p_computation=> 'ltrim(rtrim(upper(:P7_DATABASE_SCHEMA)))', p_compute_when => 'P7_DATABASE_SCHEMA', p_compute_when_type=>'ITEM_IS_NOT_NULL'); null; end; / begin wwv_flow_api.create_page_validation( p_id => 937303712838715959 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_tabular_form_region_id => null + wwv_flow_api.g_id_offset, p_validation_name => 'valid identifier', p_validation_sequence=> 10, p_validation => 'wwv_flow_utilities.is_valid_identifier(p_identifier=>:P7_DATABASE_SCHEMA,p_quote=>true)', p_validation_type => 'PLSQL_EXPRESSION', p_error_message => 'Schema name must be a valid Oracle identifier.', p_always_execute=>'N', p_when_button_pressed=> 936914804766905093 + wwv_flow_api.g_id_offset, p_associated_item=> 936913701783902285 + 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 => 937371322129198730 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_tabular_form_region_id => null + wwv_flow_api.g_id_offset, p_validation_name => 'reserved company name', p_validation_sequence=> 20, p_validation => 'nvl(upper(:P7_DATABASE_SCHEMA),''x'') not in (''INTERNAL'',''UNKNOWN'',''CSS'',''JAVASCRIPT'',''THEMES'',''TUTORIAL'',''XML'',''DOC'',''DP'',''TEMPLATES'')', p_validation_type => 'PLSQL_EXPRESSION', p_error_message => 'Workspace is a reserved name, request denied.', p_always_execute=>'N', p_when_button_pressed=> 936914804766905093 + wwv_flow_api.g_id_offset, p_associated_item=> 936913701783902285 + 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 => 937372826677228443 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_tabular_form_region_id => null + wwv_flow_api.g_id_offset, p_validation_name => 'company already exists or requested', p_validation_sequence=> 30, p_validation => 'for c1 in (select null'||unistr('\000a')|| ' from wwv_flow_provision_company'||unistr('\000a')|| ' where company_name = upper(:P7_DATABASE_SCHEMA)'||unistr('\000a')|| ' and project_status not in (''DECLINED'',''TERMINATED'') ) loop'||unistr('\000a')|| ' return false;'||unistr('\000a')|| ' exit;'||unistr('\000a')|| 'end loop;'||unistr('\000a')|| 'for c1 in (select null'||unistr('\000a')|| ' from wwv_flow_companies'||unistr('\000a')|| ' where short_name = upper(:P7_DATABASE_SCHEMA) ) loop'||unistr('\000a')|| ' return false;'||unistr('\000a')|| ' exit;'||unistr('\000a')|| 'end loop;'||unistr('\000a')|| ''||unistr('\000a')|| 'if not nvl(length(trim(:P7_DATABASE_SCHEMA)),0) > 0 then'||unistr('\000a')|| ' return false;'||unistr('\000a')|| 'end if;'||unistr('\000a')|| ''||unistr('\000a')|| 'return true;', p_validation_type => 'FUNC_BODY_RETURNING_BOOLEAN', p_error_message => 'Workspace name already exists', p_always_execute=>'N', p_when_button_pressed=> 936914804766905093 + wwv_flow_api.g_id_offset, p_associated_item=> 936913701783902285 + 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 => 937374501884306454 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_tabular_form_region_id => null + wwv_flow_api.g_id_offset, p_validation_name => 'check if db user exists', p_validation_sequence=> 40, p_validation => 'select null'||unistr('\000a')|| ' from sys.dba_users'||unistr('\000a')|| ' where username = upper(:P7_DATABASE_SCHEMA)', p_validation_type => 'EXISTS', p_error_message => 'Database user does not exist.', p_always_execute=>'N', p_validation_condition=> ':P7_DB_USER = ''EXISTING'' and :P7_DATABASE_SCHEMA is not null', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_when_button_pressed=> 936914804766905093 + wwv_flow_api.g_id_offset, p_associated_item=> 936913701783902285 + 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 => 937374812189328357 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_tabular_form_region_id => null + wwv_flow_api.g_id_offset, p_validation_name => 'check if db user does not exist', p_validation_sequence=> 50, p_validation => 'select null'||unistr('\000a')|| ' from sys.dba_users'||unistr('\000a')|| ' where username = upper(:P7_DATABASE_SCHEMA)', p_validation_type => 'NOT_EXISTS', p_error_message => 'Database user already exists.', p_always_execute=>'N', p_validation_condition=> ':P7_DB_USER = ''NEW'' and :P7_DATABASE_SCHEMA is not null', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_when_button_pressed=> 936914804766905093 + wwv_flow_api.g_id_offset, p_associated_item=> 936913701783902285 + 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 => 937377128521437159 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_tabular_form_region_id => null + wwv_flow_api.g_id_offset, p_validation_name => 'check existing schema not internal', p_validation_sequence=> 60, p_validation => 'select null'||unistr('\000a')|| ' from wwv_flow_companies'||unistr('\000a')|| ' where provisioning_company_id = 10'||unistr('\000a')|| ' and first_schema_provisioned = upper(:P7_DATABASE_SCHEMA)', p_validation_type => 'NOT_EXISTS', p_error_message => 'Cannot use INTERNAL workspace.', p_always_execute=>'N', p_validation_condition=> ':P7_DB_USER = ''EXISTING'' and :P7_DATABASE_SCHEMA is not null', p_validation_condition_type=> 'PLSQL_EXPRESSION', p_when_button_pressed=> 936914804766905093 + wwv_flow_api.g_id_offset, p_associated_item=> 936913701783902285 + 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 => 937378005712458883 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_tabular_form_region_id => null + wwv_flow_api.g_id_offset, p_validation_name => 'schema not reserved/restricted', p_validation_sequence=> 70, p_validation => 'wwv_flow_provisioning.reserved_schema(p_schema => :P7_DATABASE_SCHEMA) = false and'||unistr('\000a')|| 'not wwv_flow_provision.is_reserved(:P7_DATABASE_SCHEMA) and'||unistr('\000a')|| 'not (wwv_flow_provisioning.site_admin_is_restricted and wwv_flow_provisioning.restricted_schema(p_schema => :P7_DATABASE_SCHEMA,'||unistr('\000a')|| ' p_workspace_name => :P7_DATABASE_SCHEMA) )', p_validation_type => 'PLSQL_EXPRESSION', p_error_message => 'Database username is reserved or restricted', p_always_execute=>'N', p_when_button_pressed=> 936914804766905093 + wwv_flow_api.g_id_offset, p_associated_item=> 936913701783902285 + 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 => 937383315979528079 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_tabular_form_region_id => null + wwv_flow_api.g_id_offset, p_validation_name => 'Invalid characters in username', p_validation_sequence=> 80, p_validation => 'P7_APEX_USERNAME', p_validation2 => '<>', p_validation_type => 'ITEM_IN_VALIDATION_CONTAINS_NO_CHAR_IN_STRING2', p_error_message => 'Invalid database username.', p_always_execute=>'N', p_when_button_pressed=> 936914804766905093 + wwv_flow_api.g_id_offset, p_associated_item=> 936913910804902285 + 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 => 937385303344562321 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_tabular_form_region_id => null + wwv_flow_api.g_id_offset, p_validation_name => 'confirm password', p_validation_sequence=> 90, p_validation => ':P7_APEX_PASSWORD = :P7_APEX_PASSWORD_CONF', p_validation_type => 'PLSQL_EXPRESSION', p_error_message => 'Passwords do not match.', p_always_execute=>'N', p_when_button_pressed=> 936914804766905093 + wwv_flow_api.g_id_offset, p_associated_item=> 936914124355902286 + 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'||unistr('\000a')|| ' l_sgid number;'||unistr('\000a')|| 'begin'||unistr('\000a')|| ' if :P7_DB_USER = ''NEW'' then'||unistr('\000a')|| ' wwv_flow_provision.create_user('||unistr('\000a')|| ' p_username => wwv_flow_assert.simple_sql_name(:P7_DATABASE_SCHEMA),'||unistr('\000a')|| ' p_password => :P7_APEX_PASSWORD );'||unistr('\000a')|| ' --'||unistr('\000a')|| ' wwv_flow_provision.set_user_tablespace('||unistr('\000a')|| ' p_username => wwv_flow_assert.simple_sql_name(:P7_DATABASE_SCHEMA),'||unistr('\000a')|| ' p_default_ts =>'; p:=p||' ''USERS'','||unistr('\000a')|| ' p_temp_ts => ''TEMP'' );'||unistr('\000a')|| ' --'||unistr('\000a')|| ' wwv_flow_provision.grant_initial_privs('||unistr('\000a')|| ' p_username => wwv_flow_assert.simple_sql_name(:P7_DATABASE_SCHEMA ));'||unistr('\000a')|| ' '||unistr('\000a')|| ' end if;'||unistr('\000a')|| ' --'||unistr('\000a')|| ' wwv_flow_provisioning.auto_provision_company('||unistr('\000a')|| ' p_company_name => wwv_flow_assert.simple_sql_name(:P7_DATABASE_SCHEMA),'||unistr('\000a')|| ' p_schema_name => wwv_flow_assert.simple_sql_n'; p:=p||'ame(:P7_DATABASE_SCHEMA),'||unistr('\000a')|| ' p_schema_password => null, -- always set to null, which implies existing db user'||unistr('\000a')|| ' p_admin_userid => :P7_APEX_USERNAME,'||unistr('\000a')|| ' p_admin_password => :P7_APEX_PASSWORD); '||unistr('\000a')|| ' '||unistr('\000a')|| ' l_sgid := wwv_flow_security.find_security_group_id(wwv_flow_assert.simple_sql_name(:P7_DATABASE_SCHEMA));'||unistr('\000a')|| ''||unistr('\000a')|| ' update wwv_flow_fnd_user '||unistr('\000a')|| ' set change_password_on_first_us'; p:=p||'e = ''N'''||unistr('\000a')|| ' where user_name = upper(:P7_APEX_USERNAME) '||unistr('\000a')|| ' and security_group_id = l_sgid;'||unistr('\000a')|| 'end;'; wwv_flow_api.create_page_process( p_id => 937412225909672923 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 7, p_process_sequence=> 10, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'PLSQL', p_process_name=> 'Create Workspace', p_process_sql_clob => p, p_process_error_message=> 'Error creating workspace.', p_error_display_location=> 'ON_ERROR_PAGE', p_process_when_button_id=>936914804766905093 + wwv_flow_api.g_id_offset, p_process_success_message=> 'Successfully created workspace &P7_DATABASE_SCHEMA.. To begin, click here to login.', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'P7_APEX_PASSWORD,P7_APEX_PASSWORD_CONF'; wwv_flow_api.create_page_process( p_id => 937438301986788978 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 7, p_process_sequence=> 20, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'CLEAR_CACHE_FOR_ITEMS', p_process_name=> 'Clear Cache', p_process_sql_clob => p, p_process_error_message=> '', p_error_display_location=> 'ON_ERROR_PAGE', p_process_when_button_id=>936914804766905093 + wwv_flow_api.g_id_offset, p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin --------------------------------------- -- ...updatable report columns for page 7 -- begin null; end; null; end; / --application/pages/page_00009 prompt ...PAGE 9: Tablespace Storage Details -- begin wwv_flow_api.create_page ( p_flow_id => wwv_flow.g_flow_id ,p_id => 9 ,p_tab_set => 'TS1' ,p_name => 'Tablespace Storage Details' ,p_step_title => 'Tablespace Storage Details' ,p_allow_duplicate_submissions => 'Y' ,p_step_sub_title => 'Tablespace Storage Details' ,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 => 'ON' ,p_required_role => 936944301397349617 + wwv_flow_api.g_id_offset ,p_page_is_public_y_n => 'N' ,p_protection_level => 'N' ,p_cache_page_yn => 'N' ,p_cache_timeout_seconds => 21600 ,p_cache_by_user_yn => 'N' ,p_help_text => 'No help is available for this page.' ,p_last_updated_by => 'JOEL' ,p_last_upd_yyyymmddhh24miss => '20110414101733' ); null; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 937074121455121010 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 9, p_plug_name=> 'Breadcrumb', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936886425092865365+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 1, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 'M'|| to_char(936874627069859959 + wwv_flow_api.g_id_offset), p_menu_template_id=> 936904805731865485+ 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_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||' select segment_name ,segment_type,'||unistr('\000a')|| ' case when segment_type = ''TABLE'' then num_rows else null end num_rows,'||unistr('\000a')|| ' sum(bytes)/1024/1024 size_in_megs'||unistr('\000a')|| 'from dba_segments s,dba_tables t'||unistr('\000a')|| 'where s.tablespace_name = :P9_TBLSPACE_NAME'||unistr('\000a')|| 'and s.owner = t.owner (+)'||unistr('\000a')|| 'and s.segment_name = t.table_name (+)'||unistr('\000a')|| 'group by segment_name,segment_type,case when segment_type = ''TABLE'' then num_rows else null end'||unistr('\000a')|| ' '||unistr('\000a')|| ''; wwv_flow_api.create_page_plug ( p_id=> 937074515668121023 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 9, p_plug_name=> 'Tablespace Storage Details', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936889721148865373+ 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=> 'DYNAMIC_QUERY', p_translate_title=> 'Y', p_rest_enabled=> 'N', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'COLON_DELMITED_LIST', p_plug_query_row_count_max => 500, p_plug_display_condition_type => '', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare a1 varchar2(32767) := null; begin a1:=a1||' select segment_name ,segment_type,'||unistr('\000a')|| ' case when segment_type = ''TABLE'' then num_rows else null end num_rows,'||unistr('\000a')|| ' sum(bytes)/1024/1024 size_in_megs'||unistr('\000a')|| 'from dba_segments s,dba_tables t'||unistr('\000a')|| 'where s.tablespace_name = :P9_TBLSPACE_NAME'||unistr('\000a')|| 'and s.owner = t.owner (+)'||unistr('\000a')|| 'and s.segment_name = t.table_name (+)'||unistr('\000a')|| 'group by segment_name,segment_type,case when segment_type = ''TABLE'' then num_rows else null end'||unistr('\000a')|| ' '||unistr('\000a')|| ''; wwv_flow_api.create_worksheet( p_id=> 937074630455121023+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 9, p_region_id=> 937074515668121023+wwv_flow_api.g_id_offset, p_name=> 'Tablespace Storage Details', p_folder_id=> null, p_alias=> '', p_report_id_item=> '', p_max_row_count=> '10000', p_max_row_count_message=> 'This query returns more than #MAX_ROW_COUNT# rows, please filter your data to ensure complete results.', p_no_data_found_message=> 'No data found.', p_max_rows_per_page=>'', p_search_button_label=>'', p_sort_asc_image=>'', p_sort_asc_image_attr=>'', p_sort_desc_image=>'', p_sort_desc_image_attr=>'', p_sql_query => a1, p_status=>'AVAILABLE_FOR_OWNER', p_allow_report_saving=>'Y', p_allow_save_rpt_public=>'N', p_allow_report_categories=>'N', p_show_nulls_as=>'-', p_pagination_type=>'ROWS_X_TO_Y', p_pagination_display_pos=>'BOTTOM_RIGHT', p_show_finder_drop_down=>'Y', p_show_display_row_count=>'N', p_show_search_bar=>'Y', p_show_search_textbox=>'Y', p_show_actions_menu=>'Y', p_report_list_mode=>'TABS', p_show_detail_link=>'N', p_show_select_columns=>'Y', p_show_rows_per_page=>'Y', p_show_filter=>'Y', p_show_sort=>'Y', p_show_control_break=>'Y', p_show_highlight=>'Y', p_show_computation=>'Y', p_show_aggregate=>'Y', p_show_chart=>'Y', p_show_group_by=>'Y', p_show_notify=>'N', p_show_calendar=>'N', p_show_flashback=>'Y', p_show_reset=>'Y', p_show_download=>'Y', p_show_help=>'Y', p_download_formats=>'CSV:HTML:EMAIL', p_allow_exclude_null_values=>'N', p_allow_hide_extra_columns=>'N', p_icon_view_enabled_yn=>'N', p_icon_view_columns_per_row=>1, p_detail_view_enabled_yn=>'N', p_owner=>'KRIS'); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937074818186121088+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 9, p_worksheet_id => 937074630455121023+wwv_flow_api.g_id_offset, p_db_column_name =>'SEGMENT_NAME', p_display_order =>1, p_column_identifier =>'A', p_column_label =>'Segment Name', p_report_label =>'Segment Name', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937075922841145563+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 9, p_worksheet_id => 937074630455121023+wwv_flow_api.g_id_offset, p_db_column_name =>'SEGMENT_TYPE', p_display_order =>2, p_column_identifier =>'C', p_column_label =>'Segment Type', p_report_label =>'Segment Type', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'STRING', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'LEFT', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937074911592121103+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 9, p_worksheet_id => 937074630455121023+wwv_flow_api.g_id_offset, p_db_column_name =>'SIZE_IN_MEGS', p_display_order =>3, p_column_identifier =>'B', p_column_label =>'Size (MB)', p_report_label =>'Size (MB)', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'NUMBER', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'RIGHT', p_format_mask =>'999G999G999G999G990D0', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / begin wwv_flow_api.create_worksheet_column( p_id => 937104312733312886+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 9, p_worksheet_id => 937074630455121023+wwv_flow_api.g_id_offset, p_db_column_name =>'NUM_ROWS', p_display_order =>4, p_column_identifier =>'D', p_column_label =>'Number of Rows', p_report_label =>'Number of Rows', p_sync_form_label =>'Y', p_display_in_default_rpt =>'Y', p_is_sortable =>'Y', p_allow_sorting =>'Y', p_allow_filtering =>'Y', p_allow_highlighting =>'Y', p_allow_ctrl_breaks =>'Y', p_allow_aggregations =>'Y', p_allow_computations =>'Y', p_allow_charting =>'Y', p_allow_group_by =>'Y', p_allow_hide =>'Y', p_others_may_edit =>'Y', p_others_may_view =>'Y', p_column_type =>'NUMBER', p_display_as =>'TEXT', p_display_text_as =>'ESCAPE_SC', p_heading_alignment =>'CENTER', p_column_alignment =>'RIGHT', p_format_mask =>'999G999G999G999G999G999G990', p_tz_dependent =>'N', p_rpt_distinct_lov =>'Y', p_rpt_show_filter_lov =>'D', p_rpt_filter_date_ranges =>'ALL', p_help_text =>''); end; / declare rc1 varchar2(32767) := null; begin rc1:=rc1||'SEGMENT_NAME:SIZE_IN_MEGS:SEGMENT_TYPE:NUM_ROWS'; wwv_flow_api.create_worksheet_rpt( p_id => 937075204010130611+wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 9, p_worksheet_id => 937074630455121023+wwv_flow_api.g_id_offset, p_session_id => null, p_base_report_id => null+wwv_flow_api.g_id_offset, p_application_user => 'APXWS_DEFAULT', p_report_seq =>10, p_report_alias =>'9370753', p_status =>'PUBLIC', p_category_id =>null+wwv_flow_api.g_id_offset, p_is_default =>'Y', p_display_rows =>15, p_report_columns =>rc1, p_sort_column_1 =>'SIZE_IN_MEGS', p_sort_direction_1 =>'DESC', p_flashback_enabled =>'N', p_calendar_display_column =>''); end; / begin null; end; / begin null; end; / declare h varchar2(32767) := null; begin h := null; h:=h||'The name of the tablespace for which the details are displayed.'; wwv_flow_api.create_page_item( p_id=>937075032276129312 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 9, p_name=>'P9_TBLSPACE_NAME', p_data_type=> 'VARCHAR', p_is_required=> false, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 937074515668121023+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Tablespace', p_source_type=> 'STATIC', p_display_as=> 'NATIVE_DISPLAY_ONLY', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, 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_field_template=> 936904524832865485+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'YES', p_protection_level => 'N', p_escape_on_http_output => 'Y', p_help_text=> h, p_attribute_01 => 'N', p_attribute_02 => 'VALUE', p_attribute_04 => 'Y', p_show_quick_picks=>'N', p_item_comment => ''); end; / begin --------------------------------------- -- ...updatable report columns for page 9 -- begin null; end; null; end; / --application/pages/page_00010 prompt ...PAGE 10: Session Details -- begin wwv_flow_api.create_page ( p_flow_id => wwv_flow.g_flow_id ,p_id => 10 ,p_tab_set => 'TS1' ,p_name => 'Session Details' ,p_step_title => 'Session Details' ,p_allow_duplicate_submissions => 'Y' ,p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS' ,p_first_item => 'NO_FIRST_ITEM' ,p_include_apex_css_js_yn => 'Y' ,p_autocomplete_on_off => 'ON' ,p_required_role => 936944301397349617 + wwv_flow_api.g_id_offset ,p_page_is_public_y_n => 'N' ,p_protection_level => 'N' ,p_cache_page_yn => 'N' ,p_cache_timeout_seconds => 21600 ,p_cache_by_user_yn => 'N' ,p_last_updated_by => 'JOEL' ,p_last_upd_yyyymmddhh24miss => '20110414101705' ); null; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 5280205953553414 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 10, p_plug_name=> 'SID', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 0, p_plug_display_sequence=> 3, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'STATIC_TEXT', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows => 15, p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 937087130073201453 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 10, p_plug_name=> 'Breadcrumb', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936886425092865365+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 1, p_plug_display_column=> 1, p_plug_display_point=> 'REGION_POSITION_01', p_plug_source=> s, p_plug_source_type=> 'M'|| to_char(936874627069859959 + wwv_flow_api.g_id_offset), p_menu_template_id=> 936904805731865485+ 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_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||'begin '||unistr('\000a')|| ' for r in ( select replace(q.sql_text,chr(0)) sql_text'||unistr('\000a')|| ' from v$session s,v$sql q'||unistr('\000a')|| ' where s.sql_address = q.address'||unistr('\000a')|| ' and s.sql_hash_value = q.hash_value'||unistr('\000a')|| ' and s.sid = :P10_SID) loop'||unistr('\000a')|| ' htp.prn(r.sql_text);'||unistr('\000a')|| 'end loop;'||unistr('\000a')|| 'end;'; wwv_flow_api.create_page_plug ( p_id=> 937087611638208511 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 10, p_plug_name=> 'Active SQL', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936890925366865374+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 11, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'PLSQL_PROCEDURE', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select event,p1,p2,'||unistr('\000a')|| ' case when p3 = 0 then null else p3 end p3'||unistr('\000a')|| ' from v$session_wait'||unistr('\000a')|| ' where sid = :P10_SID'; wwv_flow_api.create_report_region ( p_id=> 937088527353222497 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 10, p_name=> 'Waits', p_region_name=>'', p_template=> 936890925366865374+ wwv_flow_api.g_id_offset, p_display_sequence=> 21, p_display_column=> 1, p_display_point=> 'AFTER_SHOW_ITEMS', p_source=> s, p_source_type=> 'SQL_QUERY', p_plug_caching=> 'NOT_CACHED', p_ajax_enabled=> 'Y', p_query_row_template=> 936900209975865391+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_show_nulls_as=> ' - ', p_query_break_cols=> '0', p_query_no_data_found=> 'no data found', p_query_num_rows_type=> 'NEXT_PREVIOUS_LINKS', p_query_row_count_max=> '500', p_pagination_display_position=> 'BOTTOM_RIGHT', p_csv_output=> 'N', p_query_asc_image=> 'apex/builder/dup.gif', p_query_asc_image_attr=> 'width="16" height="16" alt="" ', p_query_desc_image=> 'apex/builder/ddown.gif', p_query_desc_image_attr=> 'width="16" height="16" alt="" ', p_plug_query_strip_html=> 'Y', p_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937088826116222502 + wwv_flow_api.g_id_offset, p_region_id=> 937088527353222497 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 1, p_form_element_id=> null, p_column_alias=> 'EVENT', p_column_display_sequence=> 1, p_column_heading=> 'EVENT', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937088926059222504 + wwv_flow_api.g_id_offset, p_region_id=> 937088527353222497 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 2, p_form_element_id=> null, p_column_alias=> 'P1', p_column_display_sequence=> 2, p_column_heading=> 'P1', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937089019364222504 + wwv_flow_api.g_id_offset, p_region_id=> 937088527353222497 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 3, p_form_element_id=> null, p_column_alias=> 'P2', p_column_display_sequence=> 3, p_column_heading=> 'P2', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937089124824222504 + wwv_flow_api.g_id_offset, p_region_id=> 937088527353222497 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 4, p_form_element_id=> null, p_column_alias=> 'P3', p_column_display_sequence=> 4, p_column_heading=> 'P3', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select s.SID,s.status,s.username,s.process,s.LOGON_TIME,'||unistr('\000a')|| ' s.logon_time since,s.server,s.type,p.spid,p.TRACEID,'||unistr('\000a')|| ' s.serial#'||unistr('\000a')|| ' from v$session s, v$process p'||unistr('\000a')|| ' where sid = :P10_SID'||unistr('\000a')|| ' and s.paddr = p.addr'; wwv_flow_api.create_report_region ( p_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 10, p_name=> 'Server Details', p_region_name=>'', p_template=> 936890925366865374+ wwv_flow_api.g_id_offset, p_display_sequence=> 31, p_display_column=> 1, p_display_point=> 'AFTER_SHOW_ITEMS', p_source=> s, p_source_type=> 'SQL_QUERY', p_plug_caching=> 'NOT_CACHED', p_ajax_enabled=> 'Y', p_query_row_template=> 936900209975865391+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_show_nulls_as=> ' - ', p_query_break_cols=> '0', p_query_no_data_found=> 'no data found', p_query_num_rows_type=> 'NEXT_PREVIOUS_LINKS', p_query_row_count_max=> '500', p_pagination_display_position=> 'BOTTOM_RIGHT', p_csv_output=> 'N', p_query_asc_image=> 'apex/builder/dup.gif', p_query_asc_image_attr=> 'width="16" height="16" alt="" ', p_query_desc_image=> 'apex/builder/ddown.gif', p_query_desc_image_attr=> 'width="16" height="16" alt="" ', p_plug_query_strip_html=> 'Y', p_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937089517705226403 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 1, p_form_element_id=> null, p_column_alias=> 'SID', p_column_display_sequence=> 1, p_column_heading=> 'SID', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937089623298226404 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 2, p_form_element_id=> null, p_column_alias=> 'STATUS', p_column_display_sequence=> 2, p_column_heading=> 'STATUS', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937089726801226404 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 3, p_form_element_id=> null, p_column_alias=> 'USERNAME', p_column_display_sequence=> 3, p_column_heading=> 'USERNAME', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937089810906226404 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 4, p_form_element_id=> null, p_column_alias=> 'PROCESS', p_column_display_sequence=> 4, p_column_heading=> 'PROCESS', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937089930426226404 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 5, p_form_element_id=> null, p_column_alias=> 'LOGON_TIME', p_column_display_sequence=> 5, p_column_heading=> 'LOGON_TIME', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937090019116226404 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 6, p_form_element_id=> null, p_column_alias=> 'SINCE', p_column_display_sequence=> 6, p_column_heading=> 'Since', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_column_height=> '1', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937090124110226404 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 7, p_form_element_id=> null, p_column_alias=> 'SERVER', p_column_display_sequence=> 7, p_column_heading=> 'SERVER', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937090232577226404 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 8, p_form_element_id=> null, p_column_alias=> 'TYPE', p_column_display_sequence=> 8, p_column_heading=> 'TYPE', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937090312808226404 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 9, p_form_element_id=> null, p_column_alias=> 'SPID', p_column_display_sequence=> 9, p_column_heading=> 'SPID', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937090412684226405 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 10, p_form_element_id=> null, p_column_alias=> 'TRACEID', p_column_display_sequence=> 10, p_column_heading=> 'TRACEID', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937090515540226405 + wwv_flow_api.g_id_offset, p_region_id=> 937089208090226396 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 11, p_form_element_id=> null, p_column_alias=> 'SERIAL#', p_column_display_sequence=> 11, p_column_heading=> 'SERIAL#', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select osuser,machine,terminal,CLIENT_INFO,CLIENT_IDENTIFIER'||unistr('\000a')|| ' from v$session'||unistr('\000a')|| ' where sid = :P10_SID'; wwv_flow_api.create_report_region ( p_id=> 937090719519229674 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 10, p_name=> 'Client Info', p_region_name=>'', p_template=> 936890925366865374+ wwv_flow_api.g_id_offset, p_display_sequence=> 41, p_display_column=> 1, p_display_point=> 'AFTER_SHOW_ITEMS', p_source=> s, p_source_type=> 'SQL_QUERY', p_plug_caching=> 'NOT_CACHED', p_ajax_enabled=> 'Y', p_query_row_template=> 936900209975865391+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_show_nulls_as=> ' - ', p_query_break_cols=> '0', p_query_no_data_found=> 'no data found', p_query_num_rows_type=> 'NEXT_PREVIOUS_LINKS', p_query_row_count_max=> '500', p_pagination_display_position=> 'BOTTOM_RIGHT', p_csv_output=> 'N', p_query_asc_image=> 'apex/builder/dup.gif', p_query_asc_image_attr=> 'width="16" height="16" alt="" ', p_query_desc_image=> 'apex/builder/ddown.gif', p_query_desc_image_attr=> 'width="16" height="16" alt="" ', p_plug_query_strip_html=> 'Y', p_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937091010589229680 + wwv_flow_api.g_id_offset, p_region_id=> 937090719519229674 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 1, p_form_element_id=> null, p_column_alias=> 'OSUSER', p_column_display_sequence=> 1, p_column_heading=> 'OSUSER', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937091120962229680 + wwv_flow_api.g_id_offset, p_region_id=> 937090719519229674 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 2, p_form_element_id=> null, p_column_alias=> 'MACHINE', p_column_display_sequence=> 2, p_column_heading=> 'MACHINE', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937091228053229680 + wwv_flow_api.g_id_offset, p_region_id=> 937090719519229674 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 3, p_form_element_id=> null, p_column_alias=> 'TERMINAL', p_column_display_sequence=> 3, p_column_heading=> 'TERMINAL', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937091331898229680 + wwv_flow_api.g_id_offset, p_region_id=> 937090719519229674 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 4, p_form_element_id=> null, p_column_alias=> 'CLIENT_INFO', p_column_display_sequence=> 4, p_column_heading=> 'CLIENT_INFO', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937091411710229680 + wwv_flow_api.g_id_offset, p_region_id=> 937090719519229674 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 5, p_form_element_id=> null, p_column_alias=> 'CLIENT_IDENTIFIER', p_column_display_sequence=> 5, p_column_heading=> 'CLIENT_IDENTIFIER', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select decode(command, '||unistr('\000a')|| ' 0,null, '||unistr('\000a')|| ' 1,''CRE TAB'', '||unistr('\000a')|| ' 2,''INSERT'', '||unistr('\000a')|| ' 3,''SELECT'', '||unistr('\000a')|| ' '; s:=s||' 4,''CRE CLUSTER'', '||unistr('\000a')|| ' 5,''ALT CLUSTER'', '||unistr('\000a')|| ' 6,''UPDATE'', '||unistr('\000a')|| ' 7,''DELETE'', '||unistr('\000a')|| ' 8,''DRP CLUSTER'', '||unistr('\000a')|| ' '; s:=s||' 9,''CRE INDEX'', '||unistr('\000a')|| ' 10,''DROP INDEX'', '||unistr('\000a')|| ' 11,''ALT INDEX'', '||unistr('\000a')|| ' 12,''DROP TABLE'', '||unistr('\000a')|| ' 13,''CRE SE'; s:=s||'Q'', '||unistr('\000a')|| ' 14,''ALT SEQ'', '||unistr('\000a')|| ' 15,''ALT TABLE'', '||unistr('\000a')|| ' 16,''DROP SEQ'', '||unistr('\000a')|| ' 17,''GRANT'', '||unistr('\000a')|| ' '; s:=s||' 18,''REVOKE'', '||unistr('\000a')|| ' 19,''CRE SYN'', '||unistr('\000a')|| ' 20,''DROP SYN'', '||unistr('\000a')|| ' 21,''CRE VIEW'', '||unistr('\000a')|| ' 22,''DROP VIEW'', '||unistr('\000a')|| ' '; s:=s||' 23,''VAL INDEX'', '||unistr('\000a')|| ' 24,''CRE PROC'', '||unistr('\000a')|| ' 25,''ALT PROC'', '||unistr('\000a')|| ' 26,''LOCK TABLE'', '||unistr('\000a')|| ' 28,''RENAME'', '||unistr('\000a')|| ' '; s:=s||' 29,''COMMENT'', '||unistr('\000a')|| ' 30,''AUDIT'', '||unistr('\000a')|| ' 31,''NOAUDIT'', '||unistr('\000a')|| ' 32,''CRE DBLINK'', '||unistr('\000a')|| ' 33,'; s:=s||'''DROP DBLINK'', '||unistr('\000a')|| ' 34,''CRE DB'', '||unistr('\000a')|| ' 35,''ALTER DB'', '||unistr('\000a')|| ' 36,''CRE RBS'', '||unistr('\000a')|| ' 37,''ALT RBS'', '||unistr('\000a')|| ' '; s:=s||' 38,''DROP RBS'', '||unistr('\000a')|| ' 39,''CRE TBLSPC'', '||unistr('\000a')|| ' 40,''ALT TBLSPC'', '||unistr('\000a')|| ' 41,''DROP TBLSPC'', '||unistr('\000a')|| ' 42,''ALT SESSION'', '||unistr('\000a')|| ' '; s:=s||' 43,''ALT USER'', '||unistr('\000a')|| ' 44,''COMMIT'', '||unistr('\000a')|| ' 45,''ROLLBACK'', '||unistr('\000a')|| ' 46,''SAVEPOINT'', '||unistr('\000a')|| ' 47,''P'; s:=s||'L/SQL EXEC'', '||unistr('\000a')|| ' 48,''SET XACTN'', '||unistr('\000a')|| ' 49,''SWITCH LOG'', '||unistr('\000a')|| ' 50,''EXPLAIN'', '||unistr('\000a')|| ' 51,''CRE USER'', '||unistr('\000a')|| ' '; s:=s||' 52,''CRE ROLE'', '||unistr('\000a')|| ' 53,''DROP USER'', '||unistr('\000a')|| ' 54,''DROP ROLE'', '||unistr('\000a')|| ' 55,''SET ROLE'', '||unistr('\000a')|| ' 56,''CRE SCHEMA'', '||unistr('\000a')|| ' '; s:=s||' 57,''CRE CTLFILE'', '||unistr('\000a')|| ' 58,''ALTER TRACING'', '||unistr('\000a')|| ' 59,''CRE TRIGGER'', '||unistr('\000a')|| ' 60,''ALT TRIGGER'', '||unistr('\000a')|| ' '; s:=s||' 61,''DRP TRIGGER'', '||unistr('\000a')|| ' 62,''ANALYZE TAB'', '||unistr('\000a')|| ' 63,''ANALYZE IX'', '||unistr('\000a')|| ' 64,''ANALYZE CLUS'', '||unistr('\000a')|| ' 65,''CRE PROFILE'', '||unistr('\000a')|| ' '; s:=s||' 66,''DRP PROFILE'', '||unistr('\000a')|| ' 67,''ALT PROFILE'', '||unistr('\000a')|| ' 68,''DRP PROC'', '||unistr('\000a')|| ' 69,''DRP PROC'', '||unistr('\000a')|| ' 70,''AL'; s:=s||'T RESOURCE'', '||unistr('\000a')|| ' 71,''CRE SNPLOG'', '||unistr('\000a')|| ' 72,''ALT SNPLOG'', '||unistr('\000a')|| ' 73,''DROP SNPLOG'', '||unistr('\000a')|| ' 74,''CREATE SNAP'', '||unistr('\000a')|| ' '; s:=s||' 75,''ALT SNAP'', '||unistr('\000a')|| ' 76,''DROP SNAP'', '||unistr('\000a')|| ' 79,''ALTER ROLE'', '||unistr('\000a')|| ' 79,''ALTER ROLE'', '||unistr('\000a')|| ' 85,''TRUNC TAB'', '||unistr('\000a')|| ' '; s:=s||' 86,''TRUNC CLUST'', '||unistr('\000a')|| ' 88,''ALT VIEW'', '||unistr('\000a')|| ' 91,''CRE FUNC'', '||unistr('\000a')|| ' 92,''ALT FUNC'', '||unistr('\000a')|| ' '; s:=s||' 93,''DROP FUNC'', '||unistr('\000a')|| ' 94,''CRE PKG'', '||unistr('\000a')|| ' 95,''ALT PKG'', '||unistr('\000a')|| ' 96,''DROP PKG'', '||unistr('\000a')|| ' 97,''CRE PKG BODY'', '||unistr('\000a')|| ' '; s:=s||' 98,''ALT PKG BODY'', '||unistr('\000a')|| ' 99,''DRP PKG BODY'', '||unistr('\000a')|| ' to_char(command)) "Command"'||unistr('\000a')|| ' ,LAST_CALL_ET,program,module,action'||unistr('\000a')|| ' from v$session where sid = :P10_SID'; wwv_flow_api.create_report_region ( p_id=> 937091532332233449 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 10, p_name=> 'Application Info', p_region_name=>'', p_template=> 936890925366865374+ wwv_flow_api.g_id_offset, p_display_sequence=> 51, p_display_column=> 1, p_display_point=> 'AFTER_SHOW_ITEMS', p_source=> s, p_source_type=> 'SQL_QUERY', p_plug_caching=> 'NOT_CACHED', p_ajax_enabled=> 'Y', p_query_row_template=> 936900209975865391+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_show_nulls_as=> ' - ', p_query_break_cols=> '0', p_query_no_data_found=> 'no data found', p_query_num_rows_type=> 'NEXT_PREVIOUS_LINKS', p_query_row_count_max=> '500', p_pagination_display_position=> 'BOTTOM_RIGHT', p_csv_output=> 'N', p_query_asc_image=> 'apex/builder/dup.gif', p_query_asc_image_attr=> 'width="16" height="16" alt="" ', p_query_desc_image=> 'apex/builder/ddown.gif', p_query_desc_image_attr=> 'width="16" height="16" alt="" ', p_plug_query_strip_html=> 'Y', p_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937091802609233464 + wwv_flow_api.g_id_offset, p_region_id=> 937091532332233449 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 1, p_form_element_id=> null, p_column_alias=> 'Command', p_column_display_sequence=> 1, p_column_heading=> 'Command', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937091929265233466 + wwv_flow_api.g_id_offset, p_region_id=> 937091532332233449 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 2, p_form_element_id=> null, p_column_alias=> 'LAST_CALL_ET', p_column_display_sequence=> 2, p_column_heading=> 'LAST_CALL_ET', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937092022506233466 + wwv_flow_api.g_id_offset, p_region_id=> 937091532332233449 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 3, p_form_element_id=> null, p_column_alias=> 'PROGRAM', p_column_display_sequence=> 3, p_column_heading=> 'PROGRAM', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937092129617233466 + wwv_flow_api.g_id_offset, p_region_id=> 937091532332233449 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 4, p_form_element_id=> null, p_column_alias=> 'MODULE', p_column_display_sequence=> 4, p_column_heading=> 'Module', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 937092207605233466 + wwv_flow_api.g_id_offset, p_region_id=> 937091532332233449 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 5, p_form_element_id=> null, p_column_alias=> 'ACTION', p_column_display_sequence=> 5, p_column_heading=> 'ACTION', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'ESCAPE_SC', p_is_required=> false, p_pk_col_source=> s, p_column_comment=>''); end; / begin null; end; / begin null; end; / declare h varchar2(32767) := null; begin h := null; h:=h||'The Database Session identifier for which the details are displayed.'; wwv_flow_api.create_page_item( p_id=>937087817525210273 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 10, p_name=>'P10_SID', p_data_type=> 'VARCHAR', p_is_required=> false, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 5280205953553414+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type=> 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'SID', p_source_type=> 'STATIC', p_display_as=> 'NATIVE_DISPLAY_ONLY', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, 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_field_template=> 936904524832865485+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'YES', p_protection_level => 'N', p_escape_on_http_output => 'Y', p_help_text=> h, p_attribute_01 => 'N', p_attribute_02 => 'VALUE', p_attribute_04 => 'Y', p_show_quick_picks=>'N', p_item_comment => ''); end; / begin --------------------------------------- -- ...updatable report columns for page 10 -- begin null; end; null; end; / --application/pages/page_00101 prompt ...PAGE 101: Login -- begin wwv_flow_api.create_page ( p_flow_id => wwv_flow.g_flow_id ,p_id => 101 ,p_name => 'Login' ,p_alias => 'LOGIN' ,p_step_title => 'Login' ,p_allow_duplicate_submissions => 'Y' ,p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS' ,p_first_item => 'AUTO_FIRST_ITEM' ,p_include_apex_css_js_yn => 'Y' ,p_autocomplete_on_off => 'OFF' ,p_step_template => 936879405068865354 + wwv_flow_api.g_id_offset ,p_required_role => 936944301397349617 + wwv_flow_api.g_id_offset ,p_page_is_public_y_n => 'N' ,p_protection_level => 'N' ,p_cache_page_yn => 'N' ,p_cache_timeout_seconds => 21600 ,p_cache_by_user_yn => 'N' ,p_last_updated_by => 'JOEL' ,p_last_upd_yyyymmddhh24miss => '20110302104034' ); null; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 936873806486859951 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 101, p_plug_name=> 'Login', p_region_name=>'', p_escape_on_http_output=>'N', p_plug_template=> 936888203598865371+ 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_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_footer=> '

Login as a database user which has been granted the DBA database role (for example, SYSTEM).

', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / begin null; end; / begin null; end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>936873918730859954 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 101, p_name=>'P101_USERNAME', p_data_type=> '', p_is_required=> false, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 936873806486859951+wwv_flow_api.g_id_offset, p_use_cache_before_default=> '', p_prompt=>'Username', p_display_as=> 'NATIVE_TEXT_FIELD', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 40, p_cMaxlength=> 100, p_cHeight=> null, p_begin_on_new_line=> 'YES', p_begin_on_new_field=> 'YES', p_colspan=> 2, p_rowspan=> 1, p_label_alignment=> 'RIGHT', p_field_alignment=> 'LEFT', p_field_template=> 936904524832865485+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_attribute_01 => 'N', p_attribute_02 => 'N', p_attribute_03 => 'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>936874025479859956 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 101, p_name=>'P101_PASSWORD', p_data_type=> '', p_is_required=> false, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 936873806486859951+wwv_flow_api.g_id_offset, p_use_cache_before_default=> '', p_prompt=>'Password', p_display_as=> 'NATIVE_PASSWORD', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 40, p_cMaxlength=> 100, p_cHeight=> null, 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=> 936904524832865485+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_attribute_01 => 'Y', p_attribute_02 => 'Y', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>936874124128859956 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 101, p_name=>'P101_LOGIN', p_data_type=> '', p_is_required=> false, p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 30, p_item_plug_id => 936873806486859951+wwv_flow_api.g_id_offset, p_use_cache_before_default=> '', p_item_default=> 'Login', p_prompt=>'Login', p_source=>'LOGIN', p_source_type=> 'STATIC', p_display_as=> 'BUTTON', p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> null, p_cMaxlength=> null, p_cHeight=> null, p_tag_attributes => 'template:'||to_char(936883817777865362 + wwv_flow_api.g_id_offset), 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_button_action => 'SUBMIT', p_button_is_hot=>'N', p_item_comment => ''); end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'begin'||unistr('\000a')|| 'owa_util.mime_header(''text/html'', FALSE);'||unistr('\000a')|| 'owa_cookie.send('||unistr('\000a')|| ' name=>''LOGIN_USERNAME_COOKIE'','||unistr('\000a')|| ' value=>lower(:P101_USERNAME));'||unistr('\000a')|| 'exception when others then null;'||unistr('\000a')|| 'end;'; wwv_flow_api.create_page_process( p_id => 936874317214859958 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 101, p_process_sequence=> 10, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'PLSQL', p_process_name=> 'Set Username Cookie', p_process_sql_clob => p, p_process_error_message=> '', p_error_display_location=> 'ON_ERROR_PAGE', p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'wwv_flow_custom_auth_std.login('||unistr('\000a')|| ' P_UNAME => :P101_USERNAME,'||unistr('\000a')|| ' P_PASSWORD => :P101_PASSWORD,'||unistr('\000a')|| ' P_SESSION_ID => v(''APP_SESSION''),'||unistr('\000a')|| ' P_FLOW_PAGE => :APP_ID||'':1'''||unistr('\000a')|| ' );'; wwv_flow_api.create_page_process( p_id => 936874223036859957 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 101, p_process_sequence=> 20, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'PLSQL', p_process_name=> 'Login', p_process_sql_clob => p, p_process_error_message=> '', p_error_display_location=> 'ON_ERROR_PAGE', p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'101'; wwv_flow_api.create_page_process( p_id => 936874507927859959 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 101, p_process_sequence=> 30, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'CLEAR_CACHE_FOR_PAGES', p_process_name=> 'Clear Page(s) Cache', p_process_sql_clob => p, p_process_error_message=> '', p_error_display_location=> 'ON_ERROR_PAGE', p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'declare'||unistr('\000a')|| ' v varchar2(255) := null;'||unistr('\000a')|| ' c owa_cookie.cookie;'||unistr('\000a')|| 'begin'||unistr('\000a')|| ' c := owa_cookie.get(''LOGIN_USERNAME_COOKIE'');'||unistr('\000a')|| ' :P101_USERNAME := c.vals(1);'||unistr('\000a')|| 'exception when others then null;'||unistr('\000a')|| 'end;'; wwv_flow_api.create_page_process( p_id => 936874408065859958 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 101, p_process_sequence=> 10, p_process_point=> 'BEFORE_HEADER', p_process_type=> 'PLSQL', p_process_name=> 'Get Username Cookie', p_process_sql_clob => p, p_process_error_message=> '', p_error_display_location=> 'ON_ERROR_PAGE', p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin --------------------------------------- -- ...updatable report columns for page 101 -- begin null; end; null; end; / prompt ...lists -- --application/shared_components/navigation/lists/main_links begin wwv_flow_api.create_list ( p_id=> 8538002419844773 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'Main Links', p_list_type=> 'STATIC', p_list_query=>'', p_list_status=> 'PUBLIC', p_list_displayed=> 'BY_DEFAULT', p_display_row_template_id=> 936898727314865389 + wwv_flow_api.g_id_offset); wwv_flow_api.create_list_item ( p_id=> 8538200320844776 + wwv_flow_api.g_id_offset, p_list_id=> 8538002419844773 + 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=> 'Storage', p_list_item_link_target=> 'f?p=&APP_ID.:2:&SESSION.::&DEBUG.::::', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_text_02=> 'View currently used storage.', p_list_text_03=> 'Storage', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_current_for_pages=> '2', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 8538408854844778 + wwv_flow_api.g_id_offset, p_list_id=> 8538002419844773 + 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=> 'Sessions', p_list_item_link_target=> 'f?p=&APP_ID.:4:&SESSION.::&DEBUG.::::', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_text_02=> 'View current database sessions.', p_list_text_03=> 'Sessions', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_current_for_pages=> '4', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 8538705222844779 + wwv_flow_api.g_id_offset, p_list_id=> 8538002419844773 + 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=> 'Parameters', p_list_item_link_target=> 'f?p=&APP_ID.:6:&SESSION.::&DEBUG.::::', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_text_02=> 'View initialization parameters.', p_list_text_03=> 'Parameters', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_current_for_pages=> '6', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 8539017725844779 + wwv_flow_api.g_id_offset, p_list_id=> 8538002419844773 + 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=>40, p_list_item_link_text=> 'Application Express', p_list_item_link_target=> 'f?p=&APP_ID.:7:&SESSION.::&DEBUG.::::', p_list_countclicks_y_n=> 'N', p_list_text_01=> '', p_list_text_02=> 'Get started with Oracle Application Express.', p_list_text_03=> 'Application Express', p_list_item_current_type=> 'COLON_DELIMITED_PAGE_LIST', p_list_item_current_for_pages=> '7', p_list_item_owner=> ''); null; end; / --application/shared_components/navigation/lists/links begin wwv_flow_api.create_list ( p_id=> 937440212637810959 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'Links', p_list_type=> 'STATIC', p_list_query=>'', p_list_status=> 'PUBLIC', p_list_displayed=> 'BY_DEFAULT', p_display_row_template_id=> 936898727314865389 + wwv_flow_api.g_id_offset); wwv_flow_api.create_list_item ( p_id=> 937440427059810960 + wwv_flow_api.g_id_offset, p_list_id=> 937440212637810959 + 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=> 'Online Help ', p_list_item_link_target=> 'http://www.oracle.com/pls/xe112/homepage ', p_list_text_01=> '', p_list_item_current_type=> '', p_list_item_current_for_pages=> 'http://www.oracle.com/pls/xe112/homepage ', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 937440702487811042 + wwv_flow_api.g_id_offset, p_list_id=> 937440212637810959 + 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=> 'Learning Library ', p_list_item_link_target=> 'http://apex.oracle.com/pls/apex/f?p=44785:1 ', p_list_text_01=> '', p_list_item_current_type=> '', p_list_item_current_for_pages=> 'http://apex.oracle.com/pls/apex/f?p=44785:1 ', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 937498918898739890 + wwv_flow_api.g_id_offset, p_list_id=> 937440212637810959 + wwv_flow_api.g_id_offset, p_list_item_type=> '', p_list_item_status=> '', p_item_displayed=> '', p_list_item_display_sequence=>25, p_list_item_link_text=> 'Oracle Technology Network', p_list_item_link_target=> 'http://otn.oracle.com', p_list_text_01=> '', p_list_item_current_type=> '', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 937440900222811042 + wwv_flow_api.g_id_offset, p_list_id=> 937440212637810959 + 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=> 'Oracle SQL Developer ', p_list_item_link_target=> 'http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html ', p_list_text_01=> '', p_list_item_current_type=> '', p_list_item_current_for_pages=> 'http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html ', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 937441219554811042 + wwv_flow_api.g_id_offset, p_list_id=> 937440212637810959 + 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=>40, p_list_item_link_text=> 'Oracle Express Edition ', p_list_item_link_target=> 'http://www.oracle.com/technetwork/database/express-edition/downloads/index.html ', p_list_text_01=> '', p_list_item_current_type=> '', p_list_item_current_for_pages=> 'http://www.oracle.com/technetwork/database/express-edition/downloads/index.html ', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 937441511509811042 + wwv_flow_api.g_id_offset, p_list_id=> 937440212637810959 + 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=>50, p_list_item_link_text=> 'Oracle Application Express ', p_list_item_link_target=> 'http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html ', p_list_text_01=> '', p_list_item_current_type=> '', p_list_item_current_for_pages=> 'http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html ', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 937444608397828656 + wwv_flow_api.g_id_offset, p_list_id=> 937440212637810959 + wwv_flow_api.g_id_offset, p_list_item_type=> '', p_list_item_status=> '', p_item_displayed=> '', p_list_item_display_sequence=>60, p_list_item_link_text=> 'Oracle JDeveloper 11g ', p_list_item_link_target=> 'http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html ', p_list_text_01=> '', p_list_item_current_type=> '', p_list_item_owner=> ''); wwv_flow_api.create_list_item ( p_id=> 937444811514829539 + wwv_flow_api.g_id_offset, p_list_id=> 937440212637810959 + wwv_flow_api.g_id_offset, p_list_item_type=> '', p_list_item_status=> '', p_item_displayed=> '', p_list_item_display_sequence=>70, p_list_item_link_text=> 'Pre-built Developer VMs ', p_list_item_link_target=> 'http://www.oracle.com/technetwork/community/developer-vm/index.html ', p_list_text_01=> '', p_list_item_current_type=> '', p_list_item_owner=> ''); null; end; / --application/shared_components/navigation/breadcrumbs prompt ...breadcrumbs -- begin wwv_flow_api.create_menu ( p_id=> 936874627069859959 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> ' Breadcrumb'); wwv_flow_api.create_menu_option ( p_id=>936875125711859978 + wwv_flow_api.g_id_offset, p_menu_id=>936874627069859959 + wwv_flow_api.g_id_offset, p_parent_id=>0, p_option_sequence=>10, p_short_name=>'Home', p_long_name=>'', p_link=>'f?p=4950:1:&SESSION.', p_page_id=>1, p_also_current_for_pages=> ''); wwv_flow_api.create_menu_option ( p_id=>937074332489121020 + wwv_flow_api.g_id_offset, p_menu_id=>936874627069859959 + wwv_flow_api.g_id_offset, p_parent_id=>936875729665859983 + wwv_flow_api.g_id_offset, p_option_sequence=>10, p_short_name=>'Tablespace Storage Details', p_long_name=>'', p_link=>'f?p=&FLOW_ID.:9:&SESSION.', p_page_id=>9, p_also_current_for_pages=> ''); wwv_flow_api.create_menu_option ( p_id=>937087309372201455 + wwv_flow_api.g_id_offset, p_menu_id=>936874627069859959 + wwv_flow_api.g_id_offset, p_parent_id=>936876913526859988 + wwv_flow_api.g_id_offset, p_option_sequence=>10, p_short_name=>'Session Details', p_long_name=>'', p_link=>'f?p=&FLOW_ID.:10:&SESSION.', p_page_id=>10, p_also_current_for_pages=> ''); wwv_flow_api.create_menu_option ( p_id=>936875729665859983 + wwv_flow_api.g_id_offset, p_menu_id=>936874627069859959 + wwv_flow_api.g_id_offset, p_parent_id=>936875125711859978 + wwv_flow_api.g_id_offset, p_option_sequence=>20, p_short_name=>'Storage', p_long_name=>'', p_link=>'f?p=&APP_ID.:2:&SESSION.::&DEBUG.:::', p_page_id=>2, p_also_current_for_pages=> ''); wwv_flow_api.create_menu_option ( p_id=>936876913526859988 + wwv_flow_api.g_id_offset, p_menu_id=>936874627069859959 + wwv_flow_api.g_id_offset, p_parent_id=>936875125711859978 + wwv_flow_api.g_id_offset, p_option_sequence=>40, p_short_name=>'Sessions', p_long_name=>'', p_link=>'f?p=&APP_ID.:4:&SESSION.::&DEBUG.:::', p_page_id=>4, p_also_current_for_pages=> ''); wwv_flow_api.create_menu_option ( p_id=>936877506648859991 + wwv_flow_api.g_id_offset, p_menu_id=>936874627069859959 + wwv_flow_api.g_id_offset, p_parent_id=>936875125711859978 + wwv_flow_api.g_id_offset, p_option_sequence=>50, p_short_name=>'Backups', p_long_name=>'', p_link=>'f?p=&APP_ID.:5:&SESSION.::&DEBUG.:::', p_page_id=>5, p_also_current_for_pages=> ''); wwv_flow_api.create_menu_option ( p_id=>936878132259859995 + wwv_flow_api.g_id_offset, p_menu_id=>936874627069859959 + wwv_flow_api.g_id_offset, p_parent_id=>936875125711859978 + wwv_flow_api.g_id_offset, p_option_sequence=>60, p_short_name=>'Parameters', p_long_name=>'', p_link=>'f?p=&APP_ID.:6:&SESSION.::&DEBUG.:::', p_page_id=>6, p_also_current_for_pages=> ''); wwv_flow_api.create_menu_option ( p_id=>936878713681859999 + wwv_flow_api.g_id_offset, p_menu_id=>936874627069859959 + wwv_flow_api.g_id_offset, p_parent_id=>936875125711859978 + wwv_flow_api.g_id_offset, p_option_sequence=>70, p_short_name=>'Oracle Application Express', p_long_name=>'', p_link=>'f?p=&APP_ID.:7:&SESSION.::&DEBUG.:::', p_page_id=>7, p_also_current_for_pages=> ''); null; end; / prompt ...page templates for application: 4950 -- --application/shared_components/user_interface/templates/page/login prompt ......Page template 936879405068865354 begin declare c1 varchar2(32767) := null; c2 varchar2(32767) := null; c3 varchar2(32767) := null; l_clob clob; l_length number := 1; begin c1:=c1||''||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| ' #TITLE#'||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' #HEAD#'||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| '#FORM_OPEN#'||unistr('\000a')|| ''; c2:=c2||'#FORM_CLOSE#'||unistr('\000a')|| ''||unistr('\000a')|| ''; c3:=c3||'
'||unistr('\000a')|| '
#SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#
'||unistr('\000a')|| '
#REGION_POSITION_02##BOX_BODY##REGION_POSITION_03#
'||unistr('\000a')|| '
'||unistr('\000a')|| ''; wwv_flow_api.create_template( p_id=> 936879405068865354 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'Login', p_body_title=> '', p_header_template=> c1, p_box=> c3, p_footer_template=> c2, p_success_message=> '
'||unistr('\000a')|| ' '||unistr('\000a')|| ' #SUCCESS_MESSAGE#'||unistr('\000a')|| '
', 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=> '
'||unistr('\000a')|| ' #MESSAGE#'||unistr('\000a')|| '
', 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="0"', p_theme_id => 21, p_theme_class_id => 6, p_translate_this_template => 'N', p_mobile_page_template => 'N', p_template_comment => '18'); end; null; end; / --application/shared_components/user_interface/templates/page/no_tabs_right_sidebar_optional_table_based prompt ......Page template 936880509857865357 begin declare c1 varchar2(32767) := null; c2 varchar2(32767) := null; c3 varchar2(32767) := null; l_clob clob; l_length number := 1; begin c1:=c1||''||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| ' #TITLE#'||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' #HEAD#'||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| '#FORM_OPEN#'||unistr('\000a')|| ''; c2:=c2||''||unistr('\000a')|| '#FORM_CLOSE#'||unistr('\000a')|| ''||unistr('\000a')|| ''; c3:=c3||''||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
#REGION'; c3:=c3||'_POSITION_01##REGION_POSITION_04#
'||unistr('\000a')|| '
#SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#
'||unistr('\000a')|| '
'||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '; c3:=c3||' '||unistr('\000a')|| '
#REGION_POSITION_02##BOX_BODY##REGION_POSITION_03#
'||unistr('\000a')|| '
'; wwv_flow_api.create_template( p_id=> 936880509857865357 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'No Tabs - Right Sidebar (optional / table-based)', p_body_title=> '', p_header_template=> c1, p_box=> c3, p_footer_template=> c2, p_success_message=> '
'||unistr('\000a')|| ' '||unistr('\000a')|| ' #SUCCESS_MESSAGE#'||unistr('\000a')|| '
', 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=> '
'||unistr('\000a')|| ' #MESSAGE#'||unistr('\000a')|| '
', 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="0" width="100%"', p_sidebar_def_reg_pos => 'REGION_POSITION_02', p_breadcrumb_def_reg_pos => 'REGION_POSITION_01', p_theme_id => 21, p_theme_class_id => 3, p_error_page_template => '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| ' #ADDITIONAL_INFO#'||unistr('\000a')|| ' #MESSAGE#'||unistr('\000a')|| '

'||unistr('\000a')|| ' '||unistr('\000a')|| '

'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
'||unistr('\000a')|| '
', p_translate_this_template => 'N', p_mobile_page_template => 'N', p_template_comment => ''); end; null; end; / --application/shared_components/user_interface/templates/page/one_level_tabs_right_sidebar_optional_table_based prompt ......Page template 936881728833865360 begin declare c1 varchar2(32767) := null; c2 varchar2(32767) := null; c3 varchar2(32767) := null; l_clob clob; l_length number := 1; begin c1:=c1||''||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| ' #TITLE#'||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' #HEAD#'||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| '#FORM_OPEN#'||unistr('\000a')|| ''; c2:=c2||''||unistr('\000a')|| '#FORM_CLOSE#'||unistr('\000a')|| ''||unistr('\000a')|| ''; c3:=c3||''||unistr('\000a')|| ''||unistr('\000a')|| '
#REGION_POSITION_01##REGION_POSITION_04#
'||unistr('\000a')|| '
#S'; c3:=c3||'UCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#
'||unistr('\000a')|| '
'||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| '
#REGION_POSITION_02##BOX_BODY##REGION_POSITION_03#
'||unistr('\000a')|| '
'; wwv_flow_api.create_template( p_id=> 936881728833865360 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'One Level Tabs - Right Sidebar (optional / table-based)', p_body_title=> '', p_header_template=> c1, p_box=> c3, p_footer_template=> c2, p_success_message=> '
'||unistr('\000a')|| ' '||unistr('\000a')|| ' #SUCCESS_MESSAGE#'||unistr('\000a')|| '
', p_current_tab=> '
  • '||unistr('\000a')|| '#TAB_LABEL##TAB_INLINE_EDIT#'||unistr('\000a')|| '
  • ', p_current_tab_font_attr=> '', p_non_current_tab=> '
  • '||unistr('\000a')|| '#TAB_LABEL##TAB_INLINE_EDIT#'||unistr('\000a')|| '
  • ', 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=> '
    '||unistr('\000a')|| ' #MESSAGE#'||unistr('\000a')|| '
    ', 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=> '', p_breadcrumb_def_reg_pos => 'REGION_POSITION_01', p_theme_id => 21, p_theme_class_id => 1, p_translate_this_template => 'N', p_mobile_page_template => 'N', p_template_comment => ''); end; null; end; / --application/shared_components/user_interface/templates/page/printer_friendly prompt ......Page template 936882328801865361 begin declare c1 varchar2(32767) := null; c2 varchar2(32767) := null; c3 varchar2(32767) := null; l_clob clob; l_length number := 1; begin c1:=c1||''||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| ' #TITLE#'||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' #HEAD#'||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| '#FORM_OPEN#'; c2:=c2||'#FORM_CLOSE#'||unistr('\000a')|| ''||unistr('\000a')|| ''; c3:=c3||''||unistr('\000a')|| '
    '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| '
    #REGION_POSITION_02##BOX_BODY##REGION_POSITION_03#
    '||unistr('\000a')|| '
    '||unistr('\000a')|| ''; wwv_flow_api.create_template( p_id=> 936882328801865361 + 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=> '', 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=> '', p_navigation_bar=> '', 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="0" width="100%"', p_theme_id => 21, p_theme_class_id => 5, p_translate_this_template => 'N', p_mobile_page_template => 'N', p_template_comment => '3'); end; null; end; / prompt ...button templates -- --application/shared_components/user_interface/templates/button/button prompt ......Button Template 936883817777865362 begin wwv_flow_api.create_button_templates ( p_id => 936883817777865362 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_template_name => 'Button' ,p_template => '' ,p_translate_this_template => 'N' ,p_theme_class_id => 1 ,p_theme_id => 21 ); null; end; / --application/shared_components/user_interface/templates/button/hot_button_red prompt ......Button Template 936884428414865363 begin wwv_flow_api.create_button_templates ( p_id => 936884428414865363 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_template_name => 'Hot Button (Red)' ,p_template => '' ,p_translate_this_template => 'N' ,p_theme_class_id => 4 ,p_theme_id => 21 ); null; end; / --------------------------------------- prompt ...region templates -- --application/shared_components/user_interface/templates/region/breadcrumb_region prompt ......region template 936886425092865365 begin wwv_flow_api.create_plug_template ( p_id => 936886425092865365 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_template => '' ,p_page_plug_template_name => 'Breadcrumb Region' ,p_render_form_items_in_table => 'Y' ,p_theme_id => 21 ,p_theme_class_id => 6 ,p_translate_this_template => 'N' ,p_template_comment => 'Use this region template to contain breadcrumb menus. Breadcrumb menus are implemented using breadcrumbs. Breadcrumb menus are designed to displayed in #REGION_POSITION_01#' ); null; end; / begin declare t2 varchar2(32767) := null; begin t2 := null; wwv_flow_api.set_plug_template_tab_attr ( p_id=> 936886425092865365 + 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/form_region prompt ......region template 936888203598865371 begin wwv_flow_api.create_plug_template ( p_id => 936888203598865371 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_template => '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    #TITLE#
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    #CLOSE##PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP#
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '#BODY#
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    ' ,p_page_plug_template_name => 'Form Region' ,p_render_form_items_in_table => 'Y' ,p_plug_table_bgcolor => '#f7f7e7' ,p_theme_id => 21 ,p_theme_class_id => 8 ,p_plug_heading_bgcolor => '#f7f7e7' ,p_plug_font_size => '-1' ,p_translate_this_template => 'N' ,p_template_comment => 'Red Theme' ); null; end; / begin declare t2 varchar2(32767) := null; begin t2 := null; wwv_flow_api.set_plug_template_tab_attr ( p_id=> 936888203598865371 + 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/region_without_buttons_and_titles prompt ......region template 936889721148865373 begin wwv_flow_api.create_plug_template ( p_id => 936889721148865373 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_template => '
    '||unistr('\000a')|| '
    #BODY#
    '||unistr('\000a')|| '
    ' ,p_page_plug_template_name => 'Region without Buttons and Titles' ,p_render_form_items_in_table => 'Y' ,p_theme_id => 21 ,p_theme_class_id => 19 ,p_translate_this_template => 'N' ); null; end; / begin declare t2 varchar2(32767) := null; begin t2 := null; wwv_flow_api.set_plug_template_tab_attr ( p_id=> 936889721148865373 + 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/reports_region prompt ......region template 936890925366865374 begin wwv_flow_api.create_plug_template ( p_id => 936890925366865374 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_template => '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    #TITLE#
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    #CLOSE##PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP#
    '||unistr('\000a')|| '
    #BODY#
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    ' ,p_page_plug_template_name => 'Reports Region' ,p_render_form_items_in_table => 'Y' ,p_plug_table_bgcolor => '#ffffff' ,p_theme_id => 21 ,p_theme_class_id => 9 ,p_plug_heading_bgcolor => '#ffffff' ,p_plug_font_size => '-1' ,p_translate_this_template => 'N' ,p_template_comment => 'Red Theme' ); null; end; / begin declare t2 varchar2(32767) := null; begin t2 := null; wwv_flow_api.set_plug_template_tab_attr ( p_id=> 936890925366865374 + 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/reports_region_no_title prompt ......region template 936891504925865375 begin wwv_flow_api.create_plug_template ( p_id => 936891504925865375 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_template => '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| ' #BODY#'||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| ' #CLOSE##PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##'|| 'EXPAND##COPY##HELP#'||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    ' ,p_page_plug_template_name => 'Reports Region No Title' ,p_render_form_items_in_table => 'Y' ,p_theme_id => 21 ,p_theme_class_id => 9 ,p_translate_this_template => 'N' ); null; end; / begin declare t2 varchar2(32767) := null; begin t2 := null; wwv_flow_api.set_plug_template_tab_attr ( p_id=> 936891504925865375 + 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/reports_region_alternative_1 prompt ......region template 936892120369865376 begin wwv_flow_api.create_plug_template ( p_id => 936892120369865376 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_template => '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    #TITLE#
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    #CLOSE##PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP#
    '||unistr('\000a')|| '
    #BODY#
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '
    '||unistr('\000a')|| '' ,p_page_plug_template_name => 'Reports Region, Alternative 1' ,p_render_form_items_in_table => 'Y' ,p_plug_table_bgcolor => '#ffffff' ,p_theme_id => 21 ,p_theme_class_id => 10 ,p_plug_heading_bgcolor => '#ffffff' ,p_plug_font_size => '-1' ,p_translate_this_template => 'N' ,p_template_comment => 'Red Theme' ); null; end; / begin declare t2 varchar2(32767) := null; begin t2 := null; wwv_flow_api.set_plug_template_tab_attr ( p_id=> 936892120369865376 + 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/main_links_list prompt ......list template 8548028083899041 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||' '||unistr('\000a')|| ' '||unistr('\000a')|| '

    #TEXT#

    '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| '

    #A02#

    '||unistr('\000a')|| ' '||unistr('\000a')|| ' '; t2:=t2||' '||unistr('\000a')|| ' '||unistr('\000a')|| '

    #TEXT#

    '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| ' '||unistr('\000a')|| '

    #A02#

    '||unistr('\000a')|| ' '||unistr('\000a')|| ' '; t3 := null; t4 := null; t5 := null; t6 := null; t7 := null; t8 := null; wwv_flow_api.create_list_template ( p_id=>8548028083899041 + 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=>'Main Links List', p_theme_id => 21, p_theme_class_id => 1, p_list_template_before_rows=>''||unistr('\000a')|| ''||unistr('\000a')|| '', p_list_template_after_rows=>'
    ', p_reference_id=>918801307562918415, p_translate_this_template => 'N', p_list_template_comment=>''); end; null; end; / --application/shared_components/user_interface/templates/list/vertical_unordered_list_with_bullets prompt ......list template 936898727314865389 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=>936898727314865389 + 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=>'Vertical Unordered List with Bullets', p_theme_id => 21, p_theme_class_id => 1, p_list_template_before_rows=>'', p_translate_this_template => 'N', p_list_template_comment=>''); end; null; end; / prompt ...report templates -- --application/shared_components/user_interface/templates/report/borderless_report prompt ......report template 936900209975865391 begin declare c1 varchar2(32767) := null; c2 varchar2(32767) := null; c3 varchar2(32767) := null; c4 varchar2(32767) := null; begin c1:=c1||'#COLUMN_VALUE#'; c2 := null; c3 := null; c4 := null; wwv_flow_api.create_row_template ( p_id=> 936900209975865391 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_row_template_name=> 'Borderless Report', p_row_template1=> c1, p_row_template_condition1=> '', p_row_template2=> c2, p_row_template_condition2=> '', p_row_template3=> c3, p_row_template_condition3=> '', p_row_template4=> c4, p_row_template_condition4=> '', p_row_template_before_rows=>'#TOP_PAGINATION#'||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| '#PAGINATION#'||unistr('\000a')|| '
    ', p_row_template_after_rows =>'
    #EXTERNAL_LINK##CSV_LINK#
    ', p_row_template_table_attr =>'', p_row_template_type =>'GENERIC_COLUMNS', p_column_heading_template=>'#COLUMN_HEADER#', p_row_template_display_cond1=>'0', p_row_template_display_cond2=>'0', p_row_template_display_cond3=>'0', p_row_template_display_cond4=>'0', p_next_page_template=>'#PAGINATION_NEXT#', p_previous_page_template=>'#PAGINATION_PREVIOUS#', p_next_set_template=>'#PAGINATION_NEXT_SET#', p_previous_set_template=>'#PAGINATION_PREVIOUS_SET#', p_theme_id => 21, p_theme_class_id => 1, p_translate_this_template => 'N', p_row_template_comment=> ''); end; null; end; / begin begin wwv_flow_api.create_row_template_patch ( p_id => 936900209975865391 + wwv_flow_api.g_id_offset, p_row_template_before_first =>'', p_row_template_after_last =>''); exception when others then null; end; null; end; / --application/shared_components/user_interface/templates/report/standard prompt ......report template 936902514655865394 begin declare c1 varchar2(32767) := null; c2 varchar2(32767) := null; c3 varchar2(32767) := null; c4 varchar2(32767) := null; begin c1:=c1||'#COLUMN_VALUE#'; c2 := null; c3 := null; c4 := null; wwv_flow_api.create_row_template ( p_id=> 936902514655865394 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_row_template_name=> 'Standard', p_row_template1=> c1, p_row_template_condition1=> '', p_row_template2=> c2, p_row_template_condition2=> '', p_row_template3=> c3, p_row_template_condition3=> '', p_row_template4=> c4, p_row_template_condition4=> '', p_row_template_before_rows=>'#TOP_PAGINATION#'||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| ''||unistr('\000a')|| '#PAGINATION#'||unistr('\000a')|| '
    ', p_row_template_after_rows =>'
    #EXTERNAL_LINK##CSV_LINK#
    ', p_row_template_table_attr =>'', p_row_template_type =>'GENERIC_COLUMNS', p_column_heading_template=>'#COLUMN_HEADER#', p_row_template_display_cond1=>'0', p_row_template_display_cond2=>'0', p_row_template_display_cond3=>'0', p_row_template_display_cond4=>'0', p_next_page_template=>'#PAGINATION_NEXT#', p_previous_page_template=>'#PAGINATION_PREVIOUS#', p_next_set_template=>'#PAGINATION_NEXT_SET#', p_previous_set_template=>'#PAGINATION_PREVIOUS_SET#', p_row_style_mouse_over=>'#F0F0F0', p_row_style_checked=>'#E8E8E8', p_theme_id => 21, p_theme_class_id => 4, p_translate_this_template => 'N', p_row_template_comment=> ''); end; null; end; / begin begin wwv_flow_api.create_row_template_patch ( p_id => 936902514655865394 + wwv_flow_api.g_id_offset, p_row_template_before_first =>'', p_row_template_after_last =>''); exception when others then null; end; null; end; / prompt ...label templates -- --application/shared_components/user_interface/templates/label/optional_with_help prompt ......label template 936904524832865485 begin begin wwv_flow_api.create_field_template ( p_id=> 936904524832865485 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_template_name=>'Optional with help', p_template_body1=>'', p_before_item=>'', p_after_item=>'', p_on_error_before_label=>'
    ', p_on_error_after_label=>'
    #ERROR_MESSAGE#
    ', p_theme_id => 21, p_theme_class_id => 1, p_translate_this_template=> 'N', p_template_comment=> ''); end; null; end; / --application/shared_components/user_interface/templates/label/required_with_help prompt ......label template 936904703644865485 begin begin wwv_flow_api.create_field_template ( p_id=> 936904703644865485 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_template_name=>'Required with help', p_template_body1=>'', p_before_item=>'', p_after_item=>'', p_on_error_before_label=>'
    ', p_on_error_after_label=>'
    #ERROR_MESSAGE#
    ', p_theme_id => 21, p_theme_class_id => 2, p_translate_this_template=> 'N', p_template_comment=> ''); end; null; end; / prompt ...breadcrumb templates -- --application/shared_components/user_interface/templates/breadcrumb/breadcrumb_menu prompt ......template 936904805731865485 begin begin wwv_flow_api.create_menu_template ( p_id=> 936904805731865485 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=>'Breadcrumb Menu', p_before_first=>'', p_max_levels=>12, p_start_with_node=>'PARENT_TO_LEAF', p_theme_id => 21, p_theme_class_id => 1, p_translate_this_template => 'N', p_template_comments=>''); end; null; end; / --application/shared_components/user_interface/templates/popuplov prompt ...popup list of values templates -- prompt ......template 936905603379865499 begin begin wwv_flow_api.create_popup_lov_template ( p_id=> 936905603379865499 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_popup_icon=>'#IMAGE_PREFIX#themes/theme_21/images/sPopupLOVIcon.png', p_popup_icon_attr=>'alt="Popup Lov"', p_popup_icon2=>'', p_popup_icon_attr2=>'', p_page_name=>'winlov', p_page_title=>'Search Dialog', p_page_html_head=>' ', p_page_body_attr=>'onload="first_field()" class="pop-up-lov"', 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=>'450', p_result_row_x_of_y=>'
    Row(s) #FIRST_ROW# - #LAST_ROW#
    ', p_result_rows_per_pg=>500, p_before_result_set=>'
    ', p_theme_id => 21, p_theme_class_id => 1, p_translate_this_template => 'N', p_after_result_set =>'
    '); end; null; end; / prompt ...calendar templates -- prompt ...application themes -- --application/shared_components/user_interface/themes/scarlet prompt ......theme 936905710643865499 begin wwv_flow_api.create_theme ( p_id =>936905710643865499 + wwv_flow_api.g_id_offset, p_flow_id =>wwv_flow.g_flow_id, p_theme_id => 21, p_theme_name=>'Scarlet', p_default_page_template=>936881728833865360 + wwv_flow_api.g_id_offset, p_error_template=>936880509857865357 + wwv_flow_api.g_id_offset, p_printer_friendly_template=>936882328801865361 + wwv_flow_api.g_id_offset, p_breadcrumb_display_point=>'REGION_POSITION_01', p_sidebar_display_point=>'REGION_POSITION_02', p_login_template=>936879405068865354 + wwv_flow_api.g_id_offset, p_default_button_template=>936883817777865362 + wwv_flow_api.g_id_offset, p_default_region_template=>936890925366865374 + wwv_flow_api.g_id_offset, p_default_chart_template =>936887900653865370 + wwv_flow_api.g_id_offset, p_default_form_template =>936888203598865371 + wwv_flow_api.g_id_offset, p_default_reportr_template =>936890925366865374 + wwv_flow_api.g_id_offset, p_default_tabform_template=>936890925366865374 + wwv_flow_api.g_id_offset, p_default_wizard_template=>936893605622865377 + wwv_flow_api.g_id_offset, p_default_menur_template=>936886425092865365 + wwv_flow_api.g_id_offset, p_default_listr_template=>936887629418865370 + wwv_flow_api.g_id_offset, p_default_irr_template=>936889721148865373 + wwv_flow_api.g_id_offset, p_default_report_template =>936902514655865394 + wwv_flow_api.g_id_offset, p_default_label_template=>936904524832865485 + wwv_flow_api.g_id_offset, p_default_menu_template=>936904805731865485 + wwv_flow_api.g_id_offset, p_default_calendar_template=>null + wwv_flow_api.g_id_offset, p_default_list_template=>936898727314865389 + wwv_flow_api.g_id_offset, p_default_option_label=>936904524832865485 + wwv_flow_api.g_id_offset, p_default_required_label=>936904703644865485 + wwv_flow_api.g_id_offset); end; / prompt ...build options used by application 4950 -- begin null; end; / --application/shared_components/globalization/language prompt ...Language Maps for Application 4950 -- begin wwv_flow_api.create_language_map( p_id => 5282808480686690 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => wwv_flow.g_flow_id, p_translation_flow_id => 4951, p_translation_flow_language_cd=> 'es', p_translation_image_directory => '', p_translation_comments => ''); wwv_flow_api.create_language_map( p_id => 5282913328688011 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => wwv_flow.g_flow_id, p_translation_flow_id => 4952, p_translation_flow_language_cd=> 'fr', p_translation_image_directory => '', p_translation_comments => ''); wwv_flow_api.create_language_map( p_id => 5283018176689507 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => wwv_flow.g_flow_id, p_translation_flow_id => 4953, p_translation_flow_language_cd=> 'de', p_translation_image_directory => '', p_translation_comments => ''); wwv_flow_api.create_language_map( p_id => 5283123371690931 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => wwv_flow.g_flow_id, p_translation_flow_id => 4954, p_translation_flow_language_cd=> 'it', p_translation_image_directory => '', p_translation_comments => ''); wwv_flow_api.create_language_map( p_id => 5283231682693312 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => wwv_flow.g_flow_id, p_translation_flow_id => 4955, p_translation_flow_language_cd=> 'pt-br', p_translation_image_directory => '', p_translation_comments => ''); wwv_flow_api.create_language_map( p_id => 5283303070694528 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => wwv_flow.g_flow_id, p_translation_flow_id => 4956, p_translation_flow_language_cd=> 'zh-cn', p_translation_image_directory => '', p_translation_comments => ''); wwv_flow_api.create_language_map( p_id => 5283407226695750 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => wwv_flow.g_flow_id, p_translation_flow_id => 4957, p_translation_flow_language_cd=> 'zh-tw', p_translation_image_directory => '', p_translation_comments => ''); wwv_flow_api.create_language_map( p_id => 5283509650696470 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => wwv_flow.g_flow_id, p_translation_flow_id => 4958, p_translation_flow_language_cd=> 'ko', p_translation_image_directory => '', p_translation_comments => ''); wwv_flow_api.create_language_map( p_id => 5283611728697070 + wwv_flow_api.g_id_offset, p_primary_language_flow_id => wwv_flow.g_flow_id, p_translation_flow_id => 4959, p_translation_flow_language_cd=> 'ja', p_translation_image_directory => '', p_translation_comments => ''); end; / --application/shared_components/globalization/messages prompt ...messages used by application: 4950 -- --application/shared_components/globalization/dyntranslations prompt ...dynamic translations used by application: 4950 -- prompt ...Shortcuts -- prompt ...web services (9iR2 or better) -- prompt ...shared queries -- prompt ...report layouts -- prompt ...authentication schemes -- --application/shared_components/security/authentication/database_account prompt ......authentication 936873424775859940 begin wwv_flow_api.create_authentication ( p_id => 936873424775859940 + wwv_flow_api.g_id_offset ,p_flow_id => wwv_flow.g_flow_id ,p_name => 'DATABASE ACCOUNT' ,p_scheme_type => 'NATIVE_DB_ACCOUNTS' ,p_attribute_15 => '936873424775859940' ,p_invalid_session_type => 'LOGIN' ,p_logout_url => 'f?p=&APP_ID.:1' ,p_use_secure_cookie_yn => 'N' ,p_comments => 'Use database account credentials.' ); null; end; / prompt ...plugins -- prompt ...load tables -- --application/end_environment commit; commit; begin execute immediate 'begin dbms_session.set_nls( param => ''NLS_NUMERIC_CHARACTERS'', value => '''''''' || replace(wwv_flow_api.g_nls_numeric_chars,'''''''','''''''''''') || ''''''''); end;'; end; / set verify on set feedback on prompt ...done