DBA Data[Home] [Help]

APPS.OTA_OTARPSIS_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 133: select fnd_date.date_to_displaydate(to_date(substr((p_course_end_date),1,10),'yyyy/mm/dd'))

129: end;
130:
131: function CF_course_end_dateFormula return Char is
132: begin
133: select fnd_date.date_to_displaydate(to_date(substr((p_course_end_date),1,10),'yyyy/mm/dd'))
134: into cp_course_end_date
135: from dual;
136:
137: return(to_char(null));

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

138: end;
139:
140: function CF_course_start_dateFormula return Char is
141: begin
142: select fnd_date.date_to_displaydate(to_date(substr((p_course_start_date),1,10),'yyyy/mm/dd'))
143: into cp_course_start_date
144: from dual;
145:
146: return(to_char(null));