BI publisher variable not getting updated

Summary

Variable PROCESSSTATUS is not getting updated,This is a BI stored procedure-to check the child jobs process status

Content

This is a BI stored procedure which is to check the overall status - the child job status and respond, the initial query is to check for the status and in while condition the loop needs to be set as long as status is in running status.

The query and logic is working as expected only issues in with PROCESSSTATUS  which is not getting updated, please advise

 

 

DECLARE
type refcursor is REF CURSOR;
xdo_cursor refcursor;
p_request_id varchar2(150):=:p_request_id;