136: l_text:='
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: --
139: l_text:='
140: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
141: l_text:=l_text||'
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='
144: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
248: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);
249: l_text:=l_text||'';
250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
251: l_text:='
252: l_text:=l_text||fnd_date.date_to_canonical(p_projected_assignment_end);
253: l_text:=l_text||'
254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
255: l_text:='
256: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
508: end if;
509: l_text:=l_text||'';
510: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
511: l_text:='
512: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
513: l_text:=l_text||'
514: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
515: l_text:='
516: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
512: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
513: l_text:=l_text||'';
514: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
515: l_text:='
516: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
517: l_text:=l_text||'
518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
519: l_text:='
520: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);