APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on FND_CONCURRENT

Line 11652: FROM fnd_concurrent_requests

11648: FOR UPDATE OF object_version_number NOWAIT;
11649:
11650: CURSOR fnd_concur_csr(p_conc_req_id IN NUMBER) IS
11651: SELECT 'x'
11652: FROM fnd_concurrent_requests
11653: WHERE REQUEST_ID = p_conc_req_id;
11654:
11655: record_locked EXCEPTION;
11656: pragma exception_init (record_locked, -54);

Line 11703: l_req_status := FND_CONCURRENT.GET_REQUEST_STATUS(request_id => undeleted_parent.parent_conc_request_id,

11699: -- cleanup any orphaned rows left from other parent requests.
11700: FOR undeleted_parent IN get_undeleted_parents(p_parent_conc_request_id) LOOP
11701: /* not needed - check only child conc request status
11702: -- check parent status.
11703: l_req_status := FND_CONCURRENT.GET_REQUEST_STATUS(request_id => undeleted_parent.parent_conc_request_id,
11704: --appl_shortname => 'AHL',
11705: --program => 'AHLUEFF',
11706: phase => l_rphase,
11707: status => l_rstatus,

Line 11715: l_req_status := FND_CONCURRENT.GET_REQUEST_STATUS(request_id => undeleted_child.child_conc_request_id,

11711: IF (l_req_status = TRUE) AND (l_dphase = 'COMPLETE' OR l_dphase IS NULL) THEN
11712: */
11713:
11714: FOR undeleted_child IN get_undeleted_child(undeleted_parent.parent_conc_request_id) LOOP
11715: l_req_status := FND_CONCURRENT.GET_REQUEST_STATUS(request_id => undeleted_child.child_conc_request_id,
11716: --appl_shortname => 'AHL',
11717: --program => 'AHLWUEFF',
11718: phase => l_rphase,
11719: status => l_rstatus,

Line 11724: -- check if request exists in fnd_concurrent_requests table

11720: dev_phase => lc_dphase,
11721: dev_status => l_dstatus,
11722: message => l_message);
11723: IF NOT(l_req_status) THEN
11724: -- check if request exists in fnd_concurrent_requests table
11725: OPEN fnd_concur_csr(undeleted_child.child_conc_request_id);
11726: FETCH fnd_concur_csr INTO l_junk;
11727: IF (fnd_concur_csr%NOTFOUND) THEN
11728: l_req_status := TRUE;