111: begin
112:
113: select fnd_date.date_to_displaydate(sysdate,calendar_aware)
114: into cp_current_date
115: from dual;
116:
117: return(to_char(null));
118:
119: end;
143:
144: function CF_session_dateFormula return Char is
145: begin
146: select fnd_date.date_to_displaydate((p_session_date),calendar_aware) into cp_session_date
147: from dual;
148:
149: return (to_char(NULL));
150: end;
151:
152: function CF_course_start_dateFormula return Char is
153: begin
154: select fnd_date.date_to_displaydate(to_date(substr((p_course_start_date),1,10),'yyyy/mm/dd'))
155: into cp_course_start_date
156: from dual;
157:
158: return(to_char(null));
159: end;
160:
161: function CF_course_end_dateFormula return Char is
162: begin
163: select fnd_date.date_to_displaydate(to_date(substr((p_course_end_date),1,10),'yyyy/mm/dd'))
164: into cp_course_end_date
165: from dual;
166:
167: return(to_char(null));
168: end;
169: