405: IF (x_mode = 'I') THEN
406: x_last_updated_by := 1;
407: x_last_update_login := 0;
408: ELSIF (x_mode = 'R') THEN
409: x_last_updated_by := fnd_global.user_id;
410: IF (x_last_updated_by IS NULL) THEN
411: x_last_updated_by := -1;
412: END IF;
413: x_last_update_login := fnd_global.login_id;
409: x_last_updated_by := fnd_global.user_id;
410: IF (x_last_updated_by IS NULL) THEN
411: x_last_updated_by := -1;
412: END IF;
413: x_last_update_login := fnd_global.login_id;
414: IF (x_last_update_login IS NULL) THEN
415: x_last_update_login := -1;
416: END IF;
417: x_request_id := fnd_global.conc_request_id;
413: x_last_update_login := fnd_global.login_id;
414: IF (x_last_update_login IS NULL) THEN
415: x_last_update_login := -1;
416: END IF;
417: x_request_id := fnd_global.conc_request_id;
418: x_program_id := fnd_global.conc_program_id;
419: x_program_application_id := fnd_global.prog_appl_id;
420:
421: IF (x_request_id = -1) THEN
414: IF (x_last_update_login IS NULL) THEN
415: x_last_update_login := -1;
416: END IF;
417: x_request_id := fnd_global.conc_request_id;
418: x_program_id := fnd_global.conc_program_id;
419: x_program_application_id := fnd_global.prog_appl_id;
420:
421: IF (x_request_id = -1) THEN
422: x_request_id := NULL;
415: x_last_update_login := -1;
416: END IF;
417: x_request_id := fnd_global.conc_request_id;
418: x_program_id := fnd_global.conc_program_id;
419: x_program_application_id := fnd_global.prog_appl_id;
420:
421: IF (x_request_id = -1) THEN
422: x_request_id := NULL;
423: x_program_id := NULL;
599: IF (X_MODE = 'I') THEN
600: x_last_updated_by := 1;
601: x_last_update_login := 0;
602: ELSIF (x_mode = 'R') THEN
603: x_last_updated_by := fnd_global.user_id;
604: IF x_last_updated_by IS NULL THEN
605: x_last_updated_by := -1;
606: END IF;
607: x_last_update_login := fnd_global.login_id;
603: x_last_updated_by := fnd_global.user_id;
604: IF x_last_updated_by IS NULL THEN
605: x_last_updated_by := -1;
606: END IF;
607: x_last_update_login := fnd_global.login_id;
608: IF (x_last_update_login IS NULL) THEN
609: x_last_update_login := -1;
610: END IF;
611: ELSE
633: x_last_update_login => x_last_update_login
634: );
635:
636: IF (x_mode = 'R') THEN
637: x_request_id := fnd_global.conc_request_id;
638: x_program_id := fnd_global.conc_program_id;
639: x_program_application_id := fnd_global.prog_appl_id;
640: IF (x_request_id = -1) THEN
641: x_request_id := old_references.request_id;
634: );
635:
636: IF (x_mode = 'R') THEN
637: x_request_id := fnd_global.conc_request_id;
638: x_program_id := fnd_global.conc_program_id;
639: x_program_application_id := fnd_global.prog_appl_id;
640: IF (x_request_id = -1) THEN
641: x_request_id := old_references.request_id;
642: x_program_id := old_references.program_id;
635:
636: IF (x_mode = 'R') THEN
637: x_request_id := fnd_global.conc_request_id;
638: x_program_id := fnd_global.conc_program_id;
639: x_program_application_id := fnd_global.prog_appl_id;
640: IF (x_request_id = -1) THEN
641: x_request_id := old_references.request_id;
642: x_program_id := old_references.program_id;
643: x_program_application_id := old_references.program_application_id;