175: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
176: l_text:=l_text||'';
177: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
178: l_text:='
179: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
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_object_version_number);
179: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
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_object_version_number);
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_supervisor_id);
183: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
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_supervisor_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_assignment_number);
195: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
196: l_text:=l_text||'';
197: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
198: l_text:='
199: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
200: l_text:=l_text||'
201: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
202: l_text:='
203: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
207: l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);
208: l_text:=l_text||'';
209: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
210: l_text:='
211: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
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||irc_utilities_pkg.removeTags(p_frequency);
223: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
224: l_text:=l_text||'';
225: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
226: l_text:='
227: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
228: l_text:=l_text||'
229: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
230: l_text:='
231: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
227: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
228: l_text:=l_text||'';
229: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
230: l_text:='
231: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
232: l_text:=l_text||'
233: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
234: l_text:='
235: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
235: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
236: l_text:=l_text||'';
237: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
238: l_text:='
239: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);
240: l_text:=l_text||'
241: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
242: l_text:='
243: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);
247: l_text:=l_text||irc_utilities_pkg.removeTags(p_projected_assignment_end);
248: l_text:=l_text||'';
249: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
250: l_text:='
251: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);
252: l_text:=l_text||'
253: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
254: l_text:='
255: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
255: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
256: l_text:=l_text||'';
257: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
258: l_text:='
259: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
260: l_text:=l_text||'
261: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
262: l_text:='
263: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
535: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
536: l_text:=l_text||'';
537: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
538: l_text:='
539: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
540: l_text:=l_text||'
541: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
542: l_text:='
543: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
539: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
540: l_text:=l_text||'';
541: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
542: l_text:='
543: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
544: l_text:=l_text||'
545: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
546: l_text:='
547: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
579: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
580: l_text:=l_text||'';
581: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
582: l_text:='
583: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
584: l_text:=l_text||'
585: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
586: l_text:='
587: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
583: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
584: l_text:=l_text||'';
585: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
586: l_text:='
587: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
588: l_text:=l_text||'
589: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
590: l_text:='
591: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
587: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
588: l_text:=l_text||'';
589: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
590: l_text:='
591: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
592: l_text:=l_text||'
593: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
594: l_text:='
595: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
591: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
592: l_text:=l_text||'';
593: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
594: l_text:='
595: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
596: l_text:=l_text||'
597: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
598: l_text:='
599: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);
675: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);
676: l_text:=l_text||'';
677: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
678: l_text:='
679: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);
680: l_text:=l_text||'
681: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
682: l_text:='
683: l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);
695: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
696: l_text:=l_text||'';
697: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
698: l_text:='
699: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);
700: l_text:=l_text||'
701: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
702: l_text:='
703: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
703: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
704: l_text:=l_text||'';
705: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
706: l_text:='
707: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
708: l_text:=l_text||'
709: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
710: l_text:='';
711: --