419: if(X_MODE = 'I') then
420: X_LAST_UPDATED_BY := 1;
421: X_LAST_UPDATE_LOGIN := 0;
422: elsif (X_MODE = 'R') then
423: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
424: if X_LAST_UPDATED_BY is NULL then
425: X_LAST_UPDATED_BY := -1;
426: end if;
427: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
423: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
424: if X_LAST_UPDATED_BY is NULL then
425: X_LAST_UPDATED_BY := -1;
426: end if;
427: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
428: if X_LAST_UPDATE_LOGIN is NULL then
429: X_LAST_UPDATE_LOGIN := -1;
430: end if;
431:
428: if X_LAST_UPDATE_LOGIN is NULL then
429: X_LAST_UPDATE_LOGIN := -1;
430: end if;
431:
432: x_request_id := fnd_global.conc_request_id;
433: x_program_id := fnd_global.conc_program_id;
434: x_program_application_id := fnd_global.prog_appl_id;
435:
436: if (x_request_id = -1) then
429: X_LAST_UPDATE_LOGIN := -1;
430: end if;
431:
432: x_request_id := fnd_global.conc_request_id;
433: x_program_id := fnd_global.conc_program_id;
434: x_program_application_id := fnd_global.prog_appl_id;
435:
436: if (x_request_id = -1) then
437: x_request_id := NULL;
430: end if;
431:
432: x_request_id := fnd_global.conc_request_id;
433: x_program_id := fnd_global.conc_program_id;
434: x_program_application_id := fnd_global.prog_appl_id;
435:
436: if (x_request_id = -1) then
437: x_request_id := NULL;
438: x_program_id := NULL;
835: if(X_MODE = 'I') then
836: X_LAST_UPDATED_BY := 1;
837: X_LAST_UPDATE_LOGIN := 0;
838: elsif (X_MODE = 'R') then
839: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
840: if X_LAST_UPDATED_BY is NULL then
841: X_LAST_UPDATED_BY := -1;
842: end if;
843: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
839: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
840: if X_LAST_UPDATED_BY is NULL then
841: X_LAST_UPDATED_BY := -1;
842: end if;
843: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
844: if X_LAST_UPDATE_LOGIN is NULL then
845: X_LAST_UPDATE_LOGIN := -1;
846: end if;
847: else
901: );
902:
903:
904: if (X_MODE = 'R') then
905: x_request_id := fnd_global.conc_request_id;
906: x_program_id := fnd_global.conc_program_id;
907: x_program_application_id := fnd_global.prog_appl_id;
908:
909: if (x_request_id = -1) then
902:
903:
904: if (X_MODE = 'R') then
905: x_request_id := fnd_global.conc_request_id;
906: x_program_id := fnd_global.conc_program_id;
907: x_program_application_id := fnd_global.prog_appl_id;
908:
909: if (x_request_id = -1) then
910: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
903:
904: if (X_MODE = 'R') then
905: x_request_id := fnd_global.conc_request_id;
906: x_program_id := fnd_global.conc_program_id;
907: x_program_application_id := fnd_global.prog_appl_id;
908:
909: if (x_request_id = -1) then
910: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
911: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;