DBA Data[Home] [Help]

APPS.OTA_OTARPREG_XMLP_PKG dependencies on DUAL

Line 112: from dual;

108: begin
109:
110: select fnd_date.date_to_displaydate(sysdate)
111: into cp_current_date
112: from dual;
113:
114: return(to_char(null));
115:
116: end;

Line 144: from dual;

140:
141: function CF_session_dateFormula return Char is
142: begin
143: select fnd_date.date_to_displaydate(p_session_date) into cp_session_date
144: from dual;
145:
146: return (to_char(NULL));
147: end;
148:

Line 153: from dual;

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

Line 162: from dual;

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