DBA Data[Home] [Help]

APPS.BSC_KPI_COLOR_PROPERTIES_PUB dependencies on BSC_KPI_MEASURE_PROPS

Line 12: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE

8: PROCEDURE Update_Kpi_Color_Properties (
9: p_commit IN VARCHAR2 := FND_API.G_FALSE
10: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
11: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
12: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
13: , p_kpi_prototype_color IN BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
14: , p_kpi_prototype_trend IN BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
15: , p_color_by_total IN BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
16: , p_disable_trend IN BSC_KPI_MEASURE_PROPS.disable_trend%TYPE

Line 13: , p_kpi_prototype_color IN BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE

9: p_commit IN VARCHAR2 := FND_API.G_FALSE
10: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
11: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
12: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
13: , p_kpi_prototype_color IN BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
14: , p_kpi_prototype_trend IN BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
15: , p_color_by_total IN BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
16: , p_disable_trend IN BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
17: , p_need_color_recalc IN VARCHAR2 := 'N'

Line 14: , p_kpi_prototype_trend IN BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE

10: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
11: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
12: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
13: , p_kpi_prototype_color IN BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
14: , p_kpi_prototype_trend IN BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
15: , p_color_by_total IN BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
16: , p_disable_trend IN BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
17: , p_need_color_recalc IN VARCHAR2 := 'N'
18: , x_return_status OUT NOCOPY VARCHAR2

Line 15: , p_color_by_total IN BSC_KPI_MEASURE_PROPS.color_by_total%TYPE

11: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
12: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
13: , p_kpi_prototype_color IN BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
14: , p_kpi_prototype_trend IN BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
15: , p_color_by_total IN BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
16: , p_disable_trend IN BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
17: , p_need_color_recalc IN VARCHAR2 := 'N'
18: , x_return_status OUT NOCOPY VARCHAR2
19: , x_msg_count OUT NOCOPY NUMBER

Line 16: , p_disable_trend IN BSC_KPI_MEASURE_PROPS.disable_trend%TYPE

12: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
13: , p_kpi_prototype_color IN BSC_KPI_MEASURE_PROPS.prototype_color_id%TYPE
14: , p_kpi_prototype_trend IN BSC_KPI_MEASURE_PROPS.prototype_trend_id%TYPE
15: , p_color_by_total IN BSC_KPI_MEASURE_PROPS.color_by_total%TYPE
16: , p_disable_trend IN BSC_KPI_MEASURE_PROPS.disable_trend%TYPE
17: , p_need_color_recalc IN VARCHAR2 := 'N'
18: , x_return_status OUT NOCOPY VARCHAR2
19: , x_msg_count OUT NOCOPY NUMBER
20: , x_msg_data OUT NOCOPY VARCHAR2

Line 23: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;

19: , x_msg_count OUT NOCOPY NUMBER
20: , x_msg_data OUT NOCOPY VARCHAR2
21: )
22: IS
23: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
24: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
25:
26: BEGIN
27:

Line 33: BSC_KPI_MEASURE_PROPS_PUB.Retrieve_Kpi_Measure_Props

29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31: -- Any Business Logic Validation
32:
33: BSC_KPI_MEASURE_PROPS_PUB.Retrieve_Kpi_Measure_Props
34: ( p_objective_id => p_objective_id
35: , p_kpi_measure_id => p_kpi_measure_id
36: , x_kpi_measure_rec => l_kpi_measure_rec
37: , x_return_status => x_return_status

Line 52: BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props

48: l_kpi_measure_rec.prototype_color := p_kpi_prototype_color;
49: l_kpi_measure_rec.prototype_trend := p_kpi_prototype_trend;
50: l_kpi_measure_rec.color_by_total := p_color_by_total;
51:
52: BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props
53: ( p_commit => p_commit
54: , p_kpi_measure_rec => l_kpi_measure_rec
55: , x_return_status => x_return_status
56: , x_msg_count => x_msg_count

Line 489: l_kpi_measure_id := BSC_KPI_MEASURE_PROPS_PUB.get_shared_obj_kpi_measure

485: );
486:
487: FOR c_shared IN c_shared_obj(p_objective_id) LOOP
488:
489: l_kpi_measure_id := BSC_KPI_MEASURE_PROPS_PUB.get_shared_obj_kpi_measure
490: ( p_objective_id => p_objective_id
491: , p_kpi_measure_id => p_kpi_measure_id
492: , p_shared_objective_id => c_shared.indicator
493: );

Line 651: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE

647: PROCEDURE Save_Disable_Color_Of_Kpi (
648: p_commit IN VARCHAR2 := FND_API.G_FALSE
649: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
650: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
651: , p_disable_color IN BSC_KPI_MEASURE_PROPS.disable_color%TYPE
652: , p_need_color_recalc IN VARCHAR2 := 'N'
653: , x_return_status OUT NOCOPY VARCHAR2
654: , x_msg_count OUT NOCOPY NUMBER
655: , x_msg_data OUT NOCOPY VARCHAR2

Line 658: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;

654: , x_msg_count OUT NOCOPY NUMBER
655: , x_msg_data OUT NOCOPY VARCHAR2
656: )
657: IS
658: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
659: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
660:
661: BEGIN
662:

Line 668: BSC_KPI_MEASURE_PROPS_PUB.Retrieve_Kpi_Measure_Props

664: x_return_status := FND_API.G_RET_STS_SUCCESS;
665:
666: -- Any Business Logic Validation
667:
668: BSC_KPI_MEASURE_PROPS_PUB.Retrieve_Kpi_Measure_Props
669: ( p_objective_id => p_objective_id
670: , p_kpi_measure_id => p_kpi_measure_id
671: , x_kpi_measure_rec => l_kpi_measure_rec
672: , x_return_status => x_return_status

Line 683: BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props

679: END IF;
680:
681: l_kpi_measure_rec.disable_color := p_disable_color;
682:
683: BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props
684: ( p_commit => p_commit
685: , p_kpi_measure_rec => l_kpi_measure_rec
686: , x_return_status => x_return_status
687: , x_msg_count => x_msg_count