APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_SYS_DATASETS_B

Line 3895: l_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;

3891: , p_DimSetId IN NUMBER
3892: ) RETURN VARCHAR2
3893: IS
3894: l_source BSC_SYS_DIM_LEVELS_B.SOURCE%TYPE;
3895: l_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;
3896: BEGIN
3897: BSC_BIS_KPI_MEAS_PUB.get_Dim_Set_Source_Info
3898: ( p_Indicator => p_Indicator
3899: , p_DimSetId => p_DimSetId

Line 4088: l_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;

4084: l_alias VARCHAR2(4);
4085:
4086: l_data_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
4087: l_temp_data_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
4088: l_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;
4089: l_dim_obj_short_names VARCHAR2(32000);
4090: l_default_short_names VARCHAR2(32000);
4091: l_view_by_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
4092: l_dim_set_id BSC_KPI_DIM_SETS_TL.dim_set_id%TYPE;

Line 4103: l_old_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;

4099: l_dim_obj_tmp_short_names VARCHAR2(32000);
4100:
4101: --START ADEED BY PETER
4102: -- Need the following to keep track of whether data set has changed (3169904)
4103: l_old_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;
4104: l_indic_type NUMBER;
4105: l_config_type NUMBER;
4106: l_def_calc_id bsc_kpi_measure_props.default_calculation%TYPE;
4107: CURSOR c_old_data_set_id IS

Line 4120: FROM BSC_SYS_DATASETS_B a

4116: --END ADEED BY PETER
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;

Line 4134: FROM BSC_SYS_DATASETS_B D,

4130: AND Prototype_Flag <> 2;
4131:
4132: CURSOR C_OPTIONZERO_SOURCE IS
4133: SELECT D.SOURCE,D.DATASET_ID
4134: FROM BSC_SYS_DATASETS_B D,
4135: BSC_KPI_ANALYSIS_MEASURES_B K
4136: WHERE D.DATASET_ID = K.DATASET_ID
4137: AND k.indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4138: AND analysis_option0 = 0

Line 4244: FROM BSC_SYS_DATASETS_B

4240: RAISE FND_API.G_EXC_ERROR;
4241: END IF;
4242:
4243: SELECT Source INTO l_data_source
4244: FROM BSC_SYS_DATASETS_B
4245: WHERE Dataset_Id = l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id;
4246: IF (NOT p_update_ana_opt AND l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id IS NOT NULL) THEN
4247: BSC_BIS_KPI_MEAS_PUB.get_Dim_Set_Source_Info
4248: ( p_Indicator => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id

Line 4995: l_datasource BSC_SYS_DATASETS_B.Source%TYPE;

4991: , x_msg_data OUT NOCOPY VARCHAR2
4992: ) IS
4993: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
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;

Line 5003: FROM BSC_SYS_DATASETS_B

4999: l_sname BSC_KPIS_B.SHORT_NAME%TYPE;
5000:
5001: CURSOR c_data_source IS
5002: SELECT Source
5003: FROM BSC_SYS_DATASETS_B
5004: WHERE Dataset_Id = p_data_set_id;
5005:
5006: CURSOR c_kpi_ids IS
5007: SELECT indicator

Line 7409: FROM BSC_KPI_ANALYSIS_MEASURES_B A, BSC_SYS_DATASETS_B B

7405:
7406: ELSE
7407:
7408: SELECT COUNT (DISTINCT A.dataset_id) INTO l_count
7409: FROM BSC_KPI_ANALYSIS_MEASURES_B A, BSC_SYS_DATASETS_B B
7410: WHERE INDICATOR = p_kpi_id
7411: AND A.DATASET_ID = B.DATASET_ID
7412: AND B.SOURCE = 'BSC';
7413:

Line 7894: BSC_SYS_DATASETS_B SYS

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:
7898: --dbms_output.PUT_LINE('given measure short name is :- '|| l_measure_short_name);