941: if(X_MODE = 'I') then
942: X_LAST_UPDATED_BY := 1;
943: X_LAST_UPDATE_LOGIN := 0;
944: elsif (X_MODE IN ('R', 'S')) then
945: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
946: if X_LAST_UPDATED_BY is NULL then
947: X_LAST_UPDATED_BY := -1;
948: end if;
949: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
945: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
946: if X_LAST_UPDATED_BY is NULL then
947: X_LAST_UPDATED_BY := -1;
948: end if;
949: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
950: if X_LAST_UPDATE_LOGIN is NULL then
951: X_LAST_UPDATE_LOGIN := -1;
952: end if;
953: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
949: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
950: if X_LAST_UPDATE_LOGIN is NULL then
951: X_LAST_UPDATE_LOGIN := -1;
952: end if;
953: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
954: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
955: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
956: if (X_REQUEST_ID = -1) then
957: X_REQUEST_ID := NULL;
950: if X_LAST_UPDATE_LOGIN is NULL then
951: X_LAST_UPDATE_LOGIN := -1;
952: end if;
953: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
954: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
955: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
956: if (X_REQUEST_ID = -1) then
957: X_REQUEST_ID := NULL;
958: X_PROGRAM_ID := NULL;
951: X_LAST_UPDATE_LOGIN := -1;
952: end if;
953: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
954: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
955: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
956: if (X_REQUEST_ID = -1) then
957: X_REQUEST_ID := NULL;
958: X_PROGRAM_ID := NULL;
959: X_PROGRAM_APPLICATION_ID := NULL;
1173: if(X_MODE = 'I') then
1174: X_LAST_UPDATED_BY := 1;
1175: X_LAST_UPDATE_LOGIN := 0;
1176: elsif (X_MODE IN ('R', 'S')) then
1177: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1178: if X_LAST_UPDATED_BY is NULL then
1179: X_LAST_UPDATED_BY := -1;
1180: end if;
1181: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1177: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1178: if X_LAST_UPDATED_BY is NULL then
1179: X_LAST_UPDATED_BY := -1;
1180: end if;
1181: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1182: if X_LAST_UPDATE_LOGIN is NULL then
1183: X_LAST_UPDATE_LOGIN := -1;
1184: end if;
1185: else
1208: x_last_updated_by => X_LAST_UPDATED_BY,
1209: x_last_update_login => X_LAST_UPDATE_LOGIN
1210: ) ;
1211: if (X_MODE IN ('R', 'S')) then
1212: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1213: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1214: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1215: if (X_REQUEST_ID = -1) then
1216: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1209: x_last_update_login => X_LAST_UPDATE_LOGIN
1210: ) ;
1211: if (X_MODE IN ('R', 'S')) then
1212: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1213: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1214: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1215: if (X_REQUEST_ID = -1) then
1216: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1217: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
1210: ) ;
1211: if (X_MODE IN ('R', 'S')) then
1212: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1213: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1214: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1215: if (X_REQUEST_ID = -1) then
1216: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1217: X_PROGRAM_ID := OLD_REFERENCES.PROGRAM_ID;
1218: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;