eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

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

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

151: end;
152:
153: function CF_course_start_dateFormula return Char is
154: begin
155: select fnd_date.date_to_displaydate(to_date(substr((p_course_start_date),1,10),'yyyy/mm/dd'),calendar_aware)
156: into cp_course_start_date
157: from dual;
158:
159: return(to_char(null));