139: l_text:=l_text||irc_utilities_pkg.removeTags(p_timezone_code);
140: l_text:=l_text||'';
141: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
142: l_text:='
143: l_text:=l_text||fnd_number.number_to_canonical(p_tp_header_id);
144: l_text:=l_text||'
145: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
146: l_text:='
147: l_text:=l_text||irc_utilities_pkg.removeTags(p_ece_tp_location_code);
167: l_text:=l_text||irc_utilities_pkg.removeTags(p_country);
168: l_text:=l_text||'';
169: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
170: l_text:='
171: l_text:=l_text||fnd_number.number_to_canonical(p_designated_receiver_id);
172: l_text:=l_text||'
173: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
174: l_text:='
175: l_text:=l_text||irc_utilities_pkg.removeTags(p_in_organization_flag);
179: l_text:=l_text||fnd_date.date_to_canonical(p_inactive_date);
180: l_text:=l_text||'';
181: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
182: l_text:='
183: l_text:=l_text||fnd_number.number_to_canonical(p_operating_unit_id);
184: l_text:=l_text||'
185: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186: l_text:='
187: l_text:=l_text||fnd_number.number_to_canonical(p_inventory_organization_id);
183: l_text:=l_text||fnd_number.number_to_canonical(p_operating_unit_id);
184: l_text:=l_text||'';
185: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186: l_text:='
187: l_text:=l_text||fnd_number.number_to_canonical(p_inventory_organization_id);
188: l_text:=l_text||'
189: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
190: l_text:='
191: l_text:=l_text||irc_utilities_pkg.removeTags(p_office_site_flag);
211: l_text:=l_text||irc_utilities_pkg.removeTags(p_region_3);
212: l_text:=l_text||'';
213: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
214: l_text:='
215: l_text:=l_text||fnd_number.number_to_canonical(p_ship_to_location_id);
216: l_text:=l_text||'
217: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
218: l_text:='
219: l_text:=l_text||irc_utilities_pkg.removeTags(p_ship_to_site_flag);
443: l_text:=l_text||irc_utilities_pkg.removeTags(p_global_attribute20);
444: l_text:=l_text||'';
445: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
446: l_text:='
447: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
448: l_text:=l_text||'
449: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
450: l_text:='
451: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
447: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
448: l_text:=l_text||'';
449: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
450: l_text:='
451: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
452: l_text:=l_text||'
453: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
454: l_text:='
455: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
451: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
452: l_text:=l_text||'';
453: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
454: l_text:='
455: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
456: l_text:=l_text||'
457: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
458: l_text:='';
459: --