APPS.HR_PERSON_ABSENCE_BE2 dependencies on FND_DATE

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

124: l_text:='';
125: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
126: --
127: l_text:='';
128: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
129: l_text:=l_text||'';
130: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
131: l_text:='';
132: l_text:=l_text||fnd_number.number_to_canonical(p_absence_attendance_id);

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

144: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
145: l_text:=l_text||'';
146: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
147: l_text:='';
148: l_text:=l_text||fnd_date.date_to_canonical(p_date_notification);
149: l_text:=l_text||'';
150: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
151: l_text:='';
152: l_text:=l_text||fnd_date.date_to_canonical(p_date_projected_start);

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

148: l_text:=l_text||fnd_date.date_to_canonical(p_date_notification);
149: l_text:=l_text||'';
150: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
151: l_text:='';
152: l_text:=l_text||fnd_date.date_to_canonical(p_date_projected_start);
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||irc_utilities_pkg.removeTags(p_time_projected_start);

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

156: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_projected_start);
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_end);
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_end);

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

164: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_projected_end);
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_start);
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_start);

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

172: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_start);
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_end);
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_end);

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

292: l_text:=l_text||fnd_number.number_to_canonical(p_maternity_id);
293: l_text:=l_text||'';
294: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
295: l_text:='';
296: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_start_date);
297: l_text:=l_text||'';
298: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
299: l_text:='';
300: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_end_date);

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

296: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_start_date);
297: l_text:=l_text||'';
298: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
299: l_text:='';
300: l_text:=l_text||fnd_date.date_to_canonical(p_sickness_end_date);
301: l_text:=l_text||'';
302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
303: l_text:='';
304: l_text:=l_text||irc_utilities_pkg.removeTags(p_pregnancy_related_illness);