289: if(X_MODE = 'I') then
290: X_LAST_UPDATED_BY := 1;
291: X_LAST_UPDATE_LOGIN := 0;
292: elsif (X_MODE = 'R') then
293: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
294: if X_LAST_UPDATED_BY is NULL then
295: X_LAST_UPDATED_BY := -1;
296: end if;
297: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
293: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
294: if X_LAST_UPDATED_BY is NULL then
295: X_LAST_UPDATED_BY := -1;
296: end if;
297: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
298: if X_LAST_UPDATE_LOGIN is NULL then
299: X_LAST_UPDATE_LOGIN := -1;
300: end if;
301:
298: if X_LAST_UPDATE_LOGIN is NULL then
299: X_LAST_UPDATE_LOGIN := -1;
300: end if;
301:
302: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
303: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
304: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
305: if (X_REQUEST_ID = -1) then
306: X_REQUEST_ID := NULL;
299: X_LAST_UPDATE_LOGIN := -1;
300: end if;
301:
302: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
303: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
304: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
305: if (X_REQUEST_ID = -1) then
306: X_REQUEST_ID := NULL;
307: X_PROGRAM_ID := NULL;
300: end if;
301:
302: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
303: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
304: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
305: if (X_REQUEST_ID = -1) then
306: X_REQUEST_ID := NULL;
307: X_PROGRAM_ID := NULL;
308: X_PROGRAM_APPLICATION_ID := NULL;
448: if(X_MODE = 'I') then
449: X_LAST_UPDATED_BY := 1;
450: X_LAST_UPDATE_LOGIN := 0;
451: elsif (X_MODE = 'R') then
452: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
453: if X_LAST_UPDATED_BY is NULL then
454: X_LAST_UPDATED_BY := -1;
455: end if;
456: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
452: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
453: if X_LAST_UPDATED_BY is NULL then
454: X_LAST_UPDATED_BY := -1;
455: end if;
456: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
457: if X_LAST_UPDATE_LOGIN is NULL then
458: X_LAST_UPDATE_LOGIN := -1;
459: end if;
460: else
478: x_last_update_login => X_LAST_UPDATE_LOGIN
479: );
480:
481: if(X_MODE='R') then
482: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
483: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
484: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
485: if (X_REQUEST_ID = -1) then
486: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
479: );
480:
481: if(X_MODE='R') then
482: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
483: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
484: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
485: if (X_REQUEST_ID = -1) then
486: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
487: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
480:
481: if(X_MODE='R') then
482: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
483: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
484: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
485: if (X_REQUEST_ID = -1) then
486: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
487: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
488: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;