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

Line 147: Print( ' text=['||Dbms_Lob.Substr(p_catv_rec.text,80,1)||'...]');

143: Print( ' comments=['||p_catv_rec.comments||']');
144: Print( ' fulltext_yn=['||p_catv_rec.fulltext_yn||']');
145: Print( ' variation_description=['||p_catv_rec.variation_description||']');
146: Print( ' name=['||p_catv_rec.name||']');
147: Print( ' text=['||Dbms_Lob.Substr(p_catv_rec.text,80,1)||'...]');
148: Print( ' cat_type=['||p_catv_rec.cat_type||']');
149: Print( ' document_type=['||p_catv_rec.document_type||']');
150: Print( ' document_id=['||p_catv_rec.document_id||']');
151: Print( ' source_flag=['||p_catv_rec.source_flag||']');

Line 194: Print( ' text=['||Dbms_Lob.Substr(p_catv_rec.text,80,1)||'...]');

190: Print( ' comments=['||p_catv_rec.comments||']');
191: Print( ' fulltext_yn=['||p_catv_rec.fulltext_yn||']');
192: Print( ' variation_description=['||p_catv_rec.variation_description||']');
193: Print( ' name=['||p_catv_rec.name||']');
194: Print( ' text=['||Dbms_Lob.Substr(p_catv_rec.text,80,1)||'...]');
195: Print( ' cat_type=['||p_catv_rec.cat_type||']');
196: END;
197:
198: ---------------------------------------------------------------------------

Line 842: Dbms_Lob.createtemporary( l_txt, TRUE, Dbms_Lob.Session);

838: l_art_ver_id := Get_Art_Ver_Id(p_catv_rec.sav_sae_id,p_catv_rec.sav_sav_release);
839: END IF;
840:
841: IF (p_catv_rec.TEXT IS NULL) THEN
842: Dbms_Lob.createtemporary( l_txt, TRUE, Dbms_Lob.Session);
843: Dbms_Lob.writeappend( l_txt, 1, ' ');
844: ELSE
845: l_txt := p_catv_rec.TEXT;
846: END IF;

Line 843: Dbms_Lob.writeappend( l_txt, 1, ' ');

839: END IF;
840:
841: IF (p_catv_rec.TEXT IS NULL) THEN
842: Dbms_Lob.createtemporary( l_txt, TRUE, Dbms_Lob.Session);
843: Dbms_Lob.writeappend( l_txt, 1, ' ');
844: ELSE
845: l_txt := p_catv_rec.TEXT;
846: END IF;
847:

Line 901: IF Dbms_Lob.istemporary( l_txt )=1 THEN

897: x_article_version_id => x_art_ver_id
898: );
899: x_std_art_id := l_art_id;
900: x_std_art_ver_id := l_art_ver_id;
901: IF Dbms_Lob.istemporary( l_txt )=1 THEN
902: Dbms_Lob.freetemporary( l_txt );
903: END IF;
904: --------------------------------------------
905: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 902: Dbms_Lob.freetemporary( l_txt );

898: );
899: x_std_art_id := l_art_id;
900: x_std_art_ver_id := l_art_ver_id;
901: IF Dbms_Lob.istemporary( l_txt )=1 THEN
902: Dbms_Lob.freetemporary( l_txt );
903: END IF;
904: --------------------------------------------
905: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 1026: IF Dbms_Lob.istemporary( l_txt )=1 THEN

1022: CLOSE l_get_intent_csr;
1023: END IF;
1024:
1025: IF l_txt IS NOT NULL THEN
1026: IF Dbms_Lob.istemporary( l_txt )=1 THEN
1027: Dbms_Lob.freetemporary( l_txt );
1028: END IF;
1029: END IF;
1030: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1027: Dbms_Lob.freetemporary( l_txt );

1023: END IF;
1024:
1025: IF l_txt IS NOT NULL THEN
1026: IF Dbms_Lob.istemporary( l_txt )=1 THEN
1027: Dbms_Lob.freetemporary( l_txt );
1028: END IF;
1029: END IF;
1030: x_return_status := G_RET_STS_UNEXP_ERROR ;
1031: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 1416: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then

1412: END IF;
1413: --
1414: -- code for temporary clob ... start
1415: --
1416: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
1417: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
1418: -- l_clob := p_catv_rec.TEXT;
1419: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1420: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);

Line 1417: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);

1413: --
1414: -- code for temporary clob ... start
1415: --
1416: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
1417: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
1418: -- l_clob := p_catv_rec.TEXT;
1419: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1420: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1421: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,

Line 1419: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);

1415: --
1416: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
1417: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
1418: -- l_clob := p_catv_rec.TEXT;
1419: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1420: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1421: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1422: -- amount => dbms_lob.getlength(l_clob));
1423: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);

Line 1420: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);

1416: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
1417: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
1418: -- l_clob := p_catv_rec.TEXT;
1419: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1420: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1421: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1422: -- amount => dbms_lob.getlength(l_clob));
1423: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1424: -- DBMS_LOB.CLOSE(l_clob);

Line 1421: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,

1417: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
1418: -- l_clob := p_catv_rec.TEXT;
1419: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1420: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1421: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1422: -- amount => dbms_lob.getlength(l_clob));
1423: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1424: -- DBMS_LOB.CLOSE(l_clob);
1425: -- DBMS_LOB.freetemporary(l_clob);

Line 1422: -- amount => dbms_lob.getlength(l_clob));

1418: -- l_clob := p_catv_rec.TEXT;
1419: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1420: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1421: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1422: -- amount => dbms_lob.getlength(l_clob));
1423: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1424: -- DBMS_LOB.CLOSE(l_clob);
1425: -- DBMS_LOB.freetemporary(l_clob);
1426: -- end if;

Line 1423: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);

1419: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1420: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1421: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1422: -- amount => dbms_lob.getlength(l_clob));
1423: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1424: -- DBMS_LOB.CLOSE(l_clob);
1425: -- DBMS_LOB.freetemporary(l_clob);
1426: -- end if;
1427: --

Line 1424: -- DBMS_LOB.CLOSE(l_clob);

1420: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1421: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1422: -- amount => dbms_lob.getlength(l_clob));
1423: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1424: -- DBMS_LOB.CLOSE(l_clob);
1425: -- DBMS_LOB.freetemporary(l_clob);
1426: -- end if;
1427: --
1428: -- code for temporary clob ... end

Line 1425: -- DBMS_LOB.freetemporary(l_clob);

1421: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1422: -- amount => dbms_lob.getlength(l_clob));
1423: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1424: -- DBMS_LOB.CLOSE(l_clob);
1425: -- DBMS_LOB.freetemporary(l_clob);
1426: -- end if;
1427: --
1428: -- code for temporary clob ... end
1429: --

Line 2076: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then

2072: END IF;
2073: --
2074: -- code for temporary clob ... start
2075: --
2076: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
2077: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
2078: -- l_clob := p_catv_rec.TEXT;
2079: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2080: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);

Line 2077: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);

2073: --
2074: -- code for temporary clob ... start
2075: --
2076: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
2077: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
2078: -- l_clob := p_catv_rec.TEXT;
2079: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2080: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2081: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,

Line 2079: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);

2075: --
2076: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
2077: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
2078: -- l_clob := p_catv_rec.TEXT;
2079: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2080: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2081: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2082: -- amount => dbms_lob.getlength(l_clob));
2083: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);

Line 2080: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);

2076: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
2077: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
2078: -- l_clob := p_catv_rec.TEXT;
2079: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2080: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2081: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2082: -- amount => dbms_lob.getlength(l_clob));
2083: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2084: -- DBMS_LOB.CLOSE(l_clob);

Line 2081: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,

2077: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
2078: -- l_clob := p_catv_rec.TEXT;
2079: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2080: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2081: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2082: -- amount => dbms_lob.getlength(l_clob));
2083: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2084: -- DBMS_LOB.CLOSE(l_clob);
2085: -- DBMS_LOB.freetemporary(l_clob);

Line 2082: -- amount => dbms_lob.getlength(l_clob));

2078: -- l_clob := p_catv_rec.TEXT;
2079: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2080: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2081: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2082: -- amount => dbms_lob.getlength(l_clob));
2083: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2084: -- DBMS_LOB.CLOSE(l_clob);
2085: -- DBMS_LOB.freetemporary(l_clob);
2086: -- end if;

Line 2083: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);

2079: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2080: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2081: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2082: -- amount => dbms_lob.getlength(l_clob));
2083: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2084: -- DBMS_LOB.CLOSE(l_clob);
2085: -- DBMS_LOB.freetemporary(l_clob);
2086: -- end if;
2087: --

Line 2084: -- DBMS_LOB.CLOSE(l_clob);

2080: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2081: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2082: -- amount => dbms_lob.getlength(l_clob));
2083: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2084: -- DBMS_LOB.CLOSE(l_clob);
2085: -- DBMS_LOB.freetemporary(l_clob);
2086: -- end if;
2087: --
2088: -- code for temporary clob ... end

Line 2085: -- DBMS_LOB.freetemporary(l_clob);

2081: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2082: -- amount => dbms_lob.getlength(l_clob));
2083: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2084: -- DBMS_LOB.CLOSE(l_clob);
2085: -- DBMS_LOB.freetemporary(l_clob);
2086: -- end if;
2087: --
2088: -- code for temporary clob ... end
2089: --