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:
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: