APPS.HR_COMPETENCE_ELEMENT_BE1 dependencies on FND_DATE

Line 203: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);

199: l_text:=l_text||irc_utilities_pkg.removeTags(p_mandatory);
200: l_text:=l_text||'';
201: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
202: l_text:='';
203: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);
204: l_text:=l_text||'';
205: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
206: l_text:='';
207: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);

Line 207: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);

203: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);
204: l_text:=l_text||'';
205: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
206: l_text:='';
207: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_to);
208: l_text:=l_text||'';
209: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
210: l_text:='';
211: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_competence_type);

Line 239: l_text:=l_text||fnd_date.date_to_canonical(p_certification_date);

235: l_text:=l_text||fnd_number.number_to_canonical(p_line_score);
236: l_text:=l_text||'';
237: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
238: l_text:='';
239: l_text:=l_text||fnd_date.date_to_canonical(p_certification_date);
240: l_text:=l_text||'';
241: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
242: l_text:='';
243: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_method);

Line 247: l_text:=l_text||fnd_date.date_to_canonical(p_next_certification_date);

243: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_method);
244: l_text:=l_text||'';
245: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
246: l_text:='';
247: l_text:=l_text||fnd_date.date_to_canonical(p_next_certification_date);
248: l_text:=l_text||'';
249: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
250: l_text:='';
251: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

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

335: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
336: l_text:=l_text||'';
337: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
338: l_text:='';
339: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
340: l_text:=l_text||'';
341: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
342: l_text:='';
343: l_text:=l_text||fnd_number.number_to_canonical(p_object_id);

Line 451: l_text:=l_text||fnd_date.date_to_canonical(p_achieved_date);

447: l_text:=l_text||irc_utilities_pkg.removeTags(p_information20);
448: l_text:=l_text||'';
449: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
450: l_text:='';
451: l_text:=l_text||fnd_date.date_to_canonical(p_achieved_date);
452: l_text:=l_text||'';
453: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
454: l_text:='';
455: l_text:=l_text||fnd_number.number_to_canonical(p_appr_line_score);