69: l_text:='
70: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
71: --
72: l_text:='
73: l_text:=l_text||fnd_number.number_to_canonical(p_competence_element_id);
74: l_text:=l_text||'
75: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
76: l_text:='
77: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
73: l_text:=l_text||fnd_number.number_to_canonical(p_competence_element_id);
74: l_text:=l_text||'';
75: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
76: l_text:='
77: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
78: l_text:=l_text||'
79: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
80: l_text:='
81: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);
77: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
78: l_text:=l_text||'';
79: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
80: l_text:='
81: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);
82: l_text:=l_text||'
83: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
84: l_text:='
85: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date_from);
197: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
198: l_text:=l_text||'';
199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
200: l_text:='
201: l_text:=l_text||fnd_number.number_to_canonical(p_ins_ovn);
202: l_text:=l_text||'
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='
205: l_text:=l_text||fnd_number.number_to_canonical(p_ins_comp_id);
201: l_text:=l_text||fnd_number.number_to_canonical(p_ins_ovn);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='
205: l_text:=l_text||fnd_number.number_to_canonical(p_ins_comp_id);
206: l_text:=l_text||'
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
208: l_text:='';
209: --