[Home] [Help]
216:
217: l_attached := FND_API.G_TRUE;
218: SELECT COUNT(0)
219: INTO l_count
220: FROM bsc_tab_indicators
221: WHERE tab_id = p_tabId
222: AND indicator = p_indicator;
223:
224: IF(l_count =0)THEN
2884: l_Count NUMBER;
2885:
2886: CURSOR c_PageNames IS
2887: SELECT T.NAME
2888: FROM BSC_TABS_VL T, BSC_TAB_INDICATORS K
2889: WHERE T.TAB_ID = K.TAB_ID
2890: AND T.TAB_ID <> l_Tab_Id
2891: AND K.INDICATOR = l_Kpi_Id;
2892:
6725:
6726: CURSOR c_Tab_List IS
6727: SELECT T.NAME
6728: FROM BSC_TABS_VL T
6729: , BSC_TAB_INDICATORS TI
6730: , BSC_KPI_ANALYSIS_MEASURES_B AM
6731: , BIS_INDICATORS BI
6732: WHERE BI.SHORT_NAME = l_Measure_Short_Name
6733: AND AM.DATASET_ID = BI.DATASET_ID
7504: l_ret_status varchar2(10);
7505: l_msg_data varchar2(2000);
7506: l_msg_count number(5);
7507:
7508: l_indicator bsc_tab_indicators.indicator%TYPE;
7509:
7510:
7511: CURSOR c_tab_indicators IS
7512: SELECT indicator FROM bsc_tab_indicators
7508: l_indicator bsc_tab_indicators.indicator%TYPE;
7509:
7510:
7511: CURSOR c_tab_indicators IS
7512: SELECT indicator FROM bsc_tab_indicators
7513: WHERE tab_id = p_tab_id;
7514:
7515: BEGIN
7516: FND_MSG_PUB.Initialize;
7610: l_cust_kpi_name bsc_oaf_analysys_opt_comb_v.full_name%TYPE;
7611: l_cust_kpis varchar2(1000) := '';
7612:
7613: CURSOR c_get_objective IS
7614: SELECT a.name,a.indicator FROM BSC_KPIS_VL a,BSC_TAB_INDICATORS b
7615: WHERE a.indicator = b.indicator
7616: AND b.tab_id = p_tabId;
7617:
7618: CURSOR c_get_custom_Kpis(p_indicator bsc_oaf_analysys_opt_comb_v.indicator%TYPE) IS
9120: BEGIN
9121:
9122: SELECT COUNT(1) INTO l_Count
9123: FROM BSC_TABS_B T,
9124: BSC_TAB_INDICATORS K,
9125: BSC_KPI_ANALYSIS_OPTIONS_B A
9126: WHERE T.TAB_ID = p_Tab_id
9127: AND K.TAB_ID = T.TAB_ID
9128: AND A.INDICATOR = K.INDICATOR