444: IF (x_mode = 'I') THEN
445: x_last_updated_by := 1;
446: x_last_update_login := 0;
447: ELSIF (x_mode = 'R') THEN
448: x_last_updated_by := fnd_global.user_id;
449: IF (x_last_updated_by IS NULL) THEN
450: x_last_updated_by := -1;
451: END IF;
452: x_last_update_login := fnd_global.login_id;
448: x_last_updated_by := fnd_global.user_id;
449: IF (x_last_updated_by IS NULL) THEN
450: x_last_updated_by := -1;
451: END IF;
452: x_last_update_login := fnd_global.login_id;
453: IF (x_last_update_login IS NULL) THEN
454: x_last_update_login := -1;
455: END IF;
456: x_request_id := fnd_global.conc_request_id;
452: x_last_update_login := fnd_global.login_id;
453: IF (x_last_update_login IS NULL) THEN
454: x_last_update_login := -1;
455: END IF;
456: x_request_id := fnd_global.conc_request_id;
457: x_program_id := fnd_global.conc_program_id;
458: x_program_application_id := fnd_global.prog_appl_id;
459:
460: IF (x_request_id = -1) THEN
453: IF (x_last_update_login IS NULL) THEN
454: x_last_update_login := -1;
455: END IF;
456: x_request_id := fnd_global.conc_request_id;
457: x_program_id := fnd_global.conc_program_id;
458: x_program_application_id := fnd_global.prog_appl_id;
459:
460: IF (x_request_id = -1) THEN
461: x_request_id := NULL;
454: x_last_update_login := -1;
455: END IF;
456: x_request_id := fnd_global.conc_request_id;
457: x_program_id := fnd_global.conc_program_id;
458: x_program_application_id := fnd_global.prog_appl_id;
459:
460: IF (x_request_id = -1) THEN
461: x_request_id := NULL;
462: x_program_id := NULL;
855: IF (X_MODE = 'I') THEN
856: x_last_updated_by := 1;
857: x_last_update_login := 0;
858: ELSIF (x_mode = 'R') THEN
859: x_last_updated_by := fnd_global.user_id;
860: IF x_last_updated_by IS NULL THEN
861: x_last_updated_by := -1;
862: END IF;
863: x_last_update_login := fnd_global.login_id;
859: x_last_updated_by := fnd_global.user_id;
860: IF x_last_updated_by IS NULL THEN
861: x_last_updated_by := -1;
862: END IF;
863: x_last_update_login := fnd_global.login_id;
864: IF (x_last_update_login IS NULL) THEN
865: x_last_update_login := -1;
866: END IF;
867: ELSE
923: x_last_update_login => x_last_update_login
924: );
925:
926: IF (x_mode = 'R') THEN
927: x_request_id := fnd_global.conc_request_id;
928: x_program_id := fnd_global.conc_program_id;
929: x_program_application_id := fnd_global.prog_appl_id;
930: IF (x_request_id = -1) THEN
931: x_request_id := old_references.request_id;
924: );
925:
926: IF (x_mode = 'R') THEN
927: x_request_id := fnd_global.conc_request_id;
928: x_program_id := fnd_global.conc_program_id;
929: x_program_application_id := fnd_global.prog_appl_id;
930: IF (x_request_id = -1) THEN
931: x_request_id := old_references.request_id;
932: x_program_id := old_references.program_id;
925:
926: IF (x_mode = 'R') THEN
927: x_request_id := fnd_global.conc_request_id;
928: x_program_id := fnd_global.conc_program_id;
929: x_program_application_id := fnd_global.prog_appl_id;
930: IF (x_request_id = -1) THEN
931: x_request_id := old_references.request_id;
932: x_program_id := old_references.program_id;
933: x_program_application_id := old_references.program_application_id;