123: l_text:='
124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
125: --
126: l_text:='
127: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
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||fnd_number.number_to_canonical(p_booking_id);
159: l_text:=l_text||fnd_number.number_to_canonical(p_authorizer_person_id);
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_date_booking_placed);
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||irc_utilities_pkg.removeTags(p_corespondent);
223: l_text:=l_text||irc_utilities_pkg.removeTags(p_third_party_contact_fax);
224: l_text:=l_text||'';
225: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
226: l_text:='
227: l_text:=l_text||fnd_date.date_to_canonical(p_date_status_changed);
228: l_text:=l_text||'
229: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
230: l_text:='
231: l_text:=l_text||irc_utilities_pkg.removeTags(p_status_change_comments);