'||chr(10)||
' '||chr(10)||
' | #CLOSE# #PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP# | '||chr(10)||
' '||chr(10)||
' '||chr(10)||
''||chr(10)||
''||chr(10)||
' | #BODY# | '||chr(10)||
' '||chr(10)||
'
';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511993328446044782 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Bracketed Region',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 18,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511993328446044782 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/breadcrumb_region
prompt ......region template 1511993415805044782
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'#BODY# ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511993415805044782 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Breadcrumb Region',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 6,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511993415805044782 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/button_region_with_title
prompt ......region template 1511993509676044782
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'#BODY#'||chr(10)||
'';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511993509676044782 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Button Region with Title',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 4,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511993509676044782 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/button_region_without_title
prompt ......region template 1511993604018044782
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
'#BODY#';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511993604018044782 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Button Region without Title',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 17,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511993604018044782 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/chart_region
prompt ......region template 1511993712532044784
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
''||chr(10)||
''||chr(10)||
''||chr(10)||
'| #CLOSE# #PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP# | '||chr(10)||
' '||chr(10)||
''||chr(10)||
''||chr(10)||
''||chr(10)||
'| #BODY# | '||chr(10)||
' '||chr(10)||
' ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511993712532044784 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Chart Region',
p_plug_table_bgcolor => '#ffffff',
p_theme_id => 3,
p_theme_class_id => 30,
p_plug_heading_bgcolor => '#ffffff',
p_plug_font_size => '-1',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511993712532044784 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/form_region
prompt ......region template 1511993822422044784
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511993822422044784 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Form Region',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 8,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511993822422044784 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/hide_and_show_region
prompt ......region template 1511993907334044784
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
''||chr(10)||
''||chr(10)||
''||chr(10)||
'| #CLOSE# #PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP# | '||chr(10)||
' '||chr(10)||
' | '||chr(10)||
' '||chr(10)||
''||chr(10)||
'#BODY# | '||chr(10)||
' '||chr(10)||
' ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511993907334044784 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Hide and Show Region',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 1,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => 'Gray Head, white body');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511993907334044784 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/list_region_with_icon_chart_list
prompt ......region template 1511994029983044784
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
''||chr(10)||
'| #CLOSE# #PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP# | '||chr(10)||
' '||chr(10)||
''||chr(10)||
' | '||chr(10)||
'#BODY# |
| '||chr(10)||
' '||chr(10)||
' ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511994029983044784 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'List Region with Icon - Chart List',
p_plug_table_bgcolor => '#ffffff',
p_theme_id => 3,
p_theme_class_id => 29,
p_plug_heading_bgcolor => '#ffffff',
p_plug_font_size => '-1',
p_translate_this_template => 'N',
p_template_comment => 'Red Theme');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511994029983044784 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/list_region_with_icon_report_list
prompt ......region template 1511994111662044784
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
''||chr(10)||
'| #CLOSE# #PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP# | '||chr(10)||
' '||chr(10)||
''||chr(10)||
''||chr(10)||
' | '||chr(10)||
'#BODY# |
| '||chr(10)||
' '||chr(10)||
' ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511994111662044784 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'List Region with Icon - Report List',
p_plug_table_bgcolor => '#ffffff',
p_theme_id => 3,
p_theme_class_id => 29,
p_plug_heading_bgcolor => '#ffffff',
p_plug_font_size => '-1',
p_translate_this_template => 'N',
p_template_comment => 'Red Theme');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511994111662044784 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/navigation_region
prompt ......region template 1511994211314044784
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'#BODY# ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511994211314044784 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Navigation Region',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 5,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511994211314044784 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/navigation_region_alternative_1
prompt ......region template 1511994300684044785
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
'#BODY# ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511994300684044785 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Navigation Region, Alternative 1',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 16,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511994300684044785 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/region_without_buttons_and_titles
prompt ......region template 1511994418887044785
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
'';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511994418887044785 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Region without Buttons and Titles',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 19,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511994418887044785 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/region_without_title
prompt ......region template 1511994530841044785
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
'| #CLOSE# #PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP# | '||chr(10)||
''||chr(10)||
'| #BODY# | ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511994530841044785 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Region without Title',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 11,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511994530841044785 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/report_filter_single_row
prompt ......region template 1511994617206044785
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
''||chr(10)||
' | '||chr(10)||
' | '||chr(10)||
'#BODY# | '||chr(10)||
'
| '||chr(10)||
'#CLOSE##EDIT##CHANGE##DELETE##CREATE##CREATE2##COPY##PREVIOUS##NEXT##EXPAND##HELP# | '||chr(10)||
' '||chr(10)||
'
| '||chr(10)||
''||chr(10)||
' | '||chr(10)||
' '||chr(10)||
''||chr(10)||
' ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511994617206044785 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Report Filter - Single Row',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 31,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511994617206044785 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/reports_region
prompt ......region template 1511994710487044785
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
''||chr(10)||
'| #CLOSE# #PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP# | '||chr(10)||
' '||chr(10)||
''||chr(10)||
'| #BODY# | '||chr(10)||
' '||chr(10)||
' ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511994710487044785 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Reports Region',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 9,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511994710487044785 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/reports_region_100_width
prompt ......region template 1511994820416044785
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
''||chr(10)||
'| #CLOSE# #PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP# | '||chr(10)||
' '||chr(10)||
''||chr(10)||
'| #BODY# | '||chr(10)||
' '||chr(10)||
' ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511994820416044785 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Reports Region 100% Width',
p_plug_table_bgcolor => '#ffffff',
p_theme_id => 3,
p_theme_class_id => 13,
p_plug_heading_bgcolor => '#ffffff',
p_plug_font_size => '-1',
p_translate_this_template => 'N',
p_template_comment => 'Red Theme');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511994820416044785 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/reports_region_alternative_1
prompt ......region template 1511994920579044785
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
''||chr(10)||
'| #CLOSE# #PREVIOUS##NEXT##DELETE##EDIT##CHANGE##CREATE##CREATE2##EXPAND##COPY##HELP# | '||chr(10)||
''||chr(10)||
'| #BODY# | '||chr(10)||
' '||chr(10)||
' ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511994920579044785 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Reports Region, Alternative 1',
p_plug_table_bgcolor => '#ffffff',
p_theme_id => 3,
p_theme_class_id => 10,
p_plug_heading_bgcolor => '#ffffff',
p_plug_font_size => '-1',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511994920579044785 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/sidebar_region
prompt ......region template 1511995025967044785
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||'';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511995025967044785 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Sidebar Region',
p_plug_table_bgcolor => '#f7f7e7',
p_theme_id => 3,
p_theme_class_id => 2,
p_plug_heading_bgcolor => '#f7f7e7',
p_plug_font_size => '-1',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511995025967044785 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/sidebar_region_alternative_1
prompt ......region template 1511995310365044786
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
'  | '||chr(10)||
' '||chr(10)||
' '||chr(10)||
'  | '||chr(10)||
' '||chr(10)||
' '||chr(10)||
'
';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511995310365044786 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Sidebar Region, Alternative 1',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 3,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511995310365044786 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/wizard_region
prompt ......region template 1511995424993044786
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
' '||chr(10)||
' '||chr(10)||
' | #BODY# | '||chr(10)||
' '||chr(10)||
' ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511995424993044786 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Wizard Region',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 12,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511995424993044786 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/region/wizard_region_with_icon
prompt ......region template 1511995501189044786
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
' '||chr(10)||
' '||chr(10)||
' '||chr(10)||
' '||chr(10)||
'  | '||chr(10)||
' #BODY# | '||chr(10)||
' '||chr(10)||
' | '||chr(10)||
' '||chr(10)||
' ';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 1511995501189044786 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Wizard Region with Icon',
p_plug_table_bgcolor => '',
p_theme_id => 3,
p_theme_class_id => 20,
p_plug_heading_bgcolor => '',
p_plug_font_size => '',
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 1511995501189044786 + wwv_flow_api.g_id_offset,
p_form_table_attr=> t2 );
exception when others then null;
end;
null;
end;
/
prompt ...List Templates
--
--application/shared_components/user_interface/templates/list/button_list
prompt ......list template 1511995619159044787
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'';
t2:=t2||''||chr(10)||
' '||chr(10)||
'  | '||chr(10)||
' #TEXT# | '||chr(10)||
'  | '||chr(10)||
' '||chr(10)||
' ';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511995619159044787 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Button List',
p_theme_id => 3,
p_theme_class_id => 6,
p_list_template_before_rows=>'',
p_list_template_after_rows=>' ',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/dhtml_menu_with_sublist
prompt ......list template 1511995712093044793
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'';
t2:=t2||'';
t3:=t3||'';
t4:=t4||'';
t5:=t5||'';
t6:=t6||'';
t7:=t7||'';
t8:=t8||'';
wwv_flow_api.create_list_template (
p_id=>1511995712093044793 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'DHTML Menu with Sublist',
p_theme_id => 3,
p_theme_class_id => 20,
p_list_template_before_rows=>'
',
p_before_sub_list=>'',
p_sub_list_item_current=> t3,
p_sub_list_item_noncurrent=> t4,
p_item_templ_curr_w_child=> t5,
p_item_templ_noncurr_w_child=> t6,
p_sub_templ_curr_w_child=> t7,
p_sub_templ_noncurr_w_child=> t8,
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/dhtml_tree
prompt ......list template 1511995821668044793
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||' #TEXT#';
t2:=t2||'#TEXT#';
t3:=t3||'#TEXT#';
t4:=t4||'#TEXT#';
t5:=t5||' #TEXT#';
t6:=t6||'#TEXT#';
t7:=t7||'#TEXT#';
t8:=t8||'#TEXT#';
wwv_flow_api.create_list_template (
p_id=>1511995821668044793 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'DHTML Tree',
p_theme_id => 3,
p_theme_class_id => 22,
p_list_template_before_rows=>'',
p_list_template_after_rows=>'
',
p_before_sub_list=>'',
p_sub_list_item_current=> t3,
p_sub_list_item_noncurrent=> t4,
p_item_templ_curr_w_child=> t5,
p_item_templ_noncurr_w_child=> t6,
p_sub_templ_curr_w_child=> t7,
p_sub_templ_noncurr_w_child=> t8,
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/horizontal_images_with_label_list
prompt ......list template 1511995919729044795
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||' | 
#TEXT# | ';
t2:=t2||'
#TEXT# | ';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511995919729044795 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Horizontal Images with Label List',
p_theme_id => 3,
p_theme_class_id => 4,
p_list_template_before_rows=>'',
p_list_template_after_rows=>'
',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/horizontal_links_list
prompt ......list template 1511996028620044795
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'#TEXT#';
t2:=t2||'#TEXT#';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511996028620044795 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Horizontal Links List',
p_theme_id => 3,
p_theme_class_id => 3,
p_list_template_before_rows=>'',
p_list_template_after_rows=>' ',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/pull_down_menu_with_image
prompt ......list template 1511996128079044795
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'';
t2:=t2||'';
t3:=t3||'';
t4:=t4||'';
t5:=t5||'';
t6:=t6||'';
t7:=t7||'';
t8:=t8||'';
wwv_flow_api.create_list_template (
p_id=>1511996128079044795 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Pull Down Menu with Image',
p_theme_id => 3,
p_theme_class_id => 21,
p_list_template_before_rows=>'
',
p_before_sub_list=>'',
p_sub_list_item_current=> t3,
p_sub_list_item_noncurrent=> t4,
p_item_templ_curr_w_child=> t5,
p_item_templ_noncurr_w_child=> t6,
p_sub_templ_curr_w_child=> t7,
p_sub_templ_noncurr_w_child=> t8,
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/pull_down_menu_with_image_custom_1
prompt ......list template 1511996202041044796
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'';
t2:=t2||'';
t3:=t3||'';
t4:=t4||'';
t5:=t5||'';
t6:=t6||'';
t7:=t7||'';
t8:=t8||'';
wwv_flow_api.create_list_template (
p_id=>1511996202041044796 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Pull Down Menu with Image (Custom 1)',
p_theme_id => 3,
p_theme_class_id => 9,
p_list_template_before_rows=>'
',
p_before_sub_list=>'',
p_sub_list_item_current=> t3,
p_sub_list_item_noncurrent=> t4,
p_item_templ_curr_w_child=> t5,
p_item_templ_noncurr_w_child=> t6,
p_sub_templ_curr_w_child=> t7,
p_sub_templ_noncurr_w_child=> t8,
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/tabbed_navigation_list
prompt ......list template 1511996332765044799
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||''||chr(10)||
''||chr(10)||
'| | '||chr(10)||
''||chr(10)||
'#TEXT# | '||chr(10)||
' | '||chr(10)||
' | ';
t2:=t2||''||chr(10)||
'| | #TEXT# | '||chr(10)||
' | '||chr(10)||
' | ';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511996332765044799 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Tabbed Navigation List',
p_theme_id => 3,
p_theme_class_id => 7,
p_list_template_before_rows=>'',
p_list_template_after_rows=>'
',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/tree_list
prompt ......list template 1511996428044044799
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'#TEXT#';
t2:=t2||'#TEXT#';
t3:=t3||'#TEXT#';
t4:=t4||'#TEXT#';
t5:=t5||'#TEXT#';
t6:=t6||'#TEXT#';
t7:=t7||'#TEXT#';
t8:=t8||'#TEXT#';
wwv_flow_api.create_list_template (
p_id=>1511996428044044799 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Tree List',
p_theme_id => 3,
p_theme_class_id => 23,
p_list_template_before_rows=>'',
p_list_template_after_rows=>'
',
p_before_sub_list=>'',
p_sub_list_item_current=> t3,
p_sub_list_item_noncurrent=> t4,
p_item_templ_curr_w_child=> t5,
p_item_templ_noncurr_w_child=> t6,
p_sub_templ_curr_w_child=> t7,
p_sub_templ_noncurr_w_child=> t8,
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/vertical_images_list
prompt ......list template 1511996512395044807
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||' | ';
t2:=t2||' | ';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511996512395044807 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Vertical Images List',
p_theme_id => 3,
p_theme_class_id => 5,
p_list_template_before_rows=>'',
p_list_template_after_rows=>' ',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/vertical_images_list_custom_2
prompt ......list template 1511996607533044807
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||' | #TEXT# | '||chr(10)||
'';
t2:=t2||' | #TEXT# | '||chr(10)||
'';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511996607533044807 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Vertical Images List (Custom 2)',
p_theme_id => 3,
p_theme_class_id => 10,
p_list_template_before_rows=>'',
p_list_template_after_rows=>' '||chr(10)||
'',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/vertical_ordered_list
prompt ......list template 1511996721136044807
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'#TEXT#';
t2:=t2||'#TEXT#';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511996721136044807 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Vertical Ordered List',
p_theme_id => 3,
p_theme_class_id => 2,
p_list_template_before_rows=>'',
p_list_template_after_rows=>' ',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/vertical_sidebar_list
prompt ......list template 1511996829172044807
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'| #TEXT# | ';
t2:=t2||'| #TEXT# | ';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511996829172044807 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Vertical Sidebar List',
p_theme_id => 3,
p_theme_class_id => 19,
p_list_template_before_rows=>'',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/vertical_unordered_list_with_bullets
prompt ......list template 1511996929208044807
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'#TEXT#';
t2:=t2||'#TEXT#';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511996929208044807 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Vertical Unordered List with Bullets',
p_theme_id => 3,
p_theme_class_id => 1,
p_list_template_before_rows=>'',
p_list_template_after_rows=>' ',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/vertical_unordered_list_without_bullet
prompt ......list template 1511997005948044807
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'#TEXT#';
t2:=t2||'#TEXT#';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511997005948044807 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Vertical Unordered List without Bullet',
p_theme_id => 3,
p_theme_class_id => 18,
p_list_template_before_rows=>'',
p_list_template_after_rows=>' ',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/wizard_progress_list
prompt ......list template 1511997103916044807
begin
declare
t varchar2(32767) := null;
t2 varchar2(32767) := null;
t3 varchar2(32767) := null;
t4 varchar2(32767) := null;
t5 varchar2(32767) := null;
t6 varchar2(32767) := null;
t7 varchar2(32767) := null;
t8 varchar2(32767) := null;
l_clob clob;
l_clob2 clob;
l_clob3 clob;
l_clob4 clob;
l_clob5 clob;
l_clob6 clob;
l_clob7 clob;
l_clob8 clob;
l_length number := 1;
begin
t:=t||'#TEXT# '||chr(10)||
'';
t2:=t2||'#TEXT# '||chr(10)||
'';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>1511997103916044807 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_list_template_current=>t,
p_list_template_noncurrent=> t2,
p_list_template_name=>'Wizard Progress List',
p_theme_id => 3,
p_theme_class_id => 17,
p_list_template_before_rows=>'',
p_list_template_after_rows=>' &DONE. '||chr(10)||
' #TOP_PAGINATION#'||chr(10)||
'',
p_row_template_after_rows =>'#PAGINATION#'||chr(10)||
' #EXTERNAL_LINK##CSV_LINK# | ',
p_row_template_table_attr =>'',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'#COLUMN_HEADER# | ',
p_row_template_display_cond1=>'0',
p_row_template_display_cond2=>'0',
p_row_template_display_cond3=>'0',
p_row_template_display_cond4=>'0',
p_theme_id => 3,
p_theme_class_id => 1,
p_translate_this_template => 'N',
p_row_template_comment=> '.t1reportborderless{ }'||chr(10)||
'.t1reportborderless .t1reportheader{ }'||chr(10)||
'.t1reportborderless .t1reportdata{ }');
end;
null;
end;
/
begin
begin
wwv_flow_api.create_row_template_patch (
p_id => 1511997212921044807 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'',
p_row_template_after_last =>' ');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/horizontal_border
prompt ......report template 1511997329080044811
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'#COLUMN_VALUE#';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 1511997329080044811 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'Horizontal Border',
p_row_template1=> c1,
p_row_template_condition1=> '',
p_row_template2=> c2,
p_row_template_condition2=> '',
p_row_template3=> c3,
p_row_template_condition3=> '',
p_row_template4=> c4,
p_row_template_condition4=> '',
p_row_template_before_rows=>''||chr(10)||
'#TOP_PAGINATION#'||chr(10)||
''||chr(10)||
'',
p_row_template_after_rows =>''||chr(10)||
' | '||chr(10)||
' #EXTERNAL_LINK##CSV_LINK#'||chr(10)||
' '||chr(10)||
' | '||chr(10)||
' | ',
p_row_template_table_attr =>'',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'#COLUMN_HEADER#',
p_row_template_display_cond1=>'0',
p_row_template_display_cond2=>'0',
p_row_template_display_cond3=>'0',
p_row_template_display_cond4=>'0',
p_theme_id => 3,
p_theme_class_id => 2,
p_translate_this_template => 'N',
p_row_template_comment=> '');
end;
null;
end;
/
begin
begin
wwv_flow_api.create_row_template_patch (
p_id => 1511997329080044811 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'',
p_row_template_after_last =>' ');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/one_column_unordered_list
prompt ......report template 1511997422323044811
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'#COLUMN_VALUE#';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 1511997422323044811 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'One Column Unordered List',
p_row_template1=> c1,
p_row_template_condition1=> '',
p_row_template2=> c2,
p_row_template_condition2=> '',
p_row_template3=> c3,
p_row_template_condition3=> '',
p_row_template4=> c4,
p_row_template_condition4=> '',
p_row_template_before_rows=>''||chr(10)||
'#TOP_PAGINATION#'||chr(10)||
'',
p_row_template_after_rows =>' #EXTERNAL_LINK##CSV_LINK# | '||chr(10)||
'#PAGINATION#'||chr(10)||
' ',
p_row_template_table_attr =>'OMIT',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'',
p_row_template_display_cond1=>'NOT_CONDITIONAL',
p_row_template_display_cond2=>'NOT_CONDITIONAL',
p_row_template_display_cond3=>'NOT_CONDITIONAL',
p_row_template_display_cond4=>'NOT_CONDITIONAL',
p_theme_id => 3,
p_theme_class_id => 3,
p_translate_this_template => 'N',
p_row_template_comment=> '');
end;
null;
end;
/
begin
begin
wwv_flow_api.create_row_template_patch (
p_id => 1511997422323044811 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'OMIT',
p_row_template_after_last =>'OMIT');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/standard_report
prompt ......report template 1511997528380044811
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'#COLUMN_VALUE# | ';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 1511997528380044811 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'Standard Report',
p_row_template1=> c1,
p_row_template_condition1=> '',
p_row_template2=> c2,
p_row_template_condition2=> '',
p_row_template3=> c3,
p_row_template_condition3=> '',
p_row_template4=> c4,
p_row_template_condition4=> '',
p_row_template_before_rows=>''||chr(10)||
'',
p_row_template_after_rows =>''||chr(10)||
' | '||chr(10)||
' #EXTERNAL_LINK##CSV_LINK#'||chr(10)||
' '||chr(10)||
' | '||chr(10)||
' ',
p_row_template_table_attr =>'',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'',
p_row_template_display_cond1=>'0',
p_row_template_display_cond2=>'0',
p_row_template_display_cond3=>'0',
p_row_template_display_cond4=>'0',
p_row_style_mouse_over=>'#EEEECC',
p_row_style_checked=>'#EEEECC',
p_theme_id => 3,
p_theme_class_id => 4,
p_translate_this_template => 'N',
p_row_template_comment=> '');
end;
null;
end;
/
begin
begin
wwv_flow_api.create_row_template_patch (
p_id => 1511997528380044811 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'',
p_row_template_after_last =>' ');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/standard_report_ppr
prompt ......report template 1511997630311044811
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'#COLUMN_VALUE# | ';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 1511997630311044811 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'Standard Report (PPR)',
p_row_template1=> c1,
p_row_template_condition1=> '',
p_row_template2=> c2,
p_row_template_condition2=> '',
p_row_template3=> c3,
p_row_template_condition3=> '',
p_row_template4=> c4,
p_row_template_condition4=> '',
p_row_template_before_rows=>'',
p_row_template_after_rows =>' | '||chr(10)||
''||chr(10)||
' | #EXTERNAL_LINK##CSV_LINK# | '||chr(10)||
' | '||chr(10)||
' '||chr(10)||
'
'||chr(10)||
''||chr(10)||
''||chr(10)||
''||chr(10)||
'  ',
p_previous_page_template=>' ',
p_next_set_template=>'',
p_previous_set_template=>'',
p_row_style_mouse_over=>'#EEEECC',
p_row_style_checked=>'#EEEECC',
p_theme_id => 3,
p_theme_class_id => 7,
p_translate_this_template => 'N',
p_row_template_comment=> '');
end;
null;
end;
/
begin
begin
wwv_flow_api.create_row_template_patch (
p_id => 1511997630311044811 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'',
p_row_template_after_last =>' ');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/standard_report_with_alt_row_colors
prompt ......report template 1511997706258044811
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'#COLUMN_VALUE# | ';
c2:=c2||'#COLUMN_VALUE# | ';
c3:=c3||'#COLUMN_VALUE# | ';
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 1511997706258044811 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'Standard Report (with alt row colors)',
p_row_template1=> c1,
p_row_template_condition1=> '',
p_row_template2=> c2,
p_row_template_condition2=> '',
p_row_template3=> c3,
p_row_template_condition3=> '',
p_row_template4=> c4,
p_row_template_condition4=> '',
p_row_template_before_rows=>''||chr(10)||
'',
p_row_template_after_rows =>''||chr(10)||
' | '||chr(10)||
' #EXTERNAL_LINK##CSV_LINK#'||chr(10)||
' '||chr(10)||
' | '||chr(10)||
' '||chr(10)||
' ',
p_row_template_table_attr =>'OMIT',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'',
p_row_template_display_cond1=>'EVEN_ROW_NUMBERS',
p_row_template_display_cond2=>'ODD_ROW_NUMBERS',
p_row_template_display_cond3=>'0',
p_row_template_display_cond4=>'EVEN_ROW_NUMBERS',
p_theme_id => 3,
p_theme_class_id => 5,
p_translate_this_template => 'N',
p_row_template_comment=> '');
end;
null;
end;
/
begin
begin
wwv_flow_api.create_row_template_patch (
p_id => 1511997706258044811 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'',
p_row_template_after_last =>'');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/value_attribute_pairs
prompt ......report template 1511997815114044812
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||' | #COLUMN_VALUE# | '||chr(10)||
'';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 1511997815114044812 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'Value Attribute Pairs',
p_row_template1=> c1,
p_row_template_condition1=> '',
p_row_template2=> c2,
p_row_template_condition2=> '',
p_row_template3=> c3,
p_row_template_condition3=> '',
p_row_template4=> c4,
p_row_template_condition4=> '',
p_row_template_before_rows=>''||chr(10)||
''||chr(10)||
'#TOP_PAGINATION#'||chr(10)||
'',
p_row_template_after_rows =>' #EXTERNAL_LINK# | #PAGINATION# ',
p_row_template_table_attr =>'',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'',
p_row_template_display_cond1=>'0',
p_row_template_display_cond2=>'0',
p_row_template_display_cond3=>'0',
p_row_template_display_cond4=>'0',
p_theme_id => 3,
p_theme_class_id => 6,
p_translate_this_template => 'N',
p_row_template_comment=> '');
end;
null;
end;
/
begin
begin
wwv_flow_api.create_row_template_patch (
p_id => 1511997815114044812 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'OMIT',
p_row_template_after_last =>'
| '||chr(10)||
'');
exception when others then null;
end;
null;
end;
/
prompt ...label templates
--
--application/shared_components/user_interface/templates/label/no_label
prompt ......label template 1511997932544044812
begin
begin
wwv_flow_api.create_field_template (
p_id=> 1511997932544044812 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'No Label',
p_template_body1=>'',
p_template_body2=>'',
p_on_error_before_label=>'',
p_on_error_after_label=>'',
p_theme_id => 3,
p_theme_class_id => 13,
p_translate_this_template=> 'N',
p_template_comment=> '');
end;
null;
end;
/
--application/shared_components/user_interface/templates/label/optional
prompt ......label template 1511998005210044815
begin
begin
wwv_flow_api.create_field_template (
p_id=> 1511998005210044815 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'Optional',
p_template_body1=>'',
p_on_error_before_label=>'',
p_on_error_after_label=>'',
p_theme_id => 3,
p_theme_class_id => 3,
p_translate_this_template=> 'N',
p_template_comment=> '');
end;
null;
end;
/
--application/shared_components/user_interface/templates/label/optional_label_with_help
prompt ......label template 1511998115743044815
begin
begin
wwv_flow_api.create_field_template (
p_id=> 1511998115743044815 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'Optional Label with Help',
p_template_body1=>'',
p_template_body2=>'',
p_on_error_before_label=>'',
p_on_error_after_label=>'',
p_theme_id => 3,
p_theme_class_id => 1,
p_translate_this_template=> 'N',
p_template_comment=> '');
end;
null;
end;
/
--application/shared_components/user_interface/templates/label/required
prompt ......label template 1511998220992044815
begin
begin
wwv_flow_api.create_field_template (
p_id=> 1511998220992044815 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'Required',
p_template_body1=>'',
p_on_error_before_label=>'',
p_on_error_after_label=>'',
p_theme_id => 3,
p_theme_class_id => 4,
p_translate_this_template=> 'N',
p_template_comment=> '');
end;
null;
end;
/
--application/shared_components/user_interface/templates/label/required_label_with_help
prompt ......label template 1511998317527044815
begin
begin
wwv_flow_api.create_field_template (
p_id=> 1511998317527044815 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'Required Label with Help',
p_template_body1=>'',
p_on_error_before_label=>'',
p_on_error_after_label=>'',
p_theme_id => 3,
p_theme_class_id => 2,
p_translate_this_template=> 'N',
p_template_comment=> '');
end;
null;
end;
/
prompt ...breadcrumb templates
--
--application/shared_components/user_interface/templates/breadcrumb/breadcrumbs
prompt ......template 1511998432506044815
begin
begin
wwv_flow_api.create_menu_template (
p_id=> 1511998432506044815 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=>'Breadcrumbs',
p_before_first=>'',
p_current_page_option=>'#NAME#',
p_non_current_page_option=>'#NAME#',
p_menu_link_attributes=>'',
p_between_levels=>' > ',
p_after_last=>'',
p_max_levels=>12,
p_start_with_node=>'PARENT_TO_LEAF',
p_theme_id => 3,
p_theme_class_id => 1,
p_translate_this_template => 'N',
p_template_comments=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/breadcrumb/hierarchical_menu
prompt ......template 1511998504056044818
begin
begin
wwv_flow_api.create_menu_template (
p_id=> 1511998504056044818 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=>'Hierarchical Menu',
p_before_first=>'',
p_max_levels=>11,
p_start_with_node=>'CHILD_MENU',
p_theme_id => 3,
p_theme_class_id => 2,
p_translate_this_template => 'N',
p_template_comments=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/popuplov
prompt ...popup list of values templates
--
prompt ......template 1511999226708044824
begin
begin
wwv_flow_api.create_popup_lov_template (
p_id=> 1511999226708044824 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_popup_icon=>'#IMAGE_PREFIX#list_gray.gif',
p_popup_icon_attr=>'width="13" height="13" alt="Popup Lov"',
p_popup_icon2=>'',
p_popup_icon_attr2=>'',
p_page_name=>'Popup LOV',
p_page_title=>'Search Dialog',
p_page_html_head=>''||chr(10)||
'',
p_page_body_attr=>'onload="first_field()" style="margin:0;"',
p_before_field_text=>'',
p_scrollbars=>'1',
p_resizable=>'1',
p_width =>'400',
p_height=>'450',
p_result_row_x_of_y=>'
Row(s) #FIRST_ROW# - #LAST_ROW# ',
p_result_rows_per_pg=>500,
p_before_result_set=>'',
p_theme_id => 3,
p_theme_class_id => 1,
p_translate_this_template => 'N',
p_after_result_set =>' ');
end;
null;
end;
/
prompt ...calendar templates
--
--application/shared_components/user_interface/templates/calendar/calendar
prompt ......template 1511998626552044818
begin
begin
wwv_flow_api.create_calendar_template(
p_id=> 1511998626552044818 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_cal_template_name=>'Calendar',
p_translate_this_template=> 'N',
p_day_of_week_format=> '#IDAY# | ',
p_month_title_format=> ' '||chr(10)||
' '||chr(10)||
' | #IMONTH# #YYYY# | '||chr(10)||
' '||chr(10)||
' '||chr(10)||
' ',
p_month_open_format=> '',
p_month_close_format=> ' | '||chr(10)||
' '||chr(10)||
' '||chr(10)||
'',
p_day_title_format=> '#DD# ',
p_day_open_format=> '',
p_day_close_format=> ' | ',
p_today_open_format=> '',
p_weekend_title_format=> ' #DD# ',
p_weekend_open_format => ' | ',
p_weekend_close_format => ' | ',
p_nonday_title_format => '#DD# ',
p_nonday_open_format => '',
p_nonday_close_format => ' | ',
p_week_title_format => '',
p_week_open_format => '',
p_week_close_format => ' ',
p_daily_title_format => '',
p_daily_open_format => '',
p_daily_close_format => ' ',
p_weekly_title_format => ''||chr(10)||
''||chr(10)||
'| #WTITLE# | '||chr(10)||
' '||chr(10)||
''||chr(10)||
'| ',
p_weekly_day_of_week_format => ' | #IDAY#
#MM#/#DD# | ',
p_weekly_month_open_format => '',
p_weekly_month_close_format => ' ',
p_weekly_day_title_format => '',
p_weekly_day_open_format => '',
p_weekly_day_close_format => '
| ',
p_weekly_today_open_format => '',
p_weekly_weekend_title_format => '',
p_weekly_weekend_open_format => ' | ',
p_weekly_weekend_close_format => '
| ',
p_weekly_time_open_format => '',
p_weekly_time_close_format => '
| ',
p_weekly_time_title_format => '#TIME#',
p_weekly_hour_open_format => '',
p_weekly_hour_close_format => ' ',
p_daily_day_of_week_format => '#IDAY# #DD#/#MM# | ',
p_daily_month_title_format => ' | #IMONTH# #DD#, #YYYY# | '||chr(10)||
'',
p_daily_month_open_format => '',
p_daily_month_close_format => ' | ',
p_daily_day_title_format => '',
p_daily_day_open_format => '',
p_daily_day_close_format => '
| ',
p_daily_today_open_format => '',
p_daily_time_open_format => ' | ',
p_daily_time_close_format => '
| ',
p_daily_time_title_format => '#TIME#',
p_daily_hour_open_format => '',
p_daily_hour_close_format => ' ',
p_theme_id => 3,
p_theme_class_id => 1,
p_reference_id=> null);
end;
null;
end;
/
--application/shared_components/user_interface/templates/calendar/calendar_alternative_1
prompt ......template 1511998815611044824
begin
begin
wwv_flow_api.create_calendar_template(
p_id=> 1511998815611044824 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_cal_template_name=>'Calendar, Alternative 1',
p_translate_this_template=> 'N',
p_day_of_week_format=> '#IDAY# | ',
p_month_title_format=> ' '||chr(10)||
' '||chr(10)||
' | #IMONTH# #YYYY# | '||chr(10)||
' '||chr(10)||
' '||chr(10)||
' ',
p_month_open_format=> '',
p_month_close_format=> ' | '||chr(10)||
' '||chr(10)||
' '||chr(10)||
'',
p_day_title_format=> '#DD# ',
p_day_open_format=> '',
p_day_close_format=> ' | ',
p_today_open_format=> '',
p_weekend_title_format=> ' #DD# ',
p_weekend_open_format => ' | ',
p_weekend_close_format => ' | ',
p_nonday_title_format => '#DD# ',
p_nonday_open_format => '',
p_nonday_close_format => ' | ',
p_week_title_format => '',
p_week_open_format => '',
p_week_close_format => ' ',
p_daily_title_format => '',
p_daily_open_format => '',
p_daily_close_format => '',
p_weekly_title_format => ''||chr(10)||
''||chr(10)||
'| #WTITLE# | '||chr(10)||
' '||chr(10)||
''||chr(10)||
'| ',
p_weekly_day_of_week_format => ' | #IDAY#
#MM#/#DD# | ',
p_weekly_month_open_format => '',
p_weekly_month_close_format => ' ',
p_weekly_day_title_format => '',
p_weekly_day_open_format => '',
p_weekly_day_close_format => '
| ',
p_weekly_today_open_format => '',
p_weekly_weekend_title_format => '',
p_weekly_weekend_open_format => ' | ',
p_weekly_weekend_close_format => '
| ',
p_weekly_time_open_format => '',
p_weekly_time_close_format => '
| ',
p_weekly_time_title_format => '#TIME#',
p_weekly_hour_open_format => '',
p_weekly_hour_close_format => ' ',
p_daily_day_of_week_format => '#IDAY# #DD#/#MM# | ',
p_daily_month_title_format => ' | #IMONTH# #DD#, #YYYY# | '||chr(10)||
'',
p_daily_month_open_format => '',
p_daily_month_close_format => ' | ',
p_daily_day_title_format => '',
p_daily_day_open_format => '',
p_daily_day_close_format => '
| ',
p_daily_today_open_format => '',
p_daily_time_open_format => ' | ',
p_daily_time_close_format => '
| ',
p_daily_time_title_format => '#TIME#',
p_daily_hour_open_format => '',
p_daily_hour_close_format => ' ',
p_theme_id => 3,
p_theme_class_id => 2,
p_reference_id=> null);
end;
null;
end;
/
--application/shared_components/user_interface/templates/calendar/small_calendar
prompt ......template 1511999024659044824
begin
begin
wwv_flow_api.create_calendar_template(
p_id=> 1511999024659044824 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_cal_template_name=>'Small Calendar',
p_translate_this_template=> 'N',
p_day_of_week_format=> '',
p_month_title_format=> ' '||chr(10)||
' '||chr(10)||
' | #IMONTH# #YYYY# | '||chr(10)||
' '||chr(10)||
' '||chr(10)||
' ',
p_month_open_format=> '',
p_month_close_format=> ' | '||chr(10)||
' '||chr(10)||
' '||chr(10)||
'',
p_day_title_format=> '#DD# ',
p_day_open_format=> '',
p_day_close_format=> ' | ',
p_today_open_format=> '',
p_weekend_title_format=> ' #DD# ',
p_weekend_open_format => ' | ',
p_weekend_close_format => ' | ',
p_nonday_title_format => '#DD# ',
p_nonday_open_format => '',
p_nonday_close_format => '',
p_week_title_format => '',
p_week_open_format => ' | ',
p_week_close_format => ' ',
p_daily_title_format => '',
p_daily_open_format => '',
p_daily_close_format => ' ',
p_weekly_title_format => ''||chr(10)||
''||chr(10)||
'| #WTITLE# | '||chr(10)||
' '||chr(10)||
''||chr(10)||
'| ',
p_weekly_day_of_week_format => ' | #IDAY#
#MM#/#DD# | ',
p_weekly_month_open_format => '',
p_weekly_month_close_format => ' ',
p_weekly_day_title_format => '',
p_weekly_day_open_format => '',
p_weekly_day_close_format => '
| ',
p_weekly_today_open_format => '',
p_weekly_weekend_title_format => '',
p_weekly_weekend_open_format => ' | ',
p_weekly_weekend_close_format => '
| ',
p_weekly_time_open_format => '',
p_weekly_time_close_format => '
| ',
p_weekly_time_title_format => '#TIME#',
p_weekly_hour_open_format => '',
p_weekly_hour_close_format => ' ',
p_daily_day_of_week_format => '#IDAY# #DD#/#MM# | ',
p_daily_month_title_format => ' | #IMONTH# #DD#, #YYYY# | '||chr(10)||
'',
p_daily_month_open_format => '',
p_daily_month_close_format => ' | ',
p_daily_day_title_format => '',
p_daily_day_open_format => '',
p_daily_day_close_format => '
| ',
p_daily_today_open_format => '',
p_daily_time_open_format => ' | ',
p_daily_time_close_format => '
| ',
p_daily_time_title_format => '#TIME#',
p_daily_hour_open_format => '',
p_daily_hour_close_format => ' ',
p_theme_id => 3,
p_theme_class_id => 3,
p_reference_id=> null);
end;
null;
end;
/
prompt ...application themes
--
--application/shared_components/user_interface/themes/business
prompt ......theme 1511999327982044827
begin
wwv_flow_api.create_theme (
p_id =>1511999327982044827 + wwv_flow_api.g_id_offset,
p_flow_id =>wwv_flow.g_flow_id,
p_theme_id => 3,
p_theme_name=>'Business',
p_default_page_template=>1511992211125044770 + wwv_flow_api.g_id_offset,
p_error_template=>1511991929450044764 + wwv_flow_api.g_id_offset,
p_printer_friendly_template=>1511992517313044773 + wwv_flow_api.g_id_offset,
p_breadcrumb_display_point=>'REGION_POSITION_01',
p_sidebar_display_point=>'REGION_POSITION_02',
p_login_template=>1511991929450044764 + wwv_flow_api.g_id_offset,
p_default_button_template=>1511992821725044776 + wwv_flow_api.g_id_offset,
p_default_region_template=>1511994710487044785 + wwv_flow_api.g_id_offset,
p_default_chart_template =>1511993712532044784 + wwv_flow_api.g_id_offset,
p_default_form_template =>1511993822422044784 + wwv_flow_api.g_id_offset,
p_default_reportr_template =>1511994710487044785 + wwv_flow_api.g_id_offset,
p_default_tabform_template=>1511994710487044785 + wwv_flow_api.g_id_offset,
p_default_wizard_template=>1511995424993044786 + wwv_flow_api.g_id_offset,
p_default_menur_template=>1511993415805044782 + wwv_flow_api.g_id_offset,
p_default_listr_template=>1511994710487044785 + wwv_flow_api.g_id_offset,
p_default_report_template =>1511997528380044811 + wwv_flow_api.g_id_offset,
p_default_label_template=>1511998115743044815 + wwv_flow_api.g_id_offset,
p_default_menu_template=>1511998432506044815 + wwv_flow_api.g_id_offset,
p_default_calendar_template=>1511998626552044818 + wwv_flow_api.g_id_offset,
p_default_list_template=>1511996929208044807 + wwv_flow_api.g_id_offset,
p_default_option_label=>1511998115743044815 + wwv_flow_api.g_id_offset,
p_default_required_label=>1511998317527044815 + wwv_flow_api.g_id_offset);
end;
/
prompt ...build options used by application 62577
--
begin
null;
end;
/
--application/shared_components/globalization/messages
prompt ...messages used by application: 62577
--
--application/shared_components/globalization/dyntranslations
prompt ...dynamic translations used by application: 62577
--
--application/shared_components/globalization/language
prompt ...Language Maps for Application 62577
--
begin
null;
end;
/
prompt ...Shortcuts
--
prompt ...web services (9iR2 or better)
--
prompt ...shared queries
--
prompt ...report layouts
--
prompt ...authentication schemes
--
--application/shared_components/security/authentication/html_db
prompt ......scheme 1511999408655044828
begin
declare
s1 varchar2(32767) := null;
s2 varchar2(32767) := null;
s3 varchar2(32767) := null;
s4 varchar2(32767) := null;
s5 varchar2(32767) := null;
begin
s1 := null;
s2 := null;
s3 := null;
s4:=s4||'-BUILTIN-';
s5 := null;
wwv_flow_api.create_auth_setup (
p_id=> 1511999408655044828 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> 'HTML DB',
p_description=>'Use internal Application Express account credentials and login page in this application.',
p_page_sentry_function=> s1,
p_sess_verify_function=> s2,
p_pre_auth_process=> s3,
p_auth_function=> s4,
p_post_auth_process=> s5,
p_invalid_session_page=>'101',
p_invalid_session_url=>'',
p_cookie_name=>'',
p_cookie_path=>'',
p_cookie_domain=>'',
p_use_secure_cookie_yn=>'',
p_ldap_host=>'',
p_ldap_port=>'',
p_ldap_string=>'',
p_attribute_01=>'',
p_attribute_02=>'wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:1',
p_attribute_03=>'',
p_attribute_04=>'',
p_attribute_05=>'',
p_attribute_06=>'',
p_attribute_07=>'',
p_attribute_08=>'',
p_required_patch=>'');
end;
null;
end;
/
--application/shared_components/security/authentication/database
prompt ......scheme 1511999531333044831
begin
declare
s1 varchar2(32767) := null;
s2 varchar2(32767) := null;
s3 varchar2(32767) := null;
s4 varchar2(32767) := null;
s5 varchar2(32767) := null;
begin
s1:=s1||'-DATABASE-';
s2 := null;
s3 := null;
s4 := null;
s5 := null;
wwv_flow_api.create_auth_setup (
p_id=> 1511999531333044831 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> 'DATABASE',
p_description=>'Use database authentication (user identified by DAD).',
p_page_sentry_function=> s1,
p_sess_verify_function=> s2,
p_pre_auth_process=> s3,
p_auth_function=> s4,
p_post_auth_process=> s5,
p_invalid_session_page=>'',
p_invalid_session_url=>'',
p_cookie_name=>'',
p_cookie_path=>'',
p_cookie_domain=>'',
p_use_secure_cookie_yn=>'',
p_ldap_host=>'',
p_ldap_port=>'',
p_ldap_string=>'',
p_attribute_01=>'',
p_attribute_02=>'',
p_attribute_03=>'',
p_attribute_04=>'',
p_attribute_05=>'',
p_attribute_06=>'',
p_attribute_07=>'',
p_attribute_08=>'',
p_required_patch=>'');
end;
null;
end;
/
--application/shared_components/security/authentication/database_account
prompt ......scheme 1511999604286044831
begin
declare
s1 varchar2(32767) := null;
s2 varchar2(32767) := null;
s3 varchar2(32767) := null;
s4 varchar2(32767) := null;
s5 varchar2(32767) := null;
begin
s1 := null;
s2 := null;
s3 := null;
s4:=s4||'return false; end;--';
s5 := null;
wwv_flow_api.create_auth_setup (
p_id=> 1511999604286044831 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> 'DATABASE ACCOUNT',
p_description=>'Use database account credentials.',
p_page_sentry_function=> s1,
p_sess_verify_function=> s2,
p_pre_auth_process=> s3,
p_auth_function=> s4,
p_post_auth_process=> s5,
p_invalid_session_page=>'101',
p_invalid_session_url=>'',
p_cookie_name=>'',
p_cookie_path=>'',
p_cookie_domain=>'',
p_use_secure_cookie_yn=>'',
p_ldap_host=>'',
p_ldap_port=>'',
p_ldap_string=>'',
p_attribute_01=>'',
p_attribute_02=>'wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:1',
p_attribute_03=>'',
p_attribute_04=>'',
p_attribute_05=>'',
p_attribute_06=>'',
p_attribute_07=>'',
p_attribute_08=>'',
p_required_patch=>'');
end;
null;
end;
/
--application/deployment/definition
prompt ...application deployment
--
begin
declare
s varchar2(32767) := null;
l_clob clob;
begin
s := null;
wwv_flow_api.create_install (
p_id => 1512231301302650570 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_include_in_export_yn => 'Y',
p_deinstall_message=> '');
end;
end;
/
--application/deployment/install
prompt ...application install scripts
--
begin
declare
s varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
s:=s||'/* '||chr(10)||
' Copyright 2009 apps2fusion.com '||chr(10)||
' Kishore Ryali'||chr(10)||
' Oracle Application Express Tutorials '||chr(10)||
'*/'||chr(10)||
''||chr(10)||
'/* Table Script */'||chr(10)||
'CREATE TABLE xx_person_details'||chr(10)||
'('||chr(10)||
' person_id NUMBER NOT NULL'||chr(10)||
',first_name VARCHAR2(50)'||chr(10)||
',last_name VARCHAR2(50)'||chr(10)||
',email VARCHAR2(100)'||chr(10)||
',student_flag VARCHAR2(1)'||chr(10)||
',name_of_university VARCHAR2(100)'||chr(10)||
',last_update_date DATE'||chr(10)||
',last_update_login INTEGER'||chr(10)||
',';
s:=s||'last_updated_by INTEGER'||chr(10)||
',creation_date DATE'||chr(10)||
',created_by INTEGER'||chr(10)||
');'||chr(10)||
''||chr(10)||
'/* Sequence Script */'||chr(10)||
'CREATE SEQUENCE "XX_PERSON_ID_S"'||chr(10)||
'MINVALUE 1 MAXVALUE 999999999999999999999999999'||chr(10)||
'INCREMENT BY 1 START WITH 1'||chr(10)||
'CACHE 20 NOORDER NOCYCLE;'||chr(10)||
''||chr(10)||
'/* API to insert person record */'||chr(10)||
'CREATE OR REPLACE PROCEDURE xx_insert_person_prc ('||chr(10)||
' p_person_rec IN OUT xx_person_details%ROWTYPE'||chr(10)||
')'||chr(10)||
'IS'||chr(10)||
'BEGIN'||chr(10)||
' SELECT xx_person_id';
s:=s||'_s.NEXTVAL'||chr(10)||
' INTO p_person_rec.person_id'||chr(10)||
' FROM DUAL;'||chr(10)||
' p_person_rec.last_update_date := SYSDATE;'||chr(10)||
' p_person_rec.creation_date := SYSDATE;'||chr(10)||
' p_person_rec.last_update_login := -1;'||chr(10)||
' p_person_rec.last_updated_by := 71690;'||chr(10)||
' p_person_rec.created_by := 71690;'||chr(10)||
' INSERT INTO xx_person_details'||chr(10)||
' VALUES p_person_rec;'||chr(10)||
'END xx_insert_person_prc;'||chr(10)||
'/'||chr(10)||
''||chr(10)||
'/* Script to populate sample data */'||chr(10)||
'DECLA';
s:=s||'RE'||chr(10)||
' l_person_rec xx_person_details%ROWTYPE;'||chr(10)||
' l_person_empty_rec xx_person_details%ROWTYPE;'||chr(10)||
'BEGIN'||chr(10)||
' for i in 1..40 loop'||chr(10)||
' l_person_rec := l_person_empty_rec;'||chr(10)||
' l_person_rec.first_name := ''FN'' || i;'||chr(10)||
' l_person_rec.last_name := ''LN'' || i ;'||chr(10)||
' l_person_rec.email := ''f.l.'' || i || ''@gmail.com'';'||chr(10)||
' l_person_rec.student_flag := case mod(i,2) when 0 then ''N'' when 1 th';
s:=s||'en ''Y'' end;'||chr(10)||
' xx_insert_person_prc (l_person_rec);'||chr(10)||
' end loop;'||chr(10)||
' COMMIT;'||chr(10)||
'END;'||chr(10)||
'/'||chr(10)||
'';
wwv_flow_api.create_install_script(
p_id => 1515194908976756958 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_install_id=> 1512231301302650570 + wwv_flow_api.g_id_offset,
p_name => 'apex_tut01_db_scripts.sql',
p_sequence=> 10,
p_script_type=> 'INSTALL',
p_script_clob=> s);
end;
end;
/
--application/deployment/checks
prompt ...application deployment checks
--
begin
null;
end;
/
--application/deployment/buildoptions
prompt ...application deployment build options
--
begin
null;
end;
/
--application/end_environment
commit;
commit;
begin
execute immediate 'alter session set nls_numeric_characters='''||wwv_flow_api.g_nls_numeric_chars||'''';
end;
/
set verify on
set feedback on
prompt ...done
| |
#MESSAGE#
;)
