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.

[Home] [Help]

APPS.CZ_PB_MGR dependencies on CZ_JRAD_CHUNKS

Line 3655: EXECUTE IMMEDIATE 'insert into cz_jrad_chunks' || p_link_name || ' (publication_id,jrad_doc,seq_nbr,xml_chunk)' || ' ' || 'values ('||cz_pb_mgr.v_publication_id||',:1,:2,:3)'

3651:
3652: IF (l_chunk_tbl.COUNT > 0) THEN
3653: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3654: LOOP
3655: EXECUTE IMMEDIATE 'insert into cz_jrad_chunks' || p_link_name || ' (publication_id,jrad_doc,seq_nbr,xml_chunk)' || ' ' || 'values ('||cz_pb_mgr.v_publication_id||',:1,:2,:3)'
3656: USING l_chunk_tbl(i).jrad_doc, l_chunk_tbl(i).seq_nbr, l_chunk_tbl(i).xml_chunk;
3657: END LOOP;
3658: END IF;
3659:

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

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

Line 3839: EXECUTE IMMEDIATE 'insert into cz_jrad_chunks' || p_link_name || ' (publication_id,jrad_doc,seq_nbr,xml_chunk)' || ' ' || 'values ('||cz_pb_mgr.v_publication_id||',:1,:2,:3)'

3835: FOR i IN l_chunk_tbl.FIRST .. l_chunk_tbl.LAST
3836: LOOP
3837: replace_extends(l_chunk_tbl(i).xml_chunk);
3838: handle_ancestorNode(p_document_name, p_new_document_name, l_chunk_tbl(i).xml_chunk);
3839: EXECUTE IMMEDIATE 'insert into cz_jrad_chunks' || p_link_name || ' (publication_id,jrad_doc,seq_nbr,xml_chunk)' || ' ' || 'values ('||cz_pb_mgr.v_publication_id||',:1,:2,:3)'
3840: USING l_chunk_tbl(i).jrad_doc, l_chunk_tbl(i).seq_nbr, l_chunk_tbl(i).xml_chunk;
3841: END LOOP;
3842: END IF;
3843:

Line 3869: FROM cz_jrad_chunks

3865:
3866: CURSOR jrad_docs_cur
3867: IS
3868: SELECT DISTINCT jrad_doc
3869: FROM cz_jrad_chunks
3870: WHERE publication_id=p_publication_id;
3871:
3872: CURSOR jrad_chunks_cur(p_jrad_doc VARCHAR2)
3873: IS

Line 3875: FROM cz_jrad_chunks

3871:
3872: CURSOR jrad_chunks_cur(p_jrad_doc VARCHAR2)
3873: IS
3874: SELECT xml_chunk
3875: FROM cz_jrad_chunks
3876: WHERE jrad_doc = p_jrad_doc
3877: AND publication_id=p_publication_id
3878: ORDER BY seq_nbr;
3879:

Line 4055: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';

4051: IS
4052: BEGIN
4053: pbdebug := 22025;
4054:
4055: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';
4056:
4057: collect_chunks(p_document_name, p_link_name, x_return_status, x_msg_count, x_msg_data);
4058:
4059: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '('||cz_pb_mgr.v_publication_id||'); end; ';

Line 4061: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';

4057: collect_chunks(p_document_name, p_link_name, x_return_status, x_msg_count, x_msg_data);
4058:
4059: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '('||cz_pb_mgr.v_publication_id||'); end; ';
4060:
4061: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';
4062:
4063: EXCEPTION
4064: WHEN NO_DATA_FOUND
4065: THEN

Line 4107: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';

4103: WHERE cz_ui_pages.ui_def_id = p_ui_def_id AND cz_ui_pages.deleted_flag = '0';
4104:
4105: IF (l_jrad_doc_tbl.COUNT > 0)
4106: THEN
4107: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';
4108:
4109: FOR i IN l_jrad_doc_tbl.FIRST .. l_jrad_doc_tbl.LAST
4110: LOOP
4111: collect_chunks(l_jrad_doc_tbl(i), l_link_name, x_return_status, x_msg_count, x_msg_data);

Line 4116: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';

4112: END LOOP;
4113:
4114: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '('||cz_pb_mgr.v_publication_id||'); end; ';
4115:
4116: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';
4117: END IF;
4118: EXCEPTION
4119: WHEN link_name_is_null
4120: THEN

Line 4162: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';

4158:
4159: --Bug#10417318:Modified delete for JRAD_CHUNKS as explained earlier.
4160: IF (l_jrad_doc_tbl.COUNT > 0)
4161: THEN
4162: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';
4163:
4164: FOR i IN l_jrad_doc_tbl.FIRST .. l_jrad_doc_tbl.LAST
4165: LOOP
4166: collect_chunks(l_jrad_doc_tbl(i), p_link_name, x_return_status, x_msg_count, x_msg_data);

Line 4171: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';

4167: END LOOP;
4168:
4169: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '('||cz_pb_mgr.v_publication_id||'); end; ';
4170:
4171: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';
4172: END IF;
4173:
4174: EXCEPTION
4175: WHEN OTHERS

Line 4433: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';

4429: THEN
4430: RAISE document_is_null;
4431: END IF;
4432:
4433: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';
4434:
4435: 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);
4436:
4437: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '('||cz_pb_mgr.v_publication_id||'); end; ';

Line 4439: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';

4435: 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);
4436:
4437: EXECUTE IMMEDIATE ' begin cz_pb_mgr.insert_jrad_docs' || p_link_name || '('||cz_pb_mgr.v_publication_id||'); end; ';
4438:
4439: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';
4440: ELSE
4441: insert_into_repository(p_old_document_name, p_new_document_name);
4442: END IF;
4443: