-- 等待请求
DECLARE
l_request_id NUMBER;
l_rphase VARCHAR2(80);
l_rstatus VARCHAR2(80);
l_dphase VARCHAR2(80);
l_dstatus VARCHAR2(80);
l_message VARCHAR2(2000);
BEGIN
------Wait for request
l_call_status := fnd_concurrent.wait_for_request(l_request_id
,10
,1000
,l_rphase
,l_rstatus
,l_dphase
,l_dstatus
,l_message);
IF l_dphase = 'COMPLETE'
AND l_dstatus = 'NORMAL' THEN
NULL;
--请求完成
END IF;
END;
DECLARE
l_request_id NUMBER;
l_rphase VARCHAR2(80);
l_rstatus VARCHAR2(80);
l_dphase VARCHAR2(80);
l_dstatus VARCHAR2(80);
l_message VARCHAR2(2000);
BEGIN
------Wait for request
l_call_status := fnd_concurrent.wait_for_request(l_request_id
,10
,1000
,l_rphase
,l_rstatus
,l_dphase
,l_dstatus
,l_message);
IF l_dphase = 'COMPLETE'
AND l_dstatus = 'NORMAL' THEN
NULL;
--请求完成
END IF;
END;