19: Function C_FROM_DATE_p return varchar2 is
20: Begin
21: select fnd_date.date_to_displaydate(to_date(substr((P_FROM_DATE),1,10),'yyyy/mm/dd'),calendar_aware)
22: into C_FROM_DATE
23: from dual;
24: return C_FROM_DATE;
25: END;
26:
27: Function C_TO_DATE_p return varchar2 is
27: Function C_TO_DATE_p return varchar2 is
28: Begin
29: select fnd_date.date_to_displaydate(to_date(substr((P_TO_DATE),1,10),'yyyy/mm/dd'),calendar_aware)
30: into C_TO_DATE
31: from dual;
32: return C_TO_DATE;
33: END;
34:
35: END ota_frm_xmlp_pkg;