74: l_text:='
75: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
76: --
77: l_text:='
78: l_text:=l_text||fnd_number.number_to_canonical(p_agency_vacancy_id);
79: l_text:=l_text||'
80: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
81: l_text:='
82: l_text:=l_text||fnd_number.number_to_canonical(p_agency_id);
78: l_text:=l_text||fnd_number.number_to_canonical(p_agency_vacancy_id);
79: l_text:=l_text||'';
80: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
81: l_text:='
82: l_text:=l_text||fnd_number.number_to_canonical(p_agency_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_vacancy_id);
82: l_text:=l_text||fnd_number.number_to_canonical(p_agency_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_vacancy_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_date.date_to_canonical(p_start_date);
94: l_text:=l_text||fnd_date.date_to_canonical(p_end_date);
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_max_allowed_applicants);
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_manage_applicants_allowed);