andy/mip
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
Files
master
mip/Screens/f155_theme_101.sql

3922 lines
131 KiB
SQL
Raw Permalink Blame History

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;
/
-- AAAA PPPPP EEEEEE XX XX
-- AA AA PP PP EE XX XX
-- AA AA PP PP EE XX XX
-- AAAAAAAAAA PPPPP EEEE XXXX
-- AA AA PP EE XX XX
-- AA AA PP EE XX XX
-- AA AA PP EEEEEE XX XX
prompt Set Credentials...
begin
-- Assumes you are running the script connected to SQL*Plus as the Oracle user FLOWS_030100 or as the owner (parsing schema) of the application.
wwv_flow_api.set_security_group_id(p_security_group_id=>11019802792885519);
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=>'2007.01.08');
end;
/
prompt Set Application ID...
begin
-- SET APPLICATION ID
wwv_flow.g_flow_id := 155;
wwv_flow_api.g_id_offset := 0;
null;
end;
/
--application/themes/101
begin
wwv_flow.g_flow_theme_id := 101;
null;
end;
/
--
prompt ...theme : 101
--
prompt ...remove existing theme ...
begin
wwv_flow_api.delete_theme(p_flow_id=> wwv_flow.g_flow_id , p_theme_id=>wwv_flow.g_flow_theme_id ,p_import=>'Y');
null;
end;
/
prompt ...page templates for application: 155
--
--application/shared_components/user_interface/templates/page/no_tabs
prompt ......Page template 71114788560453355
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
c1:=c1||'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"'||chr(10)||
'"http://www.w3.org/TR/html4/loose.dtd">'||chr(10)||
''||chr(10)||
'<html lang="&BROWSER_LANGUAGE."'||chr(10)||
' xmlns:htmldb="http://htmldb.oracle.com">'||chr(10)||
'<head>'||chr(10)||
' <title>#TITLE#</title>'||chr(10)||
' <link rel="stylesheet"'||chr(10)||
' href="#IMAGE_PREFIX#ng_common.css"'||chr(10)||
' type="text/css">'||chr(10)||
'</head>'||chr(10)||
''||chr(10)||
'<body>'||chr(10)||
' #HEAD# #FORM_OPEN#'||chr(10)||
''||chr(10)||
' <div id="rowHd">'||chr(10)||
' <div id="logo"';
c1:=c1||''||chr(10)||
' class="hskpcol1">'||chr(10)||
' <a href="http://www.nationalgrid.com/"><img src='||chr(10)||
' "#IMAGE_PREFIX#ng_logo_group_medium.gif"'||chr(10)||
' alt="National Grid homepage"'||chr(10)||
' width="200"'||chr(10)||
' height="43"></a>'||chr(10)||
' </div>'||chr(10)||
''||chr(10)||
' <div id="navHousekeep"'||chr(10)||
' class="hskpcol2">'||chr(10)||
' <div class="margin5">'||chr(10)||
' <a href="http://www.nationalgrid.com/uk/Metering/"'||chr(10)||
' c';
c1:=c1||'lass="hskpnav"'||chr(10)||
' title='||chr(10)||
' "National Grid Metering homepage"'||chr(10)||
' accesskey="1">Home</a> | <a href="&LOGOUT_URL."'||chr(10)||
' class="hskpnav"'||chr(10)||
' title="Log out of the system"'||chr(10)||
' accesskey="2">Logout</a> | '||chr(10)||
' <!--a href="/group/help" class="hskpnav">Help</a>&nbsp;|&nbsp;--><span>'||chr(10)||
' You are logged in as:&APP_USER.</span>'||chr(10)||
' ';
c1:=c1||' </div>'||chr(10)||
' </div>'||chr(10)||
' </div>'||chr(10)||
''||chr(10)||
' <div id="rowSiteNav">'||chr(10)||
' </div>';
c2:=c2||'<div id="rowFooter"><!-- bottom strip of info -->'||chr(10)||
' '||chr(10)||
' <div class="clear"></div>'||chr(10)||
' <div class="access"><hr></div>'||chr(10)||
''||chr(10)||
' '||chr(10)||
' <div class="hskpcol1"><!-- copyright box -->'||chr(10)||
' <div id="copyright">Copyright &copy; <!--2006--><span id="Pagefooter_lblYear">2008</span> National Grid, Copyright &copy; 2008 Advantica Ltd.</div>'||chr(10)||
' </div>'||chr(10)||
' '||chr(10)||
' <div class="hskpcol2">'||chr(10)||
' <div id="navFooter">'||chr(10)||
' ';
c2:=c2||' <a href="&SITEMAP_URL.">Site map</a> | '||chr(10)||
' <a href="&T_AND_C_URL." target="blank">Terms &amp; conditions</a>'||chr(10)||
' | <a href="&PRIVACY_URL.">Privacy policy</a>'||chr(10)||
' </div>'||chr(10)||
' </div>'||chr(10)||
' '||chr(10)||
'</div>'||chr(10)||
'#REGION_POSITION_05#'||chr(10)||
'#FORM_CLOSE# '||chr(10)||
'<!-- #APP_VERSION# -->'||chr(10)||
'</body>'||chr(10)||
'</html>';
c3:=c3||' <div id="UKSubNav"'||chr(10)||
' class="reg">'||chr(10)||
' #REGION_POSITION_01#'||chr(10)||
' </div>'||chr(10)||
''||chr(10)||
' <div id="rowContent">'||chr(10)||
' <div id="colLeft">'||chr(10)||
' <div id="navTier"'||chr(10)||
' class="w180">'||chr(10)||
' #REGION_POSITION_08#'||chr(10)||
' </div>'||chr(10)||
' </div>'||chr(10)||
''||chr(10)||
' <div id="colMid">'||chr(10)||
' #BOX_BODY# #REGION_POSITION_02# #REGION_POSITION_03#'||chr(10)||
' #REGION_POSITION_04#'||chr(10)||
' </div>'||chr(10)||
''||chr(10)||
' <div id="colRight">'||chr(10)||
' <h1 c';
c3:=c3||'lass="podTitle"><img src='||chr(10)||
' "#IMAGE_PREFIX#ng_exclaim.gif"'||chr(10)||
' alt=""'||chr(10)||
' width="23"'||chr(10)||
' height="23">Important Messages</h1>'||chr(10)||
''||chr(10)||
' <div class="t4messages">'||chr(10)||
' #GLOBAL_NOTIFICATION##SUCCESS_MESSAGE##NOTIFICATION_MESSAGE#'||chr(10)||
' </div>'||chr(10)||
' </div>'||chr(10)||
' </div>';
wwv_flow_api.create_template(
p_id=> 71114788560453355 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> 'No Tabs',
p_body_title=> '',
p_header_template=> c1,
p_box=> c3,
p_footer_template=> c2,
p_success_message=> '<div class="t4success">#SUCCESS_MESSAGE#</div>',
p_current_tab=> '',
p_current_tab_font_attr=> '',
p_non_current_tab=> '',
p_non_current_tab_font_attr => '',
p_top_current_tab=> '',
p_top_current_tab_font_attr => '',
p_top_non_curr_tab=> '',
p_top_non_curr_tab_font_attr=> '',
p_current_image_tab=> '',
p_non_current_image_tab=> '',
p_notification_message=> '<div class="t4notification">#MESSAGE#</div>',
p_navigation_bar=> '',
p_navbar_entry=> '<li><img src="#IMAGE_PREFIX#ng_black.gif" alt=""><a href="#LINK#">#TEXT#</a></li>',
p_app_tab_before_tabs=>'',
p_app_tab_current_tab=>'',
p_app_tab_non_current_tab=>'',
p_app_tab_after_tabs=>'',
p_region_table_cattributes=> ' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"',
p_sidebar_def_reg_pos => 'REGION_POSITION_02',
p_breadcrumb_def_reg_pos => 'REGION_POSITION_01',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 3,
p_template_comment => '');
end;
null;
end;
/
--application/shared_components/user_interface/templates/page/popup
prompt ......Page template 71115999890453357
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
c1:=c1||'<html lang="&BROWSER_LANGUAGE." xmlns:htmldb="http://htmldb.oracle.com">'||chr(10)||
'<head>'||chr(10)||
'<title>#TITLE#</title>'||chr(10)||
'<link rel="stylesheet" href="#IMAGE_PREFIX#themes/theme_4/theme_V3.css" type="text/css" />'||chr(10)||
'#HEAD#'||chr(10)||
'</head>'||chr(10)||
'<body #ONLOAD#>#FORM_OPEN#';
c2:=c2||'#FORM_CLOSE#</body>'||chr(10)||
'</html>';
c3:=c3||'<table summary="" cellpadding="0" width="100%" cellspacing="0" border="0">'||chr(10)||
'<tr>'||chr(10)||
'<td width="100%" valign="top"><div class="t4messages">#SUCCESS_MESSAGE##NOTIFICATION_MESSAGE#</div>#BOX_BODY##REGION_POSITION_01##REGION_POSITION_02##REGION_POSITION_04##REGION_POSITION_05##REGION_POSITION_06##REGION_POSITION_07##REGION_POSITION_08#</td>'||chr(10)||
'<td valign="top">#REGION_POSITION_03#<br /></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
wwv_flow_api.create_template(
p_id=> 71115999890453357 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> 'Popup',
p_body_title=> '',
p_header_template=> c1,
p_box=> c3,
p_footer_template=> c2,
p_success_message=> '<div class="t4success">#SUCCESS_MESSAGE#</div>',
p_current_tab=> '',
p_current_tab_font_attr=> '',
p_non_current_tab=> '',
p_non_current_tab_font_attr => '',
p_top_current_tab=> '',
p_top_current_tab_font_attr => '',
p_top_non_curr_tab=> '',
p_top_non_curr_tab_font_attr=> '',
p_current_image_tab=> '',
p_non_current_image_tab=> '',
p_notification_message=> '<div class="t4notification">#MESSAGE#</div>',
p_navigation_bar=> '<div class="t4NavigationBar">#BAR_BODY#</div>',
p_navbar_entry=> '<a href="#LINK#" class="t4NavigationBar">#TEXT#</a>',
p_app_tab_before_tabs=>'',
p_app_tab_current_tab=>'',
p_app_tab_non_current_tab=>'',
p_app_tab_after_tabs=>'',
p_region_table_cattributes=> ' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 4,
p_translate_this_template => 'N',
p_template_comment => '');
end;
null;
end;
/
--application/shared_components/user_interface/templates/page/printer_friendly
prompt ......Page template 71116307709453357
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
c1:=c1||'<html lang="&BROWSER_LANGUAGE." xmlns:htmldb="http://htmldb.oracle.com">'||chr(10)||
'<head>'||chr(10)||
'<title>#TITLE#</title>'||chr(10)||
'<link rel="stylesheet" href="#IMAGE_PREFIX#themes/theme_4/theme_V3.css" type="text/css" />'||chr(10)||
'#HEAD#'||chr(10)||
'</head>'||chr(10)||
'<body #ONLOAD#>#FORM_OPEN#';
c2:=c2||'#FORM_CLOSE#</body>'||chr(10)||
'</html>';
c3:=c3||'<table summary="" cellpadding="0" width="100%" cellspacing="0" border="0">'||chr(10)||
'<tr>'||chr(10)||
'<td valign="top">#LOGO##REGION_POSITION_06#</td>'||chr(10)||
'<td width="100%" valign="top">#REGION_POSITION_07#</td>'||chr(10)||
'<td valign="top">#REGION_POSITION_08#</td>'||chr(10)||
'</table>'||chr(10)||
'<table summary="" cellpadding="0" width="100%" cellspacing="0" border="0">'||chr(10)||
'<tr>'||chr(10)||
'<td width="100%" valign="top">'||chr(10)||
'<div style="border:1px solid black;">#SUCCESS_MESSAG';
c3:=c3||'E##NOTIFICATION_MESSAGE#</div>'||chr(10)||
'#BOX_BODY##REGION_POSITION_04#</td>'||chr(10)||
'<td valign="top">#REGION_POSITION_03#<br /></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>'||chr(10)||
'#REGION_POSITION_05#'||chr(10)||
''||chr(10)||
'';
wwv_flow_api.create_template(
p_id=> 71116307709453357 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> 'Printer Friendly',
p_body_title=> '',
p_header_template=> c1,
p_box=> c3,
p_footer_template=> c2,
p_success_message=> '<div class="t4success">#SUCCESS_MESSAGE#</div>',
p_current_tab=> '',
p_current_tab_font_attr=> '',
p_non_current_tab=> '',
p_non_current_tab_font_attr => '',
p_top_current_tab=> '',
p_top_current_tab_font_attr => '',
p_top_non_curr_tab=> '',
p_top_non_curr_tab_font_attr=> '',
p_current_image_tab=> '',
p_non_current_image_tab=> '',
p_notification_message=> '<div class="t4notification">#MESSAGE#</div>',
p_navigation_bar=> '<div class="t4NavigationBar">#BAR_BODY#</div>',
p_navbar_entry=> '<a href="#LINK#" class="t4NavigationBar">#TEXT#</a>',
p_app_tab_before_tabs=>'',
p_app_tab_current_tab=>'',
p_app_tab_non_current_tab=>'',
p_app_tab_after_tabs=>'',
p_region_table_cattributes=> ' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 5,
p_translate_this_template => 'N',
p_template_comment => '3');
end;
null;
end;
/
--application/shared_components/user_interface/templates/page/errorpage
prompt ......Page template 85292499999520701
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
c1:=c1||'<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml1-transitional.dtd">'||chr(10)||
'<html lang="&BROWSER_LANGUAGE." xmlns:htmldb="http://htmldb.oracle.com">'||chr(10)||
'<head>'||chr(10)||
'<title>#TITLE#</title>'||chr(10)||
'<link rel="stylesheet" href="#IMAGE_PREFIX#ng_common.css" type="text/css" />'||chr(10)||
'#HEAD#'||chr(10)||
'</head>'||chr(10)||
'<body #ONLOAD#>#FORM_OPEN#'||chr(10)||
'<div id="rowHd">'||chr(10)||
'<div id="logo" class="hskpcol';
c1:=c1||'1">'||chr(10)||
'<a href="http://www.nationalgrid.com/"><img src="#IMAGE_PREFIX#ng_logo_group_medium.gif" alt="National Grid homepage"/></a>'||chr(10)||
'</div>'||chr(10)||
'<div id="navHousekeep" class="hskpcol2">'||chr(10)||
'<div class="margin5">'||chr(10)||
'<a href="http://www.nationalgrid.com/uk/Metering/" class="hskpnav" title="National Grid Metering homepage" accesskey="1">Home</a>&nbsp;|&nbsp;<a href="&LOGOUT_URL." class="hskpnav" title="Log out o';
c1:=c1||'f the system" accesskey="2">Logout</a>&nbsp;|&nbsp;<!--a href="/group/help" class="hskpnav">Help</a>&nbsp;|&nbsp;--><span>You are logged in as:&APP_USER.</span>'||chr(10)||
'</div>'||chr(10)||
'</div>'||chr(10)||
'</div>'||chr(10)||
'<div id="rowSiteNav">'||chr(10)||
'</div>'||chr(10)||
''||chr(10)||
'<script type="text/javascript">'||chr(10)||
''||chr(10)||
'function MyErrorPage(p_err_item,p_err_process)'||chr(10)||
'{'||chr(10)||
''||chr(10)||
' var vElementList = null;'||chr(10)||
' var vElement = null;'||chr(10)||
' var vErrorStack = null;'||chr(10)||
' var vOraErr';
c1:=c1||'orStack = null;'||chr(10)||
' var vOraError = null;'||chr(10)||
' var vOraCode = null;'||chr(10)||
' var vAjaxRequest = null;'||chr(10)||
' var vAjaxResult = null;'||chr(10)||
' var vMyMsg = '''';'||chr(10)||
''||chr(10)||
'if (!document.getElementById)'||chr(10)||
' return;'||chr(10)||
''||chr(10)||
'if (!document.createElement)'||chr(10)||
' return;'||chr(10)||
''||chr(10)||
' vElementList = window.document.getElementsByTagName("div");'||chr(10)||
' for (i=0; i < vElementList.length; i++)'||chr(10)||
' {'||chr(10)||
' vElement = vElementList[i];'||chr(10)||
' '||chr(10)||
' if (vElement.classN';
c1:=c1||'ame == "ErrorPageMessage")'||chr(10)||
' {'||chr(10)||
' vErrorStack = (vErrorStack ==null?"":vErrorStack)+vElement.innerHTML;'||chr(10)||
' vOraErrorStack = vErrorStack.split("ORA-");'||chr(10)||
' if (vOraErrorStack.length > 1 ) {'||chr(10)||
' vElement.innerHTML = ''''; '||chr(10)||
' for(var j=1; j < vOraErrorStack.length; j++) {'||chr(10)||
' vOraError = vOraErrorStack[j];'||chr(10)||
' vAjaxRequest = new htmldb_Get(null,&APP_ID.,''APPLICATION_PROCESS=''+p_e';
c1:=c1||'rr_process,0);'||chr(10)||
' vAjaxRequest.add(p_err_item,vOraError);'||chr(10)||
' vAjaxResult = vAjaxRequest.get();'||chr(10)||
' if (vAjaxResult) {'||chr(10)||
' vMyMsg = vMyMsg + vAjaxResult;'||chr(10)||
' } else {'||chr(10)||
' vMyMsg = vMyMsg + vOraError.substring(0);'||chr(10)||
' }'||chr(10)||
' }'||chr(10)||
' }'||chr(10)||
'if (document.getElementById && document.createElement && vMyMsg.length > 0) {'||chr(10)||
' var divA = document.getElementById(''ErrorO';
c1:=c1||'utputDiv'');'||chr(10)||
' var oH = document.createElement(''h1'');'||chr(10)||
' oH.appendChild(document.createTextNode(''Validation failed because:''));'||chr(10)||
' var oP = document.createElement(''p'');'||chr(10)||
' oP.id = ''FriendlyError'';'||chr(10)||
' oP.appendChild(document.createTextNode(vMyMsg));'||chr(10)||
' // Insert the heading as the first child of the element'||chr(10)||
' divA.insertBefore(oP, divA.firstChild);'||chr(10)||
' divA.insertBefore(oH, divA.firstChild)';
c1:=c1||';'||chr(10)||
' }'||chr(10)||
' }'||chr(10)||
' }'||chr(10)||
'}'||chr(10)||
'</script>'||chr(10)||
''||chr(10)||
'<body onload="MyErrorPage(''ORA_ERR_CODE'',''getErrorMsg'')" #ONLOAD#>#FORM_OPEN#'||chr(10)||
''||chr(10)||
'';
c2:=c2||'<div id="rowFooter"><!-- bottom strip of info -->'||chr(10)||
' '||chr(10)||
' <div class="clear"></div>'||chr(10)||
' <div class="access"><hr></div>'||chr(10)||
''||chr(10)||
' '||chr(10)||
' <div class="hskpcol1"><!-- copyright box -->'||chr(10)||
' <div id="copyright">Copyright &copy; <!--2006--><span id="Pagefooter_lblYear">2008</span> National Grid</div>'||chr(10)||
' </div>'||chr(10)||
' '||chr(10)||
' <div class="hskpcol2">'||chr(10)||
' <div id="navFooter">'||chr(10)||
' <a href="&SITEMAP_URL.">Site map</a';
c2:=c2||'> | '||chr(10)||
' <a href="&T_AND_C_URL." target="blank">Terms &amp; conditions</a>'||chr(10)||
''||chr(10)||
' | <a href="&PRIVACY_URL.">Privacy policy</a>'||chr(10)||
' </div>'||chr(10)||
' </div>'||chr(10)||
' '||chr(10)||
'</div>'||chr(10)||
'#REGION_POSITION_05#'||chr(10)||
'#FORM_CLOSE# '||chr(10)||
'<!-- #APP_VERSION# -->'||chr(10)||
'</body>'||chr(10)||
'</html>';
c3:=c3||'<div id="UKSubNav" class="reg">'||chr(10)||
'#REGION_POSITION_01#'||chr(10)||
'</div>'||chr(10)||
'<div id="rowContent">'||chr(10)||
'<div id="colLeft">'||chr(10)||
'<div id="navTier" class="w180">#REGION_POSITION_08#</div>'||chr(10)||
'</div>'||chr(10)||
' <div id="colMid">'||chr(10)||
'<div id="ErrorOutputDiv">'||chr(10)||
'#BOX_BODY#'||chr(10)||
'</div>'||chr(10)||
'</div>'||chr(10)||
''||chr(10)||
'<div id="colRight">'||chr(10)||
'<h1 class="podTitle"><img src="#IMAGE_PREFIX#ng_exclaim.gif" alt=""/>Important Messages</h1>'||chr(10)||
'<div class="t4messages">#GLOBAL_NOT';
c3:=c3||'IFICATION##SUCCESS_MESSAGE##NOTIFICATION_MESSAGE#</div>'||chr(10)||
'</div>'||chr(10)||
'</div>'||chr(10)||
''||chr(10)||
'';
wwv_flow_api.create_template(
p_id=> 85292499999520701 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=> 'ErrorPage',
p_body_title=> '',
p_header_template=> c1,
p_box=> c3,
p_footer_template=> c2,
p_success_message=> '<div class="t4success">#SUCCESS_MESSAGE#</div>',
p_current_tab=> '',
p_current_tab_font_attr=> '',
p_non_current_tab=> '',
p_non_current_tab_font_attr => '',
p_top_current_tab=> '',
p_top_current_tab_font_attr => '',
p_top_non_curr_tab=> '',
p_top_non_curr_tab_font_attr=> '',
p_current_image_tab=> '',
p_non_current_image_tab=> '',
p_notification_message=> '<div class="t4notification">#MESSAGE#</div>',
p_navigation_bar=> '',
p_navbar_entry=> '<li><img src="/i/ng_black.gif" alt=""><a href="#LINK#">#TEXT#</a></li>',
p_app_tab_before_tabs=>'',
p_app_tab_current_tab=>'',
p_app_tab_non_current_tab=>'',
p_app_tab_after_tabs=>'',
p_region_table_cattributes=> ' summary="" cellpadding="0" border="0" cellspacing="0" width="100%"',
p_sidebar_def_reg_pos => 'REGION_POSITION_02',
p_breadcrumb_def_reg_pos => 'REGION_POSITION_01',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 3,
p_error_page_template => '<table summary=""><tr><td><img src="/i/error.gif" border="0" /></td>'||chr(10)||
'</tr>'||chr(10)||
'<b id=''ORA''>Error</b>'||chr(10)||
'<tr><td><a href=#BACK_LINK#>#OK#</a></td>'||chr(10)||
'<td><br /></td></tr></table> ',
p_template_comment => '');
end;
null;
end;
/
prompt ...button templates
--
--application/shared_components/user_interface/templates/button/button
prompt ......Button Template 71130218387453389
declare
t varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
t:=t||'<input type="button" name="#LABEL#" value="#LABEL#" onclick="#LINK#"/>';
wwv_flow_api.create_button_templates (
p_id=>71130218387453389 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_template=>t,
p_template_name=> 'Button',
p_translate_this_template => 'N',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 1,
p_template_comment => 'Standard Button');
end;
/
--application/shared_components/user_interface/templates/button/button_alternative_1
prompt ......Button Template 71130402747453394
declare
t varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
t:=t||'<a href="#LINK#" class="t4ButtonAlternative1">#LABEL#</a>';
wwv_flow_api.create_button_templates (
p_id=>71130402747453394 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_template=>t,
p_template_name=> 'Button, Alternative 1',
p_translate_this_template => 'N',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 4,
p_template_comment => 'XP Square FFFFFF');
end;
/
--application/shared_components/user_interface/templates/button/button_alternative_2
prompt ......Button Template 71130603223453394
declare
t varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
t:=t||'<a href="#LINK#" class="t4ButtonAlternative2">#LABEL#</a>';
wwv_flow_api.create_button_templates (
p_id=>71130603223453394 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_template=>t,
p_template_name=> 'Button, Alternative 2',
p_translate_this_template => 'N',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 5,
p_template_comment => 'Standard Button');
end;
/
--application/shared_components/user_interface/templates/button/button_alternative_3
prompt ......Button Template 71130819271453394
declare
t varchar2(32767) := null;
l_clob clob;
l_length number := 1;
begin
t:=t||'<a href="#LINK#" class="t4ButtonAlternative3">#LABEL#</a>';
wwv_flow_api.create_button_templates (
p_id=>71130819271453394 + wwv_flow_api.g_id_offset,
p_flow_id=>wwv_flow.g_flow_id,
p_template=>t,
p_template_name=> 'Button, Alternative 3',
p_translate_this_template => 'N',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 2,
p_template_comment => 'Standard Button');
end;
/
---------------------------------------
prompt ...region templates
--
--application/shared_components/user_interface/templates/region/form_region_without_buttons
prompt ......region template 53349279953171514
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||'<h1 class="regionheader">#TITLE#<a name="#REGION_STATIC_ID#"> </a></h1>'||chr(10)||
'<table class="t4FormRegion" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader"></td></tr>'||chr(10)||
'<!--'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'-->'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#<img alt=';
t:=t||'"" src="#IMAGE_PREFIX#themes/theme_4/1px_trans.gif" style="display:block;" width="600" height="1" /></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 53349279953171514 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Form Region without Buttons',
p_plug_table_bgcolor => '#f7f7e7',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 8,
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=> 53349279953171514 + 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/borderless_region
prompt ......region template 71117211208453358
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||'<table class="t4BorderlessRegion" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71117211208453358 + wwv_flow_api.g_id_offset,
p_flow_id => wwv_flow.g_flow_id,
p_template => t,
p_page_plug_template_name=> 'Borderless Region',
p_plug_table_bgcolor => '#f7f7e7',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 7,
p_plug_heading_bgcolor => '#f7f7e7',
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=> 71117211208453358 + 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/bracketed_region
prompt ......region template 71117502348453364
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||'<table cellpadding="0" cellspacing="0" border="0" summary="" class="t4BracketedRegion" id="#REGION_ID#">'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionHeader">#TITLE#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td><table cellpadding="0" cellspacing="0" border="0" summary="" width="100%">'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4bracket"><img src="#IMAGE_PREFIX#themes/theme_1/1px_trans.gif" height="5" width="1" alt="" /></td>'||chr(10)||
'<td rowspan="3" class="t4RegionBody"><div c';
t:=t||'lass="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</div>#BODY#</td>'||chr(10)||
'<td class="t4bracket"><img src="#IMAGE_PREFIX#themes/theme_1/1px_trans.gif" height="5" width="1" alt="" /></td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td><img src="#IMAGE_PREFIX#themes/theme_1/1px_trans.gif" height="1" width="1" alt="" /></td>'||chr(10)||
'<td><img src="#IMAGE_PREFIX#themes/theme_1/1px_trans.gi';
t:=t||'f" height="1" width="1" alt="" /></td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4bracket"><img src="#IMAGE_PREFIX#themes/theme_1/1px_trans.gif" height="5" width="1" alt="" /></td>'||chr(10)||
'<td class="t4bracket"><img src="#IMAGE_PREFIX#themes/theme_1/1px_trans.gif" height="5" width="1" alt="" /></td>'||chr(10)||
'</tr>'||chr(10)||
'</table></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71117502348453364 + 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 => '#ffffff',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 18,
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=> 71117502348453364 + 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 71117787921453364
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||'<div id="#REGION_ID#">#BODY#</div>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71117787921453364 + 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 => wwv_flow.g_flow_theme_id,
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=> 71117787921453364 + 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 71118107841453364
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||'<table class="t4ButtonRegionwithTitle" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr><td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#<img alt="" src="#IMAGE_PREFIX#themes/theme_4/1px_trans.gif" style="display:block;" width="600" height="1" /></td></tr>'||chr(10)||
'<';
t:=t||'/table>#BODY#';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71118107841453364 + 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 => wwv_flow.g_flow_theme_id,
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=> 71118107841453364 + 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 71118400356453364
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||'<table class="t4ButtonRegionwithoutTitle" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#<img alt="" src="#IMAGE_PREFIX#themes/theme_4/1px_trans.gif" style="display:block;" width="600" height="1" /></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>#BODY#';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71118400356453364 + 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 => '#ffffff',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 17,
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=> 71118400356453364 + 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 71118718898453364
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||'<table class="t4ChartRegion" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71118718898453364 + 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 => wwv_flow.g_flow_theme_id,
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=> 71118718898453364 + 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 71118991564453364
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||'<h1 class="regionheader">#TITLE#<a name="#REGION_STATIC_ID#"> </a></h1>'||chr(10)||
'<table class="t4FormRegion" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader"></td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#<img alt="" src="#';
t:=t||'IMAGE_PREFIX#themes/theme_4/1px_trans.gif" style="display:block;" width="600" height="1" /></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71118991564453364 + 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 => '#f7f7e7',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 8,
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=> 71118991564453364 + 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 71119296403453366
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||'<table class="t4HideandShowRegion" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
' <tr><td class="t4RegionHeader">#TITLE#<a style="margin-left:5px;" href="javascript:hideShow(''region#REGION_SEQUENCE_ID#'',''shIMG#REGION_SEQUENCE_ID#'',''#IMAGE_PREFIX#themes/theme_4/rollup_plus_dgray.gif'',''#IMAGE_PREFIX#themes/theme_4/rollup_minus_dgray.gif'');" class="t4HideShowMinLink"><img s';
t:=t||'rc="#IMAGE_PREFIX#themes/theme_4/rollup_plus_dgray.gif" '||chr(10)||
' id="shIMG#REGION_SEQUENCE_ID#" alt="" /></a></td></tr>'||chr(10)||
'<tr><td><div class="t4Hide" id="region#REGION_SEQUENCE_ID#"><div class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</div><div class="t4RegionBody">#BODY#</div></div></td></tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71119296403453366 + 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 => '#ffffff',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 1,
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=> 71119296403453366 + 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
prompt ......region template 71119612157453366
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||'<table class="t4ListRegionwithIcon" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody"><table summary="" cellpadding="0" cellspacing="0" border="0">'||chr(10)||
'<tr>'||chr(10)||
'<td valign="to';
t:=t||'p"><img src="#IMAGE_PREFIX#themes/theme_4/chart.gif" alt="" /></td>'||chr(10)||
'<td valign="top">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71119612157453366 + 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)',
p_plug_table_bgcolor => '#ffffff',
p_theme_id => wwv_flow.g_flow_theme_id,
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=> 71119612157453366 + 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_
prompt ......region template 71119901175453368
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||'<table class="t4ListRegionwithIcon" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody"><table summary="" cellpadding="0" cellspacing="0" border="0">'||chr(10)||
'<tr>'||chr(10)||
'<td valign="to';
t:=t||'p"><img src="#IMAGE_PREFIX#themes/theme_4/report.gif"" alt="" /></td>'||chr(10)||
'<td valign="top">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71119901175453368 + 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) ',
p_plug_table_bgcolor => '#ffffff',
p_theme_id => wwv_flow.g_flow_theme_id,
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=> 71119901175453368 + 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 71120211015453368
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||'<table class="t4NavigationRegion" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71120211015453368 + 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 => wwv_flow.g_flow_theme_id,
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=> 71120211015453368 + 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 71120511409453368
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||'<table class="t4NavigationRegionAlternative1" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71120511409453368 + 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 => wwv_flow.g_flow_theme_id,
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=> 71120511409453368 + 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_title
prompt ......region template 71120815740453368
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||'<table class="t4RegionwithoutButtonsandTitle" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader"><br /></td></tr>'||chr(10)||
'<tr><td class="t4RegionBody">#BODY#</td></tr>'||chr(10)||
'</table>'||chr(10)||
'';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71120815740453368 + 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 Title',
p_plug_table_bgcolor => '',
p_theme_id => wwv_flow.g_flow_theme_id,
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=> 71120815740453368 + 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 71121113963453369
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||'<table class="t4RegionwithoutTitle" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader"><br /></td></tr>'||chr(10)||
'<tr><td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td></tr>'||chr(10)||
'<tr><td class="t4RegionBody">#BODY#</td></tr>'||chr(10)||
'</table>'||chr(10)||
'';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71121113963453369 + 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 => wwv_flow.g_flow_theme_id,
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=> 71121113963453369 + 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 71121389039453369
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||'<h1>#TITLE#</h1>'||chr(10)||
'<table class="t4ReportsRegion" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="10" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader"></td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71121389039453369 + 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 => '#ffffff',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 9,
p_plug_heading_bgcolor => '#ffffff',
p_plug_font_size => '-1',
p_translate_this_template => 'N',
p_template_comment => 'Red Theme');
end;
null;
end;
/
begin
declare
t2 varchar2(32767) := null;
begin
t2 := null;
wwv_flow_api.set_plug_template_tab_attr (
p_id=> 71121389039453369 + 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 71121696020453369
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||'<table class="t4GReportsRegion100Width" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table>'||chr(10)||
'';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71121696020453369 + 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 => wwv_flow.g_flow_theme_id,
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=> 71121696020453369 + 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 71122001547453369
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||'<table class="t4ReportsRegionAlternative1" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71122001547453369 + 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 => wwv_flow.g_flow_theme_id,
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=> 71122001547453369 + 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 71122304127453369
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||'<table class="t4SidebarRegion" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71122304127453369 + 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 => wwv_flow.g_flow_theme_id,
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=> 71122304127453369 + 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 71122591553453369
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||'<table class="t4SidebarRegionAlternative1" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71122591553453369 + 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 => '#f7f7e7',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 3,
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=> 71122591553453369 + 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 71122912959453369
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||'<table class="t4WizardRegion" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71122912959453369 + 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 => wwv_flow.g_flow_theme_id,
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=> 71122912959453369 + 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 71123193402453369
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||'<table class="t4WizardRegionwithIcon" id="#REGION_ID#" border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'<tr><td class="t4RegionHeader">#TITLE#</td></tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4ButtonHolder">#CLOSE#&nbsp;#EXPAND##HELP##DELETE##EDIT##CHANGE##COPY##PREVIOUS##NEXT##CREATE##CREATE2#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4RegionBody"><table summary="" cellpadding="0" cellspacing="0" border="0">'||chr(10)||
'<tr>'||chr(10)||
'<td valign="';
t:=t||'top"><img src="#IMAGE_PREFIX#themes/theme_4/iconwizard.gif" alt=""/></td>'||chr(10)||
'<td width="100%" valign="top">#BODY#</td>'||chr(10)||
'</tr>'||chr(10)||
'</table></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>';
t2 := null;
wwv_flow_api.create_plug_template (
p_id => 71123193402453369 + 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 => wwv_flow.g_flow_theme_id,
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=> 71123193402453369 + 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 71125605794453375
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||'<a href="#LINK#" class="t4Button" style="background-color:#CCCCCC;">#TEXT#</a>';
t2:=t2||'<a href="#LINK#" class="t4Button">#TEXT#</a>';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>71125605794453375 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 6,
p_list_template_before_rows=>'<div class="t4ButtonList">',
p_list_template_after_rows=>'</div>',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/dhtml_list_image_with_sublist
prompt ......list template 71125894102453380
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||'<div class="dhtmlMenuItem"><a href="#LINK#"><img src="#IMAGE_PREFIX#themes/generic_list.gif" alt="" #IMAGE_ATTR# /></a><img src="#IMAGE_PREFIX#themes/generic_nochild.gif" width="22" height="75" alt="" /><a href="#LINK#" class="dhtmlBottom">#TEXT#</a></div>';
t2:=t2||'<div class="dhtmlMenuItem"><a href="#LINK#"><img src="#IMAGE_PREFIX#themes/generic_list.gif" alt="" #IMAGE_ATTR# /></a><img src="#IMAGE_PREFIX#themes/generic_nochild.gif" width="22" height="75" alt="" /><a href="#LINK#" class="dhtmlBottom">#TEXT#</a></div>';
t3:=t3||'<li class="dhtmlMenuSep"><img src="#IMAGE_PREFIX#themes/theme_13/1px_trans.gif" width="1" height="1" alt="" class="dhtmlMenuSep" /></li>';
t4:=t4||'<li><a href="#LINK#" class="dhtmlSubMenuN" onmouseover="dhtml_CloseAllSubMenusL(this)">#TEXT#</a></li>';
t5:=t5||'<div class="dhtmlMenuItem"><a href="#LINK#"><img src="#IMAGE_PREFIX#themes/generic_list.gif" alt="" #IMAGE_ATTR# /></a><img src="#IMAGE_PREFIX#themes/generic_open.gif" width="22" height="75" class="dhtmlMenu" onclick="app_AppMenuMultiOpenBottom(this,''#LIST_ITEM_ID#'',false)" alt="" /><a href="#LINK#" class="dhtmlBottom">#TEXT#</a></div>';
t6:=t6||'<div class="dhtmlMenuItem"><a href="#LINK#"><img src="#IMAGE_PREFIX#themes/generic_list.gif" alt="" #IMAGE_ATTR# /></a><img src="#IMAGE_PREFIX#themes/generic_open.gif" width="22" height="75" class="dhtmlMenu" onclick="app_AppMenuMultiOpenBottom(this,''#LIST_ITEM_ID#'',false)" alt="" /><a href="#LINK#" class="dhtmlBottom">#TEXT#</a></div>';
t7:=t7||'<li class="dhtmlSubMenuS"><a href="#LINK#" class="dhtmlSubMenuS" onmouseover="dhtml_MenuOpen(this,''#LIST_ITEM_ID#'',true,''Left'')"><span style="float:left;">#TEXT#</span><img class="t13MIMG" src="#IMAGE_PREFIX#menu_open_right2.gif" alt="" /></a></li>';
t8:=t8||'<li class="dhtmlSubMenuS"><a href="#LINK#" class="dhtmlSubMenuS" onmouseover="dhtml_MenuOpen(this,''#LIST_ITEM_ID#'',true,''Left'')"><span style="float:left;">#TEXT#</span><img class="t13MIMG" src="#IMAGE_PREFIX#menu_open_right2.gif" alt="" /></a></li>';
wwv_flow_api.create_list_template (
p_id=>71125894102453380 + 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 List (Image) with Sublist',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 21,
p_list_template_before_rows=>'<div class="dhtmlMenuLG">',
p_list_template_after_rows=>'</div><br style="clear:both;"/><br style="clear:both;"/>',
p_before_sub_list=>'<ul id="#PARENT_LIST_ITEM_ID#" htmldb:listlevel="#LEVEL#" class="dhtmlSubMenu2" style="display:none;"><li class="dhtmlSubMenuP" onmouseover="dhtml_CloseAllSubMenusL(this)">#PARENT_TEXT#</li>',
p_after_sub_list=>'</ul>',
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_menu_with_sublist
prompt ......list template 71126118039453380
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||'<li class="dhtmlMenuItem"><a href="#LINK#">#TEXT#</a></li>';
t2:=t2||'<li class="dhtmlMenuItem"><a href="#LINK#">#TEXT#</a></li>';
t3:=t3||'<li class="dhtmlMenuSep2"><img src="#IMAGE_PREFIX#themes/theme_13/1px_trans.gif" width="1" height="1" alt="" class="dhtmlMenuSep2" /></li>';
t4:=t4||'<li><a href="#LINK#" class="dhtmlSubMenuN" onmouseover="dhtml_CloseAllSubMenusL(this)">#TEXT#</a></li>';
t5:=t5||'<li class="dhtmlMenuItem1"><a href="#LINK#">#TEXT#</a><img src="#IMAGE_PREFIX#themes/theme_13/menu_small.gif" alt="Expand" onclick="app_AppMenuMultiOpenBottom2(this,''#LIST_ITEM_ID#'',false)" /></li>';
t6:=t6||'<li class="dhtmlMenuItem1"><a href="#LINK#">#TEXT#</a><img src="#IMAGE_PREFIX#themes/theme_13/menu_small.gif" alt="Expand" onclick="app_AppMenuMultiOpenBottom2(this,''#LIST_ITEM_ID#'',false)" /></li>';
t7:=t7||'<li class="dhtmlSubMenuS"><a href="#LINK#" class="dhtmlSubMenuS" onmouseover="dhtml_MenuOpen(this,''#LIST_ITEM_ID#'',true,''Left'')"><span style="float:left;">#TEXT#</span><img class="t13MIMG" src="#IMAGE_PREFIX#menu_open_right2.gif" alt="" /></a></li>';
t8:=t8||'<li class="dhtmlSubMenuS"><a href="#LINK#" class="dhtmlSubMenuS" onmouseover="dhtml_MenuOpen(this,''#LIST_ITEM_ID#'',true,''Left'')"><span style="float:left;">#TEXT#</span><img class="t13MIMG" src="#IMAGE_PREFIX#menu_open_right2.gif" alt="" /></a></li>';
wwv_flow_api.create_list_template (
p_id=>71126118039453380 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 20,
p_list_template_before_rows=>'<ul class="dhtmlMenuLG2">',
p_list_template_after_rows=>'</ul><br style="clear:both;"/><br style="clear:both;"/>',
p_before_sub_list=>'<ul id="#PARENT_LIST_ITEM_ID#" htmldb:listlevel="#LEVEL#" class="dhtmlSubMenu2" style="display:none;">',
p_after_sub_list=>'</ul>',
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 71126412572453380
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||'<li><img src="#IMAGE_PREFIX#themes/theme_13/node.gif" align="middle" alt="" /><a href="#LINK#">#TEXT#</a></li>';
t2:=t2||'<li><img src="#IMAGE_PREFIX#themes/theme_13/node.gif" align="middle" alt="" /><a href="#LINK#">#TEXT#</a></li>';
t3:=t3||'<li><img src="#IMAGE_PREFIX#themes/theme_13/node.gif" align="middle" alt="" /><a href="#LINK#">#TEXT#</a></li>';
t4:=t4||'<li><img src="#IMAGE_PREFIX#themes/theme_13/node.gif" align="middle" alt="" /><a href="#LINK#">#TEXT#</a></li>';
t5:=t5||'<li><img src="#IMAGE_PREFIX#themes/theme_13/plus.gif" align="middle" onclick="htmldb_ToggleWithImage(this,''#LIST_ITEM_ID#'')" class="pseudoButtonInactive" alt="" /><a href="#LINK#">#TEXT#</a></li>';
t6:=t6||'<li><img src="#IMAGE_PREFIX#themes/theme_13/plus.gif" align="middle" onclick="htmldb_ToggleWithImage(this,''#LIST_ITEM_ID#'')" class="pseudoButtonInactive" alt="" /><a href="#LINK#">#TEXT#</a></li>';
t7:=t7||'<li><img src="#IMAGE_PREFIX#themes/theme_13/plus.gif" onclick="htmldb_ToggleWithImage(this,''#LIST_ITEM_ID#'')" align="middle" class="pseudoButtonInactive" alt="" /><a href="#LINK#">#TEXT#</a></li>';
t8:=t8||'<li><img src="#IMAGE_PREFIX#themes/theme_13/plus.gif" onclick="htmldb_ToggleWithImage(this,''#LIST_ITEM_ID#'')" align="middle" class="pseudoButtonInactive" alt="" /><a href="#LINK#">#TEXT#</a></li>';
wwv_flow_api.create_list_template (
p_id=>71126412572453380 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 22,
p_list_template_before_rows=>'<ul class="dhtmlTree">',
p_list_template_after_rows=>'</ul><br style="clear:both;"/><br style="clear:both;"/>',
p_before_sub_list=>'<ul id="#PARENT_LIST_ITEM_ID#" htmldb:listlevel="#LEVEL#" style="display:none;" class="dhtmlTree">',
p_after_sub_list=>'</ul>',
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 71126692093453382
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||'<td class="t4current"><img src="#IMAGE_PREFIX##IMAGE#" border="0" alt="" #IMAGE_ATTR#/><br />#TEXT#</td>';
t2:=t2||'<td><a href="#LINK#"><img src="#IMAGE_PREFIX##IMAGE#" border="0" alt="" #IMAGE_ATTR#/></a><br /><a href="#LINK#">#TEXT#</a></td>';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>71126692093453382 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 4,
p_list_template_before_rows=>'<table class="t4HorizontalImageswithLabelList" cellpadding="0" border="0" cellspacing="0" summary=""><tr>',
p_list_template_after_rows=>'</tr></table>',
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 71127002907453382
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||'<a href="#LINK#" class="t4current">#TEXT#</a>';
t2:=t2||'<a href="#LINK#">#TEXT#</a>';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>71127002907453382 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 3,
p_list_template_before_rows=>'<div class="t4HorizontalLinksList">',
p_list_template_after_rows=>'</div>',
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 71127314557453382
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||'<li><a class="t4current" href="#LINK#">#TEXT#</a></li>';
t2:=t2||'<li><a href="#LINK#">#TEXT#</a></li>';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>71127314557453382 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 7,
p_list_template_before_rows=>'<ul class="t4TabbedNavigationList">',
p_list_template_after_rows=>'</ul>',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/tree_list
prompt ......list template 71127598124453382
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||'<li><a name="#LIST_LABEL#" class="current" href="#LINK#"><img src="/i/ng_black.gif" alt="" width="5" height="11"/>#TEXT#</a></li>';
t2:=t2||'<li><a name="#LIST_LABEL#" href="#LINK#"><img src="/i/ng_black.gif" alt="" width="5" height="11"/>#TEXT#</a></li>';
t3:=t3||'<li><a name="#LIST_LABEL#" class="current" href="#LINK#"><img src="/i/ng_black.gif" alt="" width="5" height="11"/>#TEXT#</a></li>';
t4:=t4||'<li><a name="#LIST_LABEL#" href="#LINK#"><img src="/i/ng_black.gif" alt="" width="5" height="11"/>#TEXT#</a></li>';
t5:=t5||'<li><a name="#LIST_LABEL#" class="current" href="#LINK#"><img src="/i/ng_black.gif" alt="" width="5" height="11" />#TEXT#</a></li>';
t6:=t6||'<li><a name="#LIST_LABEL#" href="#LINK#"><img src="/i/ng_black.gif" alt="" width="5" height="11"/>#TEXT#</a></li>';
t7:=t7||'<li><a name="#LIST_LABEL#" class="current" href="#LINK#"><img src="/i/ng_black.gif" alt="" width="5" height="11"/>#TEXT#</a></li>';
t8:=t8||'<li><a name="#LIST_LABEL#" href="#LINK#"><img src="/i/ng_black.gif" alt="" width="5" height="11"/>#TEXT#</a></li>';
wwv_flow_api.create_list_template (
p_id=>71127598124453382 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 0,
p_list_template_before_rows=>'<ul class="tierLink">',
p_list_template_after_rows=>'</ul><br style="clear:both;"/><br style="clear:both;"/>',
p_before_sub_list=>'<ul name="#LIST_LABEL#" id="#PARENT_LIST_ITEM_ID#" htmldb:listlevel="#LEVEL#">',
p_after_sub_list=>'</ul>',
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_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/vertical_images_list
prompt ......list template 71127917370453382
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||'<tr><td class="t4current"><a href="#LINK#"><img src="#IMAGE_PREFIX##IMAGE#" #IMAGE_ATTR# alt="" />#TEXT#</a></td></tr>';
t2:=t2||'<tr><td><a href="#LINK#"><img src="#IMAGE_PREFIX##IMAGE#" #IMAGE_ATTR# alt="" />#TEXT#</a></td></tr>';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>71127917370453382 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 5,
p_list_template_before_rows=>'<table border="0" cellpadding="0" cellspacing="0" summary="" class="t4VerticalImagesList">',
p_list_template_after_rows=>'</table>',
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 71128203586453382
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||'<li class="t4current"><a href="#LINK#">#TEXT#</a></li>';
t2:=t2||'<li><a href="#LINK#">#TEXT#</a></li>';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>71128203586453382 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 2,
p_list_template_before_rows=>'<ol class="t4VerticalOrderedList">',
p_list_template_after_rows=>'</ol>',
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 71128489682453382
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||'<tr><td class="t4current"><a href="#LINK#" class="t4nav">#TEXT#</a></td></tr>';
t2:=t2||'<tr><td><a href="#LINK#" class="t4nav">#TEXT#</a></td></tr>';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>71128489682453382 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 19,
p_list_template_before_rows=>'<table border="0" cellpadding="0" cellspacing="0" summary="" class="t4VerticalSidebarList">',
p_list_template_after_rows=>'</table>',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
--application/shared_components/user_interface/templates/list/vertical_unordered_links_without_bullets
prompt ......list template 71128789774453382
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||'<li class="t4current"><a href="#LINK#">#TEXT#</a></li>';
t2:=t2||'<li><a href="#LINK#">#TEXT#</a></li>';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>71128789774453382 + 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 Links without Bullets',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 18,
p_list_template_before_rows=>'<ul class="t4VerticalUnorderedLinkswithoutBullets">',
p_list_template_after_rows=>'</ul>',
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 71129089840453382
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||'<li class="t4current"><a href="#LINK#">#TEXT#</a></li>';
t2:=t2||'<li><a href="#LINK#">#TEXT#</a></li>';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>71129089840453382 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 1,
p_list_template_before_rows=>'<ul class="t4VerticalUnorderedListwithBullets">',
p_list_template_after_rows=>'</ul>',
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 71129397885453383
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||'<tr><td><div class="t4current">#TEXT#</div></td></tr>';
t2:=t2||'<tr><td><div>#TEXT#</div></td></tr>';
t3 := null;
t4 := null;
t5 := null;
t6 := null;
t7 := null;
t8 := null;
wwv_flow_api.create_list_template (
p_id=>71129397885453383 + 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 => wwv_flow.g_flow_theme_id,
p_theme_class_id => 17,
p_list_template_before_rows=>'<table border="0" cellpadding="0" cellspacing="0" summary="" class="t4WizardProgressList">',
p_list_template_after_rows=>'<tr><td>&DONE.</td></tr>'||chr(10)||
'</table>',
p_translate_this_template => 'N',
p_list_template_comment=>'');
end;
null;
end;
/
prompt ...report templates
--
--application/shared_components/user_interface/templates/report/borderless
prompt ......report template 71123508518453369
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'<td headers="#COLUMN_HEADER_NAME#" #ALIGNMENT# class="t4data">#COLUMN_VALUE#</td>';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 71123508518453369 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'Borderless',
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=>'<table cellpadding="0" border="0" cellspacing="0" summary="">#TOP_PAGINATION#'||chr(10)||
'<tr><td><table class="t4Borderless" cellpadding="0" border="0" cellspacing="0" summary="">',
p_row_template_after_rows =>'</table><div class="t4CVS">#EXTERNAL_LINK##CSV_LINK#</div></td></tr>#PAGINATION#</table>'||chr(10)||
'',
p_row_template_table_attr =>'OMIT',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'<th class="t4ReportHeader"#ALIGNMENT# id="#COLUMN_HEADER_NAME#">#COLUMN_HEADER#</th>',
p_row_template_display_cond1=>'0',
p_row_template_display_cond2=>'0',
p_row_template_display_cond3=>'0',
p_row_template_display_cond4=>'0',
p_next_page_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT# &gt;</a>',
p_previous_page_template=>'<a href="#LINK#" class="t4pagination">&lt;#PAGINATION_PREVIOUS#</a>',
p_next_set_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT_SET#&gt;&gt;</a>',
p_previous_set_template=>'<a href="#LINK#" class="t4pagination">&lt;&lt;#PAGINATION_PREVIOUS_SET#</a>',
p_row_style_checked=>'#CCCCCC',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 1,
p_translate_this_template => 'N',
p_row_template_comment=> '');
end;
null;
end;
/
begin
begin
wwv_flow_api.create_row_template_patch (
p_id => 71123508518453369 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'<tr #HIGHLIGHT_ROW#>',
p_row_template_after_last =>'</tr>');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/horizontal_border
prompt ......report template 71123788944453372
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'<td headers="#COLUMN_HEADER_NAME#" #ALIGNMENT# class="t4data">#COLUMN_VALUE#</td>';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 71123788944453372 + 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=>'<table cellpadding="0" border="0" cellspacing="0" summary="">#TOP_PAGINATION#'||chr(10)||
'<tr><td><table class="t4HorizontalBorder" border="0" cellpadding="0" cellspacing="0" summary="">',
p_row_template_after_rows =>'</table><div class="t4CVS">#EXTERNAL_LINK##CSV_LINK#</div></td></tr>#PAGINATION#</table>',
p_row_template_table_attr =>'OMIT',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'<th class="t4ReportHeader" id="#COLUMN_HEADER_NAME#" #ALIGNMENT#>#COLUMN_HEADER#</th>',
p_row_template_display_cond1=>'0',
p_row_template_display_cond2=>'0',
p_row_template_display_cond3=>'0',
p_row_template_display_cond4=>'0',
p_next_page_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT# &gt;</a>',
p_previous_page_template=>'<a href="#LINK#" class="t4pagination">&lt;#PAGINATION_PREVIOUS#</a>',
p_next_set_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT_SET#&gt;&gt;</a>',
p_previous_set_template=>'<a href="#LINK#" class="t4pagination">&lt;&lt;#PAGINATION_PREVIOUS_SET#</a>',
p_row_style_checked=>'#CCCCCC',
p_theme_id => wwv_flow.g_flow_theme_id,
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 => 71123788944453372 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'<tr #HIGHLIGHT_ROW#>',
p_row_template_after_last =>'</tr>');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/one_column_unordered_list
prompt ......report template 71124102649453372
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=> 71124102649453372 + 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=>'<table border="0" cellpadding="0" cellspacing="0" summary="">'||chr(10)||
'#TOP_PAGINATION#<tr><td><ul class="t4OneColumnUnorderedList">',
p_row_template_after_rows =>'</ul><div class="t4CVS">#EXTERNAL_LINK##CSV_LINK#</div></td></tr>#PAGINATION#</table>',
p_row_template_table_attr =>'OMIT',
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_next_page_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT# &gt;</a>',
p_previous_page_template=>'<a href="#LINK#" class="t4pagination">&lt;#PAGINATION_PREVIOUS#</a>',
p_next_set_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT_SET#&gt;&gt;</a>',
p_previous_set_template=>'<a href="#LINK#" class="t4pagination">&lt;&lt;#PAGINATION_PREVIOUS_SET#</a>',
p_theme_id => wwv_flow.g_flow_theme_id,
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 => 71124102649453372 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'<li>',
p_row_template_after_last =>'</li>');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/standard
prompt ......report template 71124395124453374
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'<td #ALIGNMENT# headers="#COLUMN_HEADER#" class="t4data">#COLUMN_VALUE#</td>';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 71124395124453374 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'Standard',
p_row_template1=> c1,
p_row_template_condition1=> '',
p_row_template2=> c2,
p_row_template_condition2=> '',
p_row_template3=> c3,
p_row_template_condition3=> '',
p_row_template4=> c4,
p_row_template_condition4=> '',
p_row_template_before_rows=>'<table cellpadding="0" border="0" cellspacing="0" summary="">#TOP_PAGINATION#'||chr(10)||
'<tr><td><table cellpadding="0" border="0" cellspacing="0" summary="" class="t4Standard">',
p_row_template_after_rows =>'</table><div class="t4CVS">#EXTERNAL_LINK##CSV_LINK#</div></td></tr>#PAGINATION#</table>',
p_row_template_table_attr =>'OMIT',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'<th class="t4ReportHeader"#ALIGNMENT# id="#COLUMN_HEADER_NAME#">#COLUMN_HEADER#</th>',
p_row_template_display_cond1=>'0',
p_row_template_display_cond2=>'0',
p_row_template_display_cond3=>'0',
p_row_template_display_cond4=>'0',
p_next_page_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT# &gt;</a>',
p_previous_page_template=>'<a href="#LINK#" class="t4pagination">&lt;#PAGINATION_PREVIOUS#</a>',
p_next_set_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT_SET#&gt;&gt;</a>',
p_previous_set_template=>'<a href="#LINK#" class="t4pagination">&lt;&lt;#PAGINATION_PREVIOUS_SET#</a>',
p_row_style_checked=>'#CCCCCC',
p_theme_id => wwv_flow.g_flow_theme_id,
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 => 71124395124453374 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'<tr #HIGHLIGHT_ROW#>',
p_row_template_after_last =>'</tr>');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/standard_ppr
prompt ......report template 71124704812453374
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'<td #ALIGNMENT# headers="#COLUMN_HEADER#" class="t4data">#COLUMN_VALUE#</td>';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 71124704812453374 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'Standard (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=>'<div id="report#REGION_ID#"><htmldb:#REGION_ID#><table cellpadding="0" border="0" cellspacing="0" summary="">#TOP_PAGINATION#'||chr(10)||
'<tr><td><table cellpadding="0" border="0" cellspacing="0" summary="" class="t4Standard">',
p_row_template_after_rows =>'</table><div class="t4CVS">#EXTERNAL_LINK##CSV_LINK#</div></td></tr>#PAGINATION#</table><script language=JavaScript type=text/javascript>'||chr(10)||
'<!--'||chr(10)||
'init_htmlPPRReport(''#REGION_ID#'');'||chr(10)||
''||chr(10)||
'//-->'||chr(10)||
'</script>'||chr(10)||
'</htmldb:#REGION_ID#>'||chr(10)||
'</div>',
p_row_template_table_attr =>'OMIT',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'<th class="t4ReportHeader"#ALIGNMENT# id="#COLUMN_HEADER_NAME#">#COLUMN_HEADER#</th>',
p_row_template_display_cond1=>'0',
p_row_template_display_cond2=>'0',
p_row_template_display_cond3=>'0',
p_row_template_display_cond4=>'0',
p_next_page_template=>'<a href="javascript:html_PPR_Report_Page(this,''#REGION_ID#'',''#LINK#'')" class="t4pagination">#PAGINATION_NEXT# &gt;</a>',
p_previous_page_template=>'<a href="javascript:html_PPR_Report_Page(this,''#REGION_ID#'',''#LINK#'')" class="t4pagination">&lt;#PAGINATION_PREVIOUS#</a>',
p_next_set_template=>'<a href="javascript:html_PPR_Report_Page(this,''#REGION_ID#'',''#LINK#'')" class="t4pagination">#PAGINATION_NEXT_SET#&gt;&gt;</a>',
p_previous_set_template=>'<a href="javascript:html_PPR_Report_Page(this,''#REGION_ID#'',''#LINK#'')" class="t4pagination">&lt;&lt;#PAGINATION_PREVIOUS_SET#</a>',
p_row_style_checked=>'#CCCCCC',
p_theme_id => wwv_flow.g_flow_theme_id,
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 => 71124704812453374 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'<tr #HIGHLIGHT_ROW#>',
p_row_template_after_last =>'</tr>');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/standard_alternating_row_colors
prompt ......report template 71125013780453374
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'<td headers="#COLUMN_HEADER_NAME#" #ALIGNMENT# class="t4data">#COLUMN_VALUE#</td>'||chr(10)||
'';
c2:=c2||'<td headers="#COLUMN_HEADER_NAME#" #ALIGNMENT# class="t4dataalt">#COLUMN_VALUE#</td>';
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 71125013780453374 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_row_template_name=> 'Standard, Alternating 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=>'<table border="0" cellpadding="0" cellspacing="0" summary="">#TOP_PAGINATION#'||chr(10)||
'<tr><td><table border="0" cellpadding="0" cellspacing="0" summary="" class="t4StandardAlternatingRowColors">',
p_row_template_after_rows =>'</table><div class="t4CVS">#EXTERNAL_LINK##CSV_LINK#</div></td></tr>#PAGINATION#</table>',
p_row_template_table_attr =>'OMIT',
p_row_template_type =>'GENERIC_COLUMNS',
p_column_heading_template=>'<th class="t4ReportHeader"#ALIGNMENT# id="#COLUMN_HEADER_NAME#">#COLUMN_HEADER#</th>',
p_row_template_display_cond1=>'ODD_ROW_NUMBERS',
p_row_template_display_cond2=>'NOT_CONDITIONAL',
p_row_template_display_cond3=>'NOT_CONDITIONAL',
p_row_template_display_cond4=>'ODD_ROW_NUMBERS',
p_next_page_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT# &gt;</a>',
p_previous_page_template=>'<a href="#LINK#" class="t4pagination">&lt;#PAGINATION_PREVIOUS#</a>',
p_next_set_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT_SET#&gt;&gt;</a>',
p_previous_set_template=>'<a href="#LINK#" class="t4pagination">&lt;&lt;#PAGINATION_PREVIOUS_SET#</a>',
p_row_style_checked=>'#CCCCCC',
p_theme_id => wwv_flow.g_flow_theme_id,
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 => 71125013780453374 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'<tr #HIGHLIGHT_ROW#> ',
p_row_template_after_last =>'</tr>');
exception when others then null;
end;
null;
end;
/
--application/shared_components/user_interface/templates/report/value_attribute_pairs
prompt ......report template 71125292747453374
begin
declare
c1 varchar2(32767) := null;
c2 varchar2(32767) := null;
c3 varchar2(32767) := null;
c4 varchar2(32767) := null;
begin
c1:=c1||'<tr>'||chr(10)||
'<th class="t4ReportHeader">#COLUMN_HEADER#</th>'||chr(10)||
'<td class="t4data">#COLUMN_VALUE#</td>'||chr(10)||
'</tr>';
c2 := null;
c3 := null;
c4 := null;
wwv_flow_api.create_row_template (
p_id=> 71125292747453374 + 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=>'<table cellpadding="0" cellspacing="0" border="0" summary="">'||chr(10)||
'#TOP_PAGINATION#'||chr(10)||
'<tr>'||chr(10)||
'<td><table cellpadding="0" cellspacing="0" border="0" summary="" class="t4ValueAttributePairs">',
p_row_template_after_rows =>'</table><div class="t4CVS">#EXTERNAL_LINK##CSV_LINK#</div></td></tr>#PAGINATION#</table>',
p_row_template_table_attr =>'OMIT',
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_next_page_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT# &gt;</a>',
p_previous_page_template=>'<a href="#LINK#" class="t4pagination">&lt;#PAGINATION_PREVIOUS#</a>',
p_next_set_template=>'<a href="#LINK#" class="t4pagination">#PAGINATION_NEXT_SET#&gt;&gt;</a>',
p_previous_set_template=>'<a href="#LINK#" class="t4pagination">&lt;&lt;#PAGINATION_PREVIOUS_SET#</a>',
p_theme_id => wwv_flow.g_flow_theme_id,
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 => 71125292747453374 + wwv_flow_api.g_id_offset,
p_row_template_before_first =>'',
p_row_template_after_last =>'<tr><td colspan="2" class="t4seperate"><hr /></td></tr>');
exception when others then null;
end;
null;
end;
/
prompt ...label templates
--
--application/shared_components/user_interface/templates/label/p32_optional_label_with_help
prompt ......label template 32443332494481752
begin
begin
wwv_flow_api.create_field_template (
p_id=> 32443332494481752 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'P32 Optional Label with Help',
p_template_body1=>'<label for="#CURRENT_ITEM_NAME#">'||chr(10)||
'<a class="t4OptionalLabelwithHelp" href="javascript:popupFieldHelp(''#CURRENT_ITEM_ID#'',''&SESSION.'')" tabindex="999">'||chr(10)||
'',
p_template_body2=>' "P32_LABEL"</a></label>',
p_on_error_before_label=>'<div class="t4InlineError">',
p_on_error_after_label=>'<br/>#ERROR_MESSAGE#</div>',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 1,
p_translate_this_template=> 'N',
p_template_comment=> '');
end;
null;
end;
/
--application/shared_components/user_interface/templates/label/no_label
prompt ......label template 71129707991453383
begin
begin
wwv_flow_api.create_field_template (
p_id=> 71129707991453383 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'No Label',
p_template_body1=>'<span class="t4NoLabel">',
p_template_body2=>'</span>',
p_on_error_before_label=>'<div class="t4InlineError">',
p_on_error_after_label=>'<br/>#ERROR_MESSAGE#</div>',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 13,
p_translate_this_template=> 'N',
p_template_comment=> '');
end;
null;
end;
/
--application/shared_components/user_interface/templates/label/optional_label
prompt ......label template 71129790826453388
begin
begin
wwv_flow_api.create_field_template (
p_id=> 71129790826453388 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'Optional Label',
p_template_body1=>'<label for="#CURRENT_ITEM_NAME#"><span class="t4OptionalLabel">',
p_template_body2=>'</span></label>',
p_on_error_before_label=>'<div class="t4InlineError">',
p_on_error_after_label=>'<br/>#ERROR_MESSAGE#</div>',
p_theme_id => wwv_flow.g_flow_theme_id,
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 71129916045453388
begin
begin
wwv_flow_api.create_field_template (
p_id=> 71129916045453388 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'Optional Label with Help',
p_template_body1=>'<label for="#CURRENT_ITEM_NAME#">'||chr(10)||
'<a class="t4OptionalLabelwithHelp" href="javascript:popupFieldHelp(''#CURRENT_ITEM_ID#'',''&SESSION.'')" tabindex="999">'||chr(10)||
'',
p_template_body2=>'</a></label>',
p_on_error_before_label=>'<div class="t4InlineError">',
p_on_error_after_label=>'<br/>#ERROR_MESSAGE#</div>',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 1,
p_translate_this_template=> 'N',
p_template_comment=> '');
end;
null;
end;
/
--application/shared_components/user_interface/templates/label/required_label
prompt ......label template 71130000454453389
begin
begin
wwv_flow_api.create_field_template (
p_id=> 71130000454453389 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'Required Label',
p_template_body1=>'<label for="#CURRENT_ITEM_NAME#"><span class="t4RequiredLabel">',
p_template_body2=>'</span></label>',
p_on_error_before_label=>'<div class="t4InlineError">',
p_on_error_after_label=>'<br/>#ERROR_MESSAGE#</div>',
p_theme_id => wwv_flow.g_flow_theme_id,
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 71130096047453389
begin
begin
wwv_flow_api.create_field_template (
p_id=> 71130096047453389 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_template_name=>'Required Label with Help',
p_template_body1=>'<label for="#CURRENT_ITEM_NAME#"><a class="t4RequiredLabelwithHelp" href="javascript:popupFieldHelp(''#CURRENT_ITEM_ID#'',''&SESSION.'')" tabindex="999">',
p_template_body2=>' *</a></label>',
p_on_error_before_label=>'<div class="t4InlineError">',
p_on_error_after_label=>'<br/>#ERROR_MESSAGE#</div>',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 2,
p_translate_this_template=> 'N',
p_template_comment=> '');
end;
null;
end;
/
prompt ...breadcrumb templates
--
--application/shared_components/user_interface/templates/breadcrumb/breadcrumb_menu
prompt ......template 71131009669453394
begin
begin
wwv_flow_api.create_menu_template (
p_id=> 71131009669453394 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=>'Breadcrumb Menu',
p_before_first=>'',
p_current_page_option=>'<img src="#WORKSPACE_IMAGES#black.gif" alt=""><a href="#LINK#" class="current">#NAME#</a>',
p_non_current_page_option=>'<img src="#WORKSPACE_IMAGES#black.gif" alt=""><a href="#LINK#" class="empty">#NAME#</a>',
p_menu_link_attributes=>'',
p_between_levels=>'&nbsp;&gt;&nbsp;',
p_after_last=>'',
p_max_levels=>12,
p_start_with_node=>'PARENT_TO_LEAF',
p_theme_id => wwv_flow.g_flow_theme_id,
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 71131117677453397
begin
begin
wwv_flow_api.create_menu_template (
p_id=> 71131117677453397 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_name=>'Hierarchical Menu',
p_before_first=>'<ul class="t4HierarchicalMenu">',
p_current_page_option=>'<li class="t4current"><a href="#LINK#">#NAME#</a></li>',
p_non_current_page_option=>'<li><a href="#LINK#">#NAME#</a></li>',
p_menu_link_attributes=>'',
p_between_levels=>'',
p_after_last=>'</ul>',
p_max_levels=>11,
p_start_with_node=>'CHILD_MENU',
p_theme_id => wwv_flow.g_flow_theme_id,
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 71131519566453400
begin
begin
wwv_flow_api.create_popup_lov_template (
p_id=> 71131519566453400 + 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=>'winlov',
p_page_title=>'Search Dialog',
p_page_html_head=>'<link rel="stylesheet" href="#IMAGE_PREFIX#themes/theme_4/theme_V2.css" type="text/css">'||chr(10)||
'',
p_page_body_attr=>'onload="first_field()" style="background-color:#FFFFFF;margin:0;"',
p_before_field_text=>'<div class="t4PopupHead">',
p_page_heading_text=>'The % wildcard can be used.',
p_page_footer_text =>'',
p_filter_width =>'20',
p_filter_max_width =>'100',
p_filter_text_attr =>'',
p_find_button_text =>'Search',
p_find_button_image=>'',
p_find_button_attr =>'',
p_close_button_text=>'Close',
p_close_button_image=>'',
p_close_button_attr=>'',
p_next_button_text =>'Next >',
p_next_button_image=>'',
p_next_button_attr =>'',
p_prev_button_text =>'< Previous',
p_prev_button_image=>'',
p_prev_button_attr =>'',
p_after_field_text=>'</div>',
p_scrollbars=>'1',
p_resizable=>'1',
p_width =>'400',
p_height=>'450',
p_result_row_x_of_y=>'<br /><div style="padding:2px; font-size:8pt;">Row(s) #FIRST_ROW# - #LAST_ROW#</div>',
p_result_rows_per_pg=>500,
p_before_result_set=>'<div class="t4PopupBody">',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 1,
p_translate_this_template => 'N',
p_after_result_set =>'</div>');
end;
null;
end;
/
prompt ...calendar templates
--
--application/shared_components/user_interface/templates/calendar/calendar
prompt ......template 71131217935453399
begin
begin
wwv_flow_api.create_calendar_template(
p_id=> 71131217935453399 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_cal_template_name=>'Calendar',
p_translate_this_template=> 'Y',
p_day_of_week_format=> '<th class="t4DayOfWeek">#IDAY#</th>',
p_month_title_format=> '<table cellspacing="0" cellpadding="0" border="0" summary="" class="t4CalendarHolder"> '||chr(10)||
' <tr>'||chr(10)||
' <td class="t4MonthTitle">#IMONTH# #YYYY#</td>'||chr(10)||
' </tr>'||chr(10)||
' <tr>'||chr(10)||
' <td>',
p_month_open_format=> '<table border="0" cellpadding="0" cellspacing="0" summary="0" class="t4Calendar">',
p_month_close_format=> '</table></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>'||chr(10)||
'',
p_day_title_format=> '<div class="t4DayTitle">#DD#</div>',
p_day_open_format=> '<td class="t4Day" valign="top">',
p_day_close_format=> '</td>',
p_today_open_format=> '<td valign="top" class="t4Today">',
p_weekend_title_format=> '<div class="t4WeekendDayTitle">#DD#</div>',
p_weekend_open_format => '<td valign="top" class="t4WeekendDay">',
p_weekend_close_format => '</td>',
p_nonday_title_format => '<div class="t4NonDayTitle">#DD#</div>',
p_nonday_open_format => '<td class="t4NonDay" valign="top">',
p_nonday_close_format => '</td>',
p_week_title_format => '',
p_week_open_format => '<tr>',
p_week_close_format => '</tr> ',
p_daily_title_format => '<th width="14%" class="calheader">#IDAY#</th>',
p_daily_open_format => '<tr>',
p_daily_close_format => '</tr>',
p_weekly_title_format => '<table cellspacing="0" cellpadding="0" border="0" summary="" class="t4WeekCalendarHolder">'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4MonthTitle" id="test">#WTITLE#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td>',
p_weekly_day_of_week_format => '<th class="t4DayOfWeek">#IDAY#<br>#MM#/#DD#</th>',
p_weekly_month_open_format => '<table border="0" cellpadding="0" cellspacing="0" summary="0" class="t4WeekCalendar">',
p_weekly_month_close_format => '</table></td></tr></table>',
p_weekly_day_title_format => '',
p_weekly_day_open_format => '<td class="t4Day" valign="top">',
p_weekly_day_close_format => '<br /></td>',
p_weekly_today_open_format => '<td class="t4Today" valign="top">',
p_weekly_weekend_title_format => '',
p_weekly_weekend_open_format => '<td valign="top" class="t4NonDay">',
p_weekly_weekend_close_format => '<br /></td>',
p_weekly_time_open_format => '<th class="t4Hour">',
p_weekly_time_close_format => '<br /></th>',
p_weekly_time_title_format => '#TIME#',
p_weekly_hour_open_format => '<tr>',
p_weekly_hour_close_format => '</tr>',
p_daily_day_of_week_format => '<th class="t4DayOfWeek">#IDAY# #DD#/#MM#</th>',
p_daily_month_title_format => '<table cellspacing="0" cellpadding="0" border="0" summary="" class="t4DayCalendarHolder"> <tr> <td class="t4MonthTitle">#IMONTH# #DD#, #YYYY#</td> </tr> <tr> <td>'||chr(10)||
'',
p_daily_month_open_format => '<table border="0" cellpadding="2" cellspacing="0" summary="0" class="t4DayCalendar">',
p_daily_month_close_format => '</table></td> </tr> </table>',
p_daily_day_title_format => '',
p_daily_day_open_format => '<td valign="top" class="t4Day">',
p_daily_day_close_format => '<br /></td>',
p_daily_today_open_format => '<td valign="top" class="t4Today">',
p_daily_time_open_format => '<th class="t4Hour">',
p_daily_time_close_format => '<br /></th>',
p_daily_time_title_format => '#TIME#',
p_daily_hour_open_format => '<tr>',
p_daily_hour_close_format => '</tr>',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 1,
p_reference_id=> null);
end;
null;
end;
/
--application/shared_components/user_interface/templates/calendar/calendar_alternative_1
prompt ......template 71131314629453400
begin
begin
wwv_flow_api.create_calendar_template(
p_id=> 71131314629453400 + 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=> 'Y',
p_day_of_week_format=> '<th class="t4DayOfWeek">#IDAY#</th>',
p_month_title_format=> '<table cellspacing="0" cellpadding="0" border="0" summary="" class="t4CalendarAlternative1Holder"> '||chr(10)||
' <tr>'||chr(10)||
' <td class="t4MonthTitle">#IMONTH# #YYYY#</td>'||chr(10)||
' </tr>'||chr(10)||
' <tr>'||chr(10)||
' <td>',
p_month_open_format=> '<table border="0" cellpadding="0" cellspacing="0" summary="0" class="t4CalendarAlternative1">',
p_month_close_format=> '</table></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>'||chr(10)||
'',
p_day_title_format=> '<div class="t4DayTitle">#DD#</div>',
p_day_open_format=> '<td class="t4Day" valign="top">',
p_day_close_format=> '</td>',
p_today_open_format=> '<td valign="top" class="t4Today">',
p_weekend_title_format=> '<div class="t4WeekendDayTitle">#DD#</div>',
p_weekend_open_format => '<td valign="top" class="t4WeekendDay">',
p_weekend_close_format => '</td>',
p_nonday_title_format => '<div class="t4NonDayTitle">#DD#</div>',
p_nonday_open_format => '<td class="t4NonDay" valign="top">',
p_nonday_close_format => '</td>',
p_week_title_format => '',
p_week_open_format => '<tr>',
p_week_close_format => '</tr> ',
p_daily_title_format => '<th width="14%" class="calheader">#IDAY#</th>',
p_daily_open_format => '<tr>',
p_daily_close_format => '</tr>',
p_weekly_title_format => '<table cellspacing="0" cellpadding="0" border="0" summary="" class="t4WeekCalendarAlternative1Holder">'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4MonthTitle" id="test">#WTITLE#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td>',
p_weekly_day_of_week_format => '<th class="t4DayOfWeek">#IDAY#<br>#MM#/#DD#</th>',
p_weekly_month_open_format => '<table border="0" cellpadding="0" cellspacing="0" summary="0" class="t4WeekCalendarAlternative1">',
p_weekly_month_close_format => '</table></td></tr></table>',
p_weekly_day_title_format => '',
p_weekly_day_open_format => '<td class="t4Day" valign="top">',
p_weekly_day_close_format => '<br /></td>',
p_weekly_today_open_format => '<td class="t4Today" valign="top">',
p_weekly_weekend_title_format => '',
p_weekly_weekend_open_format => '<td valign="top" class="t4NonDay">',
p_weekly_weekend_close_format => '<br /></td>',
p_weekly_time_open_format => '<th class="t4Hour">',
p_weekly_time_close_format => '<br /></th>',
p_weekly_time_title_format => '#TIME#',
p_weekly_hour_open_format => '<tr>',
p_weekly_hour_close_format => '</tr>',
p_daily_day_of_week_format => '<th class="t4DayOfWeek">#IDAY# #DD#/#MM#</th>',
p_daily_month_title_format => '<table cellspacing="0" cellpadding="0" border="0" summary="" class="t4DayCalendarAlternative1Holder"> <tr><td class="t4MonthTitle">#IMONTH# #DD#, #YYYY#</td></tr><tr><td>'||chr(10)||
'',
p_daily_month_open_format => '<table border="0" cellpadding="2" cellspacing="0" summary="0" class="t4DayCalendarAlternative1">',
p_daily_month_close_format => '</table></td> </tr> </table>',
p_daily_day_title_format => '',
p_daily_day_open_format => '<td valign="top" class="t4Day">',
p_daily_day_close_format => '<br /></td>',
p_daily_today_open_format => '<td valign="top" class="t4Today">',
p_daily_time_open_format => '<th class="t4Hour">',
p_daily_time_close_format => '<br /></th>',
p_daily_time_title_format => '#TIME#',
p_daily_hour_open_format => '<tr>',
p_daily_hour_close_format => '</tr>',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 2,
p_reference_id=> null);
end;
null;
end;
/
--application/shared_components/user_interface/templates/calendar/small_calendar
prompt ......template 71131416867453400
begin
begin
wwv_flow_api.create_calendar_template(
p_id=> 71131416867453400 + wwv_flow_api.g_id_offset,
p_flow_id=> wwv_flow.g_flow_id,
p_cal_template_name=>'Small Calendar',
p_translate_this_template=> 'Y',
p_day_of_week_format=> '',
p_month_title_format=> '<table cellspacing="0" cellpadding="0" border="0" summary="" class="t4SmallCalenderHolder"> '||chr(10)||
' <tr>'||chr(10)||
' <td class="t4MonthTitle">#IMONTH# #YYYY#</td>'||chr(10)||
' </tr>'||chr(10)||
' <tr>'||chr(10)||
' <td>',
p_month_open_format=> '<table border="0" cellpadding="0" cellspacing="0" summary="0" class="t4SmallCalender">',
p_month_close_format=> '</table></td>'||chr(10)||
'</tr>'||chr(10)||
'</table>'||chr(10)||
'',
p_day_title_format=> '<div class="t4DayTitle">#DD#</div>',
p_day_open_format=> '<td class="t4Day" valign="top">',
p_day_close_format=> '</td>',
p_today_open_format=> '<td valign="top" class="t4Today">',
p_weekend_title_format=> '<div class="t4WeekendDayTitle">#DD#</div>',
p_weekend_open_format => '<td valign="top" class="t4WeekendDay">',
p_weekend_close_format => '</td>',
p_nonday_title_format => '<div class="t4NonDayTitle">#DD#</div>',
p_nonday_open_format => '<td class="t4NonDay" valign="top">',
p_nonday_close_format => '</td>',
p_week_title_format => '',
p_week_open_format => '<tr>',
p_week_close_format => '</tr> ',
p_daily_title_format => '<th width="14%" class="calheader">#IDAY#</th>',
p_daily_open_format => '<tr>',
p_daily_close_format => '</tr>',
p_weekly_title_format => '<table cellspacing="0" cellpadding="0" border="0" summary="" class="t4SmallWeekCalendarHolder">'||chr(10)||
'<tr>'||chr(10)||
'<td class="t4MonthTitle" id="test">#WTITLE#</td>'||chr(10)||
'</tr>'||chr(10)||
'<tr>'||chr(10)||
'<td>',
p_weekly_day_of_week_format => '<th class="t4DayOfWeek">#IDAY#<br />#MM#/#DD#</th>',
p_weekly_month_open_format => '<table border="0" cellpadding="0" cellspacing="0" summary="0" class="t4SmallWeekCalendar">',
p_weekly_month_close_format => '</table></td></tr></table>',
p_weekly_day_title_format => '',
p_weekly_day_open_format => '<td class="t4Day" valign="top">',
p_weekly_day_close_format => '<br /></td>',
p_weekly_today_open_format => '<td class="t4Today" valign="top">',
p_weekly_weekend_title_format => '',
p_weekly_weekend_open_format => '<td valign="top" class="t4NonDay">',
p_weekly_weekend_close_format => '<br /></td>',
p_weekly_time_open_format => '<th class="t4Hour">',
p_weekly_time_close_format => '<br /></th>',
p_weekly_time_title_format => '#TIME#',
p_weekly_hour_open_format => '<tr>',
p_weekly_hour_close_format => '</tr>',
p_daily_day_of_week_format => '<th class="t4DayOfWeek">#IDAY# #DD#/#MM#</th>',
p_daily_month_title_format => '<table cellspacing="0" cellpadding="0" border="0" summary="" class="t4SmallDayCalendarHolder"> <tr> <td class="t4MonthTitle">#IMONTH# #DD#, #YYYY#</td> </tr><tr><td>'||chr(10)||
'',
p_daily_month_open_format => '<table border="0" cellpadding="2" cellspacing="0" summary="0" class="t4SmallDayCalendar">',
p_daily_month_close_format => '</table></td></tr></table>',
p_daily_day_title_format => '',
p_daily_day_open_format => '<td valign="top" class="t4Day">',
p_daily_day_close_format => '<br /></td>',
p_daily_today_open_format => '<td valign="top" class="t4Today">',
p_daily_time_open_format => '<th class="t4Hour">',
p_daily_time_close_format => '<br /></th>',
p_daily_time_title_format => '#TIME#',
p_daily_hour_open_format => '<tr>',
p_daily_hour_close_format => '</tr>',
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_class_id => 3,
p_reference_id=> null);
end;
null;
end;
/
prompt ...application themes
--
--application/shared_components/user_interface/themes/national_grid
prompt ......theme 71131715554453408
begin
wwv_flow_api.create_theme (
p_id =>71131715554453408 + wwv_flow_api.g_id_offset,
p_flow_id =>wwv_flow.g_flow_id,
p_theme_id => wwv_flow.g_flow_theme_id,
p_theme_name=>'National Grid',
p_default_page_template=>71114788560453355 + wwv_flow_api.g_id_offset,
p_error_template=>85292499999520701 + wwv_flow_api.g_id_offset,
p_printer_friendly_template=>71116307709453357 + wwv_flow_api.g_id_offset,
p_breadcrumb_display_point=>'REGION_POSITION_01',
p_sidebar_display_point=>'REGION_POSITION_02',
p_login_template=>71114617743453322 + wwv_flow_api.g_id_offset,
p_default_button_template=>71130218387453389 + wwv_flow_api.g_id_offset,
p_default_region_template=>71121389039453369 + wwv_flow_api.g_id_offset,
p_default_chart_template =>71118718898453364 + wwv_flow_api.g_id_offset,
p_default_form_template =>71118991564453364 + wwv_flow_api.g_id_offset,
p_default_reportr_template =>71121389039453369 + wwv_flow_api.g_id_offset,
p_default_tabform_template=>71121389039453369 + wwv_flow_api.g_id_offset,
p_default_wizard_template=>71122912959453369 + wwv_flow_api.g_id_offset,
p_default_menur_template=>71117787921453364 + wwv_flow_api.g_id_offset,
p_default_listr_template=>71121389039453369 + wwv_flow_api.g_id_offset,
p_default_report_template =>71124395124453374 + wwv_flow_api.g_id_offset,
p_default_label_template=>71129916045453388 + wwv_flow_api.g_id_offset,
p_default_menu_template=>71131009669453394 + wwv_flow_api.g_id_offset,
p_default_calendar_template=>71131217935453399 + wwv_flow_api.g_id_offset,
p_default_list_template=>71129089840453382 + wwv_flow_api.g_id_offset,
p_default_option_label=>71129916045453388 + wwv_flow_api.g_id_offset,
p_default_required_label=>71130096047453389 + wwv_flow_api.g_id_offset);
end;
/
begin
wwv_flow_api.g_varchar2_table := wwv_flow_api.empty_varchar2_table;
wwv_flow_api.g_varchar2_table(1) := '474946383961C8002B00F70000126EAA3D88B9F1F6FA4890BECEE0ED0061A2D9E6F1AECDE2D0E2EEF6F9FC0A6BA8B5D1E48DB9D694BDD8458DBDA1C5DD00589DF8FAFCA5C6DE66A1C8A9CAE0297CB2ACCBE13A86B8B0CEE2FBFCFD0568A60A66A579ACCE';
wwv_flow_api.g_varchar2_table(2) := 'DEEAF38AB7D5A5C8DF257AB10968A6F4F8FAEEF4F87EB0D0CADEECD6E5F09AC1DB1D75AE99BFDAE2ECF4005DA05D9CC5005C9E0465A4C9DDEA287BB2DAE8F1FCFDFEF0F6F9F2F7FA6EA4CAE8F0F7BAD4E672A8CC6AA4CAB8D4E60066A5F6FAFC5498C291';
wwv_flow_api.g_varchar2_table(3) := 'BBD7C4DAE9599AC46DA2C84D8EBDDCE8F2F5F8FB87B5D41A74AD4C91BF69A1C985B4D3004C96005099D4E4EF00549A1672AD0F6EAA2278B03182B55496C2619DC6A8C8DFE0EAF380B2D270A7CB0063A42177AF1170ABBCD6E7428CBC83B3D33683B7B8D3';
wwv_flow_api.g_varchar2_table(4) := 'E5EBF3F8F2F6F980ACCE0366A55898C33F8ABB0060A19FC3DCBED6E85E95C2C1D9E8E5EEF574AACE00569B629FC6EDF3F8EAF1F6FDFEFE0C6AA81570ABC6DCEAF0F5F93685B75094C1A6C8DEE7EFF6E9EFF61973AD0461A20364A45E99C35296C2FAFBFD';
wwv_flow_api.g_varchar2_table(5) := '7BAED0E6EEF474A8CC6FA5CB609EC6458BBB2C7DB30262A30F6CA9267CB3F4F9FC317EB380B0D19FC5DDDCE8F19CC2DB2D7FB4629FC7C2D9E9BFD8E8C0D7E85396C1418CBCFCFCFDECF1F82E80B4DCEAF277ABCD6CA5CACCDFECC2D8E9B2CFE34E94C083';
wwv_flow_api.g_varchar2_table(6) := 'B5D33985B83684B80C6CA80B6CA86DA7CB5193C00266A62B7EB31370AB0E6EA90065A50065A40064A40063A3005B9E005EA0005A9EDFE9F30062A3005FA1FFFFFE74AACD5196C2005B9F0064A3DEE9F3FEFEFFC2DAEAFEFEFE0062A2005EA1005A9D0059';
wwv_flow_api.g_varchar2_table(7) := '9D005A9F005FA0F3F8FAFEFFFE005FA2EBF2F7FFFEFEF7F9FC80B2D10165A50064A5DEE9F2FEFFFFFEFEFD649FC75196C1C0D7E7E4EDF5E5EFF60D6EA90265A480AFD0F4F7FADEE8F11774AE6FA8CB5091BF428BBCF8FBFC458FBD0263A3BAD6E600589B';
wwv_flow_api.g_varchar2_table(8) := 'FFFEFF5B9BC598C1DB2578B0699EC6D3E4EFD3E3EEB8D4E580B1D1ABCCE182B1D183B2D20F63A3609CC685B3D3DFE9F2B3D0E41F77AFE7F0F676A9CC0769A75495C1E3ECF30161A20162A3A5C9DFFFFFFF21F90400000000002C00000000C8002B000008';
wwv_flow_api.g_varchar2_table(9) := 'FF00FF091C48B0A0C18308132A5CC8B0A1C38710234A9C48B1A2C58B18336AAC3828D0C68F20438A1C19F1D6BF086E6CAD2044B2A5CB97302972D2F5EA952D7831731E1BF82BA74F911158C87AD5AA15961545A03D34F933E23163758C456B8A314CD49F';
wwv_flow_api.g_varchar2_table(10) := '3238D8C252B49619481065547946EFD9366D4D7B2AB414EF0E53AA14977989D7836A03335860699010518091100A146CC0909640110F1D0E3A68F30DAEC565202084830B6FC50A061267983203AB962D0A547D34D1B5403163C71597C19835C071BB2413';
wwv_flow_api.g_varchar2_table(11) := '673CA9E5CA55010B5453AC78A5E3205BB7A827AA661D3CF61358AD5C99C1DD54376F83BFA08A985A1CE2F0D6D521CAAED5EAD5F2DCBB7B17FF2C375059F687AA63613FDF5036ACDAB711261BF2088E0C87753A18E83062A184DD745044C43EFB85115104';
wwv_flow_api.g_varchar2_table(12) := '2A1850050D0E1121480C31E4114142E9AD57D0085FF8D00E330DFC90C13F323C13C310107E289000230E61800A3DCD604111D9DC3050072F9460630C6F1124C00D3E30C38C0F9F4CE81E7C1644E0811832FE43811089E493CF13A37890C03F390E444403';
wwv_flow_api.g_varchar2_table(13) := '0ECC918F06F9CC61C8198014F44136CC1C51802B2C58A1E62602DDF281180F9867D00B3540A1800621ECA10F066A15748318A2F40746203084A0810246F89124429F4C60A79372C080C33A541674DD41EEA053CB0AC4CCB2421F01A89001378085B04A15';
wwv_flow_api.g_varchar2_table(14) := '03511002601B04F08F0951D8FFA2CB12390C240D1F1A68C0475D06D503032C9C12B382385E9810C771C9DD56C72B4A5C91C104B3B481572DBA10D3C205311C648217BAB4B10216AF14100B042B5C6203415128D1C42C3BEC304C134B3441D83FC704A0C4';
wwv_flow_api.g_varchar2_table(15) := '285566D0880B100C530016D442604B28E71694831266E8F1033A4DC452CB2BC8CC124B3F1E1C244320E24030CBBFB0D832CC30001C60D0A5051561861944B5B2432BBBB410AA167815900F2D037D604B2D58C872411E30B440540BB80C244F2CB0BCD2C2';
wwv_flow_api.g_varchar2_table(16) := '1D06F9C08F19B525E78AD18710E0C47BB65940C313B1E4D0030428B4034A250B300083AC762C53100259CCE2020B0FDC404D3D0D9421EE00130AD485379644018B3301E4FF32CD34040C3400040E140407172BC48242171850B3400301ACD0020C4C1484';
wwv_flow_api.g_varchar2_table(17) := 'CB307350310704A19C704325149CA28119B6544CD0323D48AE0A035FDFF00121F9ACE00273032D530171049D80086D4575F78A2B3BC8C285164461A100CD027D70662B059481842C3BD4A64BD0024DB1822BADC8924B4114F4C1DDCA4F83AB9C3D0AFC5E';
wwv_flow_api.g_varchar2_table(18) := 'F5D50518E1F21A05DD134031B2F84350065CCCD2C707066520852C2B8056906EBB18C740DE32B8C211A413C390C51112439008E0A01FB308C09406828B5828000566288241CE210E5B68A16002C1C00A64818A64186401729845197A71BAD558C8047258';
wwv_flow_api.g_varchar2_table(19) := '5E2B80D58CD1D9C215B570C6CA8C87BC7F280F7BAF008006FF7E073008E06020D62B8AF608A2823998217AD11B8A06B2078BA215255C569BCD0ABC004282BCC005BA08050B05528266ACA01B08E9C01366C12B8200705104292041A8C08F16D00D2145B0';
wwv_flow_api.g_varchar2_table(20) := '05D008820B9FADC00708C9C10A8031AF7FF4A207B340471D101288583CA18B2413C8045A10BD19CA21106828C103BEC1B4E4CCF078352B40CA6A020C5B28801B00C8061257A0C4ED0D0407B1C01ECBB031817A94E006F048043056D69DDBA0AF0F954048';
wwv_flow_api.g_varchar2_table(21) := '0654B10223886020909016A51072895844A26E03718E780A2247814440132D90C3320F1201629A4205146C81194030418298A404636801664E648A25002121EE28402A5E70BA0AA86720E0004101DAA5FF9C07343000B228CA0E60014A81F8439445B10D';
wwv_flow_api.g_varchar2_table(22) := '0A18C00B1AD020024C4962F65C09A228300D7BC1E88298C4B18B84FAF209B288C27D10C2825898A21A03B1801058004D8384231630309B1B57B08B69C6917003F9C12B5670448550A000B6F0A7402A280B0D2284064E2007330692873F08812F08C18019';
wwv_flow_api.g_varchar2_table(23) := '5A318916DE532004D0C07BB2E7803814840989408E2B7838908312C5363060A04124BA44813C430158C09E19344104834CA018D83B1FD6CCA1101CCC4201BC18885214B28939D822A6FF0BCF41AAF98F73C8AE040BA101378671050ACE22156A48080F22';
wwv_flow_api.g_varchar2_table(24) := '5359818C512124A0A42FEA89BB7F9CE186DD3183500BC282EB8DB5A03E44682B56608584FF24D1156DFD070668539B1598AE20E83CEB4787710A85300302B035880C0460821BA4800D8A304301103BD3E71884B1B880803DCA99102E0CA30C2365C33014';
wwv_flow_api.g_varchar2_table(25) := 'F088847413022C494802D640072A24E10F21A8452A465BBBDBADA70BC4A80D2CF26180833CA09304EDE10FBB33861FD89695B8A5A80F5CBB8B021F440428A00D16AF360C3628C40AE3EDE140D6000924D8C1096330C33096B0020D4C57A6D154EC75712A';
wwv_flow_api.g_varchar2_table(26) := '102040C00E2355081084818EBAFE03177F55AB41225001F40E502080D842238E800E05C022164D68C22B9A31DF16961607BA280A2C56C120835062075C097028B1A76584580F7BB915450BB8AC005419041016ED651621403D845801FFB91A1E0227E6A0';
wwv_flow_api.g_varchar2_table(27) := '8B86356315AA70801BCEC085C9A15820D25C2C8BFF7107080460270B91C4308C50E5CB25B7203CF6313E21318A02B4A10D0550803D2E60894624C105ADA0AF4022898331B7A216DC58C4417C910A22C2D6AC9F0CAC975939D181882296AE80052B4C98BF';
wwv_flow_api.g_varchar2_table(28) := '0BD842CD5763F385333C1013EC2116C3D883242440803A80632047100675536C5D6A0E9A0C10B8408C13C2826140C1C68ED630A47B9C5E49B64018B52883076E9007228C140DB411F53F6C575A2BE8227AB5B8461E0E7200DE76F91F0725B3AC0F92C4E0';
wwv_flow_api.g_varchar2_table(29) := '2998D6BBE0EF4132E0858B0EB7CD0779734165408658B82007E05C2C4CFFFC8F40AFD880FFB80204A0C07183F4C201C3FF08C0481D3DF01D937B2012805F246EF059822C20DEA45DCF097EFD34717CE120ED70EDBF95471482B6BC206CA5A8051E569B5A';
wwv_flow_api.g_varchar2_table(30) := '14922034300277F43A0C881B44E2C85BC71862C1D7EE6E3CB1351534C81BD0020D6C13214440C1306A3554622324D2E9CD801D5AB08A21C073AAF28EA427C640941DACA0EBA753C4995E2B60841AFDC0B5C96D0CF2C195D94AE22037281A91286CF58260';
wwv_flow_api.g_varchar2_table(31) := '5D20783819FE1002072714A3021C07A04D0537684AECD4230A010522560096B63FBA812FFFC70CB4100B3220C4241E58C10EF2EEC28124000A83C74208324B9076A0F693852F3A600FDC4A7C56A0005D49049B2AF58F0438A018E07BF885E12C901304A3';
wwv_flow_api.g_varchar2_table(32) := '00224308FF03645100D027B6DA3705790214B18227D85D98A458413ECAEBFAA3C35ED223B8C62CA4911022A8C2164D563B30705502E106A6E60AC030070D600D34400048000BBBD02EC8174ABF43503A8674D76370045108A6D60AC1E000201414BAC74F';
wwv_flow_api.g_varchar2_table(33) := 'DA971097F70F37170B1676106000052B507E61525D5B207604D10092037806F15FB380832C675EB117752B607E07810F2D000BA91020024880FFA0067D801C2A030C66F0044EA001B2B00B293350B04574B9B67CB3063CC1300D04F105FFA232AD600B20';
wwv_flow_api.g_varchar2_table(34) := '9004EE450A28D33413F60415B67D05F50628200B73400906F1058C100276200B4EF00605F100B6200BBF957E04010896403439E08705E10389E04CFBFF4641E37581F7975EBD2009B1600B9D601060D00D2D90050AC00FAB356FBD47100CC019BD736A38';
wwv_flow_api.g_varchar2_table(35) := 'D30AC0900853348106254A5B687FABD47C0421482A031F2FB802C88080B2D4866F6882DC271045300CB690080C450336500F92D0074DC00090100BBB600839C06BFF4000E102004540050DA0568C2510D50002B1100B9AF0001D808CA0300DB2100B7280';
wwv_flow_api.g_varchar2_table(36) := '8490C885DC147BFFB00E89600B05A00F6820000280000C00026D600F37700D66C00D7E107E91341013B00278758ACEB00228E001F9503C59387887376BB43810221005B3F00AE0F334DDB10201000262751B33900A4B90890911084B000BEFF70F343001';
wwv_flow_api.g_varchar2_table(37) := 'E2227F5AA00005D0042E400232500D7BFFF02EB1606620D209BA100BC2302E8554064B700106A1026E500010200BF9B00AA5A094D7025905D10929B99206C10328B00413607300108EB5A0054F900AD1320AFDC502B300014A4002A3969565A05C14E005';
wwv_flow_api.g_varchar2_table(38) := '05D00223A40BB6C00804A0531AF96F8E0001B1706EB560950541064D20974D301903B1131D4006B6100C385345B2D0022C600D5000012D302E54900048900654A010189006139009056101012007D133060070045525109E800FF2100855261032C0000E';
wwv_flow_api.g_varchar2_table(39) := '700830300A9ED0260C90061E502521840A00C0773BA000A3700236664E54E09970901080C001690055C586047B3044AE100215E00102604D293005E94007269101CCB94E23F3051CFF000496100454C020ECF03458A8569E50038440083530088A781012';
wwv_flow_api.g_varchar2_table(40) := '1004EF19049050733067080000290100093D310FEE099F04C09B111107D5400025A00ED4E81011100198F0636D921099C0042580006B305255F21606DA1075600225E00955F06CD4674E16E17DD8F395339011FA491036C0044CB0065E55A2EC51A31F01';
wwv_flow_api.g_varchar2_table(41) := '0814200154400512501A064106B45600516022365AA446CA10340000E45700C1100208C03D21D0772DC076475AA5564A10BFD06735112EF6C00154A00367C00263E084BB600B3F77A5686AA5EEC007FB941C9B020CAEA0121A293D035072697AA7E7F100';
wwv_flow_api.g_varchar2_table(42) := '2EF02D09B5A540246247709D783AA8367A0086100272890C0500548F2B090B30C001AF49A8925A1C72B20E0C000417500187100052F00E3760631D3AA9A20A1732F0A0336AA40101003B';
end;
/
begin
wwv_flow_api.create_theme_image(
p_id =>71131715554453408 + wwv_flow_api.g_id_offset,
p_flow_id =>wwv_flow.g_flow_id,
p_theme_id => wwv_flow.g_flow_theme_id,
p_varchar2_table=> wwv_flow_api.g_varchar2_table,
p_mimetype=> '');
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
Reference in New Issue View Git Blame Copy Permalink