[Home] [Help]
1066: -- to prevent it. To do this we need to check if there is a different
1067: -- indicator in the same tab with the same name.
1068: select count(indicator)
1069: into l_count
1070: from bsc_tab_indicators a
1071: where a.indicator <> p_kpi_id
1072: and a.tab_id = (select tab_id
1073: from bsc_tab_indicators
1074: where indicator = p_kpi_id)
1069: into l_count
1070: from bsc_tab_indicators a
1071: where a.indicator <> p_kpi_id
1072: and a.tab_id = (select tab_id
1073: from bsc_tab_indicators
1074: where indicator = p_kpi_id)
1075: and a.indicator in (select indicator
1076: from bsc_kpis_tl
1077: where name = p_kpi_name);
1078:
1079: if l_count <> 0 then
1080: select d.name
1081: into l_tab_name
1082: from BSC_TAB_INDICATORS a,
1083: BSC_KPIS_TL b,
1084: BSC_KPIS_TL c,
1085: BSC_TABS_TL d
1086: where a.indicator = b.indicator
1850:
1851: --Determine if Indicator assigned to a tab.
1852: select count(indicator)
1853: into l_ind_tab_count
1854: from BSC_TAB_INDICATORS
1855: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
1856:
1857: -- if indicator assigned to tab get tab id.
1858: if l_ind_tab_count > 0 then
1858: if l_ind_tab_count > 0 then
1859:
1860: select tab_id
1861: into l_tab_id
1862: from BSC_TAB_INDICATORS
1863: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
1864:
1865: end if;
1866:
1923:
1924: --Determine if Indicator assigned to a tab.
1925: select count(indicator)
1926: into l_ind_tab_count
1927: from BSC_TAB_INDICATORS
1928: where indicator = l_Bsc_Dim_Set_Rec_Type.Bsc_Kpi_Id;
1929:
1930: -- if indicator assigned to tab get indicator.
1931: if l_ind_tab_count > 0 then
1930: -- if indicator assigned to tab get indicator.
1931: if l_ind_tab_count > 0 then
1932: select tab_id
1933: into l_tab_id
1934: from BSC_TAB_INDICATORS
1935: where indicator = l_Bsc_Dim_Set_Rec_Type.Bsc_Kpi_Id;
1936: end if;
1937:
1938:
2053:
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
2070:
2071: -- check if this Indicator has been assigned to a Tab.
2072: select count(tab_id)
2073: into l_count
2074: from BSC_TAB_INDICATORS
2075: where indicator = p_kpi_id;
2076:
2077: if l_count > 0 then
2078: -- Get the tab id for this indicator.
2077: if l_count > 0 then
2078: -- Get the tab id for this indicator.
2079: select tab_id
2080: into l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id
2081: from BSC_TAB_INDICATORS
2082: where indicator = p_kpi_id;
2083: end if;
2084:
2085: -- set some of the values for the Record Type
2297:
2298: CURSOR c_Share_Ind IS
2299: SELECT DISTINCT K.Indicator
2300: FROM BSC_KPIS_VL K
2301: , BSC_TAB_INDICATORS T
2302: WHERE K.Indicator = T.Indicator
2303: AND K.Share_Flag = 2
2304: AND T.Tab_Id = p_tab_id;
2305:
2492: -- Determine if there are kpis in this tab which have the same name as
2493: -- the kpi being passed.
2494: select count(indicator)
2495: into l_same_name
2496: from BSC_TAB_INDICATORS
2497: where tab_id = p_tab_id
2498: and indicator in (select indicator
2499: from BSC_KPIS_TL
2500: where upper(name) = upper(l_kpi_name));
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
2536: -- Need to determine if this KPI will be master or shared;
2537: -- Check If the Master is already assigned to other Tab.
2538: select count(tab_id)
2539: into l_count
2540: from BSC_TAB_INDICATORS
2541: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
2542:
2543: BSC_BIS_LOCKS_PUB.LOCK_TAB(
2544: p_tab_id => p_tab_id
2798:
2799: -- Evaluate if the KPI Assigned to the Tab is the Master or a Share KPI
2800: select count(indicator)
2801: into l_count
2802: from BSC_TAB_INDICATORS
2803: where tab_id = l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id
2804: and indicator = l_Master_KPI_id;
2805:
2806: -- If l_count = 0 then the KPI assiged is a Share KPI
2807: if l_count = 0 then
2808: -- get the code for Share KPI assiged to the Tab
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: );
2842: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := l_Master_KPI_id;
2843: -- Count the Share KPIs in other tabs
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
2892: --- Make Shared KPI as the Master KPI to make it appear in library.
2893: -- Get the Share KPI Code
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:
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:
3109: Begin
3110:
3111: select count(indicator)
3112: into l_count
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
5931: WHERE tab_id = p_tab_id;
5932:
5933: CURSOR c_Kpi_function IS
5934: SELECT c.function_name,d.name
5935: FROM bsc_oaf_analysys_opt_comb_v a,bsc_tab_indicators b,bis_indicators c,bsc_kpis_vl d
5936: WHERE a.indicator = b.indicator
5937: AND a.dataset_id = c.dataset_id
5938: AND a.indicator = d.indicator
5939: AND b.tab_id = p_tab_id;