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

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

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

Line 1999: insert into cz_jrad_chunks(jrad_doc,seq_nbr,xml_chunk)

1995:
1996: IF (l_chunk_tbl.COUNT > 0) THEN
1997: FOR I IN 1..l_seq_nbr
1998: LOOP
1999: insert into cz_jrad_chunks(jrad_doc,seq_nbr,xml_chunk)
2000: values (l_chunk_tbl(i).jrad_doc,l_chunk_tbl(i).seq_nbr,l_chunk_tbl(i).xml_chunk);
2001: END LOOP;
2002: END IF;
2003: commit;

Line 2027: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;

2023: x_msg_data OUT NOCOPY VARCHAR2)
2024: IS
2025: l_link_name cz_servers.fndnam_link_name%TYPE;
2026: l_ref_cursor ref_cursor;
2027: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;
2028: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2029: l_XML_CHUNK VARCHAR2(32767);
2030: l_template_id cz_ui_templates.template_id%TYPE := NULL;
2031: BEGIN

Line 2028: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;

2024: IS
2025: l_link_name cz_servers.fndnam_link_name%TYPE;
2026: l_ref_cursor ref_cursor;
2027: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;
2028: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2029: l_XML_CHUNK VARCHAR2(32767);
2030: l_template_id cz_ui_templates.template_id%TYPE := NULL;
2031: BEGIN
2032: ----initialize link name

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

2035: END IF;
2036:
2037: ----delete from temp table on target and source
2038: EXECUTE IMMEDIATE
2039: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2040: delete from cz_jrad_chunks; commit;
2041:
2042: ----get XML chunks from the target to be imported
2043: EXECUTE IMMEDIATE 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'

Line 2040: delete from cz_jrad_chunks; commit;

2036:
2037: ----delete from temp table on target and source
2038: EXECUTE IMMEDIATE
2039: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2040: delete from cz_jrad_chunks; commit;
2041:
2042: ----get XML chunks from the target to be imported
2043: EXECUTE IMMEDIATE 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'
2044: USING p_ui_def_id,l_template_id;

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

2042: ----get XML chunks from the target to be imported
2043: EXECUTE IMMEDIATE 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'
2044: USING p_ui_def_id,l_template_id;
2045:
2046: ----insert XML chunks from the target to the cz_jrad_chunks table on the source
2047: OPEN l_ref_cursor FOR 'SELECT JRAD_DOC,SEQ_NBR,XML_CHUNK
2048: FROM cz_jrad_chunks'||l_link_name;
2049: LOOP
2050: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;

Line 2048: FROM cz_jrad_chunks'||l_link_name;

2044: USING p_ui_def_id,l_template_id;
2045:
2046: ----insert XML chunks from the target to the cz_jrad_chunks table on the source
2047: OPEN l_ref_cursor FOR 'SELECT JRAD_DOC,SEQ_NBR,XML_CHUNK
2048: FROM cz_jrad_chunks'||l_link_name;
2049: LOOP
2050: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;
2051: EXIT WHEN l_ref_cursor%NOTFOUND;
2052: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK)

Line 2052: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK)

2048: FROM cz_jrad_chunks'||l_link_name;
2049: LOOP
2050: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;
2051: EXIT WHEN l_ref_cursor%NOTFOUND;
2052: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK)
2053: values (l_jrad_doc,l_seq_nbr,l_XML_CHUNK);
2054: END LOOP;
2055: COMMIT;
2056: CLOSE l_ref_cursor;

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

2059: cz_pb_mgr.insert_jrad_docs;
2060:
2061: ----delete from temp table on target and source
2062: EXECUTE IMMEDIATE
2063: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2064: delete from cz_jrad_chunks; commit;
2065: EXCEPTION
2066: WHEN NO_DATA_FOUND THEN
2067: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2064: delete from cz_jrad_chunks; commit;

2060:
2061: ----delete from temp table on target and source
2062: EXECUTE IMMEDIATE
2063: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2064: delete from cz_jrad_chunks; commit;
2065: EXCEPTION
2066: WHEN NO_DATA_FOUND THEN
2067: x_return_status := FND_API.G_RET_STS_ERROR;
2068: x_msg_count := 1;

Line 2099: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;

2095: l_ui_def_id_tbl t_ref;
2096: l_template_id_tbl t_ref;
2097: l_link_name cz_servers.fndnam_link_name%TYPE;
2098: l_ref_cursor ref_cursor;
2099: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;
2100: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2101: l_XML_CHUNK VARCHAR2(32767);
2102:
2103: BEGIN

Line 2100: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;

2096: l_template_id_tbl t_ref;
2097: l_link_name cz_servers.fndnam_link_name%TYPE;
2098: l_ref_cursor ref_cursor;
2099: l_jrad_doc cz_jrad_chunks.jrad_doc%TYPE;
2100: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2101: l_XML_CHUNK VARCHAR2(32767);
2102:
2103: BEGIN
2104: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2122: FOR I IN l_ui_def_id_tbl.FIRST..l_ui_def_id_tbl.LAST
2123: LOOP
2124: ----delete from temp table on target and source
2125: EXECUTE IMMEDIATE
2126: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2127: delete from cz_jrad_chunks; commit;
2128:
2129: ----get XML chunks from the target to be imported
2130: EXECUTE IMMEDIATE

Line 2127: delete from cz_jrad_chunks; commit;

2123: LOOP
2124: ----delete from temp table on target and source
2125: EXECUTE IMMEDIATE
2126: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2127: delete from cz_jrad_chunks; commit;
2128:
2129: ----get XML chunks from the target to be imported
2130: EXECUTE IMMEDIATE
2131: 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'

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

2130: EXECUTE IMMEDIATE
2131: 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'
2132: USING l_ui_def_id_tbl(i),l_template_id_tbl(i);
2133:
2134: ----insert XML chunks from the target to the cz_jrad_chunks table on the source
2135: OPEN l_ref_cursor FOR 'SELECT JRAD_DOC,SEQ_NBR,XML_CHUNK
2136: FROM cz_jrad_chunks'||l_link_name;
2137: LOOP
2138: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;

Line 2136: FROM cz_jrad_chunks'||l_link_name;

2132: USING l_ui_def_id_tbl(i),l_template_id_tbl(i);
2133:
2134: ----insert XML chunks from the target to the cz_jrad_chunks table on the source
2135: OPEN l_ref_cursor FOR 'SELECT JRAD_DOC,SEQ_NBR,XML_CHUNK
2136: FROM cz_jrad_chunks'||l_link_name;
2137: LOOP
2138: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;
2139: EXIT WHEN l_ref_cursor%NOTFOUND;
2140: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK)

Line 2140: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK)

2136: FROM cz_jrad_chunks'||l_link_name;
2137: LOOP
2138: FETCH l_ref_cursor INTO l_jrad_doc,l_seq_nbr,l_XML_CHUNK;
2139: EXIT WHEN l_ref_cursor%NOTFOUND;
2140: insert into cz_jrad_chunks (JRAD_DOC,SEQ_NBR,XML_CHUNK)
2141: values (l_jrad_doc,l_seq_nbr,l_XML_CHUNK);
2142: END LOOP;
2143: COMMIT;
2144: CLOSE l_ref_cursor;

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

2147: cz_pb_mgr.insert_jrad_docs;
2148:
2149: ----delete from temp table on target and source
2150: EXECUTE IMMEDIATE
2151: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2152: delete from cz_jrad_chunks; commit;
2153: END LOOP;
2154: END IF;
2155: EXCEPTION

Line 2152: delete from cz_jrad_chunks; commit;

2148:
2149: ----delete from temp table on target and source
2150: EXECUTE IMMEDIATE
2151: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2152: delete from cz_jrad_chunks; commit;
2153: END LOOP;
2154: END IF;
2155: EXCEPTION
2156: WHEN NO_DATA_FOUND THEN