DBA Data[Home] [Help]

APPS.BSC_KPI_COLOR_PROPERTIES_PUB dependencies on BSC_KPI_MEASURE_WEIGHTS_PUB

Line 258: l_kpi_measure_weights_rec BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec;

254: , x_msg_count OUT NOCOPY NUMBER
255: , x_msg_data OUT NOCOPY VARCHAR2
256: )
257: IS
258: l_kpi_measure_weights_rec BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec;
259: l_num VARCHAR(2);
260: l_obj_prototype_flag BSC_KPIS_B.prototype_flag%TYPE;
261: l_color_rollup_type BSC_KPIS_B.color_rollup_type%TYPE;
262: BEGIN

Line 277: BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights

273: SELECT count(1) INTO l_num FROM bsc_kpi_measure_weights WHERE indicator = p_objective_id AND kpi_measure_id = p_kpi_measure_id;
274:
275: IF (l_num = 0) THEN
276:
277: BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights
278: ( p_commit => p_commit
279: , p_kpi_measure_weights_rec => l_kpi_measure_weights_rec
280: , p_cascade_shared => TRUE
281: , x_return_status => x_return_status

Line 292: BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights

288: END IF;
289:
290: ELSE
291:
292: BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights
293: ( p_commit => p_commit
294: , p_kpi_measure_weights_rec => l_kpi_measure_weights_rec
295: , p_cascade_shared => TRUE
296: , x_return_status => x_return_status