122: l_text:='
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: --
125: l_text:='
126: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
127: l_text:=l_text||'
128: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
129: l_text:='
130: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
446: l_text:=l_text||irc_utilities_pkg.removeTags(p_country_of_birth);
447: l_text:=l_text||'';
448: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
449: l_text:='
450: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
451: l_text:=l_text||'
452: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
453: l_text:='
454: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);