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 146: Print( ' text=['||Dbms_Lob.Substr(p_catv_rec.text,80,1)||'...]');

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

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

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

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

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

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

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

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

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

Line 899: Dbms_Lob.freetemporary( l_txt );

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

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

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

Line 1024: Dbms_Lob.freetemporary( l_txt );

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

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

1405: END IF;
1406: --
1407: -- code for temporary clob ... start
1408: --
1409: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
1410: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
1411: -- l_clob := p_catv_rec.TEXT;
1412: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1413: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);

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

1406: --
1407: -- code for temporary clob ... start
1408: --
1409: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
1410: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
1411: -- l_clob := p_catv_rec.TEXT;
1412: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1413: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1414: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,

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

1408: --
1409: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
1410: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
1411: -- l_clob := p_catv_rec.TEXT;
1412: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1413: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1414: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1415: -- amount => dbms_lob.getlength(l_clob));
1416: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);

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

1409: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
1410: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
1411: -- l_clob := p_catv_rec.TEXT;
1412: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1413: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1414: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1415: -- amount => dbms_lob.getlength(l_clob));
1416: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1417: -- DBMS_LOB.CLOSE(l_clob);

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

1410: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
1411: -- l_clob := p_catv_rec.TEXT;
1412: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1413: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1414: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1415: -- amount => dbms_lob.getlength(l_clob));
1416: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1417: -- DBMS_LOB.CLOSE(l_clob);
1418: -- DBMS_LOB.freetemporary(l_clob);

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

1411: -- l_clob := p_catv_rec.TEXT;
1412: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1413: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1414: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1415: -- amount => dbms_lob.getlength(l_clob));
1416: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1417: -- DBMS_LOB.CLOSE(l_clob);
1418: -- DBMS_LOB.freetemporary(l_clob);
1419: -- end if;

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

1412: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
1413: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1414: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1415: -- amount => dbms_lob.getlength(l_clob));
1416: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1417: -- DBMS_LOB.CLOSE(l_clob);
1418: -- DBMS_LOB.freetemporary(l_clob);
1419: -- end if;
1420: --

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

1413: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
1414: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1415: -- amount => dbms_lob.getlength(l_clob));
1416: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1417: -- DBMS_LOB.CLOSE(l_clob);
1418: -- DBMS_LOB.freetemporary(l_clob);
1419: -- end if;
1420: --
1421: -- code for temporary clob ... end

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

1414: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
1415: -- amount => dbms_lob.getlength(l_clob));
1416: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
1417: -- DBMS_LOB.CLOSE(l_clob);
1418: -- DBMS_LOB.freetemporary(l_clob);
1419: -- end if;
1420: --
1421: -- code for temporary clob ... end
1422: --

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

2058: END IF;
2059: --
2060: -- code for temporary clob ... start
2061: --
2062: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
2063: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
2064: -- l_clob := p_catv_rec.TEXT;
2065: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2066: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);

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

2059: --
2060: -- code for temporary clob ... start
2061: --
2062: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
2063: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
2064: -- l_clob := p_catv_rec.TEXT;
2065: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2066: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2067: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,

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

2061: --
2062: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
2063: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
2064: -- l_clob := p_catv_rec.TEXT;
2065: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2066: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2067: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2068: -- amount => dbms_lob.getlength(l_clob));
2069: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);

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

2062: -- if (dbms_lob.istemporary(p_catv_rec.TEXT) = 1) then
2063: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
2064: -- l_clob := p_catv_rec.TEXT;
2065: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2066: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2067: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2068: -- amount => dbms_lob.getlength(l_clob));
2069: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2070: -- DBMS_LOB.CLOSE(l_clob);

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

2063: -- DBMS_LOB.CREATETEMPORARY(gi_catv_rec.TEXT,FALSE,DBMS_LOB.CALL);
2064: -- l_clob := p_catv_rec.TEXT;
2065: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2066: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2067: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2068: -- amount => dbms_lob.getlength(l_clob));
2069: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2070: -- DBMS_LOB.CLOSE(l_clob);
2071: -- DBMS_LOB.freetemporary(l_clob);

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

2064: -- l_clob := p_catv_rec.TEXT;
2065: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2066: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2067: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2068: -- amount => dbms_lob.getlength(l_clob));
2069: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2070: -- DBMS_LOB.CLOSE(l_clob);
2071: -- DBMS_LOB.freetemporary(l_clob);
2072: -- end if;

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

2065: -- DBMS_LOB.OPEN(l_clob, DBMS_LOB.LOB_READONLY);
2066: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2067: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2068: -- amount => dbms_lob.getlength(l_clob));
2069: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2070: -- DBMS_LOB.CLOSE(l_clob);
2071: -- DBMS_LOB.freetemporary(l_clob);
2072: -- end if;
2073: --

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

2066: -- DBMS_LOB.OPEN(gi_catv_rec.TEXT, DBMS_LOB.LOB_READWRITE);
2067: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2068: -- amount => dbms_lob.getlength(l_clob));
2069: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2070: -- DBMS_LOB.CLOSE(l_clob);
2071: -- DBMS_LOB.freetemporary(l_clob);
2072: -- end if;
2073: --
2074: -- code for temporary clob ... end

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

2067: -- DBMS_LOB.COPY(dest_lob => gi_catv_rec.TEXT,src_lob => l_clob,
2068: -- amount => dbms_lob.getlength(l_clob));
2069: -- DBMS_LOB.CLOSE(gi_catv_rec.TEXT);
2070: -- DBMS_LOB.CLOSE(l_clob);
2071: -- DBMS_LOB.freetemporary(l_clob);
2072: -- end if;
2073: --
2074: -- code for temporary clob ... end
2075: --