APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on DBMS_LOCK

Line 1166: DBMS_LOCK.sleep (30);

1162: END IF;
1163:
1164: l_cnt := l_cnt + 1;
1165: -- wait for 30 seconds before attempting to lock again
1166: DBMS_LOCK.sleep (30);
1167: ELSE
1168: RAISE;
1169: END IF;
1170: END; -- anonymous PL/SQL block to trap lock exception