346: IS
347: m_existing_text long :=existing_text;
348: begin
349: if (m_a1 is not null ) then
350: m_existing_text := m_existing_text || m_a1 || fnd_global.local_chr(10);
351: end if;
352:
353: if (m_a2 is not null ) then
354: m_existing_text := m_existing_text || m_a2 || fnd_global.local_chr(10);
350: m_existing_text := m_existing_text || m_a1 || fnd_global.local_chr(10);
351: end if;
352:
353: if (m_a2 is not null ) then
354: m_existing_text := m_existing_text || m_a2 || fnd_global.local_chr(10);
355: end if;
356:
357: if (m_a3 is not null ) then
358: m_existing_text := m_existing_text || m_a3 || fnd_global.local_chr(10);
354: m_existing_text := m_existing_text || m_a2 || fnd_global.local_chr(10);
355: end if;
356:
357: if (m_a3 is not null ) then
358: m_existing_text := m_existing_text || m_a3 || fnd_global.local_chr(10);
359: end if;
360:
361: if (m_a4 is not null ) then
362: m_existing_text := m_existing_text || m_a4 || fnd_global.local_chr(10);
358: m_existing_text := m_existing_text || m_a3 || fnd_global.local_chr(10);
359: end if;
360:
361: if (m_a4 is not null ) then
362: m_existing_text := m_existing_text || m_a4 || fnd_global.local_chr(10);
363: end if;
364:
365: if (m_a5 is not null ) then
366: m_existing_text :=m_existing_text || m_a5 || fnd_global.local_chr(10);
362: m_existing_text := m_existing_text || m_a4 || fnd_global.local_chr(10);
363: end if;
364:
365: if (m_a5 is not null ) then
366: m_existing_text :=m_existing_text || m_a5 || fnd_global.local_chr(10);
367: end if;
368:
369: if (m_a6 is not null ) then
370: m_existing_text :=m_existing_text || m_a6 || fnd_global.local_chr(10);
366: m_existing_text :=m_existing_text || m_a5 || fnd_global.local_chr(10);
367: end if;
368:
369: if (m_a6 is not null ) then
370: m_existing_text :=m_existing_text || m_a6 || fnd_global.local_chr(10);
371: end if;
372:
373: if (m_a7 is not null ) then
374: m_existing_text :=m_existing_text || m_a7 || fnd_global.local_chr(10);
370: m_existing_text :=m_existing_text || m_a6 || fnd_global.local_chr(10);
371: end if;
372:
373: if (m_a7 is not null ) then
374: m_existing_text :=m_existing_text || m_a7 || fnd_global.local_chr(10);
375: end if;
376:
377: if (m_a8 is not null ) then
378: m_existing_text :=m_existing_text || m_a8 || fnd_global.local_chr(10);
374: m_existing_text :=m_existing_text || m_a7 || fnd_global.local_chr(10);
375: end if;
376:
377: if (m_a8 is not null ) then
378: m_existing_text :=m_existing_text || m_a8 || fnd_global.local_chr(10);
379: end if;
380:
381: if (m_a9 is not null ) then
382: m_existing_text :=m_existing_text || m_a9 || fnd_global.local_chr(10);
378: m_existing_text :=m_existing_text || m_a8 || fnd_global.local_chr(10);
379: end if;
380:
381: if (m_a9 is not null ) then
382: m_existing_text :=m_existing_text || m_a9 || fnd_global.local_chr(10);
383: end if;
384:
385: if (m_a10 is not null ) then
386: m_existing_text :=m_existing_text || m_a10 || fnd_global.local_chr(10);
382: m_existing_text :=m_existing_text || m_a9 || fnd_global.local_chr(10);
383: end if;
384:
385: if (m_a10 is not null ) then
386: m_existing_text :=m_existing_text || m_a10 || fnd_global.local_chr(10);
387: end if;
388:
389: if (m_a11 is not null ) then
390: m_existing_text :=m_existing_text || m_a11 || fnd_global.local_chr(10);
386: m_existing_text :=m_existing_text || m_a10 || fnd_global.local_chr(10);
387: end if;
388:
389: if (m_a11 is not null ) then
390: m_existing_text :=m_existing_text || m_a11 || fnd_global.local_chr(10);
391: end if;
392:
393: if (m_a12 is not null ) then
394: m_existing_text :=m_existing_text || m_a12 || fnd_global.local_chr(10);
390: m_existing_text :=m_existing_text || m_a11 || fnd_global.local_chr(10);
391: end if;
392:
393: if (m_a12 is not null ) then
394: m_existing_text :=m_existing_text || m_a12 || fnd_global.local_chr(10);
395: end if;
396:
397: if (m_a13 is not null ) then
398: m_existing_text :=m_existing_text || m_a13 || fnd_global.local_chr(10);
394: m_existing_text :=m_existing_text || m_a12 || fnd_global.local_chr(10);
395: end if;
396:
397: if (m_a13 is not null ) then
398: m_existing_text :=m_existing_text || m_a13 || fnd_global.local_chr(10);
399: end if;
400:
401: if (m_a14 is not null ) then
402: m_existing_text :=m_existing_text || m_a14 || fnd_global.local_chr(10);
398: m_existing_text :=m_existing_text || m_a13 || fnd_global.local_chr(10);
399: end if;
400:
401: if (m_a14 is not null ) then
402: m_existing_text :=m_existing_text || m_a14 || fnd_global.local_chr(10);
403: end if;
404:
405: if (m_a15 is not null ) then
406: m_existing_text :=m_existing_text || m_a15 || fnd_global.local_chr(10);
402: m_existing_text :=m_existing_text || m_a14 || fnd_global.local_chr(10);
403: end if;
404:
405: if (m_a15 is not null ) then
406: m_existing_text :=m_existing_text || m_a15 || fnd_global.local_chr(10);
407: end if;
408:
409: return m_existing_text;
410: