132: l_text:='
133: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
134: --
135: l_text:='
136: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
137: l_text:=l_text||'
138: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
139: l_text:='
140: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
388: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
389: l_text:=l_text||'';
390: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
391: l_text:='
392: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
393: l_text:=l_text||'
394: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
395: l_text:='
396: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
392: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
393: l_text:=l_text||'';
394: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
395: l_text:='
396: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
397: l_text:=l_text||'
398: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
399: l_text:='
400: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);