DBA Data[Home] [Help]

APPS.FND_RT_REQUEST dependencies on DBMS_LOCK

Line 42: dbms_lock.sleep(60);

38: cnt := 1;
39: totalsleep := 0;
40: while ((cnt > 0) and (totalsleep < timeout))loop
41: /* the following sleep function is in second */
42: dbms_lock.sleep(60);
43: select count(*) into cnt
44: from fnd_concurrent_requests
45: where phase_code in ('P', 'R')
46: start with request_id = parent.request_id