751: if(X_MODE = 'I') then
752: X_LAST_UPDATED_BY := 1;
753: X_LAST_UPDATE_LOGIN := 0;
754: elsif (X_MODE = 'R') then
755: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
756: if X_LAST_UPDATED_BY is NULL then
757: X_LAST_UPDATED_BY := -1;
758: end if;
759: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
755: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
756: if X_LAST_UPDATED_BY is NULL then
757: X_LAST_UPDATED_BY := -1;
758: end if;
759: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
760: if X_LAST_UPDATE_LOGIN is NULL then
761: X_LAST_UPDATE_LOGIN := -1;
762: end if;
763: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
759: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
760: if X_LAST_UPDATE_LOGIN is NULL then
761: X_LAST_UPDATE_LOGIN := -1;
762: end if;
763: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
764: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
765: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
766: if (X_REQUEST_ID = -1) then
767: X_REQUEST_ID := NULL;
760: if X_LAST_UPDATE_LOGIN is NULL then
761: X_LAST_UPDATE_LOGIN := -1;
762: end if;
763: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
764: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
765: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
766: if (X_REQUEST_ID = -1) then
767: X_REQUEST_ID := NULL;
768: X_PROGRAM_ID := NULL;
761: X_LAST_UPDATE_LOGIN := -1;
762: end if;
763: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
764: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
765: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
766: if (X_REQUEST_ID = -1) then
767: X_REQUEST_ID := NULL;
768: X_PROGRAM_ID := NULL;
769: X_PROGRAM_APPLICATION_ID := NULL;
961: if(X_MODE = 'I') then
962: X_LAST_UPDATED_BY := 1;
963: X_LAST_UPDATE_LOGIN := 0;
964: elsif (X_MODE = 'R') then
965: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
966: if X_LAST_UPDATED_BY is NULL then
967: X_LAST_UPDATED_BY := -1;
968: end if;
969: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
965: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
966: if X_LAST_UPDATED_BY is NULL then
967: X_LAST_UPDATED_BY := -1;
968: end if;
969: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
970: if X_LAST_UPDATE_LOGIN is NULL then
971: X_LAST_UPDATE_LOGIN := -1;
972: end if;
973: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
969: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
970: if X_LAST_UPDATE_LOGIN is NULL then
971: X_LAST_UPDATE_LOGIN := -1;
972: end if;
973: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
974: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
975: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
976: if (X_REQUEST_ID = -1) then
977: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
970: if X_LAST_UPDATE_LOGIN is NULL then
971: X_LAST_UPDATE_LOGIN := -1;
972: end if;
973: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
974: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
975: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
976: if (X_REQUEST_ID = -1) then
977: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
978: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
971: X_LAST_UPDATE_LOGIN := -1;
972: end if;
973: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
974: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
975: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
976: if (X_REQUEST_ID = -1) then
977: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
978: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
979: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;