179: l_text:=l_text||fnd_date.date_to_canonical(p_hire_date);
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_number.number_to_canonical(p_business_group_id);
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_last_name);
191: l_text:=l_text||irc_utilities_pkg.removeTags(p_sex);
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_per_comments);
255: l_text:=l_text||irc_utilities_pkg.removeTags(p_title);
256: l_text:=l_text||'';
257: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
258: l_text:='
259: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
260: l_text:=l_text||'
261: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
262: l_text:='
263: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_telephone);
535: l_text:=l_text||irc_utilities_pkg.removeTags(p_fast_path_employee);
536: l_text:=l_text||'';
537: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
538: l_text:='
539: l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);
540: l_text:=l_text||'
541: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
542: l_text:='
543: l_text:=l_text||irc_utilities_pkg.removeTags(p_honors);
603: l_text:=l_text||irc_utilities_pkg.removeTags(p_suffix);
604: l_text:=l_text||'';
605: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
606: l_text:='
607: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
608: l_text:=l_text||'
609: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
610: l_text:='
611: l_text:=l_text||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);
663: l_text:=l_text||fnd_date.date_to_canonical(p_adjusted_svc_date);
664: l_text:=l_text||'';
665: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
666: l_text:='
667: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
668: l_text:=l_text||'
669: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
670: l_text:='
671: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
667: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
668: l_text:=l_text||'';
669: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
670: l_text:='
671: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
672: l_text:=l_text||'
673: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
674: l_text:='
675: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
671: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
672: l_text:=l_text||'';
673: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
674: l_text:='
675: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
676: l_text:=l_text||'
677: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
678: l_text:='
679: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
675: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
676: l_text:=l_text||'';
677: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
678: l_text:='
679: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
680: l_text:=l_text||'
681: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
682: l_text:='
683: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
691: l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);
692: l_text:=l_text||'';
693: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
694: l_text:='
695: l_text:=l_text||fnd_number.number_to_canonical(p_per_comment_id);
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_assignment_sequence);
695: l_text:=l_text||fnd_number.number_to_canonical(p_per_comment_id);
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_assignment_sequence);
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_assignment_number);
719: l_text:=l_text||irc_utilities_pkg.removeTags(p_global_person_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||fnd_number.number_to_canonical(p_party_id);
724: l_text:=l_text||'
725: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
726: l_text:='
727: if(P_NAME_COMBINATION_WARNING) then