APPS.MSC_CL_PULL dependencies on DBMS_LOCK

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

1706:
1707: IF DBMS_PIPE.SEND_MESSAGE( v_pipe_wm)<>0 THEN RAISE EX_PIPE_SND;
1708: END IF;
1709:
1710: IF lv_task_status <> OK THEN DBMS_LOCK.SLEEP(5);
1711: END IF;
1712:
1713: END IF;
1714:

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

3091: --- PREPLACE CHANGE END ---
3092:
3093: END LOOP; -- lc_i
3094:
3095: DBMS_LOCK.SLEEP( 5); -- initial estimated sleep time
3096:
3097: --lv_task_not_completed := lv_total_task_number;
3098:
3099: lv_start_time:= SYSDATE;