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