DBA Data[Home] [Help]

APPS.OTA_CHT_XMLP_PKG dependencies on FND_DATE

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;