178: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
179: l_text:=l_text||'';
180: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
181: l_text:='
182: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
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_person_id);
182: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
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_person_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_organization_id);
186: l_text:=l_text||fnd_number.number_to_canonical(p_person_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_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_assignment_number);
198: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_category);
199: l_text:=l_text||'';
200: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
201: l_text:='
202: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
203: l_text:=l_text||'
204: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
205: l_text:='
206: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
210: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
211: l_text:=l_text||'';
212: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
213: l_text:='
214: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
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_establishment_id);
214: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
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_establishment_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_frequency);
226: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_address_line);
227: l_text:=l_text||'';
228: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
229: l_text:='
230: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
231: l_text:=l_text||'
232: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
233: l_text:='
234: l_text:=l_text||irc_utilities_pkg.removeTags(p_labour_union_member_flag);
234: l_text:=l_text||irc_utilities_pkg.removeTags(p_labour_union_member_flag);
235: l_text:=l_text||'';
236: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
237: l_text:='
238: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
239: l_text:=l_text||'
240: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
241: l_text:='
242: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
242: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
243: l_text:=l_text||'';
244: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
245: l_text:='
246: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
247: l_text:=l_text||'
248: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
249: l_text:='
250: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
246: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
247: l_text:=l_text||'';
248: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
249: l_text:='
250: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
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_grade_id);
250: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
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_grade_id);
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||irc_utilities_pkg.removeTags(p_project_title);
258: l_text:=l_text||irc_utilities_pkg.removeTags(p_project_title);
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_set_of_books_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||irc_utilities_pkg.removeTags(p_source_type);
266: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
267: l_text:=l_text||'';
268: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
269: l_text:='
270: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
271: l_text:=l_text||'
272: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
273: l_text:='
274: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);
290: l_text:=l_text||irc_utilities_pkg.removeTags(p_vendor_employee_number);
291: l_text:=l_text||'';
292: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
293: l_text:='
294: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
295: l_text:=l_text||'
296: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
297: l_text:='
298: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);
294: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
295: l_text:=l_text||'';
296: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
297: l_text:='
298: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);
299: l_text:=l_text||'
300: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
301: l_text:='
302: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);
298: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_site_id);
299: l_text:=l_text||'';
300: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
301: l_text:='
302: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);
303: l_text:=l_text||'
304: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
305: l_text:='
306: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);
302: l_text:=l_text||fnd_number.number_to_canonical(p_po_header_id);
303: l_text:=l_text||'';
304: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
305: l_text:='
306: l_text:=l_text||fnd_number.number_to_canonical(p_po_line_id);
307: l_text:=l_text||'
308: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
309: l_text:='
310: l_text:=l_text||fnd_date.date_to_canonical(p_projected_assignment_end);
682: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_concat_segments);
683: l_text:=l_text||'';
684: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
685: l_text:='
686: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
687: l_text:=l_text||'
688: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
689: l_text:='
690: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
686: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
687: l_text:=l_text||'';
688: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
689: l_text:='
690: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
691: l_text:=l_text||'
692: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
693: l_text:='
694: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
698: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
699: l_text:=l_text||'';
700: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
701: l_text:='
702: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
703: l_text:=l_text||'
704: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
705: l_text:='
706: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
702: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
703: l_text:=l_text||'';
704: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
705: l_text:='
706: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
707: l_text:=l_text||'
708: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
709: l_text:='
710: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
706: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
707: l_text:=l_text||'';
708: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
709: l_text:='
710: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
711: l_text:=l_text||'
712: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
713: l_text:='
714: l_text:=l_text||irc_utilities_pkg.removeTags(p_people_group_name);
730: end if;
731: l_text:=l_text||'';
732: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
733: l_text:='
734: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
735: l_text:=l_text||'
736: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
737: l_text:='
738: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
734: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
735: l_text:=l_text||'';
736: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
737: l_text:='
738: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
739: l_text:=l_text||'
740: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
741: l_text:='';
742: --