Does a cement brick walled sump for residential purposes require a PCC or RCC floor (bed)?

Typically, you want a bottom to your sump. Otherwise, you have dirt/mud containing your sump. This can lead to the sump sinking, dirt and rocks trying to go through your sump, or leaking around the sump which you probably didn’t intend as you would have provided leach lines instead of the sump.

So, yes. You want something like a concrete bottom to your sump.