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);
171: l_text:=l_text||'
172: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
173: l_text:='
174: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
174: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
175: l_text:=l_text||'';
176: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
177: l_text:='
178: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
179: l_text:=l_text||'
180: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
181: l_text:='
182: l_text:=l_text||irc_utilities_pkg.removeTags(p_applicant_number);
506: l_text:=l_text||irc_utilities_pkg.removeTags(p_correspondence_language);
507: l_text:=l_text||'';
508: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
509: l_text:='
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);
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);
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);
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);
599: l_text:=l_text||'
600: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
601: l_text:='
602: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
598: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
599: l_text:=l_text||'';
600: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
601: l_text:='
602: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
603: l_text:=l_text||'
604: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
605: l_text:='
606: l_text:=l_text||fnd_number.number_to_canonical(p_application_id);
602: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
603: l_text:=l_text||'';
604: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
605: l_text:='
606: l_text:=l_text||fnd_number.number_to_canonical(p_application_id);
607: l_text:=l_text||'
608: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
609: l_text:='
610: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
606: l_text:=l_text||fnd_number.number_to_canonical(p_application_id);
607: l_text:=l_text||'';
608: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
609: l_text:='
610: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
611: l_text:=l_text||'
612: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
613: l_text:='
614: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
610: l_text:=l_text||fnd_number.number_to_canonical(p_per_object_version_number);
611: l_text:=l_text||'';
612: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
613: l_text:='
614: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
615: l_text:=l_text||'
616: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
617: l_text:='
618: l_text:=l_text||fnd_number.number_to_canonical(p_apl_object_version_number);
614: l_text:=l_text||fnd_number.number_to_canonical(p_asg_object_version_number);
615: l_text:=l_text||'';
616: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
617: l_text:='
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);
630: l_text:=l_text||irc_utilities_pkg.removeTags(p_full_name);
631: l_text:=l_text||'';
632: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
633: l_text:='
634: l_text:=l_text||fnd_number.number_to_canonical(p_per_comment_id);
635: l_text:=l_text||'
636: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
637: l_text:='
638: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
634: l_text:=l_text||fnd_number.number_to_canonical(p_per_comment_id);
635: l_text:=l_text||'';
636: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
637: l_text:='
638: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
639: l_text:=l_text||'
640: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
641: l_text:='
642: if(P_NAME_COMBINATION_WARNING) then
674: l_text:=l_text||irc_utilities_pkg.removeTags(p_party_id);
675: l_text:=l_text||'';
676: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
677: l_text:='
678: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
679: l_text:=l_text||'
680: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
681: l_text:='';
682: --