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_UI_TEMPLATES

Line 1852: (80, 'SEQUENCES', '0', 'CZ_UI_TEMPLATES_S', 'CZ_UI_TEMPLATES', 'TEMPLATE_ID', '20');

1848:
1849: INSERT INTO cz_xfr_tables
1850: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1851: VALUES
1852: (80, 'SEQUENCES', '0', 'CZ_UI_TEMPLATES_S', 'CZ_UI_TEMPLATES', 'TEMPLATE_ID', '20');
1853: INSERT INTO cz_xfr_tables
1854: (order_seq, xfr_group, disabled, src_table, dst_table, dst_subschema, filtersyntax)
1855: VALUES
1856: (81, 'SEQUENCES', '0', 'CZ_FCE_FILES_S', 'CZ_FCE_FILES', 'FCE_FILE_ID', '20');

Line 1915: ----p_ui_def_id : ui_def_id of the UI or that in the cz_ui_templates table

1911: ---------------------------
1912: ----This procedure retrieves the XML chunks (from the source instance)
1913: ----of the JRAD docs that are migrated to the target instance
1914: ----params:
1915: ----p_ui_def_id : ui_def_id of the UI or that in the cz_ui_templates table
1916: ----p_template_id : template id in cz_ui_templates
1917: ----If template id is NULL then the JRAD docs of UI pages passed are extracted
1918: ----If both template_id and ui_def_id are passed in then the JRAD docs of UI templates
1919: ----are extracted

Line 1916: ----p_template_id : template id in cz_ui_templates

1912: ----This procedure retrieves the XML chunks (from the source instance)
1913: ----of the JRAD docs that are migrated to the target instance
1914: ----params:
1915: ----p_ui_def_id : ui_def_id of the UI or that in the cz_ui_templates table
1916: ----p_template_id : template id in cz_ui_templates
1917: ----If template id is NULL then the JRAD docs of UI pages passed are extracted
1918: ----If both template_id and ui_def_id are passed in then the JRAD docs of UI templates
1919: ----are extracted
1920: PROCEDURE get_xml_chunks (p_ui_def_id IN NUMBER,

Line 1955: FROM cz_ui_templates

1951: SELECT jrad_doc
1952: BULK
1953: COLLECT
1954: INTO l_jrad_doc_tbl
1955: FROM cz_ui_templates
1956: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
1957: AND cz_ui_templates.template_id = p_template_id
1958: AND cz_ui_templates.seeded_flag = '0'
1959: AND cz_ui_templates.deleted_flag = '0';

Line 1956: WHERE cz_ui_templates.ui_def_id = p_ui_def_id

1952: BULK
1953: COLLECT
1954: INTO l_jrad_doc_tbl
1955: FROM cz_ui_templates
1956: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
1957: AND cz_ui_templates.template_id = p_template_id
1958: AND cz_ui_templates.seeded_flag = '0'
1959: AND cz_ui_templates.deleted_flag = '0';
1960: END IF;

Line 1957: AND cz_ui_templates.template_id = p_template_id

1953: COLLECT
1954: INTO l_jrad_doc_tbl
1955: FROM cz_ui_templates
1956: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
1957: AND cz_ui_templates.template_id = p_template_id
1958: AND cz_ui_templates.seeded_flag = '0'
1959: AND cz_ui_templates.deleted_flag = '0';
1960: END IF;
1961: EXCEPTION

Line 1958: AND cz_ui_templates.seeded_flag = '0'

1954: INTO l_jrad_doc_tbl
1955: FROM cz_ui_templates
1956: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
1957: AND cz_ui_templates.template_id = p_template_id
1958: AND cz_ui_templates.seeded_flag = '0'
1959: AND cz_ui_templates.deleted_flag = '0';
1960: END IF;
1961: EXCEPTION
1962: WHEN NO_DATA_FOUND THEN

Line 1959: AND cz_ui_templates.deleted_flag = '0';

1955: FROM cz_ui_templates
1956: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
1957: AND cz_ui_templates.template_id = p_template_id
1958: AND cz_ui_templates.seeded_flag = '0'
1959: AND cz_ui_templates.deleted_flag = '0';
1960: END IF;
1961: EXCEPTION
1962: WHEN NO_DATA_FOUND THEN
1963: NULL; ---do nothing

Line 2042: l_template_id cz_ui_templates.template_id%TYPE := NULL;

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
2045: IF (p_link_name IS NULL) THEN l_link_name := ' ';
2046: ELSE l_link_name := '@'||p_link_name;

Line 2125: FROM cz_ui_templates

2121: SELECT ui_def_id, template_id
2122: BULK
2123: COLLECT
2124: INTO l_ui_def_id_tbl,l_template_id_tbl
2125: FROM cz_ui_templates
2126: WHERE cz_ui_templates.deleted_flag = '0'
2127: AND cz_ui_templates.seeded_flag = '0'
2128: AND cz_ui_templates.ui_def_id = 0
2129: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id

Line 2126: WHERE cz_ui_templates.deleted_flag = '0'

2122: BULK
2123: COLLECT
2124: INTO l_ui_def_id_tbl,l_template_id_tbl
2125: FROM cz_ui_templates
2126: WHERE cz_ui_templates.deleted_flag = '0'
2127: AND cz_ui_templates.seeded_flag = '0'
2128: AND cz_ui_templates.ui_def_id = 0
2129: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id
2130: FROM cz_ui_defs

Line 2127: AND cz_ui_templates.seeded_flag = '0'

2123: COLLECT
2124: INTO l_ui_def_id_tbl,l_template_id_tbl
2125: FROM cz_ui_templates
2126: WHERE cz_ui_templates.deleted_flag = '0'
2127: AND cz_ui_templates.seeded_flag = '0'
2128: AND cz_ui_templates.ui_def_id = 0
2129: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id
2130: FROM cz_ui_defs
2131: WHERE cz_ui_defs.deleted_flag = '0');

Line 2128: AND cz_ui_templates.ui_def_id = 0

2124: INTO l_ui_def_id_tbl,l_template_id_tbl
2125: FROM cz_ui_templates
2126: WHERE cz_ui_templates.deleted_flag = '0'
2127: AND cz_ui_templates.seeded_flag = '0'
2128: AND cz_ui_templates.ui_def_id = 0
2129: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id
2130: FROM cz_ui_defs
2131: WHERE cz_ui_defs.deleted_flag = '0');
2132:

Line 2129: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id

2125: FROM cz_ui_templates
2126: WHERE cz_ui_templates.deleted_flag = '0'
2127: AND cz_ui_templates.seeded_flag = '0'
2128: AND cz_ui_templates.ui_def_id = 0
2129: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id
2130: FROM cz_ui_defs
2131: WHERE cz_ui_defs.deleted_flag = '0');
2132:
2133: IF (l_ui_def_id_tbl.COUNT > 0) THEN