APPS.OTA_OTARPATT_XMLP_PKG dependencies on FND_DATE

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

72: p_trainer_and := p_trainer_and || ' AND rb.event_id = :p_event_id';
73: END IF;
74:
75: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NOT NULL) THEN
76: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)
77: AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
78: END IF;
79:
80: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NULL) THEN

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

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

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

77: AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
78: END IF;
79:
80: IF (p_course_start_date IS NOT NULL AND p_course_end_date IS NULL) THEN
81: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)';
82: END IF;
83:
84: IF (p_course_start_date IS NULL AND p_course_end_date IS NOT NULL) THEN
85: p_and := p_and || ' AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';

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

81: p_and := p_and || ' AND evt.course_start_date = fnd_date.canonical_to_date(:p_course_start_date)';
82: END IF;
83:
84: IF (p_course_start_date IS NULL AND p_course_end_date IS NOT NULL) THEN
85: p_and := p_and || ' AND evt.course_end_date = fnd_date.canonical_to_date(:p_course_end_date)';
86: END IF;
87:
88: IF p_training_center_id IS NOT NULL THEN
89: p_and := p_and || ' AND evt.training_center_id = :p_training_center_id';

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

157: end;
158:
159: function CF_course_end_dateFormula return Char is
160: begin
161: select fnd_date.date_to_displaydate(to_date(substr((p_course_end_date),1,10),'yyyy/mm/dd'),calendar_aware)
162: into cp_course_end_date
163: from dual;
164:
165: return(to_char(null));

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

166: end;
167:
168: function CF_course_start_dateFormula return Char is
169: begin
170: select fnd_date.date_to_displaydate(to_date(substr((p_course_start_date),1,10),'yyyy/mm/dd'),calendar_aware)
171: into cp_course_start_date
172: from dual;
173:
174: return(to_char(null));