DBA Data[Home] [Help]

APPS.QPR_TRANSFORMATION dependencies on FND_GLOBAL

Line 305: FND_GLOBAL.USER_ID,

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

Line 307: FND_GLOBAL.USER_ID,

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

Line 308: FND_GLOBAL.LOGIN_ID,

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

Line 326: last_updated_by = fnd_global.user_id,

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

Line 327: last_update_login = fnd_global.login_id

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,

Line 339: last_updated_by = fnd_global.user_id,

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

Line 340: last_update_login = fnd_global.login_id

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,

Line 350: last_updated_by = fnd_global.user_id,

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;

Line 351: last_update_login = fnd_global.login_id

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

Line 556: last_updated_by = fnd_global.user_id,

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

Line 557: last_update_login = fnd_global.login_id

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

Line 574: last_updated_by = fnd_global.user_id,

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

Line 575: last_update_login = fnd_global.login_id

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

Line 591: last_updated_by = fnd_global.user_id,

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

Line 592: last_update_login = fnd_global.login_id

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