93: l_text:='
94: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
95: --
96: l_text:='
97: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
98: l_text:=l_text||'
99: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
100: l_text:='
101: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
269: l_text:=l_text||irc_utilities_pkg.removeTags(p_employment_category);
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_effective_start_date);
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_date.date_to_canonical(p_effective_end_date);
273: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
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_date.date_to_canonical(p_effective_end_date);
278: l_text:=l_text||'
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
280: l_text:='
281: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);