174: l_text:='
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: --
177: l_text:='
178: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
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||fnd_number.number_to_canonical(p_business_group_id);
306: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);
307: l_text:=l_text||'';
308: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
309: l_text:='
310: l_text:=l_text||fnd_date.date_to_canonical(p_projected_assignment_end);
311: l_text:=l_text||'
312: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
313: l_text:='
314: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
690: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
691: l_text:=l_text||'';
692: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
693: l_text:='
694: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
695: l_text:=l_text||'
696: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
697: l_text:='
698: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
694: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
695: l_text:=l_text||'';
696: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
697: l_text:='
698: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
699: l_text:=l_text||'
700: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
701: l_text:='
702: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);