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_classification_id);
500: l_text:=l_text||fnd_number.number_to_canonical(p_element_type_id);
501: l_text:=l_text||'';
502: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
503: l_text:='
504: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
505: l_text:=l_text||'
506: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
507: l_text:='
508: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
504: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
505: l_text:=l_text||'';
506: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
507: l_text:='
508: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
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_number.number_to_canonical(p_object_version_number);