301: transf_header_rec.TO_VALUE_DESC,
302: l_all_value,
303: l_all_desc,
304: sysdate,
305: FND_GLOBAL.USER_ID,
306: sysdate,
307: FND_GLOBAL.USER_ID,
308: FND_GLOBAL.LOGIN_ID,
309: null);
303: l_all_desc,
304: sysdate,
305: FND_GLOBAL.USER_ID,
306: sysdate,
307: FND_GLOBAL.USER_ID,
308: FND_GLOBAL.LOGIN_ID,
309: null);
310: exception
311: when others then
304: sysdate,
305: FND_GLOBAL.USER_ID,
306: sysdate,
307: FND_GLOBAL.USER_ID,
308: FND_GLOBAL.LOGIN_ID,
309: null);
310: exception
311: when others then
312: errbuf := substr(SQLERRM,1,150);
322: qpr_transformation.get_num(measure_rec.level_value_to),
323: measure8_number =
324: qpr_transformation.get_num(measure_rec.level_value_from),
325: last_update_date = sysdate,
326: last_updated_by = fnd_global.user_id,
327: last_update_login = fnd_global.login_id
328: where measure_value_id = measure_rec.measure_value_id;
329: elsif transf_header_rec.to_dim_code = 'VLB' then
330: update qpr_measure_data
323: measure8_number =
324: qpr_transformation.get_num(measure_rec.level_value_from),
325: last_update_date = sysdate,
326: last_updated_by = fnd_global.user_id,
327: last_update_login = fnd_global.login_id
328: where measure_value_id = measure_rec.measure_value_id;
329: elsif transf_header_rec.to_dim_code = 'VLB' then
330: update qpr_measure_data
331: set vlb_level_value = transf_header_rec.to_value,
335: qpr_transformation.get_num(measure_rec.level_value_from),
336: measure9_number = measure_rec.measure4_number,
337: measure10_number = measure_rec.measure4_number,
338: last_update_date = sysdate,
339: last_updated_by = fnd_global.user_id,
340: last_update_login = fnd_global.login_id
341: where measure_value_id = measure_rec.measure_value_id;
342: elsif transf_header_rec.to_dim_code = 'MGB' then
343: update qpr_measure_data
336: measure9_number = measure_rec.measure4_number,
337: measure10_number = measure_rec.measure4_number,
338: last_update_date = sysdate,
339: last_updated_by = fnd_global.user_id,
340: last_update_login = fnd_global.login_id
341: where measure_value_id = measure_rec.measure_value_id;
342: elsif transf_header_rec.to_dim_code = 'MGB' then
343: update qpr_measure_data
344: set mgb_level_value = transf_header_rec.to_value,
346: qpr_transformation.get_num(measure_rec.level_value_to),
347: measure19_number =
348: qpr_transformation.get_num(measure_rec.level_value_from),
349: last_update_date = sysdate,
350: last_updated_by = fnd_global.user_id,
351: last_update_login = fnd_global.login_id
352: where measure_value_id =
353: measure_rec.measure_value_id;
354: end if;
347: measure19_number =
348: qpr_transformation.get_num(measure_rec.level_value_from),
349: last_update_date = sysdate,
350: last_updated_by = fnd_global.user_id,
351: last_update_login = fnd_global.login_id
352: where measure_value_id =
353: measure_rec.measure_value_id;
354: end if;
355: fnd_file.put_line(fnd_file.log, 'Updated '||
552: transf_header_rec.to_value, null), level8_value),
553: level8_desc = nvl(decode(transf_header_rec.to_level_id, 8,
554: transf_header_rec.to_value_desc, null), level8_desc),
555: last_update_date = sysdate,
556: last_updated_by = fnd_global.user_id,
557: last_update_login = fnd_global.login_id
558: where dim_value_id = c_dim_rec.dim_value_id(I);
559: fnd_file.put_line(fnd_file.log, 'Number of rows updated: '||sql%rowcount);
560: exception
553: level8_desc = nvl(decode(transf_header_rec.to_level_id, 8,
554: transf_header_rec.to_value_desc, null), level8_desc),
555: last_update_date = sysdate,
556: last_updated_by = fnd_global.user_id,
557: last_update_login = fnd_global.login_id
558: where dim_value_id = c_dim_rec.dim_value_id(I);
559: fnd_file.put_line(fnd_file.log, 'Number of rows updated: '||sql%rowcount);
560: exception
561: when others then
570: update qpr_dimension_values
571: set level2_value = transf_header_rec.to_value,
572: level2_desc = transf_header_rec.to_value_desc,
573: last_update_date = sysdate,
574: last_updated_by = fnd_global.user_id,
575: last_update_login = fnd_global.login_id
576: where dim_value_id = c_dim_rec.dim_value_id(I);
577: exception
578: when others then
571: set level2_value = transf_header_rec.to_value,
572: level2_desc = transf_header_rec.to_value_desc,
573: last_update_date = sysdate,
574: last_updated_by = fnd_global.user_id,
575: last_update_login = fnd_global.login_id
576: where dim_value_id = c_dim_rec.dim_value_id(I);
577: exception
578: when others then
579: errbuf := substr(SQLERRM,1,150);
587: update qpr_dimension_values
588: set level3_value = transf_header_rec.to_value,
589: level3_desc = transf_header_rec.to_value_desc,
590: last_update_date = sysdate,
591: last_updated_by = fnd_global.user_id,
592: last_update_login = fnd_global.login_id
593: where dim_value_id = c_dim_rec.dim_value_id(I);
594: exception
595: when others then
588: set level3_value = transf_header_rec.to_value,
589: level3_desc = transf_header_rec.to_value_desc,
590: last_update_date = sysdate,
591: last_updated_by = fnd_global.user_id,
592: last_update_login = fnd_global.login_id
593: where dim_value_id = c_dim_rec.dim_value_id(I);
594: exception
595: when others then
596: errbuf := substr(SQLERRM,1,150);