APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on DBMS_LOCK

Line 1594: DBMS_LOCK.sleep (30);

1590: END IF;
1591:
1592: l_cnt := l_cnt + 1;
1593: -- wait for 30 seconds before attempting to lock again
1594: DBMS_LOCK.sleep (30);
1595: ELSE
1596: RAISE;
1597: END IF;
1598: END; -- anonymous PL/SQL block to trap lock exception