DBA Data[Home] [Help]

APPS.BSC_SIMULATION_VIEW_PUB dependencies on BSC_COLOR_RANGES_PUB

Line 1437: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

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;
1440:
1441: CURSOR c_color_ranges IS

Line 1438: l_Bsc_Kpi_Color_Range_New_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;

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;
1440:
1441: CURSOR c_color_ranges IS
1442: SELECT a.color_range_sequence,a.low,a.high,a.color_id

Line 1469: BSC_COLOR_RANGES_PUB.Save_Color_Prop_Ranges

1465: l_Bsc_Kpi_Color_Range_Rec(l_count).color_id := cd.color_id;
1466: l_count := l_count + 1;
1467: END LOOP;
1468:
1469: BSC_COLOR_RANGES_PUB.Save_Color_Prop_Ranges
1470: (
1471: p_commit => FND_API.G_FALSE
1472: , p_objective_id => p_indicator
1473: , p_kpi_measure_id => l_kpi_measure_id