APPS.HR_ASSIGNMENT_BE8 dependencies on IRC_UTILITIES_PKG

Line 288: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);

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);
291: l_text:='';
292: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_address_line);

Line 292: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_address_line);

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);
295: l_text:='';
296: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

Line 296: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

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);
299: l_text:='';
300: l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);

Line 308: l_text:=l_text||irc_utilities_pkg.removeTags(p_employment_category);

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);
311: l_text:='';
312: l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);

Line 312: l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);

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);
315: l_text:='';
316: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);

Line 316: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);

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);
319: l_text:='';
320: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);

Line 328: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);

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);
331: l_text:='';
332: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);

Line 336: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);

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);
339: l_text:='';
340: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);

Line 344: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);

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);
347: l_text:='';
348: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);

Line 352: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);

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);
355: l_text:='';
356: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);

Line 356: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);

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);
359: l_text:='';
360: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_start);

Line 360: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_start);

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);
363: l_text:='';
364: l_text:=l_text||irc_utilities_pkg.removeTags(p_bargaining_unit_code);

Line 364: l_text:=l_text||irc_utilities_pkg.removeTags(p_bargaining_unit_code);

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);
367: l_text:='';
368: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute_category);

Line 368: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute_category);

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);
371: l_text:='';
372: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute1);

Line 372: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute1);

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);
375: l_text:='';
376: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute2);

Line 376: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute2);

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);
379: l_text:='';
380: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute3);

Line 380: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute3);

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);
383: l_text:='';
384: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute4);

Line 384: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute4);

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);
387: l_text:='';
388: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute5);

Line 388: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute5);

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);
391: l_text:='';
392: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute6);

Line 392: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute6);

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);
395: l_text:='';
396: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute7);

Line 396: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute7);

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);
399: l_text:='';
400: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute8);

Line 400: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute8);

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);
403: l_text:='';
404: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute9);

Line 404: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute9);

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);
407: l_text:='';
408: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute10);

Line 408: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute10);

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);
411: l_text:='';
412: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute11);

Line 412: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute11);

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);
415: l_text:='';
416: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute12);

Line 416: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute12);

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);
419: l_text:='';
420: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute13);

Line 420: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute13);

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);
423: l_text:='';
424: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute14);

Line 424: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute14);

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);
427: l_text:='';
428: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute15);

Line 428: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute15);

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);
431: l_text:='';
432: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute16);

Line 432: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute16);

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);
435: l_text:='';
436: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute17);

Line 436: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute17);

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);
439: l_text:='';
440: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute18);

Line 440: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute18);

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);
443: l_text:='';
444: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute19);

Line 444: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute19);

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);
447: l_text:='';
448: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute20);

Line 448: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute20);

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);
451: l_text:='';
452: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute21);

Line 452: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute21);

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);
455: l_text:='';
456: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute22);

Line 456: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute22);

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);
459: l_text:='';
460: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute23);

Line 460: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute23);

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);
463: l_text:='';
464: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute24);

Line 464: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute24);

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);
467: l_text:='';
468: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute25);

Line 468: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute25);

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);
471: l_text:='';
472: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute26);

Line 472: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute26);

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);
475: l_text:='';
476: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute27);

Line 476: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute27);

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);
479: l_text:='';
480: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute28);

Line 480: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute28);

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);
483: l_text:='';
484: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute29);

Line 484: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute29);

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);
487: l_text:='';
488: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute30);

Line 488: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute30);

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);
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);

Line 496: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment1);

492: l_text:=l_text||irc_utilities_pkg.removeTags(p_title);
493: 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);

Line 500: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment2);

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);
503: l_text:='';
504: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment3);

Line 504: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment3);

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);
507: l_text:='';
508: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment4);

Line 508: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment4);

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);
511: l_text:='';
512: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment5);

Line 512: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment5);

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);
515: l_text:='';
516: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment6);

Line 516: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment6);

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);
519: l_text:='';
520: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment7);

Line 520: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment7);

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);
523: l_text:='';
524: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment8);

Line 524: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment8);

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);
527: l_text:='';
528: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment9);

Line 528: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment9);

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);
531: l_text:='';
532: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment10);

Line 532: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment10);

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);
535: l_text:='';
536: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment11);

Line 536: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment11);

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);
539: l_text:='';
540: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment12);

Line 540: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment12);

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);
543: l_text:='';
544: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment13);

Line 544: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment13);

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);
547: l_text:='';
548: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment14);

Line 548: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment14);

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);
551: l_text:='';
552: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment15);

Line 552: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment15);

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);
555: l_text:='';
556: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment16);

Line 556: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment16);

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);
559: l_text:='';
560: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment17);

Line 560: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment17);

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);
563: l_text:='';
564: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment18);

Line 564: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment18);

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);
567: l_text:='';
568: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment19);

Line 568: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment19);

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);
571: l_text:='';
572: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment20);

Line 572: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment20);

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);
575: l_text:='';
576: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment21);

Line 576: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment21);

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);
579: l_text:='';
580: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment22);

Line 580: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment22);

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);
583: l_text:='';
584: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment23);

Line 584: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment23);

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);
587: l_text:='';
588: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment24);

Line 588: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment24);

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);
591: l_text:='';
592: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment25);

Line 592: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment25);

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);
595: l_text:='';
596: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment26);

Line 596: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment26);

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);
599: l_text:='';
600: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment27);

Line 600: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment27);

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);
603: l_text:='';
604: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment28);

Line 604: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment28);

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);
607: l_text:='';
608: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment29);

Line 608: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment29);

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);
611: l_text:='';
612: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment30);

Line 612: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment30);

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);
615: l_text:='';
616: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);

Line 616: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);

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);
619: l_text:='';
620: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment1);

Line 620: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment1);

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);
623: l_text:='';
624: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment2);

Line 624: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment2);

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);
627: l_text:='';
628: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment3);

Line 628: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment3);

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);
631: l_text:='';
632: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment4);

Line 632: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment4);

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);
635: l_text:='';
636: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment5);

Line 636: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment5);

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);
639: l_text:='';
640: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment6);

Line 640: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment6);

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);
643: l_text:='';
644: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment7);

Line 644: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment7);

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);
647: l_text:='';
648: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment8);

Line 648: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment8);

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);
651: l_text:='';
652: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment9);

Line 652: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment9);

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);
655: l_text:='';
656: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment10);

Line 656: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment10);

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);
659: l_text:='';
660: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment11);

Line 660: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment11);

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);
663: l_text:='';
664: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment12);

Line 664: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment12);

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);
667: l_text:='';
668: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment13);

Line 668: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment13);

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);
671: l_text:='';
672: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment14);

Line 672: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment14);

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);
675: l_text:='';
676: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment15);

Line 676: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment15);

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);
679: l_text:='';
680: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment16);

Line 680: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment16);

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);
683: l_text:='';
684: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment17);

Line 684: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment17);

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);
687: l_text:='';
688: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment18);

Line 688: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment18);

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);
691: l_text:='';
692: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment19);

Line 692: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment19);

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);
695: l_text:='';
696: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment20);

Line 696: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment20);

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);
699: l_text:='';
700: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment21);

Line 700: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment21);

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);
703: l_text:='';
704: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment22);

Line 704: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment22);

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);
707: l_text:='';
708: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment23);

Line 708: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment23);

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);
711: l_text:='';
712: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment24);

Line 712: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment24);

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);
715: l_text:='';
716: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment25);

Line 716: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment25);

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);
719: l_text:='';
720: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment26);

Line 720: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment26);

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);
723: l_text:='';
724: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment27);

Line 724: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment27);

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);
727: l_text:='';
728: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment28);

Line 728: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment28);

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);
731: l_text:='';
732: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment29);

Line 732: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment29);

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);
735: l_text:='';
736: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment30);

Line 736: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment30);

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);
739: l_text:='';
740: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);

Line 740: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);

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);
743: l_text:='';
744: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);

Line 776: l_text:=l_text||irc_utilities_pkg.removeTags(p_concat_segments);

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);
779: l_text:='';
780: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_concat_segments);

Line 780: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_concat_segments);

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);
783: l_text:='';
784: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);

Line 800: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);

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);
803: l_text:='';
804: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment2);

Line 804: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment2);

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);
807: l_text:='';
808: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment3);

Line 808: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment3);

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);
811: l_text:='';
812: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment4);

Line 812: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment4);

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);
815: l_text:='';
816: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment5);

Line 816: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment5);

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);
819: l_text:='';
820: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment6);

Line 820: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment6);

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);
823: l_text:='';
824: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment7);

Line 824: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment7);

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);
827: l_text:='';
828: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment8);

Line 828: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment8);

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);
831: l_text:='';
832: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment9);

Line 832: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment9);

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);
835: l_text:='';
836: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment10);

Line 836: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment10);

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);
839: l_text:='';
840: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment11);

Line 840: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment11);

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);
843: l_text:='';
844: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment12);

Line 844: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment12);

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);
847: l_text:='';
848: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment13);

Line 848: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment13);

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);
851: l_text:='';
852: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment14);

Line 852: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment14);

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);
855: l_text:='';
856: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment15);

Line 856: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment15);

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);
859: l_text:='';
860: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment16);

Line 860: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment16);

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);
863: l_text:='';
864: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment17);

Line 864: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment17);

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);
867: l_text:='';
868: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment18);

Line 868: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment18);

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);
871: l_text:='';
872: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment19);

Line 872: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment19);

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);
875: l_text:='';
876: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);

Line 876: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);

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);
879: l_text:='';
880: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);

Line 884: l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);

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);
887: l_text:='';
888: l_text:=l_text||irc_utilities_pkg.removeTags(p_employee_category);

Line 888: l_text:=l_text||irc_utilities_pkg.removeTags(p_employee_category);

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);
891: l_text:='';
892: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_at_home);

Line 892: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_at_home);

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);
895: l_text:='';
896: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);

Line 896: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);

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);
899: l_text:='';
900: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);

Line 904: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);

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);
907: l_text:='';
908: l_text:=l_text||fnd_number.number_to_canonical(p_applicant_rank);