PROCEDURE UPDATE_DETAILS(id NUMBER, membershipNumber VARCHAR2, surname VARCHAR2, forename VARCHAR2,changeStatus VARCHAR2) AS
  BEGIN
    IF CHANGESTATUS = 'true' THEN
    UPDATE members
    SET MEMBERSHIP_NO = membershipNumber, SURNAME = surname, FORENAME = forename, SUBMITTED_DATE = SYSDATE, CHANGED_DATE = SYSDATE
    WHERE ID = id;
  ELSE
    UPDATE members
    SET MEMBERSHIP_NO = membershipNumber, SURNAME = surname, FORENAME = forename, SUBMITTED_DATE = SYSDATE
    WHERE ID = id;
  END IF;

END UPDATE_DETAILS;

WHERE ID = id;

UPDATE members
SET .....
WHERE members.ID = members.id;