Declaring cursor FOR LOOP on a delimited string in PL/SQL

 Hi Guys

I have a delimited string of concurrent request ids which i store in a variable 

l_request_id

The string looks something like this 

    l_request_id =     |67891|67892|67893|67894

Now i need to declare a cursor FOR LOOP which will split the variable ,get the concurrent request ids one by one and LOOP through the cursor.

Can anyone let me know how to do it. 

Can you also send me the piece of code on how to accomplish this

Thanks

Vijay