107: l_text:='
108: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
109: --
110: l_text:='
111: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
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_qualification_id);
131: l_text:=l_text||irc_utilities_pkg.removeTags(p_status);
132: l_text:=l_text||'';
133: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
134: l_text:='
135: l_text:=l_text||fnd_date.date_to_canonical(p_awarded_date);
136: l_text:=l_text||'
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: l_text:='
139: l_text:=l_text||fnd_number.number_to_canonical(p_fee);
159: l_text:=l_text||fnd_number.number_to_canonical(p_total_training_amount);
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||fnd_date.date_to_canonical(p_start_date);
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_date.date_to_canonical(p_end_date);
163: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
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_date.date_to_canonical(p_end_date);
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||irc_utilities_pkg.removeTags(p_license_number);
171: l_text:=l_text||irc_utilities_pkg.removeTags(p_license_number);
172: l_text:=l_text||'';
173: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
174: l_text:='
175: l_text:=l_text||fnd_date.date_to_canonical(p_expiry_date);
176: l_text:=l_text||'
177: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
178: l_text:='
179: l_text:=l_text||irc_utilities_pkg.removeTags(p_license_restrictions);
179: l_text:=l_text||irc_utilities_pkg.removeTags(p_license_restrictions);
180: l_text:=l_text||'';
181: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
182: l_text:='
183: l_text:=l_text||fnd_date.date_to_canonical(p_projected_completion_date);
184: l_text:=l_text||'
185: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186: l_text:='
187: l_text:=l_text||irc_utilities_pkg.removeTags(p_awarding_body);