120: l_text:='
121: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
122: --
123: l_text:='
124: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
125: l_text:=l_text||'
126: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
127: l_text:='
128: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
136: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);
137: l_text:=l_text||'';
138: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
139: l_text:='
140: l_text:=l_text||fnd_number.number_to_canonical(p_approval_authority);
141: l_text:=l_text||'
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='
144: l_text:=l_text||irc_utilities_pkg.removeTags(p_benchmark_job_flag);
144: l_text:=l_text||irc_utilities_pkg.removeTags(p_benchmark_job_flag);
145: l_text:=l_text||'';
146: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
147: l_text:='
148: l_text:=l_text||fnd_number.number_to_canonical(p_benchmark_job_id);
149: l_text:=l_text||'
150: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
151: l_text:='
152: l_text:=l_text||irc_utilities_pkg.removeTags(p_emp_rights_flag);
444: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
445: l_text:=l_text||'';
446: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
447: l_text:='
448: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
449: l_text:=l_text||'
450: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
451: l_text:='
452: l_text:=l_text||irc_utilities_pkg.removeTags(p_name);
452: l_text:=l_text||irc_utilities_pkg.removeTags(p_name);
453: l_text:=l_text||'';
454: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
455: l_text:='
456: l_text:=l_text||fnd_number.number_to_canonical(p_job_definition_id);
457: l_text:=l_text||'
458: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
459: l_text:='
460: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);