162: l_text:='
163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
164: --
165: l_text:='
166: l_text:=l_text||fnd_date.date_to_canonical(p_date_received);
167: l_text:=l_text||'
168: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
169: l_text:='
170: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
186: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_comments);
187: l_text:=l_text||'';
188: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
189: l_text:='
190: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
191: l_text:=l_text||'
192: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
193: l_text:='
194: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);
190: l_text:=l_text||fnd_date.date_to_canonical(p_date_employee_data_verified);
191: l_text:=l_text||'';
192: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
193: l_text:='
194: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);
195: l_text:=l_text||'
196: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
197: l_text:='
198: l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);
498: l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);
499: l_text:=l_text||'';
500: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
501: l_text:='
502: l_text:=l_text||fnd_date.date_to_canonical(p_background_date_check);
503: l_text:=l_text||'
504: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
505: l_text:='
506: l_text:=l_text||irc_utilities_pkg.removeTags(p_correspondence_language);
510: l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);
511: l_text:=l_text||'';
512: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
513: l_text:='
514: l_text:=l_text||fnd_date.date_to_canonical(p_hold_applicant_date_until);
515: l_text:=l_text||'
516: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
517: l_text:='
518: l_text:=l_text||irc_utilities_pkg.removeTags(p_honors);
534: l_text:=l_text||irc_utilities_pkg.removeTags(p_pre_name_adjunct);
535: l_text:=l_text||'';
536: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
537: l_text:='
538: l_text:=l_text||fnd_date.date_to_canonical(p_projected_start_date);
539: l_text:=l_text||'
540: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
541: l_text:='
542: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_exists);
542: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_exists);
543: l_text:=l_text||'';
544: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
545: l_text:='
546: l_text:=l_text||fnd_date.date_to_canonical(p_resume_last_updated);
547: l_text:=l_text||'
548: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
549: l_text:='
550: l_text:=l_text||irc_utilities_pkg.removeTags(p_student_status);
558: l_text:=l_text||irc_utilities_pkg.removeTags(p_suffix);
559: l_text:=l_text||'';
560: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
561: l_text:='
562: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_death);
563: l_text:=l_text||'
564: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
565: l_text:='
566: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
566: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
567: l_text:=l_text||'';
568: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
569: l_text:='
570: l_text:=l_text||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);
571: l_text:=l_text||'
572: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
573: l_text:='
574: l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_med_pln_no);
582: l_text:=l_text||irc_utilities_pkg.removeTags(p_uses_tobacco_flag);
583: l_text:=l_text||'';
584: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
585: l_text:='
586: l_text:=l_text||fnd_date.date_to_canonical(p_dpdnt_adoption_date);
587: l_text:=l_text||'
588: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
589: l_text:='
590: l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);
590: l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);
591: l_text:=l_text||'';
592: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
593: l_text:='
594: l_text:=l_text||fnd_date.date_to_canonical(p_original_date_of_hire);
595: l_text:=l_text||'
596: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
597: l_text:='
598: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
618: l_text:=l_text||fnd_number.number_to_canonical(p_apl_object_version_number);
619: l_text:=l_text||'';
620: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
621: l_text:='
622: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
623: l_text:=l_text||'
624: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
625: l_text:='
626: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);
622: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_start_date);
623: l_text:=l_text||'';
624: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
625: l_text:='
626: l_text:=l_text||fnd_date.date_to_canonical(p_per_effective_end_date);
627: l_text:=l_text||'
628: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
629: l_text:='
630: l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);