APPS.HZ_IMP_DQM_STAGE dependencies on FND_CONCURRENT_REQUESTS

Line 725: l_sub FND_CONCURRENT.REQUESTS_TAB_TYPE;

721: x_msg_data VARCHAR2(255);
722:
723: x_dup_batch_id NUMBER;
724: l_state boolean := true;
725: l_sub FND_CONCURRENT.REQUESTS_TAB_TYPE;
726: call_status boolean;
727: l_conc_phase VARCHAR2(80);
728: l_conc_status VARCHAR2(80);
729: l_conc_dev_phase VARCHAR2(30);

Line 789: from fnd_concurrent_requests R

785: -- AFTER ALL THE WORKERS ARE DONE, SEE IF THEY HAVE ALL COMPLETED NORMALLY
786: -- assume that all concurrent dup workers completed normally, unless found otherwise
787: l_workers_completed := TRUE;
788: select request_id BULK COLLECT into l_sub_requests
789: from fnd_concurrent_requests R
790: where parent_request_id = FND_GLOBAL.conc_request_id
791: and (phase_code<>'C' or status_code<>'C');
792: IF l_sub_requests.count > 0 THEN
793: l_workers_completed := FALSE;

Line 828: from fnd_concurrent_requests R

824: -- AFTER ALL THE WORKERS ARE DONE, SEE IF THEY HAVE ALL COMPLETED NORMALLY
825: -- assume that all concurrent dup workers completed normally, unless found otherwise
826: l_workers_completed := TRUE;
827: select request_id BULK COLLECT into l_sub_requests
828: from fnd_concurrent_requests R
829: where parent_request_id = FND_GLOBAL.conc_request_id
830: and (phase_code<>'C' or status_code<>'C');
831: IF l_sub_requests.count > 0 THEN
832: l_workers_completed := FALSE;