ignored in stored procedure with clause
date in_date, date in_date_end: that is incorrect syntax. Use TO_DATE with the appropriate format string, example: to_date(in_date_end, 'YYYY-MM-DD').

But date values should be passed with DATE type, not VARCHAR2 and all the above becomes unnecessary.