Line 21: select fnd_date.date_to_displaydate(to_date(substr((P_FROM_DATE),1,10),'yyyy/mm/dd'),calendar_aware)
17: END C_FORUM_NAME_p;
18:
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;
Line 29: select fnd_date.date_to_displaydate(to_date(substr((P_TO_DATE),1,10),'yyyy/mm/dd'),calendar_aware)
25: END;
26:
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;