127: l_text:='
128: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
129: --
130: l_text:='
131: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
132: l_text:=l_text||'
133: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
134: l_text:='
135: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
471: l_text:=l_text||fnd_number.number_to_canonical(p_deduction_element_type_id);
472: l_text:=l_text||'';
473: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
474: l_text:='
475: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
476: l_text:=l_text||'
477: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
478: l_text:='
479: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
475: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
476: l_text:=l_text||'';
477: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
478: l_text:='
479: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
480: l_text:=l_text||'
481: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
482: l_text:='
483: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);