209: l_text:='
210: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
211: --
212: l_text:='
213: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
214: l_text:=l_text||'
215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
216: l_text:='
217: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
269: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
270: l_text:=l_text||'';
271: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
272: l_text:='
273: l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);
274: l_text:=l_text||'
275: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
276: l_text:='
277: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
865: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
866: l_text:=l_text||'';
867: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
868: l_text:='
869: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
870: l_text:=l_text||'
871: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
872: l_text:='
873: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
869: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
870: l_text:=l_text||'';
871: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
872: l_text:='
873: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
874: l_text:=l_text||'
875: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
876: l_text:='
877: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);