[Home] [Help]
257:
258: CURSOR c_tabs_to_check is
259: SELECT DISTINCT B.TAB_ID
260: FROM BSC_KPI_DIM_GROUPS A
261: ,BSC_TAB_INDICATORS B
262: WHERE A.INDICATOR = B.INDICATOR
263: AND A.DIM_GROUP_ID = p_Dimension_Id;
264:
265: l_tab_id number;
349:
350: --Cursor to get The common Dimensions for the tab.
351: CURSOR c_Common_Levels IS
352: SELECT DISTINCT KL.LEVEL_TABLE_NAME, KL.DIM_LEVEL_INDEX, NVL(KL.PARENT_LEVEL_INDEX, -1), SL.DIM_LEVEL_ID
353: FROM BSC_TAB_INDICATORS TI,
354: BSC_KPIS_B KB,
355: BSC_KPI_DIM_LEVELS_VL KL,
356: BSC_SYS_DIM_LEVELS_VL SL
357: WHERE TI.TAB_ID = p_Tab_Id
379: , KL.DIM_LEVEL_INDEX
380: , SLG.DEFAULT_VALUE
381: , KL.PARENT_LEVEL_INDEX
382: , KL.DEFAULT_KEY_VALUE
383: FROM BSC_TAB_INDICATORS TI
384: , BSC_KPIS_B KB
385: , BSC_KPI_DIM_LEVELS_VL KL
386: , BSC_KPI_DIM_GROUPS KG
387: , BSC_SYS_DIM_LEVELS_BY_GROUP SLG
411: --Evaluate that not KPI in the tab has PMF Measures as Default One
412: SELECT COUNT(SOURCE)
413: INTO v_Num_KPI_Default_PMF
414: FROM (SELECT DISTINCT KM.INDICATOR, DS.DATASET_ID, DS.SOURCE --, KM.PROTOTYPE_FLAG
415: FROM BSC_TAB_INDICATORS TI,
416: BSC_KPI_ANALYSIS_MEASURES_B KM ,
417: (SELECT INDICATOR, DEFAULT_VALUE
418: FROM BSC_KPI_ANALYSIS_GROUPS
419: WHERE ANALYSIS_GROUP_ID = 0 ) A0,
448: FROM (
449: SELECT DISTINCT INDICATOR, DIM_SET_ID, SOURCE
450: FROM
451: ( SELECT KB.INDICATOR, KDS.DIM_SET_ID, SL.DIM_LEVEL_ID, SL.SOURCE
452: FROM BSC_TAB_INDICATORS TI,
453: BSC_KPIS_B KB,
454: BSC_KPI_DIM_SETS_VL KDS,
455: BSC_KPI_DIM_GROUPS KDG,
456: BSC_SYS_DIM_LEVELS_BY_GROUP SLG,
694: v_index number;
695:
696: CURSOR c_KPIs IS
697: SELECT INDICATOR
698: FROM BSC_TAB_INDICATORS
699: WHERE TAB_ID = p_Tab_Id;
700:
701: BEGIN
702: FND_MSG_PUB.Initialize;
822: AND Prototype_Flag <> 2;
823:
824: CURSOR c_tab_id IS
825: SELECT tab_id
826: FROM BSC_TAB_INDICATORS
827: WHERE indicator = l_Kpi_Id;
828:
829: BEGIN
830: FND_MSG_PUB.Initialize;