157: l_text:=l_text||fnd_date.date_to_canonical(p_date_booking_placed);
158: l_text:=l_text||'';
159: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
160: l_text:='
161: l_text:=l_text||irc_utilities_pkg.removeTags(p_corespondent);
162: l_text:=l_text||'
163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
164: l_text:='
165: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_booking_flag);
161: l_text:=l_text||irc_utilities_pkg.removeTags(p_corespondent);
162: l_text:=l_text||'';
163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
164: l_text:='
165: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_booking_flag);
166: l_text:=l_text||'
167: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
168: l_text:='
169: l_text:=l_text||fnd_number.number_to_canonical(p_number_of_places);
173: l_text:=l_text||fnd_number.number_to_canonical(p_administrator);
174: l_text:=l_text||'';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: l_text:='
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_booking_priority);
178: l_text:=l_text||'
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='
181: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_booking_priority);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='
181: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
182: l_text:=l_text||'
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='
185: l_text:=l_text||fnd_number.number_to_canonical(p_contact_address_id);
185: l_text:=l_text||fnd_number.number_to_canonical(p_contact_address_id);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
188: l_text:='
189: l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_phone);
190: l_text:=l_text||'
191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
192: l_text:='
193: l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_fax);
189: l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_phone);
190: l_text:=l_text||'';
191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
192: l_text:='
193: l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_fax);
194: l_text:=l_text||'
195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
196: l_text:='
197: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_customer_id);
205: l_text:=l_text||fnd_number.number_to_canonical(p_third_party_address_id);
206: l_text:=l_text||'';
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
208: l_text:='
209: l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_contact_phone);
210: l_text:=l_text||'
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='
213: l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_contact_fax);
209: l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_contact_phone);
210: l_text:=l_text||'';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='
213: l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_contact_fax);
214: l_text:=l_text||'
215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
216: l_text:='
217: l_text:=l_text||fnd_date.date_to_canonical(p_date_status_changed);
217: l_text:=l_text||fnd_date.date_to_canonical(p_date_status_changed);
218: l_text:=l_text||'';
219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
220: l_text:='
221: l_text:=l_text||irc_utilities_pkg.removeTags(p_failure_reason);
222: l_text:=l_text||'
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='
225: l_text:=l_text||irc_utilities_pkg.removeTags(p_attendance_result);
221: l_text:=l_text||irc_utilities_pkg.removeTags(p_failure_reason);
222: l_text:=l_text||'';
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='
225: l_text:=l_text||irc_utilities_pkg.removeTags(p_attendance_result);
226: l_text:=l_text||'
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='
229: l_text:=l_text||fnd_number.number_to_canonical(p_language_id);
229: l_text:=l_text||fnd_number.number_to_canonical(p_language_id);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='
233: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_booking);
234: l_text:=l_text||'
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='
237: l_text:=l_text||irc_utilities_pkg.removeTags(p_special_booking_instructions);
233: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_booking);
234: l_text:=l_text||'';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='
237: l_text:=l_text||irc_utilities_pkg.removeTags(p_special_booking_instructions);
238: l_text:=l_text||'
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='
241: l_text:=l_text||irc_utilities_pkg.removeTags(p_successful_attendance_flag);
237: l_text:=l_text||irc_utilities_pkg.removeTags(p_special_booking_instructions);
238: l_text:=l_text||'';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='
241: l_text:=l_text||irc_utilities_pkg.removeTags(p_successful_attendance_flag);
242: l_text:=l_text||'
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='
245: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information_category);
241: l_text:=l_text||irc_utilities_pkg.removeTags(p_successful_attendance_flag);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='
245: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information_category);
246: l_text:=l_text||'
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='
249: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information1);
245: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information_category);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='
249: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information1);
250: l_text:=l_text||'
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='
253: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information2);
249: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information1);
250: l_text:=l_text||'';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='
253: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information2);
254: l_text:=l_text||'
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='
257: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information3);
253: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information2);
254: l_text:=l_text||'';
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='
257: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information3);
258: l_text:=l_text||'
259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
260: l_text:='
261: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information4);
257: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information3);
258: l_text:=l_text||'';
259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
260: l_text:='
261: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information4);
262: l_text:=l_text||'
263: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
264: l_text:='
265: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information5);
261: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information4);
262: l_text:=l_text||'';
263: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
264: l_text:='
265: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information5);
266: l_text:=l_text||'
267: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
268: l_text:='
269: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information6);
265: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information5);
266: l_text:=l_text||'';
267: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
268: l_text:='
269: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information6);
270: l_text:=l_text||'
271: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
272: l_text:='
273: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information7);
269: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information6);
270: l_text:=l_text||'';
271: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
272: l_text:='
273: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information7);
274: l_text:=l_text||'
275: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
276: l_text:='
277: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information8);
273: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information7);
274: l_text:=l_text||'';
275: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
276: l_text:='
277: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information8);
278: l_text:=l_text||'
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
280: l_text:='
281: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information9);
277: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information8);
278: l_text:=l_text||'';
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
280: l_text:='
281: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information9);
282: l_text:=l_text||'
283: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
284: l_text:='
285: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information10);
281: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information9);
282: l_text:=l_text||'';
283: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
284: l_text:='
285: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information10);
286: l_text:=l_text||'
287: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
288: l_text:='
289: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information11);
285: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information10);
286: l_text:=l_text||'';
287: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
288: l_text:='
289: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information11);
290: l_text:=l_text||'
291: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
292: l_text:='
293: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information12);
289: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information11);
290: l_text:=l_text||'';
291: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
292: l_text:='
293: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information12);
294: l_text:=l_text||'
295: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
296: l_text:='
297: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information13);
293: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information12);
294: l_text:=l_text||'';
295: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
296: l_text:='
297: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information13);
298: l_text:=l_text||'
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='
301: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information14);
297: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information13);
298: l_text:=l_text||'';
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='
301: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information14);
302: l_text:=l_text||'
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
304: l_text:='
305: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information15);
301: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information14);
302: l_text:=l_text||'';
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
304: l_text:='
305: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information15);
306: l_text:=l_text||'
307: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
308: l_text:='
309: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information16);
305: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information15);
306: l_text:=l_text||'';
307: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
308: l_text:='
309: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information16);
310: l_text:=l_text||'
311: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
312: l_text:='
313: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information17);
309: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information16);
310: l_text:=l_text||'';
311: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
312: l_text:='
313: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information17);
314: l_text:=l_text||'
315: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
316: l_text:='
317: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information18);
313: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information17);
314: l_text:=l_text||'';
315: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
316: l_text:='
317: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information18);
318: l_text:=l_text||'
319: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
320: l_text:='
321: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information19);
317: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information18);
318: l_text:=l_text||'';
319: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
320: l_text:='
321: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information19);
322: l_text:=l_text||'
323: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
324: l_text:='
325: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information20);
321: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information19);
322: l_text:=l_text||'';
323: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
324: l_text:='
325: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information20);
326: l_text:=l_text||'
327: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
328: l_text:='
329: l_text:=l_text||irc_utilities_pkg.removeTags(p_create_finance_line);
325: l_text:=l_text||irc_utilities_pkg.removeTags(p_tdb_information20);
326: l_text:=l_text||'';
327: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
328: l_text:='
329: l_text:=l_text||irc_utilities_pkg.removeTags(p_create_finance_line);
330: l_text:=l_text||'
331: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
332: l_text:='
333: l_text:=l_text||fnd_number.number_to_canonical(p_finance_header_id);
333: l_text:=l_text||fnd_number.number_to_canonical(p_finance_header_id);
334: l_text:=l_text||'';
335: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
336: l_text:='
337: l_text:=l_text||irc_utilities_pkg.removeTags(p_currency_code);
338: l_text:=l_text||'
339: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
340: l_text:='
341: l_text:=l_text||fnd_number.number_to_canonical(p_standard_amount);
353: l_text:=l_text||fnd_number.number_to_canonical(p_booking_deal_id);
354: l_text:=l_text||'';
355: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
356: l_text:='
357: l_text:=l_text||irc_utilities_pkg.removeTags(p_booking_deal_type);
358: l_text:=l_text||'
359: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
360: l_text:='
361: l_text:=l_text||fnd_number.number_to_canonical(p_finance_line_id);
361: l_text:=l_text||fnd_number.number_to_canonical(p_finance_line_id);
362: l_text:=l_text||'';
363: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
364: l_text:='
365: l_text:=l_text||irc_utilities_pkg.removeTags(p_enrollment_type);
366: l_text:=l_text||'
367: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
368: l_text:='
369: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
389: l_text:=l_text||fnd_number.number_to_canonical(p_delegate_contact_id);
390: l_text:=l_text||'';
391: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
392: l_text:='
393: l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_email);
394: l_text:=l_text||'
395: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
396: l_text:='
397: l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_email);
393: l_text:=l_text||irc_utilities_pkg.removeTags(p_delegate_contact_email);
394: l_text:=l_text||'';
395: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
396: l_text:='
397: l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_email);
398: l_text:=l_text||'
399: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
400: l_text:='
401: l_text:=l_text||irc_utilities_pkg.removeTags(p_person_address_type);
397: l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_email);
398: l_text:=l_text||'';
399: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
400: l_text:='
401: l_text:=l_text||irc_utilities_pkg.removeTags(p_person_address_type);
402: l_text:=l_text||'
403: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
404: l_text:='
405: l_text:=l_text||fnd_number.number_to_canonical(p_line_id);
409: l_text:=l_text||fnd_number.number_to_canonical(p_org_id);
410: l_text:=l_text||'';
411: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
412: l_text:='
413: l_text:=l_text||irc_utilities_pkg.removeTags(p_daemon_flag);
414: l_text:=l_text||'
415: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
416: l_text:='
417: l_text:=l_text||irc_utilities_pkg.removeTags(p_daemon_type);
413: l_text:=l_text||irc_utilities_pkg.removeTags(p_daemon_flag);
414: l_text:=l_text||'';
415: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
416: l_text:='
417: l_text:=l_text||irc_utilities_pkg.removeTags(p_daemon_type);
418: l_text:=l_text||'
419: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
420: l_text:='
421: l_text:=l_text||fnd_number.number_to_canonical(p_old_event_id);
425: l_text:=l_text||fnd_number.number_to_canonical(p_quote_line_id);
426: l_text:=l_text||'';
427: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
428: l_text:='
429: l_text:=l_text||irc_utilities_pkg.removeTags(p_interface_source);
430: l_text:=l_text||'
431: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
432: l_text:='
433: l_text:=l_text||irc_utilities_pkg.removeTags(p_total_training_time);
429: l_text:=l_text||irc_utilities_pkg.removeTags(p_interface_source);
430: l_text:=l_text||'';
431: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
432: l_text:='
433: l_text:=l_text||irc_utilities_pkg.removeTags(p_total_training_time);
434: l_text:=l_text||'
435: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
436: l_text:='
437: l_text:=l_text||irc_utilities_pkg.removeTags(p_content_player_status);
433: l_text:=l_text||irc_utilities_pkg.removeTags(p_total_training_time);
434: l_text:=l_text||'';
435: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
436: l_text:='
437: l_text:=l_text||irc_utilities_pkg.removeTags(p_content_player_status);
438: l_text:=l_text||'
439: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
440: l_text:='
441: l_text:=l_text||fnd_number.number_to_canonical(p_score);
453: l_text:=l_text||fnd_number.number_to_canonical(p_booking_justification_id);
454: l_text:=l_text||'';
455: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
456: l_text:='
457: l_text:=l_text||irc_utilities_pkg.removeTags(p_is_history_flag);
458: l_text:=l_text||'
459: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
460: l_text:='
461: l_text:=l_text||irc_utilities_pkg.removeTags(p_is_mandatory_enrollment);
457: l_text:=l_text||irc_utilities_pkg.removeTags(p_is_history_flag);
458: l_text:=l_text||'';
459: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
460: l_text:='
461: l_text:=l_text||irc_utilities_pkg.removeTags(p_is_mandatory_enrollment);
462: l_text:=l_text||'
463: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
464: l_text:='
465: l_text:=l_text||fnd_number.number_to_canonical(p_booking_id);