126: l_text:=l_text||irc_utilities_pkg.removeTags(p_language_code);
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_number.number_to_canonical(p_location_id);
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||irc_utilities_pkg.removeTags(p_location_code);
142: l_text:=l_text||irc_utilities_pkg.removeTags(p_timezone_code);
143: l_text:=l_text||'';
144: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
145: l_text:='
146: l_text:=l_text||fnd_number.number_to_canonical(p_tp_header_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||irc_utilities_pkg.removeTags(p_ece_tp_location_code);
170: l_text:=l_text||irc_utilities_pkg.removeTags(p_country);
171: l_text:=l_text||'';
172: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
173: l_text:='
174: l_text:=l_text||fnd_number.number_to_canonical(p_designated_receiver_id);
175: l_text:=l_text||'
176: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
177: l_text:='
178: l_text:=l_text||irc_utilities_pkg.removeTags(p_in_organization_flag);
182: l_text:=l_text||fnd_date.date_to_canonical(p_inactive_date);
183: l_text:=l_text||'';
184: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
185: l_text:='
186: l_text:=l_text||fnd_number.number_to_canonical(p_operating_unit_id);
187: l_text:=l_text||'
188: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
189: l_text:='
190: l_text:=l_text||fnd_number.number_to_canonical(p_inventory_organization_id);
186: l_text:=l_text||fnd_number.number_to_canonical(p_operating_unit_id);
187: l_text:=l_text||'';
188: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
189: l_text:='
190: l_text:=l_text||fnd_number.number_to_canonical(p_inventory_organization_id);
191: l_text:=l_text||'
192: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
193: l_text:='
194: l_text:=l_text||irc_utilities_pkg.removeTags(p_office_site_flag);
214: l_text:=l_text||irc_utilities_pkg.removeTags(p_region_3);
215: l_text:=l_text||'';
216: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
217: l_text:='
218: l_text:=l_text||fnd_number.number_to_canonical(p_ship_to_location_id);
219: l_text:=l_text||'
220: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
221: l_text:='
222: l_text:=l_text||irc_utilities_pkg.removeTags(p_ship_to_site_flag);
446: l_text:=l_text||irc_utilities_pkg.removeTags(p_global_attribute20);
447: l_text:=l_text||'';
448: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
449: l_text:='
450: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
451: l_text:=l_text||'
452: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
453: l_text:='';
454: --