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