302: if(X_MODE = 'I') then
303: X_LAST_UPDATED_BY := 1;
304: X_LAST_UPDATE_LOGIN := 0;
305: elsif (X_MODE IN ('R', 'S')) then
306: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
307: if X_LAST_UPDATED_BY is NULL then
308: X_LAST_UPDATED_BY := -1;
309: end if;
310: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
306: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
307: if X_LAST_UPDATED_BY is NULL then
308: X_LAST_UPDATED_BY := -1;
309: end if;
310: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
311: if X_LAST_UPDATE_LOGIN is NULL then
312: X_LAST_UPDATE_LOGIN := -1;
313: end if;
314: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
310: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
311: if X_LAST_UPDATE_LOGIN is NULL then
312: X_LAST_UPDATE_LOGIN := -1;
313: end if;
314: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
315: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
316: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
317: if (X_REQUEST_ID = -1) then
318: X_REQUEST_ID := NULL;
311: if X_LAST_UPDATE_LOGIN is NULL then
312: X_LAST_UPDATE_LOGIN := -1;
313: end if;
314: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
315: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
316: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
317: if (X_REQUEST_ID = -1) then
318: X_REQUEST_ID := NULL;
319: X_PROGRAM_ID := NULL;
312: X_LAST_UPDATE_LOGIN := -1;
313: end if;
314: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
315: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
316: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
317: if (X_REQUEST_ID = -1) then
318: X_REQUEST_ID := NULL;
319: X_PROGRAM_ID := NULL;
320: X_PROGRAM_APPLICATION_ID := NULL;
492: if(X_MODE = 'I') then
493: X_LAST_UPDATED_BY := 1;
494: X_LAST_UPDATE_LOGIN := 0;
495: elsif (X_MODE IN ('R', 'S')) then
496: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
497: if X_LAST_UPDATED_BY is NULL then
498: X_LAST_UPDATED_BY := -1;
499: end if;
500: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
496: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
497: if X_LAST_UPDATED_BY is NULL then
498: X_LAST_UPDATED_BY := -1;
499: end if;
500: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
501: if X_LAST_UPDATE_LOGIN is NULL then
502: X_LAST_UPDATE_LOGIN := -1;
503: end if;
504: else
524: x_last_updated_by=>X_LAST_UPDATED_BY,
525: x_last_update_login=>X_LAST_UPDATE_LOGIN
526: );
527: if (X_MODE IN ('R', 'S')) then
528: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
529: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
530: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
531: if (X_REQUEST_ID = -1) then
532: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
525: x_last_update_login=>X_LAST_UPDATE_LOGIN
526: );
527: if (X_MODE IN ('R', 'S')) then
528: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
529: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
530: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
531: if (X_REQUEST_ID = -1) then
532: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
533: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
526: );
527: if (X_MODE IN ('R', 'S')) then
528: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
529: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
530: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
531: if (X_REQUEST_ID = -1) then
532: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
533: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
534: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;