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_PMF_UI_WRAPPER dependencies on BSC_KPIS_B

Line 377: ' from BSC_KPIS_B ' ||

373: ,x_msg_data);
374:
375: -- Add the analysis dimension levels to the shared Indicators.
376: l_sql := 'select indicator ' ||
377: ' from BSC_KPIS_B ' ||
378: ' where source_indicator = :1';
379:
380: open dc_value for l_sql using p_kpi_id;
381: loop

Line 1131: from BSC_KPIS_B

1127:
1128: -- determine if there are any shared KPI based on this KPI.
1129: select count(indicator)
1130: into l_count
1131: from BSC_KPIS_B
1132: where source_indicator = p_kpi_id;
1133:
1134: -- if there are any shared KPIs update those also.
1135: if l_count > 0 then

Line 1138: ' from BSC_KPIS_B ' ||

1134: -- if there are any shared KPIs update those also.
1135: if l_count > 0 then
1136:
1137: l_sql := 'select indicator ' ||
1138: ' from BSC_KPIS_B ' ||
1139: ' where source_indicator = :1';
1140:
1141: open dc_value for l_sql using p_kpi_id;
1142: loop

Line 1915: ' from BSC_KPIS_B ' ||

1911: -- If deleting the dimension set, then delete it from all indicators,
1912: -- master, and shared.
1913:
1914: l_shr_sql := 'select indicator ' ||
1915: ' from BSC_KPIS_B ' ||
1916: ' where indicator = :1' ||
1917: ' or source_indicator = :2';
1918:
1919: open dc_shr for l_shr_sql using p_kpi_id, p_kpi_id;

Line 2058: , BSC_KPIS_B B

2054:
2055: CURSOR c_Tab_Id IS
2056: SELECT DISTINCT A.Tab_Id
2057: FROM BSC_TAB_INDICATORS A
2058: , BSC_KPIS_B B
2059: , BSC_SYS_FILTERS_VIEWS C
2060: WHERE A.Indicator = B.Indicator
2061: AND C.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab
2062: AND C.Source_Code = A.Tab_Id

Line 2512: from BSC_KPIS_B

2508:
2509: -- need to get kpi group for this kpi.
2510: select distinct(ind_group_id)
2511: into l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id
2512: from BSC_KPIS_B
2513: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
2514: -- Evaluate the Group Type
2515: SELECT GROUP_TYPE
2516: into l_kpi_group_type

Line 2525: FROM BSC_KPIS_B BK, BSC_TAB_INDICATORS TI

2521: if l_kpi_group_type = 1 then
2522: -- if the the Group is Below the name
2523: SELECT COUNT(BK.INDICATOR)
2524: into l_count
2525: FROM BSC_KPIS_B BK, BSC_TAB_INDICATORS TI
2526: WHERE BK.IND_GROUP_ID = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id
2527: AND TI.TAB_ID = p_tab_id
2528: AND BK.INDICATOR = TI.INDICATOR;
2529: if l_count > 0 then

Line 2776: from BSC_KPIS_B

2772:
2773: -- get l_share_flag, Indicator source and KPI Group. It will be used for tab validation.
2774: select share_flag, source_indicator
2775: into l_share_flag, l_kpi_source
2776: from BSC_KPIS_B
2777: where indicator = p_kpi_id;
2778:
2779: -- Validate that the p_KPI_id corresponds to the Master KPI.
2780: if l_share_flag <> 2 then

Line 2795: from BSC_KPIS_B

2791:
2792: -- Get the KPI group id.
2793: select IND_GROUP_ID
2794: into l_kpi_group_id
2795: from BSC_KPIS_B
2796: where indicator = p_kpi_id;
2797: l_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id := l_kpi_group_id;
2798:
2799: -- Evaluate if the KPI Assigned to the Tab is the Master or a Share KPI

Line 2813: and indicator in (select indicator from BSC_KPIS_B

2809: select indicator
2810: into l_Bsc_Kpi_Entity_Rec.Bsc_kpi_id
2811: from BSC_TAB_INDICATORS
2812: where tab_id = l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id
2813: and indicator in (select indicator from BSC_KPIS_B
2814: where source_indicator = l_Master_KPI_id
2815: );
2816: -- Granular Locking
2817: BSC_BIS_LOCKS_PUB.LOCK_TAB(

Line 2848: from BSC_KPIS_B

2844: select count(indicator)
2845: into l_kpi_count
2846: from BSC_TAB_INDICATORS
2847: where indicator in (select indicator
2848: from BSC_KPIS_B
2849: where source_indicator = l_Master_KPI_id );
2850: -- Get production Mode Flag for Master KPI
2851: select prototype_flag, decode(CONFIG_TYPE, 7, 1, 0)
2852: into l_prototype_flag, l_Simulation_Tree_flag

Line 2853: from BSC_KPIS_B

2849: where source_indicator = l_Master_KPI_id );
2850: -- Get production Mode Flag for Master KPI
2851: select prototype_flag, decode(CONFIG_TYPE, 7, 1, 0)
2852: into l_prototype_flag, l_Simulation_Tree_flag
2853: from BSC_KPIS_B
2854: where indicator = l_Master_KPI_id;
2855: if l_prototype_flag <> 1 and l_prototype_flag <> 3 then
2856: l_is_obj_in_production := TRUE;
2857: else

Line 2898: FROM bsc_kpis_b

2894: SELECT indicator
2895: INTO l_kpi_id
2896: FROM BSC_TAB_INDICATORS
2897: WHERE indicator IN (SELECT indicator
2898: FROM bsc_kpis_b
2899: WHERE source_indicator = l_Master_KPI_id );
2900:
2901: -- Once the shared KPI obtained then delete master KPI.
2902: -- call the public version of Delete_Kpi_Defaults.

Line 2939: UPDATE bsc_kpis_b

2935: END IF;
2936: -- Need to do this update directly because the procedure will see the null
2937: -- value for Source Indicator and it will update it with previos value, not
2938: -- the null one.
2939: UPDATE bsc_kpis_b
2940: SET source_indicator = NULL
2941: WHERE indicator = l_kpi_id;
2942:
2943: ELSE

Line 2971: from bsc_kpis_b a, bsc_tab_indicators b

2967: -- Evaluate if it needs to unassign the KPI Group
2968:
2969: select count(b.indicator)
2970: into l_kpi_count
2971: from bsc_kpis_b a, bsc_tab_indicators b
2972: where a.ind_group_id = l_kpi_group_id
2973: and a.indicator = b.indicator
2974: and b.tab_id = p_tab_id;
2975:

Line 3117: from BSC_KPIS_B

3113: from BSC_TAB_INDICATORS
3114: where tab_id = p_tab_id
3115: and (indicator = p_kpi_id or
3116: indicator in (select indicator
3117: from BSC_KPIS_B
3118: where source_indicator = p_kpi_id)
3119: );
3120:
3121: if l_count <> 0 then

Line 3150: FROM bsc_kpis_b

3146:
3147: l_kpi_id number;
3148: CURSOR c_kpis IS
3149: SELECT indicator
3150: FROM bsc_kpis_b
3151: WHERE ind_group_id = p_kpi_group_id
3152: AND SHARE_FLAG <> 2
3153: AND PROTOTYPE_FLAG <> 2;
3154:

Line 3167: FROM BSC_KPIS_B

3163: SAVEPOINT BscPmfUIUAssignKpiGrp;
3164:
3165: SELECT COUNT(*)
3166: INTO l_count
3167: FROM BSC_KPIS_B
3168: WHERE ind_group_id = p_kpi_group_id
3169: and SHARE_FLAG <> 2
3170: and PROTOTYPE_FLAG <> 2;
3171:

Line 5247: UPDATE bsc_kpis_b

5243: WHERE periodicity_id = cd_reorder.periodicity_id
5244: AND indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5245: END LOOP;
5246:
5247: UPDATE bsc_kpis_b
5248: SET calendar_id = p_calendar_id
5249: ,periodicity_id = l_Dft_periodicity_id
5250: ,last_update_date = SYSDATE
5251: WHERE indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;

Line 5306: bsc_kpis_b

5302: CURSOR c_share_kpis IS
5303: SELECT
5304: indicator
5305: FROM
5306: bsc_kpis_b
5307: WHERE
5308: source_indicator = p_Indicator
5309: AND PROTOTYPE_FLAG <> 2;
5310:

Line 5473: l_Indic_Type BSC_KPIS_B.INDICATOR_TYPE%TYPE;

5469: l_periodicity_id NUMBER;
5470: l_current_period NUMBER;
5471: l_periodicities_tbl BSC_BIS_LOCKS_PUB.t_numberTable;
5472: l_current_periods BSC_BIS_LOCKS_PUB.t_numberTable;
5473: l_Indic_Type BSC_KPIS_B.INDICATOR_TYPE%TYPE;
5474: l_Indic_Config_Type BSC_KPIS_B.CONFIG_TYPE%TYPE;
5475: l_Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE;
5476: l_Is_Invalid_Per_Sim BOOLEAN := FALSE;
5477: l_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;

Line 5474: l_Indic_Config_Type BSC_KPIS_B.CONFIG_TYPE%TYPE;

5470: l_current_period NUMBER;
5471: l_periodicities_tbl BSC_BIS_LOCKS_PUB.t_numberTable;
5472: l_current_periods BSC_BIS_LOCKS_PUB.t_numberTable;
5473: l_Indic_Type BSC_KPIS_B.INDICATOR_TYPE%TYPE;
5474: l_Indic_Config_Type BSC_KPIS_B.CONFIG_TYPE%TYPE;
5475: l_Periodicity_Type BSC_SYS_PERIODICITIES.PERIODICITY_ID%TYPE;
5476: l_Is_Invalid_Per_Sim BOOLEAN := FALSE;
5477: l_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;
5478: l_Invalid_Period_Name BSC_SYS_PERIODICITIES_TL.NAME%TYPE;

Line 5493: FROM BSC_KPIS_B

5489:
5490:
5491: CURSOR c_share_kpis IS
5492: SELECT indicator
5493: FROM BSC_KPIS_B
5494: WHERE source_indicator = p_kpi_id
5495: AND PROTOTYPE_FLAG <> 2;
5496:
5497: CURSOR c_Yearly_Periodicity IS

Line 5537: FROM bsc_kpis_b

5533: CLOSE c_Yearly_Periodicity;
5534:
5535: SELECT indicator_type, config_type, calendar_id, periodicity_id, prototype_flag
5536: INTO l_Indic_Type,l_Indic_Config_Type, l_cur_cal_id, l_cur_periodicity_id, l_cur_prototype_flag
5537: FROM bsc_kpis_b
5538: WHERE indicator = p_kpi_id;
5539:
5540: --now we will support more than 1 periodicity for Simulation tree.
5541: -- so relaxing this condition

Line 5611: FROM bsc_kpis_b

5607: l_sql :='
5608: DELETE bsc_kpi_periodicities
5609: WHERE indicator IN
5610: (SELECT indicator
5611: FROM bsc_kpis_b
5612: WHERE indicator = :1 OR source_indicator = :2)';
5613: l_sql := l_sql || ' AND periodicity_id NOT IN (' || l_periodicity_ids || ')';
5614:
5615: EXECUTE IMMEDIATE l_sql USING p_kpi_id, p_kpi_id;

Line 5669: FROM bsc_kpis_b

5665: AND user_level1=C_DISABLE_FLAG
5666: AND periodicity_id = l_cur_periodicity_id
5667: AND indicator IN
5668: (SELECT indicator
5669: FROM bsc_kpis_b
5670: WHERE indicator = p_kpi_id
5671: OR source_indicator=p_kpi_id);
5672: END IF;
5673:

Line 5717: FROM bsc_kpis_b k

5713: -- Remove all the Master/Shared Objective periodicities.
5714: DELETE bsc_kpi_periodicities p
5715: WHERE p.indicator in
5716: (SELECT k.indicator
5717: FROM bsc_kpis_b k
5718: WHERE k.indicator = p_kpi_id
5719: OR k.source_indicator = p_kpi_id);
5720:
5721: IF (l_Dft_periodicity_id IS NULL) THEN