APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on DBMS_LOCK

Line 810: DBMS_LOCK.SLEEP( 10);

806: ELSIF l_dev_phase='INACTIVE' THEN
807: EXIT WHEN l_pending_timeout_flag= 1;
808: END IF;
809:
810: DBMS_LOCK.SLEEP( 10);
811:
812: END LOOP;
813:
814: o_retcode:= SYS_NO;

Line 870: DBMS_LOCK.SLEEP( 10);

866: END IF;
867: EXIT;
868: END IF;
869:
870: DBMS_LOCK.SLEEP( 10);
871:
872: END LOOP;
873:
874: o_retcode:= G_OTHERS;