531: if(X_MODE = 'I') then
532: X_LAST_UPDATED_BY := 1;
533: X_LAST_UPDATE_LOGIN := 0;
534: elsif (X_MODE = 'R') then
535: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
536: if X_LAST_UPDATED_BY is NULL then
537: X_LAST_UPDATED_BY := -1;
538: end if;
539: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
535: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
536: if X_LAST_UPDATED_BY is NULL then
537: X_LAST_UPDATED_BY := -1;
538: end if;
539: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
540: if X_LAST_UPDATE_LOGIN is NULL then
541: X_LAST_UPDATE_LOGIN := -1;
542: end if;
543: X_REQUEST_ID:=FND_GLOBAL.CONC_REQUEST_ID;
539: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
540: if X_LAST_UPDATE_LOGIN is NULL then
541: X_LAST_UPDATE_LOGIN := -1;
542: end if;
543: X_REQUEST_ID:=FND_GLOBAL.CONC_REQUEST_ID;
544: X_PROGRAM_ID:=FND_GLOBAL.CONC_PROGRAM_ID;
545: X_PROGRAM_APPLICATION_ID:=FND_GLOBAL.PROG_APPL_ID;
546: if (X_REQUEST_ID = -1 ) then
547: X_REQUEST_ID:=NULL;
540: if X_LAST_UPDATE_LOGIN is NULL then
541: X_LAST_UPDATE_LOGIN := -1;
542: end if;
543: X_REQUEST_ID:=FND_GLOBAL.CONC_REQUEST_ID;
544: X_PROGRAM_ID:=FND_GLOBAL.CONC_PROGRAM_ID;
545: X_PROGRAM_APPLICATION_ID:=FND_GLOBAL.PROG_APPL_ID;
546: if (X_REQUEST_ID = -1 ) then
547: X_REQUEST_ID:=NULL;
548: X_PROGRAM_ID:=NULL;
541: X_LAST_UPDATE_LOGIN := -1;
542: end if;
543: X_REQUEST_ID:=FND_GLOBAL.CONC_REQUEST_ID;
544: X_PROGRAM_ID:=FND_GLOBAL.CONC_PROGRAM_ID;
545: X_PROGRAM_APPLICATION_ID:=FND_GLOBAL.PROG_APPL_ID;
546: if (X_REQUEST_ID = -1 ) then
547: X_REQUEST_ID:=NULL;
548: X_PROGRAM_ID:=NULL;
549: X_PROGRAM_APPLICATION_ID:=NULL;
717: if(X_MODE = 'I') then
718: X_LAST_UPDATED_BY := 1;
719: X_LAST_UPDATE_LOGIN := 0;
720: elsif (X_MODE = 'R') then
721: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
722: if X_LAST_UPDATED_BY is NULL then
723: X_LAST_UPDATED_BY := -1;
724: end if;
725: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
721: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
722: if X_LAST_UPDATED_BY is NULL then
723: X_LAST_UPDATED_BY := -1;
724: end if;
725: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
726: if X_LAST_UPDATE_LOGIN is NULL then
727: X_LAST_UPDATE_LOGIN := -1;
728: end if;
729: X_REQUEST_ID:=FND_GLOBAL.CONC_REQUEST_ID;
725: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
726: if X_LAST_UPDATE_LOGIN is NULL then
727: X_LAST_UPDATE_LOGIN := -1;
728: end if;
729: X_REQUEST_ID:=FND_GLOBAL.CONC_REQUEST_ID;
730: X_PROGRAM_ID:=FND_GLOBAL.CONC_PROGRAM_ID;
731: X_PROGRAM_APPLICATION_ID:=FND_GLOBAL.PROG_APPL_ID;
732: if (X_REQUEST_ID = -1 ) then
733: X_REQUEST_ID:=OLD_REFERENCES.REQUEST_ID;
726: if X_LAST_UPDATE_LOGIN is NULL then
727: X_LAST_UPDATE_LOGIN := -1;
728: end if;
729: X_REQUEST_ID:=FND_GLOBAL.CONC_REQUEST_ID;
730: X_PROGRAM_ID:=FND_GLOBAL.CONC_PROGRAM_ID;
731: X_PROGRAM_APPLICATION_ID:=FND_GLOBAL.PROG_APPL_ID;
732: if (X_REQUEST_ID = -1 ) then
733: X_REQUEST_ID:=OLD_REFERENCES.REQUEST_ID;
734: X_PROGRAM_ID:=OLD_REFERENCES.PROGRAM_ID;
727: X_LAST_UPDATE_LOGIN := -1;
728: end if;
729: X_REQUEST_ID:=FND_GLOBAL.CONC_REQUEST_ID;
730: X_PROGRAM_ID:=FND_GLOBAL.CONC_PROGRAM_ID;
731: X_PROGRAM_APPLICATION_ID:=FND_GLOBAL.PROG_APPL_ID;
732: if (X_REQUEST_ID = -1 ) then
733: X_REQUEST_ID:=OLD_REFERENCES.REQUEST_ID;
734: X_PROGRAM_ID:=OLD_REFERENCES.PROGRAM_ID;
735: X_PROGRAM_APPLICATION_ID:=OLD_REFERENCES.PROGRAM_APPLICATION_ID;