948: if(X_MODE = 'I') then
949: X_LAST_UPDATED_BY := 1;
950: X_LAST_UPDATE_LOGIN := 0;
951: elsif (X_MODE = 'R') then
952: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
953: if X_LAST_UPDATED_BY is NULL then
954: X_LAST_UPDATED_BY := -1;
955: end if;
956: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
952: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
953: if X_LAST_UPDATED_BY is NULL then
954: X_LAST_UPDATED_BY := -1;
955: end if;
956: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
957: if X_LAST_UPDATE_LOGIN is NULL then
958: X_LAST_UPDATE_LOGIN := -1;
959: end if;
960:
957: if X_LAST_UPDATE_LOGIN is NULL then
958: X_LAST_UPDATE_LOGIN := -1;
959: end if;
960:
961: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
962: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
963: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
964: IF (X_REQUEST_ID = -1) THEN
965: X_REQUEST_ID := NULL;
958: X_LAST_UPDATE_LOGIN := -1;
959: end if;
960:
961: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
962: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
963: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
964: IF (X_REQUEST_ID = -1) THEN
965: X_REQUEST_ID := NULL;
966: X_PROGRAM_ID := NULL;
959: end if;
960:
961: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
962: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
963: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
964: IF (X_REQUEST_ID = -1) THEN
965: X_REQUEST_ID := NULL;
966: X_PROGRAM_ID := NULL;
967: X_PROGRAM_APPLICATION_ID := NULL;
1171: if(X_MODE = 'I') then
1172: X_LAST_UPDATED_BY := 1;
1173: X_LAST_UPDATE_LOGIN := 0;
1174: elsif (X_MODE = 'R') then
1175: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1176: if X_LAST_UPDATED_BY is NULL then
1177: X_LAST_UPDATED_BY := -1;
1178: end if;
1179: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1175: X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1176: if X_LAST_UPDATED_BY is NULL then
1177: X_LAST_UPDATED_BY := -1;
1178: end if;
1179: X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1180: if X_LAST_UPDATE_LOGIN is NULL then
1181: X_LAST_UPDATE_LOGIN := -1;
1182: end if;
1183: else
1210: x_last_update_login => X_LAST_UPDATE_LOGIN
1211: );
1212:
1213: if (X_MODE = 'R') then
1214: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1215: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1216: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1217: if (X_REQUEST_ID = -1) then
1218: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1211: );
1212:
1213: if (X_MODE = 'R') then
1214: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1215: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1216: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1217: if (X_REQUEST_ID = -1) then
1218: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1219: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
1212:
1213: if (X_MODE = 'R') then
1214: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
1215: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
1216: X_PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
1217: if (X_REQUEST_ID = -1) then
1218: X_REQUEST_ID := OLD_REFERENCES.REQUEST_ID;
1219: X_PROGRAM_ID := OLD_REFERENCES. PROGRAM_ID;
1220: X_PROGRAM_APPLICATION_ID := OLD_REFERENCES.PROGRAM_APPLICATION_ID;