DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on FND_CONCURRENT_REQUESTS

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

2154: log ('checking completion status of child programs spawned by tis program' );
2155: l_workers_completed := TRUE;
2156:
2157: -- program id is hard coded since any conc program submitted by this program is construed
2158: -- as its child in FND_CONCURRENT_REQUESTS, regardless of the TRUE/FALSE flag
2159: -- used in FND_CONCURRENT.SUBMIT_REQUEST
2160:
2161: select request_id BULK COLLECT into l_sub_requests
2162: from fnd_concurrent_requests R

Line 2162: from fnd_concurrent_requests R

2158: -- as its child in FND_CONCURRENT_REQUESTS, regardless of the TRUE/FALSE flag
2159: -- used in FND_CONCURRENT.SUBMIT_REQUEST
2160:
2161: select request_id BULK COLLECT into l_sub_requests
2162: from fnd_concurrent_requests R
2163: where parent_request_id = l_request_id
2164: and concurrent_program_id = 46839
2165: and (phase_code<>'C' or status_code<>'C');
2166:

Line 2782: from Fnd_Concurrent_Requests R

2778: l_workers_completed := TRUE;
2779:
2780: -- get request ids that did not complete
2781: Select request_id BULK COLLECT into l_sub_requests
2782: from Fnd_Concurrent_Requests R
2783: Where Parent_Request_Id = FND_GLOBAL.conc_request_id
2784: and (phase_code<>'C' or status_code<>'C');
2785:
2786: -- log these request_ids and set the return code of the parent concurrent program