110: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
111: l_text:=l_text||'';
112: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
113: l_text:='
114: l_text:=l_text||fnd_number.number_to_canonical(p_period_of_service_id);
115: l_text:=l_text||'
116: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
117: l_text:='
118: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
114: l_text:=l_text||fnd_number.number_to_canonical(p_period_of_service_id);
115: l_text:=l_text||'';
116: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
117: l_text:='
118: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
119: l_text:=l_text||'
120: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
121: l_text:='
122: l_text:=l_text||fnd_date.date_to_canonical(p_actual_termination_date);
126: l_text:=l_text||fnd_date.date_to_canonical(p_last_standard_process_date);
127: l_text:=l_text||'';
128: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
129: l_text:='
130: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
131: l_text:=l_text||'
132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
133: l_text:='
134: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
130: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
131: l_text:=l_text||'';
132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
133: l_text:='
134: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
135: l_text:=l_text||'
136: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
137: l_text:='
138: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
414: end if;
415: l_text:=l_text||'';
416: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
417: l_text:='
418: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
419: l_text:=l_text||'
420: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
421: l_text:='
422: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
418: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
419: l_text:=l_text||'';
420: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
421: l_text:='
422: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
423: l_text:=l_text||'
424: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
425: l_text:='';
426: --