53: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
54: l_text:=l_text||'';
55: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
56: l_text:='
57: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
58: l_text:=l_text||'
59: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
60: l_text:='
61: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_type);
93: l_text:=l_text||irc_utilities_pkg.removeTags(p_surrogate_key);
94: l_text:=l_text||'';
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: l_text:='
97: l_text:=l_text||fnd_date.date_to_canonical(p_calculation_date);
98: l_text:=l_text||'
99: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
100: l_text:='
101: l_text:=l_text||irc_utilities_pkg.removeTags(p_retroactive_status);