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);
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);
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);
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