97: l_text:='
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: --
100: l_text:='
101: l_text:=l_text||fnd_number.number_to_canonical(p_person_analysis_id);
102: l_text:=l_text||'
103: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
104: l_text:='
105: l_text:=l_text||fnd_number.number_to_canonical(p_pea_object_version_number);
101: l_text:=l_text||fnd_number.number_to_canonical(p_person_analysis_id);
102: l_text:=l_text||'';
103: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
104: l_text:='
105: l_text:=l_text||fnd_number.number_to_canonical(p_pea_object_version_number);
106: l_text:=l_text||'
107: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
108: l_text:='
109: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
117: l_text:=l_text||fnd_date.date_to_canonical(p_date_to);
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_number.number_to_canonical(p_request_id);
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_number.number_to_canonical(p_program_application_id);
121: l_text:=l_text||fnd_number.number_to_canonical(p_request_id);
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_number.number_to_canonical(p_program_application_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_number.number_to_canonical(p_program_id);
125: l_text:=l_text||fnd_number.number_to_canonical(p_program_application_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_number.number_to_canonical(p_program_id);
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_date.date_to_canonical(p_program_update_date);
341: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
342: l_text:=l_text||'';
343: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
344: l_text:='
345: l_text:=l_text||fnd_number.number_to_canonical(p_analysis_criteria_id);
346: l_text:=l_text||'
347: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
348: l_text:='';
349: --