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

Line 63: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'clob_result', DBMS_LOB.GETLENGTH(clob_result) );

59: clob_result := FPDSNGXMLGEN(p_document_id, p_release_num, p_revision_num);
60:
61: l_progress := '003';
62: IF g_debug_stmt THEN
63: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'clob_result', DBMS_LOB.GETLENGTH(clob_result) );
64: END IF;
65:
66: RETURN clob_result;
67: EXCEPTION

Line 543: IF dbms_lob.getlength(l_xml_result) >0 THEN

539: END IF;
540:
541: -- Length of IDVD
542: l_progress:='027';
543: IF dbms_lob.getlength(l_xml_result) >0 THEN
544:
545: l_progress:='028';
546: l_resultOffset := DBMS_LOB.INSTR(l_xml_result,'>');
547:

Line 546: l_resultOffset := DBMS_LOB.INSTR(l_xml_result,'>');

542: l_progress:='027';
543: IF dbms_lob.getlength(l_xml_result) >0 THEN
544:
545: l_progress:='028';
546: l_resultOffset := DBMS_LOB.INSTR(l_xml_result,'>');
547:
548: l_progress:='029';
549: l_tempXMLResult := l_xml_result;
550:

Line 552: dbms_lob.write(l_xml_result,length(' '),1,' ');

548: l_progress:='029';
549: l_tempXMLResult := l_xml_result;
550:
551: l_progress:='030';
552: dbms_lob.write(l_xml_result,length(' '),1,' ');
553: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(' '),l_resultOffset);
554:
555: IF dbms_lob.getlength(l_referencedidvid) > 0 THEN
556: l_progress:='031';

Line 553: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(' '),l_resultOffset);

549: l_tempXMLResult := l_xml_result;
550:
551: l_progress:='030';
552: dbms_lob.write(l_xml_result,length(' '),1,' ');
553: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(' '),l_resultOffset);
554:
555: IF dbms_lob.getlength(l_referencedidvid) > 0 THEN
556: l_progress:='031';
557: l_variablePosition := DBMS_LOB.INSTR(l_referencedidvid,'>');

Line 555: IF dbms_lob.getlength(l_referencedidvid) > 0 THEN

551: l_progress:='030';
552: dbms_lob.write(l_xml_result,length(' '),1,' ');
553: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(' '),l_resultOffset);
554:
555: IF dbms_lob.getlength(l_referencedidvid) > 0 THEN
556: l_progress:='031';
557: l_variablePosition := DBMS_LOB.INSTR(l_referencedidvid,'>');
558: dbms_lob.copy(l_xml_result, l_referencedidvid, dbms_lob.getlength(l_referencedidvid)- l_variablePosition, dbms_lob.getlength(l_xml_result)+1, l_variablePosition+1);
559: END IF;

Line 557: l_variablePosition := DBMS_LOB.INSTR(l_referencedidvid,'>');

553: dbms_lob.copy(l_xml_result,l_tempXMLResult,dbms_lob.getlength(l_tempXMLResult)-l_resultOffset,length(' '),l_resultOffset);
554:
555: IF dbms_lob.getlength(l_referencedidvid) > 0 THEN
556: l_progress:='031';
557: l_variablePosition := DBMS_LOB.INSTR(l_referencedidvid,'>');
558: dbms_lob.copy(l_xml_result, l_referencedidvid, dbms_lob.getlength(l_referencedidvid)- l_variablePosition, dbms_lob.getlength(l_xml_result)+1, l_variablePosition+1);
559: END IF;
560: l_progress:='032';
561: dbms_lob.write(l_xml_result,length(''),dbms_lob.getlength(l_xml_result) + 1,'');

Line 558: dbms_lob.copy(l_xml_result, l_referencedidvid, dbms_lob.getlength(l_referencedidvid)- l_variablePosition, dbms_lob.getlength(l_xml_result)+1, l_variablePosition+1);

554:
555: IF dbms_lob.getlength(l_referencedidvid) > 0 THEN
556: l_progress:='031';
557: l_variablePosition := DBMS_LOB.INSTR(l_referencedidvid,'>');
558: dbms_lob.copy(l_xml_result, l_referencedidvid, dbms_lob.getlength(l_referencedidvid)- l_variablePosition, dbms_lob.getlength(l_xml_result)+1, l_variablePosition+1);
559: END IF;
560: l_progress:='032';
561: dbms_lob.write(l_xml_result,length(''),dbms_lob.getlength(l_xml_result) + 1,'');
562:

Line 561: dbms_lob.write(l_xml_result,length(''),dbms_lob.getlength(l_xml_result) + 1,'');

557: l_variablePosition := DBMS_LOB.INSTR(l_referencedidvid,'>');
558: dbms_lob.copy(l_xml_result, l_referencedidvid, dbms_lob.getlength(l_referencedidvid)- l_variablePosition, dbms_lob.getlength(l_xml_result)+1, l_variablePosition+1);
559: END IF;
560: l_progress:='032';
561: dbms_lob.write(l_xml_result,length(''),dbms_lob.getlength(l_xml_result) + 1,'');
562:
563:
564: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
565: l_progress:='033';

Line 566: IF dbms_lob.getlength(l_ContractDates) >0 THEN

562:
563:
564: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
565: l_progress:='033';
566: IF dbms_lob.getlength(l_ContractDates) >0 THEN
567: l_variablePosition := DBMS_LOB.INSTR(l_ContractDates,'>');
568: dbms_lob.copy(l_xml_result, l_ContractDates, dbms_lob.getlength(l_ContractDates)- l_variablePosition, dbms_lob.getlength(l_xml_result) +1, l_variablePosition+1);
569: END IF;
570: END IF;

Line 567: l_variablePosition := DBMS_LOB.INSTR(l_ContractDates,'>');

563:
564: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
565: l_progress:='033';
566: IF dbms_lob.getlength(l_ContractDates) >0 THEN
567: l_variablePosition := DBMS_LOB.INSTR(l_ContractDates,'>');
568: dbms_lob.copy(l_xml_result, l_ContractDates, dbms_lob.getlength(l_ContractDates)- l_variablePosition, dbms_lob.getlength(l_xml_result) +1, l_variablePosition+1);
569: END IF;
570: END IF;
571:

Line 568: dbms_lob.copy(l_xml_result, l_ContractDates, dbms_lob.getlength(l_ContractDates)- l_variablePosition, dbms_lob.getlength(l_xml_result) +1, l_variablePosition+1);

564: IF (PO_COMM_FPDSNG_PVT.getReleaseId()) IS NOT null THEN
565: l_progress:='033';
566: IF dbms_lob.getlength(l_ContractDates) >0 THEN
567: l_variablePosition := DBMS_LOB.INSTR(l_ContractDates,'>');
568: dbms_lob.copy(l_xml_result, l_ContractDates, dbms_lob.getlength(l_ContractDates)- l_variablePosition, dbms_lob.getlength(l_xml_result) +1, l_variablePosition+1);
569: END IF;
570: END IF;
571:
572: IF dbms_lob.getlength(l_dollarValues) >0 THEN

Line 572: IF dbms_lob.getlength(l_dollarValues) >0 THEN

568: dbms_lob.copy(l_xml_result, l_ContractDates, dbms_lob.getlength(l_ContractDates)- l_variablePosition, dbms_lob.getlength(l_xml_result) +1, l_variablePosition+1);
569: END IF;
570: END IF;
571:
572: IF dbms_lob.getlength(l_dollarValues) >0 THEN
573: l_progress:='034';
574: l_variablePosition := DBMS_LOB.INSTR(l_dollarValues,'>');
575: dbms_lob.copy(l_xml_result, l_dollarValues, dbms_lob.getlength(l_dollarValues)- l_variablePosition, dbms_lob.getlength(l_xml_result)+1, l_variablePosition+1);
576: END IF;

Line 574: l_variablePosition := DBMS_LOB.INSTR(l_dollarValues,'>');

570: END IF;
571:
572: IF dbms_lob.getlength(l_dollarValues) >0 THEN
573: l_progress:='034';
574: l_variablePosition := DBMS_LOB.INSTR(l_dollarValues,'>');
575: dbms_lob.copy(l_xml_result, l_dollarValues, dbms_lob.getlength(l_dollarValues)- l_variablePosition, dbms_lob.getlength(l_xml_result)+1, l_variablePosition+1);
576: END IF;
577:
578:

Line 575: dbms_lob.copy(l_xml_result, l_dollarValues, dbms_lob.getlength(l_dollarValues)- l_variablePosition, dbms_lob.getlength(l_xml_result)+1, l_variablePosition+1);

571:
572: IF dbms_lob.getlength(l_dollarValues) >0 THEN
573: l_progress:='034';
574: l_variablePosition := DBMS_LOB.INSTR(l_dollarValues,'>');
575: dbms_lob.copy(l_xml_result, l_dollarValues, dbms_lob.getlength(l_dollarValues)- l_variablePosition, dbms_lob.getlength(l_xml_result)+1, l_variablePosition+1);
576: END IF;
577:
578:
579: IF dbms_lob.getlength(l_contractMarketingData) >0 THEN

Line 579: IF dbms_lob.getlength(l_contractMarketingData) >0 THEN

575: dbms_lob.copy(l_xml_result, l_dollarValues, dbms_lob.getlength(l_dollarValues)- l_variablePosition, dbms_lob.getlength(l_xml_result)+1, l_variablePosition+1);
576: END IF;
577:
578:
579: IF dbms_lob.getlength(l_contractMarketingData) >0 THEN
580: l_progress:='035';
581: l_variablePosition := DBMS_LOB.INSTR(l_contractMarketingData,'>');
582: dbms_lob.copy(l_xml_result, l_contractMarketingData, dbms_lob.getlength(l_contractMarketingData)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
583: END IF;

Line 581: l_variablePosition := DBMS_LOB.INSTR(l_contractMarketingData,'>');

577:
578:
579: IF dbms_lob.getlength(l_contractMarketingData) >0 THEN
580: l_progress:='035';
581: l_variablePosition := DBMS_LOB.INSTR(l_contractMarketingData,'>');
582: dbms_lob.copy(l_xml_result, l_contractMarketingData, dbms_lob.getlength(l_contractMarketingData)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
583: END IF;
584:
585:

Line 582: dbms_lob.copy(l_xml_result, l_contractMarketingData, dbms_lob.getlength(l_contractMarketingData)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

578:
579: IF dbms_lob.getlength(l_contractMarketingData) >0 THEN
580: l_progress:='035';
581: l_variablePosition := DBMS_LOB.INSTR(l_contractMarketingData,'>');
582: dbms_lob.copy(l_xml_result, l_contractMarketingData, dbms_lob.getlength(l_contractMarketingData)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
583: END IF;
584:
585:
586: IF dbms_lob.getlength(l_contractData) >0 THEN

Line 586: IF dbms_lob.getlength(l_contractData) >0 THEN

582: dbms_lob.copy(l_xml_result, l_contractMarketingData, dbms_lob.getlength(l_contractMarketingData)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
583: END IF;
584:
585:
586: IF dbms_lob.getlength(l_contractData) >0 THEN
587: l_progress:='036';
588: l_variablePosition := DBMS_LOB.INSTR(l_contractData,'>');
589: dbms_lob.copy(l_xml_result, l_contractData, dbms_lob.getlength(l_contractData)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
590: END IF;

Line 588: l_variablePosition := DBMS_LOB.INSTR(l_contractData,'>');

584:
585:
586: IF dbms_lob.getlength(l_contractData) >0 THEN
587: l_progress:='036';
588: l_variablePosition := DBMS_LOB.INSTR(l_contractData,'>');
589: dbms_lob.copy(l_xml_result, l_contractData, dbms_lob.getlength(l_contractData)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
590: END IF;
591:
592: IF dbms_lob.getlength(l_productInfo) >0 THEN

Line 589: dbms_lob.copy(l_xml_result, l_contractData, dbms_lob.getlength(l_contractData)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

585:
586: IF dbms_lob.getlength(l_contractData) >0 THEN
587: l_progress:='036';
588: l_variablePosition := DBMS_LOB.INSTR(l_contractData,'>');
589: dbms_lob.copy(l_xml_result, l_contractData, dbms_lob.getlength(l_contractData)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
590: END IF;
591:
592: IF dbms_lob.getlength(l_productInfo) >0 THEN
593: l_progress:='037';

Line 592: IF dbms_lob.getlength(l_productInfo) >0 THEN

588: l_variablePosition := DBMS_LOB.INSTR(l_contractData,'>');
589: dbms_lob.copy(l_xml_result, l_contractData, dbms_lob.getlength(l_contractData)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
590: END IF;
591:
592: IF dbms_lob.getlength(l_productInfo) >0 THEN
593: l_progress:='037';
594: l_variablePosition := DBMS_LOB.INSTR(l_productInfo,'>');
595: dbms_lob.copy(l_xml_result, l_productInfo, dbms_lob.getlength(l_productInfo)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
596: END IF;

Line 594: l_variablePosition := DBMS_LOB.INSTR(l_productInfo,'>');

590: END IF;
591:
592: IF dbms_lob.getlength(l_productInfo) >0 THEN
593: l_progress:='037';
594: l_variablePosition := DBMS_LOB.INSTR(l_productInfo,'>');
595: dbms_lob.copy(l_xml_result, l_productInfo, dbms_lob.getlength(l_productInfo)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
596: END IF;
597:
598: IF dbms_lob.getlength(l_vendorHeader) >0 THEN

Line 595: dbms_lob.copy(l_xml_result, l_productInfo, dbms_lob.getlength(l_productInfo)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

591:
592: IF dbms_lob.getlength(l_productInfo) >0 THEN
593: l_progress:='037';
594: l_variablePosition := DBMS_LOB.INSTR(l_productInfo,'>');
595: dbms_lob.copy(l_xml_result, l_productInfo, dbms_lob.getlength(l_productInfo)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
596: END IF;
597:
598: IF dbms_lob.getlength(l_vendorHeader) >0 THEN
599: l_progress:='038';

Line 598: IF dbms_lob.getlength(l_vendorHeader) >0 THEN

594: l_variablePosition := DBMS_LOB.INSTR(l_productInfo,'>');
595: dbms_lob.copy(l_xml_result, l_productInfo, dbms_lob.getlength(l_productInfo)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
596: END IF;
597:
598: IF dbms_lob.getlength(l_vendorHeader) >0 THEN
599: l_progress:='038';
600: l_variablePosition := DBMS_LOB.INSTR(l_vendorHeader,'>');
601: dbms_lob.copy(l_xml_result, l_vendorHeader, dbms_lob.getlength(l_vendorHeader)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
602: END IF;

Line 600: l_variablePosition := DBMS_LOB.INSTR(l_vendorHeader,'>');

596: END IF;
597:
598: IF dbms_lob.getlength(l_vendorHeader) >0 THEN
599: l_progress:='038';
600: l_variablePosition := DBMS_LOB.INSTR(l_vendorHeader,'>');
601: dbms_lob.copy(l_xml_result, l_vendorHeader, dbms_lob.getlength(l_vendorHeader)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
602: END IF;
603:
604: IF dbms_lob.getlength(l_vendorLocation) >0 THEN

Line 601: dbms_lob.copy(l_xml_result, l_vendorHeader, dbms_lob.getlength(l_vendorHeader)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

597:
598: IF dbms_lob.getlength(l_vendorHeader) >0 THEN
599: l_progress:='038';
600: l_variablePosition := DBMS_LOB.INSTR(l_vendorHeader,'>');
601: dbms_lob.copy(l_xml_result, l_vendorHeader, dbms_lob.getlength(l_vendorHeader)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
602: END IF;
603:
604: IF dbms_lob.getlength(l_vendorLocation) >0 THEN
605: l_progress:='039';

Line 604: IF dbms_lob.getlength(l_vendorLocation) >0 THEN

600: l_variablePosition := DBMS_LOB.INSTR(l_vendorHeader,'>');
601: dbms_lob.copy(l_xml_result, l_vendorHeader, dbms_lob.getlength(l_vendorHeader)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
602: END IF;
603:
604: IF dbms_lob.getlength(l_vendorLocation) >0 THEN
605: l_progress:='039';
606: l_variablePosition := DBMS_LOB.INSTR(l_vendorLocation,'>');
607: dbms_lob.copy(l_xml_result, l_vendorLocation, dbms_lob.getlength(l_vendorLocation)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
608: END IF;

Line 606: l_variablePosition := DBMS_LOB.INSTR(l_vendorLocation,'>');

602: END IF;
603:
604: IF dbms_lob.getlength(l_vendorLocation) >0 THEN
605: l_progress:='039';
606: l_variablePosition := DBMS_LOB.INSTR(l_vendorLocation,'>');
607: dbms_lob.copy(l_xml_result, l_vendorLocation, dbms_lob.getlength(l_vendorLocation)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
608: END IF;
609:
610: l_progress:='040';

Line 607: dbms_lob.copy(l_xml_result, l_vendorLocation, dbms_lob.getlength(l_vendorLocation)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);

603:
604: IF dbms_lob.getlength(l_vendorLocation) >0 THEN
605: l_progress:='039';
606: l_variablePosition := DBMS_LOB.INSTR(l_vendorLocation,'>');
607: dbms_lob.copy(l_xml_result, l_vendorLocation, dbms_lob.getlength(l_vendorLocation)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
608: END IF;
609:
610: l_progress:='040';
611: dbms_lob.write(l_xml_result,length(''),dbms_lob.getlength(l_xml_result) + 1,'');

Line 611: dbms_lob.write(l_xml_result,length(''),dbms_lob.getlength(l_xml_result) + 1,'');

607: dbms_lob.copy(l_xml_result, l_vendorLocation, dbms_lob.getlength(l_vendorLocation)- l_variablePosition, dbms_lob.getlength(l_xml_result), l_variablePosition+1);
608: END IF;
609:
610: l_progress:='040';
611: dbms_lob.write(l_xml_result,length(''),dbms_lob.getlength(l_xml_result) + 1,'');
612:
613: END IF; -- Length of IDVD which is going to be for sure
614:
615: IF g_debug_stmt THEN

Line 987: l_BLOBLength PLS_INTEGER := DBMS_LOB.getLength( p_ClobData );

983: IS
984: l_DataSize PLS_INTEGER := 1;
985: l_Buffer RAW( 32767 );
986: l_TempBLOB BLOB;
987: l_BLOBLength PLS_INTEGER := DBMS_LOB.getLength( p_ClobData );
988: l_api_name CONSTANT VARCHAR2(25):= 'CLOB_TO_BLOB';
989: l_progress VARCHAR2(3);
990:
991: BEGIN

Line 993: DBMS_LOB.createTemporary( l_TempBLOB, TRUE );

989: l_progress VARCHAR2(3);
990:
991: BEGIN
992: l_progress := '000';
993: DBMS_LOB.createTemporary( l_TempBLOB, TRUE );
994:
995: l_progress := '001';
996: DBMS_LOB.OPEN( l_TempBLOB, DBMS_LOB.LOB_ReadWrite );
997:

Line 996: DBMS_LOB.OPEN( l_TempBLOB, DBMS_LOB.LOB_ReadWrite );

992: l_progress := '000';
993: DBMS_LOB.createTemporary( l_TempBLOB, TRUE );
994:
995: l_progress := '001';
996: DBMS_LOB.OPEN( l_TempBLOB, DBMS_LOB.LOB_ReadWrite );
997:
998: l_progress := '002';
999: LOOP
1000: l_progress := '003';

Line 1001: l_Buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( p_ClobData, 16000, l_DataSize ) );

997:
998: l_progress := '002';
999: LOOP
1000: l_progress := '003';
1001: l_Buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( p_ClobData, 16000, l_DataSize ) );
1002:
1003: IF UTL_RAW.LENGTH( l_Buffer ) > 0 THEN
1004: DBMS_LOB.writeAppend( l_TempBLOB, UTL_RAW.LENGTH( l_Buffer ), l_Buffer );
1005: END IF;

Line 1004: DBMS_LOB.writeAppend( l_TempBLOB, UTL_RAW.LENGTH( l_Buffer ), l_Buffer );

1000: l_progress := '003';
1001: l_Buffer := UTL_RAW.cast_to_raw( DBMS_LOB.SUBSTR( p_ClobData, 16000, l_DataSize ) );
1002:
1003: IF UTL_RAW.LENGTH( l_Buffer ) > 0 THEN
1004: DBMS_LOB.writeAppend( l_TempBLOB, UTL_RAW.LENGTH( l_Buffer ), l_Buffer );
1005: END IF;
1006:
1007: l_DataSize := l_DataSize + 16000;
1008: EXIT WHEN l_DataSize > l_BLOBLength;

Line 1035: DBMS_LOB.CREATETEMPORARY(l_CLOBData, TRUE);

1031:
1032: BEGIN
1033:
1034: l_progress := '000';
1035: DBMS_LOB.CREATETEMPORARY(l_CLOBData, TRUE);
1036:
1037: l_progress := '001';
1038: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_BlobData) / l_Buffer)
1039: LOOP

Line 1038: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_BlobData) / l_Buffer)

1034: l_progress := '000';
1035: DBMS_LOB.CREATETEMPORARY(l_CLOBData, TRUE);
1036:
1037: l_progress := '001';
1038: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_BlobData) / l_Buffer)
1039: LOOP
1040:
1041: l_progress := '002';
1042: l_TempChar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_BlobData, l_Buffer, l_Start));

Line 1042: l_TempChar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_BlobData, l_Buffer, l_Start));

1038: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_BlobData) / l_Buffer)
1039: LOOP
1040:
1041: l_progress := '002';
1042: l_TempChar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_BlobData, l_Buffer, l_Start));
1043:
1044: DBMS_LOB.WRITEAPPEND(l_CLOBData, LENGTH(l_TempChar), l_TempChar);
1045:
1046: l_Start := l_Start + l_Buffer;

Line 1044: DBMS_LOB.WRITEAPPEND(l_CLOBData, LENGTH(l_TempChar), l_TempChar);

1040:
1041: l_progress := '002';
1042: l_TempChar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_BlobData, l_Buffer, l_Start));
1043:
1044: DBMS_LOB.WRITEAPPEND(l_CLOBData, LENGTH(l_TempChar), l_TempChar);
1045:
1046: l_Start := l_Start + l_Buffer;
1047: END LOOP;
1048:

Line 1080: dbms_lob.createtemporary(l_new_Clob,TRUE);

1076:
1077: BEGIN
1078: l_progress := '000';
1079: -- initalize the new clob
1080: dbms_lob.createtemporary(l_new_Clob,TRUE);
1081:
1082: l_progress := '001';
1083: l_clob_len := dbms_lob.getlength(p_ClobData);
1084:

Line 1083: l_clob_len := dbms_lob.getlength(p_ClobData);

1079: -- initalize the new clob
1080: dbms_lob.createtemporary(l_new_Clob,TRUE);
1081:
1082: l_progress := '001';
1083: l_clob_len := dbms_lob.getlength(p_ClobData);
1084:
1085: l_progress := '002';
1086: WHILE l_pos < l_clob_len
1087: LOOP

Line 1088: dbms_lob.read(p_ClobData, l_amount, l_pos, l_buffer);

1084:
1085: l_progress := '002';
1086: WHILE l_pos < l_clob_len
1087: LOOP
1088: dbms_lob.read(p_ClobData, l_amount, l_pos, l_buffer);
1089:
1090: IF l_buffer IS NOT NULL THEN
1091: -- replace the text
1092: l_buffer := replace(l_buffer, p_str_to_replace, p_replace_with);

Line 1094: dbms_lob.writeappend(l_new_Clob, LENGTH(l_buffer), l_buffer);

1090: IF l_buffer IS NOT NULL THEN
1091: -- replace the text
1092: l_buffer := replace(l_buffer, p_str_to_replace, p_replace_with);
1093: -- write it to the new clob
1094: dbms_lob.writeappend(l_new_Clob, LENGTH(l_buffer), l_buffer);
1095: END IF;
1096: l_pos := l_pos + l_amount;
1097: END LOOP;
1098: l_progress := '003';