DBA Data[Home] [Help]

APPS.FND_EXEC_MIG_CMDS dependencies on DBMS_LOCK

Line 368: DBMS_LOCK.SLEEP(300);

364: end if;
365: l_retVal := 1;
366: EXIT;
367: end if;
368: DBMS_LOCK.SLEEP(300);
369: else
370: if sqlcode = -25228 then
371: update fnd_ts_mig_status set num_threads=num_threads-1, status=decode(num_threads,1,'SUCCESS',status),detail_message=decode(num_threads,1,'',detail_message) where item='EXE_MIG_CMDS';
372: commit;