146: l_text:='
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: --
149: l_text:='
150: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
151: l_text:=l_text||'
152: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
153: l_text:='
154: l_text:=l_text||fnd_number.number_to_canonical(p_element_type_id);
582: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
583: l_text:=l_text||'';
584: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
585: l_text:='
586: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
587: l_text:=l_text||'
588: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
589: l_text:='
590: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
586: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
587: l_text:=l_text||'';
588: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
589: l_text:='
590: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
591: l_text:=l_text||'
592: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
593: l_text:='';
594: --