Dear Brian,
I'm so sorry to hear about Paul's situation. I know there are really no words that can help you right now. The best thing you can do is to be there for him, talk to him about normal, everyday things, and reminisce about all the good times I'm sure you have had together.
Please - contact your local hospice organization IMMEDIATELY. They are staffed with highly skilled, compassionate people who can help you with every aspect of what you and Paul are facing. They know everything about pain control and emotional issues and can help with medical needs and activities of daily living. Their services are usually covered by insurance or Medicare.
Paul is lucky to have a friend like you. Stay strong for him, you will always be glad you did. I will keep you both in my thoughts and prayers.
Barb