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.PAY_FI_PAYLIST dependencies on DBMS_LOB

Line 422: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

418: l_str10 := '';
419: l_str11 := '';
420: */
421:
422: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
423: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
424:
425: current_index := 0;
426:

Line 423: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

419: l_str11 := '';
420: */
421:
422: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
423: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
424:
425: current_index := 0;
426:
427: IF gplsqltable.count > 0 THEN

Line 429: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

425: current_index := 0;
426:
427: IF gplsqltable.count > 0 THEN
428:
429: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
430:
431:
432: FOR table_counter IN gplsqltable.FIRST .. gplsqltable.LAST LOOP
433:

Line 441: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

437: IF l_str9 IN ('HEADER_START' ,'HEADER_END','BODY_START',
438: 'BODY_END','EMP_START','EMP_END','FOOTER_START','FOOTER_END') THEN
439:
440: IF l_str9 IN ('HEADER_START' ,'BODY_START','EMP_START','FOOTER_START') THEN
441: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
442: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
443: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
444: ELSE
445: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

Line 442: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

438: 'BODY_END','EMP_START','EMP_END','FOOTER_START','FOOTER_END') THEN
439:
440: IF l_str9 IN ('HEADER_START' ,'BODY_START','EMP_START','FOOTER_START') THEN
441: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
442: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
443: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
444: ELSE
445: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 443: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

439:
440: IF l_str9 IN ('HEADER_START' ,'BODY_START','EMP_START','FOOTER_START') THEN
441: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
442: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
443: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
444: ELSE
445: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
447: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

Line 445: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

441: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
442: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
443: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
444: ELSE
445: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
447: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
448: END IF;
449:

Line 446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

442: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
443: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
444: ELSE
445: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
447: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
448: END IF;
449:
450: ELSE

Line 447: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

443: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
444: ELSE
445: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
446: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
447: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
448: END IF;
449:
450: ELSE
451:

Line 454: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

450: ELSE
451:
452: if l_str9 is not null then
453:
454: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
455: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
456: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
457: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
458: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

Line 455: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

451:
452: if l_str9 is not null then
453:
454: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
455: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
456: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
457: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
458: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 456: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

452: if l_str9 is not null then
453:
454: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
455: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
456: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
457: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
458: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
460: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

Line 457: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);

453:
454: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
455: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
456: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
457: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
458: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
460: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
461: else

Line 458: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

454: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
455: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
456: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
457: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
458: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
460: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
461: else
462:

Line 459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

455: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
456: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
457: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
458: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
460: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
461: else
462:
463: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

Line 460: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

456: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
457: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
458: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
460: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
461: else
462:
463: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
464: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 463: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

459: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
460: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
461: else
462:
463: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
464: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
465: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
466: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
467: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

Line 464: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

460: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
461: else
462:
463: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
464: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
465: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
466: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
467: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
468: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

Line 465: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);

461: else
462:
463: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
464: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
465: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
466: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
467: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
468: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
469:

Line 466: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

462:
463: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
464: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
465: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
466: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
467: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
468: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
469:
470: end if;

Line 467: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

463: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
464: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
465: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
466: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
467: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
468: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
469:
470: end if;
471:

Line 468: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

464: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
465: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
466: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
467: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
468: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
469:
470: end if;
471:
472: END IF;

Line 476: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );

472: END IF;
473:
474: END LOOP;
475:
476: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
477:
478: ELSE
479: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
480: END IF;

Line 479: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );

475:
476: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
477:
478: ELSE
479: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
480: END IF;
481:
482: p_xfdf_clob := l_xfdf_string;
483:

Line 520: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);

516: l_str6 := '';
517: l_str7 := ' ';
518: l_str10 := '';
519: l_str11 := '';
520: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
521: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
522: current_index := 0;
523:
524: IF gplsqltable.COUNT > 0

Line 521: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);

517: l_str7 := ' ';
518: l_str10 := '';
519: l_str11 := '';
520: DBMS_LOB.createtemporary (l_xfdf_string, FALSE, DBMS_LOB.CALL);
521: DBMS_LOB.OPEN (l_xfdf_string, DBMS_LOB.lob_readwrite);
522: current_index := 0;
523:
524: IF gplsqltable.COUNT > 0
525: THEN

Line 526: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);

522: current_index := 0;
523:
524: IF gplsqltable.COUNT > 0
525: THEN
526: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
527: l_str8 := gplsqltable (1).tagname;
528: l_str9 := gplsqltable (1).tagvalue;
529: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
530: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 529: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

525: THEN
526: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
527: l_str8 := gplsqltable (1).tagname;
528: l_str9 := gplsqltable (1).tagvalue;
529: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
530: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
531: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
532: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
533: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

Line 530: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

526: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str1), l_str1);
527: l_str8 := gplsqltable (1).tagname;
528: l_str9 := gplsqltable (1).tagvalue;
529: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
530: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
531: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
532: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
533: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 531: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

527: l_str8 := gplsqltable (1).tagname;
528: l_str9 := gplsqltable (1).tagvalue;
529: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
530: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
531: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
532: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
533: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
535: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 532: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);

528: l_str9 := gplsqltable (1).tagvalue;
529: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
530: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
531: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
532: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
533: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
535: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
536: l_str8 := gplsqltable (2).tagname;

Line 533: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

529: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
530: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
531: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
532: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
533: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
535: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
536: l_str8 := gplsqltable (2).tagname;
537: l_str9 := gplsqltable (2).tagvalue;

Line 534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

530: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
531: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
532: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
533: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
535: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
536: l_str8 := gplsqltable (2).tagname;
537: l_str9 := gplsqltable (2).tagvalue;
538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

Line 535: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

531: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
532: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
533: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
535: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
536: l_str8 := gplsqltable (2).tagname;
537: l_str9 := gplsqltable (2).tagvalue;
538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
539: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

534: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
535: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
536: l_str8 := gplsqltable (2).tagname;
537: l_str9 := gplsqltable (2).tagvalue;
538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
539: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
541: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

Line 539: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

535: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
536: l_str8 := gplsqltable (2).tagname;
537: l_str9 := gplsqltable (2).tagvalue;
538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
539: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
541: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
543: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

536: l_str8 := gplsqltable (2).tagname;
537: l_str9 := gplsqltable (2).tagvalue;
538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
539: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
541: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
543: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 541: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);

537: l_str9 := gplsqltable (2).tagvalue;
538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
539: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
541: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
543: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
545:

Line 542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

538: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
539: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
541: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
543: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
545:
546: FOR table_counter IN gplsqltable.FIRST .. gplsqltable.LAST

Line 543: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

539: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
541: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
543: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
545:
546: FOR table_counter IN gplsqltable.FIRST .. gplsqltable.LAST
547: LOOP

Line 544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

540: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
541: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
542: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
543: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
544: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
545:
546: FOR table_counter IN gplsqltable.FIRST .. gplsqltable.LAST
547: LOOP
548: l_str8 := gplsqltable (table_counter).tagname;

Line 553: DBMS_LOB.writeappend (

549: l_str9 := gplsqltable (table_counter).tagvalue;
550:
551: IF l_str9 = 'END'
552: THEN
553: DBMS_LOB.writeappend (
554: l_xfdf_string,
555: LENGTH (l_str11),
556: l_str11
557: );

Line 560: DBMS_LOB.writeappend (

556: l_str11
557: );
558: ELSIF l_str9 = 'START'
559: THEN
560: DBMS_LOB.writeappend (
561: l_xfdf_string,
562: LENGTH (l_str10),
563: l_str10
564: );

Line 567: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

563: l_str10
564: );
565: ELSIF l_str9 IS NOT NULL
566: THEN
567: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
568: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
569: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
570: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
571: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

Line 568: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

564: );
565: ELSIF l_str9 IS NOT NULL
566: THEN
567: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
568: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
569: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
570: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
571: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
572: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 569: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

565: ELSIF l_str9 IS NOT NULL
566: THEN
567: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
568: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
569: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
570: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
571: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
572: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
573: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 570: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);

566: THEN
567: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
568: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
569: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
570: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
571: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
572: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
573: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
574: ELSE

Line 571: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

567: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
568: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
569: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
570: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
571: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
572: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
573: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
574: ELSE
575: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

Line 572: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

568: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
569: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
570: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
571: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
572: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
573: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
574: ELSE
575: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
576: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 573: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

569: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
570: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str9), l_str9);
571: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
572: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
573: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
574: ELSE
575: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
576: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
577: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

Line 575: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);

571: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
572: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
573: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
574: ELSE
575: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
576: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
577: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
578: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
579: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 576: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

572: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
573: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
574: ELSE
575: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
576: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
577: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
578: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
579: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
580: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 577: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);

573: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
574: ELSE
575: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
576: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
577: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
578: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
579: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
580: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
581: END IF;

Line 578: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

574: ELSE
575: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
576: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
577: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
578: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
579: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
580: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
581: END IF;
582: END LOOP;

Line 579: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

575: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str2), l_str2);
576: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
577: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
578: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
579: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
580: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
581: END IF;
582: END LOOP;
583:

Line 580: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

576: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
577: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str3), l_str3);
578: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
579: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
580: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
581: END IF;
582: END LOOP;
583:
584: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

Line 584: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);

580: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);
581: END IF;
582: END LOOP;
583:
584: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
585: ELSE
586: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
587: END IF;
588:

Line 586: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);

582: END LOOP;
583:
584: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str6), l_str6);
585: ELSE
586: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str7), l_str7);
587: END IF;
588:
589: p_xfdf_clob := l_xfdf_string;
590: hr_utility.set_location ('Leaving WritetoCLOB ', 70);