193: if(X_MODE = 'I') then
194: X_LAST_UPDATED_BY := 1;
195: X_LAST_UPDATE_LOGIN := 0;
196: elsif (X_MODE = 'R') then
197: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
198: if X_LAST_UPDATED_BY is NULL then
199: X_LAST_UPDATED_BY := -1;
200: end if;
201: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
197: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
198: if X_LAST_UPDATED_BY is NULL then
199: X_LAST_UPDATED_BY := -1;
200: end if;
201: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
202: if X_LAST_UPDATE_LOGIN is NULL then
203: X_LAST_UPDATE_LOGIN := -1;
204: end if;
205: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
201: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
202: if X_LAST_UPDATE_LOGIN is NULL then
203: X_LAST_UPDATE_LOGIN := -1;
204: end if;
205: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
206: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
207: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
208: if (X_REQUEST_ID = -1) then
209: X_REQUEST_ID := NULL;
202: if X_LAST_UPDATE_LOGIN is NULL then
203: X_LAST_UPDATE_LOGIN := -1;
204: end if;
205: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
206: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
207: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
208: if (X_REQUEST_ID = -1) then
209: X_REQUEST_ID := NULL;
210: X_PROGRAM_ID := NULL;
203: X_LAST_UPDATE_LOGIN := -1;
204: end if;
205: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
206: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
207: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
208: if (X_REQUEST_ID = -1) then
209: X_REQUEST_ID := NULL;
210: X_PROGRAM_ID := NULL;
211: X_PROGRAM_APPLICATION_ID := NULL;