109: l_text:='
110: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
111: --
112: l_text:='
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);
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);
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_date.date_to_canonical(p_end_date);
121: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);
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_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);