APPS.BIS_PMF_MIGRATION_PUB dependencies on BIS_INDICATOR_DIMENSIONS

Line 56: bis_indicator_dimensions

52: )
53: IS
54: CURSOR c_dimcount(p_measure_id IN NUMBER) IS
55: SELECT count(1) FROM
56: bis_indicator_dimensions
57: WHERE indicator_id = p_measure_id;
58: l_reseuenced_dimensions_array BIS_PMF_MIGRATION_PUB.resequenced_dimensions_array;
59: l_dimcount NUMBER;
60: BEGIN

Line 302: UPDATE bis_indicator_dimensions

298: FOR l_count IN 1..l_reseq_dims.COUNT LOOP
299: IF (l_reseq_dims(l_count).dim_id IS NULL) THEN
300: EXIT;
301: ELSE
302: UPDATE bis_indicator_dimensions
303: SET sequence_no = l_dummy_value
304: WHERE dimension_id=l_Reseq_dims(l_count).dim_id AND
305: indicator_id=c_rec.indicator_id;
306: END IF;

Line 313: UPDATE bis_indicator_dimensions

309: FOR l_count IN 1..l_reseq_dims.COUNT LOOP
310: IF (l_reseq_dims(l_count).dim_id IS NULL) THEN
311: EXIT;
312: ELSE
313: UPDATE bis_indicator_dimensions
314: SET sequence_no= l_reseq_dims(l_count).seq_no
315: WHERE dimension_id = l_reseq_dims(l_count).dim_id AND
316: indicator_id = c_Rec.indicator_id;
317: END IF;