If your payment is made with a card, the activation is immediate, then you will receive a welcome message with the server confirmation email which contains the temporary IP address, cPanel login details.
But if payment is made manually such as a bank transfer, it is usually activated after the payment is confirmed.