APPS.BIS_INDICATOR_REGION_UI_PVT dependencies on BIS_UTILITIES_PVT

Line 279: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL) AND

275: 7, z.dimension7_level_id,
276: NULL) org_dimension_level_id
277: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
278: WHERE x.dimension_id = y.dimension_id AND
279: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL) AND
280: x.indicator_id = z.indicator_id AND
281: z.target_level_id = p_target_level_id;
282:
283: CURSOR c_dimension_level_value(dimension_index NUMBER) IS

Line 347: l_time_dimension_name := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id, NULL);

343: x_return_status => l_return_status,
344: x_msg_count => l_msg_count,
345: x_msg_data => l_msg_data);
346:
347: l_time_dimension_name := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id, NULL);
348: l_total_time_level_name := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_TL(l_time_dimension_name, p_target_level_id, NULL);
349: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ; --2684911
350:
351: OPEN c_source;

Line 348: l_total_time_level_name := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_TL(l_time_dimension_name, p_target_level_id, NULL);

344: x_msg_count => l_msg_count,
345: x_msg_data => l_msg_data);
346:
347: l_time_dimension_name := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id, NULL);
348: l_total_time_level_name := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_TL(l_time_dimension_name, p_target_level_id, NULL);
349: l_time_lvl_dep_on_org := BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name) ; --2684911
350:
351: OPEN c_source;
352: FETCH c_source INTO l_source;

Line 470: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL) AND

466: 7, z.dimension7_level_id,
467: NULL) org_dimension_level_id
468: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
469: WHERE x.dimension_id = y.dimension_id AND
470: y.short_name = BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL) AND
471: x.indicator_id = z.indicator_id AND
472: z.target_level_id = p_target_level_id;
473:
474: CURSOR c_dimension_level_value(dimension_index NUMBER) IS

Line 541: l_time_dimension_name := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id, NULL);

537: x_return_status => l_return_status,
538: x_msg_count => l_msg_count,
539: x_msg_data => l_msg_data);
540:
541: l_time_dimension_name := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id, NULL);
542: l_total_time_level_name := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_TL(l_time_dimension_name, p_target_level_id, NULL);
543:
544: OPEN c_source;
545: FETCH c_source INTO l_source;

Line 542: l_total_time_level_name := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_TL(l_time_dimension_name, p_target_level_id, NULL);

538: x_msg_count => l_msg_count,
539: x_msg_data => l_msg_data);
540:
541: l_time_dimension_name := BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id, NULL);
542: l_total_time_level_name := BIS_UTILITIES_PVT.GET_TOTAL_DIMLEVEL_NAME_TL(l_time_dimension_name, p_target_level_id, NULL);
543:
544: OPEN c_source;
545: FETCH c_source INTO l_source;
546: CLOSE c_source;

Line 901: l_none_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_NONE');

897:
898: -- =======================
899: -- loading messages
900: -- =======================
901: l_none_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_NONE');
902: l_na_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NA_LBL'));
903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
904:
905: -- header labels

Line 902: l_na_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NA_LBL'));

898: -- =======================
899: -- loading messages
900: -- =======================
901: l_none_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_NONE');
902: l_na_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NA_LBL'));
903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
904:
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');

Line 903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');

899: -- loading messages
900: -- =======================
901: l_none_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_NONE');
902: l_na_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NA_LBL'));
903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
904:
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');

Line 906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');

902: l_na_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NA_LBL'));
903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
904:
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));

Line 907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');

903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
904:
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:

Line 908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');

904:
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
912: -- msgs

Line 909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));

905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');

Line 910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));

906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');

Line 913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');

909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
915: l_worse_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_WORSE');
916: l_improve_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_IMPROVE');
917:

Line 914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');

910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
915: l_worse_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_WORSE');
916: l_improve_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_IMPROVE');
917:
918:

Line 915: l_worse_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_WORSE');

911:
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
915: l_worse_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_WORSE');
916: l_improve_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_IMPROVE');
917:
918:
919: -- =======================

Line 916: l_improve_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_IMPROVE');

912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
915: l_worse_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_WORSE');
916: l_improve_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_IMPROVE');
917:
918:
919: -- =======================
920: -- Begin Main block

Line 1112: l_url_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_ENTER_PT_DATA');

1108: RETURN;
1109: END IF;
1110:
1111: -- demo is on
1112: l_url_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_ENTER_PT_DATA');
1113:
1114: l_servlet_agent := FND_WEB_CONFIG.JSP_AGENT; -- 'http://serv:port/OA_HTML/'
1115: IF ( l_servlet_agent IS NULL ) THEN -- 'APPS_SERVLET_AGENT' is null
1116: l_servlet_agent := FND_WEB_CONFIG.WEB_SERVER || 'OA_HTML/';

Line 1199: l_button_tbl BIS_UTILITIES_PVT.HTML_Button_Tbl_Type;

1195: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1196:
1197: -- Fix for ADA buttons
1198: l_button_str varchar2(32000);
1199: l_button_tbl BIS_UTILITIES_PVT.HTML_Button_Tbl_Type;
1200: l_string VARCHAR2(32000);
1201: l_demo_string VARCHAR(32000);
1202: l_append_string VARCHAR2(1000);
1203: l_swan_enabled BOOLEAN;

Line 1211: l_swan_enabled := BIS_UTILITIES_PVT.checkSWANEnabled();

1207:
1208: -- meastmon 09/07/2001 Fix bug#1980577. Workaround Do not encrypt plug_id
1209: l_plug_id := Z;
1210:
1211: l_swan_enabled := BIS_UTILITIES_PVT.checkSWANEnabled();
1212:
1213:
1214: --if icx_sec.validateSession then
1215: -- if ICX_SEC.validatePlugSession(l_plug_id) then

Line 1310: l_instruction := bis_utilities_pvt.escape_html_input(icx_util.replace_quotes(fnd_message.get));

1306:
1307:
1308: -- Print out NOCOPY the instructions for this page
1309: fnd_message.set_name('BIS','BIS_PLUG_INSTRUCTION1');
1310: l_instruction := bis_utilities_pvt.escape_html_input(icx_util.replace_quotes(fnd_message.get));
1311: l_string := l_string ||'
';
1312: l_string := l_string ||'';
1313: l_string := l_string ||'';

Line 1474: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_AVAILABLE_MEASURES')||': ';

1470: l_string := l_string ||'

'; 1314: l_string := l_string ||l_instruction||'

';--cell
1471:
1472: IF(l_swan_enabled)THEN
1473: l_string := l_string ||'';

Line 1481: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': ';

1477: ELSE
1478: l_string := l_string ||'

';
1484: l_string := l_string ||'

'; 1474: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_AVAILABLE_MEASURES')||': '; 1475: l_string := l_string ||'	'; 1476: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': '; 1477: ELSE 1478: l_string := l_string ||'
'; Line 1476: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': '; 1472: IF(l_swan_enabled)THEN 1473: l_string := l_string ||'
'; 1474: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_AVAILABLE_MEASURES')||': '; 1475: l_string := l_string ||'	'; 1476: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': '; 1477: ELSE 1478: l_string := l_string ||'
'; 1479: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_AVAILABLE_MEASURES')||': '; 1480: l_string := l_string ||'	'; Line 1479: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_AVAILABLE_MEASURES')||': '; 1475: l_string := l_string ||'	'; 1476: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': '; 1477: ELSE 1478: l_string := l_string ||'
'; 1479: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_AVAILABLE_MEASURES')||': '; 1480: l_string := l_string ||'	'; 1481: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': '; 1482: END IF; 1483: l_string := l_string ||'
'; 1479: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_AVAILABLE_MEASURES')||': '; 1480: l_string := l_string ||'	'; 1481: l_string := l_string ||BIS_UTILITIES_PVT.getPrompt('BIS_SELECTED_MEASURES')||': '; 1482: END IF; 1483: l_string := l_string ||'
'; 1485: l_string := l_string ||' '; -- full menu cell Line 1494: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(getPerformanceMeasureName(l_indicators_tbl(i).target_level_id)); 1490: ELSE 1491: for i in l_indicators_tbl.FIRST .. l_indicators_tbl.COUNT loop 1492: -- mdamle 01/12/2001 - Change display text of Performance Measure list 1493: -- changed l_indicators_tbl(i).target_level_name to getPerformanceMeasureName() 1494: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(getPerformanceMeasureName(l_indicators_tbl(i).target_level_id)); 1495: end loop; 1496: END IF; 1497: 1498: l_string := l_string ||''; Line 1504: l_string := l_string || BIS_UTILITIES_PVT.getPrompt('BIS_ADD'); 1500: l_string := l_string ||' '; 1501: l_string := l_string ||' '; --add 1502: l_string := l_string ||''; 1508: ELSE 1509: l_string := l_string || ''';return true">'; 1513: l_string := l_string ||' '; -- add 1514: l_string := l_string ||' '; -- full menu cell 1515: l_string := l_string ||'	'; 1516: --favorite cell Line 1530: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(getPerformanceMeasureName(l_temp_tbl(i).id)); 1526: ELSE 1527: for i in l_temp_tbl.FIRST .. l_temp_tbl.COUNT loop 1528: -- mdamle 01/12/2001 - Change display text of Performance Measure list 1529: -- changed l_temp_tbl(i).name to getPerformanceMeasureName() 1530: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(getPerformanceMeasureName(l_temp_tbl(i).id)); 1531: end loop; 1532: END IF; 1533: else 1534: Line 1541: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_text); 1537: 1538: l_loc := instr(p_selections_tbl(i),'*',1,1); 1539: l_value := substr (p_selections_tbl(i),1,l_loc - 1); 1540: l_text := substr (p_selections_tbl(i),l_loc + 1); 1541: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_text); 1542: exit when p_selections_tbl(i) is NULL; 1543: end LOOP; 1544: 1545: end if; Line 1553: --l_string := l_string || ICX_UTIL.replace_onMouseOver_quotes(BIS_UTILITIES_PVT.getPrompt('BIS_UP')); 1549: 1550: -- up and down 1551: l_string := l_string ||' '; 1552: l_string := l_string ||''; 1552: l_string := l_string ||''; 1556: l_string := l_string || ''';return true">'; 1561: l_string := l_string ||' '; 1562: l_string := l_string ||''; 1561: l_string := l_string ||' '; 1562: l_string := l_string ||''; 1565: l_string := l_string || ''';return true">'; 1570: l_string := l_string ||' '; --up and down 1571: l_string := l_string ||'

'; --favorite cell
1572: l_string := l_string ||'';
1573: l_string := l_string ||'';

Line 1581: l_button_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;

1577: l_string := l_string ||'
';
1578: l_string := l_string ||'
';
1579:
1580: IF(l_swan_enabled)THEN
1581: l_button_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
1582: ELSE
1583: l_button_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
1584: END IF;
1585:

Line 1583: l_button_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;

1579:
1580: IF(l_swan_enabled)THEN
1581: l_button_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
1582: ELSE
1583: l_button_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
1584: END IF;
1585:
1586: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
1587: l_button_tbl(1).left_edge := l_button_edge;

Line 1590: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');

1586: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
1587: l_button_tbl(1).left_edge := l_button_edge;
1588: l_button_tbl(1).right_edge := l_button_edge;
1589: l_button_tbl(1).disabled := FND_API.G_FALSE;
1590: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
1591: l_button_tbl(1).href := 'Javascript:deleteTo()';
1592:
1593: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
1594: l_string := l_string ||l_button_str;

Line 1593: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

1589: l_button_tbl(1).disabled := FND_API.G_FALSE;
1590: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
1591: l_button_tbl(1).href := 'Javascript:deleteTo()';
1592:
1593: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
1594: l_string := l_string ||l_button_str;
1595:
1596: l_string := l_string ||'';
1597: l_string := l_string ||'';

Line 1607: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;

1603:
1604: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
1605:
1606: l_button_tbl(1).left_edge := l_button_edge;
1607: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
1608: l_button_tbl(1).disabled := FND_API.G_FALSE;
1609: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CONTINUE');
1610: l_button_tbl(1).href := 'Javascript:savefavorites()';
1611: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

Line 1609: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CONTINUE');

1605:
1606: l_button_tbl(1).left_edge := l_button_edge;
1607: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
1608: l_button_tbl(1).disabled := FND_API.G_FALSE;
1609: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CONTINUE');
1610: l_button_tbl(1).href := 'Javascript:savefavorites()';
1611: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
1612: l_string := l_string ||l_button_str;
1613: l_string := l_string ||'';

Line 1611: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

1607: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
1608: l_button_tbl(1).disabled := FND_API.G_FALSE;
1609: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CONTINUE');
1610: l_button_tbl(1).href := 'Javascript:savefavorites()';
1611: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
1612: l_string := l_string ||l_button_str;
1613: l_string := l_string ||'';
1614:
1615: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.

Line 1616: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;

1612: l_string := l_string ||l_button_str;
1613: l_string := l_string ||'';
1614:
1615: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
1616: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
1617: l_button_tbl(1).right_edge := l_button_edge;
1618: l_button_tbl(1).disabled := FND_API.G_FALSE;
1619: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');
1620:

Line 1619: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');

1615: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
1616: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
1617: l_button_tbl(1).right_edge := l_button_edge;
1618: l_button_tbl(1).disabled := FND_API.G_FALSE;
1619: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');
1620:
1621: IF (p_back_url IS NULL) THEN
1622: l_button_tbl(1).href := BIS_REPORT_UTIL_PVT.Get_Home_URL;
1623: ELSE

Line 1627: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

1623: ELSE
1624: l_button_tbl(1).href := p_back_url;
1625: END IF;
1626:
1627: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
1628: l_string := l_string ||l_button_str;
1629: l_string := l_string ||'';
1630: l_string := l_string ||'';
1631:

Line 1788: l_button_tbl BIS_UTILITIES_PVT.HTML_Button_Tbl_Type;

1784: FROM BISFV_TARGET_LEVELS
1785: WHERE TARGET_LEVEL_ID = p_tarid;
1786:
1787: l_button_str varchar2(32000);
1788: l_button_tbl BIS_UTILITIES_PVT.HTML_Button_Tbl_Type;
1789: --Bug 1797465
1790: l_dim0_lbl VARCHAR2(1000);
1791: l_dim1_lbl VARCHAR2(1000);
1792: l_dim2_lbl VARCHAR2(1000);

Line 1812: l_swan_enabled := BIS_UTILITIES_PVT.checkSWANEnabled();

1808: BEGIN
1809:
1810:
1811: l_plug_id := Z;
1812: l_swan_enabled := BIS_UTILITIES_PVT.checkSWANEnabled();
1813: --l_plug_id := icx_call.decrypt2(Z);
1814:
1815: --if icx_sec.validateSession then
1816: -- if ICX_SEC.validatePlugSession(l_plug_id) then

Line 1837: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');

1833: l_dup_combo := icx_util.replace_quotes(fnd_message.get);
1834: fnd_message.set_name('BIS','BIS_CHOOSE_DIM_VALUE');
1835: l_choose_dim_value := icx_util.replace_quotes(fnd_message.get);
1836:
1837: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
1838:
1839:
1840: IF ((p_reference_path IS NOT NULL) AND (NOT BIS_PMF_PORTLET_UTIL.has_customized_rows(l_plug_id, l_current_user_id, l_owner_user_id) )) THEN
1841: l_user_id := l_owner_user_id;

Line 1874: l_instruction := bis_utilities_pvt.escape_html_input(icx_util.replace_quotes(fnd_message.get));

1870: l_string := '';
1871: l_string := l_string || '';
1872: -- Print out NOCOPY the instructions for this page
1873: fnd_message.set_name('BIS','BIS_PLUG_INSTRUCTION2');
1874: l_instruction := bis_utilities_pvt.escape_html_input(icx_util.replace_quotes(fnd_message.get));
1875: l_string := l_string ||'
';
1876: l_string := l_string ||'';
1877: l_string := l_string ||'';
1878: l_string := l_string ||'

'||l_instruction||'

';

Line 2147: l_string := l_string ||' if (confirm("'||BIS_UTILITIES_PVT.getPrompt('BIS_DELETE')||'" + " " + document.DefaultFormName.C.options[temp].text + "?"))';

2143: l_string := l_string ||' var temp=document.DefaultFormName.C.selectedIndex;';
2144: l_string := l_string ||' if (temp < 0)';
2145: l_string := l_string ||' selectTo();';
2146: l_string := l_string ||' else {';
2147: l_string := l_string ||' if (confirm("'||BIS_UTILITIES_PVT.getPrompt('BIS_DELETE')||'" + " " + document.DefaultFormName.C.options[temp].text + "?"))';
2148: l_string := l_string ||' document.DefaultFormName.C.options[temp] = null;';
2149: l_string := l_string ||' };';
2150: l_string := l_string ||' }';
2151:

Line 2486: l_string1 := l_string1 || l_append_string ||bis_utilities_pvt.escape_html(c_tarlevel)||'';

2482: l_append_string := '';
2483: END IF;
2484:
2485:
2486: l_string1 := l_string1 || l_append_string ||bis_utilities_pvt.escape_html(c_tarlevel)||'';
2487: l_string1 := l_string1 ||'';
2488: l_string1 := l_string1 ||'';
2489: l_string1 := l_string1 ||'';
2490: l_string1 := l_string1 ||'';

Line 2532: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_text);

2528: v_ind_level_id := TO_NUMBER(l_value);
2529: end if;
2530:
2531: if l_value = TO_CHAR(v_ind_level_id) then
2532: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_text);
2533: else
2534: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_text);
2535: end if;
2536: end loop;

Line 2534: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_text);

2530:
2531: if l_value = TO_CHAR(v_ind_level_id) then
2532: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_text);
2533: else
2534: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_text);
2535: end if;
2536: end loop;
2537: l_string1 := l_string1 ||'';
2538:

Line 2546: l_string1 := l_string1 ||l_append_string||bis_utilities_pvt.escape_html(c_dim_and_plan)||'';

2542: l_string1 := l_string1 ||'';
2543: l_string1 := l_string1 ||'';
2544: l_string1 := l_string1 ||'';
2545:
2546: l_string1 := l_string1 ||l_append_string||bis_utilities_pvt.escape_html(c_dim_and_plan)||'';
2547: l_string1 := l_string1 ||'';
2548: l_string1 := l_string1 ||'';
2549: l_string1 := l_string1 ||'';
2550: l_string1 := l_string1 ||'';

Line 2734: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';

2730: elsif (l_Org_Level_Short_Name='TOTAL_ORGANIZATIONS') then
2731: l_string1 := l_string1 ||'';
2732: l_string1 := l_string1 ||'';
2733: l_string1 := l_string1 ||'';
2734: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';
2735: l_string1 := l_string1 ||'';
2736: l_string1 := l_string1 ||'';
2737: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(LOWER(l_Org_Level_Short_Name));
2738: l_string1 := l_string1 ||'';

Line 2737: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(LOWER(l_Org_Level_Short_Name));

2733: l_string1 := l_string1 ||'';
2734: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';
2735: l_string1 := l_string1 ||'';
2736: l_string1 := l_string1 ||'';
2737: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(LOWER(l_Org_Level_Short_Name));
2738: l_string1 := l_string1 ||'';
2739: else
2740: -- Print out NOCOPY label and input box for dimension0
2741: l_string1 := l_string1 ||'';

Line 2753: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';

2749: l_string1 := l_string1 ||'';
2750: end if;
2751:
2752: l_string1 := l_string1 ||'';
2753: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';
2754: l_string1 := l_string1 ||'';
2755: l_string1 := l_string1 ||'';
2756: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2757:

Line 2756: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);

2752: l_string1 := l_string1 ||'';
2753: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';
2754: l_string1 := l_string1 ||'';
2755: l_string1 := l_string1 ||'

';
2756: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2757:
2758: if (l_orgs_tbl.COUNT <> 0) THEN
2759: removeDuplicates(p_original_tbl => l_orgs_tbl,
2760: p_value => NULL,

Line 2764: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d0_tbl(i).name);

2760: p_value => NULL,
2761: x_unique_tbl => l_d0_tbl);
2762: for i in 1 ..l_d0_tbl.COUNT LOOP
2763: exit when (l_d0_tbl(i).id is NULL);
2764: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d0_tbl(i).name);
2765: end loop;
2766: end if;
2767: l_string1 := l_string1 ||''||c_choose;
2768: l_string1 := l_string1 ||'';

Line 2789: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension1_Level_Name)||'';

2785: else
2786: -- Print out NOCOPY label and input box for dimension1
2787: l_string1 := l_string1 || '';
2788: l_string1 := l_string1 ||'';
2789: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension1_Level_Name)||'';
2790: l_string1 := l_string1 ||'';
2791: l_string1 := l_string1 ||'';
2792: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2793:

Line 2792: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);

2788: l_string1 := l_string1 ||'';
2789: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension1_Level_Name)||'';
2790: l_string1 := l_string1 ||'';
2791: l_string1 := l_string1 ||'

';
2792: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2793:
2794:
2795: if (l_dim1_tbl.COUNT <> 0) THEN
2796: removeDuplicates(p_original_tbl => l_dim1_tbl,

Line 2802: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d1_tbl(i).name);

2798: x_unique_tbl => l_d1_tbl);
2799: for i in 1 ..l_d1_tbl.COUNT LOOP
2800: exit when (l_d1_tbl(i).id is NULL);
2801: -- mdamle - 01/15/2001 - Add quotes around VALUE
2802: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d1_tbl(i).name);
2803: end loop;
2804: end if;
2805: l_string1 := l_string1 ||''||c_choose;
2806: l_string1 := l_string1 ||'';

Line 2825: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension2_Level_Name)||'';

2821: end if;
2822: else -- Print out NOCOPY label and input box for dimension2
2823: l_string1 := l_string1 ||'';
2824: l_string1 := l_string1 ||'';
2825: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension2_Level_Name)||'';
2826: l_string1 := l_string1 ||'';
2827: l_string1 := l_string1 ||'';
2828: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2829:

Line 2828: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);

2824: l_string1 := l_string1 ||'';
2825: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension2_Level_Name)||'';
2826: l_string1 := l_string1 ||'';
2827: l_string1 := l_string1 ||'

';
2828: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2829:
2830: if (l_dim2_tbl.COUNT <> 0) THEN
2831: removeDuplicates(p_original_tbl => l_dim2_tbl,
2832: p_value => NULL,

Line 2837: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d2_tbl(i).name);

2833: x_unique_tbl => l_d2_tbl);
2834: for i in 1 ..l_d2_tbl.COUNT LOOP
2835: exit when (l_d2_tbl(i).id is NULL);
2836: -- mdamle - 01/15/2001 - Add quotes around VALUE
2837: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d2_tbl(i).name);
2838: end loop;
2839: end if;
2840: l_string1 := l_string1 ||''||c_choose;
2841: l_string1 := l_string1 ||'';

Line 2860: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension3_Level_Name)||'';

2856: end if;
2857: else -- Print out NOCOPY label and input box for dimension3
2858: l_string1 := l_string1 ||'';
2859: l_string1 := l_string1 ||'';
2860: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension3_Level_Name)||'';
2861: l_string1 := l_string1 ||'';
2862: l_string1 := l_string1 ||'';
2863: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2864:

Line 2863: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);

2859: l_string1 := l_string1 ||'';
2860: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension3_Level_Name)||'';
2861: l_string1 := l_string1 ||'';
2862: l_string1 := l_string1 ||'

';
2863: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2864:
2865: if (l_dim3_tbl.COUNT <> 0) THEN
2866: removeDuplicates(p_original_tbl => l_dim3_tbl,
2867: p_value => NULL,

Line 2872: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d3_tbl(i).name);

2868: x_unique_tbl => l_d3_tbl);
2869: for i in 1 ..l_d3_tbl.COUNT LOOP
2870: exit when (l_d3_tbl(i).id is NULL);
2871: -- mdamle - 01/15/2001 - Add quotes around VALUE
2872: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d3_tbl(i).name);
2873: end loop;
2874: end if;
2875: l_string1 := l_string1 ||''||c_choose;
2876: l_string1 := l_string1 ||'';

Line 2895: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension4_Level_Name)||'';

2891: end if;
2892: else -- Print out NOCOPY label and input box for dimension4
2893: l_string1 := l_string1 ||'';
2894: l_string1 := l_string1 ||'';
2895: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension4_Level_Name)||'';
2896: l_string1 := l_string1 ||'';
2897: l_string1 := l_string1 ||'';
2898: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2899: if (l_dim4_tbl.COUNT <> 0) THEN

Line 2898: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);

2894: l_string1 := l_string1 ||'';
2895: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension4_Level_Name)||'';
2896: l_string1 := l_string1 ||'';
2897: l_string1 := l_string1 ||'

';
2898: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2899: if (l_dim4_tbl.COUNT <> 0) THEN
2900: removeDuplicates(p_original_tbl => l_dim4_tbl,
2901: p_value => NULL,
2902: x_unique_tbl => l_d4_tbl);

Line 2906: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d4_tbl(i).name);

2902: x_unique_tbl => l_d4_tbl);
2903: for i in 1 ..l_d4_tbl.COUNT LOOP
2904: exit when (l_d4_tbl(i).id is NULL);
2905: -- mdamle - 01/15/2001 - Add quotes around VALUE
2906: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d4_tbl(i).name);
2907: end loop;
2908: end if;
2909: l_string1 := l_string1 ||''||c_choose;
2910: l_string1 := l_string1 ||'';

Line 2930: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension5_Level_Name)||'';

2926: else
2927: -- Print out NOCOPY label and input box for dimension5
2928: l_string1 := l_string1 ||'';
2929: l_string1 := l_string1 ||'';
2930: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension5_Level_Name)||'';
2931: l_string1 := l_string1 ||'';
2932: l_string1 := l_string1 ||'';
2933: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2934: if (l_dim5_tbl.COUNT <> 0) THEN

Line 2933: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);

2929: l_string1 := l_string1 ||'';
2930: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension5_Level_Name)||'';
2931: l_string1 := l_string1 ||'';
2932: l_string1 := l_string1 ||'

';
2933: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2934: if (l_dim5_tbl.COUNT <> 0) THEN
2935: removeDuplicates(p_original_tbl => l_dim5_tbl,
2936: p_value => NULL,
2937: x_unique_tbl => l_d5_tbl);

Line 2941: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d5_tbl(i).name);

2937: x_unique_tbl => l_d5_tbl);
2938: for i in 1 ..l_d5_tbl.COUNT LOOP
2939: exit when (l_d5_tbl(i).id is NULL);
2940: -- mdamle - 01/15/2001 - Add quotes around VALUE
2941: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d5_tbl(i).name);
2942: end loop;
2943: end if;
2944: l_string1 := l_string1 ||''||c_choose;
2945: l_string1 := l_string1 ||'';

Line 2965: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension6_Level_Name)||'';

2961: else
2962: -- Print out NOCOPY label and input box for dimension6
2963: l_string1 := l_string1 ||'';
2964: l_string1 := l_string1 ||'';
2965: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension6_Level_Name)||'';
2966: l_string1 := l_string1 ||'';
2967: l_string1 := l_string1 ||'';
2968: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2969: if (l_dim6_tbl.COUNT <> 0) THEN

Line 2968: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);

2964: l_string1 := l_string1 ||'';
2965: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension6_Level_Name)||'';
2966: l_string1 := l_string1 ||'';
2967: l_string1 := l_string1 ||'

';
2968: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
2969: if (l_dim6_tbl.COUNT <> 0) THEN
2970: removeDuplicates(p_original_tbl => l_dim6_tbl,
2971: p_value => NULL,
2972: x_unique_tbl => l_d6_tbl);

Line 2976: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d6_tbl(i).name);

2972: x_unique_tbl => l_d6_tbl);
2973: for i in 1 ..l_d6_tbl.COUNT LOOP
2974: exit when (l_d6_tbl(i).id is NULL);
2975: -- mdamle - 01/15/2001 - Add quotes around VALUE
2976: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d6_tbl(i).name);
2977: end loop;
2978: end if;
2979: l_string1 := l_string1 ||''||c_choose;
2980: l_string1 := l_string1 ||'';

Line 3000: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension7_Level_Name)||'';

2996: else
2997: -- Print out NOCOPY label and input box for dimension7
2998: l_string1 := l_string1 ||'';
2999: l_string1 := l_string1 ||'';
3000: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension7_Level_Name)||'';
3001: l_string1 := l_string1 ||'';
3002: l_string1 := l_string1 ||'';
3003: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
3004: if (l_dim7_tbl.COUNT <> 0) THEN

Line 3003: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);

2999: l_string1 := l_string1 ||'';
3000: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_recs.Dimension7_Level_Name)||'';
3001: l_string1 := l_string1 ||'';
3002: l_string1 := l_string1 ||'

';
3003: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_blank);
3004: if (l_dim7_tbl.COUNT <> 0) THEN
3005: removeDuplicates(p_original_tbl => l_dim7_tbl,
3006: p_value => NULL,
3007: x_unique_tbl => l_d7_tbl);

Line 3011: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d7_tbl(i).name);

3007: x_unique_tbl => l_d7_tbl);
3008: for i in 1 ..l_d7_tbl.COUNT LOOP
3009: exit when (l_d7_tbl(i).id is NULL);
3010: -- mdamle - 01/15/2001 - Add quotes around VALUE
3011: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_d7_tbl(i).name);
3012: end loop;
3013: end if;
3014: l_string1 := l_string1 ||''||c_choose;
3015: l_string1 := l_string1 ||'';

Line 3025: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_plan)||'';

3021: l_string1 := l_string1 ||'';
3022:
3023: -- Have a poplist for the Business Plan
3024: l_string1 := l_string1 ||'';
3025: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_plan)||'';
3026: l_string1 := l_string1 ||'';
3027: l_string1 := l_string1 ||'';
3028: for pl in plan_cur loop
3029: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(pl.name);

Line 3029: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(pl.name);

3025: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html(c_plan)||'';
3026: l_string1 := l_string1 ||'';
3027: l_string1 := l_string1 ||'

';
3028: for pl in plan_cur loop
3029: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(pl.name);
3030: end loop;
3031: l_string1 := l_string1 ||'';
3032: l_string1 := l_string1 ||'';
3033: l_string1 := l_string1 ||'';

Line 3082: l_button_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;

3078:
3079: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
3080: --icx_plug_utilities.buttonBoth(c_display_homepage,'Javascript:addTo()');
3081: IF(l_swan_enabled)THEN
3082: l_button_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
3083: ELSE
3084: l_button_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
3085: END IF;
3086: l_button_tbl(1).left_edge := l_button_edge;

Line 3084: l_button_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;

3080: --icx_plug_utilities.buttonBoth(c_display_homepage,'Javascript:addTo()');
3081: IF(l_swan_enabled)THEN
3082: l_button_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
3083: ELSE
3084: l_button_edge := BIS_UTILITIES_PVT.G_ROUND_EDGE;
3085: END IF;
3086: l_button_tbl(1).left_edge := l_button_edge;
3087: l_button_tbl(1).right_edge := l_button_edge;
3088: l_button_tbl(1).disabled := FND_API.G_FALSE;

Line 3091: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

3087: l_button_tbl(1).right_edge := l_button_edge;
3088: l_button_tbl(1).disabled := FND_API.G_FALSE;
3089: l_button_tbl(1).label := c_display_homepage;
3090: l_button_tbl(1).href := 'Javascript:addTo()';
3091: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
3092: l_string1 := l_button_str;
3093:
3094: l_string1 := l_string1 ||'';
3095: l_string1 := l_string1 ||'';

Line 3113: l_string1 := l_string1 || ''||bis_utilities_pvt.escape_html(c_tarlevels_homepage) ||'';

3109: l_string1 := l_string1 ||'';
3110: l_string1 := l_string1 ||'';
3111: l_string1 := l_string1 ||'';
3112: IF(l_swan_enabled)THEN
3113: l_string1 := l_string1 || '';
3114: ELSE
3115: l_string1 := l_string1 || '';
3116: END IF;
3117: l_string1 := l_string1 || '';

Line 3115: l_string1 := l_string1 || '

';

3111: l_string1 := l_string1 ||'

';
3112: IF(l_swan_enabled)THEN
3113: l_string1 := l_string1 || '';
3114: ELSE
3115: l_string1 := l_string1 || '';
3116: END IF;
3117: l_string1 := l_string1 || '';
3118: l_string1 := l_string1 || '';
3119: l_string1 := l_string1 || '';

Line 3213: l_string1 := l_string1 ||'';

3209: l_access := '*N';
3210: END IF;
3211:
3212: -- mdamle 01/15/2001 - Added quotes around the VALUE
3213: l_string1 := l_string1 ||'';
3214: l_string1 := l_string1 ||bis_utilities_pvt.escape_html_input(l_labels_tbl(i).label);
3215:
3216: end LOOP;
3217: end if; -- if l_labels_tbl is empty

Line 3214: l_string1 := l_string1 ||bis_utilities_pvt.escape_html_input(l_labels_tbl(i).label);

3210: END IF;
3211:
3212: -- mdamle 01/15/2001 - Added quotes around the VALUE
3213: l_string1 := l_string1 ||'';
3214: l_string1 := l_string1 ||bis_utilities_pvt.escape_html_input(l_labels_tbl(i).label);
3215:
3216: end LOOP;
3217: end if; -- if l_labels_tbl is empty
3218:

Line 3231: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_text);

3227: IF ( (instr(l_value, '*Y', -1, 1 ) = 0) AND (instr(l_value, '*N', -1, 1 ) = 0)) THEN
3228: l_value := l_value || '*Y'; -- first time added
3229: END IF;
3230: -- mdamle 01/15/2001 - Added quotes around the VALUE
3231: l_string1 := l_string1 ||''||bis_utilities_pvt.escape_html_input(l_text);
3232: exit when p_displaylabels_tbl(i) is NULL;
3233: end LOOP;
3234: end if; -- endif for checking if p_ind_level_id is null or not
3235:

Line 3244: l_string1 := l_string1 ||'';
3242:
3243: IF(l_swan_enabled)THEN
3244: l_string1 := l_string1 ||'';
3250: l_string1 := l_string1 ||'

';

Line 3249: l_string1 := l_string1 ||icx_util.replace_alt_quotes(BIS_UTILITIES_PVT.getPrompt('BIS_UP'))||'" BORDER="0">';

3245: ELSE
3246: l_string1 := l_string1 ||'';
3250: l_string1 := l_string1 ||'';
3251: l_string1 := l_string1 ||'

';
3251: l_string1 := l_string1 ||'';
3259: l_string1 := l_string1 ||'

'||bis_utilities_pvt.escape_html(c_tarlevels_homepage) ||'	'||bis_utilities_pvt.escape_html(c_tarlevels_homepage) ||'		'||bis_utilities_pvt.escape_html(c_tarlevels_homepage) ||'
'||bis_utilities_pvt.escape_html(c_tarlevels_homepage) ||'	'||bis_utilities_pvt.escape_html(c_tarlevels_homepage) ||'
'; 3252: IF(l_swan_enabled)THEN 3253: l_string1 := l_string1 ||''; 3250: l_string1 := l_string1 ||'
'; 3252: IF(l_swan_enabled)THEN 3253: l_string1 := l_string1 ||''; Line 3255: l_string1 := l_string1 ||''; 3252: IF(l_swan_enabled)THEN 3253: l_string1 := l_string1 ||''; 3258: l_string1 := l_string1 ||'

';

Line 3257: l_string1 := l_string1 ||icx_util.replace_alt_quotes(BIS_UTILITIES_PVT.getPrompt('BIS_DOWN'))||'" BORDER="0">';

3253: l_string1 := l_string1 ||'';
3258: l_string1 := l_string1 ||'';
3259: l_string1 := l_string1 ||'';
3260: l_string1 := l_string1 ||'';
3261: l_string1 := l_string1 || '';

Line 3271: -- BIS_UTILITIES_PVT.getPrompt('BIS_EDIT')

3267: l_string1 := l_string1 ||'';
3268:
3269: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
3270: --icx_plug_utilities.buttonBoth(
3271: -- BIS_UTILITIES_PVT.getPrompt('BIS_EDIT')
3272: -- ,'Javascript:editTo()');
3273: l_button_tbl(1).left_edge := l_button_edge;
3274: l_button_tbl(1).right_edge := l_button_edge;
3275: l_button_tbl(1).disabled := FND_API.G_FALSE;

Line 3276: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_EDIT');

3272: -- ,'Javascript:editTo()');
3273: l_button_tbl(1).left_edge := l_button_edge;
3274: l_button_tbl(1).right_edge := l_button_edge;
3275: l_button_tbl(1).disabled := FND_API.G_FALSE;
3276: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_EDIT');
3277: l_button_tbl(1).href := 'Javascript:editTo()';
3278: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
3279: l_string1 := l_string1 ||l_button_str;
3280:

Line 3278: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

3274: l_button_tbl(1).right_edge := l_button_edge;
3275: l_button_tbl(1).disabled := FND_API.G_FALSE;
3276: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_EDIT');
3277: l_button_tbl(1).href := 'Javascript:editTo()';
3278: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
3279: l_string1 := l_string1 ||l_button_str;
3280:
3281: l_string1 := l_string1 ||'';
3282: l_string1 := l_string1 ||'';

Line 3286: -- BIS_UTILITIES_PVT.getPrompt('BIS_DELETE')

3282: l_string1 := l_string1 ||'';
3283:
3284: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
3285: --icx_plug_utilities.buttonBoth(
3286: -- BIS_UTILITIES_PVT.getPrompt('BIS_DELETE')
3287: -- ,'Javascript:deleteTo()');
3288: l_button_tbl(1).left_edge := l_button_edge;
3289: l_button_tbl(1).right_edge := l_button_edge;
3290: l_button_tbl(1).disabled := FND_API.G_FALSE;

Line 3291: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');

3287: -- ,'Javascript:deleteTo()');
3288: l_button_tbl(1).left_edge := l_button_edge;
3289: l_button_tbl(1).right_edge := l_button_edge;
3290: l_button_tbl(1).disabled := FND_API.G_FALSE;
3291: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
3292: l_button_tbl(1).href := 'Javascript:deleteTo()';
3293: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
3294: l_string1 := l_string1 ||l_button_str;
3295: l_string1 := l_string1 ||'';

Line 3293: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

3289: l_button_tbl(1).right_edge := l_button_edge;
3290: l_button_tbl(1).disabled := FND_API.G_FALSE;
3291: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_DELETE');
3292: l_button_tbl(1).href := 'Javascript:deleteTo()';
3293: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
3294: l_string1 := l_string1 ||l_button_str;
3295: l_string1 := l_string1 ||'';
3296: l_string1 := l_string1 ||'';
3297: l_string1 := l_string1 ||'';

Line 3327: --icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'),

3323: --meastmon 06/20/2001. Added valign attribute
3324: l_string1 := l_string1 ||'';
3363: l_string1 := l_string1 ||'

'; -- ok 3325: 3326: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that. 3327: --icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'), 3328: -- 'Javascript:savedimensions()'); 3329: l_button_tbl(1).left_edge := l_button_edge; 3330: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE; 3331: l_button_tbl(1).disabled := FND_API.G_FALSE; Line 3330: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE; 3326: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that. 3327: --icx_plug_utilities.buttonLeft(BIS_UTILITIES_PVT.getPrompt('BIS_OK'), 3328: -- 'Javascript:savedimensions()'); 3329: l_button_tbl(1).left_edge := l_button_edge; 3330: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE; 3331: l_button_tbl(1).disabled := FND_API.G_FALSE; 3332: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_OK'); 3333: l_button_tbl(1).href := 'Javascript:savedimensions()'; 3334: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str); Line 3332: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_OK'); 3328: -- 'Javascript:savedimensions()'); 3329: l_button_tbl(1).left_edge := l_button_edge; 3330: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE; 3331: l_button_tbl(1).disabled := FND_API.G_FALSE; 3332: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_OK'); 3333: l_button_tbl(1).href := 'Javascript:savedimensions()'; 3334: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str); 3335: l_string1 := l_string1 ||l_button_str; 3336: Line 3334: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str); 3330: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE; 3331: l_button_tbl(1).disabled := FND_API.G_FALSE; 3332: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_OK'); 3333: l_button_tbl(1).href := 'Javascript:savedimensions()'; 3334: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str); 3335: l_string1 := l_string1 ||l_button_str; 3336: 3337: l_string1 := l_string1 ||''; 3338: --meastmon 06/20/2001. Added valign attribute Line 3352: --icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'), 3348: l_string1 := l_string1 ||''; 3349: --l_string1 := l_string1 ||''; 3350: 3351: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that. 3352: --icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'), 3353: -- 'Javascript:document.actionback.submit()'); 3354: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE; 3355: l_button_tbl(1).right_edge := l_button_edge; 3356: l_button_tbl(1).disabled := FND_API.G_FALSE; Line 3354: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE; 3350: 3351: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that. 3352: --icx_plug_utilities.buttonRight(BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'), 3353: -- 'Javascript:document.actionback.submit()'); 3354: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE; 3355: l_button_tbl(1).right_edge := l_button_edge; 3356: l_button_tbl(1).disabled := FND_API.G_FALSE; 3357: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'); 3358: l_button_tbl(1).href := 'Javascript:doCancel()'; Line 3357: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'); 3353: -- 'Javascript:document.actionback.submit()'); 3354: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE; 3355: l_button_tbl(1).right_edge := l_button_edge; 3356: l_button_tbl(1).disabled := FND_API.G_FALSE; 3357: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'); 3358: l_button_tbl(1).href := 'Javascript:doCancel()'; 3359: --l_button_tbl(1).href := 'Javascript:document.actionback.submit()'; 3360: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str); 3361: l_string1 := l_string1 ||l_button_str; Line 3360: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str); 3356: l_button_tbl(1).disabled := FND_API.G_FALSE; 3357: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'); 3358: l_button_tbl(1).href := 'Javascript:doCancel()'; 3359: --l_button_tbl(1).href := 'Javascript:document.actionback.submit()'; 3360: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str); 3361: l_string1 := l_string1 ||l_button_str; 3362: l_string1 := l_string1 ||'

';
3364: l_string1 := l_string1 ||'';

Line 3511: l_button_tbl BIS_UTILITIES_PVT.HTML_Button_Tbl_Type;

3507:
3508: -- meastmon 06/20/2001
3509: -- Fix for ADA buttons
3510: l_button_str varchar2(32000);
3511: l_button_tbl BIS_UTILITIES_PVT.HTML_Button_Tbl_Type;
3512: l_set_of_books_id VARCHAR2(200);
3513:
3514: l_dim_level_value_rec_p BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
3515: l_string VARCHAR2(32000);

Line 3565: l_swan_enabled := BIS_UTILITIES_PVT.checkSWANEnabled();

3561: BEGIN
3562:
3563: -- meastmon 09/07/2001 Fix bug#1980577. Workaround Do not encrypt plug_id
3564: l_plug_id := Z;
3565: l_swan_enabled := BIS_UTILITIES_PVT.checkSWANEnabled();
3566:
3567: --l_plug_id := icx_call.decrypt2(Z);
3568:
3569: --if icx_sec.validateSession then

Line 4189: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_tarlevel) ||'';

4185: l_string := l_string ||'';
4186: l_string := l_string ||'';
4187: l_string := l_string ||'';
4188: l_string := l_string ||'';
4189: l_string := l_string ||'';
4190: l_string := l_string ||'';
4191: l_string := l_string ||'';
4192: l_string := l_string ||'

'||bis_utilities_pvt.escape_html(c_tarlevel) ||'

'||bis_utilities_pvt.escape_html(l_indlevel_name)||'

';
4193: l_string := l_string ||'';

Line 4190: l_string := l_string ||''||bis_utilities_pvt.escape_html(l_indlevel_name)||'';

4186: l_string := l_string ||'';
4187: l_string := l_string ||'';
4188: l_string := l_string ||'';
4189: l_string := l_string ||'';
4190: l_string := l_string ||'';
4191: l_string := l_string ||'';
4192: l_string := l_string ||'

'||bis_utilities_pvt.escape_html(c_tarlevel) ||'

'||bis_utilities_pvt.escape_html(l_indlevel_name)||'

';
4193: l_string := l_string ||'';
4194: l_string := l_string ||'';

Line 4212: l_string := l_string ||l_append_string||bis_utilities_pvt.escape_html(c_dim_and_plan)||'';

4208: ELSE
4209: l_append_string := '';
4210: END IF;
4211:
4212: l_string := l_string ||l_append_string||bis_utilities_pvt.escape_html(c_dim_and_plan)||'';
4213: l_string := l_string ||'';
4214: l_string := l_string ||'';
4215: l_string := l_string ||'';
4216: l_string := l_string ||'';

Line 4309: l_string := l_string ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';

4305: l_string := l_string ||'';
4306: -- meastmon 06/07/2001
4307: l_string := l_string ||'';
4308: l_string := l_string ||'';
4309: l_string := l_string ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';
4310: l_string := l_string ||'';
4311: l_string := l_string ||'';
4312: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(LOWER(l_Org_Level_Short_Name));
4313: l_string := l_string ||'';

Line 4312: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(LOWER(l_Org_Level_Short_Name));

4308: l_string := l_string ||'';
4309: l_string := l_string ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';
4310: l_string := l_string ||'';
4311: l_string := l_string ||'';
4312: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(LOWER(l_Org_Level_Short_Name));
4313: l_string := l_string ||'';
4314: else
4315: -- Print out NOCOPY label and input box for dimension0
4316: l_string := l_string ||'';

Line 4328: l_string := l_string ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';

4324: l_string := l_string ||'';
4325: end if;
4326:
4327: l_string := l_string ||'';
4328: l_string := l_string ||''||bis_utilities_pvt.escape_html(l_Org_Level_Name)||'';
4329: l_string := l_string ||'';
4330: l_string := l_string ||'';
4331: l_string := l_string ||'';
4332:

Line 4354: l_string := l_string ||''||l_dim0_level_value_rec.Dimension_level_Value_Name;

4350: x_Return_Status => l_return_status,
4351: x_error_Tbl => l_error_tbl
4352: );
4353:
4354: l_string := l_string ||''||l_dim0_level_value_rec.Dimension_level_Value_Name;
4355:
4356:
4357:
4358:

Line 4366: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d0_tbl(i).name);

4362: p_value => l_d0,
4363: x_unique_tbl => l_d0_tbl);
4364: for i in 1 ..l_d0_tbl.COUNT LOOP
4365: exit when (l_d0_tbl(i).id is NULL);
4366: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d0_tbl(i).name);
4367: end loop;
4368: end if;
4369: l_string := l_string ||'

'||c_choose;
4370: l_string := l_string ||'';

Line 4390: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension1_Level_Name) ||'';

4386: else
4387: -- Print out NOCOPY label and input box for dimension1
4388: l_string := l_string ||'';
4389: l_string := l_string ||'';
4390: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension1_Level_Name) ||'';
4391: l_string := l_string ||'';
4392: l_string := l_string ||'';
4393: l_string := l_string ||'';
4394:

Line 4412: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim1_level_value_rec.Dimension_level_Value_Name);

4408: x_Return_Status => l_return_status,
4409: x_error_Tbl => l_error_tbl
4410: );
4411:
4412: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim1_level_value_rec.Dimension_level_Value_Name);
4413: end if;
4414:
4415: if (l_dim1_tbl.COUNT <> 0) THEN
4416: removeDuplicates(p_original_tbl => l_dim1_tbl,

Line 4422: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d1_tbl(i).name);

4418: x_unique_tbl => l_d1_tbl);
4419: for i in 1 ..l_d1_tbl.COUNT LOOP
4420: exit when (l_d1_tbl(i).id is NULL);
4421: -- mdamle - 01/15/2001 - Add quotes around VALUE
4422: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d1_tbl(i).name);
4423: end loop;
4424: end if;
4425: l_string := l_string ||'

'||c_choose;
4426: l_string := l_string ||'';

Line 4449: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension2_Level_Name) ||'';

4445: end if;
4446: else -- Print out NOCOPY label and input box for dimension2
4447: l_string := l_string ||'';
4448: l_string := l_string ||'';
4449: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension2_Level_Name) ||'';
4450: l_string := l_string ||'';
4451: l_string := l_string ||'';
4452: l_string := l_string ||'';
4453:

Line 4476: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim2_level_value_rec.Dimension_level_Value_Name);

4472: x_error_Tbl => l_error_tbl
4473: );
4474:
4475:
4476: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim2_level_value_rec.Dimension_level_Value_Name);
4477: end if;
4478:
4479: if (l_dim2_tbl.COUNT <> 0) THEN
4480: removeDuplicates(p_original_tbl => l_dim2_tbl,

Line 4485: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d2_tbl(i).name);

4481: p_value => l_d2,
4482: x_unique_tbl => l_d2_tbl);
4483: for i in 1 ..l_d2_tbl.COUNT LOOP
4484: exit when (l_d2_tbl(i).id is NULL);
4485: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d2_tbl(i).name);
4486: end loop;
4487: end if;
4488: l_string := l_string ||'

'||c_choose;
4489: l_string := l_string ||'';

Line 4508: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension3_Level_Name) ||'';

4504: end if;
4505: else -- Print out NOCOPY label and input box for dimension3
4506: l_string := l_string ||'';
4507: l_string := l_string ||'';
4508: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension3_Level_Name) ||'';
4509: l_string := l_string ||'';
4510: l_string := l_string ||'';
4511: l_string := l_string ||'';
4512:

Line 4530: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim3_level_value_rec.Dimension_level_Value_Name);

4526: x_Return_Status => l_return_status,
4527: x_error_Tbl => l_error_tbl
4528: );
4529:
4530: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim3_level_value_rec.Dimension_level_Value_Name);
4531: end if;
4532:
4533: if (l_dim3_tbl.COUNT <> 0) THEN
4534: removeDuplicates(p_original_tbl => l_dim3_tbl,

Line 4540: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d3_tbl(i).name);

4536: x_unique_tbl => l_d3_tbl);
4537: for i in 1 ..l_d3_tbl.COUNT LOOP
4538: exit when (l_d3_tbl(i).id is NULL);
4539: -- mdamle - 01/15/2001 - Add quotes around VALUE
4540: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d3_tbl(i).name);
4541: end loop;
4542: end if;
4543: l_string := l_string ||'

'||c_choose;
4544: l_string := l_string ||'';

Line 4564: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension4_Level_Name) ||'';

4560: else
4561: -- Print out NOCOPY label and input box for dimension4
4562: l_string := l_string ||'';
4563: l_string := l_string ||'';
4564: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension4_Level_Name) ||'';
4565: l_string := l_string ||'';
4566: l_string := l_string ||'';
4567: l_string := l_string ||'';
4568:

Line 4585: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim4_level_value_rec.Dimension_level_Value_Name);

4581: x_Dim_Level_Value_rec => l_dim4_level_value_rec,
4582: x_Return_Status => l_return_status,
4583: x_error_Tbl => l_error_tbl
4584: );
4585: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim4_level_value_rec.Dimension_level_Value_Name);
4586: end if;
4587:
4588: if (l_dim4_tbl.COUNT <> 0) THEN
4589: removeDuplicates(p_original_tbl => l_dim4_tbl,

Line 4596: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d4_tbl(i).name);

4592: for i in 1 ..l_d4_tbl.COUNT LOOP
4593: exit when (l_d4_tbl(i).id is NULL);
4594: -- mdamle - 01/15/2001 - Add quotes around VALUE
4595:
4596: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d4_tbl(i).name);
4597: end loop;
4598: end if;
4599: l_string := l_string ||'

'||c_choose;
4600: l_string := l_string ||'';

Line 4622: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension5_Level_Name) ||'';

4618: else
4619: -- Print out NOCOPY label and input box for dimension5
4620: l_string := l_string ||'';
4621: l_string := l_string ||'';
4622: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension5_Level_Name) ||'';
4623: l_string := l_string ||'';
4624: l_string := l_string ||'';
4625: l_string := l_string ||'';
4626: if (l_d5 <> c_hash) then

Line 4643: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim5_level_value_rec.Dimension_level_Value_Name);

4639: x_Return_Status => l_return_status,
4640: x_error_Tbl => l_error_tbl
4641: );
4642:
4643: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim5_level_value_rec.Dimension_level_Value_Name);
4644: end if;
4645:
4646: if (l_dim5_tbl.COUNT <> 0) THEN
4647: removeDuplicates(p_original_tbl => l_dim5_tbl,

Line 4652: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d5_tbl(i).name);

4648: x_unique_tbl => l_d5_tbl);
4649: for i in 1 ..l_d5_tbl.COUNT LOOP
4650: exit when (l_d5_tbl(i).id is NULL);
4651: -- mdamle - 01/15/2001 - Add quotes around VALUE
4652: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d5_tbl(i).name);
4653: end loop;
4654: end if;
4655: l_string := l_string ||'

'||c_choose;
4656: l_string := l_string ||'';

Line 4682: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension6_Level_Name) ||'';

4678: end if;
4679: else -- Print out NOCOPY label and input box for dimension6
4680: l_string := l_string ||'';
4681: l_string := l_string ||'';
4682: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension6_Level_Name) ||'';
4683: l_string := l_string ||'';
4684: l_string := l_string ||'';
4685: l_string := l_string ||'';
4686:

Line 4707: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim6_level_value_rec.Dimension_level_Value_Name);

4703:
4704:
4705:
4706:
4707: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim6_level_value_rec.Dimension_level_Value_Name);
4708: end if;
4709:
4710: if (l_dim6_tbl.COUNT <> 0) THEN
4711: removeDuplicates(p_original_tbl => l_dim6_tbl,

Line 4716: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d6_tbl(i).name);

4712: x_unique_tbl => l_d6_tbl);
4713: for i in 1 ..l_d6_tbl.COUNT LOOP
4714: exit when (l_d6_tbl(i).id is NULL);
4715: -- mdamle - 01/15/2001 - Add quotes around VALUE
4716: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d6_tbl(i).name);
4717: end loop;
4718: end if;
4719: l_string := l_string ||'

'||c_choose;
4720: l_string := l_string ||'';

Line 4746: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension7_Level_Name) ||'';

4742: end if;
4743: else -- Print out NOCOPY label and input box for dimension7
4744: l_string := l_string ||'';
4745: l_string := l_string ||'';
4746: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_recs.Dimension7_Level_Name) ||'';
4747: l_string := l_string ||'';
4748: l_string := l_string ||'';
4749: l_string := l_string ||'';
4750:

Line 4770: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim7_level_value_rec.Dimension_level_Value_Name);

4766: x_Return_Status => l_return_status,
4767: x_error_Tbl => l_error_tbl
4768: );
4769:
4770: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_dim7_level_value_rec.Dimension_level_Value_Name);
4771: end if;
4772:
4773: if (l_dim7_tbl.COUNT <> 0) THEN
4774: removeDuplicates(p_original_tbl => l_dim7_tbl,

Line 4779: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d7_tbl(i).name);

4775: x_unique_tbl => l_d7_tbl);
4776: for i in 1 ..l_d7_tbl.COUNT LOOP
4777: exit when (l_d7_tbl(i).id is NULL);
4778: -- mdamle - 01/15/2001 - Add quotes around VALUE
4779: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(l_d7_tbl(i).name);
4780: end loop;
4781: end if;
4782: l_string := l_string ||'

'||c_choose;
4783: l_string := l_string ||'';

Line 4796: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_plan)||'';

4792:
4793: -- Have a poplist for the Business Plan
4794: l_string := l_string ||'';
4795: l_string := l_string ||'';
4796: l_string := l_string ||''||bis_utilities_pvt.escape_html(c_plan)||'';
4797: l_string := l_string ||'';
4798: l_string := l_string ||'';
4799:
4800:

Line 4805: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(pl.name);

4801:
4802:
4803: for pl in plan_cur loop
4804: if pl.plan_id = TO_NUMBER(l_plan) then
4805: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(pl.name);
4806: else
4807: l_string := l_string ||'

'||bis_utilities_pvt.escape_html_input(pl.name);
4808: end if;
4809: end loop;

Line 4807: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(pl.name);

4803: for pl in plan_cur loop
4804: if pl.plan_id = TO_NUMBER(l_plan) then
4805: l_string := l_string ||'

'||bis_utilities_pvt.escape_html_input(pl.name);
4806: else
4807: l_string := l_string ||''||bis_utilities_pvt.escape_html_input(pl.name);
4808: end if;
4809: end loop;
4810:
4811: l_string := l_string ||'';

Line 4868: -- (BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveRename()');

4864: l_string := l_string ||'';
4865:
4866: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
4867: --icx_plug_utilities.buttonLeft
4868: -- (BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveRename()');
4869: IF(l_swan_enabled)THEN
4870: l_button_edge:=BIS_UTILITIES_PVT.G_FLAT_EDGE;
4871: ELSE
4872: l_button_edge:=BIS_UTILITIES_PVT.G_ROUND_EDGE;

Line 4870: l_button_edge:=BIS_UTILITIES_PVT.G_FLAT_EDGE;

4866: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
4867: --icx_plug_utilities.buttonLeft
4868: -- (BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveRename()');
4869: IF(l_swan_enabled)THEN
4870: l_button_edge:=BIS_UTILITIES_PVT.G_FLAT_EDGE;
4871: ELSE
4872: l_button_edge:=BIS_UTILITIES_PVT.G_ROUND_EDGE;
4873: END IF;
4874:

Line 4872: l_button_edge:=BIS_UTILITIES_PVT.G_ROUND_EDGE;

4868: -- (BIS_UTILITIES_PVT.getPrompt('BIS_OK'),'javascript:saveRename()');
4869: IF(l_swan_enabled)THEN
4870: l_button_edge:=BIS_UTILITIES_PVT.G_FLAT_EDGE;
4871: ELSE
4872: l_button_edge:=BIS_UTILITIES_PVT.G_ROUND_EDGE;
4873: END IF;
4874:
4875: l_button_tbl(1).left_edge := l_button_edge;
4876: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;

Line 4876: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;

4872: l_button_edge:=BIS_UTILITIES_PVT.G_ROUND_EDGE;
4873: END IF;
4874:
4875: l_button_tbl(1).left_edge := l_button_edge;
4876: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
4877: l_button_tbl(1).disabled := FND_API.G_FALSE;
4878: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_OK');
4879: l_button_tbl(1).href := 'javascript:saveRename()';
4880: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

Line 4878: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_OK');

4874:
4875: l_button_tbl(1).left_edge := l_button_edge;
4876: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
4877: l_button_tbl(1).disabled := FND_API.G_FALSE;
4878: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_OK');
4879: l_button_tbl(1).href := 'javascript:saveRename()';
4880: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
4881: l_string := l_string ||l_button_str;
4882: l_string := l_string ||'';

Line 4880: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

4876: l_button_tbl(1).right_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
4877: l_button_tbl(1).disabled := FND_API.G_FALSE;
4878: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_OK');
4879: l_button_tbl(1).href := 'javascript:saveRename()';
4880: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
4881: l_string := l_string ||l_button_str;
4882: l_string := l_string ||'';
4883:
4884: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.

Line 4886: -- (BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');

4882: l_string := l_string ||'';
4883:
4884: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
4885: --icx_plug_utilities.buttonRight
4886: -- (BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
4887: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
4888: l_button_tbl(1).right_edge := l_button_edge;
4889: l_button_tbl(1).disabled := FND_API.G_FALSE;
4890: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');

Line 4887: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;

4883:
4884: --meastmon ICX Button is not ADA Complaint. ICX is not going to fix that.
4885: --icx_plug_utilities.buttonRight
4886: -- (BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
4887: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
4888: l_button_tbl(1).right_edge := l_button_edge;
4889: l_button_tbl(1).disabled := FND_API.G_FALSE;
4890: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');
4891: l_button_tbl(1).href := 'javascript:window.close()';

Line 4890: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');

4886: -- (BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL'),'javascript:window.close()');
4887: l_button_tbl(1).left_edge := BIS_UTILITIES_PVT.G_FLAT_EDGE;
4888: l_button_tbl(1).right_edge := l_button_edge;
4889: l_button_tbl(1).disabled := FND_API.G_FALSE;
4890: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');
4891: l_button_tbl(1).href := 'javascript:window.close()';
4892: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
4893: l_string := l_string || l_button_str;
4894: l_string := l_string ||'';

Line 4892: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);

4888: l_button_tbl(1).right_edge := l_button_edge;
4889: l_button_tbl(1).disabled := FND_API.G_FALSE;
4890: l_button_tbl(1).label := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');
4891: l_button_tbl(1).href := 'javascript:window.close()';
4892: BIS_UTILITIES_PVT.GetButtonString(l_button_tbl, l_button_str);
4893: l_string := l_string || l_button_str;
4894: l_string := l_string ||'';
4895: l_string := l_string ||'';
4896: l_string := l_string ||'';

Line 5267: AND y.short_name like BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL)

5263: begin
5264: SELECT x.sequence_no into l_OrgSeqNum
5265: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
5266: WHERE x.dimension_id = y.dimension_id
5267: AND y.short_name like BIS_UTILITIES_PVT.GET_ORG_DIMENSION_NAME_TL(p_target_level_id,NULL)
5268: AND x.indicator_id = z.indicator_id
5269: AND z.target_level_id = p_target_level_id;
5270: exception
5271: when others then

Line 5289: AND y.short_name like BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL)

5285: begin
5286: SELECT x.sequence_no into l_TimeSeqNum
5287: FROM bis_indicator_dimensions x, bis_dimensions y, bis_target_levels z
5288: WHERE x.dimension_id = y.dimension_id
5289: AND y.short_name like BIS_UTILITIES_PVT.GET_TIME_DIMENSION_NAME_TL(p_target_level_id,NULL)
5290: AND x.indicator_id = z.indicator_id
5291: AND z.target_level_id = p_target_level_id ;
5292: exception
5293: when others then

Line 5796:

5792:
5793: l_HTML_Header :=
5794: '
5795:
5796:
5797:
5800: