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

Line 393: DBMS_LOB.OPEN(l_clob_loc,DBMS_LOB.lob_readwrite);

389:
390: SELECT rule_text INTO l_clob_loc FROM CZ_RULES
391: WHERE rule_id = p_rule_id;
392:
393: DBMS_LOB.OPEN(l_clob_loc,DBMS_LOB.lob_readwrite);
394:
395: l_amount:=LENGTH(p_buffer);
396:
397: DBMS_LOB.WRITE(l_clob_loc, l_amount, l_position, p_buffer);

Line 397: DBMS_LOB.WRITE(l_clob_loc, l_amount, l_position, p_buffer);

393: DBMS_LOB.OPEN(l_clob_loc,DBMS_LOB.lob_readwrite);
394:
395: l_amount:=LENGTH(p_buffer);
396:
397: DBMS_LOB.WRITE(l_clob_loc, l_amount, l_position, p_buffer);
398:
399: DBMS_LOB.CLOSE (l_clob_loc);
400:
401: END put_String_Into_CLOB;

Line 399: DBMS_LOB.CLOSE (l_clob_loc);

395: l_amount:=LENGTH(p_buffer);
396:
397: DBMS_LOB.WRITE(l_clob_loc, l_amount, l_position, p_buffer);
398:
399: DBMS_LOB.CLOSE (l_clob_loc);
400:
401: END put_String_Into_CLOB;
402:
403: FUNCTION get_String_From_CLOB RETURN VARCHAR2 IS

Line 413: --Bug #6936712. Removing calls to opening-closing DBMS_LOB procedures.

409: l_buffer VARCHAR2(32000);
410:
411: BEGIN
412:
413: --Bug #6936712. Removing calls to opening-closing DBMS_LOB procedures.
414: --The following SELECT creates a temporary LOB, so there is no need in
415: --explicit call to CREATETEMPORARY. Temporary LOBs will get freed
416: --automatically - examples in Oracle Doc do not call FREETEMPORARY.
417: --Also, Oracle Doc says that calls to OPEN-CLOSE are not required. It

Line 423: l_chunksize := DBMS_LOB.GETCHUNKSIZE(l_clob_loc);

419:
420: SELECT rule_text INTO l_clob_loc FROM CZ_RULES
421: WHERE rule_id = p_rule_id;
422:
423: l_chunksize := DBMS_LOB.GETCHUNKSIZE(l_clob_loc);
424: --vsingava 18th Dec '08 bug7316397
425: IF (l_chunksize < MAX_CHUNK_SIZE) THEN
426: l_amount := FLOOR(MAX_CHUNK_SIZE / l_chunksize) * l_chunksize;
427: ELSE

Line 433: DBMS_LOB.READ (l_clob_loc, l_amount, l_position, l_buffer);

429: END IF;
430:
431: BEGIN
432: LOOP
433: DBMS_LOB.READ (l_clob_loc, l_amount, l_position, l_buffer);
434: l_position := l_position + l_amount;
435: END LOOP;
436: EXCEPTION
437: WHEN OTHERS THEN

Line 5796: SYS.DBMS_LOB.CREATETEMPORARY(l_lob,TRUE,dbms_lob.session);

5792: END LOOP;
5793:
5794:
5795:
5796: SYS.DBMS_LOB.CREATETEMPORARY(l_lob,TRUE,dbms_lob.session);
5797: SYS.DBMS_LOB.OPEN (l_lob,DBMS_LOB.LOB_READWRITE);
5798: firstChunk := jdr_utils.EXPORTDOCUMENT(p_old_document_name,l_exportfinished);
5799:
5800: IF (firstChunk IS NULL) THEN

Line 5797: SYS.DBMS_LOB.OPEN (l_lob,DBMS_LOB.LOB_READWRITE);

5793:
5794:
5795:
5796: SYS.DBMS_LOB.CREATETEMPORARY(l_lob,TRUE,dbms_lob.session);
5797: SYS.DBMS_LOB.OPEN (l_lob,DBMS_LOB.LOB_READWRITE);
5798: firstChunk := jdr_utils.EXPORTDOCUMENT(p_old_document_name,l_exportfinished);
5799:
5800: IF (firstChunk IS NULL) THEN
5801: RAISE DOCUMENT_IS_NULL;

Line 5807: SYS.DBMS_LOB.writeappend(l_lob,l_length,l_buffer);

5803:
5804: l_buffer := LTRIM(RTRIM(firstChunk));
5805: l_length := LENGTH(l_buffer);
5806: BEGIN
5807: SYS.DBMS_LOB.writeappend(l_lob,l_length,l_buffer);
5808: EXCEPTION WHEN OTHERS THEN
5809: NULL;
5810: END;
5811:

Line 5818: SYS.DBMS_LOB.writeappend(l_lob,l_length,l_buffer);

5814: l_buffer := LTRIM(RTRIM(l_buffer));
5815:
5816: EXIT WHEN l_buffer IS NULL;
5817: l_length := LENGTH(l_buffer);
5818: SYS.DBMS_LOB.writeappend(l_lob,l_length,l_buffer);
5819: END LOOP;
5820:
5821: l_length := SYS.DBMS_LOB.getlength(l_lob);
5822: p := xmlparser.newParser;

Line 5821: l_length := SYS.DBMS_LOB.getlength(l_lob);

5817: l_length := LENGTH(l_buffer);
5818: SYS.DBMS_LOB.writeappend(l_lob,l_length,l_buffer);
5819: END LOOP;
5820:
5821: l_length := SYS.DBMS_LOB.getlength(l_lob);
5822: p := xmlparser.newParser;
5823: xmlparser.parseCLOB(p,l_lob);
5824: doc := xmlparser.getDocument(p);
5825:

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

5822: p := xmlparser.newParser;
5823: xmlparser.parseCLOB(p,l_lob);
5824: doc := xmlparser.getDocument(p);
5825:
5826: SYS.DBMS_LOB.CLOSE (l_lob);
5827: SYS.DBMS_LOB.FREETEMPORARY(l_lob);
5828:
5829: l_doc := jdr_docbuilder.createDocument(p_new_document_name);
5830: top_node := xmldom.makeNode(xmldom.getDocumentElement(doc));

Line 5827: SYS.DBMS_LOB.FREETEMPORARY(l_lob);

5823: xmlparser.parseCLOB(p,l_lob);
5824: doc := xmlparser.getDocument(p);
5825:
5826: SYS.DBMS_LOB.CLOSE (l_lob);
5827: SYS.DBMS_LOB.FREETEMPORARY(l_lob);
5828:
5829: l_doc := jdr_docbuilder.createDocument(p_new_document_name);
5830: top_node := xmldom.makeNode(xmldom.getDocumentElement(doc));
5831: