eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_PORTLET_PMREGION dependencies on BIS_INDICATOR_REGION_UI_PVT

Line 524: nls_language_code := BIS_INDICATOR_REGION_UI_PVT.Get_NLS_Language;

520: nls_language_code varchar2(20000);
521: icx_report_images varchar2(20000);
522: HTML_banner varchar2(32000);
523: begin
524: nls_language_code := BIS_INDICATOR_REGION_UI_PVT.Get_NLS_Language;
525: icx_report_images := BIS_INDICATOR_REGION_UI_PVT.Get_Images_Server;
526:
527: Build_HTML_Banner (icx_report_images -------------- VERSION 5 (call to)
528: , help_target

Line 525: icx_report_images := BIS_INDICATOR_REGION_UI_PVT.Get_Images_Server;

521: icx_report_images varchar2(20000);
522: HTML_banner varchar2(32000);
523: begin
524: nls_language_code := BIS_INDICATOR_REGION_UI_PVT.Get_NLS_Language;
525: icx_report_images := BIS_INDICATOR_REGION_UI_PVT.Get_Images_Server;
526:
527: Build_HTML_Banner (icx_report_images -------------- VERSION 5 (call to)
528: , help_target
529: , nls_language_code

Line 591: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RELATED', Related_Alt, Related_Description);

587: Parampage_Description VARCHAR2(32000);
588:
589: BEGIN
590:
591: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RELATED', Related_Alt, Related_Description);
592: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('MENU', Menu_Alt, Menu_Description);
593: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HOME', Home_Alt, Home_Description);
594: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HELP', Help_Alt, Help_Description);
595: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMPAGE', Parampage_Alt, Parampage_Description);

Line 592: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('MENU', Menu_Alt, Menu_Description);

588:
589: BEGIN
590:
591: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RELATED', Related_Alt, Related_Description);
592: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('MENU', Menu_Alt, Menu_Description);
593: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HOME', Home_Alt, Home_Description);
594: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HELP', Help_Alt, Help_Description);
595: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMPAGE', Parampage_Alt, Parampage_Description);
596:

Line 593: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HOME', Home_Alt, Home_Description);

589: BEGIN
590:
591: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RELATED', Related_Alt, Related_Description);
592: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('MENU', Menu_Alt, Menu_Description);
593: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HOME', Home_Alt, Home_Description);
594: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HELP', Help_Alt, Help_Description);
595: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMPAGE', Parampage_Alt, Parampage_Description);
596:
597: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RETURNTOPORTAL', Return_Alt, Return_Description);

Line 594: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HELP', Help_Alt, Help_Description);

590:
591: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RELATED', Related_Alt, Related_Description);
592: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('MENU', Menu_Alt, Menu_Description);
593: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HOME', Home_Alt, Home_Description);
594: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HELP', Help_Alt, Help_Description);
595: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMPAGE', Parampage_Alt, Parampage_Description);
596:
597: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RETURNTOPORTAL', Return_Alt, Return_Description);
598: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMETERS', Parameters_Alt, Parameters_Description);

Line 595: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMPAGE', Parampage_Alt, Parampage_Description);

591: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RELATED', Related_Alt, Related_Description);
592: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('MENU', Menu_Alt, Menu_Description);
593: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HOME', Home_Alt, Home_Description);
594: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HELP', Help_Alt, Help_Description);
595: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMPAGE', Parampage_Alt, Parampage_Description);
596:
597: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RETURNTOPORTAL', Return_Alt, Return_Description);
598: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMETERS', Parameters_Alt, Parameters_Description);
599: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWHELP', NewHelp_Alt, NewHelp_Description);

Line 597: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RETURNTOPORTAL', Return_Alt, Return_Description);

593: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HOME', Home_Alt, Home_Description);
594: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HELP', Help_Alt, Help_Description);
595: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMPAGE', Parampage_Alt, Parampage_Description);
596:
597: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RETURNTOPORTAL', Return_Alt, Return_Description);
598: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMETERS', Parameters_Alt, Parameters_Description);
599: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWHELP', NewHelp_Alt, NewHelp_Description);
600: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWMENU', NewMenu_Alt, NewMenu_Description);
601:

Line 598: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMETERS', Parameters_Alt, Parameters_Description);

594: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('HELP', Help_Alt, Help_Description);
595: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMPAGE', Parampage_Alt, Parampage_Description);
596:
597: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RETURNTOPORTAL', Return_Alt, Return_Description);
598: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMETERS', Parameters_Alt, Parameters_Description);
599: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWHELP', NewHelp_Alt, NewHelp_Description);
600: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWMENU', NewMenu_Alt, NewMenu_Description);
601:
602: -- mdamle 05/31/2001 - New ICX Profile for OA_HTML, OA_MEDIA

Line 599: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWHELP', NewHelp_Alt, NewHelp_Description);

595: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMPAGE', Parampage_Alt, Parampage_Description);
596:
597: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RETURNTOPORTAL', Return_Alt, Return_Description);
598: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMETERS', Parameters_Alt, Parameters_Description);
599: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWHELP', NewHelp_Alt, NewHelp_Description);
600: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWMENU', NewMenu_Alt, NewMenu_Description);
601:
602: -- mdamle 05/31/2001 - New ICX Profile for OA_HTML, OA_MEDIA
603: -- l_css := FND_PROFILE.value('ICX_OA_HTML');

Line 600: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWMENU', NewMenu_Alt, NewMenu_Description);

596:
597: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('RETURNTOPORTAL', Return_Alt, Return_Description);
598: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('PARAMETERS', Parameters_Alt, Parameters_Description);
599: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWHELP', NewHelp_Alt, NewHelp_Description);
600: BIS_INDICATOR_REGION_UI_PVT.Get_Translated_Icon_Text ('NEWMENU', NewMenu_Alt, NewMenu_Description);
601:
602: -- mdamle 05/31/2001 - New ICX Profile for OA_HTML, OA_MEDIA
603: -- l_css := FND_PROFILE.value('ICX_OA_HTML');
604: --added '/' here , otherwise the style sheet was not getting picked

Line 1593: l_temp_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

1589: l_return_status VARCHAR2(32000);
1590: l_indicators_tbl BIS_TARGET_LEVEL_PUB.Target_Level_Tbl_Type;
1591: l_displaylabels_tbl Selected_Values_Tbl_Type;
1592: l_selections_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
1593: l_temp_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
1594: l_unique BOOLEAN;
1595: l_cnt pls_integer;
1596: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1597: -- meastmon 06/20/2001

Line 1892: cvalue=>bis_utilities_pvt.escape_html_input(BIS_INDICATOR_REGION_UI_PVT.getPerformanceMeasureName(l_indicators_tbl(i).target_level_id)),

1888: for i in l_indicators_tbl.FIRST .. l_indicators_tbl.COUNT loop
1889: -- mdamle 01/12/2001 - Change display text of Performance Measure list
1890: -- changed l_indicators_tbl(i).target_level_name to getPerformanceMeasureName()
1891: htp.formSelectOption(
1892: cvalue=>bis_utilities_pvt.escape_html_input(BIS_INDICATOR_REGION_UI_PVT.getPerformanceMeasureName(l_indicators_tbl(i).target_level_id)),
1893: cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_indicators_tbl(i).target_level_id));
1894:
1895: end loop;
1896: END IF;

Line 1921: htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(BIS_INDICATOR_REGION_UI_PVT.getPerformanceMeasureName(l_temp_tbl(i).id)),

1917: ELSE
1918: for i in l_temp_tbl.FIRST .. l_temp_tbl.COUNT loop
1919: -- mdamle 01/12/2001 - Change display text of Performance Measure list
1920: -- changed l_temp_tbl(i).name to getPerformanceMeasureName()
1921: htp.formSelectOption(cvalue=>bis_utilities_pvt.escape_html_input(BIS_INDICATOR_REGION_UI_PVT.getPerformanceMeasureName(l_temp_tbl(i).id)),
1922: cattributes=>'VALUE='||bis_utilities_pvt.escape_html_input(l_temp_tbl(i).id));
1923: end loop;
1924: END IF;
1925: else

Line 2118: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2114: l_loc PLS_INTEGER;
2115: l_value VARCHAR2(32000);
2116: l_text VARCHAR2(32000);
2117: l_labels_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
2118: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2119: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2120: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2121: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2122: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2119: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2115: l_value VARCHAR2(32000);
2116: l_text VARCHAR2(32000);
2117: l_labels_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
2118: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2119: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2120: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2121: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2122: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2123: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2120: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2116: l_text VARCHAR2(32000);
2117: l_labels_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
2118: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2119: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2120: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2121: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2122: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2123: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2124: -- mdamle 01/15/2001 - Use Dim6 and Dim7

Line 2121: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2117: l_labels_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
2118: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2119: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2120: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2121: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2122: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2123: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2124: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2125: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2122: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2118: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2119: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2120: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2121: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2122: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2123: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2124: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2125: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2126: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2123: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2119: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2120: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2121: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2122: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2123: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2124: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2125: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2126: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2127:

Line 2125: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2121: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2122: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2123: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2124: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2125: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2126: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2127:
2128: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2129: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2126: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2122: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2123: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2124: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2125: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2126: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2127:
2128: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2129: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2130: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2128: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2124: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2125: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2126: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2127:
2128: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2129: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2130: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2131: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2132: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2129: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2125: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2126: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2127:
2128: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2129: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2130: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2131: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2132: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2133: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2130: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2126: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2127:
2128: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2129: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2130: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2131: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2132: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2133: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2134: -- mdamle 01/15/2001 - Use Dim6 and Dim7

Line 2131: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2127:
2128: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2129: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2130: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2131: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2132: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2133: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2134: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2135: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2132: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2128: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2129: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2130: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2131: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2132: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2133: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2134: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2135: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2136: l_d7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 2133: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2129: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2130: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2131: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2132: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2133: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2134: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2135: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2136: l_d7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2137: -- meastmon 05/11/2001

Line 2135: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2131: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2132: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2133: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2134: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2135: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2136: l_d7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2137: -- meastmon 05/11/2001
2138: l_Time_Seq_Num number;
2139: --

Line 2136: l_d7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

2132: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2133: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2134: -- mdamle 01/15/2001 - Use Dim6 and Dim7
2135: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2136: l_d7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
2137: -- meastmon 05/11/2001
2138: l_Time_Seq_Num number;
2139: --
2140: l_Org_Seq_Num number;

Line 2672: BIS_INDICATOR_REGION_UI_PVT.clearSelect

2668: l_elements(2) := 'dim0';
2669: l_elements(3) := 'label';
2670: l_elements(4) := 'C';
2671:
2672: BIS_INDICATOR_REGION_UI_PVT.clearSelect
2673: ( p_formName => 'dimensions'
2674: , p_elementTable => l_elements
2675: , x_clearString => l_clear
2676: );

Line 2696: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(v_ind_level_id);

2692: l_dim4_lbl := c_recs.Dimension4_Level_Name;
2693: l_dim5_lbl := c_recs.Dimension5_Level_Name;
2694: l_dim6_lbl := c_recs.Dimension6_Level_Name;
2695: l_dim7_lbl := c_recs.Dimension7_Level_Name;
2696: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(v_ind_level_id);
2697:
2698: if l_Org_Seq_Num = 1 then
2699: l_dim0_lbl := c_recs.Dimension1_Level_Name;
2700: elsif l_Org_Seq_Num = 2 then

Line 3043: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(v_ind_level_id);

3039: END IF;
3040:
3041: -- mdamle 01/15/2001 - Use Dim6 and Dim7
3042: -- Get the Dimension No. for Org
3043: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(v_ind_level_id);
3044:
3045: IF (l_labels_tbl(i).dim1_level_value_id is NOT NULL) THEN
3046: l_dim1_tbl(l_cnt).id := l_labels_tbl(i).dim1_level_value_id;
3047: l_dim1_tbl(l_cnt).name := l_labels_tbl(i).dim1_level_value_name;

Line 3133: l_Time_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getTimeSeqNum(v_ind_level_id);

3129: -- ******************************
3130: -- Dimension0 for Organization
3131:
3132: -- meastmon 05/11/2001
3133: l_Time_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getTimeSeqNum(v_ind_level_id);
3134: htp.formHidden('timeDimension', l_Time_Seq_Num);
3135:
3136: -- mdamle 01/15/2001 - Use Dim6 and Dim7
3137: -- Get the Dimension No. for Org

Line 3138: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(v_ind_level_id);

3134: htp.formHidden('timeDimension', l_Time_Seq_Num);
3135:
3136: -- mdamle 01/15/2001 - Use Dim6 and Dim7
3137: -- Get the Dimension No. for Org
3138: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(v_ind_level_id);
3139: htp.formHidden('orgDimension', l_Org_Seq_Num);
3140:
3141: -- mdamle 01/15/2001 - Use Dim6 and Dim7
3142: if l_Org_Seq_Num = 1 then

Line 3213: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_orgs_tbl,

3209: htp.p('');
3210: htp.formSelectOpen('dim0',cattributes=>'onchange="setdim0()"');
3211: htp.formSelectOption(l_blank,cselected=>'YES');
3212: if (l_orgs_tbl.COUNT <> 0) THEN
3213: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_orgs_tbl,
3214: p_value => NULL,
3215: x_unique_tbl => l_d0_tbl);
3216: for i in 1 ..l_d0_tbl.COUNT LOOP
3217: exit when (l_d0_tbl(i).id is NULL);

Line 3250: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim1_tbl,

3246: htp.p('');
3247: htp.formSelectOpen('dim1',cattributes=>'onchange="setdim1()"');
3248: htp.formSelectOption(l_blank,cselected=>'YES');
3249: if (l_dim1_tbl.COUNT <> 0) THEN
3250: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim1_tbl,
3251: p_value => NULL,
3252: x_unique_tbl => l_d1_tbl);
3253: for i in 1 ..l_d1_tbl.COUNT LOOP
3254: exit when (l_d1_tbl(i).id is NULL);

Line 3286: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim2_tbl,

3282: htp.p('');
3283: htp.formSelectOpen('dim2',cattributes=>'onchange="setdim2()"');
3284: htp.formSelectOption(l_blank,cselected=>'YES');
3285: if (l_dim2_tbl.COUNT <> 0) THEN
3286: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim2_tbl,
3287: p_value => NULL,
3288: x_unique_tbl => l_d2_tbl);
3289: for i in 1 ..l_d2_tbl.COUNT LOOP
3290: exit when (l_d2_tbl(i).id is NULL);

Line 3322: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim3_tbl,

3318: htp.p('');
3319: htp.formSelectOpen('dim3',cattributes=>'onchange="setdim3()"');
3320: htp.formSelectOption(l_blank,cselected=>'YES');
3321: if (l_dim3_tbl.COUNT <> 0) THEN
3322: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim3_tbl,
3323: p_value => NULL,
3324: x_unique_tbl => l_d3_tbl);
3325: for i in 1 ..l_d3_tbl.COUNT LOOP
3326: exit when (l_d3_tbl(i).id is NULL);

Line 3358: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim4_tbl,

3354: htp.p('');
3355: htp.formSelectOpen('dim4',cattributes=>'onchange="setdim4()"');
3356: htp.formSelectOption(l_blank,cselected=>'YES');
3357: if (l_dim4_tbl.COUNT <> 0) THEN
3358: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim4_tbl,
3359: p_value => NULL,
3360: x_unique_tbl => l_d4_tbl);
3361: for i in 1 ..l_d4_tbl.COUNT LOOP
3362: exit when (l_d4_tbl(i).id is NULL);

Line 3395: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim5_tbl,

3391: htp.p('');
3392: htp.formSelectOpen('dim5',cattributes=>'onchange="setdim5()"');
3393: htp.formSelectOption(l_blank,cselected=>'YES');
3394: if (l_dim5_tbl.COUNT <> 0) THEN
3395: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim5_tbl,
3396: p_value => NULL,
3397: x_unique_tbl => l_d5_tbl);
3398: for i in 1 ..l_d5_tbl.COUNT LOOP
3399: exit when (l_d5_tbl(i).id is NULL);

Line 3432: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim6_tbl,

3428: htp.p('');
3429: htp.formSelectOpen('dim6',cattributes=>'onchange="setdim6()"');
3430: htp.formSelectOption(l_blank,cselected=>'YES');
3431: if (l_dim6_tbl.COUNT <> 0) THEN
3432: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim6_tbl,
3433: p_value => NULL,
3434: x_unique_tbl => l_d6_tbl);
3435: for i in 1 ..l_d6_tbl.COUNT LOOP
3436: exit when (l_d6_tbl(i).id is NULL);

Line 3469: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim7_tbl,

3465: htp.p('');
3466: htp.formSelectOpen('dim7',cattributes=>'onchange="setdim7()"');
3467: htp.formSelectOption(l_blank,cselected=>'YES');
3468: if (l_dim7_tbl.COUNT <> 0) THEN
3469: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim7_tbl,
3470: p_value => NULL,
3471: x_unique_tbl => l_d7_tbl);
3472: for i in 1 ..l_d7_tbl.COUNT LOOP
3473: exit when (l_d7_tbl(i).id is NULL);

Line 3605: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(l_labels_tbl(i).target_level_id);

3601:
3602: --meastmon 06/07/2001 - Bug.
3603: -- l_Org_Seq_Num should be initialized within the loop, because every loop
3604: -- it is a different target.
3605: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(l_labels_tbl(i).target_level_id);
3606:
3607: if l_Org_Seq_Num = 1 then
3608: l_Org_Level_Value_ID := l_labels_tbl(i).dim1_level_value_id;
3609: end if;

Line 3631: l_Time_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getTimeSeqNum(l_labels_tbl(i).target_level_id);

3627: end if;
3628:
3629: --meastmon 06/08/2001
3630: -- Dont need to put time level value id
3631: l_Time_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getTimeSeqNum(l_labels_tbl(i).target_level_id);
3632:
3633: -- mdamle 01/15/2001 - Replace plus in data with c_hash
3634: -- The browser converts plus into space - and incorrect data is passed through
3635: l_link := l_labels_tbl(i).target_level_id||

Line 3841: --htp.formOpen('bis_indicator_region_ui_pvt.setIndicators'

3837: htp.formHidden('p_back_url',p_back_url);
3838: htp.formHidden('p_reference_path', p_reference_path);
3839:
3840: --meastmon 06/20/2001. This should not be here
3841: --htp.formOpen('bis_indicator_region_ui_pvt.setIndicators'
3842: -- ,'POST','','','NAME="actionback"');
3843:
3844: htp.p('');
3845: htp.formClose;

Line 4117: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4113: l_dim6_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
4114: l_dim7_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
4115:
4116: l_favorites_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
4117: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4118: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4119: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4120: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4121: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4118: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4114: l_dim7_level_value_rec BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Rec_Type;
4115:
4116: l_favorites_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
4117: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4118: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4119: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4120: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4121: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4122: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4119: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4115:
4116: l_favorites_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
4117: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4118: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4119: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4120: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4121: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4122: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4123: -- mdamle 01/15/2001 - Use Dim6 and Dim7

Line 4120: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4116: l_favorites_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
4117: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4118: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4119: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4120: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4121: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4122: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4123: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4124: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4121: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4117: l_orgs_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4118: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4119: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4120: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4121: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4122: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4123: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4124: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4125: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4122: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4118: l_dim1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4119: l_dim2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4120: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4121: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4122: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4123: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4124: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4125: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4126:

Line 4124: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4120: l_dim3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4121: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4122: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4123: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4124: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4125: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4126:
4127: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4128: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4125: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4121: l_dim4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4122: l_dim5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4123: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4124: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4125: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4126:
4127: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4128: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4129: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4127: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4123: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4124: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4125: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4126:
4127: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4128: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4129: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4130: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4131: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4128: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4124: l_dim6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4125: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4126:
4127: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4128: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4129: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4130: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4131: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4132: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4129: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4125: l_dim7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4126:
4127: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4128: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4129: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4130: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4131: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4132: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4133: -- mdamle 01/15/2001 - Use Dim6 and Dim7

Line 4130: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4126:
4127: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4128: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4129: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4130: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4131: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4132: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4133: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4134: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4131: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4127: l_d0_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4128: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4129: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4130: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4131: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4132: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4133: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4134: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4135: l_d7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

Line 4132: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4128: l_d1_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4129: l_d2_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4130: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4131: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4132: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4133: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4134: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4135: l_d7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4136:

Line 4134: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4130: l_d3_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4131: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4132: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4133: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4134: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4135: l_d7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4136:
4137: l_d0_name varchar2(32000);
4138: l_d1_name varchar2(32000);

Line 4135: l_d7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;

4131: l_d4_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4132: l_d5_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4133: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4134: l_d6_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4135: l_d7_tbl BIS_INDICATOR_REGION_UI_PVT.no_duplicates_tbl_Type;
4136:
4137: l_d0_name varchar2(32000);
4138: l_d1_name varchar2(32000);
4139: l_d2_name varchar2(32000);

Line 4308: l_indlevel_name := BIS_INDICATOR_REGION_UI_PVT.getPerformanceMeasureName(l_indlevel_id);

4304: -- SELECT target_level_name
4305: -- INTO l_indlevel_name
4306: -- FROM BISBV_TARGET_LEVELS
4307: -- WHERE TARGET_LEVEL_ID = l_indlevel_id;
4308: l_indlevel_name := BIS_INDICATOR_REGION_UI_PVT.getPerformanceMeasureName(l_indlevel_id);
4309:
4310: -- Set the set of books id for GL dimension levels
4311: --
4312: SELECT level_id

Line 4324: l_org_level_id := BIS_INDICATOR_REGION_UI_PVT.getOrgLevelID(l_indlevel_id);

4320: INTO l_org_level_id
4321: FROM BIS_TARGET_LEVELS
4322: WHERE target_level_id = l_indlevel_ID;
4323:
4324: l_org_level_id := BIS_INDICATOR_REGION_UI_PVT.getOrgLevelID(l_indlevel_id);
4325:
4326: IF l_sob_level_id = l_org_level_ID
4327: THEN
4328: BIS_TARGET_PVT.G_SET_OF_BOOK_ID := TO_NUMBER(l_var1);

Line 4346: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(l_indlevel_id);

4342: END IF;
4343:
4344: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4345: -- Get the Dimension No. for Org
4346: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(l_indlevel_id);
4347:
4348: IF (l_favorites_tbl(i).dim1_level_value_id is NOT NULL) THEN
4349: l_dim1_tbl(l_cnt).id := l_favorites_tbl(i).dim1_level_value_id;
4350: l_dim1_tbl(l_cnt).name := l_favorites_tbl(i).dim1_level_value_name;

Line 4703: BIS_INDICATOR_REGION_UI_PVT.clearSelect

4699: l_elements(1) := 'plan';
4700: l_elements(2) := 'dim0';
4701: l_elements(3) := 'label';
4702:
4703: BIS_INDICATOR_REGION_UI_PVT.clearSelect
4704: ( p_formName => 'editDimensions'
4705: , p_elementTable => l_elements
4706: , x_clearString => l_clear
4707: );

Line 4939: l_Time_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getTimeSeqNum(l_indlevel_id);

4935: -- ******************************
4936: -- Dimension0 for Organization
4937:
4938: -- meastmon 06/07/2001
4939: l_Time_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getTimeSeqNum(l_indlevel_id);
4940: htp.formHidden('timeDimension', l_Time_Seq_Num);
4941:
4942: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4943: -- Get the Dimension No. for Org

Line 4944: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(l_indlevel_id);

4940: htp.formHidden('timeDimension', l_Time_Seq_Num);
4941:
4942: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4943: -- Get the Dimension No. for Org
4944: l_Org_Seq_Num := BIS_INDICATOR_REGION_UI_PVT.getOrgSeqNum(l_indlevel_id);
4945: htp.formHidden('orgDimension', l_Org_Seq_Num);
4946:
4947: -- mdamle 01/15/2001 - Use Dim6 and Dim7
4948: if l_Org_Seq_Num = 1 then

Line 5057: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_orgs_tbl,

5053: cselected=>'YES');
5054:
5055: end if;
5056: if (l_orgs_tbl.COUNT <> 0) THEN
5057: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_orgs_tbl,
5058: p_value => l_d0,
5059: x_unique_tbl => l_d0_tbl);
5060: for i in 1 ..l_d0_tbl.COUNT LOOP
5061: exit when (l_d0_tbl(i).id is NULL);

Line 5118: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim1_tbl,

5114: cselected=>'YES');
5115: end if;
5116:
5117: if (l_dim1_tbl.COUNT <> 0) THEN
5118: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim1_tbl,
5119: p_value => l_d1,
5120: x_unique_tbl => l_d1_tbl);
5121: for i in 1 ..l_d1_tbl.COUNT LOOP
5122: exit when (l_d1_tbl(i).id is NULL);

Line 5180: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim2_tbl,

5176: cselected=>'YES');
5177: end if;
5178:
5179: if (l_dim2_tbl.COUNT <> 0) THEN
5180: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim2_tbl,
5181: p_value => l_d2,
5182: x_unique_tbl => l_d2_tbl);
5183: for i in 1 ..l_d2_tbl.COUNT LOOP
5184: exit when (l_d2_tbl(i).id is NULL);

Line 5240: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim3_tbl,

5236: cselected=>'YES');
5237: end if;
5238:
5239: if (l_dim3_tbl.COUNT <> 0) THEN
5240: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim3_tbl,
5241: p_value => l_d3,
5242: x_unique_tbl => l_d3_tbl);
5243: for i in 1 ..l_d3_tbl.COUNT LOOP
5244: exit when (l_d3_tbl(i).id is NULL);

Line 5300: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim4_tbl,

5296: cselected=>'YES');
5297: end if;
5298:
5299: if (l_dim4_tbl.COUNT <> 0) THEN
5300: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim4_tbl,
5301: p_value => l_d4,
5302: x_unique_tbl => l_d4_tbl);
5303: for i in 1 ..l_d4_tbl.COUNT LOOP
5304: exit when (l_d4_tbl(i).id is NULL);

Line 5360: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim5_tbl,

5356: cselected=>'YES');
5357: end if;
5358:
5359: if (l_dim5_tbl.COUNT <> 0) THEN
5360: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim5_tbl,
5361: x_unique_tbl => l_d5_tbl);
5362: for i in 1 ..l_d5_tbl.COUNT LOOP
5363: exit when (l_d5_tbl(i).id is NULL);
5364: -- mdamle - 01/15/2001 - Add quotes around VALUE

Line 5419: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim6_tbl,

5415: cselected=>'YES');
5416: end if;
5417:
5418: if (l_dim6_tbl.COUNT <> 0) THEN
5419: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim6_tbl,
5420: x_unique_tbl => l_d6_tbl);
5421: for i in 1 ..l_d6_tbl.COUNT LOOP
5422: exit when (l_d6_tbl(i).id is NULL);
5423: -- mdamle - 01/15/2001 - Add quotes around VALUE

Line 5478: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim7_tbl,

5474: cselected=>'YES');
5475: end if;
5476:
5477: if (l_dim7_tbl.COUNT <> 0) THEN
5478: BIS_INDICATOR_REGION_UI_PVT.removeDuplicates(p_original_tbl => l_dim7_tbl,
5479: x_unique_tbl => l_d7_tbl);
5480: for i in 1 ..l_d7_tbl.COUNT LOOP
5481: exit when (l_d7_tbl(i).id is NULL);
5482: -- mdamle - 01/15/2001 - Add quotes around VALUE

Line 6618: l_image_path := BIS_INDICATOR_REGION_UI_PVT.Get_Images_Server;

6614: BEGIN
6615:
6616: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
6617: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
6618: l_image_path := BIS_INDICATOR_REGION_UI_PVT.Get_Images_Server;
6619: IF ( p_status = 1 ) THEN
6620: l_gif := 'bisinrng.gif';
6621: -- l_gif := 'okind_status.gif';
6622: l_range_lbl := l_in_range_lbl;

Line 6734: l_image_path := BIS_INDICATOR_REGION_UI_PVT.Get_Images_Server;

6730: l_html_string VARCHAR2(32000) := NULL;
6731: l_image_path VARCHAR2(250);
6732:
6733: BEGIN
6734: l_image_path := BIS_INDICATOR_REGION_UI_PVT.Get_Images_Server;
6735:
6736: l_html_string := l_html_string || ' 6737: l_html_string := l_html_string || ' 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);
6738: l_html_string := l_html_string || ' ';

Line 7345: BIS_INDICATOR_REGION_UI_PVT.getCurrentPeriodInfo(

7341: -- to the time dimension whith the value id of the current period.
7342: -- target level contain a time dimension.
7343: -- Get the time level value id and name to be used to get actual and target
7344: -- Right now this is the current period
7345: BIS_INDICATOR_REGION_UI_PVT.getCurrentPeriodInfo(
7346: p_ind_selection_id
7347: ,x_target_rec.target_level_id
7348: ,l_time_dimension_level_id
7349: ,l_current_period_id

Line 7360: IF ( NOT bis_indicator_region_ui_pvt.use_current_period(x_target_rec

7356: END IF;
7357:
7358: --bug#2173475, if current period id's actual not exist,
7359: --use the latest one
7360: IF ( NOT bis_indicator_region_ui_pvt.use_current_period(x_target_rec
7361: ,l_time_dimension_index
7362: ,l_current_period_id
7363: ,l_last_period_id) ) THEN
7364: -- should use last period id in query

Line 7493: BIS_INDICATOR_REGION_UI_PVT.getAKRegionItemLongLabel(p_comp_source,

7489:
7490: l_long_label := NULL;
7491:
7492: IF (p_comp_source IS NOT NULL) THEN -- comparison source is not null
7493: BIS_INDICATOR_REGION_UI_PVT.getAKRegionItemLongLabel(p_comp_source,
7494: l_long_label);
7495: IF (l_long_label IS NOT NULL) THEN
7496: x_arrow_alt_text := l_long_label ||'.';
7497: END IF;