The problem is in the way you are creating the recordsets. you do not need to create a parameter in the recordset if the value is going to be static. Only crate a parameter if the value is coming from a variable.
For a static value, just enter the value in the where clause:
WHERE PRV_reservation_ID = 1
rather than using a parameter.