101: l_text:=l_text||irc_utilities_pkg.removeTags(p_datetrack_update_mode);
102: l_text:=l_text||'';
103: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
104: l_text:='
105: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
106: l_text:=l_text||'
107: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
108: l_text:='
109: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
105: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
106: l_text:=l_text||'';
107: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
108: l_text:='
109: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
110: l_text:=l_text||'
111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
112: l_text:='
113: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
109: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
110: l_text:=l_text||'';
111: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
112: l_text:='
113: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
114: l_text:=l_text||'
115: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
116: l_text:='
117: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
113: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
114: l_text:=l_text||'';
115: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
116: l_text:='
117: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
118: l_text:=l_text||'
119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
120: l_text:='
121: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
117: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
118: l_text:=l_text||'';
119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
120: l_text:='
121: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
122: l_text:=l_text||'
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='
125: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
121: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
122: l_text:=l_text||'';
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='
125: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
126: l_text:=l_text||'
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='
129: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
125: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='
129: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
130: l_text:=l_text||'
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='
133: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
129: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='
133: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
134: l_text:=l_text||'
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='
137: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
133: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
134: l_text:=l_text||'';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='
137: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
138: l_text:=l_text||'
139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='
141: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
137: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
138: l_text:=l_text||'';
139: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
140: l_text:='
141: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
142: l_text:=l_text||'
143: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
144: l_text:='
145: l_text:=l_text||irc_utilities_pkg.removeTags(p_segment1);
277: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
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||fnd_number.number_to_canonical(p_people_group_id);
282: l_text:=l_text||'
283: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
284: l_text:='
285: if(P_ORG_NOW_NO_MANAGER_WARNING) then
321: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
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_contract_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||fnd_number.number_to_canonical(p_establishment_id);
325: l_text:=l_text||fnd_number.number_to_canonical(p_contract_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||fnd_number.number_to_canonical(p_establishment_id);
330: l_text:=l_text||'
331: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
332: l_text:='
333: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
333: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
334: l_text:=l_text||'';
335: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
336: l_text:='
337: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
338: l_text:=l_text||'
339: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
340: l_text:='
341: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment1);