APPS.SSP_SMP_SUPPORT_PKG dependencies on DBMS_LOCK
Line 3065: DBMS_LOCK.SLEEP(20);
3061: -- 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);
3062: p_update_error := true;
3063: exit;
3064: ELSE 3065: DBMS_LOCK.SLEEP(20); 3066: END IF;
3067: Exception
3068: when no_data_found then
3069: exit;