APPS.SSP_SMP_RATE_UPLD dependencies on DBMS_LOCK

Line 48: dbms_lock.sleep(10);

44: hr_utility.set_location(g_package||'Inside while loop',10);
45: if ad_zd.get_edition('PATCH') is not null then
46: -- an online patch is in progress, goto sleep
47: hr_utility.set_location(g_package||'upd_abs_rates :AD_ZD'||ad_zd.get_edition('PATCH'),10);
48: dbms_lock.sleep(10);
49: end if;
50: exit when ad_zd.get_edition('PATCH') is null;
51: end loop;
52: