[Home] [Help]
499: l_Indicator NUMBER;
500: l_Tab_Id NUMBER;
501: l_Kpi_Group_Id NUMBER;
502: l_Kpi_Id NUMBER;
503: l_Real_Kpi_Name BSC_KPIS_VL.NAME%TYPE;
504: l_Fid NUMBER;
505: l_Rowid ROWID;
506: l_form_parameters VARCHAR2(32000);
507: l_max_seq_number NUMBER;
833: l_Does_Kpi_Exist BOOLEAN;
834: l_Tab_Id NUMBER;
835: l_Kpi_Group_Id NUMBER;
836: l_Kpi_Id NUMBER;
837: l_Real_Kpi_Name BSC_KPIS_VL.NAME%TYPE;
838: l_Fid NUMBER;
839: l_Rowid ROWID;
840: l_form_parameters VARCHAR2(32000);
841: l_max_seq_number NUMBER;
6469: WHEN OTHERS THEN
6470: RETURN NULL;
6471: END Get_Next_Region_Code_By_AO;
6472:
6473: -- Gets BSC_KPIS_VL.INDICATOR using BIS_INDICATORS.SHORT_NAME
6474: -- Used in UI
6475:
6476: FUNCTION Get_Objective_By_Kpi(
6477: p_Short_Name IN VARCHAR2
6603:
6604:
6605: /*
6606: Which will return a VARCHAR2 as follows, with objectives ordered by Objective ID
6607: (BSC_KPIS_VL.INDICATOR)
6608:
6609: "3001 - Sales Overview Page, 3002 - Email Classification Page, 3003 - ASO BIL Page"
6610:
6611: Added for Bug#3780082
6619: l_Count NUMBER;
6620:
6621: CURSOR c_Obj_Names IS
6622: SELECT (KV.INDICATOR || ' - ' || KV.NAME) XTDOBJECTIVE
6623: FROM BSC_KPIS_VL KV
6624: ,BSC_KPI_CALCULATIONS KC
6625: WHERE KC.INDICATOR = KV.INDICATOR
6626: AND KC.CALCULATION_ID = BSC_BIS_KPI_CRUD_PUB.C_CALC_XTD
6627: AND KC.USER_LEVEL0 = BSC_BIS_KPI_CRUD_PUB.C_ENABLE_CALC_U0
6740: WHERE B.SHORT_NAME = l_Measure_Short_Name;
6741:
6742: CURSOR c_Kpi_Report_List IS
6743: SELECT K.NAME || ' [' || K.INDICATOR || ']' NAME
6744: FROM BSC_KPIS_VL K
6745: , BSC_KPI_ANALYSIS_MEASURES_B A
6746: , BIS_INDICATORS B
6747: WHERE K.INDICATOR = A.INDICATOR
6748: AND A.DATASET_ID = B.DATASET_ID
7604: ,x_msg_count OUT NOCOPY number
7605: ,x_msg_data OUT NOCOPY varchar2
7606: ) IS
7607:
7608: l_objective_name BSC_KPIS_VL.NAME%TYPE;
7609: l_indicator BSC_KPIS_VL.INDICATOR%TYPE;
7610: l_cust_kpi_name bsc_oaf_analysys_opt_comb_v.full_name%TYPE;
7611: l_cust_kpis varchar2(1000) := '';
7612:
7605: ,x_msg_data OUT NOCOPY varchar2
7606: ) IS
7607:
7608: l_objective_name BSC_KPIS_VL.NAME%TYPE;
7609: l_indicator BSC_KPIS_VL.INDICATOR%TYPE;
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
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
8343:
8344: END Get_Dep_Obj_Func_Name;
8345:
8346:
8347: -- Gets BSC_KPIS_VL.INDICATOR using BIS_INDICATORS.SHORT_NAME
8348: -- Used in UI
8349:
8350: FUNCTION Get_Objective_By_AGKpi(
8351: p_Short_Name IN VARCHAR2
11260: CURSOR c_Objective_List IS
11261: SELECT KP.NAME || '[' || KP.INDICATOR || ']' NAME
11262: FROM BSC_SYS_DIM_GROUPS_VL GP,
11263: BSC_KPI_DIM_GROUPS KG,
11264: BSC_KPIS_VL KP
11265: WHERE GP.SHORT_NAME = p_Region_Code
11266: AND KG.DIM_GROUP_ID = GP.DIM_GROUP_ID
11267: AND KP.INDICATOR = KG.INDICATOR
11268: AND KP.PROTOTYPE_FLAG >= 0
11316: CURSOR c_Objective_List IS
11317: SELECT KP.INDICATOR
11318: FROM BSC_SYS_DIM_GROUPS_VL GP,
11319: BSC_KPI_DIM_GROUPS KG,
11320: BSC_KPIS_VL KP
11321: WHERE GP.SHORT_NAME = p_Region_Code
11322: AND KG.DIM_GROUP_ID = GP.DIM_GROUP_ID
11323: AND KP.INDICATOR = KG.INDICATOR;
11324: BEGIN