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