APPS.BSC_COLOR_UPGRADE dependencies on BSC_KPI_MEASURE_PROPS

Line 289: FROM bsc_kpi_measure_props

285: l_kpi_measure_rec c_kpi_measure%ROWTYPE;
286:
287: CURSOR c_kpi_measure_props_exist(p_indicator NUMBER, p_kpi_measure_id NUMBER) IS
288: SELECT COUNT(1)
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;

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

Line 414: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;

410: , prototype_flag prototype_flag
411: FROM bsc_kpis_b
412: WHERE prototype_flag <> 2;
413: l_obj_prototype_flag_rec c_obj_prototype_flag%ROWTYPE;
414: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;
415: l_update_flag BOOLEAN;
416: l_count NUMBER;
417:
418: BEGIN

Line 508: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;

504: FROM bsc_kpi_calculations
505: WHERE default_value = 1;
506:
507: l_obj_default_calc_rec c_obj_default_calc%ROWTYPE;
508: l_default_kpi_measure_id bsc_kpi_measure_props.kpi_measure_id%TYPE;
509:
510: BEGIN
511:
512: FOR l_obj_default_calc_rec IN c_obj_default_calc LOOP

Line 522: UPDATE bsc_kpi_measure_props

518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: END IF;
520:
521: IF l_default_kpi_measure_id IS NOT NULL THEN
522: UPDATE bsc_kpi_measure_props
523: SET default_calculation = l_obj_default_calc_rec.calculation_id,
524: last_update_date = SYSDATE,
525: last_updated_by = FND_GLOBAL.USER_ID
526: WHERE indicator = l_obj_default_calc_rec.objective_id

Line 724: -- Populate BSC_KPI_MEASURE_PROPS

720: IF NOT set_kpi_measure_ids(x_error_msg) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:
724: -- Populate BSC_KPI_MEASURE_PROPS
725: IF NOT set_kpi_measure_props(x_error_msg) THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728: