Line 50: select fnd_date.date_to_displaydate(to_date(substr((P_FROM_DATE),1,10),'yyyy/mm/dd'))
46: END C_ANSWER_TYPE_p;
47:
48: Function C_FROM_DATE_p return varchar2 is
49: Begin 50: select fnd_date.date_to_displaydate(to_date(substr((P_FROM_DATE),1,10),'yyyy/mm/dd')) 51: into C_FROM_DATE
52: from dual;
53: return C_FROM_DATE;
54: END;
Line 58: select fnd_date.date_to_displaydate(to_date(substr((P_TO_DATE),1,10),'yyyy/mm/dd'))
54: END;
55:
56: Function C_TO_DATE_p return varchar2 is
57: Begin 58: select fnd_date.date_to_displaydate(to_date(substr((P_TO_DATE),1,10),'yyyy/mm/dd')) 59: into C_TO_DATE
60: from dual;
61: return C_TO_DATE;
62: END;