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 102 - SCRATCH -- -- Application Export: -- Application: 102 -- Name: SCRATCH -- Date and Time: 12:02 Monday September 21, 2009 -- Exported By: JROWBOTTOM -- Flashback: 0 -- Export Type: Page Export -- Version: 3.2.1.00.10 -- Import: -- Using application builder -- or -- Using SQL*Plus as the Oracle user APEX_030200 or as the owner (parsing schema) of the application. -- AAAA PPPPP EEEEEE XX XX -- AA AA PP PP EE XX XX -- AA AA PP PP EE XX XX -- AAAAAAAAAA PPPPP EEEE XXXX -- AA AA PP EE XX XX -- AA AA PP EE XX XX -- AA AA PP EEEEEE XX XX prompt Set Credentials... begin -- Assumes you are running the script connected to SQL*Plus as the Oracle user APEX_030200 or as the owner (parsing schema) of the application. wwv_flow_api.set_security_group_id(p_security_group_id=>1044519995403809); 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-gb'; end; / prompt Check Compatibility... begin -- This date identifies the minimum version required to import this file. wwv_flow_api.set_version(p_version_yyyy_mm_dd=>'2009.01.12'); end; / prompt Set Application ID... begin -- SET APPLICATION ID wwv_flow.g_flow_id := 102; wwv_flow_api.g_id_offset := 0; null; end; / PROMPT ...Remove page 4 begin wwv_flow_api.remove_page (p_flow_id=>wwv_flow.g_flow_id, p_page_id=>4); end; / --application/pages/page_00004 prompt ...PAGE 4: Two form test (2) -- begin declare h varchar2(32767) := null; ph varchar2(32767) := null; begin h := null; ph:=ph||''; wwv_flow_api.create_page( p_id => 4, p_flow_id=> wwv_flow.g_flow_id, p_tab_set=> '', p_name => 'Two form test (2)', p_step_title=> 'Two form test (2)', p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS', p_first_item=> 'NO_FIRST_ITEM', p_include_apex_css_js_yn=>'Y', p_autocomplete_on_off => '', p_help_text => '', p_html_page_header => ' ', p_step_template => '', p_required_patch=> null + wwv_flow_api.g_id_offset, p_last_updated_by => 'JROWBOTTOM', p_last_upd_yyyymmddhh24miss => '20090921120030', 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 := null; wwv_flow_api.create_page_plug ( p_id=> 1230624515924075 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_plug_name=> 'Id Holder', p_region_name=>'', p_plug_template=> 1199712218410073+ 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=> 'COLON_DELMITED_LIST', p_plug_query_row_count_max => 500, p_plug_display_condition_type => '', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 1231208154938254 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_plug_name=> 'Form on TEST_TABLE_1', p_region_name=>'', p_plug_template=> 1199712218410073+ 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=> 'COLON_DELMITED_LIST', p_plug_query_row_count_max => 500, p_plug_display_condition_type => '', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 1233619582941612 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 4, p_plug_name=> 'Form on TEST_TABLE_2', p_region_name=>'', p_plug_template=> 1199712218410073+ 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=> 'COLON_DELMITED_LIST', p_plug_query_row_count_max => 500, p_plug_display_condition_type => '', p_plug_caching=> 'NOT_CACHED', p_plug_comment=> ''); end; / begin wwv_flow_api.create_page_button( p_id => 1231525834938254 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 4, p_button_sequence=> 30, p_button_plug_id => 1231208154938254+wwv_flow_api.g_id_offset, p_button_name => 'SAVE', p_button_image => 'template:'||to_char(1197721703410031+wwv_flow_api.g_id_offset), p_button_image_alt=> 'Apply Changes', p_button_position=> 'REGION_TEMPLATE_CHANGE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_condition=> 'P4_T1_ID', p_button_condition_type=> 'ITEM_IS_NOT_NULL', p_database_action=>'UPDATE', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 1233923498941612 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 4, p_button_sequence=> 30, p_button_plug_id => 1233619582941612+wwv_flow_api.g_id_offset, p_button_name => 'SAVE', p_button_image => 'template:'||to_char(1197721703410031+wwv_flow_api.g_id_offset), p_button_image_alt=> 'Apply Changes', p_button_position=> 'REGION_TEMPLATE_CHANGE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_condition=> 'P4_T2_ID', p_button_condition_type=> 'ITEM_IS_NOT_NULL', p_database_action=>'UPDATE', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 1231801232938256 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 4, p_button_sequence=> 10, p_button_plug_id => 1231208154938254+wwv_flow_api.g_id_offset, p_button_name => 'CANCEL', p_button_image => 'template:'||to_char(1197721703410031+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.:4:&SESSION.::&DEBUG.:::', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 1234222223941612 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 4, p_button_sequence=> 10, p_button_plug_id => 1233619582941612+wwv_flow_api.g_id_offset, p_button_name => 'CANCEL', p_button_image => 'template:'||to_char(1197721703410031+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.:4:&SESSION.::&DEBUG.:::', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 1231400358938254 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 4, p_button_sequence=> 40, p_button_plug_id => 1231208154938254+wwv_flow_api.g_id_offset, p_button_name => 'CREATE', p_button_image => 'template:'||to_char(1197721703410031+wwv_flow_api.g_id_offset), p_button_image_alt=> 'Create', p_button_position=> 'REGION_TEMPLATE_CREATE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_condition=> 'P4_T1_ID', p_button_condition_type=> 'ITEM_IS_NULL', p_database_action=>'INSERT', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 1233826009941612 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 4, p_button_sequence=> 40, p_button_plug_id => 1233619582941612+wwv_flow_api.g_id_offset, p_button_name => 'CREATE', p_button_image => 'template:'||to_char(1197721703410031+wwv_flow_api.g_id_offset), p_button_image_alt=> 'Create', p_button_position=> 'REGION_TEMPLATE_CREATE', p_button_alignment=> 'RIGHT', p_button_redirect_url=> '', p_button_condition=> 'P4_T2_ID', p_button_condition_type=> 'ITEM_IS_NULL', p_database_action=>'INSERT', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 1231606736938254 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 4, p_button_sequence=> 20, p_button_plug_id => 1231208154938254+wwv_flow_api.g_id_offset, p_button_name => 'DELETE', p_button_image => 'template:'||to_char(1197721703410031+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,''DELETE'');', p_button_condition=> 'P4_T1_ID', p_button_condition_type=> 'ITEM_IS_NOT_NULL', p_database_action=>'DELETE', p_required_patch => null + wwv_flow_api.g_id_offset); wwv_flow_api.create_page_button( p_id => 1234007988941612 + wwv_flow_api.g_id_offset, p_flow_id => wwv_flow.g_flow_id, p_flow_step_id => 4, p_button_sequence=> 20, p_button_plug_id => 1233619582941612+wwv_flow_api.g_id_offset, p_button_name => 'DELETE', p_button_image => 'template:'||to_char(1197721703410031+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,''DELETE'');', p_button_condition=> 'P4_T2_ID', p_button_condition_type=> 'ITEM_IS_NOT_NULL', p_database_action=>'DELETE', p_required_patch => null + wwv_flow_api.g_id_offset); end; / begin wwv_flow_api.create_page_branch( p_id=>1236319713951092 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_branch_action=> 'f?p=&APP_ID.:4:&SESSION.::&DEBUG.::P4_T1_ID,P4_T2_ID:&P4_T1_ENTERED_ID.,&P4_T2_ENTERED_ID.', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_when_button_id=>1236525947952873+ wwv_flow_api.g_id_offset, p_branch_sequence=> 10, p_save_state_before_branch_yn=>'N', p_branch_comment=> 'Created 21-SEP-2009 11:00 by JROWBOTTOM'); wwv_flow_api.create_page_branch( p_id=>1232412924938262 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_branch_action=> 'f?p=&APP_ID.:4:&SESSION.::&DEBUG.:::&success_msg=#SUCCESS_MSG#', p_branch_point=> 'AFTER_PROCESSING', p_branch_type=> 'REDIRECT_URL', p_branch_sequence=> 99, p_save_state_before_branch_yn=>'N', p_branch_comment=> ''); end; / declare h varchar2(32767) := null; begin wwv_flow_api.create_page_item( p_id=>1230902482927186 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_T1_ENTERED_ID', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 10, p_item_plug_id => 1230624515924075+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'T1 Entered Id', 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=> 5, 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 => 1202903859410128+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=>1231124646933629 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_T2_ENTERED_ID', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 1230624515924075+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'YES', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'T2 Entered Id', 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=> 5, 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 => 1202903859410128+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=>1232605484938267 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_T1_ID', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 1, p_item_plug_id => 1231208154938254+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'NO', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'T1 Id', p_source=>'T1_ID', p_source_type=> 'DB_COLUMN', p_display_as=> 'DISPLAY_ONLY_ESCAPE_SC', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 255, p_cHeight=> 1, p_begin_on_new_line => 'YES', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 1202903859410128+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=>1232810772938276 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_T1_VALUE', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 1231208154938254+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'NO', p_prompt=>'T1 Value', p_source=>'T1_VALUE', p_source_type=> 'DB_COLUMN', p_display_as=> 'TEXT', p_lov_columns=> null, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 32, p_cMaxlength=> 100, p_cHeight=> 1, p_begin_on_new_line => 'YES', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 1202903859410128+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=>1235023576941614 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_T2_ID', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 1, p_item_plug_id => 1233619582941612+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'NO', p_item_default_type => 'STATIC_TEXT_WITH_SUBSTITUTIONS', p_prompt=>'T2 Id', p_source=>'T2_ID', p_source_type=> 'DB_COLUMN', p_display_as=> 'DISPLAY_ONLY_ESCAPE_SC', p_lov_columns=> 1, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 30, p_cMaxlength=> 255, p_cHeight=> 1, p_begin_on_new_line => 'YES', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 1202903859410128+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=>1235202272941614 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_T2_VALUE', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 20, p_item_plug_id => 1233619582941612+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'NO', p_prompt=>'T2 Value', p_source=>'T2_VALUE', p_source_type=> 'DB_COLUMN', p_display_as=> 'TEXT', p_lov_columns=> null, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> 32, p_cMaxlength=> 100, p_cHeight=> 1, p_begin_on_new_line => 'YES', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_label_alignment => 'RIGHT', p_field_alignment => 'LEFT', p_field_template => 1202903859410128+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=>1236525947952873 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id=> 4, p_name=>'P4_GO', p_data_type=> 'VARCHAR', p_accept_processing=> 'REPLACE_EXISTING', p_item_sequence=> 30, p_item_plug_id => 1230624515924075+wwv_flow_api.g_id_offset, p_use_cache_before_default=> 'NO', p_item_default => 'Go', p_prompt=>'Go', p_source=>'Go', p_source_type=> 'STATIC', p_display_as=> 'BUTTON', p_lov_columns=> null, p_lov_display_null=> 'NO', p_lov_translated=> 'N', p_cSize=> null, p_cMaxlength=> 2000, p_cHeight=> null, p_begin_on_new_line => 'NO', p_begin_on_new_field=> 'YES', p_colspan => 1, p_rowspan => 1, p_button_image => 'go.gif', p_label_alignment => 'LEFT', p_field_alignment => 'LEFT', p_is_persistent=> 'N', p_item_comment => ''); end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'F|#OWNER#:TEST_TABLE_1:P4_T1_ID:T1_ID'; wwv_flow_api.create_page_process( p_id => 1233118898938278 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 4, p_process_sequence=> 11, p_process_point=> 'AFTER_HEADER', p_process_type=> 'DML_FETCH_ROW', p_process_name=> 'Fetch Row from TEST_TABLE_1', p_process_sql_clob => p, p_process_error_message=> 'T1: Unable to fetch row.', p_process_success_message=> 'T1: Row fetched', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'F|#OWNER#:TEST_TABLE_2:P4_T2_ID:T2_ID'; wwv_flow_api.create_page_process( p_id => 1235507445941614 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 4, p_process_sequence=> 12, p_process_point=> 'AFTER_HEADER', p_process_type=> 'DML_FETCH_ROW', p_process_name=> 'Fetch Row from TEST_TABLE_2', p_process_sql_clob => p, p_process_error_message=> 'T2: Unable to fetch row.', p_process_success_message=> 'T2: Row fetched', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'#OWNER#:TEST_TABLE_1:P4_T1_ID:T1_ID|IUD'; wwv_flow_api.create_page_process( p_id => 1233302397938281 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 4, p_process_sequence=> 30, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'DML_PROCESS_ROW', p_process_name=> 'Process Row of TEST_TABLE_1', p_process_sql_clob => p, p_process_error_message=> 'Unable to process row of table TEST_TABLE_1.', p_process_success_message=> 'Action Processed.', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'#OWNER#:TEST_TABLE_2:P4_T2_ID:T2_ID|IUD'; wwv_flow_api.create_page_process( p_id => 1235710113941614 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 4, p_process_sequence=> 30, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'DML_PROCESS_ROW', p_process_name=> 'Process Row of TEST_TABLE_2', p_process_sql_clob => p, p_process_error_message=> 'Unable to process row of table TEST_TABLE_2.', p_process_success_message=> 'Action Processed.', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'4'; wwv_flow_api.create_page_process( p_id => 1233520631938281 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 4, p_process_sequence=> 40, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'CLEAR_CACHE_FOR_PAGES', p_process_name=> 'reset page', p_process_sql_clob => p, p_process_error_message=> '', p_process_when_button_id=>1231606736938254 + wwv_flow_api.g_id_offset, p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin declare p varchar2(32767) := null; l_clob clob; l_length number := 1; begin p:=p||'4'; wwv_flow_api.create_page_process( p_id => 1235911508941614 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_flow_step_id => 4, p_process_sequence=> 40, p_process_point=> 'AFTER_SUBMIT', p_process_type=> 'CLEAR_CACHE_FOR_PAGES', p_process_name=> 'reset page', p_process_sql_clob => p, p_process_error_message=> '', p_process_when_button_id=>1234007988941612 + wwv_flow_api.g_id_offset, p_process_success_message=> '', p_process_is_stateful_y_n=>'N', p_process_comment=>''); end; null; end; / begin --------------------------------------- -- ...updatable report columns for page 4 -- begin null; end; null; end; / commit; begin execute immediate 'alter session set nls_numeric_characters='''||wwv_flow_api.g_nls_numeric_chars||''''; end; / set verify on set feedback on prompt ...done