169: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
170: l_text:=l_text||'';
171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
172: l_text:='
173: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
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_last_name);
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
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||fnd_number.number_to_canonical(p_person_type_id);
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||irc_utilities_pkg.removeTags(p_npw_number);
233: l_text:=l_text||irc_utilities_pkg.removeTags(p_first_name);
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||fnd_number.number_to_canonical(p_fte_capacity);
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_honors);
285: l_text:=l_text||irc_utilities_pkg.removeTags(p_on_military_service);
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||fnd_number.number_to_canonical(p_party_id);
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_pre_name_adjunct);
349: l_text:=l_text||irc_utilities_pkg.removeTags(p_uses_tobacco_flag);
350: l_text:=l_text||'';
351: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
352: l_text:='
353: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_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_work_schedule);
373: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='
377: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
378: l_text:=l_text||'
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='
381: l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_med_pln_no);
637: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information30);
638: l_text:=l_text||'';
639: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
640: l_text:='
641: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
642: l_text:=l_text||'
643: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
644: l_text:='
645: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
641: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
642: l_text:=l_text||'';
643: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
644: l_text:='
645: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
646: l_text:=l_text||'
647: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
648: l_text:='
649: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
653: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);
654: l_text:=l_text||'';
655: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
656: l_text:='
657: l_text:=l_text||fnd_number.number_to_canonical(p_pdp_object_version_number);
658: l_text:=l_text||'
659: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
660: l_text:='
661: l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);
661: l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);
662: l_text:=l_text||'';
663: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
664: l_text:='
665: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
666: l_text:=l_text||'
667: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
668: l_text:='
669: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
665: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
666: l_text:=l_text||'';
667: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
668: l_text:='
669: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
670: l_text:=l_text||'
671: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
672: l_text:='
673: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
669: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
670: l_text:=l_text||'';
671: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
672: l_text:='
673: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
674: l_text:=l_text||'
675: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
676: l_text:='
677: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
673: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
674: l_text:=l_text||'';
675: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
676: l_text:='
677: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
678: l_text:=l_text||'
679: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
680: l_text:='
681: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);