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_MIGRATE dependencies on CZ_JRAD_CHUNKS

Line 1878: 'CZ_ITEM_MASTERS', 'CZ_ITEM_PROPERTY_VALUES', 'CZ_ITEM_TYPE_PROPERTIES', 'CZ_JRAD_CHUNKS', 'CZ_LCE_CLOBS',

1874: 'CZ_CONFIG_EXT_ATTRIBUTES', 'CZ_CONFIG_HDRS', 'CZ_CONFIG_INPUTS', 'CZ_CONFIG_MESSAGES', 'CZ_CONFIG_USAGES',
1875: 'CZ_CONTACTS', 'CZ_CUSTOMER_END_USERS', 'CZ_DB_SIZES', 'CZ_DES_CHART_CELLS', 'CZ_DES_CHART_COLUMNS',
1876: 'CZ_DES_CHART_FEATURES', 'CZ_DEVL_PRJ_USER_GROUPS', 'CZ_DRILL_DOWN_ITEMS', 'CZ_EFFECTIVITY_SETS', 'CZ_EXPRESSIONS',
1877: 'CZ_FILTER_SETS', 'CZ_FUNC_COMP_REFS', 'CZ_FUNC_COMP_SPECS', 'CZ_GRID_CELLS', 'CZ_GRID_COLS', 'CZ_GRID_DEFS',
1878: 'CZ_ITEM_MASTERS', 'CZ_ITEM_PROPERTY_VALUES', 'CZ_ITEM_TYPE_PROPERTIES', 'CZ_JRAD_CHUNKS', 'CZ_LCE_CLOBS',
1879: 'CZ_LCE_HEADERS', 'CZ_FCE_FILES','CZ_LCE_LINES', 'CZ_LCE_LOAD_SPECS', 'CZ_LCE_OPERANDS', 'CZ_LCE_TEXTS', 'CZ_LOCALES',
1880: 'CZ_LOCK_HISTORY', 'CZ_MODEL_PUBLICATIONS', 'CZ_MODEL_REF_EXPLS', 'CZ_OPP_HDR_CONTACTS', 'CZ_PB_CLIENT_APPS',
1881: 'CZ_PB_LANGUAGES', 'CZ_PB_MODEL_EXPORTS', 'CZ_PB_TEMP_IDS', 'CZ_POPULATOR_MAPS', 'CZ_PRICES', 'CZ_PROPERTIES',
1882: 'CZ_PROPOSAL_HDRS', 'CZ_PROP_QUOTE_HDRS', 'CZ_PSNODE_PROPCOMPAT_GENS', 'CZ_PS_NODES', 'CZ_PS_PROP_VALS',

Line 2003: insert into cz_jrad_chunks(jrad_doc,seq_nbr,xml_chunk,publication_id)

1999:
2000: IF (l_chunk_tbl.COUNT > 0) THEN
2001: FOR I IN 1..l_seq_nbr
2002: LOOP
2003: insert into cz_jrad_chunks(jrad_doc,seq_nbr,xml_chunk,publication_id)
2004: values (l_chunk_tbl(i).jrad_doc,l_chunk_tbl(i).seq_nbr,l_chunk_tbl(i).xml_chunk,0);
2005: END LOOP;
2006: END IF;
2007: commit;

Line 2039: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;

2035: x_msg_data OUT NOCOPY VARCHAR2)
2036: IS
2037: l_link_name cz_servers.fndnam_link_name%TYPE;
2038: l_ref_cursor ref_cursor;
2039: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;
2040: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2041: l_XML_CHUNK VARCHAR2(32767);
2042: l_template_id cz_ui_templates.template_id%TYPE := NULL;
2043: BEGIN

Line 2040: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;

2036: IS
2037: l_link_name cz_servers.fndnam_link_name%TYPE;
2038: l_ref_cursor ref_cursor;
2039: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;
2040: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2041: l_XML_CHUNK VARCHAR2(32767);
2042: l_template_id cz_ui_templates.template_id%TYPE := NULL;
2043: BEGIN
2044: ----initialize link name

Line 2051: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';

2047: END IF;
2048:
2049: ----delete from temp table on target and source
2050: EXECUTE IMMEDIATE
2051: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2052: delete from cz_jrad_chunks; commit;
2053:
2054: ----get XML chunks from the target to be imported
2055: EXECUTE IMMEDIATE 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'

Line 2052: delete from cz_jrad_chunks; commit;

2048:
2049: ----delete from temp table on target and source
2050: EXECUTE IMMEDIATE
2051: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2052: delete from cz_jrad_chunks; commit;
2053:
2054: ----get XML chunks from the target to be imported
2055: EXECUTE IMMEDIATE 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'
2056: USING p_ui_def_id,l_template_id;

Line 2058: ----insert XML chunks from the target to the cz_jrad_chunks table on the source

2054: ----get XML chunks from the target to be imported
2055: EXECUTE IMMEDIATE 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'
2056: USING p_ui_def_id,l_template_id;
2057:
2058: ----insert XML chunks from the target to the cz_jrad_chunks table on the source
2059: OPEN l_ref_cursor FOR 'SELECT JRAD_DOC,SEQ_NBR,XML_CHUNK
2060: FROM cz_jrad_chunks'||l_link_name;
2061: LOOP
2062: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;

Line 2060: FROM cz_jrad_chunks'||l_link_name;

2056: USING p_ui_def_id,l_template_id;
2057:
2058: ----insert XML chunks from the target to the cz_jrad_chunks table on the source
2059: OPEN l_ref_cursor FOR 'SELECT JRAD_DOC,SEQ_NBR,XML_CHUNK
2060: FROM cz_jrad_chunks'||l_link_name;
2061: LOOP
2062: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;
2063: EXIT WHEN l_ref_cursor%NOTFOUND;
2064: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK,PUBLICATION_ID)

Line 2064: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK,PUBLICATION_ID)

2060: FROM cz_jrad_chunks'||l_link_name;
2061: LOOP
2062: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;
2063: EXIT WHEN l_ref_cursor%NOTFOUND;
2064: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK,PUBLICATION_ID)
2065: values (l_jrad_doc,l_seq_nbr,l_XML_CHUNK,0);
2066: END LOOP;
2067: COMMIT;
2068: CLOSE l_ref_cursor;

Line 2075: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';

2071: cz_pb_mgr.insert_jrad_docs(0);
2072:
2073: ----delete from temp table on target and source
2074: EXECUTE IMMEDIATE
2075: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2076: delete from cz_jrad_chunks; commit;
2077: EXCEPTION
2078: WHEN NO_DATA_FOUND THEN
2079: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2076: delete from cz_jrad_chunks; commit;

2072:
2073: ----delete from temp table on target and source
2074: EXECUTE IMMEDIATE
2075: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2076: delete from cz_jrad_chunks; commit;
2077: EXCEPTION
2078: WHEN NO_DATA_FOUND THEN
2079: x_return_status := FND_API.G_RET_STS_ERROR;
2080: x_msg_count := 1;

Line 2111: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;

2107: l_ui_def_id_tbl t_ref;
2108: l_template_id_tbl t_ref;
2109: l_link_name cz_servers.fndnam_link_name%TYPE;
2110: l_ref_cursor ref_cursor;
2111: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;
2112: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2113: l_XML_CHUNK VARCHAR2(32767);
2114:
2115: BEGIN

Line 2112: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;

2108: l_template_id_tbl t_ref;
2109: l_link_name cz_servers.fndnam_link_name%TYPE;
2110: l_ref_cursor ref_cursor;
2111: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;
2112: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2113: l_XML_CHUNK VARCHAR2(32767);
2114:
2115: BEGIN
2116: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2138: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';

2134: FOR I IN l_ui_def_id_tbl.FIRST..l_ui_def_id_tbl.LAST
2135: LOOP
2136: ----delete from temp table on target and source
2137: EXECUTE IMMEDIATE
2138: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2139: delete from cz_jrad_chunks; commit;
2140:
2141: ----get XML chunks from the target to be imported
2142: EXECUTE IMMEDIATE

Line 2139: delete from cz_jrad_chunks; commit;

2135: LOOP
2136: ----delete from temp table on target and source
2137: EXECUTE IMMEDIATE
2138: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2139: delete from cz_jrad_chunks; commit;
2140:
2141: ----get XML chunks from the target to be imported
2142: EXECUTE IMMEDIATE
2143: 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'

Line 2146: ----insert XML chunks from the target to the cz_jrad_chunks table on the source

2142: EXECUTE IMMEDIATE
2143: 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'
2144: USING l_ui_def_id_tbl(i),l_template_id_tbl(i);
2145:
2146: ----insert XML chunks from the target to the cz_jrad_chunks table on the source
2147: OPEN l_ref_cursor FOR 'SELECT JRAD_DOC,SEQ_NBR,XML_CHUNK
2148: FROM cz_jrad_chunks'||l_link_name;
2149: LOOP
2150: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;

Line 2148: FROM cz_jrad_chunks'||l_link_name;

2144: USING l_ui_def_id_tbl(i),l_template_id_tbl(i);
2145:
2146: ----insert XML chunks from the target to the cz_jrad_chunks table on the source
2147: OPEN l_ref_cursor FOR 'SELECT JRAD_DOC,SEQ_NBR,XML_CHUNK
2148: FROM cz_jrad_chunks'||l_link_name;
2149: LOOP
2150: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;
2151: EXIT WHEN l_ref_cursor%NOTFOUND;
2152: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK,PUBLICATION_ID)

Line 2152: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK,PUBLICATION_ID)

2148: FROM cz_jrad_chunks'||l_link_name;
2149: LOOP
2150: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;
2151: EXIT WHEN l_ref_cursor%NOTFOUND;
2152: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK,PUBLICATION_ID)
2153: values (l_jrad_doc,l_seq_nbr,l_XML_CHUNK,0);
2154: END LOOP;
2155: COMMIT;
2156: CLOSE l_ref_cursor;

Line 2163: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';

2159: cz_pb_mgr.insert_jrad_docs(0);
2160:
2161: ----delete from temp table on target and source
2162: EXECUTE IMMEDIATE
2163: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2164: delete from cz_jrad_chunks; commit;
2165: END LOOP;
2166: END IF;
2167: EXCEPTION

Line 2164: delete from cz_jrad_chunks; commit;

2160:
2161: ----delete from temp table on target and source
2162: EXECUTE IMMEDIATE
2163: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2164: delete from cz_jrad_chunks; commit;
2165: END LOOP;
2166: END IF;
2167: EXCEPTION
2168: WHEN NO_DATA_FOUND THEN