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_B

Line 561: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

557: END LOOP;
558: IF (l_Table_Count <> 0) THEN
559: IF (p_group_Id = 0) THEN
560: FOR i IN 0..(l_swap_Table.COUNT-1) LOOP
561: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
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:

Line 573: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

569: AND Analysis_Option0 = l_swap_Table(i).p_AnaOpt_Prev_Id;
570: END LOOP;
571: ELSIF (p_group_Id = 1) THEN
572: FOR i IN 0..(l_swap_Table.COUNT-1) LOOP
573: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
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:

Line 585: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

581: AND Analysis_Option1 = l_swap_Table(i).p_AnaOpt_Prev_Id;
582: END LOOP;
583: ELSIF (p_group_Id = 2) THEN
584: FOR i IN 0..(l_swap_Table.COUNT-1) LOOP
585: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
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:

Line 719: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

715: END LOOP;
716: IF (l_Table_Count <> 0) THEN
717: IF (p_group_Id = 0) THEN
718: FOR i IN 0..(l_swap_Table.COUNT-1) LOOP
719: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
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:

Line 731: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

727: AND Analysis_Option0 = l_swap_Table(i).p_AnaOpt_Prev_Id;
728: END LOOP;
729: ELSIF (p_group_Id = 1) THEN
730: FOR i IN 0..(l_swap_Table.COUNT-1) LOOP
731: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
732: SET Analysis_Option1 = l_swap_Table(i).p_AnaOpt_Next_Id
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;

Line 745: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

741: AND Analysis_Option0 = p_Parent_Option_Id;
742: END LOOP;
743: ELSIF (p_group_Id = 2) THEN
744: FOR i IN 0..(l_swap_Table.COUNT-1) LOOP
745: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
746: SET Analysis_Option2 = l_swap_Table(i).p_AnaOpt_Next_Id
747: WHERE Indicator = p_Kpi_Id
748: AND Analysis_Option2 = l_swap_Table(i).p_AnaOpt_Prev_Id
749: AND Analysis_Option1 = p_Parent_Option_Id

Line 1667: g_db_object := 'BSC_KPI_ANALYSIS_MEASURES_B';

1663: RAISE FND_API.G_EXC_ERROR;
1664:
1665: else
1666:
1667: g_db_object := 'BSC_KPI_ANALYSIS_MEASURES_B';
1668:
1669: -- Insert pertaining values into table bsc_kpi_analysis_measures_b.
1670: insert into BSC_KPI_ANALYSIS_MEASURES_B( indicator
1671: ,ANALYSIS_OPTION0

Line 1669: -- Insert pertaining values into table bsc_kpi_analysis_measures_b.

1665: else
1666:
1667: g_db_object := 'BSC_KPI_ANALYSIS_MEASURES_B';
1668:
1669: -- Insert pertaining values into table bsc_kpi_analysis_measures_b.
1670: insert into BSC_KPI_ANALYSIS_MEASURES_B( indicator
1671: ,ANALYSIS_OPTION0
1672: ,ANALYSIS_OPTION1
1673: ,ANALYSIS_OPTION2

Line 1670: insert into BSC_KPI_ANALYSIS_MEASURES_B( indicator

1666:
1667: g_db_object := 'BSC_KPI_ANALYSIS_MEASURES_B';
1668:
1669: -- Insert pertaining values into table bsc_kpi_analysis_measures_b.
1670: insert into BSC_KPI_ANALYSIS_MEASURES_B( indicator
1671: ,ANALYSIS_OPTION0
1672: ,ANALYSIS_OPTION1
1673: ,ANALYSIS_OPTION2
1674: ,SERIES_ID

Line 1926: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_B.KPI_MEASURE_ID%TYPE;

1922: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1923: l_count number;
1924: l_source BSC_SYS_DATASETS_B.SOURCE%TYPE;
1925: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;
1926: l_kpi_measure_id BSC_KPI_ANALYSIS_MEASURES_B.KPI_MEASURE_ID%TYPE;
1927: l_dataset_color_change BOOLEAN := FALSE;
1928: l_old_color_method bsc_sys_datasets_b.color_method%TYPE;
1929: l_new_color_method bsc_sys_datasets_b.color_method%TYPE;
1930: begin

Line 2052: update BSC_KPI_ANALYSIS_MEASURES_B

2048: if p_Anal_Opt_Rec.Bsc_Measure_Help is not null then
2049: l_Anal_Opt_Rec.Bsc_Measure_Help := p_Anal_Opt_Rec.Bsc_Measure_Help;
2050: end if;
2051: IF (p_Anal_Opt_Rec.Bsc_Dataset_Series_Id IS NULL) THEN
2052: update BSC_KPI_ANALYSIS_MEASURES_B
2053: set series_id = l_Anal_Opt_Rec.Bsc_Dataset_Series_Id
2054: ,dataset_id = l_Anal_Opt_Rec.Bsc_Dataset_Id
2055: ,axis = l_Anal_Opt_Rec.Bsc_Dataset_Axis
2056: ,series_type = l_Anal_Opt_Rec.Bsc_Dataset_Series_Type

Line 2080: update BSC_KPI_ANALYSIS_MEASURES_B

2076: and analysis_option2 = l_Anal_Opt_Rec.Bsc_Option_Group2
2077: and indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
2078: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
2079: ELSE
2080: update BSC_KPI_ANALYSIS_MEASURES_B
2081: set series_id = l_Anal_Opt_Rec.Bsc_Dataset_Series_Id
2082: ,dataset_id = l_Anal_Opt_Rec.Bsc_Dataset_Id
2083: ,axis = l_Anal_Opt_Rec.Bsc_Dataset_Axis
2084: ,series_type = l_Anal_Opt_Rec.Bsc_Dataset_Series_Type

Line 2124: FROM bsc_kpi_analysis_measures_b

2120:
2121: IF (l_dataset_color_change) THEN
2122: SELECT kpi_measure_id
2123: INTO l_kpi_measure_id
2124: FROM bsc_kpi_analysis_measures_b
2125: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2126: AND dataset_id = l_Anal_Opt_Rec.Bsc_Dataset_Id;
2127:
2128: BSC_COLOR_RANGES_PUB.Delete_Color_Prop_Ranges (p_objective_id => p_Anal_Opt_Rec.Bsc_Kpi_Id

Line 2302: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B

2298: --DBMS_OUTPUT.PUT_LINE('p_Anal_Opt_Rec.Bsc_Grandparent_Option_Id <'||p_Anal_Opt_Rec.Bsc_Grandparent_Option_Id||'>');
2299: --DBMS_OUTPUT.PUT_LINE('l_GrandParent_Dependent <'||l_GrandParent_Dependent||'>');
2300: --DBMS_OUTPUT.PUT_LINE('l_Parent_Dependent <'||l_Parent_Dependent||'>');
2301: IF p_Anal_Opt_Rec.Bsc_Dataset_Series_Id IS NOT NULL THEN
2302: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B
2303: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2304: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
2305: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
2306: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2

Line 2320: FROM BSC_KPI_ANALYSIS_MEASURES_B

2316: (p_Anal_Opt_Rec.Bsc_Parent_Option_Id IS NOT NULL) AND
2317: (p_Anal_Opt_Rec.Bsc_Grandparent_Option_Id IS NOT NULL)) THEN
2318: FOR cd IN c_GrandParent_Option LOOP
2319: SELECT COUNT(*) INTO l_COunt
2320: FROM BSC_KPI_ANALYSIS_MEASURES_B
2321: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2322: AND analysis_option0 = cd.Option_Id
2323: AND analysis_option1 = cd.Parent_Option_Id
2324: AND analysis_option2 = cd.GrandParent_Option_Id;

Line 2333: , BSC_KPI_ANALYSIS_MEASURES_B D

2329: IF ((is_GrandParent_Exists(p_Anal_Opt_Rec.Bsc_Kpi_Id, cd.Option_Id, 2)) AND
2330: (is_Parent_Exists(p_Anal_Opt_Rec.Bsc_Kpi_Id, cd.Parent_Option_Id, 2))) THEN
2331: SELECT COUNT(*) INTO l_Count
2332: FROM BSC_KPI_ANALYSIS_OPTIONS_B A
2333: , BSC_KPI_ANALYSIS_MEASURES_B D
2334: WHERE D.Indicator = A.Indicator
2335: AND A.Analysis_Group_Id = 2
2336: AND A.Option_Id = D.Analysis_Option2
2337: AND A.Parent_Option_Id = D.Analysis_Option1

Line 2366: , BSC_KPI_ANALYSIS_MEASURES_B D

2362: ELSIF (l_Parent_Dependent > 0) THEN
2363: IF (is_Parent_Exists(p_Anal_Opt_Rec.Bsc_Kpi_Id, cd.Option_Id, 1)) THEN
2364: SELECT COUNT(*) INTO l_Count
2365: FROM BSC_KPI_ANALYSIS_OPTIONS_B A
2366: , BSC_KPI_ANALYSIS_MEASURES_B D
2367: WHERE D.Indicator = A.Indicator
2368: AND A.Analysis_Group_Id = 1
2369: AND A.Option_Id = D.Analysis_Option1
2370: AND A.Parent_Option_Id = D.Analysis_Option0

Line 2386: , BSC_KPI_ANALYSIS_MEASURES_B D

2382: ELSIF (l_GrandParent_Dependent > 0) THEN
2383: IF (is_Parent_Exists(p_Anal_Opt_Rec.Bsc_Kpi_Id, cd.Parent_Option_Id, 2)) THEN
2384: SELECT COUNT(*) INTO l_Count
2385: FROM BSC_KPI_ANALYSIS_OPTIONS_B A
2386: , BSC_KPI_ANALYSIS_MEASURES_B D
2387: WHERE D.Indicator = A.Indicator
2388: AND A.Analysis_Group_Id = 2
2389: AND A.Parent_Option_Id = D.Analysis_Option1
2390: AND A.GrandParent_Option_Id = 0

Line 2413: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

2409: IF((l_Parent_Dependent = 0) AND (l_GrandParent_Dependent = 0)) THEN
2410: l_Parent_Analysis := cd.Parent_Option_Id;
2411: l_Grand_Parent_Analysis := cd.GrandParent_Option_Id;
2412: END IF;
2413: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
2414: SET Indicator = -999
2415: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2416: AND analysis_option0 = cd.Option_Id
2417: AND analysis_option1 = l_Parent_Analysis

Line 2431: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B

2427: END IF;
2428: END IF;
2429: END LOOP;
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;

Line 2437: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

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
2439: WHERE Indicator = -999;
2440:
2441: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

Line 2465: , BSC_KPI_ANALYSIS_MEASURES_B D

2461: IF (l_Parent_Dependent > 0) THEN
2462: IF (is_Parent_Exists(p_Anal_Opt_Rec.Bsc_Kpi_Id, cd.Option_Id, 1)) THEN
2463: SELECT COUNT(*) INTO l_Count
2464: FROM BSC_KPI_ANALYSIS_OPTIONS_B A
2465: , BSC_KPI_ANALYSIS_MEASURES_B D
2466: WHERE D.Indicator = A.Indicator
2467: AND A.Analysis_Group_Id = 1
2468: AND A.Option_Id = D.Analysis_Option1
2469: AND A.Parent_Option_Id = D.Analysis_Option0

Line 2484: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

2480: IF(l_Parent_Dependent = 0) THEN
2481: l_Parent_Analysis := cd.Parent_Option_Id;
2482: END IF;
2483:
2484: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
2485: SET Indicator = -999
2486: WHERE Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2487: AND analysis_option0 = cd.Option_Id
2488: AND analysis_option1 = l_Parent_Analysis

Line 2500: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B

2496: AND analysis_option2 = 0;
2497: END IF;
2498: END LOOP;
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;

Line 2506: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

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
2508: WHERE Indicator = -999;
2509:
2510: UPDATE BSC_KPI_ANALYSIS_MEASURES_TL

Line 2515: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B

2511: SET Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
2512: WHERE Indicator = -999;
2513: END IF;
2514: ELSE
2515: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B
2516: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
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;

Line 3549: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B

3545: x_return_status := FND_API.G_RET_STS_SUCCESS;
3546: FND_MSG_PUB.Initialize;
3547: --DBMS_OUTPUT.PUT_LINE('in private delte');
3548:
3549: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B
3550: WHERE indicator = p_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
3551: AND analysis_option0 = 0
3552: AND analysis_option1 = p_Bsc_Anal_Opt_Rec.Bsc_Option_Group1
3553: AND analysis_option2 = p_Bsc_Anal_Opt_Rec.Bsc_Option_Group2

Line 3618: FROM BSC_KPI_ANALYSIS_MEASURES_B

3614: ) is
3615:
3616: Cursor c_Dataseries is
3617: SELECT SERIES_ID
3618: FROM BSC_KPI_ANALYSIS_MEASURES_B
3619: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
3620: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
3621: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
3622: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2

Line 3637: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B

3633: SAVEPOINT DeleteBSCDataSeriesPVT;
3634: x_return_status := FND_API.G_RET_STS_SUCCESS;
3635:
3636: -- Delete the Data Series
3637: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B
3638: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
3639: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
3640: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
3641: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2

Line 3677: FROM BSC_KPI_ANALYSIS_MEASURES_B K

3673: -- currently this is very crude and needs to be replaced and moved to
3674: -- a better place.
3675: BEGIN
3676: SELECT COUNT(1) INTO l_Count
3677: FROM BSC_KPI_ANALYSIS_MEASURES_B K
3678: WHERE K.INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id
3679: AND K.ANALYSIS_OPTION0 = p_Anal_Opt_Rec.Bsc_Option_Group0
3680: AND K.ANALYSIS_OPTION1 = p_Anal_Opt_Rec.Bsc_Option_Group1
3681: AND K.ANALYSIS_OPTION2 = p_Anal_Opt_Rec.Bsc_Option_Group2

Line 3685: UPDATE BSC_KPI_ANALYSIS_MEASURES_B K

3681: AND K.ANALYSIS_OPTION2 = p_Anal_Opt_Rec.Bsc_Option_Group2
3682: AND K.DEFAULT_VALUE = 1;
3683:
3684: IF (l_Count = 0) THEN
3685: UPDATE BSC_KPI_ANALYSIS_MEASURES_B K
3686: SET K.DEFAULT_VALUE = 1
3687: WHERE K.INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id
3688: AND K.ANALYSIS_OPTION0 = p_Anal_Opt_Rec.Bsc_Option_Group0
3689: AND K.ANALYSIS_OPTION1 = p_Anal_Opt_Rec.Bsc_Option_Group1

Line 3768: FROM BSC_KPI_ANALYSIS_MEASURES_B

3764:
3765:
3766: Cursor c_Data_Series is
3767: SELECT SERIES_ID
3768: FROM BSC_KPI_ANALYSIS_MEASURES_B
3769: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
3770: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
3771: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1
3772: AND analysis_option2 = p_Anal_Opt_Rec.Bsc_Option_Group2

Line 3807: UPDATE BSC_KPI_ANALYSIS_MEASURES_B

3803: );
3804: END LOOP;
3805:
3806: -- Swap the Data Series Id
3807: UPDATE BSC_KPI_ANALYSIS_MEASURES_B
3808: SET SERIES_ID = p_Anal_Opt_Rec.Bsc_Dataset_New_Series_Id
3809: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
3810: AND analysis_option0 = p_Anal_Opt_Rec.Bsc_Option_Group0
3811: AND analysis_option1 = p_Anal_Opt_Rec.Bsc_Option_Group1

Line 3894: BSC_KPI_ANALYSIS_MEASURES_B. Only one value of the default value needs to be

3890: /*---------------------------------------------------------------------------------/
3891: API: Cascade_Series_Default_Value
3892:
3893: This API cascades the correct DEFAULT_VALUE that exists in the table
3894: BSC_KPI_ANALYSIS_MEASURES_B. Only one value of the default value needs to be
3895: set to 1 and the rest needs to be 0, so the following API will ensure the following
3896:
3897: If in "CREATE" mode
3898: -------------------

Line 3911: 1) If we have p_Default_Value passed as 0 and the table BSC_KPI_ANALYSIS_MEASURES_B

3907:
3908: If in "UPDATE" mode
3909: -------------------
3910:
3911: 1) If we have p_Default_Value passed as 0 and the table BSC_KPI_ANALYSIS_MEASURES_B
3912: has only one single entry, then x_Default_Value will be returned as 1
3913: 2) If we have p_Default_Value passed as 0 for a series which already has
3914: default_value as 1, then the next subsequent series is set with 1 and if the
3915: series being updated is already the last one, then SERIES_ID = 0 will be updated

Line 3950: l_Default_Value BSC_KPI_ANALYSIS_MEASURES_B.DEFAULT_VALUE%TYPE;

3946: WHERE K.SOURCE_INDICATOR = p_Kpi_Id
3947: AND K.PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;
3948:
3949:
3950: l_Default_Value BSC_KPI_ANALYSIS_MEASURES_B.DEFAULT_VALUE%TYPE;
3951: l_Count NUMBER;
3952: l_Max_Series_Id NUMBER;
3953: l_Upd_Series_Id NUMBER;
3954: BEGIN

Line 3978: FROM BSC_KPI_ANALYSIS_MEASURES_B K

3974:
3975: IF (p_Api_Mode = C_API_CREATE) THEN
3976:
3977: SELECT COUNT(1) INTO l_Count
3978: FROM BSC_KPI_ANALYSIS_MEASURES_B K
3979: WHERE K.INDICATOR = p_Kpi_Id
3980: AND K.ANALYSIS_OPTION0 = p_Option0
3981: AND K.ANALYSIS_OPTION1 = p_Option1
3982: AND K.ANALYSIS_OPTION2 = p_Option2;

Line 3989: UPDATE BSC_KPI_ANALYSIS_MEASURES_B K

3985: IF (l_Count = 0) THEN
3986: x_Default_Value := 1; -- enabled
3987: ELSE
3988: IF p_Default_Value = 1 THEN
3989: UPDATE BSC_KPI_ANALYSIS_MEASURES_B K
3990: SET K.DEFAULT_VALUE = 0
3991: WHERE K.INDICATOR = p_Kpi_Id
3992: AND K.ANALYSIS_OPTION0 = p_Option0
3993: AND K.ANALYSIS_OPTION1 = p_Option1

Line 4004: FROM BSC_KPI_ANALYSIS_MEASURES_B K

4000: END IF;
4001: ELSIF (p_Api_Mode = C_API_UPDATE) THEN
4002:
4003: SELECT K.DEFAULT_VALUE INTO l_Default_Value
4004: FROM BSC_KPI_ANALYSIS_MEASURES_B K
4005: WHERE K.INDICATOR = p_Kpi_Id
4006: AND K.ANALYSIS_OPTION0 = p_Option0
4007: AND K.ANALYSIS_OPTION1 = p_Option1
4008: AND K.ANALYSIS_OPTION2 = p_Option2

Line 4012: UPDATE BSC_KPI_ANALYSIS_MEASURES_B K

4008: AND K.ANALYSIS_OPTION2 = p_Option2
4009: AND K.SERIES_ID = p_Series_Id;
4010:
4011: IF (l_Default_Value = 0 AND p_Default_Value = 1) THEN
4012: UPDATE BSC_KPI_ANALYSIS_MEASURES_B K
4013: SET K.DEFAULT_VALUE = 0
4014: WHERE K.INDICATOR = p_Kpi_Id
4015: AND K.ANALYSIS_OPTION0 = p_Option0
4016: AND K.ANALYSIS_OPTION1 = p_Option1

Line 4022: FROM BSC_KPI_ANALYSIS_MEASURES_B K

4018:
4019: ELSIF (l_Default_Value = 1 AND p_Default_Value = 0) THEN
4020:
4021: SELECT NVL(MAX(K.SERIES_ID), 0) INTO l_Max_Series_Id
4022: FROM BSC_KPI_ANALYSIS_MEASURES_B K
4023: WHERE K.INDICATOR = p_Kpi_Id
4024: AND K.ANALYSIS_OPTION0 = p_Option0
4025: AND K.ANALYSIS_OPTION1 = p_Option1
4026: AND K.ANALYSIS_OPTION2 = p_Option2;

Line 4034: UPDATE BSC_KPI_ANALYSIS_MEASURES_B K

4030: ELSE
4031: l_Upd_Series_Id := p_Series_Id + 1;
4032: END IF;
4033:
4034: UPDATE BSC_KPI_ANALYSIS_MEASURES_B K
4035: SET K.DEFAULT_VALUE = 0
4036: WHERE K.INDICATOR = p_Kpi_Id
4037: AND K.ANALYSIS_OPTION0 = p_Option0
4038: AND K.ANALYSIS_OPTION1 = p_Option1

Line 4041: UPDATE BSC_KPI_ANALYSIS_MEASURES_B K

4037: AND K.ANALYSIS_OPTION0 = p_Option0
4038: AND K.ANALYSIS_OPTION1 = p_Option1
4039: AND K.ANALYSIS_OPTION2 = p_Option2;
4040:
4041: UPDATE BSC_KPI_ANALYSIS_MEASURES_B K
4042: SET K.DEFAULT_VALUE = 1
4043: WHERE K.INDICATOR = p_Kpi_Id
4044: AND K.ANALYSIS_OPTION0 = p_Option0
4045: AND K.ANALYSIS_OPTION1 = p_Option1

Line 4052: FROM BSC_KPI_ANALYSIS_MEASURES_B K

4048:
4049: BEGIN
4050: -- get the updated values of the series into x_Default_Value
4051: SELECT K.DEFAULT_VALUE INTO x_Default_Value
4052: FROM BSC_KPI_ANALYSIS_MEASURES_B K
4053: WHERE K.INDICATOR = p_Kpi_Id
4054: AND K.ANALYSIS_OPTION0 = p_Option0
4055: AND K.ANALYSIS_OPTION1 = p_Option1
4056: AND K.ANALYSIS_OPTION2 = p_Option2

Line 4107: BSC_KPI_ANALYSIS_MEASURES_B M

4103: SELECT
4104: K.SHORT_NAME
4105: FROM
4106: BSC_KPIS_B K,
4107: BSC_KPI_ANALYSIS_MEASURES_B M
4108: WHERE
4109: K.INDICATOR = M.INDICATOR
4110: AND M.DATASET_ID = p_Dataset_Id
4111: AND K.SHORT_NAME IS NOT NULL

Line 4255: UPDATE bsc_kpi_analysis_measures_b

4251: l_anal_grp_id := l_anal_grp_id - 1;
4252: END LOOP;
4253: END IF;
4254:
4255: UPDATE bsc_kpi_analysis_measures_b
4256: SET default_value = BSC_ANALYSIS_OPTION_PUB.c_ANAL_SERIES_DISABLED
4257: WHERE indicator = p_obj_id
4258: AND analysis_option0 = l_Anal_Opt_Comb_Tbl(0)
4259: AND analysis_option1 = l_Anal_Opt_Comb_Tbl(1)

Line 4262: UPDATE bsc_kpi_analysis_measures_b

4258: AND analysis_option0 = l_Anal_Opt_Comb_Tbl(0)
4259: AND analysis_option1 = l_Anal_Opt_Comb_Tbl(1)
4260: AND analysis_option2 = l_Anal_Opt_Comb_Tbl(2);
4261:
4262: UPDATE bsc_kpi_analysis_measures_b
4263: SET default_value = BSC_ANALYSIS_OPTION_PUB.c_ANAL_SERIES_ENABLED
4264: WHERE indicator = p_obj_id
4265: AND analysis_option0 = l_Anal_Opt_Comb_Tbl(0)
4266: AND analysis_option1 = l_Anal_Opt_Comb_Tbl(1)