DBA Data[Home] [Help]

APPS.OKS_IMPORT_CONTRACTS dependencies on FND_CONCURRENT_REQUESTS

Line 155: SELECT count(1) INTO l_worker_count FROM fnd_concurrent_requests

151: AND (INTERFACE_STATUS IS NULL OR INTERFACE_STATUS = 'R')
152: AND rownum = 1;
153:
154: l_stmt_num := 15;
155: SELECT count(1) INTO l_worker_count FROM fnd_concurrent_requests
156: WHERE parent_request_id = G_WORKER_REQ_ID
157: AND rownum = 1;
158:
159: IF l_row_count > 0 AND l_worker_count = 0 THEN