Below anonymous script can be used to transfer the notification ownership from person x to y
BEGIN
wf_notification.transfer (17515872, -- notification id to transfer
'1000012008', -- role to whom the notification is to be transferred
'Transferring as requested by z from x to y' -- Transfer comment
);
END;