APPS.HR_ASSIGNMENT_BE8 dependencies on DBMS_LOB

Line 209: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);

205: close get_seq;
206: --
207: -- build the xml data for the event
208: --
209: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
210: l_text:='';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='';
213: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

207: -- build the xml data for the event
208: --
209: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
210: l_text:='';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='';
213: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
214: --
215: l_text:='';

Line 213: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

209: dbms_lob.createTemporary(l_event_data,false,dbms_lob.call);
210: l_text:='';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='';
213: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
214: --
215: l_text:='';
216: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
217: l_text:=l_text||'';

Line 218: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

214: --
215: l_text:='';
216: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
217: l_text:=l_text||'';
218: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
219: l_text:='';
220: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
221: l_text:=l_text||'';
222: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 222: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

218: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
219: l_text:='';
220: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
221: l_text:=l_text||'';
222: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
223: l_text:='';
224: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
225: l_text:=l_text||'';
226: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 226: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

222: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
223: l_text:='';
224: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
225: l_text:=l_text||'';
226: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
227: l_text:='';
228: l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);
229: l_text:=l_text||'';
230: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 230: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

226: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
227: l_text:='';
228: l_text:=l_text||fnd_number.number_to_canonical(p_recruiter_id);
229: l_text:=l_text||'';
230: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
231: l_text:='';
232: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
233: l_text:=l_text||'';
234: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 234: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

230: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
231: l_text:='';
232: l_text:=l_text||fnd_number.number_to_canonical(p_grade_id);
233: l_text:=l_text||'';
234: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
235: l_text:='';
236: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
237: l_text:=l_text||'';
238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

234: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
235: l_text:='';
236: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
237: l_text:=l_text||'';
238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
239: l_text:='';
240: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
241: l_text:=l_text||'';
242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

238: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
239: l_text:='';
240: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
241: l_text:=l_text||'';
242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
243: l_text:='';
244: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
245: l_text:=l_text||'';
246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

242: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
243: l_text:='';
244: l_text:=l_text||fnd_number.number_to_canonical(p_payroll_id);
245: l_text:=l_text||'';
246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
247: l_text:='';
248: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
249: l_text:=l_text||'';
250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

246: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
247: l_text:='';
248: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_status_type_id);
249: l_text:=l_text||'';
250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
251: l_text:='';
252: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
253: l_text:=l_text||'';
254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

250: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
251: l_text:='';
252: l_text:=l_text||fnd_number.number_to_canonical(p_location_id);
253: l_text:=l_text||'';
254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
255: l_text:='';
256: l_text:=l_text||fnd_number.number_to_canonical(p_person_referred_by_id);
257: l_text:=l_text||'';
258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

254: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
255: l_text:='';
256: l_text:=l_text||fnd_number.number_to_canonical(p_person_referred_by_id);
257: l_text:=l_text||'';
258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
259: l_text:='';
260: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
261: l_text:=l_text||'';
262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

258: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
259: l_text:='';
260: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_id);
261: l_text:=l_text||'';
262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
263: l_text:='';
264: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
265: l_text:=l_text||'';
266: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 266: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

262: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
263: l_text:='';
264: l_text:=l_text||fnd_number.number_to_canonical(p_special_ceiling_step_id);
265: l_text:=l_text||'';
266: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
267: l_text:='';
268: l_text:=l_text||fnd_number.number_to_canonical(p_recruitment_activity_id);
269: l_text:=l_text||'';
270: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 270: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

266: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
267: l_text:='';
268: l_text:=l_text||fnd_number.number_to_canonical(p_recruitment_activity_id);
269: l_text:=l_text||'';
270: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
271: l_text:='';
272: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
273: l_text:=l_text||'';
274: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 274: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

270: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
271: l_text:='';
272: l_text:=l_text||fnd_number.number_to_canonical(p_soft_coding_keyflex_id);
273: l_text:=l_text||'';
274: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
275: l_text:='';
276: l_text:=l_text||fnd_number.number_to_canonical(p_source_organization_id);
277: l_text:=l_text||'';
278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

274: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
275: l_text:='';
276: l_text:=l_text||fnd_number.number_to_canonical(p_source_organization_id);
277: l_text:=l_text||'';
278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
279: l_text:='';
280: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
281: l_text:=l_text||'';
282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

278: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
279: l_text:='';
280: l_text:=l_text||fnd_number.number_to_canonical(p_vacancy_id);
281: l_text:=l_text||'';
282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
283: l_text:='';
284: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
285: l_text:=l_text||'';
286: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 286: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

282: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
283: l_text:='';
284: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
285: l_text:=l_text||'';
286: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
287: l_text:='';
288: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
289: l_text:=l_text||'';
290: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 290: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

286: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
287: l_text:='';
288: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
289: l_text:=l_text||'';
290: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
291: l_text:='';
292: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_address_line);
293: l_text:=l_text||'';
294: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 294: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

290: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
291: l_text:='';
292: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_address_line);
293: l_text:=l_text||'';
294: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
295: l_text:='';
296: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
297: l_text:=l_text||'';
298: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 298: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

294: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
295: l_text:='';
296: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
297: l_text:=l_text||'';
298: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
299: l_text:='';
300: l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);
301: l_text:=l_text||'';
302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

298: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
299: l_text:='';
300: l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);
301: l_text:=l_text||'';
302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
303: l_text:='';
304: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
305: l_text:=l_text||'';
306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

302: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
303: l_text:='';
304: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
305: l_text:=l_text||'';
306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
307: l_text:='';
308: l_text:=l_text||irc_utilities_pkg.removeTags(p_employment_category);
309: l_text:=l_text||'';
310: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 310: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

306: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
307: l_text:='';
308: l_text:=l_text||irc_utilities_pkg.removeTags(p_employment_category);
309: l_text:=l_text||'';
310: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
311: l_text:='';
312: l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);
313: l_text:=l_text||'';
314: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 314: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

310: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
311: l_text:='';
312: l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);
313: l_text:=l_text||'';
314: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
315: l_text:='';
316: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
317: l_text:=l_text||'';
318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

314: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
315: l_text:='';
316: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
317: l_text:=l_text||'';
318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
319: l_text:='';
320: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
321: l_text:=l_text||'';
322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

318: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
319: l_text:='';
320: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);
321: l_text:=l_text||'';
322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
323: l_text:='';
324: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
325: l_text:=l_text||'';
326: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 326: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

322: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
323: l_text:='';
324: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
325: l_text:=l_text||'';
326: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
327: l_text:='';
328: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
329: l_text:=l_text||'';
330: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 330: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

326: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
327: l_text:='';
328: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
329: l_text:=l_text||'';
330: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
331: l_text:='';
332: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);
333: l_text:=l_text||'';
334: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 334: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

330: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
331: l_text:='';
332: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);
333: l_text:=l_text||'';
334: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
335: l_text:='';
336: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);
337: l_text:=l_text||'';
338: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 338: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

334: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
335: l_text:='';
336: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);
337: l_text:=l_text||'';
338: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
339: l_text:='';
340: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);
341: l_text:=l_text||'';
342: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 342: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

338: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
339: l_text:='';
340: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);
341: l_text:=l_text||'';
342: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
343: l_text:='';
344: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
345: l_text:=l_text||'';
346: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 346: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

342: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
343: l_text:='';
344: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
345: l_text:=l_text||'';
346: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
347: l_text:='';
348: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
349: l_text:=l_text||'';
350: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 350: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

346: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
347: l_text:='';
348: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
349: l_text:=l_text||'';
350: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
351: l_text:='';
352: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
353: l_text:=l_text||'';
354: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 354: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

350: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
351: l_text:='';
352: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
353: l_text:=l_text||'';
354: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
355: l_text:='';
356: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);
357: l_text:=l_text||'';
358: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 358: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

354: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
355: l_text:='';
356: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);
357: l_text:=l_text||'';
358: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
359: l_text:='';
360: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_start);
361: l_text:=l_text||'';
362: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 362: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

358: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
359: l_text:='';
360: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_start);
361: l_text:=l_text||'';
362: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
363: l_text:='';
364: l_text:=l_text||irc_utilities_pkg.removeTags(p_bargaining_unit_code);
365: l_text:=l_text||'';
366: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 366: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

362: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
363: l_text:='';
364: l_text:=l_text||irc_utilities_pkg.removeTags(p_bargaining_unit_code);
365: l_text:=l_text||'';
366: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
367: l_text:='';
368: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute_category);
369: l_text:=l_text||'';
370: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 370: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

366: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
367: l_text:='';
368: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute_category);
369: l_text:=l_text||'';
370: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
371: l_text:='';
372: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute1);
373: l_text:=l_text||'';
374: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 374: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

370: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
371: l_text:='';
372: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute1);
373: l_text:=l_text||'';
374: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
375: l_text:='';
376: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute2);
377: l_text:=l_text||'';
378: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 378: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

374: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
375: l_text:='';
376: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute2);
377: l_text:=l_text||'';
378: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
379: l_text:='';
380: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute3);
381: l_text:=l_text||'';
382: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 382: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

378: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
379: l_text:='';
380: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute3);
381: l_text:=l_text||'';
382: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
383: l_text:='';
384: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute4);
385: l_text:=l_text||'';
386: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 386: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

382: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
383: l_text:='';
384: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute4);
385: l_text:=l_text||'';
386: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
387: l_text:='';
388: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute5);
389: l_text:=l_text||'';
390: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 390: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

386: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
387: l_text:='';
388: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute5);
389: l_text:=l_text||'';
390: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
391: l_text:='';
392: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute6);
393: l_text:=l_text||'';
394: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 394: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

390: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
391: l_text:='';
392: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute6);
393: l_text:=l_text||'';
394: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
395: l_text:='';
396: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute7);
397: l_text:=l_text||'';
398: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 398: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

394: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
395: l_text:='';
396: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute7);
397: l_text:=l_text||'';
398: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
399: l_text:='';
400: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute8);
401: l_text:=l_text||'';
402: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 402: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

398: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
399: l_text:='';
400: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute8);
401: l_text:=l_text||'';
402: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
403: l_text:='';
404: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute9);
405: l_text:=l_text||'';
406: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 406: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

402: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
403: l_text:='';
404: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute9);
405: l_text:=l_text||'';
406: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
407: l_text:='';
408: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute10);
409: l_text:=l_text||'';
410: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 410: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

406: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
407: l_text:='';
408: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute10);
409: l_text:=l_text||'';
410: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
411: l_text:='';
412: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute11);
413: l_text:=l_text||'';
414: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 414: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

410: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
411: l_text:='';
412: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute11);
413: l_text:=l_text||'';
414: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
415: l_text:='';
416: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute12);
417: l_text:=l_text||'';
418: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 418: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

414: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
415: l_text:='';
416: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute12);
417: l_text:=l_text||'';
418: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
419: l_text:='';
420: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute13);
421: l_text:=l_text||'';
422: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 422: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

418: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
419: l_text:='';
420: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute13);
421: l_text:=l_text||'';
422: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
423: l_text:='';
424: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute14);
425: l_text:=l_text||'';
426: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 426: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

422: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
423: l_text:='';
424: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute14);
425: l_text:=l_text||'';
426: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
427: l_text:='';
428: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute15);
429: l_text:=l_text||'';
430: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 430: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

426: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
427: l_text:='';
428: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute15);
429: l_text:=l_text||'';
430: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
431: l_text:='';
432: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute16);
433: l_text:=l_text||'';
434: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 434: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

430: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
431: l_text:='';
432: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute16);
433: l_text:=l_text||'';
434: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
435: l_text:='';
436: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute17);
437: l_text:=l_text||'';
438: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 438: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

434: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
435: l_text:='';
436: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute17);
437: l_text:=l_text||'';
438: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
439: l_text:='';
440: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute18);
441: l_text:=l_text||'';
442: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 442: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

438: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
439: l_text:='';
440: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute18);
441: l_text:=l_text||'';
442: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
443: l_text:='';
444: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute19);
445: l_text:=l_text||'';
446: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 446: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

442: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
443: l_text:='';
444: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute19);
445: l_text:=l_text||'';
446: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
447: l_text:='';
448: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute20);
449: l_text:=l_text||'';
450: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 450: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

446: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
447: l_text:='';
448: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute20);
449: l_text:=l_text||'';
450: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
451: l_text:='';
452: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute21);
453: l_text:=l_text||'';
454: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 454: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

450: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
451: l_text:='';
452: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute21);
453: l_text:=l_text||'';
454: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
455: l_text:='';
456: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute22);
457: l_text:=l_text||'';
458: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 458: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

454: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
455: l_text:='';
456: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute22);
457: l_text:=l_text||'';
458: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
459: l_text:='';
460: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute23);
461: l_text:=l_text||'';
462: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 462: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

458: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
459: l_text:='';
460: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute23);
461: l_text:=l_text||'';
462: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
463: l_text:='';
464: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute24);
465: l_text:=l_text||'';
466: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 466: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

462: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
463: l_text:='';
464: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute24);
465: l_text:=l_text||'';
466: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
467: l_text:='';
468: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute25);
469: l_text:=l_text||'';
470: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 470: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

466: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
467: l_text:='';
468: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute25);
469: l_text:=l_text||'';
470: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
471: l_text:='';
472: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute26);
473: l_text:=l_text||'';
474: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 474: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

470: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
471: l_text:='';
472: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute26);
473: l_text:=l_text||'';
474: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
475: l_text:='';
476: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute27);
477: l_text:=l_text||'';
478: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 478: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

474: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
475: l_text:='';
476: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute27);
477: l_text:=l_text||'';
478: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
479: l_text:='';
480: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute28);
481: l_text:=l_text||'';
482: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 482: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

478: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
479: l_text:='';
480: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute28);
481: l_text:=l_text||'';
482: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
483: l_text:='';
484: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute29);
485: l_text:=l_text||'';
486: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 486: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

482: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
483: l_text:='';
484: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute29);
485: l_text:=l_text||'';
486: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
487: l_text:='';
488: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute30);
489: l_text:=l_text||'';
490: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 490: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

486: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
487: l_text:='';
488: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute30);
489: l_text:=l_text||'';
490: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
491: l_text:='';
494: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 494: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

490: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
491: l_text:='';
494: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
495: l_text:='';
496: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment1);
497: l_text:=l_text||'';
498: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 498: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

494: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
495: l_text:='';
496: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment1);
497: l_text:=l_text||'';
498: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
499: l_text:='';
500: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment2);
501: l_text:=l_text||'';
502: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 502: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

498: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
499: l_text:='';
500: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment2);
501: l_text:=l_text||'';
502: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
503: l_text:='';
504: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment3);
505: l_text:=l_text||'';
506: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 506: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

502: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
503: l_text:='';
504: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment3);
505: l_text:=l_text||'';
506: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
507: l_text:='';
508: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment4);
509: l_text:=l_text||'';
510: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 510: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

506: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
507: l_text:='';
508: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment4);
509: l_text:=l_text||'';
510: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
511: l_text:='';
512: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment5);
513: l_text:=l_text||'';
514: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 514: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

510: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
511: l_text:='';
512: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment5);
513: l_text:=l_text||'';
514: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
515: l_text:='';
516: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment6);
517: l_text:=l_text||'';
518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

514: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
515: l_text:='';
516: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment6);
517: l_text:=l_text||'';
518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
519: l_text:='';
520: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment7);
521: l_text:=l_text||'';
522: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 522: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

518: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
519: l_text:='';
520: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment7);
521: l_text:=l_text||'';
522: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
523: l_text:='';
524: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment8);
525: l_text:=l_text||'';
526: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 526: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

522: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
523: l_text:='';
524: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment8);
525: l_text:=l_text||'';
526: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
527: l_text:='';
528: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment9);
529: l_text:=l_text||'';
530: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 530: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

526: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
527: l_text:='';
528: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment9);
529: l_text:=l_text||'';
530: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
531: l_text:='';
532: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment10);
533: l_text:=l_text||'';
534: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 534: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

530: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
531: l_text:='';
532: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment10);
533: l_text:=l_text||'';
534: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
535: l_text:='';
536: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment11);
537: l_text:=l_text||'';
538: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 538: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

534: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
535: l_text:='';
536: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment11);
537: l_text:=l_text||'';
538: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
539: l_text:='';
540: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment12);
541: l_text:=l_text||'';
542: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 542: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

538: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
539: l_text:='';
540: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment12);
541: l_text:=l_text||'';
542: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
543: l_text:='';
544: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment13);
545: l_text:=l_text||'';
546: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 546: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

542: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
543: l_text:='';
544: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment13);
545: l_text:=l_text||'';
546: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
547: l_text:='';
548: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment14);
549: l_text:=l_text||'';
550: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 550: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

546: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
547: l_text:='';
548: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment14);
549: l_text:=l_text||'';
550: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
551: l_text:='';
552: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment15);
553: l_text:=l_text||'';
554: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 554: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

550: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
551: l_text:='';
552: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment15);
553: l_text:=l_text||'';
554: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
555: l_text:='';
556: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment16);
557: l_text:=l_text||'';
558: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 558: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

554: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
555: l_text:='';
556: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment16);
557: l_text:=l_text||'';
558: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
559: l_text:='';
560: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment17);
561: l_text:=l_text||'';
562: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 562: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

558: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
559: l_text:='';
560: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment17);
561: l_text:=l_text||'';
562: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
563: l_text:='';
564: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment18);
565: l_text:=l_text||'';
566: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 566: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

562: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
563: l_text:='';
564: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment18);
565: l_text:=l_text||'';
566: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
567: l_text:='';
568: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment19);
569: l_text:=l_text||'';
570: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 570: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

566: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
567: l_text:='';
568: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment19);
569: l_text:=l_text||'';
570: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
571: l_text:='';
572: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment20);
573: l_text:=l_text||'';
574: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 574: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

570: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
571: l_text:='';
572: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment20);
573: l_text:=l_text||'';
574: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
575: l_text:='';
576: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment21);
577: l_text:=l_text||'';
578: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 578: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

574: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
575: l_text:='';
576: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment21);
577: l_text:=l_text||'';
578: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
579: l_text:='';
580: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment22);
581: l_text:=l_text||'';
582: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 582: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

578: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
579: l_text:='';
580: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment22);
581: l_text:=l_text||'';
582: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
583: l_text:='';
584: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment23);
585: l_text:=l_text||'';
586: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 586: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

582: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
583: l_text:='';
584: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment23);
585: l_text:=l_text||'';
586: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
587: l_text:='';
588: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment24);
589: l_text:=l_text||'';
590: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 590: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

586: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
587: l_text:='';
588: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment24);
589: l_text:=l_text||'';
590: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
591: l_text:='';
592: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment25);
593: l_text:=l_text||'';
594: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 594: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

590: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
591: l_text:='';
592: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment25);
593: l_text:=l_text||'';
594: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
595: l_text:='';
596: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment26);
597: l_text:=l_text||'';
598: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 598: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

594: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
595: l_text:='';
596: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment26);
597: l_text:=l_text||'';
598: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
599: l_text:='';
600: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment27);
601: l_text:=l_text||'';
602: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 602: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

598: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
599: l_text:='';
600: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment27);
601: l_text:=l_text||'';
602: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
603: l_text:='';
604: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment28);
605: l_text:=l_text||'';
606: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 606: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

602: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
603: l_text:='';
604: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment28);
605: l_text:=l_text||'';
606: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
607: l_text:='';
608: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment29);
609: l_text:=l_text||'';
610: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 610: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

606: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
607: l_text:='';
608: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment29);
609: l_text:=l_text||'';
610: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
611: l_text:='';
612: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment30);
613: l_text:=l_text||'';
614: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 614: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

610: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
611: l_text:='';
612: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment30);
613: l_text:=l_text||'';
614: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
615: l_text:='';
616: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
617: l_text:=l_text||'';
618: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 618: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

614: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
615: l_text:='';
616: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
617: l_text:=l_text||'';
618: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
619: l_text:='';
620: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment1);
621: l_text:=l_text||'';
622: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 622: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

618: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
619: l_text:='';
620: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment1);
621: l_text:=l_text||'';
622: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
623: l_text:='';
624: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment2);
625: l_text:=l_text||'';
626: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 626: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

622: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
623: l_text:='';
624: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment2);
625: l_text:=l_text||'';
626: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
627: l_text:='';
628: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment3);
629: l_text:=l_text||'';
630: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 630: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

626: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
627: l_text:='';
628: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment3);
629: l_text:=l_text||'';
630: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
631: l_text:='';
632: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment4);
633: l_text:=l_text||'';
634: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 634: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

630: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
631: l_text:='';
632: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment4);
633: l_text:=l_text||'';
634: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
635: l_text:='';
636: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment5);
637: l_text:=l_text||'';
638: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 638: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

634: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
635: l_text:='';
636: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment5);
637: l_text:=l_text||'';
638: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
639: l_text:='';
640: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment6);
641: l_text:=l_text||'';
642: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 642: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

638: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
639: l_text:='';
640: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment6);
641: l_text:=l_text||'';
642: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
643: l_text:='';
644: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment7);
645: l_text:=l_text||'';
646: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 646: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

642: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
643: l_text:='';
644: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment7);
645: l_text:=l_text||'';
646: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
647: l_text:='';
648: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment8);
649: l_text:=l_text||'';
650: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 650: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

646: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
647: l_text:='';
648: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment8);
649: l_text:=l_text||'';
650: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
651: l_text:='';
652: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment9);
653: l_text:=l_text||'';
654: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 654: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

650: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
651: l_text:='';
652: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment9);
653: l_text:=l_text||'';
654: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
655: l_text:='';
656: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment10);
657: l_text:=l_text||'';
658: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 658: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

654: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
655: l_text:='';
656: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment10);
657: l_text:=l_text||'';
658: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
659: l_text:='';
660: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment11);
661: l_text:=l_text||'';
662: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 662: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

658: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
659: l_text:='';
660: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment11);
661: l_text:=l_text||'';
662: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
663: l_text:='';
664: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment12);
665: l_text:=l_text||'';
666: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 666: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

662: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
663: l_text:='';
664: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment12);
665: l_text:=l_text||'';
666: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
667: l_text:='';
668: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment13);
669: l_text:=l_text||'';
670: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 670: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

666: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
667: l_text:='';
668: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment13);
669: l_text:=l_text||'';
670: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
671: l_text:='';
672: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment14);
673: l_text:=l_text||'';
674: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 674: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

670: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
671: l_text:='';
672: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment14);
673: l_text:=l_text||'';
674: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
675: l_text:='';
676: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment15);
677: l_text:=l_text||'';
678: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 678: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

674: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
675: l_text:='';
676: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment15);
677: l_text:=l_text||'';
678: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
679: l_text:='';
680: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment16);
681: l_text:=l_text||'';
682: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 682: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

678: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
679: l_text:='';
680: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment16);
681: l_text:=l_text||'';
682: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
683: l_text:='';
684: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment17);
685: l_text:=l_text||'';
686: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 686: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

682: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
683: l_text:='';
684: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment17);
685: l_text:=l_text||'';
686: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
687: l_text:='';
688: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment18);
689: l_text:=l_text||'';
690: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 690: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

686: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
687: l_text:='';
688: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment18);
689: l_text:=l_text||'';
690: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
691: l_text:='';
692: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment19);
693: l_text:=l_text||'';
694: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 694: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

690: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
691: l_text:='';
692: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment19);
693: l_text:=l_text||'';
694: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
695: l_text:='';
696: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment20);
697: l_text:=l_text||'';
698: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 698: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

694: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
695: l_text:='';
696: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment20);
697: l_text:=l_text||'';
698: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
699: l_text:='';
700: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment21);
701: l_text:=l_text||'';
702: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 702: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

698: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
699: l_text:='';
700: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment21);
701: l_text:=l_text||'';
702: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
703: l_text:='';
704: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment22);
705: l_text:=l_text||'';
706: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 706: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

702: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
703: l_text:='';
704: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment22);
705: l_text:=l_text||'';
706: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
707: l_text:='';
708: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment23);
709: l_text:=l_text||'';
710: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 710: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

706: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
707: l_text:='';
708: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment23);
709: l_text:=l_text||'';
710: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
711: l_text:='';
712: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment24);
713: l_text:=l_text||'';
714: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 714: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

710: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
711: l_text:='';
712: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment24);
713: l_text:=l_text||'';
714: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
715: l_text:='';
716: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment25);
717: l_text:=l_text||'';
718: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 718: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

714: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
715: l_text:='';
716: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment25);
717: l_text:=l_text||'';
718: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
719: l_text:='';
720: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment26);
721: l_text:=l_text||'';
722: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 722: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

718: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
719: l_text:='';
720: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment26);
721: l_text:=l_text||'';
722: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
723: l_text:='';
724: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment27);
725: l_text:=l_text||'';
726: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 726: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

722: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
723: l_text:='';
724: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment27);
725: l_text:=l_text||'';
726: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
727: l_text:='';
728: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment28);
729: l_text:=l_text||'';
730: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 730: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

726: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
727: l_text:='';
728: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment28);
729: l_text:=l_text||'';
730: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
731: l_text:='';
732: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment29);
733: l_text:=l_text||'';
734: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 734: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

730: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
731: l_text:='';
732: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment29);
733: l_text:=l_text||'';
734: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
735: l_text:='';
736: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment30);
737: l_text:=l_text||'';
738: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 738: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

734: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
735: l_text:='';
736: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment30);
737: l_text:=l_text||'';
738: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
739: l_text:='';
740: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);
741: l_text:=l_text||'';
742: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 742: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

738: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
739: l_text:='';
740: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);
741: l_text:=l_text||'';
742: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
743: l_text:='';
744: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
745: l_text:=l_text||'';
746: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 746: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

742: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
743: l_text:='';
744: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);
745: l_text:=l_text||'';
746: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
747: l_text:='';
748: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
749: l_text:=l_text||'';
750: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 750: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

746: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
747: l_text:='';
748: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
749: l_text:=l_text||'';
750: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
751: l_text:='';
752: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
753: l_text:=l_text||'';
754: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 754: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

750: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
751: l_text:='';
752: l_text:=l_text||fnd_date.date_to_canonical(p_effective_start_date);
753: l_text:=l_text||'';
754: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
755: l_text:='';
756: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
757: l_text:=l_text||'';
758: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 758: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

754: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
755: l_text:='';
756: l_text:=l_text||fnd_date.date_to_canonical(p_effective_end_date);
757: l_text:=l_text||'';
758: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
759: l_text:='';
760: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
761: l_text:=l_text||'';
762: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 762: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

758: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
759: l_text:='';
760: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
761: l_text:=l_text||'';
762: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
763: l_text:='';
764: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
765: l_text:=l_text||'';
766: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 766: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

762: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
763: l_text:='';
764: l_text:=l_text||fnd_number.number_to_canonical(p_comment_id);
765: l_text:=l_text||'';
766: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
767: l_text:='';
768: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
769: l_text:=l_text||'';
770: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 770: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

766: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
767: l_text:='';
768: l_text:=l_text||fnd_number.number_to_canonical(p_people_group_id);
769: l_text:=l_text||'';
770: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
771: l_text:='';
772: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
773: l_text:=l_text||'';
774: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 774: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

770: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
771: l_text:='';
772: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
773: l_text:=l_text||'';
774: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
775: l_text:='';
776: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
777: l_text:=l_text||'';
778: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 778: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

774: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
775: l_text:='';
776: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);
777: l_text:=l_text||'';
778: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
779: l_text:='';
780: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_concat_segments);
781: l_text:=l_text||'';
782: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 782: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

778: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
779: l_text:='';
780: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_concat_segments);
781: l_text:=l_text||'';
782: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
783: l_text:='';
784: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
785: l_text:=l_text||'';
786: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 786: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

782: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
783: l_text:='';
784: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);
785: l_text:=l_text||'';
786: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
787: l_text:='';
788: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
789: l_text:=l_text||'';
790: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 790: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

786: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
787: l_text:='';
788: l_text:=l_text||fnd_number.number_to_canonical(p_establishment_id);
789: l_text:=l_text||'';
790: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
791: l_text:='';
792: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
793: l_text:=l_text||'';
794: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 794: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

790: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
791: l_text:='';
792: l_text:=l_text||fnd_number.number_to_canonical(p_collective_agreement_id);
793: l_text:=l_text||'';
794: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
795: l_text:='';
796: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
797: l_text:=l_text||'';
798: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 798: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

794: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
795: l_text:='';
796: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
797: l_text:=l_text||'';
798: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
799: l_text:='';
800: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);
801: l_text:=l_text||'';
802: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 802: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

798: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
799: l_text:='';
800: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);
801: l_text:=l_text||'';
802: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
803: l_text:='';
804: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment2);
805: l_text:=l_text||'';
806: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 806: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

802: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
803: l_text:='';
804: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment2);
805: l_text:=l_text||'';
806: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
807: l_text:='';
808: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment3);
809: l_text:=l_text||'';
810: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 810: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

806: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
807: l_text:='';
808: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment3);
809: l_text:=l_text||'';
810: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
811: l_text:='';
812: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment4);
813: l_text:=l_text||'';
814: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 814: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

810: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
811: l_text:='';
812: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment4);
813: l_text:=l_text||'';
814: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
815: l_text:='';
816: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment5);
817: l_text:=l_text||'';
818: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 818: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

814: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
815: l_text:='';
816: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment5);
817: l_text:=l_text||'';
818: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
819: l_text:='';
820: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment6);
821: l_text:=l_text||'';
822: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 822: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

818: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
819: l_text:='';
820: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment6);
821: l_text:=l_text||'';
822: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
823: l_text:='';
824: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment7);
825: l_text:=l_text||'';
826: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 826: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

822: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
823: l_text:='';
824: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment7);
825: l_text:=l_text||'';
826: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
827: l_text:='';
828: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment8);
829: l_text:=l_text||'';
830: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 830: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

826: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
827: l_text:='';
828: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment8);
829: l_text:=l_text||'';
830: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
831: l_text:='';
832: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment9);
833: l_text:=l_text||'';
834: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 834: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

830: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
831: l_text:='';
832: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment9);
833: l_text:=l_text||'';
834: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
835: l_text:='';
836: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment10);
837: l_text:=l_text||'';
838: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 838: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

834: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
835: l_text:='';
836: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment10);
837: l_text:=l_text||'';
838: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
839: l_text:='';
840: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment11);
841: l_text:=l_text||'';
842: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 842: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

838: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
839: l_text:='';
840: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment11);
841: l_text:=l_text||'';
842: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
843: l_text:='';
844: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment12);
845: l_text:=l_text||'';
846: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 846: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

842: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
843: l_text:='';
844: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment12);
845: l_text:=l_text||'';
846: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
847: l_text:='';
848: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment13);
849: l_text:=l_text||'';
850: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 850: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

846: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
847: l_text:='';
848: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment13);
849: l_text:=l_text||'';
850: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
851: l_text:='';
852: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment14);
853: l_text:=l_text||'';
854: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 854: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

850: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
851: l_text:='';
852: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment14);
853: l_text:=l_text||'';
854: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
855: l_text:='';
856: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment15);
857: l_text:=l_text||'';
858: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 858: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

854: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
855: l_text:='';
856: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment15);
857: l_text:=l_text||'';
858: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
859: l_text:='';
860: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment16);
861: l_text:=l_text||'';
862: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 862: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

858: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
859: l_text:='';
860: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment16);
861: l_text:=l_text||'';
862: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
863: l_text:='';
864: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment17);
865: l_text:=l_text||'';
866: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 866: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

862: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
863: l_text:='';
864: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment17);
865: l_text:=l_text||'';
866: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
867: l_text:='';
868: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment18);
869: l_text:=l_text||'';
870: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 870: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

866: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
867: l_text:='';
868: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment18);
869: l_text:=l_text||'';
870: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
871: l_text:='';
872: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment19);
873: l_text:=l_text||'';
874: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 874: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

870: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
871: l_text:='';
872: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment19);
873: l_text:=l_text||'';
874: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
875: l_text:='';
876: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);
877: l_text:=l_text||'';
878: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 878: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

874: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
875: l_text:='';
876: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);
877: l_text:=l_text||'';
878: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
879: l_text:='';
880: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);
881: l_text:=l_text||'';
882: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 882: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

878: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
879: l_text:='';
880: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);
881: l_text:=l_text||'';
882: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
883: l_text:='';
884: l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);
885: l_text:=l_text||'';
886: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 886: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

882: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
883: l_text:='';
884: l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);
885: l_text:=l_text||'';
886: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
887: l_text:='';
888: l_text:=l_text||irc_utilities_pkg.removeTags(p_employee_category);
889: l_text:=l_text||'';
890: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 890: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

886: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
887: l_text:='';
888: l_text:=l_text||irc_utilities_pkg.removeTags(p_employee_category);
889: l_text:=l_text||'';
890: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
891: l_text:='';
892: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_at_home);
893: l_text:=l_text||'';
894: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 894: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

890: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
891: l_text:='';
892: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_at_home);
893: l_text:=l_text||'';
894: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
895: l_text:='';
896: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
897: l_text:=l_text||'';
898: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 898: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

894: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
895: l_text:='';
896: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
897: l_text:=l_text||'';
898: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
899: l_text:='';
900: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);
901: l_text:=l_text||'';
902: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 902: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

898: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
899: l_text:='';
900: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);
901: l_text:=l_text||'';
902: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
903: l_text:='';
904: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
905: l_text:=l_text||'';
906: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 906: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

902: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
903: l_text:='';
904: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
905: l_text:=l_text||'';
906: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
907: l_text:='';
908: l_text:=l_text||fnd_number.number_to_canonical(p_applicant_rank);
909: l_text:=l_text||'';
910: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 910: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

906: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
907: l_text:='';
908: l_text:=l_text||fnd_number.number_to_canonical(p_applicant_rank);
909: l_text:=l_text||'';
910: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
911: l_text:='';
912: l_text:=l_text||fnd_number.number_to_canonical(p_posting_content_id);
913: l_text:=l_text||'';
914: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 914: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

910: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
911: l_text:='';
912: l_text:=l_text||fnd_number.number_to_canonical(p_posting_content_id);
913: l_text:=l_text||'';
914: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
915: l_text:='';
916: l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);
917: l_text:=l_text||'';
918: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 918: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

914: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
915: l_text:='';
916: l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);
917: l_text:=l_text||'';
918: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
919: l_text:='';
920: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
921: l_text:=l_text||'';
922: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

Line 922: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

918: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
919: l_text:='';
920: l_text:=l_text||fnd_number.number_to_canonical(p_supervisor_assignment_id);
921: l_text:=l_text||'';
922: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
923: l_text:='';
924: --
925: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
926: --

Line 925: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);

921: l_text:=l_text||'';
922: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
923: l_text:='';
924: --
925: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
926: --
927: if p_effective_start_date is not NULL and
928: p_effective_start_date > trunc(SYSDATE) and
929: fnd_profile.value('HR_DEFER_FD_BE_EVENTS') = 'Y' then