[Home] [Help]
134: psp1.data_value, prp1.def_value) as property_value,
135: prp1.name as property_name, prp1.property_id,
136: prp1.data_type, psn1.item_id, to_number (null)
137: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
138: from cz_ps_nodes psn1,
139: cz_ps_prop_vals psp1,
140: CZ_UI_NODES uin,
141: cz_properties prp1
142: where psn1.deleted_flag = '0'
153: ipv2.property_value, prp2.def_value) as property_value,
154: prp2.name as property_name, prp2.property_id,
155: prp2.data_type,psn2.item_id, to_number (null) as item_type_id
156: , prp2.def_value as default_value, uin.ui_node_id
157: from cz_ps_nodes psn2,
158: cz_ui_nodes uin,
159: cz_item_property_values ipv2,
160: cz_properties prp2,
161: cz_item_masters itm2
176: prp3.property_id,
177: prp3.data_type,psn3.item_id, itm3.item_type_id , prp3.def_value as
178: default_value, uin.ui_node_id
179: from
180: cz_ps_nodes psn3,
181: cz_item_masters itm3,
182: cz_ui_nodes uin,
183: cz_item_type_properties itp3,
184: cz_properties prp3
215: psp1.data_value, prp1.def_value) as property_value,
216: prp1.name as property_name, prp1.property_id,
217: prp1.data_type,psn1.item_id, to_number (null)
218: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
219: from cz_ps_nodes psn1,
220: cz_ps_prop_vals psp1,
221: CZ_UI_NODES uin,
222: cz_properties prp1
223: where psn1.deleted_flag = '0'
234: ipv2.property_value, prp2.def_value) as property_value,
235: prp2.name as property_name, prp2.property_id,
236: prp2.data_type,psn2.item_id, to_number (null) as item_type_id
237: , prp2.def_value as default_value, uin.ui_node_id
238: from cz_ps_nodes psn2,
239: cz_ui_nodes uin,
240: cz_item_property_values ipv2,
241: cz_properties prp2,
242: cz_item_masters itm2
257: prp3.property_id,
258: prp3.data_type,psn3.item_id, itm3.item_type_id , prp3.def_value as
259: default_value, uin.ui_node_id
260: from
261: cz_ps_nodes psn3,
262: cz_item_masters itm3,
263: cz_ui_nodes uin,
264: cz_item_type_properties itp3,
265: cz_properties prp3
306: psp1.data_value, prp1.def_value) as property_value,
307: prp1.name as property_name, prp1.property_id,
308: prp1.data_type,psn1.item_id, to_number (null)
309: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
310: from cz_ps_nodes psn1,
311: cz_ps_prop_vals psp1,
312: CZ_UI_NODES uin,
313: cz_properties prp1
314: where psn1.deleted_flag = '0'
325: ipv2.property_value, prp2.def_value) as property_value,
326: prp2.name as property_name, prp2.property_id,
327: prp2.data_type,psn2.item_id, to_number (null) as item_type_id
328: , prp2.def_value as default_value, uin.ui_node_id
329: from cz_ps_nodes psn2,
330: cz_ui_nodes uin,
331: cz_item_property_values ipv2,
332: cz_properties prp2,
333: cz_item_masters itm2
348: prp3.property_id,
349: prp3.data_type,psn3.item_id, itm3.item_type_id , prp3.def_value as
350: default_value, uin.ui_node_id
351: from
352: cz_ps_nodes psn3,
353: cz_item_masters itm3,
354: cz_ui_nodes uin,
355: cz_item_type_properties itp3,
356: cz_properties prp3
387: psp1.data_value, prp1.def_value) as property_value,
388: prp1.name as property_name, prp1.property_id,
389: prp1.data_type, psn1.item_id, to_number (null)
390: as item_type_id, prp1.def_value as default_value, uin.ui_node_id
391: from cz_ps_nodes psn1,
392: cz_ps_prop_vals psp1,
393: CZ_UI_NODES uin,
394: cz_properties prp1
395: where psn1.deleted_flag = '0'
406: ipv2.property_value, prp2.def_value) as property_value,
407: prp2.name as property_name, prp2.property_id,
408: prp2.data_type, psn2.item_id, to_number (null) as item_type_id
409: , prp2.def_value as default_value, uin.ui_node_id
410: from cz_ps_nodes psn2,
411: cz_ui_nodes uin,
412: cz_item_property_values ipv2,
413: cz_properties prp2,
414: cz_item_masters itm2
429: prp3.property_id,
430: prp3.data_type, psn3.item_id, itm3.item_type_id , prp3.def_value as
431: default_value, uin.ui_node_id
432: from
433: cz_ps_nodes psn3,
434: cz_item_masters itm3,
435: cz_ui_nodes uin,
436: cz_item_type_properties itp3,
437: cz_properties prp3
493: RETURN BOOLEAN
494: IS
495: CURSOR ps_node_cursor IS
496: SELECT ps_node_id
497: FROM cz_ps_nodes
498: WHERE devl_project_id = p_model_id
499: START WITH ps_node_id = p_node_id
500: CONNECT BY ps_node_id = PRIOR parent_ID;
501: BEGIN
522: v_bom_model_id NUMBER;
523: v_ids NUM_TBL_TYPE;
524: CURSOR ps_node_cursor IS
525: SELECT persistent_node_id, ps_node_id, parent_id, ps_node_type, reference_id
526: FROM CZ_PS_NODES
527: WHERE devl_project_id = p_model_id
528: AND ps_node_type in (PS_NODE_BOM_MODEL_TYPE, PS_NODE_REFERENCE_TYPE)
529: AND deleted_flag = '0'
530: ORDER BY ps_node_type DESC;
864: BEGIN
865: SELECT component_id,model_id INTO l_component_id, l_model_id FROM CZ_MODEL_REF_EXPLS
866: WHERE model_ref_expl_id=p_target_page_expl_id;
867:
868: SELECT persistent_node_id INTO l_root_persist_id FROM CZ_PS_NODES
869: WHERE devl_project_id=p_root_model_id AND parent_id IS NULL AND deleted_flag='0';
870:
871: IF p_root_model_id=l_model_id THEN
872: SELECT ps_node_id INTO l_target_ps_node_id FROM CZ_PS_NODES WHERE devl_project_id=l_model_id AND
868: SELECT persistent_node_id INTO l_root_persist_id FROM CZ_PS_NODES
869: WHERE devl_project_id=p_root_model_id AND parent_id IS NULL AND deleted_flag='0';
870:
871: IF p_root_model_id=l_model_id THEN
872: SELECT ps_node_id INTO l_target_ps_node_id FROM CZ_PS_NODES WHERE devl_project_id=l_model_id AND
873: persistent_node_id=p_target_page_persist_id AND deleted_flag='0';
874: SELECT model_ref_expl_id INTO l_model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
875: WHERE model_id=l_model_id AND parent_expl_node_id IS NULL AND deleted_flag='0';
876:
913: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0'
914: AND PRIOR deleted_flag='0')
915: LOOP
916:
917: SELECT ps_node_id INTO l_target_ps_node_id FROM CZ_PS_NODES
918: WHERE devl_project_id=(SELECT devl_project_id FROM CZ_UI_DEFS WHERE ui_def_id=p_target_ui_def_id) AND
919: persistent_node_id=p_target_page_persist_id AND deleted_flag='0';
920:
921: RETURN TO_CHAR(l_root_persist_id)||'.'||cz_developer_utils_pvt.annotated_node_path (