Procedure Parameter Retrieval

SELECT name ,
TYPE_NAME(user_type_id )TYPE ,
max_length ,
parameter_id param_order
FROM sys.all_parameters
WHERE object_id = OBJECT_ID('[dbo].[sp_name_p]' )
AND is_output<>1 -- Excluding the OUTPUT parameter