213: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
214: l_text:=l_text||'';
215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
216: l_text:='
217: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
218: l_text:=l_text||'
219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
220: l_text:='
221: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
217: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
218: l_text:=l_text||'';
219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
220: l_text:='
221: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
222: l_text:=l_text||'
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='
225: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
221: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
222: l_text:=l_text||'';
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='
225: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
226: l_text:=l_text||'
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='
229: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
225: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
226: l_text:=l_text||'';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='
229: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
230: l_text:=l_text||'
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='
233: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
229: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='
233: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
234: l_text:=l_text||'
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='
237: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
233: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
234: l_text:=l_text||'';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='
237: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
238: l_text:=l_text||'
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='
241: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
237: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
238: l_text:=l_text||'';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='
241: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
242: l_text:=l_text||'
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='
245: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
241: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='
245: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
246: l_text:=l_text||'
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='
249: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
245: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='
249: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
250: l_text:=l_text||'
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='
253: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
249: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
250: l_text:=l_text||'';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='
253: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
254: l_text:=l_text||'
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='
257: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
253: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
254: l_text:=l_text||'';
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='
257: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
258: l_text:=l_text||'
259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
260: l_text:='
261: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);
273: l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);
274: l_text:=l_text||'';
275: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
276: l_text:='
277: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
278: l_text:=l_text||'
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
280: l_text:='
281: l_text:=l_text||irc_utilities_pkg.removeTags(p_employment_category);
293: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
294: l_text:=l_text||'';
295: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
296: l_text:='
297: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
298: l_text:=l_text||'
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='
301: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
297: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
298: l_text:=l_text||'';
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='
301: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
302: l_text:=l_text||'
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
304: l_text:='
305: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
305: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
306: l_text:=l_text||'';
307: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
308: l_text:='
309: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);
310: l_text:=l_text||'
311: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
312: l_text:='
313: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);
313: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);
314: l_text:=l_text||'';
315: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
316: l_text:='
317: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);
318: l_text:=l_text||'
319: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
320: l_text:='
321: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
321: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
322: l_text:=l_text||'';
323: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
324: l_text:='
325: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
326: l_text:=l_text||'
327: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
328: l_text:='
329: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
721: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment30);
722: l_text:=l_text||'';
723: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
724: l_text:='
725: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
726: l_text:=l_text||'
727: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
728: l_text:='
729: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
725: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
726: l_text:=l_text||'';
727: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
728: l_text:='
729: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
730: l_text:=l_text||'
731: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
732: l_text:='
733: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
729: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
730: l_text:=l_text||'';
731: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
732: l_text:='
733: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
734: l_text:=l_text||'
735: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
736: l_text:='
737: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
733: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
734: l_text:=l_text||'';
735: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
736: l_text:='
737: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
738: l_text:=l_text||'
739: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
740: l_text:='
741: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);
817: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);
818: l_text:=l_text||'';
819: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
820: l_text:='
821: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);
822: l_text:=l_text||'
823: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
824: l_text:='
825: l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);
841: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
842: l_text:=l_text||'';
843: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
844: l_text:='
845: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);
846: l_text:=l_text||'
847: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
848: l_text:='
849: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);
849: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);
850: l_text:=l_text||'';
851: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
852: l_text:='
853: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
854: l_text:=l_text||'
855: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
856: l_text:='
857: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
853: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
854: l_text:=l_text||'';
855: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
856: l_text:='
857: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
858: l_text:=l_text||'
859: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
860: l_text:='
861: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
857: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
858: l_text:=l_text||'';
859: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
860: l_text:='
861: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
862: l_text:=l_text||'
863: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
864: l_text:='
865: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
861: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
862: l_text:=l_text||'';
863: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
864: l_text:='
865: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
866: l_text:=l_text||'
867: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
868: l_text:='
869: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
873: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
874: l_text:=l_text||'';
875: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
876: l_text:='
877: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
878: l_text:=l_text||'
879: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
880: l_text:='
881: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
877: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
878: l_text:=l_text||'';
879: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
880: l_text:='
881: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
882: l_text:=l_text||'
883: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
884: l_text:='
885: if(P_OTHER_MANAGER_WARNING) then
905: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_concat_segments);
906: l_text:=l_text||'';
907: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
908: l_text:='
909: l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);
910: l_text:=l_text||'
911: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
912: l_text:='
913: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
909: l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);
910: l_text:=l_text||'';
911: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
912: l_text:='
913: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
914: l_text:=l_text||'
915: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
916: l_text:='';
917: --