86: l_text:='
87: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
88: --
89: l_text:='
90: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
91: l_text:=l_text||'
92: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
93: l_text:='
94: l_text:=l_text||irc_utilities_pkg.removeTags(p_latest_offer);
110: l_text:=l_text||fnd_number.number_to_canonical(p_respondent_id);
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_date.date_to_canonical(p_expiry_date);
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_date.date_to_canonical(p_proposed_start_date);
114: l_text:=l_text||fnd_date.date_to_canonical(p_expiry_date);
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_date.date_to_canonical(p_proposed_start_date);
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||irc_utilities_pkg.removeTags(p_offer_letter_tracking_code);
126: l_text:=l_text||irc_utilities_pkg.removeTags(p_offer_postal_service);
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_date.date_to_canonical(p_offer_shipping_date);
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_applicant_assignment_id);