76: l_text:=l_text||fnd_date.date_to_canonical(p_certification_date);
77: l_text:=l_text||'';
78: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
79: l_text:='
80: l_text:=l_text||irc_utilities_pkg.removeTags(p_certification_method);
81: l_text:=l_text||'
82: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
83: l_text:='
84: l_text:=l_text||fnd_date.date_to_canonical(p_next_certification_date);
84: l_text:=l_text||fnd_date.date_to_canonical(p_next_certification_date);
85: l_text:=l_text||'';
86: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
87: l_text:='
88: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_proficiency_level);
89: l_text:=l_text||'
90: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
91: l_text:='
92: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
88: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_proficiency_level);
89: l_text:=l_text||'';
90: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
91: l_text:='
92: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
93: l_text:=l_text||'
94: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
95: l_text:='
96: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);