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

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

3758: END LOOP;
3759:
3760: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
3761: IF (l_chunk_tbl.COUNT > 0) THEN
3762: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3763: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3764:
3765: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3766: LOOP

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

3759:
3760: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
3761: IF (l_chunk_tbl.COUNT > 0) THEN
3762: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3763: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3764:
3765: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3766: LOOP
3767: -- collect the entire document in the CLOB

Line 3769: SYS.DBMS_LOB.writeappend(l_lob, l_length, l_chunk_tbl(i).xml_chunk);

3765: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3766: LOOP
3767: -- collect the entire document in the CLOB
3768: l_length := LENGTH(l_chunk_tbl(i).xml_chunk);
3769: SYS.DBMS_LOB.writeappend(l_lob, l_length, l_chunk_tbl(i).xml_chunk);
3770: END LOOP;
3771:
3772: -- parse the document for user:attribute3
3773: -- call synch_user_attribute

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

3770: END LOOP;
3771:
3772: -- parse the document for user:attribute3
3773: -- call synch_user_attribute
3774: l_length := SYS.DBMS_LOB.getlength(l_lob);
3775: p := xmlparser.newparser;
3776: xmlparser.parseclob(p, l_lob);
3777: SYS.DBMS_LOB.CLOSE(l_lob);
3778: SYS.DBMS_LOB.freetemporary(l_lob);

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

3773: -- call synch_user_attribute
3774: l_length := SYS.DBMS_LOB.getlength(l_lob);
3775: p := xmlparser.newparser;
3776: xmlparser.parseclob(p, l_lob);
3777: SYS.DBMS_LOB.CLOSE(l_lob);
3778: SYS.DBMS_LOB.freetemporary(l_lob);
3779: doc := xmlparser.getdocument(p);
3780: nl := xmldom.getelementsbytagname(doc, '*');
3781:

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

3774: l_length := SYS.DBMS_LOB.getlength(l_lob);
3775: p := xmlparser.newparser;
3776: xmlparser.parseclob(p, l_lob);
3777: SYS.DBMS_LOB.CLOSE(l_lob);
3778: SYS.DBMS_LOB.freetemporary(l_lob);
3779: doc := xmlparser.getdocument(p);
3780: nl := xmldom.getelementsbytagname(doc, '*');
3781:
3782: IF (p_document_type IS NULL )THEN

Line 3813: SYS.DBMS_LOB.createtemporary(l_lob_temp, TRUE, DBMS_LOB.SESSION);

3809: END IF;
3810: END LOOP;
3811: END IF;
3812: -- Break the document to insert into the cz_jrad_chunks
3813: SYS.DBMS_LOB.createtemporary(l_lob_temp, TRUE, DBMS_LOB.SESSION);
3814: SYS.DBMS_LOB.OPEN(l_lob_temp, DBMS_LOB.lob_readwrite);
3815: xmldom.writetoclob(doc, l_lob_temp);
3816:
3817: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST

Line 3814: SYS.DBMS_LOB.OPEN(l_lob_temp, DBMS_LOB.lob_readwrite);

3810: END LOOP;
3811: END IF;
3812: -- Break the document to insert into the cz_jrad_chunks
3813: SYS.DBMS_LOB.createtemporary(l_lob_temp, TRUE, DBMS_LOB.SESSION);
3814: SYS.DBMS_LOB.OPEN(l_lob_temp, DBMS_LOB.lob_readwrite);
3815: xmldom.writetoclob(doc, l_lob_temp);
3816:
3817: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3818: LOOP

Line 3819: SYS.DBMS_LOB.READ(l_lob_temp, amt, l_offset, l_buffer);

3815: xmldom.writetoclob(doc, l_lob_temp);
3816:
3817: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3818: LOOP
3819: SYS.DBMS_LOB.READ(l_lob_temp, amt, l_offset, l_buffer);
3820: l_chunk_tbl(i).xml_chunk := l_buffer;
3821: l_offset := l_offset + amt;
3822: l_buffer := NULL;
3823: END LOOP;

Line 3825: SYS.DBMS_LOB.CLOSE(l_lob_temp);

3821: l_offset := l_offset + amt;
3822: l_buffer := NULL;
3823: END LOOP;
3824:
3825: SYS.DBMS_LOB.CLOSE(l_lob_temp);
3826: SYS.DBMS_LOB.freetemporary(l_lob_temp);
3827: xmlparser.freeparser(p);
3828: xmldom.freeDocument(doc);
3829: END IF;

Line 3826: SYS.DBMS_LOB.freetemporary(l_lob_temp);

3822: l_buffer := NULL;
3823: END LOOP;
3824:
3825: SYS.DBMS_LOB.CLOSE(l_lob_temp);
3826: SYS.DBMS_LOB.freetemporary(l_lob_temp);
3827: xmlparser.freeparser(p);
3828: xmldom.freeDocument(doc);
3829: END IF;
3830: END IF;

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

3922: FETCH jrad_docs_cur
3923: INTO l_jrad_doc;
3924:
3925: EXIT WHEN jrad_docs_cur%NOTFOUND;
3926: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3927: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3928:
3929: OPEN jrad_chunks_cur(l_jrad_doc);
3930:

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

3923: INTO l_jrad_doc;
3924:
3925: EXIT WHEN jrad_docs_cur%NOTFOUND;
3926: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3927: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3928:
3929: OPEN jrad_chunks_cur(l_jrad_doc);
3930:
3931: LOOP

Line 3950: SYS.DBMS_LOB.writeappend(l_lob, l_length, l_chunk);

3946: -- the replacement is done before this gets called (e.g., when collect_chunks)
3947: -- and the two templ arrays are empty anyway
3948: -- replace_extends(l_chunk);
3949: l_length := LENGTH(l_chunk);
3950: SYS.DBMS_LOB.writeappend(l_lob, l_length, l_chunk);
3951: END IF;
3952: END LOOP;
3953:
3954: CLOSE jrad_chunks_cur;

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

3952: END LOOP;
3953:
3954: CLOSE jrad_chunks_cur;
3955:
3956: l_length := SYS.DBMS_LOB.getlength(l_lob);
3957: p := xmlparser.newparser;
3958: xmlparser.parseclob(p, l_lob);
3959: doc := xmlparser.getdocument(p);
3960: SYS.DBMS_LOB.CLOSE(l_lob);

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

3956: l_length := SYS.DBMS_LOB.getlength(l_lob);
3957: p := xmlparser.newparser;
3958: xmlparser.parseclob(p, l_lob);
3959: doc := xmlparser.getdocument(p);
3960: SYS.DBMS_LOB.CLOSE(l_lob);
3961: SYS.DBMS_LOB.freetemporary(l_lob);
3962: l_doc := jdr_docbuilder.createdocument(l_jrad_doc);
3963: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
3964:

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

3957: p := xmlparser.newparser;
3958: xmlparser.parseclob(p, l_lob);
3959: doc := xmlparser.getdocument(p);
3960: SYS.DBMS_LOB.CLOSE(l_lob);
3961: SYS.DBMS_LOB.freetemporary(l_lob);
3962: l_doc := jdr_docbuilder.createdocument(l_jrad_doc);
3963: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
3964:
3965: IF (g_toplevel_attr_tbl.COUNT > 0)

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

4293: --JRAD documents was returning a 0, and UI copy procedure was failing.
4294: --Retaining this parameter as LONG and changing the places where we were
4295: --calling the procedure to LONG so we be consistent everywhere
4296: --See Bug 4930937 for symptoms of the bug.
4297: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
4298: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
4299: firstchunk := jdr_utils.exportdocument(p_old_document_name, l_exportfinished);
4300: replace_extends(firstchunk);
4301: handle_ancestorNode(p_old_document_name, p_new_document_name, firstchunk);

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

4294: --Retaining this parameter as LONG and changing the places where we were
4295: --calling the procedure to LONG so we be consistent everywhere
4296: --See Bug 4930937 for symptoms of the bug.
4297: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
4298: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
4299: firstchunk := jdr_utils.exportdocument(p_old_document_name, l_exportfinished);
4300: replace_extends(firstchunk);
4301: handle_ancestorNode(p_old_document_name, p_new_document_name, firstchunk);
4302:

Line 4309: SYS.DBMS_LOB.writeappend(l_lob, LENGTH(firstchunk), firstchunk);

4305: RAISE document_is_null;
4306: END IF;
4307:
4308: BEGIN
4309: SYS.DBMS_LOB.writeappend(l_lob, LENGTH(firstchunk), firstchunk);
4310: EXCEPTION
4311: WHEN OTHERS
4312: THEN
4313: NULL; ---- for negative index to be ignored

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

4324: EXIT WHEN l_buffer IS NULL;
4325: replace_extends(l_buffer);
4326: handle_ancestorNode(p_old_document_name, p_new_document_name, l_buffer);
4327: l_length := LENGTH(l_buffer);
4328: SYS.DBMS_LOB.writeappend(l_lob, l_length, l_buffer);
4329: END LOOP;
4330:
4331: l_length := SYS.DBMS_LOB.getlength(l_lob);
4332: p := xmlparser.newparser;

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

4327: l_length := LENGTH(l_buffer);
4328: SYS.DBMS_LOB.writeappend(l_lob, l_length, l_buffer);
4329: END LOOP;
4330:
4331: l_length := SYS.DBMS_LOB.getlength(l_lob);
4332: p := xmlparser.newparser;
4333: xmlparser.parseclob(p, l_lob);
4334: doc := xmlparser.getdocument(p);
4335: SYS.DBMS_LOB.CLOSE(l_lob);

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

4331: l_length := SYS.DBMS_LOB.getlength(l_lob);
4332: p := xmlparser.newparser;
4333: xmlparser.parseclob(p, l_lob);
4334: doc := xmlparser.getdocument(p);
4335: SYS.DBMS_LOB.CLOSE(l_lob);
4336: SYS.DBMS_LOB.freetemporary(l_lob);
4337: l_doc := jdr_docbuilder.createdocument(p_new_document_name);
4338: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
4339:

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

4332: p := xmlparser.newparser;
4333: xmlparser.parseclob(p, l_lob);
4334: doc := xmlparser.getdocument(p);
4335: SYS.DBMS_LOB.CLOSE(l_lob);
4336: SYS.DBMS_LOB.freetemporary(l_lob);
4337: l_doc := jdr_docbuilder.createdocument(p_new_document_name);
4338: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
4339:
4340: IF (g_toplevel_attr_tbl.COUNT > 0)