[Home] [Help]
1320: --dbms_output.PUT_LINE('p_measure_short_name <'||p_measure_short_name||'>');
1321: IF (x_measure_short_name IS NULL) THEN
1322: SELECT Short_Name
1323: INTO x_measure_short_name
1324: FROM BSC_SYS_MEASURES
1325: , BSC_SYS_DATASETS_VL
1326: WHERE MEASURE_ID = MEASURE_ID1
1327: AND DATASET_ID = p_data_set_id;
1328: END IF;
1405: -- WHY IS THIS REQUIRED ** ask Pankaj
1406: IF (x_measure_short_name IS NULL) THEN
1407: SELECT Short_Name
1408: INTO x_measure_short_name
1409: FROM BSC_SYS_MEASURES
1410: , BSC_SYS_DATASETS_VL
1411: WHERE MEASURE_ID = MEASURE_ID1
1412: AND DATASET_ID = p_data_set_id;
1413: END IF;
4076: , x_msg_data OUT NOCOPY VARCHAR2
4077: ) IS
4078: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
4079: l_bsc_dimset_rec BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type;
4080: l_measure_short_name BSC_SYS_MEASURES.Short_Name%TYPE;
4081: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE := 'DGRP_';
4082: l_temp_var VARCHAR2(32000);
4083: l_count NUMBER;
4084: l_alias VARCHAR2(4);
4117:
4118: CURSOR c_data_set_id IS
4119: SELECT DISTINCT a.dataset_id DataSet_Id
4120: FROM BSC_SYS_DATASETS_B a
4121: , BSC_SYS_MEASURES b
4122: WHERE UPPER(b.short_name) = UPPER(p_measure_short_name)
4123: AND a.measure_id1 = b.measure_id
4124: AND ROWNUM < 2;
4125:
4994: l_count NUMBER;
4995: l_datasource BSC_SYS_DATASETS_B.Source%TYPE;
4996: l_meaning VARCHAR(60);
4997: l_DimObj_ViewBy_Tbl BSC_BIS_KPI_MEAS_PUB.DimObj_Viewby_Tbl_Type;
4998: l_measure_short_name BSC_SYS_MEASURES.Short_Name%TYPE;
4999: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;
5000:
5001: CURSOR c_data_source IS
5002: SELECT Source
7889:
7890: BEGIN
7891: SELECT MES.SHORT_NAME
7892: INTO l_measure_short_name
7893: FROM BSC_SYS_MEASURES MES,
7894: BSC_SYS_DATASETS_B SYS
7895: WHERE MES.MEASURE_ID = SYS.MEASURE_ID1
7896: AND SYS.DATASET_ID = p_dataset_id;
7897: