69: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
70: l_text:=l_text||'';
71: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
72: l_text:='
73: l_text:=l_text||fnd_number.number_to_canonical(p_attendance_id);
74: l_text:=l_text||'
75: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
76: l_text:='
77: l_text:=l_text||irc_utilities_pkg.removeTags(p_fulltime);
89: l_text:=l_text||irc_utilities_pkg.removeTags(p_establishment);
90: l_text:=l_text||'';
91: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
92: l_text:='
93: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
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||irc_utilities_pkg.removeTags(p_attribute_category);
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='
181: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
182: l_text:=l_text||'
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='