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);
129: l_text:=l_text||'
130: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
131: l_text:='
132: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
132: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
133: l_text:=l_text||'';
134: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
135: l_text:='
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);
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);
461: l_text:=l_text||'
462: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
463: l_text:='';
464: --