Line 19: select fnd_date.date_to_displaydate(to_date(substr((P_FROM_DATE),1,10),'yyyy/mm/dd'))
15: END C_FORUM_NAME_p;
16:
17: Function C_FROM_DATE_p return varchar2 is
18: Begin 19: select fnd_date.date_to_displaydate(to_date(substr((P_FROM_DATE),1,10),'yyyy/mm/dd')) 20: into C_FROM_DATE
21: from dual;
22: return C_FROM_DATE;
23: END;
Line 27: select fnd_date.date_to_displaydate(to_date(substr((P_TO_DATE),1,10),'yyyy/mm/dd'))
23: END;
24:
25: Function C_TO_DATE_p return varchar2 is
26: Begin 27: select fnd_date.date_to_displaydate(to_date(substr((P_TO_DATE),1,10),'yyyy/mm/dd')) 28: into C_TO_DATE
29: from dual;
30: return C_TO_DATE;
31: END;