eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CONTINGENT_WORKER_BE1 dependencies on IRC_UTILITIES_PKG

Line 177: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);

173: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
174: l_text:=l_text||'';
175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
176: l_text:='';
177: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_name);
178: l_text:=l_text||'';
179: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
180: l_text:='';
181: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);

Line 185: l_text:=l_text||irc_utilities_pkg.removeTags(p_npw_number);

181: l_text:=l_text||fnd_number.number_to_canonical(p_person_type_id);
182: l_text:=l_text||'';
183: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
184: l_text:='';
185: l_text:=l_text||irc_utilities_pkg.removeTags(p_npw_number);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
188: l_text:='';
189: l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);

Line 189: l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);

185: l_text:=l_text||irc_utilities_pkg.removeTags(p_npw_number);
186: l_text:=l_text||'';
187: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
188: l_text:='';
189: l_text:=l_text||irc_utilities_pkg.removeTags(p_background_check_status);
190: l_text:=l_text||'';
191: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
192: l_text:='';
193: l_text:=l_text||fnd_date.date_to_canonical(p_background_date_check);

Line 197: l_text:=l_text||irc_utilities_pkg.removeTags(p_blood_type);

193: l_text:=l_text||fnd_date.date_to_canonical(p_background_date_check);
194: l_text:=l_text||'';
195: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
196: l_text:='';
197: l_text:=l_text||irc_utilities_pkg.removeTags(p_blood_type);
198: l_text:=l_text||'';
199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
200: l_text:='';
201: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);

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

197: l_text:=l_text||irc_utilities_pkg.removeTags(p_blood_type);
198: l_text:=l_text||'';
199: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
200: l_text:='';
201: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='';
205: l_text:=l_text||irc_utilities_pkg.removeTags(p_correspondence_language);

Line 205: l_text:=l_text||irc_utilities_pkg.removeTags(p_correspondence_language);

201: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);
202: l_text:=l_text||'';
203: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
204: l_text:='';
205: l_text:=l_text||irc_utilities_pkg.removeTags(p_correspondence_language);
206: l_text:=l_text||'';
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
208: l_text:='';
209: l_text:=l_text||irc_utilities_pkg.removeTags(p_country_of_birth);

Line 209: l_text:=l_text||irc_utilities_pkg.removeTags(p_country_of_birth);

205: l_text:=l_text||irc_utilities_pkg.removeTags(p_correspondence_language);
206: l_text:=l_text||'';
207: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
208: l_text:='';
209: l_text:=l_text||irc_utilities_pkg.removeTags(p_country_of_birth);
210: l_text:=l_text||'';
211: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
212: l_text:='';
213: l_text:=l_text||fnd_date.date_to_canonical(p_date_of_birth);

Line 225: l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);

221: l_text:=l_text||fnd_date.date_to_canonical(p_dpdnt_adoption_date);
222: l_text:=l_text||'';
223: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
224: l_text:='';
225: l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);
226: l_text:=l_text||'';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='';
229: l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);

Line 229: l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);

225: l_text:=l_text||irc_utilities_pkg.removeTags(p_dpdnt_vlntry_svce_flag);
226: l_text:=l_text||'';
227: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
228: l_text:='';
229: l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='';
233: l_text:=l_text||irc_utilities_pkg.removeTags(p_first_name);

Line 233: l_text:=l_text||irc_utilities_pkg.removeTags(p_first_name);

229: l_text:=l_text||irc_utilities_pkg.removeTags(p_email_address);
230: l_text:=l_text||'';
231: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
232: l_text:='';
233: l_text:=l_text||irc_utilities_pkg.removeTags(p_first_name);
234: l_text:=l_text||'';
235: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
236: l_text:='';
237: l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);

Line 241: l_text:=l_text||irc_utilities_pkg.removeTags(p_honors);

237: l_text:=l_text||fnd_number.number_to_canonical(p_fte_capacity);
238: l_text:=l_text||'';
239: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
240: l_text:='';
241: l_text:=l_text||irc_utilities_pkg.removeTags(p_honors);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='';
245: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_location);

Line 245: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_location);

241: l_text:=l_text||irc_utilities_pkg.removeTags(p_honors);
242: l_text:=l_text||'';
243: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
244: l_text:='';
245: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_location);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='';
249: l_text:=l_text||irc_utilities_pkg.removeTags(p_known_as);

Line 249: l_text:=l_text||irc_utilities_pkg.removeTags(p_known_as);

245: l_text:=l_text||irc_utilities_pkg.removeTags(p_internal_location);
246: l_text:=l_text||'';
247: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
248: l_text:='';
249: l_text:=l_text||irc_utilities_pkg.removeTags(p_known_as);
250: l_text:=l_text||'';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='';
253: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_medical_test_by);

Line 253: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_medical_test_by);

249: l_text:=l_text||irc_utilities_pkg.removeTags(p_known_as);
250: l_text:=l_text||'';
251: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
252: l_text:='';
253: l_text:=l_text||irc_utilities_pkg.removeTags(p_last_medical_test_by);
254: l_text:=l_text||'';
255: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
256: l_text:='';
257: l_text:=l_text||fnd_date.date_to_canonical(p_last_medical_test_date);

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

257: l_text:=l_text||fnd_date.date_to_canonical(p_last_medical_test_date);
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_mailstop);
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_marital_status);

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

261: l_text:=l_text||irc_utilities_pkg.removeTags(p_mailstop);
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_marital_status);
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_middle_names);

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

265: l_text:=l_text||irc_utilities_pkg.removeTags(p_marital_status);
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_middle_names);
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||irc_utilities_pkg.removeTags(p_national_identifier);

Line 273: l_text:=l_text||irc_utilities_pkg.removeTags(p_national_identifier);

269: l_text:=l_text||irc_utilities_pkg.removeTags(p_middle_names);
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||irc_utilities_pkg.removeTags(p_national_identifier);
274: l_text:=l_text||'';
275: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
276: l_text:='';
277: l_text:=l_text||irc_utilities_pkg.removeTags(p_nationality);

Line 277: l_text:=l_text||irc_utilities_pkg.removeTags(p_nationality);

273: l_text:=l_text||irc_utilities_pkg.removeTags(p_national_identifier);
274: l_text:=l_text||'';
275: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
276: l_text:='';
277: l_text:=l_text||irc_utilities_pkg.removeTags(p_nationality);
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_office_number);

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

277: l_text:=l_text||irc_utilities_pkg.removeTags(p_nationality);
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_office_number);
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_on_military_service);

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

281: l_text:=l_text||irc_utilities_pkg.removeTags(p_office_number);
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_on_military_service);
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||fnd_number.number_to_canonical(p_party_id);

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

289: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);
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_pre_name_adjunct);
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||irc_utilities_pkg.removeTags(p_previous_last_name);

Line 297: l_text:=l_text||irc_utilities_pkg.removeTags(p_previous_last_name);

293: l_text:=l_text||irc_utilities_pkg.removeTags(p_pre_name_adjunct);
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||irc_utilities_pkg.removeTags(p_previous_last_name);
298: l_text:=l_text||'';
299: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
300: l_text:='';
301: l_text:=l_text||fnd_date.date_to_canonical(p_projected_placement_end);

Line 309: l_text:=l_text||irc_utilities_pkg.removeTags(p_region_of_birth);

305: l_text:=l_text||fnd_date.date_to_canonical(p_receipt_of_death_cert_date);
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||irc_utilities_pkg.removeTags(p_region_of_birth);
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_registered_disabled_flag);

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

309: l_text:=l_text||irc_utilities_pkg.removeTags(p_region_of_birth);
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_registered_disabled_flag);
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||irc_utilities_pkg.removeTags(p_resume_exists);

Line 317: l_text:=l_text||irc_utilities_pkg.removeTags(p_resume_exists);

313: l_text:=l_text||irc_utilities_pkg.removeTags(p_registered_disabled_flag);
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||irc_utilities_pkg.removeTags(p_resume_exists);
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||fnd_date.date_to_canonical(p_resume_last_updated);

Line 325: l_text:=l_text||irc_utilities_pkg.removeTags(p_second_passport_exists);

321: l_text:=l_text||fnd_date.date_to_canonical(p_resume_last_updated);
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||irc_utilities_pkg.removeTags(p_second_passport_exists);
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_sex);

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

325: l_text:=l_text||irc_utilities_pkg.removeTags(p_second_passport_exists);
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_sex);
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_student_status);

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

329: l_text:=l_text||irc_utilities_pkg.removeTags(p_sex);
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_student_status);
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_suffix);

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

333: l_text:=l_text||irc_utilities_pkg.removeTags(p_student_status);
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_suffix);
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_title); <h5>Line 341: l_text:=l_text||irc_utilities_pkg.removeTags(p_title); </h5> 337: l_text:=l_text||irc_utilities_pkg.removeTags(p_suffix); 338: l_text:=l_text||'</suffix>'; 339: dbms_lob.writeAppend(l_event_data,length(l_text),l_text); 340: l_text:='<title>'; 341: l_text:=l_text||irc_utilities_pkg.removeTags(p_title); 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_town_of_birth);

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

341: l_text:=l_text||irc_utilities_pkg.removeTags(p_title);
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_town_of_birth);
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_uses_tobacco_flag);

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

345: l_text:=l_text||irc_utilities_pkg.removeTags(p_town_of_birth);
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_uses_tobacco_flag);
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||fnd_number.number_to_canonical(p_vendor_id);

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

353: l_text:=l_text||fnd_number.number_to_canonical(p_vendor_id);
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_work_schedule);
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_work_telephone);

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

357: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_schedule);
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_work_telephone);
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_exp_check_send_to_address);

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

361: l_text:=l_text||irc_utilities_pkg.removeTags(p_work_telephone);
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_exp_check_send_to_address);
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||fnd_date.date_to_canonical(p_hold_applicant_date_until);

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

377: l_text:=l_text||fnd_number.number_to_canonical(p_benefit_group_id);
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_coord_ben_med_pln_no);
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_coord_ben_no_cvg_flag);

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

381: l_text:=l_text||irc_utilities_pkg.removeTags(p_coord_ben_med_pln_no);
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_coord_ben_no_cvg_flag);
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||fnd_date.date_to_canonical(p_original_date_of_hire);

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

389: l_text:=l_text||fnd_date.date_to_canonical(p_original_date_of_hire);
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_attribute_category);
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_attribute1);

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

393: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);
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_attribute1);
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_attribute2);

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

397: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute1);
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_attribute2);
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_attribute3);

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

401: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute2);
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_attribute3);
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_attribute4);

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

405: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute3);
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_attribute4);
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_attribute5);

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

409: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute4);
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_attribute5);
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_attribute6);

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

413: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute5);
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_attribute6);
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_attribute7);

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

417: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute6);
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_attribute7);
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_attribute8);

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

421: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute7);
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_attribute8);
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_attribute9);

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

425: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute8);
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_attribute9);
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_attribute10);

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

429: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute9);
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_attribute10);
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_attribute11);

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

433: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute10);
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_attribute11);
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_attribute12);

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

437: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute11);
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_attribute12);
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_attribute13);

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

441: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute12);
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_attribute13);
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_attribute14);

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

445: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute13);
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_attribute14);
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_attribute15);

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

449: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute14);
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_attribute15);
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_attribute16);

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

453: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute15);
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_attribute16);
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_attribute17);

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

457: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute16);
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_attribute17);
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_attribute18);

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

461: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute17);
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_attribute18);
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_attribute19);

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

465: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute18);
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_attribute19);
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_attribute20);

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

469: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute19);
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_attribute20);
474: l_text:=l_text||'';
475: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
476: l_text:='';
477: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute21);

Line 477: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute21);

473: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute20);
474: l_text:=l_text||'';
475: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
476: l_text:='';
477: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute21);
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_attribute22);

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

477: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute21);
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_attribute22);
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_attribute23);

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

481: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute22);
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_attribute23);
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_attribute24);

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

485: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute23);
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_attribute24);
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_attribute25);

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

489: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute24);
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_attribute25);
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_attribute26);

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

493: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute25);
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_attribute26);
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_attribute27);

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

497: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute26);
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_attribute27);
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_attribute28);

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

501: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute27);
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_attribute28);
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_attribute29);

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

505: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute28);
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_attribute29);
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_attribute30);

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

509: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute29);
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_attribute30);
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_per_information_category);

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

513: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute30);
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_per_information_category);
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_per_information1);

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

517: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information_category);
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_per_information1);
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_per_information2);

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

521: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information1);
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_per_information2);
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_per_information3);

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

525: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information2);
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_per_information3);
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_per_information4);

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

529: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information3);
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_per_information4);
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_per_information5);

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

533: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information4);
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_per_information5);
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_per_information6);

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

537: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information5);
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_per_information6);
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_per_information7);

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

541: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information6);
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_per_information7);
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_per_information8);

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

545: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information7);
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_per_information8);
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_per_information9);

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

549: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information8);
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_per_information9);
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_per_information10);

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

553: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information9);
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_per_information10);
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_per_information11);

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

557: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information10);
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_per_information11);
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_per_information12);

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

561: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information11);
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_per_information12);
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_per_information13);

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

565: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information12);
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_per_information13);
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_per_information14);

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

569: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information13);
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_per_information14);
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_per_information15);

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

573: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information14);
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_per_information15);
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_per_information16);

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

577: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information15);
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_per_information16);
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_per_information17);

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

581: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information16);
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_per_information17);
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_per_information18);

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

585: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information17);
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_per_information18);
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_per_information19);

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

589: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information18);
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_per_information19);
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_per_information20);

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

593: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information19);
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_per_information20);
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_per_information21);

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

597: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information20);
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_per_information21);
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_per_information22);

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

601: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information21);
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_per_information22);
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_per_information23);

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

605: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information22);
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_per_information23);
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_per_information24);

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

609: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information23);
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_per_information24);
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_per_information25);

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

613: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information24);
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_per_information25);
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_per_information26);

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

617: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information25);
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_per_information26);
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_per_information27);

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

621: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information26);
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_per_information27);
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_per_information28);

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

625: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information27);
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_per_information28);
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_per_information29);

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

629: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information28);
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_per_information29);
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_per_information30);

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

633: l_text:=l_text||irc_utilities_pkg.removeTags(p_per_information29);
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_per_information30);
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||fnd_number.number_to_canonical(p_person_id);

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

657: l_text:=l_text||fnd_number.number_to_canonical(p_pdp_object_version_number);
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_full_name);
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||fnd_number.number_to_canonical(p_comment_id);

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

677: l_text:=l_text||fnd_number.number_to_canonical(p_assignment_sequence);
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_assignment_number);
682: l_text:=l_text||'';
683: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
684: l_text:='';
685: if(P_NAME_COMBINATION_WARNING) then