FND_DATE.CANONICAL_TO_DATE

Hi All,

We've requirement to schedule purge sign on audit data purge program from backend directly incase if its not scheduled . I've not pasted the complete pl/sql block but i've pasted only the one i needed to clarify.

As per the schedule only for the first run arugment1 with sysdate - 4 is considered but where as for next subsequent runs parameter is not being passed and taking null instead. Can anybody pls help in this case.

l_conc_id := fnd_request.submit_request 
                      (application => 'FND'
                       ,program     => 'FNDSCPRG'
                       ,start_time  => to_char(sysdate,'DD-MON-YYYY') || ' 19:30:00'
         ,argument1   => FND_DATE.CANONICAL_TO_DATE(sysdate -4)
         ,argument2 => chr(0)
                       );
      dbms_output.put_line('submit request successful, cond id is ' || l_conc_id);