[Home] [Help]
787: l_refreshed_flag NUMBER;
788: l_pending_timeout_flag NUMBER;
789: l_start_time DATE;
790:
791: ---------------- used for fnd_concurrent ---------
792: l_call_status boolean;
793: l_phase varchar2(80);
794: l_status varchar2(80);
795: l_dev_phase varchar2(80);
805: << begin_loop >>
806:
807: l_pending_timeout_flag := SIGN( SYSDATE - l_start_time - p_timeout/1440.0);
808:
809: l_call_status:= FND_CONCURRENT.WAIT_FOR_REQUEST
810: ( l_request_id,
811: 60,
812: 10,
813: l_phase,
853: l_refreshed_flag NUMBER;
854: l_pending_timeout_flag NUMBER;
855: l_start_time DATE;
856:
857: ---------------- used for fnd_concurrent ---------
858: l_call_status boolean;
859: l_phase varchar2(80);
860: l_status varchar2(80);
861: l_dev_phase varchar2(80);
869: LOOP
870:
871: l_pending_timeout_flag := SIGN( SYSDATE - l_start_time - p_timeout/1440.0);
872:
873: l_call_status:= FND_CONCURRENT.WAIT_FOR_REQUEST
874: ( v_request_id,
875: 10,
876: 10,
877: l_phase,
1404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Cancelling pending/running snapshots');
1405: FOR j IN 1..p_req_id.COUNT LOOP
1406: l_request_id:=p_req_id(j);
1407:
1408: l_call_status := FND_CONCURRENT.GET_REQUEST_STATUS
1409: (l_request_id,
1410: '',
1411: '',
1412: l_phase,