567: IF (x_mode = 'I') THEN
568: x_last_updated_by := 1;
569: x_last_update_login := 0;
570: ELSIF (x_mode = 'R') THEN
571: x_last_updated_by := fnd_global.user_id;
572: IF (x_last_updated_by IS NULL) THEN
573: x_last_updated_by := -1;
574: END IF;
575: x_last_update_login := fnd_global.login_id;
571: x_last_updated_by := fnd_global.user_id;
572: IF (x_last_updated_by IS NULL) THEN
573: x_last_updated_by := -1;
574: END IF;
575: x_last_update_login := fnd_global.login_id;
576: IF (x_last_update_login IS NULL) THEN
577: x_last_update_login := -1;
578: END IF;
579: x_request_id := fnd_global.conc_request_id;
575: x_last_update_login := fnd_global.login_id;
576: IF (x_last_update_login IS NULL) THEN
577: x_last_update_login := -1;
578: END IF;
579: x_request_id := fnd_global.conc_request_id;
580: x_program_id := fnd_global.conc_program_id;
581: x_program_application_id := fnd_global.prog_appl_id;
582:
583: IF (x_request_id = -1) THEN
576: IF (x_last_update_login IS NULL) THEN
577: x_last_update_login := -1;
578: END IF;
579: x_request_id := fnd_global.conc_request_id;
580: x_program_id := fnd_global.conc_program_id;
581: x_program_application_id := fnd_global.prog_appl_id;
582:
583: IF (x_request_id = -1) THEN
584: x_request_id := NULL;
577: x_last_update_login := -1;
578: END IF;
579: x_request_id := fnd_global.conc_request_id;
580: x_program_id := fnd_global.conc_program_id;
581: x_program_application_id := fnd_global.prog_appl_id;
582:
583: IF (x_request_id = -1) THEN
584: x_request_id := NULL;
585: x_program_id := NULL;
829: IF (X_MODE = 'I') THEN
830: x_last_updated_by := 1;
831: x_last_update_login := 0;
832: ELSIF (x_mode = 'R') THEN
833: x_last_updated_by := fnd_global.user_id;
834: IF x_last_updated_by IS NULL THEN
835: x_last_updated_by := -1;
836: END IF;
837: x_last_update_login := fnd_global.login_id;
833: x_last_updated_by := fnd_global.user_id;
834: IF x_last_updated_by IS NULL THEN
835: x_last_updated_by := -1;
836: END IF;
837: x_last_update_login := fnd_global.login_id;
838: IF (x_last_update_login IS NULL) THEN
839: x_last_update_login := -1;
840: END IF;
841: ELSE
871: x_last_update_login => x_last_update_login
872: );
873:
874: IF (x_mode = 'R') THEN
875: x_request_id := fnd_global.conc_request_id;
876: x_program_id := fnd_global.conc_program_id;
877: x_program_application_id := fnd_global.prog_appl_id;
878: IF (x_request_id = -1) THEN
879: x_request_id := old_references.request_id;
872: );
873:
874: IF (x_mode = 'R') THEN
875: x_request_id := fnd_global.conc_request_id;
876: x_program_id := fnd_global.conc_program_id;
877: x_program_application_id := fnd_global.prog_appl_id;
878: IF (x_request_id = -1) THEN
879: x_request_id := old_references.request_id;
880: x_program_id := old_references.program_id;
873:
874: IF (x_mode = 'R') THEN
875: x_request_id := fnd_global.conc_request_id;
876: x_program_id := fnd_global.conc_program_id;
877: x_program_application_id := fnd_global.prog_appl_id;
878: IF (x_request_id = -1) THEN
879: x_request_id := old_references.request_id;
880: x_program_id := old_references.program_id;
881: x_program_application_id := old_references.program_application_id;