DBA Data[Home] [Help]

APPS.ZPB_WF_ERROR dependencies on FND_CONCURRENT_REQUESTS

Line 400: FROM Fnd_Concurrent_Requests r

396: -- should only be one entry. This should be 1 or there is
397: -- something very wrong.
398: SELECT COUNT(r.STATUS_CODE)
399: INTO l_count
400: FROM Fnd_Concurrent_Requests r
401: WHERE r.REQUEST_ID = l_request_id
402: and r.PROGRAM_APPLICATION_ID = l_appID
403: and r.REQUESTED_BY = l_ownerID;
404:

Line 409: FROM Fnd_Concurrent_Requests r

405: if l_count = 1 then
406:
407: SELECT distinct R.STATUS_CODE, R.LOGFILE_NAME, CONCURRENT_PROGRAM_ID
408: into l_req_status, l_reqlog, l_concprgID
409: FROM Fnd_Concurrent_Requests r
410: WHERE r.REQUEST_ID = l_request_id
411: and r.PROGRAM_APPLICATION_ID = l_appID
412: and r.REQUESTED_BY = l_ownerID;
413: