Alright! Was able to figure it out with your code snippet. Once I was able to insert them. What helped me understand more was breaking out all your steps and doing them one by one.
Also before updating Scheduled_Recordings I ran this select filename from SCHEDULED_RECORDING; To see what files are in the database that need to be updated. Not all of your update steps are applicable. Thanks for posting your code. It was super helpful!