139: l_text:='
140: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
141: --
142: l_text:='
143: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
144: l_text:=l_text||'
145: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
146: l_text:='
147: l_text:=l_text||fnd_number.number_to_canonical(p_element_link_id);
547: l_text:=l_text||irc_utilities_pkg.removeTags(p_balance_concat_segments_out);
548: l_text:=l_text||'';
549: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
550: l_text:='
551: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
552: l_text:=l_text||'
553: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
554: l_text:='
555: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
551: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
552: l_text:=l_text||'';
553: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
554: l_text:='
555: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
556: l_text:=l_text||'
557: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
558: l_text:='';
559: --