86: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
87: l_text:=l_text||'';
88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
89: l_text:='
90: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
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_name);
102: l_text:=l_text||irc_utilities_pkg.removeTags(p_language_code);
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_number.number_to_canonical(p_location_id);
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||fnd_date.date_to_canonical(p_date_to);
250: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
251: l_text:=l_text||'';
252: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
253: l_text:='
254: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number_inf);
255: l_text:=l_text||'
256: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
257: l_text:='
258: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number_org);
254: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number_inf);
255: l_text:=l_text||'';
256: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
257: l_text:='
258: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number_org);
259: l_text:=l_text||'
260: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
261: l_text:='
262: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
258: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number_org);
259: l_text:=l_text||'';
260: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
261: l_text:='
262: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
263: l_text:=l_text||'
264: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
265: l_text:='
266: l_text:=l_text||fnd_number.number_to_canonical(p_org_information_id);
262: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
263: l_text:=l_text||'';
264: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
265: l_text:='
266: l_text:=l_text||fnd_number.number_to_canonical(p_org_information_id);
267: l_text:=l_text||'
268: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
269: l_text:='
270: if(P_DUPLICATE_ORG_WARNING) then