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

Line 610: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

606: AND fad.pk1_value = Nvl(l_amendment_id,p_auction_header_id)
607: AND fl.file_id(+) = fdvl.media_id
608: AND fdvl.datatype_name = 'File') LOOP
609: files_temp_holder := '' || temp.filename || '';
610: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
611: Dbms_Lob.append(files_clob,temp.filedata);
612: files_temp_holder := '' || temp.description || '';
613: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
614:

Line 611: Dbms_Lob.append(files_clob,temp.filedata);

607: AND fl.file_id(+) = fdvl.media_id
608: AND fdvl.datatype_name = 'File') LOOP
609: files_temp_holder := '' || temp.filename || '';
610: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
611: Dbms_Lob.append(files_clob,temp.filedata);
612: files_temp_holder := '' || temp.description || '';
613: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
614:
615: END LOOP;

Line 613: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

609: files_temp_holder := '' || temp.filename || '';
610: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
611: Dbms_Lob.append(files_clob,temp.filedata);
612: files_temp_holder := '' || temp.description || '';
613: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
614:
615: END LOOP;
616: files_temp_holder := '';
617: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

Line 617: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

613: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
614:
615: END LOOP;
616: files_temp_holder := '';
617: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
618:
619: LOG_MESSAGE(l_module,'file element constructed');
620:
621: select updatexml(x_xml,'//files',xmltype(files_clob))

Line 786: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

782: AND fad.pk1_value = nvl(l_amendment_id,p_auction_header_id)
783: AND fl.file_id(+) = fdvl.media_id
784: AND fdvl.datatype_name = 'File') LOOP
785: files_temp_holder := '' || temp.filename || '';
786: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
787: Dbms_Lob.append(files_clob,temp.filedata);
788: files_temp_holder := '' || temp.description || '';
789: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
790:

Line 787: Dbms_Lob.append(files_clob,temp.filedata);

783: AND fl.file_id(+) = fdvl.media_id
784: AND fdvl.datatype_name = 'File') LOOP
785: files_temp_holder := '' || temp.filename || '';
786: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
787: Dbms_Lob.append(files_clob,temp.filedata);
788: files_temp_holder := '' || temp.description || '';
789: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
790:
791: END LOOP;

Line 789: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

785: files_temp_holder := '' || temp.filename || '';
786: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
787: Dbms_Lob.append(files_clob,temp.filedata);
788: files_temp_holder := '' || temp.description || '';
789: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
790:
791: END LOOP;
792: files_temp_holder := '';
793: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

Line 793: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

789: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
790:
791: END LOOP;
792: files_temp_holder := '';
793: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
794:
795: LOG_MESSAGE(l_module,'file element constructed');
796:
797: select updatexml(x_xml,'//files',xmltype(files_clob))

Line 895: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

891: AND ACTION_TYPE='STORE_CLM_PDF'
892: AND ROWNUM < 2 );
893:
894: files_temp_holder := '' || l_pdfname || '';
895: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
896: Dbms_Lob.append(files_clob,l_pdfdata);
897: files_temp_holder := '' || l_pdfname || '';
898: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
899:

Line 896: Dbms_Lob.append(files_clob,l_pdfdata);

892: AND ROWNUM < 2 );
893:
894: files_temp_holder := '' || l_pdfname || '';
895: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
896: Dbms_Lob.append(files_clob,l_pdfdata);
897: files_temp_holder := '' || l_pdfname || '';
898: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
899:
900: /*

Line 898: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

894: files_temp_holder := '' || l_pdfname || '';
895: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
896: Dbms_Lob.append(files_clob,l_pdfdata);
897: files_temp_holder := '' || l_pdfname || '';
898: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
899:
900: /*
901: bug 13504088
902: For amendments and conformed documents, we have to fetch only

Line 933: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

929: AND fad.pk1_value = Nvl(l_amendment_id,p_auction_header_id)
930: AND fl.file_id(+) = fdvl.media_id
931: AND fdvl.datatype_name = 'File') LOOP
932: files_temp_holder := '' || temp.filename || '';
933: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
934: Dbms_Lob.append(files_clob,temp.filedata);
935: files_temp_holder := '' || temp.description || '';
936: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
937:

Line 934: Dbms_Lob.append(files_clob,temp.filedata);

930: AND fl.file_id(+) = fdvl.media_id
931: AND fdvl.datatype_name = 'File') LOOP
932: files_temp_holder := '' || temp.filename || '';
933: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
934: Dbms_Lob.append(files_clob,temp.filedata);
935: files_temp_holder := '' || temp.description || '';
936: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
937:
938: END LOOP;

Line 936: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

932: files_temp_holder := '' || temp.filename || '';
933: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
934: Dbms_Lob.append(files_clob,temp.filedata);
935: files_temp_holder := '' || temp.description || '';
936: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
937:
938: END LOOP;
939: files_temp_holder := '';
940: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

Line 940: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);

936: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
937:
938: END LOOP;
939: files_temp_holder := '';
940: Dbms_Lob.writeappend(files_clob,Length(files_temp_holder),files_temp_holder);
941:
942: LOG_MESSAGE(l_module,'file element constructed');
943:
944: select updatexml(x_xml,'//files',xmltype(files_clob))

Line 1027: LOG_MESSAGE(l_module,'Length of xml '||Dbms_Lob.getlength(x_xml));

1023:
1024: IF l_result IS NOT NULL THEN
1025: LOG_MESSAGE(l_module,'result obtained ');
1026: x_xml := l_result.getclobval();
1027: LOG_MESSAGE(l_module,'Length of xml '||Dbms_Lob.getlength(x_xml));
1028: ELSE
1029: x_result := 'E';
1030: LOG_MESSAGE(l_module,'Error ');
1031: RETURN;

Line 1466: DBMS_LOB.CREATETEMPORARY(l_clob,true);

1462: IS
1463: l_clob clob;
1464: BEGIN
1465:
1466: DBMS_LOB.CREATETEMPORARY(l_clob,true);
1467:
1468: WF_MAIL_UTIL.EncodeBLOB(p_data, l_clob);
1469:
1470: RETURN l_clob;