DBA Data[Home] [Help]

APPS.MSD_WF dependencies on DBMS_LOCK

Line 596: dbms_lock.sleep(45);

592: --agb Emerson 08/12/2003
593: -- moved sleep here to pace the loop at one minute
594: -- This should be more than sufficent
595:
596: dbms_lock.sleep(45);
597:
598: wf_engine.ItemStatus(itemType, itemkey, status_code, result);
599:
600: if RTRIM(status_code) = 'COMPLETE' then

Line 633: dbms_lock.sleep(15);

629:
630: -- agb inspired from Emerson mod 08/12/2003
631: -- This should give time for the deferred item to be
632: -- in both WF status and on the deferred queue
633: dbms_lock.sleep(15);
634: wf_engine.Background(itemtype);
635:
636: end if;
637: