388: IF (x_mode = 'I') THEN
389: x_last_updated_by := 1;
390: x_last_update_login := 0;
391: ELSIF (x_mode = 'R') THEN
392: x_last_updated_by := fnd_global.user_id;
393: IF (x_last_updated_by IS NULL) THEN
394: x_last_updated_by := -1;
395: END IF;
396: x_last_update_login := fnd_global.login_id;
392: x_last_updated_by := fnd_global.user_id;
393: IF (x_last_updated_by IS NULL) THEN
394: x_last_updated_by := -1;
395: END IF;
396: x_last_update_login := fnd_global.login_id;
397: IF (x_last_update_login IS NULL) THEN
398: x_last_update_login := -1;
399: END IF;
400: x_request_id := fnd_global.conc_request_id;
396: x_last_update_login := fnd_global.login_id;
397: IF (x_last_update_login IS NULL) THEN
398: x_last_update_login := -1;
399: END IF;
400: x_request_id := fnd_global.conc_request_id;
401: x_program_id := fnd_global.conc_program_id;
402: x_program_application_id := fnd_global.prog_appl_id;
403:
404: IF (x_request_id = -1) THEN
397: IF (x_last_update_login IS NULL) THEN
398: x_last_update_login := -1;
399: END IF;
400: x_request_id := fnd_global.conc_request_id;
401: x_program_id := fnd_global.conc_program_id;
402: x_program_application_id := fnd_global.prog_appl_id;
403:
404: IF (x_request_id = -1) THEN
405: x_request_id := NULL;
398: x_last_update_login := -1;
399: END IF;
400: x_request_id := fnd_global.conc_request_id;
401: x_program_id := fnd_global.conc_program_id;
402: x_program_application_id := fnd_global.prog_appl_id;
403:
404: IF (x_request_id = -1) THEN
405: x_request_id := NULL;
406: x_program_id := NULL;
615: IF (X_MODE = 'I') THEN
616: x_last_updated_by := 1;
617: x_last_update_login := 0;
618: ELSIF (x_mode = 'R') THEN
619: x_last_updated_by := fnd_global.user_id;
620: IF x_last_updated_by IS NULL THEN
621: x_last_updated_by := -1;
622: END IF;
623: x_last_update_login := fnd_global.login_id;
619: x_last_updated_by := fnd_global.user_id;
620: IF x_last_updated_by IS NULL THEN
621: x_last_updated_by := -1;
622: END IF;
623: x_last_update_login := fnd_global.login_id;
624: IF (x_last_update_login IS NULL) THEN
625: x_last_update_login := -1;
626: END IF;
627: ELSE
651: x_last_update_login => x_last_update_login
652: );
653:
654: IF (x_mode = 'R') THEN
655: x_request_id := fnd_global.conc_request_id;
656: x_program_id := fnd_global.conc_program_id;
657: x_program_application_id := fnd_global.prog_appl_id;
658: IF (x_request_id = -1) THEN
659: x_request_id := old_references.request_id;
652: );
653:
654: IF (x_mode = 'R') THEN
655: x_request_id := fnd_global.conc_request_id;
656: x_program_id := fnd_global.conc_program_id;
657: x_program_application_id := fnd_global.prog_appl_id;
658: IF (x_request_id = -1) THEN
659: x_request_id := old_references.request_id;
660: x_program_id := old_references.program_id;
653:
654: IF (x_mode = 'R') THEN
655: x_request_id := fnd_global.conc_request_id;
656: x_program_id := fnd_global.conc_program_id;
657: x_program_application_id := fnd_global.prog_appl_id;
658: IF (x_request_id = -1) THEN
659: x_request_id := old_references.request_id;
660: x_program_id := old_references.program_id;
661: x_program_application_id := old_references.program_application_id;