APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on DBMS_LOCK

Line 838: DBMS_LOCK.SLEEP( 10);

834: ELSIF l_dev_phase='INACTIVE' THEN
835: EXIT WHEN l_pending_timeout_flag= 1;
836: END IF;
837:
838: DBMS_LOCK.SLEEP( 10);
839:
840: END LOOP;
841:
842: o_retcode:= SYS_NO;

Line 898: DBMS_LOCK.SLEEP( 10);

894: END IF;
895: EXIT;
896: END IF;
897:
898: DBMS_LOCK.SLEEP( 10);
899:
900: END LOOP;
901:
902: o_retcode:= G_OTHERS;