448: IF (x_mode = 'I') THEN
449: x_last_updated_by := 1;
450: x_last_update_login := 0;
451: ELSIF (x_mode = 'R') THEN
452: x_last_updated_by := fnd_global.user_id;
453: IF (x_last_updated_by IS NULL) THEN
454: x_last_updated_by := -1;
455: END IF;
456: x_last_update_login := fnd_global.login_id;
452: x_last_updated_by := fnd_global.user_id;
453: IF (x_last_updated_by IS NULL) THEN
454: x_last_updated_by := -1;
455: END IF;
456: x_last_update_login := fnd_global.login_id;
457: IF (x_last_update_login IS NULL) THEN
458: x_last_update_login := -1;
459: END IF;
460: x_request_id := fnd_global.conc_request_id;
456: x_last_update_login := fnd_global.login_id;
457: IF (x_last_update_login IS NULL) THEN
458: x_last_update_login := -1;
459: END IF;
460: x_request_id := fnd_global.conc_request_id;
461: x_program_id := fnd_global.conc_program_id;
462: x_program_application_id := fnd_global.prog_appl_id;
463:
464: IF (x_request_id = -1) THEN
457: IF (x_last_update_login IS NULL) THEN
458: x_last_update_login := -1;
459: END IF;
460: x_request_id := fnd_global.conc_request_id;
461: x_program_id := fnd_global.conc_program_id;
462: x_program_application_id := fnd_global.prog_appl_id;
463:
464: IF (x_request_id = -1) THEN
465: x_request_id := NULL;
458: x_last_update_login := -1;
459: END IF;
460: x_request_id := fnd_global.conc_request_id;
461: x_program_id := fnd_global.conc_program_id;
462: x_program_application_id := fnd_global.prog_appl_id;
463:
464: IF (x_request_id = -1) THEN
465: x_request_id := NULL;
466: x_program_id := NULL;
656: IF (X_MODE = 'I') THEN
657: x_last_updated_by := 1;
658: x_last_update_login := 0;
659: ELSIF (x_mode = 'R') THEN
660: x_last_updated_by := fnd_global.user_id;
661: IF x_last_updated_by IS NULL THEN
662: x_last_updated_by := -1;
663: END IF;
664: x_last_update_login := fnd_global.login_id;
660: x_last_updated_by := fnd_global.user_id;
661: IF x_last_updated_by IS NULL THEN
662: x_last_updated_by := -1;
663: END IF;
664: x_last_update_login := fnd_global.login_id;
665: IF (x_last_update_login IS NULL) THEN
666: x_last_update_login := -1;
667: END IF;
668: ELSE
690: x_last_update_login => x_last_update_login
691: );
692:
693: IF (x_mode = 'R') THEN
694: x_request_id := fnd_global.conc_request_id;
695: x_program_id := fnd_global.conc_program_id;
696: x_program_application_id := fnd_global.prog_appl_id;
697: IF (x_request_id = -1) THEN
698: x_request_id := old_references.request_id;
691: );
692:
693: IF (x_mode = 'R') THEN
694: x_request_id := fnd_global.conc_request_id;
695: x_program_id := fnd_global.conc_program_id;
696: x_program_application_id := fnd_global.prog_appl_id;
697: IF (x_request_id = -1) THEN
698: x_request_id := old_references.request_id;
699: x_program_id := old_references.program_id;
692:
693: IF (x_mode = 'R') THEN
694: x_request_id := fnd_global.conc_request_id;
695: x_program_id := fnd_global.conc_program_id;
696: x_program_application_id := fnd_global.prog_appl_id;
697: IF (x_request_id = -1) THEN
698: x_request_id := old_references.request_id;
699: x_program_id := old_references.program_id;
700: x_program_application_id := old_references.program_application_id;