103: l_text:='
104: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
105: --
106: l_text:='
107: l_text:=l_text||fnd_number.number_to_canonical(p_competence_element_id);
108: l_text:=l_text||'
109: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
110: l_text:='
111: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
107: l_text:=l_text||fnd_number.number_to_canonical(p_competence_element_id);
108: l_text:=l_text||'';
109: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
110: l_text:='
111: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
112: l_text:=l_text||'
113: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
114: l_text:='
115: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);
111: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
112: l_text:=l_text||'';
113: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
114: l_text:='
115: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);
116: l_text:=l_text||'
117: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
118: l_text:='
119: l_text:=l_text||fnd_number.number_to_canonical(p_high_proficiency_level_id);
115: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);
116: l_text:=l_text||'';
117: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
118: l_text:='
119: l_text:=l_text||fnd_number.number_to_canonical(p_high_proficiency_level_id);
120: l_text:=l_text||'
121: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
122: l_text:='
123: l_text:=l_text||fnd_number.number_to_canonical(p_weighting_level_id);
119: l_text:=l_text||fnd_number.number_to_canonical(p_high_proficiency_level_id);
120: l_text:=l_text||'';
121: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
122: l_text:='
123: l_text:=l_text||fnd_number.number_to_canonical(p_weighting_level_id);
124: l_text:=l_text||'
125: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
126: l_text:='
127: l_text:=l_text||fnd_number.number_to_canonical(p_rating_level_id);
123: l_text:=l_text||fnd_number.number_to_canonical(p_weighting_level_id);
124: l_text:=l_text||'';
125: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
126: l_text:='
127: l_text:=l_text||fnd_number.number_to_canonical(p_rating_level_id);
128: l_text:=l_text||'
129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
130: l_text:='
131: l_text:=l_text||irc_utilities_pkg.removeTags(p_mandatory);
147: l_text:=l_text||irc_utilities_pkg.removeTags(p_competence_type);
148: l_text:=l_text||'';
149: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
150: l_text:='
151: l_text:=l_text||fnd_number.number_to_canonical(p_normal_elapse_duration);
152: l_text:=l_text||'
153: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
154: l_text:='
155: l_text:=l_text||irc_utilities_pkg.removeTags(p_normal_elapse_duration_unit);
155: l_text:=l_text||irc_utilities_pkg.removeTags(p_normal_elapse_duration_unit);
156: l_text:=l_text||'';
157: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
158: l_text:='
159: l_text:=l_text||fnd_number.number_to_canonical(p_sequence_number);
160: l_text:=l_text||'
161: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
162: l_text:='
163: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_proficiency_level);
163: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_proficiency_level);
164: l_text:=l_text||'';
165: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
166: l_text:='
167: l_text:=l_text||fnd_number.number_to_canonical(p_line_score);
168: l_text:=l_text||'
169: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
170: l_text:='
171: l_text:=l_text||fnd_date.date_to_canonical(p_certification_date);
271: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
272: l_text:=l_text||'';
273: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
274: l_text:='
275: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_type_id);
276: l_text:=l_text||'
277: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
278: l_text:='
279: l_text:=l_text||irc_utilities_pkg.removeTags(p_unit_standard_type);
371: l_text:=l_text||fnd_date.date_to_canonical(p_achieved_date);
372: l_text:=l_text||'';
373: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
374: l_text:='
375: l_text:=l_text||fnd_number.number_to_canonical(p_appr_line_score);
376: l_text:=l_text||'
377: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
378: l_text:='';
379: --