117: l_text:='
118: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
119: --
120: l_text:='
121: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
122: l_text:=l_text||'
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='
125: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
421: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information30);
422: l_text:=l_text||'';
423: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
424: l_text:='
425: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
426: l_text:=l_text||'
427: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
428: l_text:='
429: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);