create or replace procedure test123 (P_From_Date In date,
                                     P_To_date In Date,
                                     P_Out out SYS_REFCURSOR)
as
  start_date number;
  end_date number;
  business_date varchar2(20);
begin
  start_date := to_number(to_char(to_date(P_From_Date, 'DD-mm-yy'), 'j'));
  end_date := to_number(to_char(to_date(P_To_Date, 'DD-mm-yy'), 'j'));
  
       for i in start_date..end_date loop
    business_date := to_char(to_date(i, 'j'), 'YYYY-MM-DD');

  dbms_output.put_line(business_date);

  open P_Out for   Select
        File_Name,(case when (Select '1'  From  master_table 
    Where
        Trim(Upper(Frequency)) = 'WEEKLY'
       And Replace(Upper(Schedule_Days), Trim(To_Char(to_date(business_date,'YYYY-MM-DD'), 'DAY')), '$') Like '%$%'
        And ( Id ) In (
            Select  TranId
            From Transaction_Table)
            and rownum=1)=1 then 'X' End  ) "Exchanged"  From  master_table ;
 end loop;
end;

SQL> insert into Transaction_table values(1,'ABC_123','06-Jul-2020');
insert into Transaction_table values(1,'ABC_123','06-Jul-2020')
                                                 *
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected