183: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
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||fnd_number.number_to_canonical(p_person_id);
188: l_text:=l_text||'
189: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
190: l_text:='
191: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
187: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
188: l_text:=l_text||'';
189: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
190: l_text:='
191: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
192: l_text:=l_text||'
193: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
194: l_text:='
195: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
191: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
192: l_text:=l_text||'';
193: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
194: l_text:='
195: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
196: l_text:=l_text||'
197: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
198: l_text:='
199: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
267: l_text:=l_text||irc_utilities_pkg.removeTags(p_title);
268: l_text:=l_text||'';
269: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
270: l_text:='
271: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
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||irc_utilities_pkg.removeTags(p_attribute_category);
543: l_text:=l_text||irc_utilities_pkg.removeTags(p_fast_path_employee);
544: l_text:=l_text||'';
545: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
546: l_text:='
547: l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);
548: l_text:=l_text||'
549: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
550: l_text:='
551: l_text:=l_text||fnd_date.date_to_canonical(p_hold_applicant_date_until);
623: l_text:=l_text||irc_utilities_pkg.removeTags(p_suffix);
624: l_text:=l_text||'';
625: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
626: l_text:='
627: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
628: l_text:=l_text||'
629: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
630: l_text:='
631: l_text:=l_text||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);
695: l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);
696: l_text:=l_text||'';
697: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
698: l_text:='
699: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
700: l_text:=l_text||'
701: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
702: l_text:='
703: l_text:=l_text||irc_utilities_pkg.removeTags(p_town_of_birth);
715: l_text:=l_text||irc_utilities_pkg.removeTags(p_global_person_id);
716: l_text:=l_text||'';
717: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
718: l_text:='
719: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);
720: l_text:=l_text||'
721: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
722: l_text:='
723: l_text:=l_text||irc_utilities_pkg.removeTags(p_npw_number);