>The naming of a stored procedure has two terms Procedure_name and ProcedureName. Keith said that the second ProcedureName is actually a data type. Would it be a data type of the value that sproc returns? If so, what do you use for data type if the sproc returns a bunch or rows like a cursor?

You should stop working on weekend because Keith didn't say those things. :)
Each template parameter has 3 values, eg

<Procedure_Name, sysname, ProcedureName>
1. Parameter name: Procedure_Name. You will see it in the first column of the substitutin dialog
2. Type of template parameter: sysname. The second column of the substitutin dialog
3. Default value of template parameter: ProcedureName. The third column of the substitutin dialog