75: l_text:='
76: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
77: --
78: l_text:='
79: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
80: l_text:=l_text||'
81: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
82: l_text:='
83: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
87: l_text:=l_text||irc_utilities_pkg.removeTags(p_name);
88: l_text:=l_text||'';
89: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
90: l_text:='
91: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
92: l_text:=l_text||'
93: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
94: l_text:='
95: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
227: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute30);
228: l_text:=l_text||'';
229: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
230: l_text:='
231: l_text:=l_text||fnd_number.number_to_canonical(p_requisition_id);
232: l_text:=l_text||'
233: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
234: l_text:='
235: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
231: l_text:=l_text||fnd_number.number_to_canonical(p_requisition_id);
232: l_text:=l_text||'';
233: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
234: l_text:='
235: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
236: l_text:=l_text||'
237: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
238: l_text:='';
239: --