94: l_text:='
95: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
96: --
97: l_text:='
98: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
99: l_text:=l_text||'
100: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
101: l_text:='
102: l_text:=l_text||fnd_number.number_to_canonical(p_requisition_id);
102: l_text:=l_text||fnd_number.number_to_canonical(p_requisition_id);
103: l_text:=l_text||'';
104: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
105: l_text:='
106: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
107: l_text:=l_text||'
108: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
109: l_text:='
110: l_text:=l_text||irc_utilities_pkg.removeTags(p_name);
146: l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);
147: l_text:=l_text||'';
148: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
149: l_text:='
150: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);
151: l_text:=l_text||'
152: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
153: l_text:='
154: l_text:=l_text||irc_utilities_pkg.removeTags(p_description);