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.BSC_ANALYSIS_OPTION_PVT dependencies on BSC_KPI_ANALYSIS_MEASURES_TL

Line 566: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

562: SET Analysis_Option0 = l_swap_Table(i).p_AnaOpt_Next_Id
563: WHERE Indicator = p_Kpi_Id
564: AND Analysis_Option0 = l_swap_Table(i).p_AnaOpt_Prev_Id;
565:
566: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
567: SET Analysis_Option0 = l_swap_Table(i).p_AnaOpt_Next_Id
568: WHERE Indicator = p_Kpi_Id
569: AND Analysis_Option0 = l_swap_Table(i).p_AnaOpt_Prev_Id;
570: END LOOP;

Line 578: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

574: SET Analysis_Option1 = l_swap_Table(i).p_AnaOpt_Next_Id
575: WHERE Indicator = p_Kpi_Id
576: AND Analysis_Option1 = l_swap_Table(i).p_AnaOpt_Prev_Id;
577:
578: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
579: SET Analysis_Option1 = l_swap_Table(i).p_AnaOpt_Next_Id
580: WHERE Indicator = p_Kpi_Id
581: AND Analysis_Option1 = l_swap_Table(i).p_AnaOpt_Prev_Id;
582: END LOOP;

Line 590: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

586: SET Analysis_Option2 = l_swap_Table(i).p_AnaOpt_Next_Id
587: WHERE Indicator = p_Kpi_Id
588: AND Analysis_Option2 = l_swap_Table(i).p_AnaOpt_Prev_Id;
589:
590: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
591: SET Analysis_Option2 = l_swap_Table(i).p_AnaOpt_Next_Id
592: WHERE Indicator = p_Kpi_Id
593: AND Analysis_Option2 = l_swap_Table(i).p_AnaOpt_Prev_Id;
594: END LOOP;

Line 724: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

720: SET Analysis_Option0 = l_swap_Table(i).p_AnaOpt_Next_Id
721: WHERE Indicator = p_Kpi_Id
722: AND Analysis_Option0 = l_swap_Table(i).p_AnaOpt_Prev_Id;
723:
724: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
725: SET Analysis_Option0 = l_swap_Table(i).p_AnaOpt_Next_Id
726: WHERE Indicator = p_Kpi_Id
727: AND Analysis_Option0 = l_swap_Table(i).p_AnaOpt_Prev_Id;
728: END LOOP;

Line 737: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

733: WHERE Indicator = p_Kpi_Id
734: AND Analysis_Option1 = l_swap_Table(i).p_AnaOpt_Prev_Id
735: AND Analysis_Option0 = p_Parent_Option_Id;
736:
737: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
738: SET Analysis_Option1 = l_swap_Table(i).p_AnaOpt_Next_Id
739: WHERE Indicator = p_Kpi_Id
740: AND Analysis_Option1 = l_swap_Table(i).p_AnaOpt_Prev_Id
741: AND Analysis_Option0 = p_Parent_Option_Id;

Line 752: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

748: AND Analysis_Option2 = l_swap_Table(i).p_AnaOpt_Prev_Id
749: AND Analysis_Option1 = p_Parent_Option_Id
750: AND Analysis_Option0 = p_Grand_Parent_Option_Id;
751:
752: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
753: SET Analysis_Option2 = l_swap_Table(i).p_AnaOpt_Next_Id
754: WHERE Indicator = p_Kpi_Id
755: AND Analysis_Option2 = l_swap_Table(i).p_AnaOpt_Prev_Id
756: AND Analysis_Option1 = p_parent_option_Id

Line 1703: g_db_object := 'BSC_KPI_ANALYSIS_MEASURES_TL';

1699: ,p_Anal_Opt_Rec.Bsc_Dataset_Bm_Color
1700: ,p_Anal_Opt_Rec.Bsc_Measure_Prototype_Flag
1701: ,p_Anal_Opt_Rec.Bsc_Kpi_Measure_Id);
1702:
1703: g_db_object := 'BSC_KPI_ANALYSIS_MEASURES_TL';
1704:
1705: -- Insert pertaining values into table bsc_kpi_analysis_measures_tl.
1706: insert into BSC_KPI_ANALYSIS_MEASURES_TL( indicator
1707: ,analysis_option0

Line 1705: -- Insert pertaining values into table bsc_kpi_analysis_measures_tl.

1701: ,p_Anal_Opt_Rec.Bsc_Kpi_Measure_Id);
1702:
1703: g_db_object := 'BSC_KPI_ANALYSIS_MEASURES_TL';
1704:
1705: -- Insert pertaining values into table bsc_kpi_analysis_measures_tl.
1706: insert into BSC_KPI_ANALYSIS_MEASURES_TL( indicator
1707: ,analysis_option0
1708: ,analysis_option1
1709: ,analysis_option2

Line 1706: insert into BSC_KPI_ANALYSIS_MEASURES_TL( indicator

1702:
1703: g_db_object := 'BSC_KPI_ANALYSIS_MEASURES_TL';
1704:
1705: -- Insert pertaining values into table bsc_kpi_analysis_measures_tl.
1706: insert into BSC_KPI_ANALYSIS_MEASURES_TL( indicator
1707: ,analysis_option0
1708: ,analysis_option1
1709: ,analysis_option2
1710: ,series_id

Line 1728: from BSC_KPI_ANALYSIS_MEASURES_TL T

1724: from FND_LANGUAGES L
1725: where L.INSTALLED_FLAG in ('I', 'B')
1726: and not exists
1727: (select NULL
1728: from BSC_KPI_ANALYSIS_MEASURES_TL T
1729: where T.indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1730: and T.analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
1731: and T.analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
1732: and T.analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2

Line 2069: update BSC_KPI_ANALYSIS_MEASURES_TL

2065: and analysis_option0 = l_Anal_Opt_Rec.Bsc_Option_Group0
2066: and analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
2067: and analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2;
2068:
2069: update BSC_KPI_ANALYSIS_MEASURES_TL
2070: set name = l_Anal_Opt_Rec.Bsc_Measure_Long_Name
2071: ,help = l_Anal_Opt_Rec.Bsc_Measure_Help
2072: ,source_lang = userenv('LANG')
2073: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id

Line 2098: update BSC_KPI_ANALYSIS_MEASURES_TL

2094: and analysis_option1 = l_Anal_Opt_Rec.Bsc_Option_Group1
2095: and analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2
2096: and series_id = l_Anal_Opt_Rec.Bsc_Dataset_Series_Id;
2097:
2098: update BSC_KPI_ANALYSIS_MEASURES_TL
2099: set name = l_Anal_Opt_Rec.Bsc_Measure_Long_Name
2100: ,help = l_Anal_Opt_Rec.Bsc_Measure_Help
2101: ,source_lang = userenv('LANG')
2102: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id

Line 2309: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL

2305: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
2306: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2
2307: AND series_id = p_Anal_Opt_Rec.Bsc_Dataset_Series_Id;
2308:
2309: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL
2310: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2311: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
2312: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
2313: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2

Line 2420: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

2416: AND analysis_option0 = cd.Option_Id
2417: AND analysis_option1 = l_Parent_Analysis
2418: AND analysis_option2 = l_Grand_Parent_Analysis;
2419:
2420: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
2421: SET Indicator = -999
2422: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2423: AND analysis_option0 = cd.Option_Id
2424: AND analysis_option1 = l_Parent_Analysis

Line 2434: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL

2430: IF (l_Delete_Flag) THEN
2431: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B
2432: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id;
2433:
2434: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL
2435: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id;
2436:
2437: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
2438: SET Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id

Line 2441: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

2437: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
2438: SET Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2439: WHERE Indicator = -999;
2440:
2441: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
2442: SET Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2443: WHERE Indicator = -999;
2444: END IF;
2445: ELSIF ((p_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NOT NULL) AND

Line 2491: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

2487: AND analysis_option0 = cd.Option_Id
2488: AND analysis_option1 = l_Parent_Analysis
2489: AND analysis_option2 = 0;
2490:
2491: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
2492: SET Indicator = -999
2493: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2494: AND analysis_option0 = cd.Option_Id
2495: AND analysis_option1 = l_Parent_Analysis

Line 2503: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL

2499: IF (l_Delete_Flag) THEN
2500: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B
2501: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id;
2502:
2503: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL
2504: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id;
2505:
2506: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
2507: SET Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id

Line 2510: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

2506: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
2507: SET Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2508: WHERE Indicator = -999;
2509:
2510: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
2511: SET Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2512: WHERE Indicator = -999;
2513: END IF;
2514: ELSE

Line 2521: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL

2517: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
2518: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
2519: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2;
2520:
2521: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL
2522: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2523: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
2524: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
2525: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2;

Line 3557: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL

3553: AND analysis_option2 = p_Bsc_Anal_Opt_Rec.Bsc_Option_Group2
3554: AND series_id > 0;
3555: --DBMS_OUTPUT.PUT_LINE('after deleting baset table');
3556:
3557: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL
3558: WHERE indicator = p_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
3559: AND analysis_option0 = 0
3560: AND analysis_option1 = p_Bsc_Anal_Opt_Rec.Bsc_Option_Group1
3561: AND analysis_option2 = p_Bsc_Anal_Opt_Rec.Bsc_Option_Group2

Line 3644: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL

3640: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
3641: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2
3642: AND SERIES_ID = p_Anal_Opt_Rec.Bsc_Dataset_Series_Id;
3643:
3644: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_TL
3645: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
3646: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
3647: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
3648: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2

Line 3815: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

3811: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
3812: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2
3813: AND SERIES_ID = p_Anal_Opt_Rec.Bsc_Dataset_Series_Id;
3814:
3815: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL
3816: SET SERIES_ID = p_Anal_Opt_Rec.Bsc_Dataset_New_Series_Id
3817: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
3818: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
3819: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1