1059: l_workers_completed := TRUE;
1060:
1061: Select request_id BULK COLLECT into l_sub_requests
1062: from Fnd_Concurrent_Requests R
1063: Where Parent_Request_Id = FND_GLOBAL.conc_request_id
1064: and (phase_code<>'C' or status_code<>'C');
1065:
1066: IF l_sub_requests.count>0 THEN
1067: l_workers_completed:=FALSE;
1345: l_workers_completed := TRUE;
1346:
1347: Select request_id BULK COLLECT into l_sub_requests
1348: from Fnd_Concurrent_Requests R
1349: Where Parent_Request_Id = FND_GLOBAL.conc_request_id
1350: and (phase_code<>'C' or status_code<>'C');
1351:
1352: IF l_sub_requests.count>0 THEN
1353: l_workers_completed:=FALSE;
2803: l(' H_PERSON_PARTY_ID NumberList;'); -- Fix for bug 5155761
2804: l(' USER_TERMINATE EXCEPTION;');
2805: l('');
2806: l(' BEGIN');
2807: l(' req_id := FND_GLOBAL.CONC_REQUEST_ID;');
2808: l(' LOOP');
2809: l(' call_status := FND_CONCURRENT.GET_REQUEST_STATUS(');
2810: l(' req_id, null,null,rphase,rstatus,dphase,dstatus,message);');
2811: l(' IF dstatus = ''TERMINATING'' THEN');