131: l_text:='
132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
133: --
134: l_text:='
135: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
136: l_text:=l_text||'
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: l_text:='
139: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
387: l_text:=l_text||fnd_number.number_to_canonical(p_external_account_id);
388: l_text:=l_text||'';
389: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
390: l_text:='
391: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
392: l_text:=l_text||'
393: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
394: l_text:='
395: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
391: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
392: l_text:=l_text||'';
393: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
394: l_text:='
395: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
396: l_text:=l_text||'
397: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
398: l_text:='
399: l_text:=l_text||irc_utilities_pkg.removeTags(p_ppm_information1);