58:
59:
60:
61: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NOT NULL) THEN
62: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)
63: AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
64: END IF;
65:
66:
59:
60:
61: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NOT NULL) THEN
62: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)
63: AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
64: END IF;
65:
66:
67: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NULL) THEN
64: END IF;
65:
66:
67: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NULL) THEN
68: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)';
69: END IF;
70:
71: IF (p_course_start_date IS NULL AND p_course_end_date IS NOT NULL) THEN
72: p_and := p_and || ' AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
68: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)';
69: END IF;
70:
71: IF (p_course_start_date IS NULL AND p_course_end_date IS NOT NULL) THEN
72: p_and := p_and || ' AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
73: END IF;
74:
75: IF p_training_center_id IS NOT NULL THEN
76: p_and := p_and || ' AND evt.training_center_id = :p_training_center_id';
106: return Char
107: is
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));
139: 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;
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));