364: if(X_MODE = 'I') then
365: X_LAST_UPDATED_BY := 1;
366: X_LAST_UPDATE_LOGIN := 0;
367: elsif (X_MODE = 'R') then
368: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
369: if X_LAST_UPDATED_BY is NULL then
370: X_LAST_UPDATED_BY := -1;
371: end if;
372: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
368: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
369: if X_LAST_UPDATED_BY is NULL then
370: X_LAST_UPDATED_BY := -1;
371: end if;
372: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
373: if X_LAST_UPDATE_LOGIN is NULL then
374: X_LAST_UPDATE_LOGIN := -1;
375: end if;
376: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
372: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
373: if X_LAST_UPDATE_LOGIN is NULL then
374: X_LAST_UPDATE_LOGIN := -1;
375: end if;
376: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
377: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
378: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
379: if (X_REQUEST_ID = -1) then
380: X_REQUEST_ID := NULL;
373: if X_LAST_UPDATE_LOGIN is NULL then
374: X_LAST_UPDATE_LOGIN := -1;
375: end if;
376: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
377: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
378: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
379: if (X_REQUEST_ID = -1) then
380: X_REQUEST_ID := NULL;
381: X_PROGRAM_ID := NULL;
374: X_LAST_UPDATE_LOGIN := -1;
375: end if;
376: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
377: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
378: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
379: if (X_REQUEST_ID = -1) then
380: X_REQUEST_ID := NULL;
381: X_PROGRAM_ID := NULL;
382: X_PROGRAM_APPLICATION_ID := NULL;
515: if(X_MODE = 'I') then
516: X_LAST_UPDATED_BY := 1;
517: X_LAST_UPDATE_LOGIN := 0;
518: elsif (X_MODE = 'R') then
519: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
520: if X_LAST_UPDATED_BY is NULL then
521: X_LAST_UPDATED_BY := -1;
522: end if;
523: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
519: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
520: if X_LAST_UPDATED_BY is NULL then
521: X_LAST_UPDATED_BY := -1;
522: end if;
523: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
524: if X_LAST_UPDATE_LOGIN is NULL then
525: X_LAST_UPDATE_LOGIN := -1;
526: end if;
527: else
545: );
546:
547:
548: if (X_MODE = 'R') then
549: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
550: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
551: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
552: if (X_REQUEST_ID = -1) then
553: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
546:
547:
548: if (X_MODE = 'R') then
549: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
550: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
551: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
552: if (X_REQUEST_ID = -1) then
553: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
554: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
547:
548: if (X_MODE = 'R') then
549: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
550: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
551: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
552: if (X_REQUEST_ID = -1) then
553: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
554: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
555: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;