292: if(X_MODE = 'I') then
293: X_LAST_UPDATED_BY := 1;
294: X_LAST_UPDATE_LOGIN := 0;
295: elsif (X_MODE = 'R') then
296: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
297: if X_LAST_UPDATED_BY is NULL then
298: X_LAST_UPDATED_BY := -1;
299: end if;
300: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
296: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
297: if X_LAST_UPDATED_BY is NULL then
298: X_LAST_UPDATED_BY := -1;
299: end if;
300: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
301: if X_LAST_UPDATE_LOGIN is NULL then
302: X_LAST_UPDATE_LOGIN := -1;
303: end if;
304: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
300: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
301: if X_LAST_UPDATE_LOGIN is NULL then
302: X_LAST_UPDATE_LOGIN := -1;
303: end if;
304: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
305: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
306: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
307: if (X_REQUEST_ID = -1) then
308: X_REQUEST_ID := NULL;
301: if X_LAST_UPDATE_LOGIN is NULL then
302: X_LAST_UPDATE_LOGIN := -1;
303: end if;
304: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
305: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
306: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
307: if (X_REQUEST_ID = -1) then
308: X_REQUEST_ID := NULL;
309: X_PROGRAM_ID := NULL;
302: X_LAST_UPDATE_LOGIN := -1;
303: end if;
304: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
305: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
306: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
307: if (X_REQUEST_ID = -1) then
308: X_REQUEST_ID := NULL;
309: X_PROGRAM_ID := NULL;
310: X_PROGRAM_APPLICATION_ID := NULL;
462: if(X_MODE = 'I') then
463: X_LAST_UPDATED_BY := 1;
464: X_LAST_UPDATE_LOGIN := 0;
465: elsif (X_MODE = 'R') then
466: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
467: if X_LAST_UPDATED_BY is NULL then
468: X_LAST_UPDATED_BY := -1;
469: end if;
470: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
466: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
467: if X_LAST_UPDATED_BY is NULL then
468: X_LAST_UPDATED_BY := -1;
469: end if;
470: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
471: if X_LAST_UPDATE_LOGIN is NULL then
472: X_LAST_UPDATE_LOGIN := -1;
473: end if;
474: else
496: x_last_update_login=>X_LAST_UPDATE_LOGIN,
497: x_uoo_id=>X_UOO_ID
498: );
499: if (X_MODE = 'R') then
500: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
501: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
502: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
503: if (X_REQUEST_ID = -1) then
504: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
497: x_uoo_id=>X_UOO_ID
498: );
499: if (X_MODE = 'R') then
500: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
501: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
502: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
503: if (X_REQUEST_ID = -1) then
504: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
505: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
498: );
499: if (X_MODE = 'R') then
500: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
501: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
502: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
503: if (X_REQUEST_ID = -1) then
504: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
505: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
506: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;