111: l_text:='
112: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
113: --
114: l_text:='
115: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
116: l_text:=l_text||'
117: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
118: l_text:='
119: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
127: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
128: l_text:=l_text||'';
129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
130: l_text:='
131: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);
132: l_text:=l_text||'
133: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
134: l_text:='