APPS.CN_CALC_SUBMISSION_PUB dependencies on DBMS_LOCK

Line 1361: dbms_lock.sleep(180);

1357: WHILE l_unfinished LOOP
1358: l_calc_sub_status := get_calc_sub_batch_status( l_calc_sub_batch_id);
1359:
1360: IF l_calc_sub_status = 'PROCESSING' THEN
1361: dbms_lock.sleep(180);
1362: ELSE
1363: l_unfinished := FALSE;
1364: END IF;
1365: END LOOP;

Line 2269: dbms_lock.sleep(180);

2265: WHILE l_unfinished LOOP
2266: l_calc_sub_status := get_calc_sub_batch_status( l_calc_sub_batch_id);
2267:
2268: IF l_calc_sub_status = 'PROCESSING' THEN
2269: dbms_lock.sleep(180);
2270: ELSE
2271: l_unfinished := FALSE;
2272: END IF;
2273: END LOOP;