APPS.PAY_BEE_SS dependencies on DBMS_LOCK

Line 1117: dbms_lock.sleep(5);

1113: --and name = 'P_BATCH_STATUS_FLAG';
1114: --end if;
1115: while (l_phase_code<>'C')
1116: loop
1117: dbms_lock.sleep(5);
1118: select PHASE_CODE into l_phase_code from fnd_concurrent_requests where request_id=l_request_id;
1119: -- bee_trace('Phase code is '||l_phase_code);
1120: end loop;
1121:

Line 1798: dbms_lock.sleep(5);

1794:
1795:
1796: while (l_phase_code<>'C')
1797: loop
1798: dbms_lock.sleep(5);
1799: select PHASE_CODE into l_phase_code from fnd_concurrent_requests where request_id=l_request_id;
1800: -- bee_trace('Phase code is '||l_phase_code);
1801: end loop;
1802: