39: l_text:='
40: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
41: --
42: l_text:='
43: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_from);
44: l_text:=l_text||'
45: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
46: l_text:='
47: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_id);
43: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_from);
44: l_text:=l_text||'';
45: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
46: l_text:='
47: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_id);
48: l_text:=l_text||'
49: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
50: l_text:='
51: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_to);
47: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_id);
48: l_text:=l_text||'';
49: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
50: l_text:='
51: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_to);
52: l_text:=l_text||'
53: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
54: l_text:='
55: l_text:=l_text||irc_utilities_pkg.removeTags(p_competence_type);