Temp table will not exist outside of the stored proc when using #temp syntax, try ##temptablename, and use delete table at end of sp.

Read up on cursors and locking mechanisms,...