APPS.HR_PERSON_ABSENCE_BE1 dependencies on FND_DATE

Line 132: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);

128: l_text:='';
129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
130: --
131: l_text:='';
132: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
133: l_text:=l_text||'';
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: l_text:='';
136: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

Line 156: l_text:=l_text||fnd_date.date_to_canonical(p_date_notification);

152: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
153: l_text:=l_text||'';
154: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
155: l_text:='';
156: l_text:=l_text||fnd_date.date_to_canonical(p_date_notification);
157: l_text:=l_text||'';
158: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
159: l_text:='';
160: l_text:=l_text||fnd_date.date_to_canonical(p_date_projected_start);

Line 160: l_text:=l_text||fnd_date.date_to_canonical(p_date_projected_start);

156: l_text:=l_text||fnd_date.date_to_canonical(p_date_notification);
157: l_text:=l_text||'';
158: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
159: l_text:='';
160: l_text:=l_text||fnd_date.date_to_canonical(p_date_projected_start);
161: l_text:=l_text||'';
162: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
163: l_text:='';
164: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_projected_start);

Line 168: l_text:=l_text||fnd_date.date_to_canonical(p_date_projected_end);

164: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_projected_start);
165: l_text:=l_text||'';
166: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
167: l_text:='';
168: l_text:=l_text||fnd_date.date_to_canonical(p_date_projected_end);
169: l_text:=l_text||'';
170: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
171: l_text:='';
172: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_projected_end);

Line 176: l_text:=l_text||fnd_date.date_to_canonical(p_date_start);

172: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_projected_end);
173: l_text:=l_text||'';
174: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
175: l_text:='';
176: l_text:=l_text||fnd_date.date_to_canonical(p_date_start);
177: l_text:=l_text||'';
178: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
179: l_text:='';
180: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_start);

Line 184: l_text:=l_text||fnd_date.date_to_canonical(p_date_end);

180: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_start);
181: l_text:=l_text||'';
182: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
183: l_text:='';
184: l_text:=l_text||fnd_date.date_to_canonical(p_date_end);
185: l_text:=l_text||'';
186: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
187: l_text:='';
188: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_end);

Line 308: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_start_date);

304: l_text:=l_text||fnd_number.number_to_canonical(p_maternity_id);
305: l_text:=l_text||'';
306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
307: l_text:='';
308: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_start_date);
309: l_text:=l_text||'';
310: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
311: l_text:='';
312: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_end_date);

Line 312: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_end_date);

308: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_start_date);
309: l_text:=l_text||'';
310: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
311: l_text:='';
312: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_end_date);
313: l_text:=l_text||'';
314: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
315: l_text:='';
316: l_text:=l_text||irc_utilities_pkg.removeTags(p_pregnancy_related_illness);