DECLARE CURSOR c1 IS SELECT * FROM wf_users WHERE name = 'MATTS'; BEGIN FOR i IN c1 LOOP wf_directory.SetUserAttr ( user_name => i.name , orig_system => i.orig_system , orig_system_id => i.orig_system_id , display_name => i.display_name , description => i.description , notification_preference => 'QUERY' , language => i.language , territory => i.territory , email_address => i.email_address , fax => i.fax , expiration_date => i.expiration_date , status => i.status , start_date => i.start_date , OverWrite => TRUE , Parent_Orig_System => i.Parent_Orig_System , Parent_orig_system_id => i.Parent_orig_system_id , owner_tag => i.owner_tag , last_updated_by => FND_GLOBAL.USER_ID , last_update_date => SYSDATE , last_update_login => FND_GLOBAL.RESP_ID ); END LOOP; END; /