APPS.OTA_OTARPREG_XMLP_PKG dependencies on FND_DATE

Line 65: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)

61:
62:
63:
64: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NOT NULL) THEN
65: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)
66: AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
67: END IF;
68:
69:

Line 66: AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';

62:
63:
64: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NOT NULL) THEN
65: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)
66: AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
67: END IF;
68:
69:
70: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NULL) THEN

Line 71: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)';

67: END IF;
68:
69:
70: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NULL) THEN
71: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)';
72: END IF;
73:
74: IF (p_course_start_date IS NULL AND p_course_end_date IS NOT NULL) THEN
75: p_and := p_and || ' AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';

Line 75: p_and := p_and || ' AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';

71: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)';
72: END IF;
73:
74: IF (p_course_start_date IS NULL AND p_course_end_date IS NOT NULL) THEN
75: p_and := p_and || ' AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
76: END IF;
77:
78: IF p_training_center_id IS NOT NULL THEN
79: p_and := p_and || ' AND evt.training_center_id = :p_training_center_id';

Line 113: select fnd_date.date_to_displaydate(sysdate,calendar_aware)

109: return Char
110: is
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));

Line 146: select fnd_date.date_to_displaydate((p_session_date),calendar_aware) into cp_session_date

142: 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;

Line 154: select fnd_date.date_to_displaydate(to_date(substr((p_course_start_date),1,10),'yyyy/mm/dd'))

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));

Line 163: select fnd_date.date_to_displaydate(to_date(substr((p_course_end_date),1,10),'yyyy/mm/dd'))

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));