APPS.SSP_SMP_SUPPORT_PKG dependencies on DBMS_LOCK
Line 3624: DBMS_LOCK.SLEEP(20);
3620: -- DBMS_OUTPUT.PUT_LINE(' Job '||l_tbl_job(I).job_no||' Failed for person id '||l_tbl_job(I).person_id||' with absence id '||l_tbl_job(I).absence_id);
3621: p_update_error := true;
3622: exit;
3623: ELSE 3624: DBMS_LOCK.SLEEP(20); 3625: END IF;
3626: Exception
3627: when no_data_found then
3628: exit;