APPS.HR_ASSIGNMENT_BE1 dependencies on IRC_UTILITIES_PKG

Line 261: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);

257: l_text:=l_text||fnd_number.number_to_canonical(p_pay_basis_id);
258: l_text:=l_text||'';
259: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
260: l_text:='';
261: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);
262: l_text:=l_text||'';
263: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
264: l_text:='';
265: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);

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

261: l_text:=l_text||irc_utilities_pkg.removeTags(p_assignment_number);
262: l_text:=l_text||'';
263: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
264: l_text:='';
265: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
266: l_text:=l_text||'';
267: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
268: l_text:='';
269: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

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

265: l_text:=l_text||irc_utilities_pkg.removeTags(p_change_reason);
266: l_text:=l_text||'';
267: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
268: l_text:='';
269: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
270: l_text:=l_text||'';
271: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
272: l_text:='';
273: l_text:=l_text||fnd_date.date_to_canonical(p_date_probation_end);

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

277: l_text:=l_text||fnd_number.number_to_canonical(p_default_code_comb_id);
278: l_text:=l_text||'';
279: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
280: l_text:='';
281: l_text:=l_text||irc_utilities_pkg.removeTags(p_employment_category);
282: l_text:=l_text||'';
283: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
284: l_text:='';
285: l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);

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

281: l_text:=l_text||irc_utilities_pkg.removeTags(p_employment_category);
282: l_text:=l_text||'';
283: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
284: l_text:='';
285: l_text:=l_text||irc_utilities_pkg.removeTags(p_frequency);
286: l_text:=l_text||'';
287: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
288: l_text:='';
289: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_address_line);

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

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

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

289: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_address_line);
290: l_text:=l_text||'';
291: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
292: l_text:='';
293: l_text:=l_text||irc_utilities_pkg.removeTags(p_manager_flag);
294: l_text:=l_text||'';
295: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
296: l_text:='';
297: l_text:=l_text||fnd_number.number_to_canonical(p_normal_hours);

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

301: l_text:=l_text||fnd_number.number_to_canonical(p_perf_review_period);
302: l_text:=l_text||'';
303: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
304: l_text:='';
305: l_text:=l_text||irc_utilities_pkg.removeTags(p_perf_review_period_frequency);
306: l_text:=l_text||'';
307: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
308: l_text:='';
309: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);

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

309: l_text:=l_text||fnd_number.number_to_canonical(p_probation_period);
310: l_text:=l_text||'';
311: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
312: l_text:='';
313: l_text:=l_text||irc_utilities_pkg.removeTags(p_probation_unit);
314: l_text:=l_text||'';
315: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
316: l_text:='';
317: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);

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

317: l_text:=l_text||fnd_number.number_to_canonical(p_sal_review_period);
318: l_text:=l_text||'';
319: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
320: l_text:='';
321: l_text:=l_text||irc_utilities_pkg.removeTags(p_sal_review_period_frequency);
322: l_text:=l_text||'';
323: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
324: l_text:='';
325: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);

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

325: l_text:=l_text||fnd_number.number_to_canonical(p_set_of_books_id);
326: l_text:=l_text||'';
327: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
328: l_text:='';
329: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
330: l_text:=l_text||'';
331: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
332: l_text:='';
333: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);

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

329: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_type);
330: l_text:=l_text||'';
331: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
332: l_text:='';
333: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);
334: l_text:=l_text||'';
335: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
336: l_text:='';
337: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_start);

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

333: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_finish);
334: l_text:=l_text||'';
335: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
336: l_text:='';
337: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_start);
338: l_text:=l_text||'';
339: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
340: l_text:='';
341: l_text:=l_text||irc_utilities_pkg.removeTags(p_bargaining_unit_code);

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

337: l_text:=l_text||irc_utilities_pkg.removeTags(p_time_normal_start);
338: l_text:=l_text||'';
339: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
340: l_text:='';
341: l_text:=l_text||irc_utilities_pkg.removeTags(p_bargaining_unit_code);
342: l_text:=l_text||'';
343: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
344: l_text:='';
345: l_text:=l_text||irc_utilities_pkg.removeTags(p_labour_union_member_flag);

Line 345: l_text:=l_text||irc_utilities_pkg.removeTags(p_labour_union_member_flag);

341: l_text:=l_text||irc_utilities_pkg.removeTags(p_bargaining_unit_code);
342: l_text:=l_text||'';
343: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
344: l_text:='';
345: l_text:=l_text||irc_utilities_pkg.removeTags(p_labour_union_member_flag);
346: l_text:=l_text||'';
347: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
348: l_text:='';
349: l_text:=l_text||irc_utilities_pkg.removeTags(p_hourly_salaried_code);

Line 349: l_text:=l_text||irc_utilities_pkg.removeTags(p_hourly_salaried_code);

345: l_text:=l_text||irc_utilities_pkg.removeTags(p_labour_union_member_flag);
346: l_text:=l_text||'';
347: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
348: l_text:='';
349: l_text:=l_text||irc_utilities_pkg.removeTags(p_hourly_salaried_code);
350: l_text:=l_text||'';
351: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
352: l_text:='';
353: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute_category);

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

349: l_text:=l_text||irc_utilities_pkg.removeTags(p_hourly_salaried_code);
350: l_text:=l_text||'';
351: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
352: l_text:='';
353: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute_category);
354: l_text:=l_text||'';
355: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
356: l_text:='';
357: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute1);

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

353: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute_category);
354: l_text:=l_text||'';
355: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
356: l_text:='';
357: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute1);
358: l_text:=l_text||'';
359: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
360: l_text:='';
361: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute2);

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

357: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute1);
358: l_text:=l_text||'';
359: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
360: l_text:='';
361: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute2);
362: l_text:=l_text||'';
363: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
364: l_text:='';
365: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute3);

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

361: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute2);
362: l_text:=l_text||'';
363: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
364: l_text:='';
365: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute3);
366: l_text:=l_text||'';
367: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
368: l_text:='';
369: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute4);

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

365: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute3);
366: l_text:=l_text||'';
367: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
368: l_text:='';
369: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute4);
370: l_text:=l_text||'';
371: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
372: l_text:='';
373: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute5);

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

369: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute4);
370: l_text:=l_text||'';
371: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
372: l_text:='';
373: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute5);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='';
377: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute6);

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

373: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute5);
374: l_text:=l_text||'';
375: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
376: l_text:='';
377: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute6);
378: l_text:=l_text||'';
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='';
381: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute7);

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

377: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute6);
378: l_text:=l_text||'';
379: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
380: l_text:='';
381: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute7);
382: l_text:=l_text||'';
383: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
384: l_text:='';
385: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute8);

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

381: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute7);
382: l_text:=l_text||'';
383: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
384: l_text:='';
385: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute8);
386: l_text:=l_text||'';
387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
388: l_text:='';
389: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute9);

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

385: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute8);
386: l_text:=l_text||'';
387: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
388: l_text:='';
389: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute9);
390: l_text:=l_text||'';
391: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
392: l_text:='';
393: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute10);

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

389: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute9);
390: l_text:=l_text||'';
391: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
392: l_text:='';
393: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute10);
394: l_text:=l_text||'';
395: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
396: l_text:='';
397: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute11);

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

393: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute10);
394: l_text:=l_text||'';
395: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
396: l_text:='';
397: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute11);
398: l_text:=l_text||'';
399: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
400: l_text:='';
401: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute12);

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

397: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute11);
398: l_text:=l_text||'';
399: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
400: l_text:='';
401: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute12);
402: l_text:=l_text||'';
403: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
404: l_text:='';
405: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute13);

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

401: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute12);
402: l_text:=l_text||'';
403: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
404: l_text:='';
405: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute13);
406: l_text:=l_text||'';
407: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
408: l_text:='';
409: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute14);

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

405: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute13);
406: l_text:=l_text||'';
407: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
408: l_text:='';
409: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute14);
410: l_text:=l_text||'';
411: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
412: l_text:='';
413: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute15);

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

409: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute14);
410: l_text:=l_text||'';
411: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
412: l_text:='';
413: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute15);
414: l_text:=l_text||'';
415: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
416: l_text:='';
417: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute16);

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

413: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute15);
414: l_text:=l_text||'';
415: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
416: l_text:='';
417: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute16);
418: l_text:=l_text||'';
419: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
420: l_text:='';
421: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute17);

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

417: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute16);
418: l_text:=l_text||'';
419: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
420: l_text:='';
421: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute17);
422: l_text:=l_text||'';
423: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
424: l_text:='';
425: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute18);

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

421: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute17);
422: l_text:=l_text||'';
423: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
424: l_text:='';
425: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute18);
426: l_text:=l_text||'';
427: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
428: l_text:='';
429: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute19);

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

425: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute18);
426: l_text:=l_text||'';
427: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
428: l_text:='';
429: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute19);
430: l_text:=l_text||'';
431: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
432: l_text:='';
433: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute20);

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

429: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute19);
430: l_text:=l_text||'';
431: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
432: l_text:='';
433: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute20);
434: l_text:=l_text||'';
435: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
436: l_text:='';
437: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute21);

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

433: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute20);
434: l_text:=l_text||'';
435: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
436: l_text:='';
437: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute21);
438: l_text:=l_text||'';
439: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
440: l_text:='';
441: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute22);

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

437: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute21);
438: l_text:=l_text||'';
439: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
440: l_text:='';
441: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute22);
442: l_text:=l_text||'';
443: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
444: l_text:='';
445: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute23);

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

441: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute22);
442: l_text:=l_text||'';
443: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
444: l_text:='';
445: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute23);
446: l_text:=l_text||'';
447: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
448: l_text:='';
449: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute24);

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

445: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute23);
446: l_text:=l_text||'';
447: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
448: l_text:='';
449: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute24);
450: l_text:=l_text||'';
451: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
452: l_text:='';
453: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute25);

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

449: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute24);
450: l_text:=l_text||'';
451: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
452: l_text:='';
453: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute25);
454: l_text:=l_text||'';
455: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
456: l_text:='';
457: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute26);

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

453: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute25);
454: l_text:=l_text||'';
455: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
456: l_text:='';
457: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute26);
458: l_text:=l_text||'';
459: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
460: l_text:='';
461: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute27);

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

457: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute26);
458: l_text:=l_text||'';
459: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
460: l_text:='';
461: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute27);
462: l_text:=l_text||'';
463: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
464: l_text:='';
465: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute28);

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

461: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute27);
462: l_text:=l_text||'';
463: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
464: l_text:='';
465: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute28);
466: l_text:=l_text||'';
467: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
468: l_text:='';
469: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute29);

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

465: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute28);
466: l_text:=l_text||'';
467: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
468: l_text:='';
469: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute29);
470: l_text:=l_text||'';
471: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
472: l_text:='';
473: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute30);

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

469: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute29);
470: l_text:=l_text||'';
471: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
472: l_text:='';
473: l_text:=l_text||irc_utilities_pkg.removeTags(p_ass_attribute30);
474: l_text:=l_text||'';
475: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
476: l_text:='';
479: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
480: l_text:='';
481: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment1);

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

477: l_text:=l_text||irc_utilities_pkg.removeTags(p_title);
478: l_text:=l_text||'';
479: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
480: l_text:='';
481: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment1);
482: l_text:=l_text||'';
483: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
484: l_text:='';
485: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment2);

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

481: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment1);
482: l_text:=l_text||'';
483: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
484: l_text:='';
485: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment2);
486: l_text:=l_text||'';
487: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
488: l_text:='';
489: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment3);

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

485: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment2);
486: l_text:=l_text||'';
487: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
488: l_text:='';
489: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment3);
490: l_text:=l_text||'';
491: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
492: l_text:='';
493: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment4);

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

489: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment3);
490: l_text:=l_text||'';
491: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
492: l_text:='';
493: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment4);
494: l_text:=l_text||'';
495: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
496: l_text:='';
497: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment5);

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

493: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment4);
494: l_text:=l_text||'';
495: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
496: l_text:='';
497: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment5);
498: l_text:=l_text||'';
499: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
500: l_text:='';
501: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment6);

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

497: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment5);
498: l_text:=l_text||'';
499: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
500: l_text:='';
501: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment6);
502: l_text:=l_text||'';
503: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
504: l_text:='';
505: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment7);

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

501: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment6);
502: l_text:=l_text||'';
503: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
504: l_text:='';
505: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment7);
506: l_text:=l_text||'';
507: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
508: l_text:='';
509: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment8);

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

505: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment7);
506: l_text:=l_text||'';
507: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
508: l_text:='';
509: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment8);
510: l_text:=l_text||'';
511: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
512: l_text:='';
513: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment9);

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

509: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment8);
510: l_text:=l_text||'';
511: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
512: l_text:='';
513: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment9);
514: l_text:=l_text||'';
515: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
516: l_text:='';
517: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment10);

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

513: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment9);
514: l_text:=l_text||'';
515: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
516: l_text:='';
517: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment10);
518: l_text:=l_text||'';
519: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
520: l_text:='';
521: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment11);

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

517: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment10);
518: l_text:=l_text||'';
519: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
520: l_text:='';
521: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment11);
522: l_text:=l_text||'';
523: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
524: l_text:='';
525: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment12);

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

521: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment11);
522: l_text:=l_text||'';
523: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
524: l_text:='';
525: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment12);
526: l_text:=l_text||'';
527: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
528: l_text:='';
529: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment13);

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

525: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment12);
526: l_text:=l_text||'';
527: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
528: l_text:='';
529: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment13);
530: l_text:=l_text||'';
531: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
532: l_text:='';
533: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment14);

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

529: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment13);
530: l_text:=l_text||'';
531: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
532: l_text:='';
533: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment14);
534: l_text:=l_text||'';
535: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
536: l_text:='';
537: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment15);

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

533: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment14);
534: l_text:=l_text||'';
535: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
536: l_text:='';
537: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment15);
538: l_text:=l_text||'';
539: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
540: l_text:='';
541: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment16);

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

537: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment15);
538: l_text:=l_text||'';
539: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
540: l_text:='';
541: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment16);
542: l_text:=l_text||'';
543: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
544: l_text:='';
545: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment17);

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

541: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment16);
542: l_text:=l_text||'';
543: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
544: l_text:='';
545: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment17);
546: l_text:=l_text||'';
547: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
548: l_text:='';
549: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment18);

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

545: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment17);
546: l_text:=l_text||'';
547: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
548: l_text:='';
549: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment18);
550: l_text:=l_text||'';
551: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
552: l_text:='';
553: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment19);

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

549: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment18);
550: l_text:=l_text||'';
551: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
552: l_text:='';
553: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment19);
554: l_text:=l_text||'';
555: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
556: l_text:='';
557: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment20);

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

553: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment19);
554: l_text:=l_text||'';
555: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
556: l_text:='';
557: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment20);
558: l_text:=l_text||'';
559: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
560: l_text:='';
561: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment21);

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

557: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment20);
558: l_text:=l_text||'';
559: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
560: l_text:='';
561: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment21);
562: l_text:=l_text||'';
563: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
564: l_text:='';
565: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment22);

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

561: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment21);
562: l_text:=l_text||'';
563: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
564: l_text:='';
565: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment22);
566: l_text:=l_text||'';
567: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
568: l_text:='';
569: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment23);

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

565: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment22);
566: l_text:=l_text||'';
567: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
568: l_text:='';
569: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment23);
570: l_text:=l_text||'';
571: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
572: l_text:='';
573: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment24);

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

569: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment23);
570: l_text:=l_text||'';
571: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
572: l_text:='';
573: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment24);
574: l_text:=l_text||'';
575: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
576: l_text:='';
577: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment25);

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

573: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment24);
574: l_text:=l_text||'';
575: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
576: l_text:='';
577: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment25);
578: l_text:=l_text||'';
579: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
580: l_text:='';
581: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment26);

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

577: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment25);
578: l_text:=l_text||'';
579: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
580: l_text:='';
581: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment26);
582: l_text:=l_text||'';
583: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
584: l_text:='';
585: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment27);

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

581: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment26);
582: l_text:=l_text||'';
583: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
584: l_text:='';
585: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment27);
586: l_text:=l_text||'';
587: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
588: l_text:='';
589: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment28);

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

585: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment27);
586: l_text:=l_text||'';
587: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
588: l_text:='';
589: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment28);
590: l_text:=l_text||'';
591: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
592: l_text:='';
593: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment29);

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

589: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment28);
590: l_text:=l_text||'';
591: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
592: l_text:='';
593: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment29);
594: l_text:=l_text||'';
595: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
596: l_text:='';
597: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment30);

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

593: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment29);
594: l_text:=l_text||'';
595: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
596: l_text:='';
597: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment30);
598: l_text:=l_text||'';
599: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
600: l_text:='';
601: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);

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

597: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_segment30);
598: l_text:=l_text||'';
599: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
600: l_text:='';
601: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
602: l_text:=l_text||'';
603: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
604: l_text:='';
605: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment1);

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

601: l_text:=l_text||irc_utilities_pkg.removeTags(p_concatenated_segments);
602: l_text:=l_text||'';
603: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
604: l_text:='';
605: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment1);
606: l_text:=l_text||'';
607: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
608: l_text:='';
609: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment2);

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

605: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment1);
606: l_text:=l_text||'';
607: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
608: l_text:='';
609: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment2);
610: l_text:=l_text||'';
611: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
612: l_text:='';
613: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment3);

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

609: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment2);
610: l_text:=l_text||'';
611: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
612: l_text:='';
613: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment3);
614: l_text:=l_text||'';
615: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
616: l_text:='';
617: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment4);

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

613: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment3);
614: l_text:=l_text||'';
615: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
616: l_text:='';
617: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment4);
618: l_text:=l_text||'';
619: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
620: l_text:='';
621: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment5);

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

617: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment4);
618: l_text:=l_text||'';
619: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
620: l_text:='';
621: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment5);
622: l_text:=l_text||'';
623: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
624: l_text:='';
625: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment6);

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

621: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment5);
622: l_text:=l_text||'';
623: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
624: l_text:='';
625: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment6);
626: l_text:=l_text||'';
627: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
628: l_text:='';
629: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment7);

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

625: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment6);
626: l_text:=l_text||'';
627: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
628: l_text:='';
629: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment7);
630: l_text:=l_text||'';
631: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
632: l_text:='';
633: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment8);

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

629: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment7);
630: l_text:=l_text||'';
631: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
632: l_text:='';
633: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment8);
634: l_text:=l_text||'';
635: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
636: l_text:='';
637: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment9);

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

633: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment8);
634: l_text:=l_text||'';
635: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
636: l_text:='';
637: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment9);
638: l_text:=l_text||'';
639: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
640: l_text:='';
641: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment10);

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

637: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment9);
638: l_text:=l_text||'';
639: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
640: l_text:='';
641: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment10);
642: l_text:=l_text||'';
643: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
644: l_text:='';
645: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment11);

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

641: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment10);
642: l_text:=l_text||'';
643: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
644: l_text:='';
645: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment11);
646: l_text:=l_text||'';
647: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
648: l_text:='';
649: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment12);

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

645: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment11);
646: l_text:=l_text||'';
647: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
648: l_text:='';
649: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment12);
650: l_text:=l_text||'';
651: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
652: l_text:='';
653: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment13);

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

649: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment12);
650: l_text:=l_text||'';
651: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
652: l_text:='';
653: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment13);
654: l_text:=l_text||'';
655: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
656: l_text:='';
657: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment14);

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

653: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment13);
654: l_text:=l_text||'';
655: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
656: l_text:='';
657: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment14);
658: l_text:=l_text||'';
659: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
660: l_text:='';
661: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment15);

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

657: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment14);
658: l_text:=l_text||'';
659: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
660: l_text:='';
661: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment15);
662: l_text:=l_text||'';
663: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
664: l_text:='';
665: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment16);

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

661: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment15);
662: l_text:=l_text||'';
663: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
664: l_text:='';
665: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment16);
666: l_text:=l_text||'';
667: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
668: l_text:='';
669: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment17);

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

665: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment16);
666: l_text:=l_text||'';
667: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
668: l_text:='';
669: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment17);
670: l_text:=l_text||'';
671: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
672: l_text:='';
673: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment18);

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

669: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment17);
670: l_text:=l_text||'';
671: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
672: l_text:='';
673: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment18);
674: l_text:=l_text||'';
675: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
676: l_text:='';
677: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment19);

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

673: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment18);
674: l_text:=l_text||'';
675: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
676: l_text:='';
677: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment19);
678: l_text:=l_text||'';
679: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
680: l_text:='';
681: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment20);

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

677: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment19);
678: l_text:=l_text||'';
679: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
680: l_text:='';
681: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment20);
682: l_text:=l_text||'';
683: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
684: l_text:='';
685: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment21);

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

681: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment20);
682: l_text:=l_text||'';
683: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
684: l_text:='';
685: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment21);
686: l_text:=l_text||'';
687: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
688: l_text:='';
689: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment22);

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

685: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment21);
686: l_text:=l_text||'';
687: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
688: l_text:='';
689: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment22);
690: l_text:=l_text||'';
691: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
692: l_text:='';
693: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment23);

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

689: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment22);
690: l_text:=l_text||'';
691: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
692: l_text:='';
693: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment23);
694: l_text:=l_text||'';
695: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
696: l_text:='';
697: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment24);

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

693: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment23);
694: l_text:=l_text||'';
695: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
696: l_text:='';
697: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment24);
698: l_text:=l_text||'';
699: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
700: l_text:='';
701: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment25);

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

697: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment24);
698: l_text:=l_text||'';
699: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
700: l_text:='';
701: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment25);
702: l_text:=l_text||'';
703: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
704: l_text:='';
705: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment26);

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

701: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment25);
702: l_text:=l_text||'';
703: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
704: l_text:='';
705: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment26);
706: l_text:=l_text||'';
707: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
708: l_text:='';
709: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment27);

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

705: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment26);
706: l_text:=l_text||'';
707: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
708: l_text:='';
709: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment27);
710: l_text:=l_text||'';
711: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
712: l_text:='';
713: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment28);

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

709: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment27);
710: l_text:=l_text||'';
711: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
712: l_text:='';
713: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment28);
714: l_text:=l_text||'';
715: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
716: l_text:='';
717: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment29);

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

713: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment28);
714: l_text:=l_text||'';
715: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
716: l_text:='';
717: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment29);
718: l_text:=l_text||'';
719: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
720: l_text:='';
721: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment30);

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

717: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment29);
718: l_text:=l_text||'';
719: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
720: l_text:='';
721: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_segment30);
722: l_text:=l_text||'';
723: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
724: l_text:='';
725: l_text:=l_text||fnd_number.number_to_canonical(p_contract_id);

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

737: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_id_flex_num);
738: l_text:=l_text||'';
739: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
740: l_text:='';
741: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);
742: l_text:=l_text||'';
743: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
744: l_text:='';
745: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment2);

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

741: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment1);
742: l_text:=l_text||'';
743: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
744: l_text:='';
745: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment2);
746: l_text:=l_text||'';
747: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
748: l_text:='';
749: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment3);

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

745: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment2);
746: l_text:=l_text||'';
747: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
748: l_text:='';
749: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment3);
750: l_text:=l_text||'';
751: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
752: l_text:='';
753: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment4);

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

749: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment3);
750: l_text:=l_text||'';
751: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
752: l_text:='';
753: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment4);
754: l_text:=l_text||'';
755: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
756: l_text:='';
757: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment5);

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

753: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment4);
754: l_text:=l_text||'';
755: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
756: l_text:='';
757: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment5);
758: l_text:=l_text||'';
759: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
760: l_text:='';
761: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment6);

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

757: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment5);
758: l_text:=l_text||'';
759: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
760: l_text:='';
761: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment6);
762: l_text:=l_text||'';
763: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
764: l_text:='';
765: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment7);

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

761: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment6);
762: l_text:=l_text||'';
763: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
764: l_text:='';
765: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment7);
766: l_text:=l_text||'';
767: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
768: l_text:='';
769: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment8);

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

765: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment7);
766: l_text:=l_text||'';
767: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
768: l_text:='';
769: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment8);
770: l_text:=l_text||'';
771: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
772: l_text:='';
773: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment9);

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

769: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment8);
770: l_text:=l_text||'';
771: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
772: l_text:='';
773: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment9);
774: l_text:=l_text||'';
775: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
776: l_text:='';
777: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment10);

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

773: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment9);
774: l_text:=l_text||'';
775: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
776: l_text:='';
777: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment10);
778: l_text:=l_text||'';
779: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
780: l_text:='';
781: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment11);

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

777: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment10);
778: l_text:=l_text||'';
779: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
780: l_text:='';
781: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment11);
782: l_text:=l_text||'';
783: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
784: l_text:='';
785: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment12);

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

781: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment11);
782: l_text:=l_text||'';
783: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
784: l_text:='';
785: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment12);
786: l_text:=l_text||'';
787: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
788: l_text:='';
789: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment13);

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

785: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment12);
786: l_text:=l_text||'';
787: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
788: l_text:='';
789: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment13);
790: l_text:=l_text||'';
791: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
792: l_text:='';
793: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment14);

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

789: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment13);
790: l_text:=l_text||'';
791: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
792: l_text:='';
793: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment14);
794: l_text:=l_text||'';
795: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
796: l_text:='';
797: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment15);

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

793: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment14);
794: l_text:=l_text||'';
795: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
796: l_text:='';
797: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment15);
798: l_text:=l_text||'';
799: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
800: l_text:='';
801: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment16);

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

797: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment15);
798: l_text:=l_text||'';
799: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
800: l_text:='';
801: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment16);
802: l_text:=l_text||'';
803: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
804: l_text:='';
805: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment17);

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

801: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment16);
802: l_text:=l_text||'';
803: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
804: l_text:='';
805: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment17);
806: l_text:=l_text||'';
807: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
808: l_text:='';
809: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment18);

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

805: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment17);
806: l_text:=l_text||'';
807: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
808: l_text:='';
809: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment18);
810: l_text:=l_text||'';
811: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
812: l_text:='';
813: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment19);

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

809: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment18);
810: l_text:=l_text||'';
811: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
812: l_text:='';
813: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment19);
814: l_text:=l_text||'';
815: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
816: l_text:='';
817: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);

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

813: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment19);
814: l_text:=l_text||'';
815: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
816: l_text:='';
817: l_text:=l_text||irc_utilities_pkg.removeTags(p_cag_segment20);
818: l_text:=l_text||'';
819: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
820: l_text:='';
821: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);

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

821: l_text:=l_text||fnd_number.number_to_canonical(p_notice_period);
822: l_text:=l_text||'';
823: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
824: l_text:='';
825: l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);
826: l_text:=l_text||'';
827: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
828: l_text:='';
829: l_text:=l_text||irc_utilities_pkg.removeTags(p_employee_category);

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

825: l_text:=l_text||irc_utilities_pkg.removeTags(p_notice_period_uom);
826: l_text:=l_text||'';
827: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
828: l_text:='';
829: l_text:=l_text||irc_utilities_pkg.removeTags(p_employee_category);
830: l_text:=l_text||'';
831: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
832: l_text:='';
833: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_at_home);

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

829: l_text:=l_text||irc_utilities_pkg.removeTags(p_employee_category);
830: l_text:=l_text||'';
831: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
832: l_text:='';
833: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_at_home);
834: l_text:=l_text||'';
835: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
836: l_text:='';
837: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);

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

833: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_at_home);
834: l_text:=l_text||'';
835: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
836: l_text:='';
837: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
838: l_text:=l_text||'';
839: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
840: l_text:='';
841: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);

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

837: l_text:=l_text||irc_utilities_pkg.removeTags(p_job_post_source_name);
838: l_text:=l_text||'';
839: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
840: l_text:='';
841: l_text:=l_text||irc_utilities_pkg.removeTags(p_cagr_concatenated_segments);
842: l_text:=l_text||'';
843: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
844: l_text:='';
845: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);

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

845: l_text:=l_text||fnd_number.number_to_canonical(p_cagr_grade_def_id);
846: l_text:=l_text||'';
847: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
848: l_text:='';
849: l_text:=l_text||irc_utilities_pkg.removeTags(p_group_name);
850: l_text:=l_text||'';
851: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
852: l_text:='';
853: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_id);

Line 901: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_concat_segments);

897: end if;
898: l_text:=l_text||'';
899: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
900: l_text:='';
901: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_concat_segments);
902: l_text:=l_text||'';
903: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
904: l_text:='';
905: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_concat_segments);

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

901: l_text:=l_text||irc_utilities_pkg.removeTags(p_pgp_concat_segments);
902: l_text:=l_text||'';
903: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
904: l_text:='';
905: l_text:=l_text||irc_utilities_pkg.removeTags(p_scl_concat_segments);
906: l_text:=l_text||'';
907: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
908: l_text:='';
909: l_text:=l_text||fnd_number.number_to_canonical(p_grade_ladder_pgm_id);