CREATE TABLE Foo ( 
    Foo1ID VARCHAR2(255), 
    Foo2ID VARCHAR2(255), 
    FooCategory VARCHAR2(255), 
    FooValue NUMBER, 
    PRIMARY KEY (Foo1ID, Foo2ID) 
)

INSERT INTO Foo VALUES('A','100','Type1',100)

INSERT INTO Foo VALUES('A','102','Type2',20)

INSERT INTO Foo VALUES('A','104','Type1',54)

INSERT INTO Foo VALUES('A','106','Type2',75)

INSERT INTO Foo VALUES('B','100','Type1',82)

INSERT INTO Foo VALUES('B','102','Type2',33)

INSERT INTO Foo VALUES('B','104','Type1',90)

INSERT INTO Foo VALUES('B','106','Type2',65)

INSERT INTO Foo VALUES('C','100','Type1',71)

INSERT INTO Foo VALUES('C','102','Type2',25)

INSERT INTO Foo VALUES('C','104','Type1',44)

INSERT INTO Foo VALUES('C','106','Type2',93)

CREATE OR REPLACE PROCEDURE UpdateFooValue( 
    p_FooCategory Foo.FooCategory%TYPE 
) AS 
    CURSOR foo_cursor IS 
    -- Should we include Foo1ID, Foo2ID here ? 
    SELECT Foo1ID, Foo2ID, FooValue FROM Foo  
     WHERE Foo.FooCategory = p_FooCategory 
     FOR UPDATE; 
    v_FooValue Foo.FooValue%TYPE := 0; 
BEGIN 
    FOR foo_rec IN foo_cursor LOOP 
        IF foo_rec.FooValue > 50 THEN 
            v_FooValue := 25; 
        ELSE 
            v_FooValue := 10; 
        END IF; 
 
        UPDATE Foo SET FooValue = v_FooValue WHERE CURRENT OF foo_cursor; 
    END LOOP; 
END UpdateFooValue;

BEGIN 
    UpdateFooValue('Type1'); 
    COMMIT; 
    UpdateFooValue('Type2'); 
    COMMIT; 
END;    

SELECT * FROM Foo