APPS.OTA_OTARPATT_XMLP_PKG dependencies on FND_DATE

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

65: p_trainer_and := p_trainer_and || ' AND rb.event_id = :p_event_id';
66: END IF;
67:
68: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NOT NULL) THEN
69: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)
70: AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
71: END IF;
72:
73: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NULL) THEN

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

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

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

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

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

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

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

141: end;
142:
143: function CF_course_end_dateFormula return Char is
144: begin
145: select fnd_date.date_to_displaydate(to_date(substr((p_course_end_date),1,10),'yyyy/mm/dd'))
146: into cp_course_end_date
147: from dual;
148:
149: return(to_char(null));

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