set define '^'
set verify off



Rem  Copyright (c) Oracle Corporation 1999 - 2003. All Rights Reserved.
Rem
Rem    NAME
Rem      tab.sql
Rem
Rem    DESCRIPTION
Rem
Rem    NOTES
Rem
Rem    RUNTIME DEPLOYMENT: YES
Rem
Rem    MODIFIED   (MM/DD/YYYY)
Rem    tmuth       04/07/2003 - Created from Sharon's code
Rem    jstraub     05/29/2003 - Removed inserts for wwv_flow_xml_mapping, wwv_flow_xml_structure and wwv_flow_xml_upload, bug 2972214
Rem    jkallman    08/18/2003 - Corrected all month references to be numeric


-- Loading data into wwv_flow_upg_tab_obsolete

prompt ...inserting obsolete tables into wwv_flow_upg_tab_obsolete

insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_APPLICATION_TAB_SETS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_APPLICATION_TABS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_COMPANY_TYPES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_DB_AUTH',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_DYNAMIC_PAGES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_FEEDBACK',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_FILE_OBJECTS$PART',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_HTML_REPOSITORY',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_ICON_BAR_ATTRIBUTES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_LOV_VALUES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_PICK_DATABASE_SIZE',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_PICK_END_USERS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_PICK_PAGE_VIEWS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_PLATFORM_PREF',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_REQUIRED_ROLES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_SHORTCUT_USAGE_MAP',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_obsolete(table_name,obsolete_date,change_made) values ('WWV_FLOW_VERSION$',to_date('28-03-2003','DD-MM-YYYY'),'N');
commit;


-- Loading data into wwv_flow_upg_tab_name_changes

prompt ...inserting table name changes into wwv_flow_upg_tab_name_changes

insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_COLUMN_EXCEPTIONS','WWV_FLOW_UPG_COL_OBSOLETE',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_DICTIONARY$','WWV_FLOW_DICTIONARY',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_ALTERNATE_CONFIG','WWV_FLOW_ALT_CONFIG',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_BANNER','WWV_FLOW_COMMENTS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_BUILDER_AUDIT_NAMING','WWV_FLOW_FB_AUDIT_NAMING',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_BUILDER_AUDIT_TRAIL','WWV_FLOW_FB_AUDIT_TRAIL',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_COLLECTION_MEMBERS$','WWV_FLOW_COLLECTION_MEMBERS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_CUSTOM_AUTH_SETUPS','WWV_FLOW_CUSTOM_AUTH_SCHEMES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_DATA_LOAD_BAD_LOG','WWV_FLOW_DW_BAD_DATA_LOG',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_DATA_LOAD_UNLOAD','WWV_FLOW_DW_LOAD_UNLOAD_LOG',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_DYNAMIC_TRANSLATIONS$','WWV_FLOW_DYNAMIC_TRANSLATIONS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_FIELD_TEMPLATES','WWV_FLOW_LABEL_TEMPLATES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_ICON_BAR','WWV_FLOW_NAV_BAR',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_LISTS_OF_VALUES$','WWV_FLOW_LISTS_OF_VALUES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_MESSAGES$','WWV_FLOW_MESSAGES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_PAGE_GENERIC_ATTR','WWV_FLOW_REGION_GENERIC_ATTR',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_PAGE_PLUG_TEMPLATES','WWV_FLOW_REGION_TEMPLATES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_PAGE_PLUGS','WWV_FLOW_PAGE_REGIONS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_PATCHES','WWV_FLOW_BUILD_OPTIONS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_PREFERENCES$','WWV_FLOW_PREFERENCES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_PURGED_SESSIONS$','WWV_FLOW_PURGED_SESSIONS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_ROW_TEMPLATES','WWV_FLOW_REPORT_TEMPLATES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_RT_DISTRIBUTIONS$','WWV_FLOW_RT_DISTRIBUTIONS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_RT_DOWNLOADS$','WWV_FLOW_RT_DOWNLOADS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_RT_REQUESTS$','WWV_FLOW_RT_REQUESTS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_SESSIONS$','WWV_FLOW_SESSIONS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_STEP_BRANCH_ARGS','WWV_FLOW_PAGE_BRANCH_ARGS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_STEP_BRANCHES','WWV_FLOW_PAGE_BRANCHES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_STEP_BUTTONS','WWV_FLOW_PAGE_BUTTONS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_STEP_COMPUTATIONS','WWV_FLOW_PAGE_COMPUTATIONS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_STEP_ITEM_HELP','WWV_FLOW_PAGE_ITEM_HELP',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_STEP_ITEMS','WWV_FLOW_PAGE_ITEMS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_STEP_PROCESSING','WWV_FLOW_PAGE_PROCESSING',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_STEP_VALIDATIONS','WWV_FLOW_PAGE_VALIDATIONS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_STEPS','WWV_FLOW_PAGES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_TEMPLATE_THEMES$','WWV_FLOW_TEMPLATE_THEMES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_TEMPLATES','WWV_FLOW_PAGE_TEMPLATES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_TEMPLATES$','WWV_FLOW_TEMPLATES',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_TOPLEVEL_TABS','WWV_FLOW_PARENT_TABS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_TRANSLATABLE_COLS$','WWV_FLOW_TRANSLATABLE_COLS',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_TRANSLATABLE_TEXT$','WWV_FLOW_TRANSLATABLE_TEXT',to_date('28-03-2003','DD-MM-YYYY'),'N');
insert into wwv_flow_upg_tab_name_changes(old_table_name,new_table_name,change_date,change_made) values ('WWV_FLOW_UPGRADE_PROGRESS','WWV_FLOW_UPG_PROGRESS',to_date('28-03-2003','DD-MM-YYYY'),'N');
commit;