APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on HTP

Line 894: htp.p('Error: '||SQLERRM);

890: where user_id = g_user_id
891: and plug_id = p_plug_id;
892: EXCEPTION
893: WHEN OTHERS THEN
894: htp.p('Error: '||SQLERRM);
895: END;
896: ELSE
897:
898: -- =======================

Line 923: htp.p('');

919: -- =======================
920: -- Begin Main block
921: -- =======================
922: -- Banner
923: htp.p('

');
924: htp.p('

'); 925: 926: 927: -- meastmon 09/07/2001 Fix bug#1980577. Workaround Do not encrypt plug_id Line 924: htp.p('

'); 920: -- Begin Main block 921: -- ======================= 922: -- Banner 923: htp.p(''); 924: htp.p(''); 929: 'OA_HTML/OA.jsp?page=/oracle/apps/bis/pmf/pmportlet/pages/BISPMFSETINDICATORS&retainAM=Y&oapc=3&Z='||p_plug_id 930: , 'FNDINDIC.gif'); 931: 932: 933: htp.p(''); 934: htp.p(' '); 925: 926: 927: -- meastmon 09/07/2001 Fix bug#1980577. Workaround Do not encrypt plug_id 928: icx_plug_utilities.plugbanner(p_display_name, Line 933: htp.p(' '); 935: 936: draw_portlet_header(l_status_lbl 937: ,l_measure_lbl Line 934: htp.p('

');

930: , 'FNDINDIC.gif');
931:
932:
933: htp.p('');
934: htp.p('');
935:
936: draw_portlet_header(l_status_lbl
937: ,l_measure_lbl
938: ,l_value_lbl

Line 949: htp.p(' ');

945: --
946: l_row_style := 'Band';
947:
948: FOR csel in c_selections LOOP
949: htp.p(' ');
950: l_target_rec.target_level_id := csel.target_level_id;
951: l_target_rec.plan_id := csel.plan_id;
952:
953: l_target_rec.dim1_level_value_id := csel.dimension1_level_value;

Line 1054: htp.p(' ');

1050: draw_change(l_change_lbl,
1051: TO_CHAR(l_change)||l_perc_lbl,l_img,l_arrow_alt_text,l_row_style);
1052: END IF;
1053: END IF; -- (l_actual_value IS NULL)
1054: htp.p(' ');
1055:
1056:
1057: EXCEPTION
1058: WHEN e_notimevalue THEN

Line 1074: htp.p(' ');

1070:
1071:
1072: END; -- end of block containing the c_notimelevels cursor
1073:
1074: htp.p(' ');
1075:
1076: END LOOP; -- end of c_selections loop
1077: draw_portlet_footer;
1078:

Line 1087: htp.p(SQLERRM);

1083: EXCEPTION
1084: WHEN NO_DATA_FOUND THEN
1085: NULL;
1086: WHEN OTHERS THEN
1087: htp.p(SQLERRM);
1088: END DISPLAY;
1089:
1090: -- ************************************************************
1091: -- Show Demo URL for Portlal

Line 1267: -- htp.p('g_user_id '||g_user_id||'
');

1263: , x_Error_Tbl => l_error_tbl
1264: );
1265:
1266: -- /*********** For DEBUGGING **************
1267: -- htp.p('g_user_id '||g_user_id||'
');
1268: -- htp.p('g_plug_id '||l_plug_id||'
');
1269: -- for i in 1 .. l_indicators_tbl.COUNT loop
1270: -- htp.p('l_indicators_tbl(i).target_level_name: '||
1271: -- l_indicators_tbl(i).target_level_name||'
');

Line 1268: -- htp.p('g_plug_id '||l_plug_id||'
');

1264: );
1265:
1266: -- /*********** For DEBUGGING **************
1267: -- htp.p('g_user_id '||g_user_id||'
');
1268: -- htp.p('g_plug_id '||l_plug_id||'
');
1269: -- for i in 1 .. l_indicators_tbl.COUNT loop
1270: -- htp.p('l_indicators_tbl(i).target_level_name: '||
1271: -- l_indicators_tbl(i).target_level_name||'
');
1272: -- end loop;

Line 1270: -- htp.p('l_indicators_tbl(i).target_level_name: '||

1266: -- /*********** For DEBUGGING **************
1267: -- htp.p('g_user_id '||g_user_id||'
');
1268: -- htp.p('g_plug_id '||l_plug_id||'
');
1269: -- for i in 1 .. l_indicators_tbl.COUNT loop
1270: -- htp.p('l_indicators_tbl(i).target_level_name: '||
1271: -- l_indicators_tbl(i).target_level_name||'
');
1272: -- end loop;
1273: -- ************************************************/
1274:

Line 3379: when others then --htp.p(SQLERRM);

3375: -- end if; -- icx_validatePlugsession
3376: --end if; -- icx_validateSession
3377:
3378: exception
3379: when others then --htp.p(SQLERRM);
3380: --x_string1 := SQLERRM;
3381: --x_string2 := NULL;
3382: WF_NOTIFICATION.NewClob(l_str_object,SQLERRM);
3383: x_str_object := l_str_object;

Line 3631: -- htp.p(l_indlevel_id||'*'||l_d0||'*'||l_d1||'*'||l_d2||'*'||

3627:
3628: g_var1 := l_d0;
3629:
3630: -- ************** Debug stuff ****************************
3631: -- htp.p(l_indlevel_id||'*'||l_d0||'*'||l_d1||'*'||l_d2||'*'||
3632: -- l_d3||'*'||l_d4||'*'||l_d5||'*'||l_plan);
3633: -- htp.p('
*****************************************************
');
3634:
3635: -- Get all the previously selected labels from

Line 3633: -- htp.p('
*****************************************************
');

3629:
3630: -- ************** Debug stuff ****************************
3631: -- htp.p(l_indlevel_id||'*'||l_d0||'*'||l_d1||'*'||l_d2||'*'||
3632: -- l_d3||'*'||l_d4||'*'||l_d5||'*'||l_plan);
3633: -- htp.p('
*****************************************************
');
3634:
3635: -- Get all the previously selected labels from
3636: -- selections table.
3637: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections

Line 4915: --htp.p(SQLERRM);

4911: x_string := l_string;
4912:
4913: exception
4914: when others then
4915: --htp.p(SQLERRM);
4916: x_string := SQLERRM;
4917:
4918: end editDimensions;
4919:

Line 5029: -- htp.p('p_display_label_tbl '||p_displaylabels_tbl(i)||'
');

5025:
5026:
5027: --
5028: -- ****************************** Debug stuff ***************
5029: -- htp.p('p_display_label_tbl '||p_displaylabels_tbl(i)||'
');
5030: -- htp.p('
'||l_indlevel_id||'*'||l_d0||'*'||l_d1||'*'||l_d2||'*'
5031: -- ||l_d3||'*'||l_d4||
5032: -- '*'||l_d5||'*'||l_plan||'*'||l_display_label||'
');
5033: -- ***********************************************************

Line 5030: -- htp.p('
'||l_indlevel_id||'*'||l_d0||'*'||l_d1||'*'||l_d2||'*'

5026:
5027: --
5028: -- ****************************** Debug stuff ***************
5029: -- htp.p('p_display_label_tbl '||p_displaylabels_tbl(i)||'
');
5030: -- htp.p('
'||l_indlevel_id||'*'||l_d0||'*'||l_d1||'*'||l_d2||'*'
5031: -- ||l_d3||'*'||l_d4||
5032: -- '*'||l_d5||'*'||l_plan||'*'||l_display_label||'
');
5033: -- ***********************************************************
5034:

Line 5060: -- htp.p('respid :'||l_resp_id);

5056: x_return_status => l_return_status,
5057: x_error_Tbl => l_error_tbl);
5058:
5059: -- ********* Debug stuff ********************
5060: -- htp.p('respid :'||l_resp_id);
5061: -- htp.p('tarid :'||l_tar_id);
5062: -- htp.p('orgid :'||l_org_id);
5063: -- htp.p('disp :'||l_disp);
5064: -- *******************************************

Line 5061: -- htp.p('tarid :'||l_tar_id);

5057: x_error_Tbl => l_error_tbl);
5058:
5059: -- ********* Debug stuff ********************
5060: -- htp.p('respid :'||l_resp_id);
5061: -- htp.p('tarid :'||l_tar_id);
5062: -- htp.p('orgid :'||l_org_id);
5063: -- htp.p('disp :'||l_disp);
5064: -- *******************************************
5065:

Line 5062: -- htp.p('orgid :'||l_org_id);

5058:
5059: -- ********* Debug stuff ********************
5060: -- htp.p('respid :'||l_resp_id);
5061: -- htp.p('tarid :'||l_tar_id);
5062: -- htp.p('orgid :'||l_org_id);
5063: -- htp.p('disp :'||l_disp);
5064: -- *******************************************
5065:
5066: end loop; -- loop for the input plsql table

Line 5063: -- htp.p('disp :'||l_disp);

5059: -- ********* Debug stuff ********************
5060: -- htp.p('respid :'||l_resp_id);
5061: -- htp.p('tarid :'||l_tar_id);
5062: -- htp.p('orgid :'||l_org_id);
5063: -- htp.p('disp :'||l_disp);
5064: -- *******************************************
5065:
5066: end loop; -- loop for the input plsql table
5067:

Line 5134: when others then htp.p(SQLERRM);

5130: x_unique_tbl := l_temp_tbl; -- Transfer the uniques out NOCOPY
5131: END IF; -- To check if the extra parameter p_value is null or not
5132:
5133: exception
5134: when others then htp.p(SQLERRM);
5135:
5136: end removeDuplicates;
5137:
5138: PROCEDURE clearSelect(

Line 5185: htp.p(SQLERRM);

5181: x_clearString := l_clear;
5182:
5183: EXCEPTION
5184: WHEN OTHERS THEN
5185: htp.p(SQLERRM);
5186:
5187: END clearSelect;
5188:
5189: PROCEDURE SetSetOfBookVar(

Line 5231: htp.p(SQLERRM);

5227: x_sobString := l_sobString;
5228:
5229: EXCEPTION
5230: WHEN OTHERS THEN
5231: htp.p(SQLERRM);
5232: END SetSetOfBookVar;
5233:
5234: -- mdamle 01/12/2001 Get Performance Measure + Dim Level info
5235: function getPerformanceMeasureName(

Line 5648: htp.p(HTML_Banner);

5644: , FALSE
5645: , FALSE
5646: , HTML_Banner
5647: );
5648: htp.p(HTML_Banner);
5649:
5650: end Build_HTML_Banner;
5651:
5652: PROCEDURE build_html_banner ------------- VERSION 2 (definition of)

Line 6014: htp.p('');

6015: ---
6016: icx_admin_sig.help_win_script(help_target||'TOP', NULL , 'BIS');
6017: --- HACK TO circumvent target slection withing a help file:
6018: --- icx_admin_sig.help_win_script('/OA_DOC/' || help_target ||'?', nls_language_code, 'BIS');
6019: htp.p('');
6020:
6021: --- --- --- This part used to call the ICX banner builder.
6022: --- icx_plug_utilities.toolbar(
6023: --- p_text => title

Line 6038: htp.p(HTML_Banner);

6034: , FALSE
6035: , icon_show
6036: , HTML_Banner
6037: );
6038: htp.p(HTML_Banner);
6039:
6040: end Build_HTML_Banner;
6041:
6042: PROCEDURE Build_HTML_Banner

Line 6902: htp.p('');

Line 6917: htp.p('.OraPortletTableCellNumberBand {font-family:Arial, Helvetica, Geneva, sans-serif; font-size:9pt; text-align:right;

6913: htp.p('.OraPortletBodyTextGreen { FONT-FAMILY: Arial, Helvetica, Geneva, sans-serif; FONT-SIZE: 9pt; color: #009900}');
6914: htp.p('.OraPortletBodyTextRed { FONT-FAMILY: Arial, Helvetica, Geneva, sans-serif; FONT-SIZE: 9pt; color: #FF0000}');
6915: htp.p('.OraPortletTableCellTextBand {font-family:Arial, Helvetica, Geneva, sans-serif; font-size:9pt; text-align:left;
6916: background-color:#ffffff; color:#000000}');
6917: htp.p('.OraPortletTableCellNumberBand {font-family:Arial, Helvetica, Geneva, sans-serif; font-size:9pt; text-align:right;
6918: background-color:#ffffff; color:#000000; text-indent:1}');
6919: htp.p(' .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; } ');
6920:
6921: -- Table

Line 6919: htp.p(' .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; } ');

6915: htp.p('.OraPortletTableCellTextBand {font-family:Arial, Helvetica, Geneva, sans-serif; font-size:9pt; text-align:left;
6916: background-color:#ffffff; color:#000000}');
6917: htp.p('.OraPortletTableCellNumberBand {font-family:Arial, Helvetica, Geneva, sans-serif; font-size:9pt; text-align:right;
6918: background-color:#ffffff; color:#000000; text-indent:1}');
6919: htp.p(' .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; } ');
6920:
6921: -- Table
6922: htp.p(' ');
6923:

Line 6922: htp.p('

');

6918: background-color:#ffffff; color:#000000; text-indent:1}');
6919: htp.p(' .OraCopyright{ display: none; } .OraLegal{ display: none; } .OraPrivacy{ display: none; } tr:hover td.OraTableCellText{ background-color: wheat; } ');
6920:
6921: -- Table
6922: htp.p('

');
6923:
6924:
6925: htp.p(' ');
6926: htp.p(' ');

6921: -- Table
6922: htp.p('

Line 6925: htp.p('

');
6923:
6924:
6925: htp.p(' ');
6926: htp.p(' ');
6929: --width="5%"

Line 6926: htp.p('

6927: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6928: align=left valign=bottom>'||'

6922: htp.p(' '); 6923: 6924: 6925: htp.p(' '); 6926: htp.p(' '); 6929: --width="5%" 6930: htp.p(' '); 6926: htp.p(' '); 6929: --width="5%" 6930: htp.p(' '); 6929: --width="5%" 6930: htp.p(' '); 6933: htp.p(' '); 6929: --width="5%" 6930: htp.p(' '); 6933: htp.p(' '); 6933: htp.p(' '); 6937: htp.p(' '); 6932: >'||bis_utilities_pvt.escape_html(p_measure_lbl)||''); 6933: htp.p(' '); 6937: htp.p(' '); 6940: htp.p(' '); 6937: htp.p(' '); 6940: htp.p(' '); 6937: htp.p(' '); 6940: htp.p(' '); Line 6940: htp.p(' '); 6937: htp.p(' '); 6940: htp.p(' '); 6943: htp.p(' '); 6944: Line 6941: --htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6937: htp.p(' '); 6940: htp.p(' '); 6943: htp.p(' '); 6944: 6945: END draw_portlet_header ; Line 6942: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom>'||' '); 6938: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid;COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6939: align=right valign=bottom>'||bis_utilities_pvt.escape_html(p_change_lbl)||''); 6940: htp.p(' '); 6943: htp.p(' '); 6944: 6945: END draw_portlet_header ; 6946: Line 6943: htp.p(' '); 6939: align=right valign=bottom>'||bis_utilities_pvt.escape_html(p_change_lbl)||''); 6940: htp.p(' '); 6943: htp.p(' '); 6944: 6945: END draw_portlet_header ; 6946: 6947: Line 6976: htp.p(' 6927: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6928: align=left valign=bottom>'||'  Line 6927: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6923: 6924: 6925: htp.p(' 6927: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6928: align=left valign=bottom>'||'  6931: htp.p(' style="BORDER-LEFT: #cccc99 1px solid;COLOR: #336699; BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom Line 6930: htp.p(' 6926: htp.p(' 6927: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6928: align=left valign=bottom>'||'  6931: htp.p(' style="BORDER-LEFT: #cccc99 1px solid;COLOR: #336699; BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom 6932: >'||bis_utilities_pvt.escape_html(p_measure_lbl)||' 6934: --bug#2228061 Line 6931: htp.p(' style="BORDER-LEFT: #cccc99 1px solid;COLOR: #336699; BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom 6927: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6928: align=left valign=bottom>'||'  6931: htp.p(' style="BORDER-LEFT: #cccc99 1px solid;COLOR: #336699; BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom 6932: >'||bis_utilities_pvt.escape_html(p_measure_lbl)||' 6934: --bug#2228061 6935: Line 6933: htp.p(' 6929: --width="5%" 6930: htp.p(' 6931: htp.p(' style="BORDER-LEFT: #cccc99 1px solid;COLOR: #336699; BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom 6932: >'||bis_utilities_pvt.escape_html(p_measure_lbl)||' 6934: --bug#2228061 6935: 6936: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=right valign=bottom>   Line 6936: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=right valign=bottom>   6934: --bug#2228061 6935: 6936: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=right valign=bottom>   6938: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid;COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6939: align=right valign=bottom>'||bis_utilities_pvt.escape_html(p_change_lbl)||' Line 6937: htp.p(' 6933: htp.p(' 6934: --bug#2228061 6935: 6936: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=right valign=bottom>   6938: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid;COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6939: align=right valign=bottom>'||bis_utilities_pvt.escape_html(p_change_lbl)||' 6941: --htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" Line 6938: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid;COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6934: --bug#2228061 6935: 6936: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=right valign=bottom>   6938: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid;COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6939: align=right valign=bottom>'||bis_utilities_pvt.escape_html(p_change_lbl)||' 6941: --htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6942: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom>'||'  6936: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=right valign=bottom>   6938: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid;COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6939: align=right valign=bottom>'||bis_utilities_pvt.escape_html(p_change_lbl)||' 6941: --htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6942: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom>'||'  6938: htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid;COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6939: align=right valign=bottom>'||bis_utilities_pvt.escape_html(p_change_lbl)||' 6941: --htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6942: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom>'||'  6941: --htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6942: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom>'||'  6941: --htp.p(' style="BORDER-LEFT: #f7f7e7 1px solid; COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" 6942: htp.p(' style="COLOR: #336699;BORDER-TOP: #f7f7e7 1px solid" align=left valign=bottom>'||'  '); 6972: PROCEDURE draw_portlet_footer 6973: IS 6974: BEGIN 6975: 6976: htp.p('

');
6977:
6978: END draw_portlet_footer;
6979:
6980:

Line 7082: htp.p('

7078: l_range_lbl := '';
7079: END IF;
7080:
7081: --width="5%"
7082: htp.p(' 7083: htp.p(' style="BORDER-LEFT: #cccc99 1px solid; BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align=left> ');
7085: htp.p('');
7086:

Line 7083: htp.p(' style="BORDER-LEFT: #cccc99 1px solid; BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align=left> 7082: htp.p(' 7083: htp.p(' style="BORDER-LEFT: #cccc99 1px solid; BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align=left> ');
7085: htp.p('');
7086:
7087: END draw_status;

Line 7085: htp.p('');

7081: --width="5%"
7082: htp.p(' 7083: htp.p(' style="BORDER-LEFT: #cccc99 1px solid; BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align=left> ');
7085: htp.p('');
7086:
7087: END draw_status;
7088:
7089:

Line 7100: htp.p('

7096: ,p_measure_lbl IN VARCHAR2
7097: ,p_row_style IN VARCHAR2)
7098: IS
7099: BEGIN
7100: htp.p(' 7101: htp.p(' style="BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align=left>');
7102: IF p_actual_url IS NOT NULL THEN
7103: --htp.p('' || p_label || ' '); -- 2164190 sashaik --
7104: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));

Line 7101: htp.p(' style="BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align=left>');

7097: ,p_row_style IN VARCHAR2)
7098: IS
7099: BEGIN
7100: htp.p(' 7101: htp.p(' style="BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align=left>');
7102: IF p_actual_url IS NOT NULL THEN
7103: --htp.p('' || p_label || ' '); -- 2164190 sashaik --
7104: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));
7105: ELSE

Line 7103: --htp.p('' || p_label || ' '); -- 2164190 sashaik --

7099: BEGIN
7100: htp.p(' 7101: htp.p(' style="BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align=left>');
7102: IF p_actual_url IS NOT NULL THEN
7103: --htp.p('' || p_label || ' '); -- 2164190 sashaik --
7104: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));
7105: ELSE
7106: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));
7107: END IF;

Line 7104: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));

7100: htp.p(' 7101: htp.p(' style="BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align=left>');
7102: IF p_actual_url IS NOT NULL THEN
7103: --htp.p('' || p_label || ' '); -- 2164190 sashaik --
7104: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));
7105: ELSE
7106: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));
7107: END IF;
7108: htp.p(' ');

Line 7106: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));

7102: IF p_actual_url IS NOT NULL THEN
7103: --htp.p('' || p_label || ' '); -- 2164190 sashaik --
7104: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));
7105: ELSE
7106: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));
7107: END IF;
7108: htp.p(' ');
7109: END draw_measure_name;
7110:

Line 7108: htp.p(' ');

7104: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));
7105: ELSE
7106: htp.p(bis_utilities_pvt.escape_html(LTRIM(p_label)));
7107: END IF;
7108: htp.p(' ');
7109: END draw_measure_name;
7110:
7111:
7112:

Line 7124: htp.p(' 7125: '" class=OraPortletTableCellNumber'|| p_row_style);
7126: htp.p(' style="BORDER-BOTTOM: #cccc99 1px solid;BORDER-LEFT: #cccc99 1px solid" width="15%" valign="bottom" align=right nowrap> ');
7127: htp.p(' '|| bis_utilities_pvt.escape_html(p_formatted_actual) ||'');
7128: htp.p(' ');

Line 7126: htp.p(' style="BORDER-BOTTOM: #cccc99 1px solid;BORDER-LEFT: #cccc99 1px solid" width="15%" valign="bottom" align=right nowrap> ');

7122: BEGIN
7123:
7124: htp.p(' 7126: htp.p(' style="BORDER-BOTTOM: #cccc99 1px solid;BORDER-LEFT: #cccc99 1px solid" width="15%" valign="bottom" align=right nowrap> ');
7127: htp.p(' '|| bis_utilities_pvt.escape_html(p_formatted_actual) ||'');
7128: htp.p(' ');
7129: END draw_actual;
7130:

Line 7127: htp.p(' '|| bis_utilities_pvt.escape_html(p_formatted_actual) ||'');

7123:
7124: htp.p(' 7126: htp.p(' style="BORDER-BOTTOM: #cccc99 1px solid;BORDER-LEFT: #cccc99 1px solid" width="15%" valign="bottom" align=right nowrap> ');
7127: htp.p(' '|| bis_utilities_pvt.escape_html(p_formatted_actual) ||'');
7128: htp.p(' ');
7129: END draw_actual;
7130:
7131:

Line 7128: htp.p(' ');

7124: htp.p(' 7126: htp.p(' style="BORDER-BOTTOM: #cccc99 1px solid;BORDER-LEFT: #cccc99 1px solid" width="15%" valign="bottom" align=right nowrap> ');
7127: htp.p(' '|| bis_utilities_pvt.escape_html(p_formatted_actual) ||'');
7128: htp.p(' ');
7129: END draw_actual;
7130:
7131:
7132:

Line 7147: htp.p('

7143: IS
7144:
7145: BEGIN
7146:
7147: htp.p(' 7148: htp.p(' style="BORDER-LEFT: #cccc99 1px solid; BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align="right" valign="bottom" nowrap>'|| bis_utilities_pvt.escape_html(p_change));
7149: htp.p(' ');
7150:
7151: htp.p('

Line 7148: htp.p(' style="BORDER-LEFT: #cccc99 1px solid; BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align="right" valign="bottom" nowrap>'|| bis_utilities_pvt.escape_html(p_change));

7144:
7145: BEGIN
7146:
7147: htp.p(' 7148: htp.p(' style="BORDER-LEFT: #cccc99 1px solid; BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align="right" valign="bottom" nowrap>'|| bis_utilities_pvt.escape_html(p_change));
7149: htp.p(' ');
7150:
7151: htp.p(' 7152: htp.p(' style="

Line 7149: htp.p(' ');

7145: BEGIN
7146:
7147: htp.p(' 7148: htp.p(' style="BORDER-LEFT: #cccc99 1px solid; BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align="right" valign="bottom" nowrap>'|| bis_utilities_pvt.escape_html(p_change));
7149: htp.p(' ');
7150:
7151: htp.p(' 7152: htp.p(' style="
7153: BORDER-BOTTOM: #cccc99 1px solid;BORDER-TOP: #f7f7e7 1px solid " align="left" valign="bottom" nowrap >');

Line 7151: htp.p('

7147: htp.p(' 7148: htp.p(' style="BORDER-LEFT: #cccc99 1px solid; BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align="right" valign="bottom" nowrap>'|| bis_utilities_pvt.escape_html(p_change));
7149: htp.p(' ');
7150:
7151: htp.p(' 7152: htp.p(' style="
7153: BORDER-BOTTOM: #cccc99 1px solid;BORDER-TOP: #f7f7e7 1px solid " align="left" valign="bottom" nowrap >');
7154:
7155: IF ( p_img IS NOT NULL ) THEN

Line 7152: htp.p(' style="

7148: htp.p(' style="BORDER-LEFT: #cccc99 1px solid; BORDER-BOTTOM: #cccc99 1px solid; BORDER-TOP: #f7f7e7 1px solid " align="right" valign="bottom" nowrap>'|| bis_utilities_pvt.escape_html(p_change));
7149: htp.p(' ');
7150:
7151: htp.p(' 7152: htp.p(' style="
7153: BORDER-BOTTOM: #cccc99 1px solid;BORDER-TOP: #f7f7e7 1px solid " align="left" valign="bottom" nowrap >');
7154:
7155: IF ( p_img IS NOT NULL ) THEN
7156: htp.p(' ');

Line 7156: htp.p(' ');

7152: htp.p(' style="
7153: BORDER-BOTTOM: #cccc99 1px solid;BORDER-TOP: #f7f7e7 1px solid " align="left" valign="bottom" nowrap >');
7154:
7155: IF ( p_img IS NOT NULL ) THEN
7156: htp.p(' ');
7157: ELSE
7158: htp.p(' ');
7159: END IF;
7160:

Line 7158: htp.p(' ');

7154:
7155: IF ( p_img IS NOT NULL ) THEN
7156: htp.p(' ');
7157: ELSE
7158: htp.p(' ');
7159: END IF;
7160:
7161: htp.p('');
7162: END draw_change;

Line 7161: htp.p('');

7157: ELSE
7158: htp.p(' ');
7159: END IF;
7160:
7161: htp.p('');
7162: END draw_change;
7163:
7164:
7165:

Line 7265: -- htp.p(l_msg_data);

7261: x_comparison_actual_value := l_act_out.COMPARISON_ACTUAL_VALUE;
7262:
7263: EXCEPTION
7264: WHEN OTHERS THEN
7265: -- htp.p(l_msg_data);
7266: x_actual_url := NULL;
7267: x_actual_value := NULL;
7268: x_comparison_actual_value := NULL;
7269: x_err := SQLERRM;