254: if(X_MODE = 'I') then
255: X_LAST_UPDATED_BY := 1;
256: X_LAST_UPDATE_LOGIN := 0;
257: elsif (X_MODE = 'R') then
258: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
259: if X_LAST_UPDATED_BY is NULL then
260: X_LAST_UPDATED_BY := -1;
261: end if;
262: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
258: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
259: if X_LAST_UPDATED_BY is NULL then
260: X_LAST_UPDATED_BY := -1;
261: end if;
262: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
263: if X_LAST_UPDATE_LOGIN is NULL then
264: X_LAST_UPDATE_LOGIN := -1;
265: end if;
266: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
262: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
263: if X_LAST_UPDATE_LOGIN is NULL then
264: X_LAST_UPDATE_LOGIN := -1;
265: end if;
266: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
267: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
268: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
269: if(X_REQUEST_ID = -1) then
270: X_REQUEST_ID := NULL;
263: if X_LAST_UPDATE_LOGIN is NULL then
264: X_LAST_UPDATE_LOGIN := -1;
265: end if;
266: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
267: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
268: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
269: if(X_REQUEST_ID = -1) then
270: X_REQUEST_ID := NULL;
271: X_PROGRAM_ID := NULL;
264: X_LAST_UPDATE_LOGIN := -1;
265: end if;
266: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
267: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
268: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
269: if(X_REQUEST_ID = -1) then
270: X_REQUEST_ID := NULL;
271: X_PROGRAM_ID := NULL;
272: X_PROGRAM_APPLICATION_ID := NULL;
391: if(X_MODE = 'I') then
392: X_LAST_UPDATED_BY := 1;
393: X_LAST_UPDATE_LOGIN := 0;
394: elsif (X_MODE = 'R') then
395: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
396: if X_LAST_UPDATED_BY is NULL then
397: X_LAST_UPDATED_BY := -1;
398: end if;
399: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
395: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
396: if X_LAST_UPDATED_BY is NULL then
397: X_LAST_UPDATED_BY := -1;
398: end if;
399: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
400: if X_LAST_UPDATE_LOGIN is NULL then
401: X_LAST_UPDATE_LOGIN := -1;
402: end if;
403: else
417: x_last_updated_by => X_LAST_UPDATED_BY,
418: x_last_update_login => X_LAST_UPDATE_LOGIN
419: );
420: if (X_MODE = 'R') then
421: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
422: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
423: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
424: if(X_REQUEST_ID = -1) then
425: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
418: x_last_update_login => X_LAST_UPDATE_LOGIN
419: );
420: if (X_MODE = 'R') then
421: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
422: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
423: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
424: if(X_REQUEST_ID = -1) then
425: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
426: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
419: );
420: if (X_MODE = 'R') then
421: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
422: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
423: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
424: if(X_REQUEST_ID = -1) then
425: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
426: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
427: X_PROGRAM_APPLICATION_ID :=