Hi

Sure it will replace the procedure in the database and will be marked as Invalid in the database.offourse it will overwrite
when you use the keyword

create or replace procedurename

Regards