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_SE_CWCR dependencies on DBMS_LOB

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

535: l_str10 := '';
536: l_str11 := '';
537:
538:
539: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
540: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
541:
542: current_index := 0;
543:

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

536: l_str11 := '';
537:
538:
539: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
540: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
541:
542: current_index := 0;
543:
544: IF gtagdata.count > 0 THEN

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

542: current_index := 0;
543:
544: IF gtagdata.count > 0 THEN
545:
546: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
547:
548:
549: FOR table_counter IN gtagdata.FIRST .. gtagdata.LAST LOOP
550:

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

559: 'B1_END','B2','B2_END','B3','B3_END','B4','B4_END','B5','B5_END') THEN
560:
561: IF l_str9 IN ('PERSON' ,'B1','B2','B3','B4','B5') THEN
562: -- Bug# 9222739 fix ends
563: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
564: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
565: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
566: ELSE
567: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

560:
561: IF l_str9 IN ('PERSON' ,'B1','B2','B3','B4','B5') THEN
562: -- Bug# 9222739 fix ends
563: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
564: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
565: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
566: ELSE
567: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
568: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

561: IF l_str9 IN ('PERSON' ,'B1','B2','B3','B4','B5') THEN
562: -- Bug# 9222739 fix ends
563: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
564: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
565: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
566: ELSE
567: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
568: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
569: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

563: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
564: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
565: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
566: ELSE
567: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
568: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
569: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
570: END IF;
571:

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

564: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
565: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
566: ELSE
567: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
568: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
569: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
570: END IF;
571:
572: ELSE

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

565: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
566: ELSE
567: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
568: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
569: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
570: END IF;
571:
572: ELSE
573:

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

574: if l_str9 is not null then
575:
576: l_str9 := '';
577:
578: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
579: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
580: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
581: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
582: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

575:
576: l_str9 := '';
577:
578: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
579: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
580: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
581: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
582: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
583: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

576: l_str9 := '';
577:
578: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
579: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
580: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
581: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
582: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
583: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
584: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

577:
578: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
579: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
580: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
581: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
582: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
583: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
584: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
585: else

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

578: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
579: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
580: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
581: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
582: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
583: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
584: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
585: else
586:

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

579: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
580: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
581: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
582: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
583: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
584: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
585: else
586:
587: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

580: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
581: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
582: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
583: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
584: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
585: else
586:
587: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
588: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

583: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
584: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
585: else
586:
587: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
588: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
589: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
590: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
591: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

584: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
585: else
586:
587: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
588: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
589: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
590: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
591: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
592: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

585: else
586:
587: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
588: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
589: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
590: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
591: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
592: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
593:

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

586:
587: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
588: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
589: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
590: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
591: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
592: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
593:
594: end if;

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

587: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
588: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
589: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
590: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
591: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
592: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
593:
594: end if;
595:

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

588: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
589: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
590: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
591: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
592: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
593:
594: end if;
595:
596: END IF;

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

596: END IF;
597:
598: END LOOP;
599:
600: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
601:
602: ELSE
603: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
604: END IF;

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

599:
600: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
601:
602: ELSE
603: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
604: END IF;
605:
606: p_xfdf_clob := l_xfdf_string;
607: