235: IF (x_mode = 'I') THEN
236: x_last_updated_by := 1;
237: x_last_update_login := 0;
238: ELSIF (x_mode = 'R') THEN
239: x_last_updated_by := fnd_global.user_id;
240: IF (x_last_updated_by IS NULL) THEN
241: x_last_updated_by := -1;
242: END IF;
243: x_last_update_login := fnd_global.login_id;
239: x_last_updated_by := fnd_global.user_id;
240: IF (x_last_updated_by IS NULL) THEN
241: x_last_updated_by := -1;
242: END IF;
243: x_last_update_login := fnd_global.login_id;
244: IF (x_last_update_login IS NULL) THEN
245: x_last_update_login := -1;
246: END IF;
247: x_request_id := fnd_global.conc_request_id;
243: x_last_update_login := fnd_global.login_id;
244: IF (x_last_update_login IS NULL) THEN
245: x_last_update_login := -1;
246: END IF;
247: x_request_id := fnd_global.conc_request_id;
248: x_program_id := fnd_global.conc_program_id;
249: x_program_application_id := fnd_global.prog_appl_id;
250:
251: IF (x_request_id = -1) THEN
244: IF (x_last_update_login IS NULL) THEN
245: x_last_update_login := -1;
246: END IF;
247: x_request_id := fnd_global.conc_request_id;
248: x_program_id := fnd_global.conc_program_id;
249: x_program_application_id := fnd_global.prog_appl_id;
250:
251: IF (x_request_id = -1) THEN
252: x_request_id := NULL;
245: x_last_update_login := -1;
246: END IF;
247: x_request_id := fnd_global.conc_request_id;
248: x_program_id := fnd_global.conc_program_id;
249: x_program_application_id := fnd_global.prog_appl_id;
250:
251: IF (x_request_id = -1) THEN
252: x_request_id := NULL;
253: x_program_id := NULL;
443: IF (X_MODE = 'I') THEN
444: x_last_updated_by := 1;
445: x_last_update_login := 0;
446: ELSIF (x_mode = 'R') THEN
447: x_last_updated_by := fnd_global.user_id;
448: IF x_last_updated_by IS NULL THEN
449: x_last_updated_by := -1;
450: END IF;
451: x_last_update_login := fnd_global.login_id;
447: x_last_updated_by := fnd_global.user_id;
448: IF x_last_updated_by IS NULL THEN
449: x_last_updated_by := -1;
450: END IF;
451: x_last_update_login := fnd_global.login_id;
452: IF (x_last_update_login IS NULL) THEN
453: x_last_update_login := -1;
454: END IF;
455: ELSE
477: x_last_update_login => x_last_update_login
478: );
479:
480: IF (x_mode = 'R') THEN
481: x_request_id := fnd_global.conc_request_id;
482: x_program_id := fnd_global.conc_program_id;
483: x_program_application_id := fnd_global.prog_appl_id;
484: IF (x_request_id = -1) THEN
485: x_request_id := old_references.request_id;
478: );
479:
480: IF (x_mode = 'R') THEN
481: x_request_id := fnd_global.conc_request_id;
482: x_program_id := fnd_global.conc_program_id;
483: x_program_application_id := fnd_global.prog_appl_id;
484: IF (x_request_id = -1) THEN
485: x_request_id := old_references.request_id;
486: x_program_id := old_references.program_id;
479:
480: IF (x_mode = 'R') THEN
481: x_request_id := fnd_global.conc_request_id;
482: x_program_id := fnd_global.conc_program_id;
483: x_program_application_id := fnd_global.prog_appl_id;
484: IF (x_request_id = -1) THEN
485: x_request_id := old_references.request_id;
486: x_program_id := old_references.program_id;
487: x_program_application_id := old_references.program_application_id;