84: l_text:='
85: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
86: --
87: l_text:='
88: l_text:=l_text||fnd_number.number_to_canonical(p_recruiting_site_id);
89: l_text:=l_text||'
90: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
91: l_text:='
92: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
136: l_text:=l_text||irc_utilities_pkg.removeTags(p_posting_url);
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_number.number_to_canonical(p_posting_cost);
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_posting_cost_period);
152: l_text:=l_text||irc_utilities_pkg.removeTags(p_stylesheet);
153: l_text:=l_text||'';
154: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
155: l_text:='
156: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
157: l_text:=l_text||'
158: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
159: l_text:='
160: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);