121: l_text:='
122: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
123: --
124: l_text:='
125: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_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_date.date_to_canonical(p_date_from);
137: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);
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_approval_authority);
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_benchmark_job_flag);
145: l_text:=l_text||irc_utilities_pkg.removeTags(p_benchmark_job_flag);
146: l_text:=l_text||'';
147: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
148: l_text:='
149: l_text:=l_text||fnd_number.number_to_canonical(p_benchmark_job_id);
150: l_text:=l_text||'
151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
152: l_text:='
153: l_text:=l_text||irc_utilities_pkg.removeTags(p_emp_rights_flag);
153: l_text:=l_text||irc_utilities_pkg.removeTags(p_emp_rights_flag);
154: l_text:=l_text||'';
155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
156: l_text:='
157: l_text:=l_text||fnd_number.number_to_canonical(p_job_group_id);
158: l_text:=l_text||'
159: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
160: l_text:='
161: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
449: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
450: l_text:=l_text||'';
451: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
452: l_text:='
453: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
454: l_text:=l_text||'
455: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
456: l_text:='
457: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
453: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
454: l_text:=l_text||'';
455: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
456: l_text:='
457: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
458: l_text:=l_text||'
459: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
460: l_text:='
461: l_text:=l_text||fnd_number.number_to_canonical(p_job_definition_id);
457: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
458: l_text:=l_text||'';
459: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
460: l_text:='
461: l_text:=l_text||fnd_number.number_to_canonical(p_job_definition_id);
462: l_text:=l_text||'
463: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
464: l_text:='
465: l_text:=l_text||irc_utilities_pkg.removeTags(p_name);