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