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 CZ_JRAD_CHUNKS

Line 3035: EXECUTE IMMEDIATE 'insert into cz_jrad_chunks' || p_link_name || ' (jrad_doc,seq_nbr,xml_chunk)' || ' ' || 'values (:1,:2,:3)'

3031:
3032: IF (l_chunk_tbl.COUNT > 0) THEN
3033: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3034: LOOP
3035: EXECUTE IMMEDIATE 'insert into cz_jrad_chunks' || p_link_name || ' (jrad_doc,seq_nbr,xml_chunk)' || ' ' || 'values (:1,:2,:3)'
3036: USING l_chunk_tbl(i).jrad_doc, l_chunk_tbl(i).seq_nbr, l_chunk_tbl(i).xml_chunk;
3037: END LOOP;
3038: END IF;
3039:

Line 3192: -- Break the document to insert into the cz_jrad_chunks

3188: l_value:=NULL;
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:

Line 3217: EXECUTE IMMEDIATE 'insert into cz_jrad_chunks' || p_link_name || ' (jrad_doc,seq_nbr,xml_chunk)' || ' ' || 'values (:1,:2,:3)'

3213: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3214: LOOP
3215: replace_extends(l_chunk_tbl(i).xml_chunk);
3216: handle_ancestorNode(p_document_name, p_new_document_name, l_chunk_tbl(i).xml_chunk);
3217: EXECUTE IMMEDIATE 'insert into cz_jrad_chunks' || p_link_name || ' (jrad_doc,seq_nbr,xml_chunk)' || ' ' || 'values (:1,:2,:3)'
3218: USING l_chunk_tbl(i).jrad_doc, l_chunk_tbl(i).seq_nbr, l_chunk_tbl(i).xml_chunk;
3219: END LOOP;
3220: END IF;
3221:

Line 3245: FROM cz_jrad_chunks;

3241:
3242: CURSOR jrad_docs_cur
3243: IS
3244: SELECT DISTINCT jrad_doc
3245: FROM cz_jrad_chunks;
3246:
3247: CURSOR jrad_chunks_cur(p_jrad_doc VARCHAR2)
3248: IS
3249: SELECT xml_chunk

Line 3250: FROM cz_jrad_chunks

3246:
3247: CURSOR jrad_chunks_cur(p_jrad_doc VARCHAR2)
3248: IS
3249: SELECT xml_chunk
3250: FROM cz_jrad_chunks
3251: WHERE jrad_doc = p_jrad_doc
3252: ORDER BY seq_nbr;
3253:
3254: l_jrad_doc VARCHAR2(255);

Line 3424: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';

3420: IS
3421: BEGIN
3422: pbdebug := 22025;
3423:
3424: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';
3425:
3426: collect_chunks(p_document_name, p_link_name, x_return_status, x_msg_count, x_msg_data);
3427:
3428: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '; end; ';

Line 3430: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';

3426: collect_chunks(p_document_name, p_link_name, x_return_status, x_msg_count, x_msg_data);
3427:
3428: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '; end; ';
3429:
3430: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';
3431: EXCEPTION
3432: WHEN NO_DATA_FOUND
3433: THEN
3434: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3473: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || l_link_name || '; commit; end; ';

3469: WHERE cz_ui_pages.ui_def_id = p_ui_def_id AND cz_ui_pages.deleted_flag = '0';
3470:
3471: IF (l_jrad_doc_tbl.COUNT > 0)
3472: THEN
3473: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || l_link_name || '; commit; end; ';
3474:
3475: FOR i IN l_jrad_doc_tbl.FIRST .. l_jrad_doc_tbl.LAST
3476: LOOP
3477: collect_chunks(l_jrad_doc_tbl(i), l_link_name, x_return_status, x_msg_count, x_msg_data);

Line 3482: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || l_link_name || '; commit; end; ';

3478: END LOOP;
3479:
3480: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || l_link_name || '; end; ';
3481:
3482: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || l_link_name || '; commit; end; ';
3483: END IF;
3484: EXCEPTION
3485: WHEN link_name_is_null
3486: THEN

Line 3526: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';

3522: AND cz_ui_templates.deleted_flag = '0';
3523:
3524: IF (l_jrad_doc_tbl.COUNT > 0)
3525: THEN
3526: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';
3527:
3528: FOR i IN l_jrad_doc_tbl.FIRST .. l_jrad_doc_tbl.LAST
3529: LOOP
3530: collect_chunks(l_jrad_doc_tbl(i), p_link_name, x_return_status, x_msg_count, x_msg_data);

Line 3535: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';

3531: END LOOP;
3532:
3533: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '; end; ';
3534:
3535: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';
3536: END IF;
3537: EXCEPTION
3538: WHEN OTHERS
3539: THEN

Line 3790: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' commit; end; ';

3786: THEN
3787: RAISE document_is_null;
3788: END IF;
3789:
3790: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' commit; end; ';
3791:
3792: collect_chunks(p_old_document_name, p_new_document_name, p_link_name, l_return_status, l_msg_count, l_msg_data , p_document_type);
3793:
3794: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '; end; ';

Line 3796: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';

3792: collect_chunks(p_old_document_name, p_new_document_name, p_link_name, l_return_status, l_msg_count, l_msg_data , p_document_type);
3793:
3794: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '; end; ';
3795:
3796: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';
3797: ELSE
3798: insert_into_repository(p_old_document_name, p_new_document_name);
3799: END IF;
3800: EXCEPTION