Applications such as ASP.NET use connection pool. so any website session can send any TSQL query on any of the connections that are pooled.
To ensure that the current page does not get anything left over from last page/query, this proc is used. This saves overhead of disconnect and re-connect for every query/page hit.
This proc is used internally by the OLEDB Providers/ODBC drivers.