369: if(X_MODE = 'I') then
370: X_LAST_UPDATED_BY := 1;
371: X_LAST_UPDATE_LOGIN := 0;
372: elsif (X_MODE = 'R') then
373: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
374: if X_LAST_UPDATED_BY is NULL then
375: X_LAST_UPDATED_BY := -1;
376: end if;
377: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
373: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
374: if X_LAST_UPDATED_BY is NULL then
375: X_LAST_UPDATED_BY := -1;
376: end if;
377: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
378: if X_LAST_UPDATE_LOGIN is NULL then
379: X_LAST_UPDATE_LOGIN := -1;
380: end if;
381: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
377: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
378: if X_LAST_UPDATE_LOGIN is NULL then
379: X_LAST_UPDATE_LOGIN := -1;
380: end if;
381: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
382: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
383:
384: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
385: if (X_REQUEST_ID = -1) then
378: if X_LAST_UPDATE_LOGIN is NULL then
379: X_LAST_UPDATE_LOGIN := -1;
380: end if;
381: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
382: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
383:
384: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
385: if (X_REQUEST_ID = -1) then
386: X_REQUEST_ID := NULL;
380: end if;
381: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
382: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
383:
384: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
385: if (X_REQUEST_ID = -1) then
386: X_REQUEST_ID := NULL;
387: X_PROGRAM_ID := NULL;
388: X_PROGRAM_APPLICATION_ID := NULL;
517: if(X_MODE = 'I') then
518: X_LAST_UPDATED_BY := 1;
519: X_LAST_UPDATE_LOGIN := 0;
520: elsif (X_MODE = 'R') then
521: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
522: if X_LAST_UPDATED_BY is NULL then
523: X_LAST_UPDATED_BY := -1;
524: end if;
525: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
521: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
522: if X_LAST_UPDATED_BY is NULL then
523: X_LAST_UPDATED_BY := -1;
524: end if;
525: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
526: if X_LAST_UPDATE_LOGIN is NULL then
527: X_LAST_UPDATE_LOGIN := -1;
528: end if;
529: else
547: x_last_update_login=>X_LAST_UPDATE_LOGIN
548: );
549:
550: if (X_MODE = 'R') then
551: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
552: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
553: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
554: if (X_REQUEST_ID = -1) then
555: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
548: );
549:
550: if (X_MODE = 'R') then
551: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
552: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
553: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
554: if (X_REQUEST_ID = -1) then
555: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
556: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
549:
550: if (X_MODE = 'R') then
551: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
552: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
553: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
554: if (X_REQUEST_ID = -1) then
555: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
556: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
557: X_PROGRAM_APPLICATION_ID :=