eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_KPI_COLOR_PROPERTIES_PUB dependencies on BSC_KPI_MEASURE_WEIGHTS

Line 252: , p_kpi_weight IN BSC_KPI_MEASURE_WEIGHTS.weight%TYPE

248: PROCEDURE Create_Update_Kpi_Mes_Weights (
249: p_commit IN VARCHAR2 := FND_API.G_FALSE
250: , p_objective_id IN BSC_KPIS_B.indicator%TYPE
251: , p_kpi_measure_id IN BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
252: , p_kpi_weight IN BSC_KPI_MEASURE_WEIGHTS.weight%TYPE
253: , x_return_status OUT NOCOPY VARCHAR2
254: , x_msg_count OUT NOCOPY NUMBER
255: , x_msg_data OUT NOCOPY VARCHAR2
256: )

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 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;

269: l_kpi_measure_weights_rec.objective_id := p_objective_id;
270: l_kpi_measure_weights_rec.kpi_measure_id := p_kpi_measure_id;
271: l_kpi_measure_weights_rec.weight := p_kpi_weight;
272:
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

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