What does the procedure proce_Name do?

btw, I strongly recommend against any architecture or design that has pieces of queries being passed around as parameters, it gets hugely complex, there are almost always security vulnerabilities as a result and it's a pain to work with them,