DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on FND_CONCURRENT_REQUESTS

Line 2337: -- as its child in FND_CONCURRENT_REQUESTS, regardless of the TRUE/FALSE flag

2333: log ('checking completion status of child programs spawned by tis program' );
2334: l_workers_completed := TRUE;
2335:
2336: -- program id is hard coded since any conc program submitted by this program is construed
2337: -- as its child in FND_CONCURRENT_REQUESTS, regardless of the TRUE/FALSE flag
2338: -- used in FND_CONCURRENT.SUBMIT_REQUEST
2339:
2340: select request_id BULK COLLECT into l_sub_requests
2341: from fnd_concurrent_requests R

Line 2341: from fnd_concurrent_requests R

2337: -- as its child in FND_CONCURRENT_REQUESTS, regardless of the TRUE/FALSE flag
2338: -- used in FND_CONCURRENT.SUBMIT_REQUEST
2339:
2340: select request_id BULK COLLECT into l_sub_requests
2341: from fnd_concurrent_requests R
2342: where parent_request_id = l_request_id
2343: and concurrent_program_id = 46839
2344: and (phase_code<>'C' or status_code<>'C');
2345:

Line 2961: from Fnd_Concurrent_Requests R

2957: l_workers_completed := TRUE;
2958:
2959: -- get request ids that did not complete
2960: Select request_id BULK COLLECT into l_sub_requests
2961: from Fnd_Concurrent_Requests R
2962: Where Parent_Request_Id = FND_GLOBAL.conc_request_id
2963: and (phase_code<>'C' or status_code<>'C');
2964:
2965: -- log these request_ids and set the return code of the parent concurrent program