DBA Data[Home] [Help]

APPS.BIS_PMF_MIGRATION_PUB dependencies on BIS_TARGET_VALUES

Line 241: FROM bis_target_values

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
241: FROM bis_target_values
242: WHERE target_level_id = p_target_level_id;
243: l_target_level_rec BIS_PMF_MIGRATION_PUB.target_level_rec;
244: l_reseq_dims BIS_PMF_MIGRATION_PUB.resequenced_dimensions_Array;
245: l_target_rec BIS_PMF_MIGRATION_PUB.target_rec;

Line 350: l_sqlstmt1 := 'UPDATE bis_target_values SET '||

346: ,x_reseq_target_values => l_reseq_target_values
347: ,x_return_Status => l_return_status
348: );
349: IF ((l_return_status = 0) AND (l_reseq_target_values.COUNT > 0)) THEN
350: l_sqlstmt1 := 'UPDATE bis_target_values SET '||
351: l_reseq_target_values(1).target_level ||' = :1'||
352: ' ,'|| l_Reseq_target_values(2).target_level ||' = :2' ||
353: ' ,' || l_Reseq_target_values(3).target_level||' = :3'||
354: ' ,' || l_Reseq_target_values(4).target_level||' = :4' ||