212: l_text:='
213: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
214: --
215: l_text:='
216: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
217: l_text:=l_text||'
218: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
219: l_text:='
220: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
296: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
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_date_probation_end);
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||fnd_number.number_to_canonical(p_default_code_comb_id);
748: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
749: l_text:=l_text||'';
750: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
751: l_text:='
752: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
753: l_text:=l_text||'
754: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
755: l_text:='
756: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
752: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
753: l_text:=l_text||'';
754: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
755: l_text:='
756: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
757: l_text:=l_text||'
758: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
759: l_text:='
760: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);