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 3142: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);

3138: END LOOP;
3139:
3140: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
3141: IF (l_chunk_tbl.COUNT > 0) THEN
3142: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3143: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3144:
3145: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3146: LOOP

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

3139:
3140: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
3141: IF (l_chunk_tbl.COUNT > 0) THEN
3142: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3143: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3144:
3145: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3146: LOOP
3147: -- collect the entire document in the CLOB

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

3145: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3146: LOOP
3147: -- collect the entire document in the CLOB
3148: l_length := LENGTH(l_chunk_tbl(i).xml_chunk);
3149: SYS.DBMS_LOB.writeappend(l_lob, l_length, l_chunk_tbl(i).xml_chunk);
3150: END LOOP;
3151:
3152: -- parse the document for user:attribute3
3153: -- call synch_user_attribute

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

3150: END LOOP;
3151:
3152: -- parse the document for user:attribute3
3153: -- call synch_user_attribute
3154: l_length := SYS.DBMS_LOB.getlength(l_lob);
3155: p := xmlparser.newparser;
3156: xmlparser.parseclob(p, l_lob);
3157: SYS.DBMS_LOB.CLOSE(l_lob);
3158: SYS.DBMS_LOB.freetemporary(l_lob);

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

3153: -- call synch_user_attribute
3154: l_length := SYS.DBMS_LOB.getlength(l_lob);
3155: p := xmlparser.newparser;
3156: xmlparser.parseclob(p, l_lob);
3157: SYS.DBMS_LOB.CLOSE(l_lob);
3158: SYS.DBMS_LOB.freetemporary(l_lob);
3159: doc := xmlparser.getdocument(p);
3160: nl := xmldom.getelementsbytagname(doc, '*');
3161:

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

3154: l_length := SYS.DBMS_LOB.getlength(l_lob);
3155: p := xmlparser.newparser;
3156: xmlparser.parseclob(p, l_lob);
3157: SYS.DBMS_LOB.CLOSE(l_lob);
3158: SYS.DBMS_LOB.freetemporary(l_lob);
3159: doc := xmlparser.getdocument(p);
3160: nl := xmldom.getelementsbytagname(doc, '*');
3161:
3162: IF (p_document_type IS NULL )THEN

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

3189: END IF;
3190: END LOOP;
3191: END IF;
3192: -- Break the document to insert into the cz_jrad_chunks
3193: SYS.DBMS_LOB.createtemporary(l_lob_temp, TRUE, DBMS_LOB.SESSION);
3194: SYS.DBMS_LOB.OPEN(l_lob_temp, DBMS_LOB.lob_readwrite);
3195: xmldom.writetoclob(doc, l_lob_temp);
3196:
3197: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST

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

3190: END LOOP;
3191: END IF;
3192: -- Break the document to insert into the cz_jrad_chunks
3193: SYS.DBMS_LOB.createtemporary(l_lob_temp, TRUE, DBMS_LOB.SESSION);
3194: SYS.DBMS_LOB.OPEN(l_lob_temp, DBMS_LOB.lob_readwrite);
3195: xmldom.writetoclob(doc, l_lob_temp);
3196:
3197: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3198: LOOP

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

3195: xmldom.writetoclob(doc, l_lob_temp);
3196:
3197: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3198: LOOP
3199: SYS.DBMS_LOB.READ(l_lob_temp, amt, l_offset, l_buffer);
3200: l_chunk_tbl(i).xml_chunk := l_buffer;
3201: l_offset := l_offset + amt;
3202: l_buffer := NULL;
3203: END LOOP;

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

3201: l_offset := l_offset + amt;
3202: l_buffer := NULL;
3203: END LOOP;
3204:
3205: SYS.DBMS_LOB.CLOSE(l_lob_temp);
3206: SYS.DBMS_LOB.freetemporary(l_lob_temp);
3207: xmlparser.freeparser(p);
3208: xmldom.freeDocument(doc);
3209: END IF;

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

3202: l_buffer := NULL;
3203: END LOOP;
3204:
3205: SYS.DBMS_LOB.CLOSE(l_lob_temp);
3206: SYS.DBMS_LOB.freetemporary(l_lob_temp);
3207: xmlparser.freeparser(p);
3208: xmldom.freeDocument(doc);
3209: END IF;
3210: END IF;

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

3296: FETCH jrad_docs_cur
3297: INTO l_jrad_doc;
3298:
3299: EXIT WHEN jrad_docs_cur%NOTFOUND;
3300: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3301: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3302:
3303: OPEN jrad_chunks_cur(l_jrad_doc);
3304:

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

3297: INTO l_jrad_doc;
3298:
3299: EXIT WHEN jrad_docs_cur%NOTFOUND;
3300: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3301: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3302:
3303: OPEN jrad_chunks_cur(l_jrad_doc);
3304:
3305: LOOP

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

3320: -- the replacement is done before this gets called (e.g., when collect_chunks)
3321: -- and the two templ arrays are empty anyway
3322: -- replace_extends(l_chunk);
3323: l_length := LENGTH(l_chunk);
3324: SYS.DBMS_LOB.writeappend(l_lob, l_length, l_chunk);
3325: END IF;
3326: END LOOP;
3327:
3328: CLOSE jrad_chunks_cur;

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

3326: END LOOP;
3327:
3328: CLOSE jrad_chunks_cur;
3329:
3330: l_length := SYS.DBMS_LOB.getlength(l_lob);
3331: p := xmlparser.newparser;
3332: xmlparser.parseclob(p, l_lob);
3333: doc := xmlparser.getdocument(p);
3334: SYS.DBMS_LOB.CLOSE(l_lob);

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

3330: l_length := SYS.DBMS_LOB.getlength(l_lob);
3331: p := xmlparser.newparser;
3332: xmlparser.parseclob(p, l_lob);
3333: doc := xmlparser.getdocument(p);
3334: SYS.DBMS_LOB.CLOSE(l_lob);
3335: SYS.DBMS_LOB.freetemporary(l_lob);
3336: l_doc := jdr_docbuilder.createdocument(l_jrad_doc);
3337: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
3338:

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

3331: p := xmlparser.newparser;
3332: xmlparser.parseclob(p, l_lob);
3333: doc := xmlparser.getdocument(p);
3334: SYS.DBMS_LOB.CLOSE(l_lob);
3335: SYS.DBMS_LOB.freetemporary(l_lob);
3336: l_doc := jdr_docbuilder.createdocument(l_jrad_doc);
3337: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
3338:
3339: IF (g_toplevel_attr_tbl.COUNT > 0)

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

3655: --JRAD documents was returning a 0, and UI copy procedure was failing.
3656: --Retaining this parameter as LONG and changing the places where we were
3657: --calling the procedure to LONG so we be consistent everywhere
3658: --See Bug 4930937 for symptoms of the bug.
3659: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3660: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3661: firstchunk := jdr_utils.exportdocument(p_old_document_name, l_exportfinished);
3662: replace_extends(firstchunk);
3663: handle_ancestorNode(p_old_document_name, p_new_document_name, firstchunk);

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

3656: --Retaining this parameter as LONG and changing the places where we were
3657: --calling the procedure to LONG so we be consistent everywhere
3658: --See Bug 4930937 for symptoms of the bug.
3659: SYS.DBMS_LOB.createtemporary(l_lob, TRUE, DBMS_LOB.SESSION);
3660: SYS.DBMS_LOB.OPEN(l_lob, DBMS_LOB.lob_readwrite);
3661: firstchunk := jdr_utils.exportdocument(p_old_document_name, l_exportfinished);
3662: replace_extends(firstchunk);
3663: handle_ancestorNode(p_old_document_name, p_new_document_name, firstchunk);
3664:

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

3667: RAISE document_is_null;
3668: END IF;
3669:
3670: BEGIN
3671: SYS.DBMS_LOB.writeappend(l_lob, LENGTH(firstchunk), firstchunk);
3672: EXCEPTION
3673: WHEN OTHERS
3674: THEN
3675: NULL; ---- for negative index to be ignored

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

3686: EXIT WHEN l_buffer IS NULL;
3687: replace_extends(l_buffer);
3688: handle_ancestorNode(p_old_document_name, p_new_document_name, l_buffer);
3689: l_length := LENGTH(l_buffer);
3690: SYS.DBMS_LOB.writeappend(l_lob, l_length, l_buffer);
3691: END LOOP;
3692:
3693: l_length := SYS.DBMS_LOB.getlength(l_lob);
3694: p := xmlparser.newparser;

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

3689: l_length := LENGTH(l_buffer);
3690: SYS.DBMS_LOB.writeappend(l_lob, l_length, l_buffer);
3691: END LOOP;
3692:
3693: l_length := SYS.DBMS_LOB.getlength(l_lob);
3694: p := xmlparser.newparser;
3695: xmlparser.parseclob(p, l_lob);
3696: doc := xmlparser.getdocument(p);
3697: SYS.DBMS_LOB.CLOSE(l_lob);

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

3693: l_length := SYS.DBMS_LOB.getlength(l_lob);
3694: p := xmlparser.newparser;
3695: xmlparser.parseclob(p, l_lob);
3696: doc := xmlparser.getdocument(p);
3697: SYS.DBMS_LOB.CLOSE(l_lob);
3698: SYS.DBMS_LOB.freetemporary(l_lob);
3699: l_doc := jdr_docbuilder.createdocument(p_new_document_name);
3700: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
3701:

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

3694: p := xmlparser.newparser;
3695: xmlparser.parseclob(p, l_lob);
3696: doc := xmlparser.getdocument(p);
3697: SYS.DBMS_LOB.CLOSE(l_lob);
3698: SYS.DBMS_LOB.freetemporary(l_lob);
3699: l_doc := jdr_docbuilder.createdocument(p_new_document_name);
3700: top_node := xmldom.makenode(xmldom.getdocumentelement(doc));
3701:
3702: IF (g_toplevel_attr_tbl.COUNT > 0)