114: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
115: l_text:=l_text||'';
116: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
117: l_text:='
118: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_id);
119: l_text:=l_text||'
120: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
121: l_text:='
122: l_text:=l_text||fnd_number.number_to_canonical(p_previous_employer_id);
118: l_text:=l_text||fnd_number.number_to_canonical(p_previous_job_id);
119: l_text:=l_text||'';
120: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
121: l_text:='
122: l_text:=l_text||fnd_number.number_to_canonical(p_previous_employer_id);
123: l_text:=l_text||'
124: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
125: l_text:='
126: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
130: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);
131: l_text:=l_text||'';
132: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
133: l_text:='
134: l_text:=l_text||fnd_number.number_to_canonical(p_period_years);
135: l_text:=l_text||'
136: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
137: l_text:='
138: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);
134: l_text:=l_text||fnd_number.number_to_canonical(p_period_years);
135: l_text:=l_text||'';
136: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
137: l_text:='
138: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);
139: l_text:=l_text||'
140: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
141: l_text:='
142: l_text:=l_text||fnd_number.number_to_canonical(p_period_days);
138: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);
139: l_text:=l_text||'';
140: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
141: l_text:='
142: l_text:=l_text||fnd_number.number_to_canonical(p_period_days);
143: l_text:=l_text||'
144: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
145: l_text:='
146: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_name);
406: l_text:=l_text||irc_utilities_pkg.removeTags(p_pjo_information30);
407: l_text:=l_text||'';
408: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
409: l_text:='
410: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
411: l_text:=l_text||'
412: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
413: l_text:='';
414: --