65: l_text:='
66: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
67: --
68: l_text:='
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);
77: l_text:=l_text||irc_utilities_pkg.removeTags(p_fulltime);
78: l_text:=l_text||'';
79: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
80: l_text:='
81: l_text:=l_text||fnd_date.date_to_canonical(p_attended_start_date);
82: l_text:=l_text||'
83: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
84: l_text:='
85: l_text:=l_text||fnd_date.date_to_canonical(p_attended_end_date);
81: l_text:=l_text||fnd_date.date_to_canonical(p_attended_start_date);
82: l_text:=l_text||'';
83: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
84: l_text:='
85: l_text:=l_text||fnd_date.date_to_canonical(p_attended_end_date);
86: l_text:=l_text||'
87: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
88: l_text:='
89: l_text:=l_text||irc_utilities_pkg.removeTags(p_establishment);