388: IF (x_mode = 'I') THEN
389: x_last_updated_by := 1;
390: x_last_update_login := 0;
391: ELSIF (x_mode = 'R') THEN
392: x_last_updated_by := fnd_global.user_id;
393: IF (x_last_updated_by IS NULL) THEN
394: x_last_updated_by := -1;
395: END IF;
396: x_last_update_login := fnd_global.login_id;
392: x_last_updated_by := fnd_global.user_id;
393: IF (x_last_updated_by IS NULL) THEN
394: x_last_updated_by := -1;
395: END IF;
396: x_last_update_login := fnd_global.login_id;
397: IF (x_last_update_login IS NULL) THEN
398: x_last_update_login := -1;
399: END IF;
400: x_request_id := fnd_global.conc_request_id;
396: x_last_update_login := fnd_global.login_id;
397: IF (x_last_update_login IS NULL) THEN
398: x_last_update_login := -1;
399: END IF;
400: x_request_id := fnd_global.conc_request_id;
401: x_program_id := fnd_global.conc_program_id;
402: x_program_application_id := fnd_global.prog_appl_id;
403:
404: IF (x_request_id = -1) THEN
397: IF (x_last_update_login IS NULL) THEN
398: x_last_update_login := -1;
399: END IF;
400: x_request_id := fnd_global.conc_request_id;
401: x_program_id := fnd_global.conc_program_id;
402: x_program_application_id := fnd_global.prog_appl_id;
403:
404: IF (x_request_id = -1) THEN
405: x_request_id := NULL;
398: x_last_update_login := -1;
399: END IF;
400: x_request_id := fnd_global.conc_request_id;
401: x_program_id := fnd_global.conc_program_id;
402: x_program_application_id := fnd_global.prog_appl_id;
403:
404: IF (x_request_id = -1) THEN
405: x_request_id := NULL;
406: x_program_id := NULL;
566: IF (X_MODE = 'I') THEN
567: x_last_updated_by := 1;
568: x_last_update_login := 0;
569: ELSIF (x_mode = 'R') THEN
570: x_last_updated_by := fnd_global.user_id;
571: IF x_last_updated_by IS NULL THEN
572: x_last_updated_by := -1;
573: END IF;
574: x_last_update_login := fnd_global.login_id;
570: x_last_updated_by := fnd_global.user_id;
571: IF x_last_updated_by IS NULL THEN
572: x_last_updated_by := -1;
573: END IF;
574: x_last_update_login := fnd_global.login_id;
575: IF (x_last_update_login IS NULL) THEN
576: x_last_update_login := -1;
577: END IF;
578: ELSE
596: x_last_update_login => x_last_update_login
597: );
598:
599: IF (x_mode = 'R') THEN
600: x_request_id := fnd_global.conc_request_id;
601: x_program_id := fnd_global.conc_program_id;
602: x_program_application_id := fnd_global.prog_appl_id;
603: IF (x_request_id = -1) THEN
604: x_request_id := old_references.request_id;
597: );
598:
599: IF (x_mode = 'R') THEN
600: x_request_id := fnd_global.conc_request_id;
601: x_program_id := fnd_global.conc_program_id;
602: x_program_application_id := fnd_global.prog_appl_id;
603: IF (x_request_id = -1) THEN
604: x_request_id := old_references.request_id;
605: x_program_id := old_references.program_id;
598:
599: IF (x_mode = 'R') THEN
600: x_request_id := fnd_global.conc_request_id;
601: x_program_id := fnd_global.conc_program_id;
602: x_program_application_id := fnd_global.prog_appl_id;
603: IF (x_request_id = -1) THEN
604: x_request_id := old_references.request_id;
605: x_program_id := old_references.program_id;
606: x_program_application_id := old_references.program_application_id;