92: l_text:='
93: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
94: --
95: l_text:='
96: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
97: l_text:=l_text||'
98: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
99: l_text:='
100: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
104: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
105: l_text:=l_text||'';
106: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
107: l_text:='
108: l_text:=l_text||fnd_date.date_to_canonical(p_date_from);
109: l_text:=l_text||'
110: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
111: l_text:='
112: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
136: l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);
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_date.date_to_canonical(p_date_to);
141: l_text:=l_text||'
142: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
143: l_text:='
144: l_text:=l_text||irc_utilities_pkg.removeTags(p_security_method);