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 475: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

471: l_str10 := '';
472: l_str11 := '';
473:
474:
475: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
476: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
477:
478: current_index := 0;
479:

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

472: l_str11 := '';
473:
474:
475: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
476: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
477:
478: current_index := 0;
479:
480: IF gtagdata.count > 0 THEN

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

478: current_index := 0;
479:
480: IF gtagdata.count > 0 THEN
481:
482: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
483:
484:
485: FOR table_counter IN gtagdata.FIRST .. gtagdata.LAST LOOP
486:

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

494: IF l_str9 IN ('PERSON' ,'PERSON_END','B1',
495: 'B1_END','B2','B2_END','B3','B3_END','B4','B4_END') THEN
496:
497: IF l_str9 IN ('PERSON' ,'B1','B2','B3','B4') THEN
498: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
499: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
500: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
501: ELSE
502: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

495: 'B1_END','B2','B2_END','B3','B3_END','B4','B4_END') THEN
496:
497: IF l_str9 IN ('PERSON' ,'B1','B2','B3','B4') THEN
498: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
499: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
500: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
501: ELSE
502: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
503: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

496:
497: IF l_str9 IN ('PERSON' ,'B1','B2','B3','B4') THEN
498: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
499: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
500: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
501: ELSE
502: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
503: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
504: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

498: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
499: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
500: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
501: ELSE
502: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
503: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
504: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
505: END IF;
506:

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

499: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
500: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
501: ELSE
502: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
503: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
504: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
505: END IF;
506:
507: ELSE

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

500: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
501: ELSE
502: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
503: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
504: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
505: END IF;
506:
507: ELSE
508:

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

509: if l_str9 is not null then
510:
511: l_str9 := '';
512:
513: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
514: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
515: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
516: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
517: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);

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

510:
511: l_str9 := '';
512:
513: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
514: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
515: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
516: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
517: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
518: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

511: l_str9 := '';
512:
513: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
514: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
515: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
516: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
517: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
518: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
519: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

512:
513: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
514: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
515: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
516: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
517: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
518: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
519: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
520: else

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

513: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
514: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
515: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
516: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
517: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
518: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
519: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
520: else
521:

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

514: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
515: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
516: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
517: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
518: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
519: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
520: else
521:
522: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);

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

515: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
516: dbms_lob.writeAppend(l_xfdf_string, length(l_str9), l_str9);
517: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
518: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
519: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
520: else
521:
522: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
523: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

518: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
519: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
520: else
521:
522: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
523: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
524: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
525: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
526: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);

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

519: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
520: else
521:
522: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
523: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
524: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
525: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
526: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
527: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);

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

520: else
521:
522: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
523: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
524: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
525: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
526: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
527: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
528:

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

521:
522: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
523: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
524: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
525: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
526: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
527: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
528:
529: end if;

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

522: dbms_lob.writeAppend(l_xfdf_string, length(l_str2), l_str2);
523: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
524: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
525: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
526: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
527: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
528:
529: end if;
530:

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

523: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
524: dbms_lob.writeAppend(l_xfdf_string, length(l_str3), l_str3);
525: dbms_lob.writeAppend(l_xfdf_string, length(l_str4), l_str4);
526: dbms_lob.writeAppend(l_xfdf_string, length(l_str8), l_str8);
527: dbms_lob.writeAppend(l_xfdf_string, length(l_str5), l_str5);
528:
529: end if;
530:
531: END IF;

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

531: END IF;
532:
533: END LOOP;
534:
535: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
536:
537: ELSE
538: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
539: END IF;

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

534:
535: dbms_lob.writeAppend(l_xfdf_string, length(l_str6), l_str6 );
536:
537: ELSE
538: dbms_lob.writeAppend(l_xfdf_string, length(l_str7), l_str7 );
539: END IF;
540:
541: p_xfdf_clob := l_xfdf_string;
542: