665: if(X_MODE = 'I') then
666: X_LAST_UPDATED_BY := 1;
667: X_LAST_UPDATE_LOGIN := 0;
668: elsif (X_MODE = 'R') then
669: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
670: if X_LAST_UPDATED_BY is NULL then
671: X_LAST_UPDATED_BY := -1;
672: end if;
673: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
669: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
670: if X_LAST_UPDATED_BY is NULL then
671: X_LAST_UPDATED_BY := -1;
672: end if;
673: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
674: if X_LAST_UPDATE_LOGIN is NULL then
675: X_LAST_UPDATE_LOGIN := -1;
676: end if;
677: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
673: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
674: if X_LAST_UPDATE_LOGIN is NULL then
675: X_LAST_UPDATE_LOGIN := -1;
676: end if;
677: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
678: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
679: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
680: if (X_REQUEST_ID = -1) then
681: X_REQUEST_ID := NULL;
674: if X_LAST_UPDATE_LOGIN is NULL then
675: X_LAST_UPDATE_LOGIN := -1;
676: end if;
677: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
678: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
679: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
680: if (X_REQUEST_ID = -1) then
681: X_REQUEST_ID := NULL;
682: X_PROGRAM_ID := NULL;
675: X_LAST_UPDATE_LOGIN := -1;
676: end if;
677: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
678: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
679: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
680: if (X_REQUEST_ID = -1) then
681: X_REQUEST_ID := NULL;
682: X_PROGRAM_ID := NULL;
683: X_PROGRAM_APPLICATION_ID := NULL;
846: if(X_MODE = 'I') then
847: X_LAST_UPDATED_BY := 1;
848: X_LAST_UPDATE_LOGIN := 0;
849: elsif (X_MODE = 'R') then
850: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
851: if X_LAST_UPDATED_BY is NULL then
852: X_LAST_UPDATED_BY := -1;
853: end if;
854: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
850: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
851: if X_LAST_UPDATED_BY is NULL then
852: X_LAST_UPDATED_BY := -1;
853: end if;
854: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
855: if X_LAST_UPDATE_LOGIN is NULL then
856: X_LAST_UPDATE_LOGIN := -1;
857: end if;
858: else
860: IGS_GE_MSG_STACK.ADD;
861: app_exception.raise_exception;
862: end if;
863: if (X_MODE = 'R') then
864: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
865: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
866: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
867: if (X_REQUEST_ID = -1) then
868: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
861: app_exception.raise_exception;
862: end if;
863: if (X_MODE = 'R') then
864: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
865: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
866: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
867: if (X_REQUEST_ID = -1) then
868: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
869: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
862: end if;
863: if (X_MODE = 'R') then
864: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
865: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
866: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
867: if (X_REQUEST_ID = -1) then
868: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
869: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
870: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;