Line 35: select fnd_date.date_to_displaydate(to_date(substr((P_MESSAGE_START_DATE),1,10),'yyyy/mm/dd'))
31: END C_CHAT_CONTENT_TYPE_p;
32:
33: Function C_FROM_DATE_p return varchar2 is
34: Begin 35: select fnd_date.date_to_displaydate(to_date(substr((P_MESSAGE_START_DATE),1,10),'yyyy/mm/dd')) 36: into C_FROM_DATE
37: from dual;
38: return C_FROM_DATE;
39: END;
Line 43: select fnd_date.date_to_displaydate(to_date(substr((P_MESSAGE_END_DATE),1,10),'yyyy/mm/dd'))
39: END;
40:
41: Function C_TO_DATE_p return varchar2 is
42: Begin 43: select fnd_date.date_to_displaydate(to_date(substr((P_MESSAGE_END_DATE),1,10),'yyyy/mm/dd')) 44: into C_TO_DATE
45: from dual;
46: return C_TO_DATE;
47: END;