144: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
145: l_text:=l_text||'';
146: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
147: l_text:='
148: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
149: l_text:=l_text||'
150: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
151: l_text:='
152: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
148: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
149: l_text:=l_text||'';
150: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
151: l_text:='
152: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
153: l_text:=l_text||'
154: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
155: l_text:='
156: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_category);
168: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
169: l_text:=l_text||'';
170: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
171: l_text:='
172: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
173: l_text:=l_text||'
174: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
175: l_text:='
176: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
172: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
173: l_text:=l_text||'';
174: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
175: l_text:='
176: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
177: l_text:=l_text||'
178: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
179: l_text:='
180: l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);
192: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
193: l_text:=l_text||'';
194: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
195: l_text:='
196: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
197: l_text:=l_text||'
198: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
199: l_text:='
200: l_text:=l_text||irc_utilities_pkg.removeTags(p_project_title);
200: l_text:=l_text||irc_utilities_pkg.removeTags(p_project_title);
201: l_text:=l_text||'';
202: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
203: l_text:='
204: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
205: l_text:=l_text||'
206: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
207: l_text:='
208: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
208: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
209: l_text:=l_text||'';
210: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
211: l_text:='
212: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
213: l_text:=l_text||'
214: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
215: l_text:='
216: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);
232: l_text:=l_text||irc_utilities_pkg.removeTags(p_vendor_employee_number);
233: l_text:=l_text||'';
234: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
235: l_text:='
236: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
237: l_text:=l_text||'
238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
239: l_text:='
240: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);
236: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
237: l_text:=l_text||'';
238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
239: l_text:='
240: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);
241: l_text:=l_text||'
242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
243: l_text:='
244: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);
240: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);
241: l_text:=l_text||'';
242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
243: l_text:='
244: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);
245: l_text:=l_text||'
246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
247: l_text:='
248: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);
244: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);
245: l_text:=l_text||'';
246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
247: l_text:='
248: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);
249: l_text:=l_text||'
250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
251: l_text:='
252: l_text:=l_text||fnd_date.date_to_canonical(p_projected_assignment_end);
252: l_text:=l_text||fnd_date.date_to_canonical(p_projected_assignment_end);
253: l_text:=l_text||'';
254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
255: l_text:='
256: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
257: l_text:=l_text||'
258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
259: l_text:='
260: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
516: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
517: l_text:=l_text||'';
518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
519: l_text:='
520: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
521: l_text:=l_text||'
522: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
523: l_text:='
524: if(P_NO_MANAGERS_WARNING) then
536: end if;
537: l_text:=l_text||'';
538: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
539: l_text:='
540: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
541: l_text:=l_text||'
542: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
543: l_text:='
544: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
552: end if;
553: l_text:=l_text||'';
554: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
555: l_text:='
556: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
557: l_text:=l_text||'
558: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
559: l_text:='';
560: --