113: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
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_previous_job_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_date.date_to_canonical(p_start_date);
125: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);
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_period_years);
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_period_months);
129: l_text:=l_text||fnd_number.number_to_canonical(p_period_years);
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_period_months);
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_period_days);
133: l_text:=l_text||fnd_number.number_to_canonical(p_period_months);
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_period_days);
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||irc_utilities_pkg.removeTags(p_job_name);
401: l_text:=l_text||irc_utilities_pkg.removeTags(p_pjo_information30);
402: l_text:=l_text||'';
403: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
404: l_text:='
405: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
406: l_text:=l_text||'
407: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
408: l_text:='';
409: --