APPS.HR_ASSIGNMENT_BE2 dependencies on FND_DATE

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

167: l_text:='';
168: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
169: --
170: l_text:='';
171: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
172: l_text:=l_text||'';
173: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
174: l_text:='';
175: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);

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

203: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
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_date_probation_end);
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||fnd_number.number_to_canonical(p_default_code_comb_id);

Line 547: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);

543: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
544: l_text:=l_text||'';
545: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
546: l_text:='';
547: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
548: l_text:=l_text||'';
549: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
550: l_text:='';
551: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);

Line 551: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);

547: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
548: l_text:=l_text||'';
549: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
550: l_text:='';
551: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
552: l_text:=l_text||'';
553: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
554: l_text:='';
555: if(P_NO_MANAGERS_WARNING) then