539: IF (x_mode = 'I') THEN
540: x_last_updated_by := 1;
541: x_last_update_login := 0;
542: ELSIF (x_mode = 'R') THEN
543: x_last_updated_by := fnd_global.user_id;
544: IF (x_last_updated_by IS NULL) THEN
545: x_last_updated_by := -1;
546: END IF;
547: x_last_update_login := fnd_global.login_id;
543: x_last_updated_by := fnd_global.user_id;
544: IF (x_last_updated_by IS NULL) THEN
545: x_last_updated_by := -1;
546: END IF;
547: x_last_update_login := fnd_global.login_id;
548: IF (x_last_update_login IS NULL) THEN
549: x_last_update_login := -1;
550: END IF;
551: x_request_id := fnd_global.conc_request_id;
547: x_last_update_login := fnd_global.login_id;
548: IF (x_last_update_login IS NULL) THEN
549: x_last_update_login := -1;
550: END IF;
551: x_request_id := fnd_global.conc_request_id;
552: x_program_id := fnd_global.conc_program_id;
553: x_program_application_id := fnd_global.prog_appl_id;
554:
555: IF (x_request_id = -1) THEN
548: IF (x_last_update_login IS NULL) THEN
549: x_last_update_login := -1;
550: END IF;
551: x_request_id := fnd_global.conc_request_id;
552: x_program_id := fnd_global.conc_program_id;
553: x_program_application_id := fnd_global.prog_appl_id;
554:
555: IF (x_request_id = -1) THEN
556: x_request_id := NULL;
549: x_last_update_login := -1;
550: END IF;
551: x_request_id := fnd_global.conc_request_id;
552: x_program_id := fnd_global.conc_program_id;
553: x_program_application_id := fnd_global.prog_appl_id;
554:
555: IF (x_request_id = -1) THEN
556: x_request_id := NULL;
557: x_program_id := NULL;
1021: IF (X_MODE = 'I') THEN
1022: x_last_updated_by := 1;
1023: x_last_update_login := 0;
1024: ELSIF (x_mode = 'R') THEN
1025: x_last_updated_by := fnd_global.user_id;
1026: IF x_last_updated_by IS NULL THEN
1027: x_last_updated_by := -1;
1028: END IF;
1029: x_last_update_login := fnd_global.login_id;
1025: x_last_updated_by := fnd_global.user_id;
1026: IF x_last_updated_by IS NULL THEN
1027: x_last_updated_by := -1;
1028: END IF;
1029: x_last_update_login := fnd_global.login_id;
1030: IF (x_last_update_login IS NULL) THEN
1031: x_last_update_login := -1;
1032: END IF;
1033: ELSE
1093: x_last_update_login => x_last_update_login
1094: );
1095:
1096: IF (x_mode = 'R') THEN
1097: x_request_id := fnd_global.conc_request_id;
1098: x_program_id := fnd_global.conc_program_id;
1099: x_program_application_id := fnd_global.prog_appl_id;
1100: IF (x_request_id = -1) THEN
1101: x_request_id := old_references.request_id;
1094: );
1095:
1096: IF (x_mode = 'R') THEN
1097: x_request_id := fnd_global.conc_request_id;
1098: x_program_id := fnd_global.conc_program_id;
1099: x_program_application_id := fnd_global.prog_appl_id;
1100: IF (x_request_id = -1) THEN
1101: x_request_id := old_references.request_id;
1102: x_program_id := old_references.program_id;
1095:
1096: IF (x_mode = 'R') THEN
1097: x_request_id := fnd_global.conc_request_id;
1098: x_program_id := fnd_global.conc_program_id;
1099: x_program_application_id := fnd_global.prog_appl_id;
1100: IF (x_request_id = -1) THEN
1101: x_request_id := old_references.request_id;
1102: x_program_id := old_references.program_id;
1103: x_program_application_id := old_references.program_application_id;