How And What To Use To Pass Multiple Results To Store Procedure

I have another post on formatting arrays [URL], thinking that would be the way.. and may be it is.. But let me explain it here and see if thats where i need to focus. I have a class that i use to call 3 different procedures, the values from proc#1 are passed to proc#2 and then proc#2 values passed on to proc#3. Now my problem is that i need the results from proc#3 to be placed in a variable i can pass on to another procedure to execute a query.

Proc#1 returns only 1 record. (easy to place into a session or variable)

Proc#2 returns only 1 record. (easy to place into a session or variable)

Proc#3 returns multple records(its only 1 field that is returned, but can have multiple records), so i need to know what is the best solution to place all records returned into a session or variable to use as a parameter in a query?

Since i need to pass those values to a stored procedure, how can i pass what is returned from proc#3 to my query? One of the parameter of the store procedure is our locations, so my query will look like this:

Select *
From tblName
Where loc LIKE ('1','2','3' )

So i want to set it up so that the values within the LIKE statement are passed in from the page like so

Select *
From tblName
Where loc LIKE (@loc)