Code:
create table jira_upload(id_num number,filename varchar2(50));

insert into jira_upload values(1,'test');
Code:
create or replace procedure sp_jira(
id_req IN jira_upload.id_num%type,
err_msg OUT varchar2)
as
lv_count number;
begin

select id_num into lv_count from jira_upload where id_num = id_req;

if lv_count is null then
err_msg := 'ID missing';
...