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_vacancy_id);
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||irc_utilities_pkg.removeTags(p_variable_comp_lookup);
51: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
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||fnd_number.number_to_canonical(p_object_version_number);
56: l_text:=l_text||'
57: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
58: l_text:='';
59: --