I've developed an application for leave management system. When a person applies for leave, a mail is sent to Manager for approval(done by using the api). However, the from_date and to_date are not being sent. Null values are printed for those values. The following is the api that I have used in the process.Please help me resolve this. Thanks in advance.
l_body := 'Leave applied from '||to_date(nvl(:P10_REQUEST_FROM_DATE,sysdate),'DD/MON/YYYY')||' to '||to_date(nvl(:P10_REQUEST_TO_DATE,sysdate),'DD/MON/YYYY')||utl_tcp.crlf||utl_tcp.crlf;