78: l_text:='
79: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
80: --
81: l_text:='
82: l_text:=l_text||fnd_number.number_to_canonical(p_recruitment_activity_id);
83: l_text:=l_text||'
84: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
85: l_text:='
86: l_text:=l_text||fnd_number.number_to_canonical(p_authorising_person_id);
82: l_text:=l_text||fnd_number.number_to_canonical(p_recruitment_activity_id);
83: l_text:=l_text||'';
84: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
85: l_text:='
86: l_text:=l_text||fnd_number.number_to_canonical(p_authorising_person_id);
87: l_text:=l_text||'
88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
89: l_text:='
90: l_text:=l_text||fnd_number.number_to_canonical(p_run_by_organization_id);
86: l_text:=l_text||fnd_number.number_to_canonical(p_authorising_person_id);
87: l_text:=l_text||'';
88: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
89: l_text:='
90: l_text:=l_text||fnd_number.number_to_canonical(p_run_by_organization_id);
91: l_text:=l_text||'
92: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
93: l_text:='
94: l_text:=l_text||fnd_number.number_to_canonical(p_internal_contact_person_id);
90: l_text:=l_text||fnd_number.number_to_canonical(p_run_by_organization_id);
91: l_text:=l_text||'';
92: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
93: l_text:='
94: l_text:=l_text||fnd_number.number_to_canonical(p_internal_contact_person_id);
95: l_text:=l_text||'
96: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
97: l_text:='
98: l_text:=l_text||fnd_number.number_to_canonical(p_parent_recruitment_activity);
94: l_text:=l_text||fnd_number.number_to_canonical(p_internal_contact_person_id);
95: l_text:=l_text||'';
96: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
97: l_text:='
98: l_text:=l_text||fnd_number.number_to_canonical(p_parent_recruitment_activity);
99: l_text:=l_text||'
100: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
101: l_text:='
102: l_text:=l_text||irc_utilities_pkg.removeTags(p_currency_code);
138: l_text:=l_text||irc_utilities_pkg.removeTags(p_planned_cost);
139: l_text:=l_text||'';
140: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
141: l_text:='
142: l_text:=l_text||fnd_number.number_to_canonical(p_recruiting_site_id);
143: l_text:=l_text||'
144: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
145: l_text:='
146: l_text:=l_text||irc_utilities_pkg.removeTags(p_recruiting_site_response);
238: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
239: l_text:=l_text||'';
240: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
241: l_text:='
242: l_text:=l_text||fnd_number.number_to_canonical(p_posting_content_id);
243: l_text:=l_text||'
244: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
245: l_text:='
246: l_text:=l_text||irc_utilities_pkg.removeTags(p_status);
246: l_text:=l_text||irc_utilities_pkg.removeTags(p_status);
247: l_text:=l_text||'';
248: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
249: l_text:='
250: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
251: l_text:=l_text||'
252: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
253: l_text:='';
254: --