413: IF (x_mode = 'I') THEN
414: x_last_updated_by := 1;
415: x_last_update_login := 0;
416: ELSIF (x_mode = 'R') THEN
417: x_last_updated_by := fnd_global.user_id;
418: IF (x_last_updated_by IS NULL) THEN
419: x_last_updated_by := -1;
420: END IF;
421: x_last_update_login := fnd_global.login_id;
417: x_last_updated_by := fnd_global.user_id;
418: IF (x_last_updated_by IS NULL) THEN
419: x_last_updated_by := -1;
420: END IF;
421: x_last_update_login := fnd_global.login_id;
422: IF (x_last_update_login IS NULL) THEN
423: x_last_update_login := -1;
424: END IF;
425: x_request_id := fnd_global.conc_request_id;
421: x_last_update_login := fnd_global.login_id;
422: IF (x_last_update_login IS NULL) THEN
423: x_last_update_login := -1;
424: END IF;
425: x_request_id := fnd_global.conc_request_id;
426: x_program_id := fnd_global.conc_program_id;
427: x_program_application_id := fnd_global.prog_appl_id;
428:
429: IF (x_request_id = -1) THEN
422: IF (x_last_update_login IS NULL) THEN
423: x_last_update_login := -1;
424: END IF;
425: x_request_id := fnd_global.conc_request_id;
426: x_program_id := fnd_global.conc_program_id;
427: x_program_application_id := fnd_global.prog_appl_id;
428:
429: IF (x_request_id = -1) THEN
430: x_request_id := NULL;
423: x_last_update_login := -1;
424: END IF;
425: x_request_id := fnd_global.conc_request_id;
426: x_program_id := fnd_global.conc_program_id;
427: x_program_application_id := fnd_global.prog_appl_id;
428:
429: IF (x_request_id = -1) THEN
430: x_request_id := NULL;
431: x_program_id := NULL;
620: IF (X_MODE = 'I') THEN
621: x_last_updated_by := 1;
622: x_last_update_login := 0;
623: ELSIF (x_mode = 'R') THEN
624: x_last_updated_by := fnd_global.user_id;
625: IF x_last_updated_by IS NULL THEN
626: x_last_updated_by := -1;
627: END IF;
628: x_last_update_login := fnd_global.login_id;
624: x_last_updated_by := fnd_global.user_id;
625: IF x_last_updated_by IS NULL THEN
626: x_last_updated_by := -1;
627: END IF;
628: x_last_update_login := fnd_global.login_id;
629: IF (x_last_update_login IS NULL) THEN
630: x_last_update_login := -1;
631: END IF;
632: ELSE
656: x_last_update_login => x_last_update_login
657: );
658:
659: IF (x_mode = 'R') THEN
660: x_request_id := fnd_global.conc_request_id;
661: x_program_id := fnd_global.conc_program_id;
662: x_program_application_id := fnd_global.prog_appl_id;
663: IF (x_request_id = -1) THEN
664: x_request_id := old_references.request_id;
657: );
658:
659: IF (x_mode = 'R') THEN
660: x_request_id := fnd_global.conc_request_id;
661: x_program_id := fnd_global.conc_program_id;
662: x_program_application_id := fnd_global.prog_appl_id;
663: IF (x_request_id = -1) THEN
664: x_request_id := old_references.request_id;
665: x_program_id := old_references.program_id;
658:
659: IF (x_mode = 'R') THEN
660: x_request_id := fnd_global.conc_request_id;
661: x_program_id := fnd_global.conc_program_id;
662: x_program_application_id := fnd_global.prog_appl_id;
663: IF (x_request_id = -1) THEN
664: x_request_id := old_references.request_id;
665: x_program_id := old_references.program_id;
666: x_program_application_id := old_references.program_application_id;