APPS.FND_JAF_LOG_EVENT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 44

    SELECT *
    FROM FND_JAF_EVENT_LOG
    WHERE start_timestamp =
      (SELECT NVL(MAX(start_timestamp),0)
      FROM FND_JAF_EVENT_LOG
      WHERE request_id = p_request_id
      AND event_name   = p_event_name
      AND event_type   = 'SEND'
      ) FOR UPDATE;

Line: 63

    INSERT
    INTO FND_JAF_EVENT_LOG
      (
        request_id,
        event_name,
        event_type,
        start_timestamp,
        prev_event_name,
        grand_prev_event_name
      )
      VALUES
      (
        p_request_id,
        p_event_name,
        p_event_type,
        l_timestamp_value,
        p_prev_event_payload,
        p_grand_prev_event_payload
      );

Line: 85

    UPDATE FND_JAF_EVENT_LOG
    SET end_timestamp = l_timestamp_value,
      event_type      = p_event_type
    WHERE CURRENT OF fnd_jaf_event_log_cur;