APPS.MSC_CL_COLLECTION dependencies on DBMS_LOCK

Line 3811: DBMS_LOCK.SLEEP( 2);

3807: RAISE EX_PIPE_SND;
3808: END IF;
3809:
3810: IF lv_task_status <> OK THEN
3811: DBMS_LOCK.SLEEP( 2);
3812: END IF;
3813:
3814: END IF;
3815:

Line 4649: DBMS_LOCK.SLEEP( 5); -- initial estimated sleep time

4645: END IF;
4646: END IF; /* v_DSMode */
4647: END LOOP;
4648:
4649: DBMS_LOCK.SLEEP( 5); -- initial estimated sleep time
4650:
4651: --lv_task_not_completed := lv_total_task_number;
4652:
4653: lv_bon_start_end :=0; -- bug9194726

Line 6465: DBMS_LOCK.SLEEP( 5); -- initial estimated sleep time

6461: lv_task_not_completed := lv_task_not_completed + 1;
6462: END IF;
6463: END LOOP;
6464:
6465: DBMS_LOCK.SLEEP( 5); -- initial estimated sleep time
6466:
6467: --lv_task_not_completed := TOTAL_PARTIAL_TASKS;
6468:
6469: -- Now monitor the performance of the tasks.