APPS.BSC_SIMULATION_VIEW_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 1435: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;

1431: ,x_return_status OUT NOCOPY VARCHAR2
1432: ,x_msg_count OUT NOCOPY NUMBER
1433: ,x_msg_data OUT NOCOPY VARCHAR2
1434: )IS
1435: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1436: l_count NUMBER;
1437: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
1438: l_Bsc_Kpi_Color_Range_New_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
1439: l_color_ranges_changed VARCHAR2(2) := FND_API.G_FALSE;

Line 1589: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;

1585: p_indicator IN NUMBER
1586: ,p_dataset_id IN NUMBER
1587: ) RETURN NUMBER
1588: IS
1589: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1590: BEGIN
1591:
1592: SELECT kpi_measure_id
1593: INTO l_kpi_measure_id

Line 1594: FROM bsc_kpi_analysis_measures_b

1590: BEGIN
1591:
1592: SELECT kpi_measure_id
1593: INTO l_kpi_measure_id
1594: FROM bsc_kpi_analysis_measures_b
1595: WHERE indicator = p_indicator
1596: AND dataset_id = p_dataset_id;
1597:
1598: RETURN l_kpi_measure_id;

Line 1788: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;

1784: WHERE indicator =p_indicator
1785: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1786:
1787: l_count NUMBER;
1788: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1789:
1790: BEGIN
1791: FND_MSG_PUB.INITIALIZE;
1792: x_return_status := FND_API.G_RET_STS_SUCCESS;