559: IF (x_mode = 'I') THEN
560: x_last_updated_by := 1;
561: x_last_update_login := 0;
562: ELSIF (x_mode = 'R') THEN
563: x_last_updated_by := fnd_global.user_id;
564: IF (x_last_updated_by IS NULL) THEN
565: x_last_updated_by := -1;
566: END IF;
567: x_last_update_login := fnd_global.login_id;
563: x_last_updated_by := fnd_global.user_id;
564: IF (x_last_updated_by IS NULL) THEN
565: x_last_updated_by := -1;
566: END IF;
567: x_last_update_login := fnd_global.login_id;
568: IF (x_last_update_login IS NULL) THEN
569: x_last_update_login := -1;
570: END IF;
571: x_request_id := fnd_global.conc_request_id;
567: x_last_update_login := fnd_global.login_id;
568: IF (x_last_update_login IS NULL) THEN
569: x_last_update_login := -1;
570: END IF;
571: x_request_id := fnd_global.conc_request_id;
572: x_program_id := fnd_global.conc_program_id;
573: x_program_application_id := fnd_global.prog_appl_id;
574:
575: IF (x_request_id = -1) THEN
568: IF (x_last_update_login IS NULL) THEN
569: x_last_update_login := -1;
570: END IF;
571: x_request_id := fnd_global.conc_request_id;
572: x_program_id := fnd_global.conc_program_id;
573: x_program_application_id := fnd_global.prog_appl_id;
574:
575: IF (x_request_id = -1) THEN
576: x_request_id := NULL;
569: x_last_update_login := -1;
570: END IF;
571: x_request_id := fnd_global.conc_request_id;
572: x_program_id := fnd_global.conc_program_id;
573: x_program_application_id := fnd_global.prog_appl_id;
574:
575: IF (x_request_id = -1) THEN
576: x_request_id := NULL;
577: x_program_id := NULL;
750: IF (X_MODE = 'I') THEN
751: x_last_updated_by := 1;
752: x_last_update_login := 0;
753: ELSIF (x_mode = 'R') THEN
754: x_last_updated_by := fnd_global.user_id;
755: IF x_last_updated_by IS NULL THEN
756: x_last_updated_by := -1;
757: END IF;
758: x_last_update_login := fnd_global.login_id;
754: x_last_updated_by := fnd_global.user_id;
755: IF x_last_updated_by IS NULL THEN
756: x_last_updated_by := -1;
757: END IF;
758: x_last_update_login := fnd_global.login_id;
759: IF (x_last_update_login IS NULL) THEN
760: x_last_update_login := -1;
761: END IF;
762: ELSE
783: x_last_update_login => x_last_update_login
784: );
785:
786: IF (x_mode = 'R') THEN
787: x_request_id := fnd_global.conc_request_id;
788: x_program_id := fnd_global.conc_program_id;
789: x_program_application_id := fnd_global.prog_appl_id;
790: IF (x_request_id = -1) THEN
791: x_request_id := old_references.request_id;
784: );
785:
786: IF (x_mode = 'R') THEN
787: x_request_id := fnd_global.conc_request_id;
788: x_program_id := fnd_global.conc_program_id;
789: x_program_application_id := fnd_global.prog_appl_id;
790: IF (x_request_id = -1) THEN
791: x_request_id := old_references.request_id;
792: x_program_id := old_references.program_id;
785:
786: IF (x_mode = 'R') THEN
787: x_request_id := fnd_global.conc_request_id;
788: x_program_id := fnd_global.conc_program_id;
789: x_program_application_id := fnd_global.prog_appl_id;
790: IF (x_request_id = -1) THEN
791: x_request_id := old_references.request_id;
792: x_program_id := old_references.program_id;
793: x_program_application_id := old_references.program_application_id;