APPS.MSC_CL_PULL dependencies on DBMS_LOCK

Line 1672: IF lv_task_status <> OK THEN DBMS_LOCK.SLEEP(5);

1668:
1669: IF DBMS_PIPE.SEND_MESSAGE( v_pipe_wm)<>0 THEN RAISE EX_PIPE_SND;
1670: END IF;
1671:
1672: IF lv_task_status <> OK THEN DBMS_LOCK.SLEEP(5);
1673: END IF;
1674:
1675: END IF;
1676:

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

2935: --- PREPLACE CHANGE END ---
2936:
2937: END LOOP; -- lc_i
2938:
2939: DBMS_LOCK.SLEEP( 5); -- initial estimated sleep time
2940:
2941: --lv_task_not_completed := lv_total_task_number;
2942:
2943: lv_start_time:= SYSDATE;