540: IF (x_mode = 'I') THEN
541: x_last_updated_by := 1;
542: x_last_update_login := 0;
543: ELSIF (x_mode = 'R') THEN
544: x_last_updated_by := fnd_global.user_id;
545: IF (x_last_updated_by IS NULL) THEN
546: x_last_updated_by := -1;
547: END IF;
548: x_last_update_login := fnd_global.login_id;
544: x_last_updated_by := fnd_global.user_id;
545: IF (x_last_updated_by IS NULL) THEN
546: x_last_updated_by := -1;
547: END IF;
548: x_last_update_login := fnd_global.login_id;
549: IF (x_last_update_login IS NULL) THEN
550: x_last_update_login := -1;
551: END IF;
552: x_request_id := fnd_global.conc_request_id;
548: x_last_update_login := fnd_global.login_id;
549: IF (x_last_update_login IS NULL) THEN
550: x_last_update_login := -1;
551: END IF;
552: x_request_id := fnd_global.conc_request_id;
553: x_program_id := fnd_global.conc_program_id;
554: x_program_application_id := fnd_global.prog_appl_id;
555:
556: IF (x_request_id = -1) THEN
549: IF (x_last_update_login IS NULL) THEN
550: x_last_update_login := -1;
551: END IF;
552: x_request_id := fnd_global.conc_request_id;
553: x_program_id := fnd_global.conc_program_id;
554: x_program_application_id := fnd_global.prog_appl_id;
555:
556: IF (x_request_id = -1) THEN
557: x_request_id := NULL;
550: x_last_update_login := -1;
551: END IF;
552: x_request_id := fnd_global.conc_request_id;
553: x_program_id := fnd_global.conc_program_id;
554: x_program_application_id := fnd_global.prog_appl_id;
555:
556: IF (x_request_id = -1) THEN
557: x_request_id := NULL;
558: x_program_id := NULL;
744: IF (X_MODE = 'I') THEN
745: x_last_updated_by := 1;
746: x_last_update_login := 0;
747: ELSIF (x_mode = 'R') THEN
748: x_last_updated_by := fnd_global.user_id;
749: IF x_last_updated_by IS NULL THEN
750: x_last_updated_by := -1;
751: END IF;
752: x_last_update_login := fnd_global.login_id;
748: x_last_updated_by := fnd_global.user_id;
749: IF x_last_updated_by IS NULL THEN
750: x_last_updated_by := -1;
751: END IF;
752: x_last_update_login := fnd_global.login_id;
753: IF (x_last_update_login IS NULL) THEN
754: x_last_update_login := -1;
755: END IF;
756: ELSE
779: x_last_update_login => x_last_update_login
780: );
781:
782: IF (x_mode = 'R') THEN
783: x_request_id := fnd_global.conc_request_id;
784: x_program_id := fnd_global.conc_program_id;
785: x_program_application_id := fnd_global.prog_appl_id;
786: IF (x_request_id = -1) THEN
787: x_request_id := old_references.request_id;
780: );
781:
782: IF (x_mode = 'R') THEN
783: x_request_id := fnd_global.conc_request_id;
784: x_program_id := fnd_global.conc_program_id;
785: x_program_application_id := fnd_global.prog_appl_id;
786: IF (x_request_id = -1) THEN
787: x_request_id := old_references.request_id;
788: x_program_id := old_references.program_id;
781:
782: IF (x_mode = 'R') THEN
783: x_request_id := fnd_global.conc_request_id;
784: x_program_id := fnd_global.conc_program_id;
785: x_program_application_id := fnd_global.prog_appl_id;
786: IF (x_request_id = -1) THEN
787: x_request_id := old_references.request_id;
788: x_program_id := old_references.program_id;
789: x_program_application_id := old_references.program_application_id;