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

Line 360: n := dbms_lob.instr( l_doc_clob,'',1,(l_listdefCount+1));

356: l_listilfocount := l_doc_xml.extract('//wlist[position()=last()]/@w:ilfo','xmlns:w="http://schemas.microsoft.com/office/word/2003/wordml"').getNumberVal();
357:
358: l_progress := '100';
359: -- List processing start --serukull changes
360: n := dbms_lob.instr( l_doc_clob,'',1,(l_listdefCount+1));
361: n := n+12;
362:
363: if ( nvl(n,0) > 12 AND Nvl(dbms_lob.getlength(l_doc_listdef_clob),0) > 0 )
364: THEN

Line 363: if ( nvl(n,0) > 12 AND Nvl(dbms_lob.getlength(l_doc_listdef_clob),0) > 0 )

359: -- List processing start --serukull changes
360: n := dbms_lob.instr( l_doc_clob,'',1,(l_listdefCount+1));
361: n := n+12;
362:
363: if ( nvl(n,0) > 12 AND Nvl(dbms_lob.getlength(l_doc_listdef_clob),0) > 0 )
364: THEN
365: dbms_lob.createtemporary(l_result, false, dbms_lob.call);
366: dbms_lob.copy(l_result, l_doc_clob, n - 1, 1, 1);
367: dbms_lob.copy(l_result,

Line 365: dbms_lob.createtemporary(l_result, false, dbms_lob.call);

361: n := n+12;
362:
363: if ( nvl(n,0) > 12 AND Nvl(dbms_lob.getlength(l_doc_listdef_clob),0) > 0 )
364: THEN
365: dbms_lob.createtemporary(l_result, false, dbms_lob.call);
366: dbms_lob.copy(l_result, l_doc_clob, n - 1, 1, 1);
367: dbms_lob.copy(l_result,
368: l_doc_listdef_clob,
369: dbms_lob.getlength(l_doc_listdef_clob) ,

Line 366: dbms_lob.copy(l_result, l_doc_clob, n - 1, 1, 1);

362:
363: if ( nvl(n,0) > 12 AND Nvl(dbms_lob.getlength(l_doc_listdef_clob),0) > 0 )
364: THEN
365: dbms_lob.createtemporary(l_result, false, dbms_lob.call);
366: dbms_lob.copy(l_result, l_doc_clob, n - 1, 1, 1);
367: dbms_lob.copy(l_result,
368: l_doc_listdef_clob,
369: dbms_lob.getlength(l_doc_listdef_clob) ,
370: dbms_lob.getlength(l_result) + 1,

Line 367: dbms_lob.copy(l_result,

363: if ( nvl(n,0) > 12 AND Nvl(dbms_lob.getlength(l_doc_listdef_clob),0) > 0 )
364: THEN
365: dbms_lob.createtemporary(l_result, false, dbms_lob.call);
366: dbms_lob.copy(l_result, l_doc_clob, n - 1, 1, 1);
367: dbms_lob.copy(l_result,
368: l_doc_listdef_clob,
369: dbms_lob.getlength(l_doc_listdef_clob) ,
370: dbms_lob.getlength(l_result) + 1,
371: 1 );

Line 369: dbms_lob.getlength(l_doc_listdef_clob) ,

365: dbms_lob.createtemporary(l_result, false, dbms_lob.call);
366: dbms_lob.copy(l_result, l_doc_clob, n - 1, 1, 1);
367: dbms_lob.copy(l_result,
368: l_doc_listdef_clob,
369: dbms_lob.getlength(l_doc_listdef_clob) ,
370: dbms_lob.getlength(l_result) + 1,
371: 1 );
372: dbms_lob.copy(l_result,
373: l_doc_clob,

Line 370: dbms_lob.getlength(l_result) + 1,

366: dbms_lob.copy(l_result, l_doc_clob, n - 1, 1, 1);
367: dbms_lob.copy(l_result,
368: l_doc_listdef_clob,
369: dbms_lob.getlength(l_doc_listdef_clob) ,
370: dbms_lob.getlength(l_result) + 1,
371: 1 );
372: dbms_lob.copy(l_result,
373: l_doc_clob,
374: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,

Line 372: dbms_lob.copy(l_result,

368: l_doc_listdef_clob,
369: dbms_lob.getlength(l_doc_listdef_clob) ,
370: dbms_lob.getlength(l_result) + 1,
371: 1 );
372: dbms_lob.copy(l_result,
373: l_doc_clob,
374: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,
375: dbms_lob.getlength(l_result) + 1,
376: n + length('') );

Line 374: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,

370: dbms_lob.getlength(l_result) + 1,
371: 1 );
372: dbms_lob.copy(l_result,
373: l_doc_clob,
374: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,
375: dbms_lob.getlength(l_result) + 1,
376: n + length('') );
377:
378: l_doc_clob := l_result;

Line 375: dbms_lob.getlength(l_result) + 1,

371: 1 );
372: dbms_lob.copy(l_result,
373: l_doc_clob,
374: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,
375: dbms_lob.getlength(l_result) + 1,
376: n + length('') );
377:
378: l_doc_clob := l_result;
379: DBMS_LOB.FREETEMPORARY(l_result);

Line 379: DBMS_LOB.FREETEMPORARY(l_result);

375: dbms_lob.getlength(l_result) + 1,
376: n + length('') );
377:
378: l_doc_clob := l_result;
379: DBMS_LOB.FREETEMPORARY(l_result);
380: end if;
381: -- ListDef added
382:
383: l_progress := '110';

Line 386: n := dbms_lob.instr( l_doc_clob,'',1,l_listilfoCount);

382:
383: l_progress := '110';
384:
385: -- Add wlists --serukull changes Perf Fix
386: n := dbms_lob.instr( l_doc_clob,'',1,l_listilfoCount);
387: n := n+8;
388: if ( nvl(n,0) > 8 AND Nvl(dbms_lob.getlength(l_doc_list_clob),0) > 0 )
389: THEN
390: dbms_lob.createtemporary(l_result2, false, dbms_lob.call);

Line 388: if ( nvl(n,0) > 8 AND Nvl(dbms_lob.getlength(l_doc_list_clob),0) > 0 )

384:
385: -- Add wlists --serukull changes Perf Fix
386: n := dbms_lob.instr( l_doc_clob,'',1,l_listilfoCount);
387: n := n+8;
388: if ( nvl(n,0) > 8 AND Nvl(dbms_lob.getlength(l_doc_list_clob),0) > 0 )
389: THEN
390: dbms_lob.createtemporary(l_result2, false, dbms_lob.call);
391: dbms_lob.copy(l_result2, l_doc_clob, n - 1, 1, 1);
392: dbms_lob.copy(l_result2,

Line 390: dbms_lob.createtemporary(l_result2, false, dbms_lob.call);

386: n := dbms_lob.instr( l_doc_clob,'',1,l_listilfoCount);
387: n := n+8;
388: if ( nvl(n,0) > 8 AND Nvl(dbms_lob.getlength(l_doc_list_clob),0) > 0 )
389: THEN
390: dbms_lob.createtemporary(l_result2, false, dbms_lob.call);
391: dbms_lob.copy(l_result2, l_doc_clob, n - 1, 1, 1);
392: dbms_lob.copy(l_result2,
393: l_doc_list_clob,
394: dbms_lob.getlength(l_doc_list_clob) ,

Line 391: dbms_lob.copy(l_result2, l_doc_clob, n - 1, 1, 1);

387: n := n+8;
388: if ( nvl(n,0) > 8 AND Nvl(dbms_lob.getlength(l_doc_list_clob),0) > 0 )
389: THEN
390: dbms_lob.createtemporary(l_result2, false, dbms_lob.call);
391: dbms_lob.copy(l_result2, l_doc_clob, n - 1, 1, 1);
392: dbms_lob.copy(l_result2,
393: l_doc_list_clob,
394: dbms_lob.getlength(l_doc_list_clob) ,
395: dbms_lob.getlength(l_result2) + 1,

Line 392: dbms_lob.copy(l_result2,

388: if ( nvl(n,0) > 8 AND Nvl(dbms_lob.getlength(l_doc_list_clob),0) > 0 )
389: THEN
390: dbms_lob.createtemporary(l_result2, false, dbms_lob.call);
391: dbms_lob.copy(l_result2, l_doc_clob, n - 1, 1, 1);
392: dbms_lob.copy(l_result2,
393: l_doc_list_clob,
394: dbms_lob.getlength(l_doc_list_clob) ,
395: dbms_lob.getlength(l_result2) + 1,
396: 1 );

Line 394: dbms_lob.getlength(l_doc_list_clob) ,

390: dbms_lob.createtemporary(l_result2, false, dbms_lob.call);
391: dbms_lob.copy(l_result2, l_doc_clob, n - 1, 1, 1);
392: dbms_lob.copy(l_result2,
393: l_doc_list_clob,
394: dbms_lob.getlength(l_doc_list_clob) ,
395: dbms_lob.getlength(l_result2) + 1,
396: 1 );
397: dbms_lob.copy(l_result2,
398: l_doc_clob,

Line 395: dbms_lob.getlength(l_result2) + 1,

391: dbms_lob.copy(l_result2, l_doc_clob, n - 1, 1, 1);
392: dbms_lob.copy(l_result2,
393: l_doc_list_clob,
394: dbms_lob.getlength(l_doc_list_clob) ,
395: dbms_lob.getlength(l_result2) + 1,
396: 1 );
397: dbms_lob.copy(l_result2,
398: l_doc_clob,
399: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,

Line 397: dbms_lob.copy(l_result2,

393: l_doc_list_clob,
394: dbms_lob.getlength(l_doc_list_clob) ,
395: dbms_lob.getlength(l_result2) + 1,
396: 1 );
397: dbms_lob.copy(l_result2,
398: l_doc_clob,
399: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,
400: dbms_lob.getlength(l_result2) + 1,
401: n + length('') );

Line 399: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,

395: dbms_lob.getlength(l_result2) + 1,
396: 1 );
397: dbms_lob.copy(l_result2,
398: l_doc_clob,
399: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,
400: dbms_lob.getlength(l_result2) + 1,
401: n + length('') );
402: l_doc_clob := l_result2;
403: DBMS_LOB.FREETEMPORARY(l_result2);

Line 400: dbms_lob.getlength(l_result2) + 1,

396: 1 );
397: dbms_lob.copy(l_result2,
398: l_doc_clob,
399: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,
400: dbms_lob.getlength(l_result2) + 1,
401: n + length('') );
402: l_doc_clob := l_result2;
403: DBMS_LOB.FREETEMPORARY(l_result2);
404: end if;

Line 403: DBMS_LOB.FREETEMPORARY(l_result2);

399: dbms_lob.getlength(l_doc_clob) - (n + length('')) + 1 ,
400: dbms_lob.getlength(l_result2) + 1,
401: n + length('') );
402: l_doc_clob := l_result2;
403: DBMS_LOB.FREETEMPORARY(l_result2);
404: end if;
405:
406:
407: l_doc_clob := regexp_replace(regexp_replace(regexp_replace(regexp_replace(l_doc_clob,'wbody','w:body'),'',

Line 492: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);

488: G_MODULE||l_api_name,
489: '100: Entered '||G_PKG_NAME ||'.'||'get_article_body');
490: END IF;
491:
492: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
493:
494: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
495: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
496: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);

Line 494: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP

490: END IF;
491:
492: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
493:
494: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
495: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
496: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
497: v_start := v_start + v_buffer;
498: END LOOP;

Line 495: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));

491:
492: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
493:
494: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
495: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
496: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
497: v_start := v_start + v_buffer;
498: END LOOP;
499:

Line 496: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);

492: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
493:
494: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
495: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
496: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
497: v_start := v_start + v_buffer;
498: END LOOP;
499:
500:

Line 657: AND Dbms_Lob.compare(okc_word_download_upload.get_articleWML_Text(VER.article_text_in_word),okc_word_download_upload.get_articleWML_Text(st.CLOB_data)) <> 0;

653: AND st.action <> 'ADDED'
654: AND ART.id = st.cat_id
655: and VER.article_id = ART.sav_sae_id
656: and VER.article_version_id = ART.article_version_id
657: AND Dbms_Lob.compare(okc_word_download_upload.get_articleWML_Text(VER.article_text_in_word),okc_word_download_upload.get_articleWML_Text(st.CLOB_data)) <> 0;
658:
659: -- Mark the Clauses as 'UPDATED'
660: l_progress := '110';
661: IF cat_id1_tbl.Count>0 THEN

Line 750: DBMS_LOB.CREATETEMPORARY(l_doc_clob, TRUE);

746:
747:
748: l_art_clob := '##ARTICLEWML##';
749:
750: DBMS_LOB.CREATETEMPORARY(l_doc_clob, TRUE);
751:
752: BEGIN
753:
754: OPEN get_doc_data;

Line 845: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);

841: G_MODULE||l_api_name,
842: '100: Entered '||G_PKG_NAME ||'.'||'BLOB_TO_CLOB');
843: END IF;
844:
845: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
846:
847: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
848: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
849: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);

Line 847: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP

843: END IF;
844:
845: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
846:
847: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
848: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
849: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
850: v_start := v_start + v_buffer;
851: END LOOP;

Line 848: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));

844:
845: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
846:
847: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
848: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
849: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
850: v_start := v_start + v_buffer;
851: END LOOP;
852:

Line 849: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);

845: DBMS_LOB.CREATETEMPORARY(v_clob, TRUE);
846:
847: FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(p_text_in_word) / v_buffer) LOOP
848: v_varchar := UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(p_text_in_word, v_buffer, v_start));
849: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
850: v_start := v_start + v_buffer;
851: END LOOP;
852:
853: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 888: DBMS_LOB.CREATETEMPORARY(l_art_blob, FALSE);

884: G_MODULE||l_api_name,
885: '100: Entered '||G_PKG_NAME ||'.'||'Clob_to_blob');
886: END IF;
887:
888: DBMS_LOB.CREATETEMPORARY(l_art_blob, FALSE);
889:
890: DBMS_LOB.convertToBlob(l_art_blob,p_clob,DBMS_lob.getlength(p_clob),
891: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
892:

Line 890: DBMS_LOB.convertToBlob(l_art_blob,p_clob,DBMS_lob.getlength(p_clob),

886: END IF;
887:
888: DBMS_LOB.CREATETEMPORARY(l_art_blob, FALSE);
889:
890: DBMS_LOB.convertToBlob(l_art_blob,p_clob,DBMS_lob.getlength(p_clob),
891: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
892:
893: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

Line 891: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);

887:
888: DBMS_LOB.CREATETEMPORARY(l_art_blob, FALSE);
889:
890: DBMS_LOB.convertToBlob(l_art_blob,p_clob,DBMS_lob.getlength(p_clob),
891: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
892:
893: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
895: G_MODULE||l_api_name,

Line 1489: l_encoding_st:=Dbms_Lob.InStr(l_clob,'encoding="',1)+length('encoding="');

1485: l_encoding VARCHAR2(100);
1486: l_clob CLOB;
1487: BEGIN
1488: l_clob := p_clob;
1489: l_encoding_st:=Dbms_Lob.InStr(l_clob,'encoding="',1)+length('encoding="');
1490: l_encoding_end:=Dbms_Lob.InStr(l_clob,'"',l_encoding_st);
1491: l_encoding:=Dbms_Lob.SubStr(l_clob,l_encoding_end-l_encoding_st,l_encoding_st);
1492: IF l_encoding <> 'UTF-8' THEN
1493: l_clob:=REGEXP_REPLACE(l_clob, l_encoding, 'UTF-8',1,1);

Line 1490: l_encoding_end:=Dbms_Lob.InStr(l_clob,'"',l_encoding_st);

1486: l_clob CLOB;
1487: BEGIN
1488: l_clob := p_clob;
1489: l_encoding_st:=Dbms_Lob.InStr(l_clob,'encoding="',1)+length('encoding="');
1490: l_encoding_end:=Dbms_Lob.InStr(l_clob,'"',l_encoding_st);
1491: l_encoding:=Dbms_Lob.SubStr(l_clob,l_encoding_end-l_encoding_st,l_encoding_st);
1492: IF l_encoding <> 'UTF-8' THEN
1493: l_clob:=REGEXP_REPLACE(l_clob, l_encoding, 'UTF-8',1,1);
1494: END IF;

Line 1491: l_encoding:=Dbms_Lob.SubStr(l_clob,l_encoding_end-l_encoding_st,l_encoding_st);

1487: BEGIN
1488: l_clob := p_clob;
1489: l_encoding_st:=Dbms_Lob.InStr(l_clob,'encoding="',1)+length('encoding="');
1490: l_encoding_end:=Dbms_Lob.InStr(l_clob,'"',l_encoding_st);
1491: l_encoding:=Dbms_Lob.SubStr(l_clob,l_encoding_end-l_encoding_st,l_encoding_st);
1492: IF l_encoding <> 'UTF-8' THEN
1493: l_clob:=REGEXP_REPLACE(l_clob, l_encoding, 'UTF-8',1,1);
1494: END IF;
1495: RETURN l_clob;