Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE inbound (
  application_id VARCHAR2(20),
  filename       VARCHAR2(20),
  status         VARCHAR2(20),
  CREATEDAT      DATE,
  LAST_UPDATEDAT DATE
);
CREATE PACKAGE pkg_name IS
PROCEDURE pickup(
  app_id    IN  INBOUND.APPLICATION_ID%TYPE,
  Interval  IN  NUMBER,
  filename_ OUT INBOUND.FILENAME%TYPE,
  status_   OUT INBOUND.STATUS%TYPE
);
END;
/
CREATE PACKAGE BODY pkg_name IS

PROCEDURE pickup(
  app_id    IN  INBOUND.APPLICATION_ID%TYPE,
  Interval  IN  NUMBER,
  filename_ OUT INBOUND.FILENAME%TYPE,
  status_   OUT INBOUND.STATUS%TYPE
) IS
BEGIN
  SELECT filename, status
  INTO filename_, status_
  FROM INBOUND
  WHERE ROWID IN (
    SELECT ROWID
    FROM   INBOUND
    WHERE  status IN ( 'error', 'retry') 
    AND application_id IS NULL
    AND CREATEDAT < sysdate - 1/(24*60)
    AND (LAST_UPDATEDAT IS NULL OR LAST_UPDATEDAT < sysdate - Interval/(24*60))
    ORDER BY LAST_UPDATEDAT NULLS FIRST
    FETCH FIRST ROW ONLY
  )
  FOR UPDATE NOWAIT;

  UPDATE INBOUND SET application_id = app_id WHERE filename = filename_;
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    filename_ := 'Not found.';
END pickup;
END;
/
INSERT INTO inbound ( filename, status, CREATEDAT, LAST_UPDATEDAT )
SELECT 'abc', 'error', SYSDATE - INTERVAL '3' HOUR, NULL FROM DUAL UNION ALL
SELECT 'def', 'retry', SYSDATE - INTERVAL '2' HOUR, SYSDATE FROM DUAL;
2 rows affected

DECLARE
  fn INBOUND.FILENAME%TYPE;
  st INBOUND.STATUS%TYPE;
BEGIN
  pkg_name.pickup(
    app_id    => 'E42',
    interval  => 0,
    filename_ => fn,
    status_   => st
  );
  COMMIT;
  DBMS_OUTPUT.PUT_LINE( fn || ', ' || st );
END;
/
1 rows affected

dbms_output:
abc, error

SELECT * FROM inbound;


APPLICATION_ID
FILENAME
STATUS
CREATEDAT
LAST_UPDATEDAT


E42
abc
error
21-OCT-20
null

null
def
retry
21-OCT-20
21-OCT-20