DBA Data[Home] [Help]

APPS.BSC_COLOR_UPGRADE dependencies on BSC_KPI_MEASURE_PROPS_PUB

Line 293: l_kpi_measure_props_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;

289: FROM bsc_kpi_measure_props
290: WHERE indicator = p_indicator
291: AND kpi_measure_id = p_kpi_measure_id;
292:
293: l_kpi_measure_props_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
294: l_default_kpi_measure_id NUMBER;
295: l_kpi_measure_props_exist NUMBER;
296: l_return_status VARCHAR2(1);
297: l_msg_count NUMBER;

Line 321: l_kpi_measure_props_rec.prototype_trend := BSC_KPI_MEASURE_PROPS_PUB.C_TREND_UNACC_DECREASE;

317: IF l_kpi_measure_props_exist = 0 THEN
318:
319: l_kpi_measure_props_rec.objective_id := l_kpi_measure_rec.indicator;
320: l_kpi_measure_props_rec.kpi_measure_id := l_kpi_measure_rec.kpi_measure_id;
321: l_kpi_measure_props_rec.prototype_trend := BSC_KPI_MEASURE_PROPS_PUB.C_TREND_UNACC_DECREASE;
322: l_kpi_measure_props_rec.disable_color := 'T';
323: l_kpi_measure_props_rec.disable_trend := 'T';
324: l_kpi_measure_props_rec.prototype_color := 24865;
325: l_kpi_measure_props_rec.color_by_total := 1;

Line 363: BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props

359: , l_default_kpi_measure_id
360: );
361: END IF;
362:
363: BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props
364: ( p_commit => FND_API.G_FALSE
365: , p_kpi_measure_rec => l_kpi_measure_props_rec
366: , p_cascade_shared => FALSE
367: , x_return_status => l_return_status