[Home] [Help]
232: SELECT target_level_id, indicator_id, short_name
233: ,time_level_id, org_level_id, dimension1_level_id
234: ,dimension2_level_id, dimension3_level_id, dimension4_level_id
235: ,dimension5_level_id
236: FROM bis_target_levels;
237: CURSOR c_targetlvl_values(p_target_level_id IN NUMBER) IS
238: SELECT target_id, org_level_value, time_level_value
239: ,dimension1_level_value, dimension2_level_value, dimension3_level_value
240: ,dimension4_level_value, dimension5_level_value
316: indicator_id = c_Rec.indicator_id;
317: END IF;
318: END LOOP;
319: IF (l_dim_count = l_dimlevel_count) THEN
320: l_sqlstmt := 'UPDATE bis_target_levels SET ' ||
321: l_reseq_dims(1).dim_level_col ||' = :1' ||
322: ' , '||l_reseq_dims(2).dim_level_col ||' = :2'||
323: ' , '||l_reseq_dims(3).dim_level_col ||' = :3'||
324: ' , '||l_reseq_dims(4).dim_level_col ||' = :4'||