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

Line 199: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);

195: END LOOP;
196: END IF;
197:
198: -- create output parameter
199: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
200: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
201: xmldom.writetoclob(doc, l_lob);
202: solutionsXML := l_lob;
203: SYS.DBMS_LOB.CLOSE(l_lob);

Line 200: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);

196: END IF;
197:
198: -- create output parameter
199: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
200: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
201: xmldom.writetoclob(doc, l_lob);
202: solutionsXML := l_lob;
203: SYS.DBMS_LOB.CLOSE(l_lob);
204: SYS.DBMS_LOB.freetemporary(l_lob);

Line 203: SYS.DBMS_LOB.CLOSE(l_lob);

199: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
200: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
201: xmldom.writetoclob(doc, l_lob);
202: solutionsXML := l_lob;
203: SYS.DBMS_LOB.CLOSE(l_lob);
204: SYS.DBMS_LOB.freetemporary(l_lob);
205: xmldom.freeDocument(doc);
206: EXCEPTION
207: WHEN OTHERS THEN

Line 204: SYS.DBMS_LOB.freetemporary(l_lob);

200: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
201: xmldom.writetoclob(doc, l_lob);
202: solutionsXML := l_lob;
203: SYS.DBMS_LOB.CLOSE(l_lob);
204: SYS.DBMS_LOB.freetemporary(l_lob);
205: xmldom.freeDocument(doc);
206: EXCEPTION
207: WHEN OTHERS THEN
208: x_run_id := 0;

Line 272: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);

268: END LOOP;
269: END IF;
270:
271: -- create output parameter
272: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
273: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
274: xmldom.writetoclob(doc, l_lob);
275: modelsXML := l_lob;
276: SYS.DBMS_LOB.CLOSE(l_lob);

Line 273: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);

269: END IF;
270:
271: -- create output parameter
272: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
273: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
274: xmldom.writetoclob(doc, l_lob);
275: modelsXML := l_lob;
276: SYS.DBMS_LOB.CLOSE(l_lob);
277: SYS.DBMS_LOB.freetemporary(l_lob);

Line 276: SYS.DBMS_LOB.CLOSE(l_lob);

272: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
273: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
274: xmldom.writetoclob(doc, l_lob);
275: modelsXML := l_lob;
276: SYS.DBMS_LOB.CLOSE(l_lob);
277: SYS.DBMS_LOB.freetemporary(l_lob);
278: xmldom.freeDocument(doc);
279: EXCEPTION
280: WHEN OTHERS THEN

Line 277: SYS.DBMS_LOB.freetemporary(l_lob);

273: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
274: xmldom.writetoclob(doc, l_lob);
275: modelsXML := l_lob;
276: SYS.DBMS_LOB.CLOSE(l_lob);
277: SYS.DBMS_LOB.freetemporary(l_lob);
278: xmldom.freeDocument(doc);
279: EXCEPTION
280: WHEN OTHERS THEN
281: x_run_id := 0;