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_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:
1854: END adjust_specific_control;
1855: ------------------------------------------------------------------------------------------------------------
1856: --This procedure is not dynamic and significantly uses the specifics of the CZ database.

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

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

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

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

Line 1951: FROM cz_ui_templates

1947: SELECT jrad_doc
1948: BULK
1949: COLLECT
1950: INTO l_jrad_doc_tbl
1951: FROM cz_ui_templates
1952: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
1953: AND cz_ui_templates.template_id = p_template_id
1954: AND cz_ui_templates.seeded_flag = '0'
1955: AND cz_ui_templates.deleted_flag = '0';

Line 1952: WHERE cz_ui_templates.ui_def_id = p_ui_def_id

1948: BULK
1949: COLLECT
1950: INTO l_jrad_doc_tbl
1951: FROM cz_ui_templates
1952: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
1953: AND cz_ui_templates.template_id = p_template_id
1954: AND cz_ui_templates.seeded_flag = '0'
1955: AND cz_ui_templates.deleted_flag = '0';
1956: END IF;

Line 1953: AND cz_ui_templates.template_id = p_template_id

1949: COLLECT
1950: INTO l_jrad_doc_tbl
1951: FROM cz_ui_templates
1952: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
1953: AND cz_ui_templates.template_id = p_template_id
1954: AND cz_ui_templates.seeded_flag = '0'
1955: AND cz_ui_templates.deleted_flag = '0';
1956: END IF;
1957: EXCEPTION

Line 1954: AND cz_ui_templates.seeded_flag = '0'

1950: INTO l_jrad_doc_tbl
1951: FROM cz_ui_templates
1952: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
1953: AND cz_ui_templates.template_id = p_template_id
1954: AND cz_ui_templates.seeded_flag = '0'
1955: AND cz_ui_templates.deleted_flag = '0';
1956: END IF;
1957: EXCEPTION
1958: WHEN NO_DATA_FOUND THEN

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

1951: FROM cz_ui_templates
1952: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
1953: AND cz_ui_templates.template_id = p_template_id
1954: AND cz_ui_templates.seeded_flag = '0'
1955: AND cz_ui_templates.deleted_flag = '0';
1956: END IF;
1957: EXCEPTION
1958: WHEN NO_DATA_FOUND THEN
1959: NULL; ---do nothing

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

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

Line 2113: FROM cz_ui_templates

2109: SELECT ui_def_id, template_id
2110: BULK
2111: COLLECT
2112: INTO l_ui_def_id_tbl,l_template_id_tbl
2113: FROM cz_ui_templates
2114: WHERE cz_ui_templates.deleted_flag = '0'
2115: AND cz_ui_templates.seeded_flag = '0'
2116: AND cz_ui_templates.ui_def_id = 0
2117: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id

Line 2114: WHERE cz_ui_templates.deleted_flag = '0'

2110: BULK
2111: COLLECT
2112: INTO l_ui_def_id_tbl,l_template_id_tbl
2113: FROM cz_ui_templates
2114: WHERE cz_ui_templates.deleted_flag = '0'
2115: AND cz_ui_templates.seeded_flag = '0'
2116: AND cz_ui_templates.ui_def_id = 0
2117: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id
2118: FROM cz_ui_defs

Line 2115: AND cz_ui_templates.seeded_flag = '0'

2111: COLLECT
2112: INTO l_ui_def_id_tbl,l_template_id_tbl
2113: FROM cz_ui_templates
2114: WHERE cz_ui_templates.deleted_flag = '0'
2115: AND cz_ui_templates.seeded_flag = '0'
2116: AND cz_ui_templates.ui_def_id = 0
2117: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id
2118: FROM cz_ui_defs
2119: WHERE cz_ui_defs.deleted_flag = '0');

Line 2116: AND cz_ui_templates.ui_def_id = 0

2112: INTO l_ui_def_id_tbl,l_template_id_tbl
2113: FROM cz_ui_templates
2114: WHERE cz_ui_templates.deleted_flag = '0'
2115: AND cz_ui_templates.seeded_flag = '0'
2116: AND cz_ui_templates.ui_def_id = 0
2117: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id
2118: FROM cz_ui_defs
2119: WHERE cz_ui_defs.deleted_flag = '0');
2120:

Line 2117: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id

2113: FROM cz_ui_templates
2114: WHERE cz_ui_templates.deleted_flag = '0'
2115: AND cz_ui_templates.seeded_flag = '0'
2116: AND cz_ui_templates.ui_def_id = 0
2117: OR cz_ui_templates.ui_def_id IN (SELECT ui_def_id
2118: FROM cz_ui_defs
2119: WHERE cz_ui_defs.deleted_flag = '0');
2120:
2121: IF (l_ui_def_id_tbl.COUNT > 0) THEN