SQL & PL/SQL

Hello Experts,

In Oracle Apps11i , when i am trying to run this PL/SQL block it is not updating the table column.

BEGIN

    FOR cur
    IN (SELECT     DISTINCT msi.inventory_item_id, clpt.item_no
                                ,clpt.list_value
         FROM      temp clpt
                  ,mtl_system_items msi
         WHERE     clpt.item_no = msi.segment1 
               AND organization_id IN (222,223))
    LOOP
    
        
        UPDATE    mtl_system_items_b
        SET        list_price_per_unit     = cur.list_value
        WHERE          segment1 = cur.item_no
                    AND inventory_item_id = cur.inventory_item_id
                    AND organization_id IN (222,223);


    END LOOP;


    COMMIT;
exception 
when others then
dbms_output.put_line(sqlerrm);
END;

whereas when i am running direct update query, it is getting updated successfully.

        UPDATE    mtl_system_items_b
        SET        list_price_per_unit     = 25
        WHERE          segment1 = 'DFS30300'
                    AND inventory_item_id = 3
                    AND organization_id IN (222,223);

This table is directly created in APPS schema. So no issue with table creation.

Please help....

Thanks...