APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_SYS_DATASETS_B

Line 1550: l_Old_Measure_Id1 BSC_SYS_DATASETS_B.MEASURE_ID1%TYPE;

1546: l_last_update_date BIS_INDICATORS.LAST_UPDATE_DATE%TYPE;
1547:
1548: -- Added for Bug#4617140
1549: l_Old_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
1550: l_Old_Measure_Id1 BSC_SYS_DATASETS_B.MEASURE_ID1%TYPE;
1551: l_Old_Measure_Id2 BSC_SYS_DATASETS_B.MEASURE_ID2%TYPE;
1552: l_Is_Converted_To_Formula_Type BOOLEAN;
1553: l_Report_Objectives VARCHAR2(2000);
1554:

Line 1551: l_Old_Measure_Id2 BSC_SYS_DATASETS_B.MEASURE_ID2%TYPE;

1547:
1548: -- Added for Bug#4617140
1549: l_Old_Measure_Col BSC_SYS_MEASURES.MEASURE_COL%TYPE;
1550: l_Old_Measure_Id1 BSC_SYS_DATASETS_B.MEASURE_ID1%TYPE;
1551: l_Old_Measure_Id2 BSC_SYS_DATASETS_B.MEASURE_ID2%TYPE;
1552: l_Is_Converted_To_Formula_Type BOOLEAN;
1553: l_Report_Objectives VARCHAR2(2000);
1554:
1555: CURSOR c_measure_col_cur( c_measure_col_name VARCHAR2 ) IS

Line 1572: FROM BSC_SYS_DATASETS_B

1568:
1569: CURSOR c_Dataset_Measures IS
1570: SELECT MEASURE_ID1
1571: , MEASURE_ID2
1572: FROM BSC_SYS_DATASETS_B
1573: WHERE DATASET_ID = p_dataset_id;
1574:
1575: CURSOR c_Bsc_Dataset_Name IS
1576: SELECT NAME

Line 1587: FROM BSC_SYS_DATASETS_B D, BSC_SYS_MEASURES M

1583: WHERE DATASET_ID = p_dataset_id;
1584:
1585: CURSOR c_Intial_Formula_Content IS
1586: SELECT D.MEASURE_ID1, D.MEASURE_ID2, M.MEASURE_COL
1587: FROM BSC_SYS_DATASETS_B D, BSC_SYS_MEASURES M
1588: WHERE D.DATASET_ID = p_Dataset_ID
1589: AND M.MEASURE_ID = D.MEASURE_ID1;
1590:
1591: begin

Line 1754: remains within the system. When one Measure (bsc_sys_datasets_b) has its datasource

1750:
1751: -- Fix for Bug#3781176
1752: /*
1753: The following logic ensures that no dangling entries in bsc_sys_measures
1754: remains within the system. When one Measure (bsc_sys_datasets_b) has its datasource
1755: changed, then we need to delete it during update and ensure that it is not orphened
1756: i.e its achieved using the Delete_Measures from the Private datasets package (BSC_DATASETS_PVT)
1757: */
1758:

Line 2187: from bsc_sys_datasets_B d, bisbv_performance_measures pm

2183:
2184: -- Added measure_id2 to be passed to lower APIs Bug#3628113
2185: select measure_id1, measure_id2, pm.measure_id
2186: into l_Dataset_Rec.Bsc_Measure_Id, l_Dataset_Rec.Bsc_Measure_Id2, l_Measure_Rec.Measure_Id
2187: from bsc_sys_datasets_B d, bisbv_performance_measures pm
2188: where d.dataset_id = p_dataset_id
2189: and d.dataset_id = pm.dataset_id (+);
2190:
2191:

Line 4478: FROM BSC_SYS_DATASETS_B

4474: l_count := 0;
4475: l_dataset_id := NULL;
4476:
4477: SELECT COUNT(1) into l_count
4478: FROM BSC_SYS_DATASETS_B
4479: WHERE MEASURE_ID1 =TO_NUMBER(p_measure_id)
4480: AND MEASURE_ID2 IS NULL;
4481:
4482: IF (l_count=1) THEN

Line 4484: FROM BSC_SYS_DATASETS_B

4480: AND MEASURE_ID2 IS NULL;
4481:
4482: IF (l_count=1) THEN
4483: SELECT DATASET_ID INTO l_dataset_id
4484: FROM BSC_SYS_DATASETS_B
4485: WHERE MEASURE_ID1 = TO_NUMBER(p_measure_id)
4486: AND MEASURE_ID2 IS NULL;
4487:
4488: END IF;

Line 4544: BSC_SYS_DATASETS_B ME

4540: OB.NAME
4541: FROM
4542: BSC_KPIS_VL OB,
4543: BSC_KPI_ANALYSIS_MEASURES_B AM,
4544: BSC_SYS_DATASETS_B ME
4545: WHERE
4546: ME.DATASET_ID = p_Dataset_Id AND
4547: AM.DATASET_ID = ME.DATASET_ID AND
4548: OB.INDICATOR = AM.INDICATOR AND