A stored procedure has a single plan, parameters will not cause a procedure to have multiple plans.
Write queries and procedures in the simplest way, only if testing shows a problem should you consider more complicated alternatives.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability