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_MODEL_MIGRATION_PVT dependencies on CZ_PS_NODES

Line 192: SELECT MODEL_TYPE_NAME_ERR INTO l_model_type FROM cz_ps_nodes

188: l_model_type INTEGER;
189: BEGIN
190: -- each node has name ?
191: BEGIN
192: SELECT MODEL_TYPE_NAME_ERR INTO l_model_type FROM cz_ps_nodes
193: WHERE deleted_flag = '0' AND devl_project_id IN
194: (SELECT component_id FROM cz_model_ref_expls
195: WHERE deleted_flag = '0' AND model_id = p_model_id
196: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR parent_expl_node_id IS NULL))

Line 206: FROM cz_ps_nodes

202:
203: -- 1 pid maps exactly with 1 name ?
204: IF l_model_type = MODEL_TYPE_NORMAL THEN
205: FOR i IN (SELECT persistent_node_id, COUNT(distinct name)
206: FROM cz_ps_nodes
207: WHERE deleted_flag = '0' AND devl_project_id IN
208: (SELECT component_id FROM cz_model_ref_expls
209: WHERE deleted_flag = '0' AND model_id = p_model_id
210: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR

Line 238: TYPE name_tbl_type IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

234: l_cmt_rec_count PLS_INTEGER;
235: l_ndebug PLS_INTEGER;
236: l_msg VARCHAR2(1000);
237: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
238: TYPE name_tbl_type IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
239: TYPE name_tbl_type_idx_vc2 IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY VARCHAR2(15);
240: TYPE complex_num_tbl_type IS TABLE OF num_tbl_type_index_vc2 INDEX BY VARCHAR2(15);
241: TYPE complex_name_tbl_type IS TABLE OF name_tbl_type_idx_vc2 INDEX BY VARCHAR2(15);
242:

Line 239: TYPE name_tbl_type_idx_vc2 IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY VARCHAR2(15);

235: l_ndebug PLS_INTEGER;
236: l_msg VARCHAR2(1000);
237: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
238: TYPE name_tbl_type IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
239: TYPE name_tbl_type_idx_vc2 IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY VARCHAR2(15);
240: TYPE complex_num_tbl_type IS TABLE OF num_tbl_type_index_vc2 INDEX BY VARCHAR2(15);
241: TYPE complex_name_tbl_type IS TABLE OF name_tbl_type_idx_vc2 INDEX BY VARCHAR2(15);
242:
243: l_hdr_tbl num_tbl_type;

Line 268: FROM cz_ps_nodes

264: PROCEDURE create_maps(p_model_id IN NUMBER)
265: IS
266: BEGIN
267: FOR i IN (SELECT devl_project_id, persistent_node_id, name, ps_node_type, reference_id
268: FROM cz_ps_nodes
269: WHERE deleted_flag = '0' AND devl_project_id in
270: (SELECT component_id FROM cz_model_ref_expls
271: WHERE deleted_flag = '0' AND model_id = p_model_id
272: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR parent_expl_node_id IS NULL)))

Line 367: (SELECT name FROM cz_ps_nodes psn

363: IF l_model_type = MODEL_TYPE_NORMAL THEN
364: l_ndebug := 4;
365: UPDATE cz_config_items item
366: SET ps_node_name =
367: (SELECT name FROM cz_ps_nodes psn
368: WHERE deleted_flag = '0' AND persistent_node_id = item.ps_node_id
369: AND EXISTS (SELECT 1 FROM cz_model_ref_expls
370: WHERE deleted_flag = '0' AND model_id = l_model_id
371: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR parent_expl_node_id IS NULL)