set define off set verify off set serveroutput on size 1000000 set feedback off WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK begin wwv_flow.g_import_in_progress := true; end; / --application/set_environment prompt APPLICATION 103 - Advanced Topics -- -- Application Export: -- Application: 103 -- Name: Advanced Topics -- Date and Time: 23:18 Sunday June 24, 2007 -- Exported By: BROWNB@TUSC.COM -- Flashback: 0 -- Export Type: Application Export -- Version: 3.0.0.00.20 -- Import: -- Using application builder -- or -- Using SQL*Plus as the Oracle user FLOWS_030000 or as the owner (parsing schema) of the application. -- Application Statistics: -- Pages: 16 -- Items: 37 -- Computations: 2 -- Validations: 1 -- Processes: 14 -- Regions: 25 -- Buttons: 12 -- Shared Components -- Breadcrumbs: 1 -- Entries 2 -- Items: 3 -- Computations: 0 -- Processes: 2 -- Parent Tabs: 6 -- Tab Sets: 6 -- Tabs: 9 -- NavBars: 2 -- Lists: 0 -- Shortcuts: 1 -- Themes: 3 -- Templates: -- Page: 27 -- List: 42 -- Report: 24 -- Label: 15 -- Region: 64 -- 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 FLOWS_030000 or as the owner (parsing schema) of the application. wwv_flow_api.set_security_group_id(p_security_group_id=>933109475604895); end; / begin wwv_flow.g_import_in_progress := true; end; / begin select value into wwv_flow_api.g_nls_numeric_chars from nls_session_parameters where parameter='NLS_NUMERIC_CHARACTERS'; end; / begin execute immediate 'alter session set nls_numeric_characters=''.,'''; end; / begin wwv_flow.g_browser_language := 'en-us'; end; / prompt Check Compatibility... begin -- This date identifies the minimum version required to import this file. wwv_flow_api.set_version(p_version_yyyy_mm_dd=>'2007.01.08'); end; / prompt Set Application ID... begin -- SET APPLICATION ID wwv_flow.g_flow_id := 103; wwv_flow_api.g_id_offset := 0; null; end; / --application/delete_application begin -- Remove Application wwv_flow_api.remove_flow(103); end; / begin wwv_flow_audit.remove_audit_trail(103); null; end; / --application/create_application begin wwv_flow_api.create_flow( p_id => 103, p_display_id=> 103, p_owner => 'BDB', p_name => 'Advanced Topics', p_alias => 'F130', p_page_view_logging => 'YES', p_default_page_template=> 2516937270484162 + wwv_flow_api.g_id_offset, p_printer_friendly_template=> 2518925507484176 + wwv_flow_api.g_id_offset, p_default_region_template=> 2525311669484201 + wwv_flow_api.g_id_offset, p_error_template => 2518019287484175 + wwv_flow_api.g_id_offset, p_checksum_salt_last_reset => '20070624224223', p_home_link => 'f?p=&APP_ID.:1:&SESSION.', p_box_width => '98%', p_flow_language => 'en-us', p_flow_language_derived_from=> 'FLOW_PRIMARY_LANGUAGE', p_flow_image_prefix => '/i/', p_documentation_banner=> '', p_authentication => 'CUSTOM2', 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=> 1, p_public_url_prefix => '', p_public_user => '', p_dbauth_url_prefix => '', p_proxy_server => '', p_cust_authentication_process=> '.'||to_char(2488822857426612 + wwv_flow_api.g_id_offset)||'.', p_cust_authentication_page=> '', p_custom_auth_login_url=> '', p_flow_version => 'release 1.0', p_flow_status => 'AVAILABLE_W_EDIT_LINK', p_flow_unavailable_text=> '', p_build_status => 'RUN_AND_BUILD', p_exact_substitutions_only=> 'Y', p_vpd => '', p_theme_id => 12, p_default_label_template => 2534435949484239 + wwv_flow_api.g_id_offset, p_default_report_template => 2531535300484233 + wwv_flow_api.g_id_offset, p_default_list_template => 2530112752484222 + wwv_flow_api.g_id_offset, p_default_menu_template => 2534933120484240 + wwv_flow_api.g_id_offset, p_default_button_template => 2519814899484189 + wwv_flow_api.g_id_offset, p_default_chart_template => 2524116873484197 + wwv_flow_api.g_id_offset, p_default_form_template => 2526225465484201 + wwv_flow_api.g_id_offset, p_default_wizard_template => 2524414139484197 + wwv_flow_api.g_id_offset, p_default_tabform_template => 2525311669484201 + wwv_flow_api.g_id_offset, p_default_reportr_template =>2525311669484201 + wwv_flow_api.g_id_offset, p_default_menur_template => 2520238532484189 + wwv_flow_api.g_id_offset, p_default_listr_template => 2521129526484194 + wwv_flow_api.g_id_offset, p_last_updated_by => 'BROWNB@TUSC.COM', p_last_upd_yyyymmddhh24miss=> '20070624224223', 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 => 1416620724762096 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_icon_sequence => 10, p_icon_image => '', p_icon_subtext => 'Help', p_icon_target => 'f?p=&APP_ID.:10:&SESSION.::&DEBUG.::P10_PAGE_ID:&APP_PAGE_ID.:', p_icon_image_alt => '', p_icon_height => null, p_icon_width => null, p_icon_height2 => null, p_icon_width2 => null, p_icon_bar_disp_cond => '', p_icon_bar_disp_cond_type => '', p_begins_on_new_line=> 'NO', p_cell_colspan => 1, p_onclick=> '', p_icon_bar_comment=> ''); wwv_flow_api.create_icon_bar_item( p_id => 2489115995426615 + 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_icon_bar_disp_cond => '', p_icon_bar_disp_cond_type => 'CURRENT_LOOK_IS_1', p_begins_on_new_line=> '', p_cell_colspan => 1, p_onclick=> '', p_icon_bar_comment=> ''); end; / prompt ...application processes -- --application/shared_components/logic/application_processes/getempjob begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'declare'||chr(10)|| ' v_job varchar2(10);'||chr(10)|| 'begin'||chr(10)|| ' select job'||chr(10)|| ' into v_job'||chr(10)|| ' from emp'||chr(10)|| ' where empno = :F130_EMPNO;'||chr(10)|| ' htp.prn(v_job);'||chr(10)|| 'end;'; wwv_flow_api.create_flow_process( p_id => 2637736202956959 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_process_sequence=> 1, p_process_point => 'ON_DEMAND', p_process_type=> 'PLSQL', p_process_name=> 'getEmpJob', p_process_sql_clob=> p, p_process_error_message=> 'Problem with get job', p_process_when=> '', p_process_when_type=> '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_process_comment=> ''); end; null; end; / --application/shared_components/logic/application_processes/getemplov begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'declare'||chr(10)|| ' cursor data_cur is'||chr(10)|| ' select empno, ename'||chr(10)|| ' from emp'||chr(10)|| ' where deptno = :F130_DEPTNO;'||chr(10)|| ' v_results varchar2(1000);'||chr(10)|| ' '||chr(10)|| 'begin'||chr(10)|| ' '||chr(10)|| ' owa_util.mime_header(''text/xml'', FALSE );'||chr(10)|| ' htp.p(''Cache-Control: no-cache'');'||chr(10)|| ' htp.p(''Pragma: no-cache'');'||chr(10)|| ' owa_util.http_header_close;'||chr(10)|| ' htp.prn('''');'||chr(10)|| ''||chr(10)|| ' for it in data_cur loop'||chr(10)|| ' htp.prn('''');'||chr(10)|| ' end loop;'||chr(10)|| ' htp.prn('''');'||chr(10)|| 'end;'; wwv_flow_api.create_flow_process( p_id => 2662506854121270 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_process_sequence=> 1, p_process_point => 'ON_DEMAND', p_process_type=> 'PLSQL', p_process_name=> 'getEmpLOV', p_process_sql_clob=> p, p_process_error_message=> 'Problem with getEmpLOV', p_process_when=> '', p_process_when_type=> '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_process_comment=> ''); end; null; end; / prompt ...application items -- --application/shared_components/logic/application_items/f130_deptno begin wwv_flow_api.create_flow_item( p_id=> 2668909014803145 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'F130_DEPTNO', p_data_type=> 'VARCHAR', p_is_persistent=> 'Y', p_protection_level=> 'N', p_required_patch=> null + wwv_flow_api.g_id_offset, p_item_comment=> ''); null; end; / --application/shared_components/logic/application_items/f130_empno begin wwv_flow_api.create_flow_item( p_id=> 2674729559017267 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'F130_EMPNO', p_data_type=> 'VARCHAR', p_is_persistent=> 'Y', p_protection_level=> 'N', p_required_patch=> null + wwv_flow_api.g_id_offset, p_item_comment=> ''); null; end; / --application/shared_components/logic/application_items/fsp_after_login_url begin wwv_flow_api.create_flow_item( p_id=> 2493637787456515 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_name=> 'FSP_AFTER_LOGIN_URL', p_data_type=> 'VARCHAR', p_is_persistent=> 'Y', p_protection_level=> '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_item_comment=> ''); null; end; / prompt ...application level computations -- begin null; end; / prompt ...Application Tabs -- begin --application/shared_components/navigation/tabs/standard/t_highlight_current wwv_flow_api.create_tab ( p_id=> 2490525334426686 + 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_HIGHLIGHT_CURRENT', p_tab_text => 'Highlight Current', p_tab_step => 1, p_tab_also_current_for_pages => '', p_tab_parent_tabset=>'main', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_long_page wwv_flow_api.create_tab ( p_id=> 1408824402524114 + 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_LONG PAGE', p_tab_text => 'Long Page', p_tab_step => 9, p_tab_also_current_for_pages => '', p_tab_parent_tabset=>'main', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/outlook_calendar wwv_flow_api.create_tab ( p_id=> 1431922044872006 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'TS1', p_tab_sequence=> 30, p_tab_name=> 'Outlook Calendar', p_tab_text => 'Outlook Calendar', p_tab_step => 11, p_tab_also_current_for_pages => '12', p_tab_parent_tabset=>'main', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_ajaxexample wwv_flow_api.create_tab ( p_id=> 2646836858004431 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_AJAX', p_tab_sequence=> 10, p_tab_name=> 'T_AJAXEXAMPLE', p_tab_text => 'Ajax Example', p_tab_step => 2, p_tab_also_current_for_pages => '', p_tab_parent_tabset=>'main', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_checkboxes wwv_flow_api.create_tab ( p_id=> 2810823905413950 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_CHECKBOXES', p_tab_sequence=> 10, p_tab_name=> 'T_CHECKBOXES', p_tab_text => 'Check Boxes', p_tab_step => 6, p_tab_also_current_for_pages => '', p_tab_parent_tabset=>'main', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_custompopups wwv_flow_api.create_tab ( p_id=> 2781926517828028 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_CUSTOMPOPUP', p_tab_sequence=> 10, p_tab_name=> 'T_CUSTOMPOPUPS', p_tab_text => 'Custom Popups', p_tab_step => 4, p_tab_also_current_for_pages => '', p_tab_parent_tabset=>'main', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_excelreport wwv_flow_api.create_tab ( p_id=> 2737729225584039 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_EXCELREPORT', p_tab_sequence=> 10, p_tab_name=> 'T_EXCELREPORT', p_tab_text => 'Excel Report', p_tab_step => 3, p_tab_also_current_for_pages => '4', p_tab_parent_tabset=>'main', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_manualform wwv_flow_api.create_tab ( p_id=> 2834533552763009 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_MANUALFORM', p_tab_sequence=> 10, p_tab_name=> 'T_MANUALFORM', p_tab_text => 'Manual Form', p_tab_step => 7, p_tab_also_current_for_pages => '', p_tab_parent_tabset=>'main', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment => ''); --application/shared_components/navigation/tabs/standard/t_reportform wwv_flow_api.create_tab ( p_id=> 2874227641677198 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_MANUALFORM', p_tab_sequence=> 20, p_tab_name=> 'T_REPORTFORM', p_tab_text => 'Report Form', p_tab_step => 8, p_tab_also_current_for_pages => '10', p_tab_parent_tabset=>'main', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment => ''); end; / prompt ...Application Parent Tabs -- begin --application/shared_components/navigation/tabs/parent/t_highlight_current wwv_flow_api.create_toplevel_tab ( p_id=> 2490633049426690 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'main', p_tab_sequence=> 10, p_tab_name => 'T_HIGHLIGHT CURRENT', p_tab_text => 'Highlight Current', p_tab_target=> 'f?p=&APP_ID.:1:&SESSION.', p_current_on_tabset=> 'TS1', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment=> ''); --application/shared_components/navigation/tabs/parent/t_ajax wwv_flow_api.create_toplevel_tab ( p_id=> 2644738111995337 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'main', p_tab_sequence=> 10, p_tab_name => 'T_AJAX', p_tab_text => 'AJAX', p_tab_target=> 'f?p=&APP_ID.:2:&SESSION.::&DEBUG.:::', p_current_on_tabset=> 'T_AJAX', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment=> ''); --application/shared_components/navigation/tabs/parent/t_excelreport wwv_flow_api.create_toplevel_tab ( p_id=> 2736819875581306 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'main', p_tab_sequence=> 10, p_tab_name => 'T_EXCELREPORT', p_tab_text => 'Excel Report', p_tab_target=> 'f?p=&APP_ID.:3:&SESSION.::&DEBUG.:::', p_current_on_tabset=> 'T_EXCELREPORT', p_display_condition_type=> 'NEVER', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment=> ''); --application/shared_components/navigation/tabs/parent/t_custompopup wwv_flow_api.create_toplevel_tab ( p_id=> 2779121884817214 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'main', p_tab_sequence=> 10, p_tab_name => 'T_CUSTOMPOPUP', p_tab_text => 'Custom Pop up', p_tab_target=> 'f?p=&APP_ID.:4:&SESSION.::&DEBUG.:::', p_current_on_tabset=> 'T_CUSTOMPOPUP', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment=> ''); --application/shared_components/navigation/tabs/parent/t_checkboxes wwv_flow_api.create_toplevel_tab ( p_id=> 2809915940411679 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'main', p_tab_sequence=> 10, p_tab_name => 'T_CHECKBOXES', p_tab_text => 'CheckBoxes', p_tab_target=> 'f?p=&APP_ID.:6:&SESSION.::&DEBUG.:::', p_current_on_tabset=> 'T_CHECKBOXES', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment=> ''); --application/shared_components/navigation/tabs/parent/t_manualform wwv_flow_api.create_toplevel_tab ( p_id=> 2833626279760945 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'main', p_tab_sequence=> 10, p_tab_name => 'T_MANUALFORM', p_tab_text => 'Manual Form', p_tab_target=> 'f?p=&APP_ID.:7:&SESSION.::&DEBUG.:::', p_current_on_tabset=> 'T_MANUALFORM', p_required_patch=>null + wwv_flow_api.g_id_offset, p_tab_comment=> ''); end; / prompt ...Shared Lists of values -- --application/shared_components/user_interface/lov/managers begin wwv_flow_api.create_list_of_values ( p_id => 2837231782809803 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_lov_name => 'MANAGERS', p_lov_query=> 'select ename d, empno r'||chr(10)|| 'from emp'||chr(10)|| 'order by 1'); null; end; / prompt ...Application Trees -- --application/pages/page_groups prompt ...page groups -- begin null; end; / --application/comments prompt ...comments: requires application express 2.2 or higher -- --application/pages/page_00000 prompt ...PAGE 0: page zero -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 0, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> '', p_name => 'page zero', p_step_title=> 'page zero', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> 'NO_FIRST_ITEM', p_help_text => '', p_html_page_header => '', p_step_template => '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'BROWNB@TUSC.COM', p_last_upd_yyyymmddhh24miss => '20070623094708', p_page_comment => ''); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'This region is from page 0'; wwv_flow_api.create_page_plug ( p_id=> 1414203493738214 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 0, p_plug_name=> 'I''m from Page 0', p_region_name=>'', p_plug_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'STATIC_TEXT', p_translate_title=> 'Y', p_plug_display_error_message=> '#SQLERRM#', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => 'NEVER', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_required_patch=> '' + wwv_flow_api.g_id_offset, 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: Highlight Current -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h:=h||'No help is available for this page.'; ph := null; wwv_flow_api.create_page( p_id => 1, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'TS1', p_name => 'Highlight Current', p_step_title=> 'Highlight Current', p_step_sub_title => 'Highlight Current', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> '', p_help_text => ' ', p_html_page_header => '', p_step_template => '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'BROWNB@TUSC.COM', p_last_upd_yyyymmddhh24miss => '20070623004613', p_page_comment => ''); wwv_flow_api.set_page_help_text(p_flow_id=>wwv_flow.g_flow_id,p_flow_step_id=>1,p_text=>h); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 2490813541426701 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_plug_name=> 'Breadcrumbs', p_region_name=>'', p_plug_template=> 2520238532484189+ 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(2490234150426662 + wwv_flow_api.g_id_offset), p_menu_template_id=> 2534933120484240+ wwv_flow_api.g_id_offset, p_plug_display_error_message=> 'Unable to show breadcrumb.', 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=> '', p_required_patch=> '' + wwv_flow_api.g_id_offset, p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select decode(customer_id, '||chr(10)|| ' :P1_CUST_ID, ''CURRENT'','||chr(10)|| ' ''Select'') sel_label,'||chr(10)|| ' customer_id, cust_last_name||'', ''||cust_first_name cust_name,'||chr(10)|| ' cust_street_address1||''
''||Cust_city||'', ''||'||chr(10)|| ' cust_state||'' ''||cust_postal_code address, comments'||chr(10)|| ' from demo_customers'; wwv_flow_api.create_report_region ( p_id=> 2693306042028533 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_name=> 'Customers', p_region_name=>'', p_template=> 2525311669484201+ 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_display_error_message=> '#SQLERRM#', p_customized=> '0', p_translate_title=> 'Y', p_query_row_template=> 2696927294068054+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_num_rows=> '15', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_show_nulls_as=> ' - ', p_query_break_cols=> '0', p_query_no_data_found=> 'no data found', p_query_num_rows_type=> 'NEXT_PREVIOUS_LINKS', p_query_row_count_max=> '500', p_pagination_display_position=> 'BOTTOM_RIGHT', p_csv_output=> 'N', p_sort_null=> 'F', p_query_asc_image=> 'arrow_down_gray_dark.gif', p_query_asc_image_attr=> 'width="13" height="12" alt=""', p_query_desc_image=> 'arrow_up_gray_dark.gif', p_query_desc_image_attr=> 'width="13" height="12" 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=> 2694920371042097 + wwv_flow_api.g_id_offset, p_region_id=> 2693306042028533 + 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=> 'SEL_LABEL', p_column_display_sequence=> 1, p_column_heading=> ' ', p_column_link=>'f?p=&APP_ID.:1:&SESSION.::&DEBUG.::P1_CUST_ID,P1_CUST_NAME,P1_ORDER_ID:#CUSTOMER_ID#,\#CUST_NAME#\,', p_column_linktext=>'#SEL_LABEL#', 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=>'WITHOUT_MODIFICATION', p_lov_show_nulls=> 'NO', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2693614176028750 + wwv_flow_api.g_id_offset, p_region_id=> 2693306042028533 + 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=> 'CUSTOMER_ID', p_column_display_sequence=> 2, p_column_heading=> 'Customer Id', 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=> 'Y', p_display_as=>'WITHOUT_MODIFICATION', 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=> 2693706646028756 + wwv_flow_api.g_id_offset, p_region_id=> 2693306042028533 + 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=> 'CUST_NAME', p_column_display_sequence=> 3, p_column_heading=> 'Name', 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=>'WITHOUT_MODIFICATION', 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=> 2693806370028756 + wwv_flow_api.g_id_offset, p_region_id=> 2693306042028533 + 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=> 'ADDRESS', p_column_display_sequence=> 4, p_column_heading=> 'Address', p_column_link=>'#', p_column_linktext=>'#ADDRESS#', p_column_link_attr=>'TITLE="#COMMENTS#"', 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=>'WITHOUT_MODIFICATION', p_lov_show_nulls=> 'NO', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 1405200455491654 + wwv_flow_api.g_id_offset, p_region_id=> 2693306042028533 + 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=> 'COMMENTS', p_column_display_sequence=> 5, p_column_heading=> 'Comments', 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=> 'Y', p_display_as=>'WITHOUT_MODIFICATION', p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select decode(order_id, '||chr(10)|| ' :P1_ORDER_ID, ''CURRENT'','||chr(10)|| ' ''Select'') sel_label,'||chr(10)|| ' order_timestamp, order_total, order_id'||chr(10)|| ' from demo_orders'||chr(10)|| ' where customer_id = :P1_CUST_ID'; wwv_flow_api.create_report_region ( p_id=> 2702524536119020 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_name=> 'Orders for &P1_CUST_NAME.', p_region_name=>'', p_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_display_sequence=> 31, p_display_column=> 2, p_display_point=> 'AFTER_SHOW_ITEMS', p_source=> s, p_source_type=> 'SQL_QUERY', p_display_error_message=> '#SQLERRM#', p_display_when_condition=> 'P1_CUST_ID', p_display_condition_type=> 'ITEM_IS_NOT_NULL', p_customized=> '0', p_translate_title=> 'Y', p_query_row_template=> 2706811735175679+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_num_rows=> '15', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_show_nulls_as=> ' - ', p_query_break_cols=> '0', p_query_no_data_found=> 'no data found', p_query_num_rows_type=> 'NEXT_PREVIOUS_LINKS', p_query_row_count_max=> '500', p_pagination_display_position=> 'BOTTOM_RIGHT', p_csv_output=> 'N', p_query_asc_image=> 'arrow_down_gray_dark.gif', p_query_asc_image_attr=> 'width="13" height="12" alt=""', p_query_desc_image=> 'arrow_up_gray_dark.gif', p_query_desc_image_attr=> 'width="13" height="12" 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=> 2704319735146048 + wwv_flow_api.g_id_offset, p_region_id=> 2702524536119020 + 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=> 'SEL_LABEL', p_column_display_sequence=> 1, p_column_heading=> ' ', p_column_link=>'f?p=&APP_ID.:1:&SESSION.::&DEBUG.::P1_ORDER_ID,P1_ORDER_DATE:#ORDER_ID#,#ORDER_TIMESTAMP#', p_column_linktext=>'#SEL_LABEL#', 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=>'WITHOUT_MODIFICATION', p_lov_show_nulls=> 'NO', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2702815611119031 + wwv_flow_api.g_id_offset, p_region_id=> 2702524536119020 + 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=> 'ORDER_TIMESTAMP', p_column_display_sequence=> 2, p_column_heading=> 'Order Date', 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=>'WITHOUT_MODIFICATION', 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=> 2702929959119031 + wwv_flow_api.g_id_offset, p_region_id=> 2702524536119020 + 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=> 'ORDER_TOTAL', p_column_display_sequence=> 3, p_column_heading=> 'Order Total', p_column_format=> 'FML999G999G999G999G990D00', p_column_alignment=>'RIGHT', p_heading_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'Y', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_lov_show_nulls=> 'NO', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2709334804188184 + wwv_flow_api.g_id_offset, p_region_id=> 2702524536119020 + 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=> 'ORDER_ID', p_column_display_sequence=> 4, p_column_heading=> 'Order Id', 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=> 'Y', p_display_as=>'WITHOUT_MODIFICATION', p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select product_name, unit_price, quantity, '||chr(10)|| ' unit_price*quantity line_total'||chr(10)|| ' from demo_order_items doi, demo_product_info dpi'||chr(10)|| ' where doi.product_id = dpi.product_id'||chr(10)|| ' and order_id = :P1_ORDER_ID'; wwv_flow_api.create_report_region ( p_id=> 2712629703243573 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 1, p_name=> '&P1_ORDER_DATE. Order Detail', p_region_name=>'', p_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_display_sequence=> 31, p_display_column=> 2, p_display_point=> 'AFTER_SHOW_ITEMS', p_source=> s, p_source_type=> 'SQL_QUERY', p_display_error_message=> '#SQLERRM#', p_display_when_condition=> 'P1_ORDER_ID', p_display_condition_type=> 'ITEM_IS_NOT_NULL', p_customized=> '0', p_translate_title=> 'Y', p_query_row_template=> 2532512675484234+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_num_rows=> '15', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_show_nulls_as=> ' - ', p_query_break_cols=> '0', p_query_no_data_found=> 'no data found', p_query_num_rows_type=> 'NEXT_PREVIOUS_LINKS', p_query_row_count_max=> '500', p_pagination_display_position=> 'BOTTOM_RIGHT', p_csv_output=> 'N', p_query_asc_image=> 'arrow_down_gray_dark.gif', p_query_asc_image_attr=> 'width="13" height="12" alt=""', p_query_desc_image=> 'arrow_up_gray_dark.gif', p_query_desc_image_attr=> 'width="13" height="12" 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=> 2712909258243578 + wwv_flow_api.g_id_offset, p_region_id=> 2712629703243573 + 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=> 'PRODUCT_NAME', p_column_display_sequence=> 1, p_column_heading=> 'Product Name', 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=>'WITHOUT_MODIFICATION', 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=> 2713007357243578 + wwv_flow_api.g_id_offset, p_region_id=> 2712629703243573 + 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=> 'UNIT_PRICE', p_column_display_sequence=> 2, p_column_heading=> 'Unit Price', p_column_format=> 'FML999G999G999G999G990D00', p_column_alignment=>'RIGHT', p_heading_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_lov_show_nulls=> 'NO', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2713138292243578 + wwv_flow_api.g_id_offset, p_region_id=> 2712629703243573 + 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=> 'QUANTITY', p_column_display_sequence=> 3, p_column_heading=> 'Quantity', p_column_alignment=>'RIGHT', p_heading_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_lov_show_nulls=> 'NO', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2713225113243578 + wwv_flow_api.g_id_offset, p_region_id=> 2712629703243573 + 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=> 'LINE_TOTAL', p_column_display_sequence=> 4, p_column_heading=> 'Line Total', p_column_format=> 'FML999G999G999G999G990D00', p_column_alignment=>'RIGHT', p_heading_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'Y', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_lov_show_nulls=> 'NO', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_column_comment=>''); end; / begin null; end; / begin wwv_flow_api.create_page_branch( p_id=>2538018710563962 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 1, p_branch_action=> 'f?p=&APP_ID.:1:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_sequence=> 99, p_branch_comment=> 'Created 05-FEB-2007 22:19 by LARRY'); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2695520502051672 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 1, p_name=>'P1_CUST_ID', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 40, p_item_plug_id => 2693306042028533+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> null, p_cMaxlength=> 2000, 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_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2700319641089209 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 1, p_name=>'P1_CUST_NAME', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 50, p_item_plug_id => 2693306042028533+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> null, p_cMaxlength=> 2000, 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_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2704915017154172 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 1, p_name=>'P1_ORDER_ID', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 60, p_item_plug_id => 2693306042028533+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> null, p_cMaxlength=> 2000, 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_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2717036806283398 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 1, p_name=>'P1_ORDER_DATE', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 70, p_item_plug_id => 2693306042028533+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> null, p_cMaxlength=> 2000, 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_item_comment => ''); end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'declare'||chr(10)|| ' cursor data_cur is '||chr(10)|| ' select order_id, order_timestamp'||chr(10)|| ' from demo_orders'||chr(10)|| ' where customer_id = :P1_CUST_ID;'||chr(10)|| 'begin'||chr(10)|| ' open data_cur;'||chr(10)|| ' fetch data_cur'||chr(10)|| ' into :P1_ORDER_ID, :P1_ORDER_DATE;'||chr(10)|| ' close data_cur;'||chr(10)|| 'end;'; wwv_flow_api.create_page_process( p_id => 2753923445375801 + 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 First Defaults', p_process_sql_clob => p, p_process_error_message=> '', p_process_when=>':P1_CUST_ID is not null and'||chr(10)|| ':P1_ORDER_ID is null', p_process_when_type=>'PLSQL_EXPRESSION', p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_required_patch=>null + wwv_flow_api.g_id_offset, 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: AJAX Example -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph:=ph||''; wwv_flow_api.create_page( p_id => 2, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_AJAX', p_name => 'AJAX Example', p_step_title=> 'AJAX Example', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> 'NO_FIRST_ITEM', p_help_text => '', p_html_page_header => ' ', p_step_template => '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'LARRY', p_last_upd_yyyymmddhh24miss => '20070312191700', p_page_is_public_y_n=> 'N', p_page_comment => ''); wwv_flow_api.set_html_page_header(p_flow_id=>wwv_flow.g_flow_id,p_flow_step_id=>2,p_text=>ph); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 2639619709969322 + 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_plug_template=> 2520238532484189+ 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(2490234150426662 + wwv_flow_api.g_id_offset), p_menu_template_id=> 2534933120484240+ wwv_flow_api.g_id_offset, p_translate_title=> 'Y', p_plug_display_error_message=> '#SQLERRM#', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'COLON_DELMITED_LIST', p_plug_query_row_count_max => 500, p_plug_display_condition_type => '', p_plug_customized=>'0', p_plug_caching=> '', p_required_patch=> '' + wwv_flow_api.g_id_offset, 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=> 2649509416015478 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_plug_name=> 'AJAX Query Process Example', p_region_name=>'', p_plug_template=> 2525311669484201+ 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=> 'STATIC_TEXT', p_translate_title=> 'Y', p_plug_display_error_message=> '#SQLERRM#', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_customized=>'0', p_plug_caching=> '', p_required_patch=> '' + wwv_flow_api.g_id_offset, 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=> 2727723750412129 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 2, p_plug_name=> 'AJAX XML Process Example', p_region_name=>'', p_plug_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 21, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'STATIC_TEXT', p_plug_display_error_message=> '#SQLERRM#', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_caching=> '', p_required_patch=> '' + wwv_flow_api.g_id_offset, p_plug_comment=> ''); end; / begin null; end; / begin null; end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2650220844018751 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 2, p_name=>'P2_EMPNO', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 2649509416015478+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=> 'COMBOBOX', p_lov => 'select ename, empno from emp order by 1', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> 1, p_cAttributes=> 'nowrap="nowrap"', p_tag_attributes => 'onChange="javascript:getJob(this,''P2_JOB'',''OBJ'')";', p_begin_on_new_line => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'LEFT', p_field_alignment => 'LEFT', p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2653234874060679 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 2, p_name=>'P2_JOB', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 2649509416015478+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Job', p_source_type=> 'STATIC', p_display_as=> 'TEXT', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> null, p_cAttributes=> 'nowrap="nowrap"', p_begin_on_new_line => 'YES', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2665032097175794 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 2, p_name=>'P2_DEPTNO', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 30, p_item_plug_id => 2727723750412129+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Department', p_source_type=> 'STATIC', p_display_as=> 'COMBOBOX', p_lov => 'select dname d, deptno r'||chr(10)|| ' from dept'||chr(10)|| ' order by 1', p_lov_columns=> 1, p_lov_display_null=> 'YES', p_lov_translated=> 'N', p_lov_null_text=>'-- Select a Dept --', p_lov_null_value=> '', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> 1, p_cAttributes=> 'nowrap="nowrap"', p_tag_attributes => 'onChange="javascript:getEmpLov(this,''P2_EMPLOYEE'');"', 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 => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2665827380183979 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 2, p_name=>'P2_EMPLOYEE', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 40, p_item_plug_id => 2727723750412129+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Employee', p_source_type=> 'STATIC', p_display_as=> 'COMBOBOX', p_lov => 'select ename d, empno r'||chr(10)|| ' from emp'||chr(10)|| ' where 1 = 2', p_lov_columns=> 1, p_lov_display_null=> 'YES', p_lov_translated=> 'N', p_lov_null_text=>'-Select Employee-', p_lov_null_value=> '', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> 1, p_cAttributes=> 'nowrap="nowrap"', p_tag_attributes => 'onChange="javascript:getJob(this,''theJob'',''DIV'')";', 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 => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2679433949160465 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 2, p_name=>'P2_DIV', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 50, p_item_plug_id => 2727723750412129+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source=>'
 
', p_source_type=> 'STATIC', p_display_as=> 'DISPLAY_ONLY_HTML', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> 1, p_cAttributes=> 'nowrap="nowrap"', p_begin_on_new_line => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 2534731025484239+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / begin --------------------------------------- -- ...updatable report columns for page 2 -- begin null; end; null; end; / --application/pages/page_00003 prompt ...PAGE 3: Excel Report -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 3, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_EXCELREPORT', p_name => 'Excel Report', p_step_title=> 'Excel Report', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> 'NO_FIRST_ITEM', p_help_text => '', p_html_page_header => '', p_step_template => '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'LARRY', p_last_upd_yyyymmddhh24miss => '20070214232659', p_page_is_public_y_n=> 'N', p_page_comment => ''); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select dc.cust_last_name, do.order_timestamp, '||chr(10)|| ' do.order_total, dpi.product_name,'||chr(10)|| ' doi.unit_price, doi.quantity,'||chr(10)|| ' doi.unit_price*doi.quantity item_total'||chr(10)|| ' from demo_customers dc, demo_orders do,'||chr(10)|| ' demo_order_items doi, demo_product_info dpi'||chr(10)|| ' where do.customer_id = dc.customer_id'||chr(10)|| ' and doi.order_id = do.order_id'||chr(10)|| ' and doi.product_id = dpi.product_id'||chr(10)|| ' order by 1,2'; wwv_flow_api.create_report_region ( p_id=> 2742727727725481 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 3, p_name=> 'Excel Report', p_region_name=>'', p_template=> 2525311669484201+ 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_display_error_message=> '#SQLERRM#', p_customized=> '0', p_translate_title=> 'Y', p_query_row_template=> 2531535300484233+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_num_rows=> '50', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_show_nulls_as=> ' - ', p_query_break_cols=> '1:2', 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_break_column_text_format=> '#SUM_COLUMN_HEADER#', p_break_type_flag=> 'DEFAULT_BREAK_FORMATTING', p_csv_output=> 'Y', p_csv_output_link_text=> 'Export to CSV', p_query_asc_image=> 'arrow_down_gray_dark.gif', p_query_asc_image_attr=> 'width="13" height="12" alt=""', p_query_desc_image=> 'arrow_up_gray_dark.gif', p_query_desc_image_attr=> 'width="13" height="12" alt=""', p_plug_query_exp_filename=> 'Orders.csv', p_plug_query_exp_separator=> ',', p_plug_query_exp_enclosed_by=> '"', 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=> 2743018352725564 + wwv_flow_api.g_id_offset, p_region_id=> 2742727727725481 + 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=> 'CUST_LAST_NAME', p_column_display_sequence=> 1, p_column_heading=> 'Cust Last Name', 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=>'WITHOUT_MODIFICATION', 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=> 2743115658725573 + wwv_flow_api.g_id_offset, p_region_id=> 2742727727725481 + 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=> 'ORDER_TIMESTAMP', p_column_display_sequence=> 2, p_column_heading=> 'Order Timestamp', 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=>'WITHOUT_MODIFICATION', 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=> 2743237463725573 + wwv_flow_api.g_id_offset, p_region_id=> 2742727727725481 + 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=> 'ORDER_TOTAL', p_column_display_sequence=> 3, p_column_heading=> 'Order Total', 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=>'WITHOUT_MODIFICATION', 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=> 2743330823725573 + wwv_flow_api.g_id_offset, p_region_id=> 2742727727725481 + 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=> 'PRODUCT_NAME', p_column_display_sequence=> 4, p_column_heading=> 'Product Name', 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=>'WITHOUT_MODIFICATION', 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=> 2743428451725575 + wwv_flow_api.g_id_offset, p_region_id=> 2742727727725481 + 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=> 'UNIT_PRICE', p_column_display_sequence=> 5, p_column_heading=> 'Unit Price', 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=>'WITHOUT_MODIFICATION', 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=> 2743533700725575 + wwv_flow_api.g_id_offset, p_region_id=> 2742727727725481 + 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=> 'QUANTITY', p_column_display_sequence=> 6, p_column_heading=> 'Quantity', 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=>'WITHOUT_MODIFICATION', 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=> 2743614833725575 + wwv_flow_api.g_id_offset, p_region_id=> 2742727727725481 + 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=> 'ITEM_TOTAL', p_column_display_sequence=> 7, p_column_heading=> 'Item Total', p_column_alignment=>'left', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'Y', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_pk_col_source=> s, p_column_comment=>''); end; / begin null; end; / begin null; end; / begin --------------------------------------- -- ...updatable report columns for page 3 -- begin null; end; null; end; / --application/pages/page_00004 prompt ...PAGE 4: Custom Popup -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph:=ph||''||chr(10)|| ''; wwv_flow_api.create_page( p_id => 4, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_CUSTOMPOPUP', p_name => 'Custom Popup', p_step_title=> 'Custom Popup', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> 'NO_FIRST_ITEM', p_help_text => '', p_html_page_header => ' ', p_step_template => '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'BROWNB@TUSC.COM', p_last_upd_yyyymmddhh24miss => '20070623002622', p_page_is_public_y_n=> 'N', p_page_comment => ''); wwv_flow_api.set_html_page_header(p_flow_id=>wwv_flow.g_flow_id,p_flow_step_id=>4,p_text=>ph); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select CUSTOMER_ID,'||chr(10)|| ' CUST_FIRST_NAME || '' '' || CUST_LAST_NAME NAME,'||chr(10)|| ' CUST_STREET_ADDRESS1 || '' '' || CUST_STREET_ADDRESS2 || '||chr(10)|| ' '','' || CUST_CITY || '','' || CUST_STATE || '','' || '||chr(10)|| ' CUST_POSTAL_CODE FULL_ADDRESS,'||chr(10)|| ' CUST_FIRST_NAME,'||chr(10)|| ' CUST_LAST_NAME,'||chr(10)|| ' CUST_STREET_ADDRESS1 || '' '' || CUST_STREET_ADDRESS2 address,'||chr(10)|| ' CUST_CITY,'||chr(10)|| ' CUST_STATE,'||chr(10)|| ' "DEMO_CUS'; s:=s||'TOMERS"."PHONE_NUMBER1" as "PHONE_NUMBER1",'||chr(10)|| ' "DEMO_CUSTOMERS"."PHONE_NUMBER2" as "PHONE_NUMBER2",'||chr(10)|| ' "DEMO_CUSTOMERS"."CREDIT_LIMIT" as "CREDIT_LIMIT",'||chr(10)|| ' "DEMO_CUSTOMERS"."CUST_EMAIL" as "CUST_EMAIL" '||chr(10)|| ' from "DEMO_CUSTOMERS" "DEMO_CUSTOMERS"'; wwv_flow_api.create_report_region ( p_id=> 1393628905781344 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_name=> 'Pop-up Reference Window', p_region_name=>'', p_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_display_sequence=> 20, p_display_column=> 1, p_display_point=> 'AFTER_SHOW_ITEMS', p_source=> s, p_source_type=> 'SQL_QUERY', p_display_error_message=> '#SQLERRM#', p_customized=> '0', p_translate_title=> 'Y', p_query_row_template=> 2531535300484233+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_num_rows=> '15', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_show_nulls_as=> ' - ', p_query_break_cols=> '0', p_query_no_data_found=> 'no data found', p_query_num_rows_type=> 'NEXT_PREVIOUS_LINKS', p_pagination_display_position=> 'BOTTOM_RIGHT', p_csv_output=> 'N', p_sort_null=> 'F', p_query_asc_image=> 'arrow_down_gray_dark.gif', p_query_asc_image_attr=> 'width="13" height="12" alt=""', p_query_desc_image=> 'arrow_up_gray_dark.gif', p_query_desc_image_attr=> 'width="13" height="12" 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=> 1393926826781511 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'CUSTOMER_ID', p_column_display_sequence=> 1, p_column_heading=> 'Customer Id', p_column_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'N', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 1394021334781517 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'NAME', p_column_display_sequence=> 2, p_column_heading=> 'Name', p_column_link=>'http://www.peoplefinders.com/summary.asp?fn=#CUST_FIRST_NAME#&mn=&ln=#CUST_LAST_NAME#&city=#CUST_CITY#&state=#CUST_STATE#&age=&dobmm=&dobdd=&doby=&vw=&Search=&Input=&x=3&y=14', p_column_linktext=>'#NAME#', p_column_link_attr=>'target="_blank"', p_column_alignment=>'LEFT', p_heading_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'N', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_lov_show_nulls=> 'NO', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 1397415543335182 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'FULL_ADDRESS', p_column_display_sequence=> 3, p_column_heading=> 'Full Address', p_column_link=>'http://maps.google.com/maps?f=q&hl=en&q=#FULL_ADDRESS#&sll=&sspn=&ie=UTF8&ll=&spn=0.007753,0.021093&z=16&iwloc=addr&om=1', p_column_linktext=>'#FULL_ADDRESS#', p_column_link_attr=>'target="_blank"', p_column_alignment=>'LEFT', p_heading_alignment=>'CENTER', p_default_sort_column_sequence=>0, p_disable_sort_column=>'N', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_lov_show_nulls=> 'NO', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 1397532336335193 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'CUST_FIRST_NAME', p_column_display_sequence=> 9, p_column_heading=> 'Cust First Name', 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=> 'Y', p_display_as=>'WITHOUT_MODIFICATION', 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=> 1397627130335193 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'CUST_LAST_NAME', p_column_display_sequence=> 10, p_column_heading=> 'Cust Last Name', 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=> 'Y', p_display_as=>'WITHOUT_MODIFICATION', 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=> 1394100068781517 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'ADDRESS', p_column_display_sequence=> 4, p_column_heading=> 'Address', p_column_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'Y', p_display_as=>'WITHOUT_MODIFICATION', 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=> 1397726087335193 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'CUST_CITY', p_column_display_sequence=> 11, p_column_heading=> 'Cust City', 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=> 'Y', p_display_as=>'WITHOUT_MODIFICATION', 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=> 1397820549335193 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'CUST_STATE', p_column_display_sequence=> 12, p_column_heading=> 'Cust State', 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=> 'Y', p_display_as=>'WITHOUT_MODIFICATION', 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=> 1394230328781519 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'PHONE_NUMBER1', p_column_display_sequence=> 5, p_column_heading=> 'Phone Number1', p_column_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'N', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 1394315097781519 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'PHONE_NUMBER2', p_column_display_sequence=> 6, p_column_heading=> 'Phone Number2', p_column_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'N', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 1394401019781524 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + 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=> 'CREDIT_LIMIT', p_column_display_sequence=> 7, p_column_heading=> 'Credit Limit', p_column_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'N', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 1394531030781524 + wwv_flow_api.g_id_offset, p_region_id=> 1393628905781344 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_query_column_id=> 12, p_form_element_id=> null, p_column_alias=> 'CUST_EMAIL', p_column_display_sequence=> 8, p_column_heading=> 'Cust Email', p_column_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'N', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_pk_col_source=> s, p_column_comment=>''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 2785937514850097 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_plug_name=> 'Custom Popup', p_region_name=>'', p_plug_template=> 2525311669484201+ 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_plug_display_error_message=> '#SQLERRM#', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_caching=> '', p_required_patch=> '' + wwv_flow_api.g_id_offset, p_plug_comment=> ''); end; / begin null; end; / begin null; end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2786921500864478 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_EMPNO', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 30, p_item_plug_id => 2785937514850097+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Empno', p_source_type=> 'STATIC', p_display_as=> 'TEXT', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 4, 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 => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2787128152864512 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_ENAME', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 2785937514850097+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Employee', p_post_element_text=>'popup list of values', p_source_type=> 'STATIC', p_display_as=> 'TEXT', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 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 => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2787337227864514 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_SAL', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 40, p_item_plug_id => 2785937514850097+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Salary', p_source_type=> 'STATIC', p_display_as=> 'TEXT', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 8, 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 => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2787511115864514 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_COMM', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 50, p_item_plug_id => 2785937514850097+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Commission', p_source_type=> 'STATIC', p_display_as=> 'TEXT', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 8, 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 => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2787724834864515 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_DEPT_NO', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 2785937514850097+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Department', p_source_type=> 'STATIC', p_display_as=> 'COMBOBOX', p_lov => 'select dname d, deptno r'||chr(10)|| ' from dept'||chr(10)|| 'order by 1', p_lov_columns=> 1, 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 => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / begin --------------------------------------- -- ...updatable report columns for page 4 -- begin null; end; null; end; / --application/pages/page_00005 prompt ...PAGE 5: Find Employee -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph:=ph||''; wwv_flow_api.create_page( p_id => 5, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> '', p_name => 'Find Employee', p_step_title=> 'Find Employee', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> 'NO_FIRST_ITEM', p_help_text => '', p_html_page_header => ' ', p_step_template => 2517418615484173+ wwv_flow_api.g_id_offset, p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'LARRY', p_last_upd_yyyymmddhh24miss => '20070321093005', p_page_is_public_y_n=> 'N', p_page_comment => ''); wwv_flow_api.set_html_page_header(p_flow_id=>wwv_flow.g_flow_id,p_flow_step_id=>5,p_text=>ph); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'declare'||chr(10)|| ' cursor emp_cur is'||chr(10)|| ' select empno, ename, sal, comm'||chr(10)|| ' from emp'||chr(10)|| ' where deptno = :P5_DEPT_NO;'||chr(10)|| 'begin'||chr(10)|| ' for it in emp_cur loop'||chr(10)|| ' htp.p(''''||'||chr(10)|| ' it.ename|| ''    Salary - ''||'||chr(10)|| ' to_char(it.sal,''999999'')||''    Commission - ''||'||chr(10)|| ' to_char(it.comm,''999999'')||''
'');'||chr(10)|| ''||chr(10)|| ' end loop;'||chr(10)|| 'end;'; wwv_flow_api.create_page_plug ( p_id=> 2793724121054473 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 5, p_plug_name=> 'Find Employee for &P5_DNAME.', p_region_name=>'', p_plug_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'PLSQL_PROCEDURE', p_translate_title=> 'Y', p_plug_display_error_message=> '#SQLERRM#', p_plug_query_row_template=> 1, p_plug_query_headings_type=> '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=> '', p_required_patch=> '' + wwv_flow_api.g_id_offset, p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select empno, ename, sal, comm'||chr(10)|| ' from emp'||chr(10)|| ' where deptno = :P5_DEPT_NO'; wwv_flow_api.create_report_region ( p_id=> 2797931010103773 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 5, p_name=> 'Find Emp for &P5_DNAME. by Normal SQL Report', p_region_name=>'', p_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_display_sequence=> 20, p_display_column=> 1, p_display_point=> 'AFTER_SHOW_ITEMS', p_source=> s, p_source_type=> 'SQL_QUERY', p_display_error_message=> '#SQLERRM#', p_customized=> '0', p_translate_title=> 'Y', p_query_row_template=> 2531535300484233+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_num_rows=> '15', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_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=> 'arrow_down_gray_dark.gif', p_query_asc_image_attr=> 'width="13" height="12" alt=""', p_query_desc_image=> 'arrow_up_gray_dark.gif', p_query_desc_image_attr=> 'width="13" height="12" 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=> 2798236366103864 + wwv_flow_api.g_id_offset, p_region_id=> 2797931010103773 + 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=> 'EMPNO', p_column_display_sequence=> 1, p_column_heading=> 'Select', p_column_link=>'javascript:passBackValues(''&P5_PASSBACK.'',''&P5_PASSBACK.'',''#EMPNO#'',''&P5_PB2.'',''#ENAME#'',''&P5_PB3.'',''#SAL#'',''&P5_PB4.'',''#COMM#'')', p_column_linktext=>'Select', p_column_alignment=>'LEFT', p_heading_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'WITHOUT_MODIFICATION', p_lov_show_nulls=> 'NO', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2798320737103872 + wwv_flow_api.g_id_offset, p_region_id=> 2797931010103773 + 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=> 'ENAME', p_column_display_sequence=> 2, p_column_heading=> 'Employee', 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=>'WITHOUT_MODIFICATION', 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=> 2798431405103872 + wwv_flow_api.g_id_offset, p_region_id=> 2797931010103773 + 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=> 'SAL', p_column_display_sequence=> 3, p_column_heading=> 'Salary', 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=>'WITHOUT_MODIFICATION', 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=> 2798511911103872 + wwv_flow_api.g_id_offset, p_region_id=> 2797931010103773 + 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=> 'COMM', p_column_display_sequence=> 4, p_column_heading=> 'Commission', 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=>'WITHOUT_MODIFICATION', p_pk_col_source=> s, p_column_comment=>''); end; / begin null; end; / begin null; end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2794417672062011 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 5, p_name=>'P5_PASSBACK', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 2793724121054473+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_prompt=>'Passback', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, p_cHeight=> 1, p_cAttributes=> 'nowrap', p_begin_on_new_line => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2794627993062020 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 5, p_name=>'P5_PB2', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 2793724121054473+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_prompt=>'Pb2', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, p_cHeight=> 1, p_cAttributes=> 'nowrap', p_begin_on_new_line => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2794817490062020 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 5, p_name=>'P5_PB3', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 30, p_item_plug_id => 2793724121054473+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_prompt=>'Pb3', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, p_cHeight=> 1, p_cAttributes=> 'nowrap', p_begin_on_new_line => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2795027500062020 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 5, p_name=>'P5_PB4', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 40, p_item_plug_id => 2793724121054473+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_prompt=>'Pb4', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, p_cHeight=> 1, p_cAttributes=> 'nowrap', p_begin_on_new_line => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2795229650062020 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 5, p_name=>'P5_DEPT_NO', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 50, p_item_plug_id => 2793724121054473+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_prompt=>'Dept No', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 4000, p_cHeight=> 1, p_cAttributes=> 'nowrap', p_begin_on_new_line => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2861516308680484 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 5, p_name=>'P5_DNAME', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 60, p_item_plug_id => 2793724121054473+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> 1, p_cAttributes=> 'nowrap="nowrap"', p_begin_on_new_line => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'LEFT', p_field_alignment => 'LEFT', p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / begin wwv_flow_api.create_page_computation( p_id=> 2868136674206698 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 5, p_computation_sequence => 10, p_computation_item=> 'P5_DNAME', p_computation_point=> 'AFTER_HEADER', p_computation_type=> 'QUERY', p_computation_processed=> 'REPLACE_EXISTING', p_computation=> 'select dname'||chr(10)|| ' from dept'||chr(10)|| ' where deptno = :P5_DEPT_NO', p_required_patch=> null + wwv_flow_api.g_id_offset, p_compute_when => '', p_compute_when_type=>'%null%'); null; end; / begin --------------------------------------- -- ...updatable report columns for page 5 -- begin null; end; null; end; / --application/pages/page_00006 prompt ...PAGE 6: CheckBoxes -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 6, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_CHECKBOXES', p_name => 'CheckBoxes', p_step_title=> 'CheckBoxes', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> 'NO_FIRST_ITEM', p_help_text => '', p_html_page_header => '', p_step_template => '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'LARRY', p_last_upd_yyyymmddhh24miss => '20070320221557', p_page_is_public_y_n=> 'N', p_page_comment => ''); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 2813708715437945 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 6, p_plug_name=> 'Direct Reports for &P6_EMP_NAME.', p_region_name=>'', p_plug_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'STATIC_TEXT', p_translate_title=> 'Y', p_plug_display_error_message=> '#SQLERRM#', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_customized=>'0', p_plug_caching=> '', p_required_patch=> '' + wwv_flow_api.g_id_offset, p_plug_comment=> ''); end; / begin wwv_flow_api.create_page_button( p_id => 2823232235567747 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 6, p_button_sequence=> 10, p_button_plug_id => 2813708715437945+wwv_flow_api.g_id_offset, p_button_name => 'SUBMIT', p_button_image => 'template:'||to_char(2519814899484189+wwv_flow_api.g_id_offset), p_button_image_alt=> 'Submit', p_button_position=> 'BOTTOM', p_button_alignment=> 'RIGHT', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>2823518743567809 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 6, p_branch_action=> 'f?p=&FLOW_ID.:6:&SESSION.::&DEBUG.&success_msg=#SUCCESS_MSG#', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_when_button_id=>2823232235567747+ wwv_flow_api.g_id_offset, p_branch_sequence=> 10, p_branch_comment=> ''); wwv_flow_api.create_page_branch( p_id=>2815513694448890 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 6, p_branch_action=> 'f?p=&APP_ID.:6:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_sequence=> 99, p_branch_comment=> 'Created 12-MAR-2007 23:17 by LARRY'); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2814730878444370 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 6, p_name=>'P6_EMPLOYEE', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 2813708715437945+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Employee', p_source_type=> 'STATIC', p_display_as=> 'COMBOBOX_WITH_SUBMIT', p_named_lov=> '%null%', p_lov => 'select ename, empno'||chr(10)|| ' from emp'||chr(10)|| ' order by 1', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> null, p_cAttributes=> 'nowrap="nowrap"', p_begin_on_new_line => 'YES', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2816325599461695 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 6, p_name=>'P6_REPORTS', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 2813708715437945+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'NO', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Reports', p_source=>'declare'||chr(10)|| ' results varchar2(50) := null;'||chr(10)|| ' first_loop boolean := true;'||chr(10)|| ' cursor data_cur is'||chr(10)|| ' select empno'||chr(10)|| ' from emp'||chr(10)|| ' where mgr = :P6_EMPLOYEE;'||chr(10)|| 'begin'||chr(10)|| ' for it in data_cur loop'||chr(10)|| ' if first_loop then'||chr(10)|| ' results := it.empno;'||chr(10)|| ' first_loop := false;'||chr(10)|| ' else'||chr(10)|| ' results := results||'':''||it.empno;'||chr(10)|| ' end if;'||chr(10)|| ' end loop;'||chr(10)|| ' return results;'||chr(10)|| 'end;', p_source_type=> 'FUNCTION_BODY', p_display_as=> 'CHECKBOX', p_lov => 'select ename, empno'||chr(10)|| ' from emp'||chr(10)|| ' where deptno <= (select deptno '||chr(10)|| ' from emp'||chr(10)|| ' where empno = :P6_EMPLOYEE)'||chr(10)|| ' and empno != :P6_EMPLOYEE'||chr(10)|| ' order by 1', p_lov_columns=> 3, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> 1, p_cAttributes=> 'nowrap="nowrap"', p_begin_on_new_line => 'YES', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2938221789108536 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 6, p_name=>'P6_EMP_NAME', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 30, p_item_plug_id => 2813708715437945+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_source_type=> 'STATIC', p_display_as=> 'HIDDEN', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> 1, p_cAttributes=> 'nowrap="nowrap"', p_begin_on_new_line => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'LEFT', p_field_alignment => 'LEFT', p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / begin wwv_flow_api.create_page_computation( p_id=> 2940713393125036 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 6, p_computation_sequence => 10, p_computation_item=> 'P6_EMP_NAME', p_computation_point=> 'BEFORE_BOX_BODY', p_computation_type=> 'QUERY', p_computation_processed=> 'REPLACE_EXISTING', p_computation=> 'select ename'||chr(10)|| ' from emp'||chr(10)|| ' where empno = :P6_EMPLOYEE;', p_required_patch=> null + wwv_flow_api.g_id_offset, p_compute_when => '', p_compute_when_type=>'%null%'); null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'null;'; wwv_flow_api.create_page_process( p_id => 2826718907601723 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 6, p_process_sequence=> 10, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'PLSQL', p_process_name=> 'show value', p_process_sql_clob => p, p_process_error_message=> '', p_process_success_message=> '&P6_REPORTS.', p_process_is_stateful_y_n=>'N', p_required_patch=>null + wwv_flow_api.g_id_offset, p_process_comment=>''); end; null; end; / begin --------------------------------------- -- ...updatable report columns for page 6 -- begin null; end; null; end; / --application/pages/page_00007 prompt ...PAGE 7: Manual Form -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 7, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_MANUALFORM', p_name => 'Manual Form', p_step_title=> 'Manual Form', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> 'NO_FIRST_ITEM', p_help_text => '', p_html_page_header => '', p_step_template => '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'LARRY', p_last_upd_yyyymmddhh24miss => '20070314004402', p_page_is_public_y_n=> 'N', p_page_comment => ''); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'manual_form.do_form(:P7_DEPTNO);'; wwv_flow_api.create_page_plug ( p_id=> 2836332643772212 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 7, p_plug_name=> 'Dynamic Form', p_region_name=>'', p_plug_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'PLSQL_PROCEDURE', p_translate_title=> 'Y', p_plug_display_error_message=> '#SQLERRM#', p_plug_query_row_template=> 1, p_plug_query_headings_type=> '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=> '', p_required_patch=> '' + wwv_flow_api.g_id_offset, p_plug_comment=> ''); end; / begin wwv_flow_api.create_page_button( p_id => 2843506950935145 + 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 => 2836332643772212+wwv_flow_api.g_id_offset, p_button_name => 'SUBMIT', p_button_image => 'template:'||to_char(2519814899484189+wwv_flow_api.g_id_offset), p_button_image_alt=> 'Submit', p_button_position=> 'BOTTOM', p_button_alignment=> 'RIGHT', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>2843829686935167 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_branch_action=> 'f?p=&FLOW_ID.:7:&SESSION.::&DEBUG.&success_msg=#SUCCESS_MSG#', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_when_button_id=>2843506950935145+ wwv_flow_api.g_id_offset, p_branch_sequence=> 10, p_branch_comment=> ''); wwv_flow_api.create_page_branch( p_id=>2842134131905120 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_branch_action=> 'f?p=&APP_ID.:7:&SESSION.::&DEBUG.:::', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_sequence=> 99, p_branch_comment=> 'Created 13-MAR-2007 23:10 by LARRY'); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>2839618416891172 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 7, p_name=>'P7_DEPTNO', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 2836332643772212+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default => '20', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'Department', p_source_type=> 'STATIC', p_display_as=> 'COMBOBOX_WITH_SUBMIT', p_lov => 'select dname, deptno'||chr(10)|| ' from dept'||chr(10)|| ' order by 1', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 2000, p_cHeight=> 1, p_cAttributes=> 'nowrap="nowrap"', p_begin_on_new_line => 'YES', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 2534328150484236+wwv_flow_api.g_id_offset, p_is_persistent=> 'Y', p_lov_display_extra=>'NO', p_protection_level => 'N', p_item_comment => ''); end; / begin wwv_flow_api.create_page_validation( p_id => 2845321438225701 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 7, p_validation_name => 'Validate form', p_validation_sequence=> 10, p_validation => 'return manual_form.Validate_Form(:P7_DEPTNO);', p_validation_type => 'FUNC_BODY_RETURNING_ERR_TEXT', p_error_message => '', p_when_button_pressed=> 2843506950935145 + wwv_flow_api.g_id_offset, p_error_display_location=>'INLINE_IN_NOTIFICATION', p_validation_comment=> ''); null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'manual_form.process_form_items;'; wwv_flow_api.create_page_process( p_id => 2848937527466990 + 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=> 'Save changes', p_process_sql_clob => p, p_process_error_message=> '', p_process_when_button_id=>2843506950935145 + wwv_flow_api.g_id_offset, p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_required_patch=>null + wwv_flow_api.g_id_offset, p_process_comment=>''); end; null; end; / begin --------------------------------------- -- ...updatable report columns for page 7 -- begin null; end; null; end; / --application/pages/page_00008 prompt ...PAGE 8: Update EMP -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h:=h||'No help is available for this page.'; ph:=ph||''; wwv_flow_api.create_page( p_id => 8, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'T_MANUALFORM', p_name => 'Update EMP', p_step_title=> 'Update EMP', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> 'NO_FIRST_ITEM', p_help_text => ' ', p_html_page_header => ' ', p_step_template => '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'LARRY', p_last_upd_yyyymmddhh24miss => '20070315001022', p_page_comment => ''); wwv_flow_api.set_page_help_text(p_flow_id=>wwv_flow.g_flow_id,p_flow_step_id=>8,p_text=>h); wwv_flow_api.set_html_page_header(p_flow_id=>wwv_flow.g_flow_id,p_flow_step_id=>8,p_text=>ph); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'select '||chr(10)|| '"EMPNO",'||chr(10)|| '"EMPNO" EMPNO_DISPLAY,'||chr(10)|| '"ENAME",'||chr(10)|| '"JOB",'||chr(10)|| '"MGR",'||chr(10)|| '"HIREDATE",'||chr(10)|| '"SAL",'||chr(10)|| '"COMM",'||chr(10)|| '"DEPTNO"'||chr(10)|| 'from "#OWNER#"."EMP"'||chr(10)|| ''; wwv_flow_api.create_report_region ( p_id=> 2854915280505847 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 8, p_name=> 'Tabular Form', p_region_name=>'', p_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_display_sequence=> 15, p_display_column=> 1, p_display_point=> 'AFTER_SHOW_ITEMS', p_source=> s, p_source_type=> 'UPDATABLE_SQL_QUERY', p_display_error_message=> '#SQLERRM#', p_query_row_template=> 2531535300484233+ wwv_flow_api.g_id_offset, p_query_headings_type=> 'COLON_DELMITED_LIST', p_query_num_rows=> '10', p_query_options=> 'DERIVED_REPORT_COLUMNS', p_query_show_nulls_as=> '(null)', p_query_break_cols=> '0', p_query_no_data_found=> 'No data found.', p_query_num_rows_type=> 'ROW_RANGES_IN_SELECT_LIST', p_query_row_count_max=> '500', p_pagination_display_position=> 'BOTTOM_RIGHT', p_csv_output=> 'N', p_query_asc_image=> 'arrow_down_gray_dark.gif', p_query_asc_image_attr=> 'width="13" height="12" alt=""', p_query_desc_image=> 'arrow_up_gray_dark.gif', p_query_desc_image_attr=> 'width="13" height="12" 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=> 2857620201506025 + wwv_flow_api.g_id_offset, p_region_id=> 2854915280505847 + 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=> 'CHECK$01', p_column_display_sequence=> 1, p_column_heading=> ' ', 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=>'CHECKBOX', p_pk_col_source=> s, p_derived_column=> 'Y', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2855215580505936 + wwv_flow_api.g_id_offset, p_region_id=> 2854915280505847 + 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=> 'EMPNO', p_column_display_sequence=> 2, p_column_heading=> 'Empno', 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=> 'Y', p_display_as=>'HIDDEN', p_column_width=> '16', p_pk_col_source_type=> 'T', p_pk_col_source=> s, p_ref_schema=> 'UTOUG', p_ref_table_name=> 'EMP', p_ref_column_name=> 'EMPNO', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2855334302505945 + wwv_flow_api.g_id_offset, p_region_id=> 2854915280505847 + 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=> 'EMPNO_DISPLAY', p_column_display_sequence=> 3, p_column_heading=> 'Empno', 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=> 'Y', p_display_as=>'WITHOUT_MODIFICATION', p_column_width=> '16', p_pk_col_source=> s, p_ref_schema=> 'UTOUG', p_ref_table_name=> 'EMP', p_ref_column_name=> 'EMPNO_DISPLAY', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2855417094505945 + wwv_flow_api.g_id_offset, p_region_id=> 2854915280505847 + 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=> 'ENAME', p_column_display_sequence=> 4, p_column_heading=> 'Ename', 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=>'TEXT', p_column_width=> '10', p_pk_col_source=> s, p_ref_schema=> 'UTOUG', p_ref_table_name=> 'EMP', p_ref_column_name=> 'ENAME', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2855519552505945 + wwv_flow_api.g_id_offset, p_region_id=> 2854915280505847 + 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=> 'JOB', p_column_display_sequence=> 5, p_column_heading=> 'Job', 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=> 'Y', p_display_as=>'TEXT', p_column_width=> '9', p_pk_col_source=> s, p_ref_schema=> 'UTOUG', p_ref_table_name=> 'EMP', p_ref_column_name=> 'JOB', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2855633174505945 + wwv_flow_api.g_id_offset, p_region_id=> 2854915280505847 + 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=> 'MGR', p_column_display_sequence=> 6, p_column_heading=> 'Mgr', p_column_alignment=>'LEFT', p_heading_alignment=>'LEFT', p_default_sort_column_sequence=>0, p_disable_sort_column=>'Y', p_sum_column=> 'N', p_hidden_column=> 'N', p_display_as=>'SELECT_LIST_FROM_LOV', p_named_lov=>2837231782809803 + wwv_flow_api.g_id_offset, p_lov_show_nulls=> 'NO', p_column_width=> '16', p_pk_col_source=> s, p_lov_display_extra=> 'YES', p_ref_schema=> 'UTOUG', p_ref_table_name=> 'EMP', p_ref_column_name=> 'MGR', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2855726443505945 + wwv_flow_api.g_id_offset, p_region_id=> 2854915280505847 + 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=> 'HIREDATE', p_column_display_sequence=> 7, p_column_heading=> 'Hiredate', 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=> 'Y', p_display_as=>'TEXT', p_column_width=> '7', p_pk_col_source=> s, p_ref_schema=> 'UTOUG', p_ref_table_name=> 'EMP', p_ref_column_name=> 'HIREDATE', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2855827566505945 + wwv_flow_api.g_id_offset, p_region_id=> 2854915280505847 + 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=> 'SAL', p_column_display_sequence=> 8, p_column_heading=> 'Sal', 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=>'TEXT', p_column_width=> '16', p_pk_col_source=> s, p_ref_schema=> 'UTOUG', p_ref_table_name=> 'EMP', p_ref_column_name=> 'SAL', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2855927627505945 + wwv_flow_api.g_id_offset, p_region_id=> 2854915280505847 + 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=> 'COMM', p_column_display_sequence=> 9, p_column_heading=> 'Comm', 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=>'TEXT', p_column_width=> '16', p_pk_col_source=> s, p_ref_schema=> 'UTOUG', p_ref_table_name=> 'EMP', p_ref_column_name=> 'COMM', p_column_comment=>''); end; / declare s varchar2(32767) := null; begin s := null; wwv_flow_api.create_report_columns ( p_id=> 2856037926505945 + wwv_flow_api.g_id_offset, p_region_id=> 2854915280505847 + 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=> 'DEPTNO', p_column_display_sequence=> 10, p_column_heading=> 'Deptno', 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=> 'Y', p_display_as=>'TEXT', p_column_width=> '16', p_pk_col_source=> s, p_ref_schema=> 'UTOUG', p_ref_table_name=> 'EMP', p_ref_column_name=> 'DEPTNO', p_column_comment=>''); end; / begin wwv_flow_api.create_page_button( p_id => 2856406308505954 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 8, p_button_sequence=> 40, p_button_plug_id => 2854915280505847+wwv_flow_api.g_id_offset, p_button_name => 'ADD', p_button_image => 'template:'||to_char(2519814899484189+wwv_flow_api.g_id_offset), p_button_image_alt=> 'Add Row', p_button_position=> 'BOTTOM', p_button_alignment=> 'RIGHT', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 2856214400505954 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 8, p_button_sequence=> 30, p_button_plug_id => 2854915280505847+wwv_flow_api.g_id_offset, p_button_name => 'SUBMIT', p_button_image => 'template:'||to_char(2519814899484189+wwv_flow_api.g_id_offset), p_button_image_alt=> 'Submit', p_button_position=> 'REGION_TEMPLATE_CHANGE', p_button_alignment=> 'RIGHT', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 2856127348505954 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 8, p_button_sequence=> 10, p_button_plug_id => 2854915280505847+wwv_flow_api.g_id_offset, p_button_name => 'CANCEL', p_button_image => 'template:'||to_char(2519814899484189+wwv_flow_api.g_id_offset), p_button_image_alt=> 'Cancel', p_button_position=> 'REGION_TEMPLATE_CLOSE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'f?p=&APP_ID.:8:&SESSION.::&DEBUG.:::', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 2856323095505954 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 8, p_button_sequence=> 20, p_button_plug_id => 2854915280505847+wwv_flow_api.g_id_offset, p_button_name => 'MULTI_ROW_DELETE', p_button_image => 'template:'||to_char(2519814899484189+wwv_flow_api.g_id_offset), p_button_image_alt=> 'Delete', p_button_position=> 'REGION_TEMPLATE_DELETE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> 'javascript:confirmDelete(htmldb_delete_message,''MULTI_ROW_DELETE'');', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>2858131330506026 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 8, p_branch_action=> 'f?p=&APP_ID.:8:&SESSION.&success_msg=#SUCCESS_MSG#', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_sequence=> 1, p_branch_comment=> ''); end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'#OWNER#:EMP:EMPNO'; wwv_flow_api.create_page_process( p_id => 2857210136505998 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 8, p_process_sequence=> 10, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'MULTI_ROW_UPDATE', p_process_name=> 'ApplyMRU', p_process_sql_clob => p, p_process_error_message=> 'Unable to process update.', p_process_when_button_id=>2856214400505954 + wwv_flow_api.g_id_offset, p_process_success_message=> '#MRU_COUNT# row(s) updated, #MRI_COUNT# row(s) inserted.', p_process_is_stateful_y_n=>'N', p_required_patch=>null + wwv_flow_api.g_id_offset, p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'#OWNER#:EMP:EMPNO'; wwv_flow_api.create_page_process( p_id => 2857421772506015 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 8, p_process_sequence=> 20, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'MULTI_ROW_DELETE', p_process_name=> 'ApplyMRD', p_process_sql_clob => p, p_process_error_message=> 'Unable to process delete.', p_process_when=>'MULTI_ROW_DELETE', p_process_when_type=>'REQUEST_EQUALS_CONDITION', p_process_success_message=> '#MRD_COUNT# row(s) deleted.', p_process_is_stateful_y_n=>'N', p_required_patch=>null + wwv_flow_api.g_id_offset, p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'#OWNER#:EMP:EMPNO'; wwv_flow_api.create_page_process( p_id => 2857720736506026 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 8, p_process_sequence=> 30, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'MULTI_ROW_UPDATE', p_process_name=> 'ApplyMRU', p_process_sql_clob => p, p_process_error_message=> 'Unable to process update.', p_process_when_button_id=>2856406308505954 + wwv_flow_api.g_id_offset, p_process_success_message=> '#MRU_COUNT# row(s) updated, #MRI_COUNT# row(s) inserted.', p_process_is_stateful_y_n=>'N', p_required_patch=>null + wwv_flow_api.g_id_offset, p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'1'; wwv_flow_api.create_page_process( p_id => 2857909035506026 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 8, p_process_sequence=> 40, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'ADD_ROWS_TO_TABULAR_FORM', p_process_name=> 'AddRows', p_process_sql_clob => p, p_process_error_message=> 'Unable to add rows.', p_process_when_button_id=>2856406308505954 + wwv_flow_api.g_id_offset, p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_required_patch=>null + wwv_flow_api.g_id_offset, p_process_comment=>''); end; null; end; / begin --------------------------------------- -- ...updatable report columns for page 8 -- begin null; end; null; end; / --application/pages/page_00009 prompt ...PAGE 9: Really Long Page -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph := null; wwv_flow_api.create_page( p_id => 9, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> 'TS1', p_name => 'Really Long Page', p_step_title=> 'Really Long Page', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> 'NO_FIRST_ITEM', p_help_text => '', p_html_page_header => '', p_step_template => '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'BROWNB@TUSC.COM', p_last_upd_yyyymmddhh24miss => '20070623005517', p_page_comment => ''); end; end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||''||chr(10)|| 'This is my header region'||chr(10)|| 'Go to 2nd region'||chr(10)|| 'Go to 3rd region'||chr(10)|| 'Go to bottom'; wwv_flow_api.create_page_plug ( p_id=> 1410204096530575 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 9, p_plug_name=> 'Header Region', p_region_name=>'', p_plug_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 10, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'STATIC_TEXT', p_translate_title=> 'Y', p_plug_display_error_message=> '#SQLERRM#', p_plug_query_row_template=> 1, p_plug_query_headings_type=> 'QUERY_COLUMNS', p_plug_query_num_rows_type => 'NEXT_PREVIOUS_LINKS', p_plug_query_row_count_max => 500, p_plug_query_show_nulls_as => ' - ', p_plug_display_condition_type => '', p_pagination_display_position=>'BOTTOM_RIGHT', p_plug_customized=>'0', p_plug_caching=> 'NOT_CACHED', p_required_patch=> '' + wwv_flow_api.g_id_offset, p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'Go to top'||chr(10)|| 'This is a long region'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'That goes on and on...'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'This is a long region'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'That goes on and on...'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'This is a long region'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'That goes on and on...'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'This is a lon'; s:=s||'g region'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'That goes on and on...'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'This is a long region'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'That goes on and on...'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| ''; wwv_flow_api.create_page_plug ( p_id=> 1410902149539471 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 9, p_plug_name=> 'Second region'', p_plug_template=> 2525311669484201+ wwv_flow_api.g_id_offset, p_plug_display_sequence=> 20, p_plug_display_column=> 1, p_plug_display_point=> 'AFTER_SHOW_ITEMS', p_plug_source=> s, p_plug_source_type=> 'STATIC_TEXT', p_translate_title=> 'Y', p_plug_display_error_message=> '#SQLERRM#', p_plug_query_row_template=> 1, p_plug_query_headings_type=> '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_required_patch=> '' + wwv_flow_api.g_id_offset, p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s:=s||'Go to top'||chr(10)|| 'This is a long region'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'That goes on and on...'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'This is a long region'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'That goes on and on...'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| '
'||chr(10)|| 'This is a long region'||chr(10)|| '