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_REFS dependencies on CZ_MODEL_REF_EXPLS

Line 192: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;

188:
189: FUNCTION allocate_Expl_Id RETURN NUMBER IS
190: v_next_id NUMBER;
191: BEGIN
192: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;
193: RETURN v_next_id;
194: END allocate_Expl_Id;
195:
196: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 200: v_expl_node_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

196: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
197: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
198:
199: FUNCTION get_Root_Expl_Id(p_model_id IN NUMBER) RETURN NUMBER IS
200: v_expl_node_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
201: BEGIN
202: SELECT model_ref_expl_id INTO v_expl_node_id FROM CZ_MODEL_REF_EXPLS
203: WHERE component_id=p_model_id AND model_id=p_model_id AND
204: parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;

Line 202: SELECT model_ref_expl_id INTO v_expl_node_id FROM CZ_MODEL_REF_EXPLS

198:
199: FUNCTION get_Root_Expl_Id(p_model_id IN NUMBER) RETURN NUMBER IS
200: v_expl_node_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
201: BEGIN
202: SELECT model_ref_expl_id INTO v_expl_node_id FROM CZ_MODEL_REF_EXPLS
203: WHERE component_id=p_model_id AND model_id=p_model_id AND
204: parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
205: RETURN v_expl_node_id;
206: END get_Root_Expl_Id;

Line 222: (SELECT component_id FROM CZ_MODEL_REF_EXPLS

218:
219: BEGIN
220: SELECT YES_FLAG INTO p_circularity_exists FROM dual WHERE
221: EXISTS
222: (SELECT component_id FROM CZ_MODEL_REF_EXPLS
223: WHERE model_id=p_target_model_id AND deleted_flag=NO_FLAG
224: AND ps_node_type IN (REFERENCE_TYPE,CONNECTOR_TYPE) AND component_id=p_source_model_id) OR
225: (p_target_model_id=p_source_model_id);
226: RETURN p_circularity_exists;

Line 283: UPDATE CZ_MODEL_REF_EXPLS

279: v_model_ref_expl_id INTEGER;
280:
281: BEGIN
282: IF p_node_depth IS NULL THEN
283: UPDATE CZ_MODEL_REF_EXPLS
284: SET node_depth=0
285: WHERE model_id=p_model_id AND parent_expl_node_id IS NULL
286: AND deleted_flag=NO_FLAG
287: RETURNING model_ref_expl_id INTO v_model_ref_expl_id;

Line 291: FOR i IN(SELECT model_ref_expl_id,referring_node_id,ps_node_type FROM CZ_MODEL_REF_EXPLS

287: RETURNING model_ref_expl_id INTO v_model_ref_expl_id;
288: update_Node_Depth_(p_model_id,v_model_ref_expl_id,0);
289: ELSE
290: v_node_depth:=p_node_depth+1;
291: FOR i IN(SELECT model_ref_expl_id,referring_node_id,ps_node_type FROM CZ_MODEL_REF_EXPLS
292: WHERE model_id=p_model_id AND parent_expl_node_id=p_expl_id
293: AND deleted_flag=NO_FLAG)
294: LOOP
295: UPDATE CZ_MODEL_REF_EXPLS

Line 295: UPDATE CZ_MODEL_REF_EXPLS

291: FOR i IN(SELECT model_ref_expl_id,referring_node_id,ps_node_type FROM CZ_MODEL_REF_EXPLS
292: WHERE model_id=p_model_id AND parent_expl_node_id=p_expl_id
293: AND deleted_flag=NO_FLAG)
294: LOOP
295: UPDATE CZ_MODEL_REF_EXPLS
296: SET node_depth=v_node_depth
297: WHERE model_ref_expl_id=i.model_ref_expl_id AND node_depth<>v_node_depth;
298:
299: --

Line 336: UPDATE CZ_MODEL_REF_EXPLS

332: LOOP
333: EXIT WHEN j IS NULL;
334: IF t_nodes_to_delete_tbl.COUNT>0 THEN
335: FORALL i IN t_nodes_to_delete_tbl.FIRST..t_nodes_to_delete_tbl.LAST
336: UPDATE CZ_MODEL_REF_EXPLS
337: SET deleted_flag=YES_FLAG
338: WHERE model_ref_expl_id IN
339: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
340: START WITH model_id=t_upd_node_depth_models(j) AND model_ref_expl_id=t_nodes_to_delete_tbl(i) AND deleted_flag=NO_FLAG

Line 339: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

335: FORALL i IN t_nodes_to_delete_tbl.FIRST..t_nodes_to_delete_tbl.LAST
336: UPDATE CZ_MODEL_REF_EXPLS
337: SET deleted_flag=YES_FLAG
338: WHERE model_ref_expl_id IN
339: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
340: START WITH model_id=t_upd_node_depth_models(j) AND model_ref_expl_id=t_nodes_to_delete_tbl(i) AND deleted_flag=NO_FLAG
341: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
342: AND PRIOR deleted_flag=NO_FLAG);
343: END IF;

Line 349: FOR i IN(SELECT DISTINCT model_id FROM cz_model_ref_expls

345: END LOOP;
346:
347:
348: ELSE
349: FOR i IN(SELECT DISTINCT model_id FROM cz_model_ref_expls
350: WHERE ((component_id=p_model_id AND
351: ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE)) OR model_id=p_model_id)
352: AND deleted_flag=NO_FLAG)
353: LOOP

Line 359: UPDATE CZ_MODEL_REF_EXPLS

355: END LOOP;
356:
357: IF t_nodes_to_delete_tbl.COUNT>0 THEN
358: FORALL i IN t_nodes_to_delete_tbl.FIRST..t_nodes_to_delete_tbl.LAST
359: UPDATE CZ_MODEL_REF_EXPLS
360: SET deleted_flag=YES_FLAG
361: WHERE model_ref_expl_id IN
362: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
363: START WITH model_id=p_model_id AND model_ref_expl_id=t_nodes_to_delete_tbl(i) AND deleted_flag=NO_FLAG

Line 362: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

358: FORALL i IN t_nodes_to_delete_tbl.FIRST..t_nodes_to_delete_tbl.LAST
359: UPDATE CZ_MODEL_REF_EXPLS
360: SET deleted_flag=YES_FLAG
361: WHERE model_ref_expl_id IN
362: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
363: START WITH model_id=p_model_id AND model_ref_expl_id=t_nodes_to_delete_tbl(i) AND deleted_flag=NO_FLAG
364: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
365: AND PRIOR deleted_flag=NO_FLAG);
366: END IF;

Line 464: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;

460: p_ps_node_type IN INTEGER) RETURN NUMBER IS
461:
462: v_expr_parent_id CZ_EXPRESSION_NODES.expr_parent_id%TYPE;
463: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
464: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
465:
466: BEGIN
467: FOR i IN (SELECT rule_id,antecedent_id,consequent_id,NAME FROM CZ_RULES
468: WHERE devl_project_id=p_model_id AND disabled_flag=NO_FLAG

Line 542: INSERT INTO CZ_MODEL_REF_EXPLS

538:
539: BEGIN
540: v_expl_id:=allocate_Expl_Id;
541:
542: INSERT INTO CZ_MODEL_REF_EXPLS
543: (model_ref_expl_id,
544: parent_expl_node_id,
545: referring_node_id,
546: model_id,

Line 626: FROM CZ_MODEL_REF_EXPLS

622: PROCEDURE calc_Expl_Paths(p_root_expl_id IN NUMBER,x_paths_tbl OUT NOCOPY Varchar2Array ) IS
623: BEGIN
624:
625: FOR m IN(SELECT model_ref_expl_id,parent_expl_node_id,component_id,referring_node_id
626: FROM CZ_MODEL_REF_EXPLS
627: START WITH model_ref_expl_id=p_root_expl_id
628: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0' AND PRIOR deleted_flag='0')
629: LOOP
630:

Line 691: FROM CZ_MODEL_REF_EXPLS

687: l_expl_id NUMBER;
688: BEGIN
689: FOR i IN (SELECT parent_expl_node_id,referring_node_id,ps_node_type,
690: virtual_flag,component_id,expl_node_type,model_ref_expl_id,LEVEL
691: FROM CZ_MODEL_REF_EXPLS
692: START WITH model_id=p_target_model_id AND component_id=p_target_model_id -- this condition specifies root of expl tree
693: AND deleted_flag=NO_FLAG
694: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
695: LOOP

Line 758: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

754: -- M1 and M5
755: -- |--C1
756: -- so in this case t_model_ref_expl_ids_tbl will store 2 elements
757: --
758: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
759: WHERE model_id=p_target_model_id AND deleted_flag=NO_FLAG AND
760: ps_node_type IN(CONNECTOR_TYPE,REFERENCE_TYPE) )
761: LOOP
762: FOR j IN (SELECT model_ref_expl_id,ps_node_type

Line 763: FROM CZ_MODEL_REF_EXPLS

759: WHERE model_id=p_target_model_id AND deleted_flag=NO_FLAG AND
760: ps_node_type IN(CONNECTOR_TYPE,REFERENCE_TYPE) )
761: LOOP
762: FOR j IN (SELECT model_ref_expl_id,ps_node_type
763: FROM CZ_MODEL_REF_EXPLS
764: START WITH model_ref_expl_id = i.model_ref_expl_id AND deleted_flag=NO_FLAG
765: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
766: LOOP
767: t_model_ref_expl_ids_tbl(t_model_ref_expl_ids_tbl.COUNT+1):=j.model_ref_expl_id;

Line 809: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;

805: t_subtree_tbl ArrayId; -- stores rehashed ( rekeyed ) subtree
806:
807: t_next_level_expl_ids_tbl ArrayId;
808:
809: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;
810: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
811: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
812: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
813: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

Line 810: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

806:
807: t_next_level_expl_ids_tbl ArrayId;
808:
809: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;
810: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
811: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
812: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
813: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
814:

Line 811: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

807: t_next_level_expl_ids_tbl ArrayId;
808:
809: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;
810: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
811: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
812: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
813: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
814:
815: BEGIN

Line 812: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

808:
809: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;
810: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
811: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
812: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
813: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
814:
815: BEGIN
816:

Line 813: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

809: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;
810: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
811: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
812: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
813: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
814:
815: BEGIN
816:
817: t_subtree_tbl := p_subtree_tbl;

Line 866: INSERT INTO CZ_MODEL_REF_EXPLS

862: IF v_parent_id=p_new_root_expl_id THEN -- this is a root of attached subtree
863: g_root_point_tree_tbl(p_new_root_expl_id) := t_subtree_tbl(v_ind).new_id; -- store maping between attach point and root of attached subtree
864: END IF;
865:
866: INSERT INTO CZ_MODEL_REF_EXPLS
867: (model_ref_expl_id,
868: parent_expl_node_id,
869: referring_node_id,
870: model_id,

Line 909: FOR h IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

905: AND EXISTS (SELECT NULL FROM cz_devl_projects
906: WHERE devl_project_id = a.devl_project_id
907: AND deleted_flag='0'))
908: LOOP
909: FOR h IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
910: WHERE model_id=i.devl_project_id AND
911: child_model_expl_id=p_new_root_expl_id AND deleted_flag='0')
912: LOOP
913: g_hash_tree_tbl(h.model_ref_expl_id) := t_next_level_expl_ids_tbl;

Line 966: UPDATE CZ_MODEL_REF_EXPLS

962: END IF;
963:
964: IF l_expl_paths_tbl(l_new_expl_id) = t_attach_subtree_tbl(v_expl_id).expl_path THEN
965:
966: UPDATE CZ_MODEL_REF_EXPLS
967: SET child_model_expl_id=t_attach_subtree_tbl(v_expl_id).new_id
968: WHERE model_ref_expl_id=l_new_expl_id;
969:
970: END IF;

Line 1140: FROM CZ_MODEL_REF_EXPLS

1136: -- in model M2 we have 2 entries that have component_id = p_parent_ps_id = M1
1137: -- these are references Ref1 and Ref2
1138:
1139: FOR m IN(SELECT model_ref_expl_id,component_id,ps_node_type,node_depth
1140: FROM CZ_MODEL_REF_EXPLS
1141: WHERE model_id=t_chain(i).model_id AND component_id=p_parent_ps_id AND
1142: parent_expl_node_id IS NOT NULL AND deleted_flag=NO_FLAG)
1143: LOOP
1144:

Line 1148: WHERE EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS

1144:
1145: BEGIN
1146: v_connector_parent_exists:=NO_FLAG;
1147: SELECT YES_FLAG INTO v_connector_parent_exists FROM dual
1148: WHERE EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS
1149: WHERE ps_node_type=CONNECTOR_TYPE
1150: START WITH model_ref_expl_id=m.model_ref_expl_id
1151: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag=NO_FLAG AND deleted_flag=NO_FLAG);
1152: EXCEPTION

Line 1212: END LOOP; -- end of loop through CZ_MODEL_REF_EXPLS table --

1208: --
1209: -- put expl_id of branch that we've just handled
1210: --
1211: t_connect_point_tbl(m.model_ref_expl_id):= t_chain(i).model_id;
1212: END LOOP; -- end of loop through CZ_MODEL_REF_EXPLS table --
1213:
1214: --
1215: -- put the current model = t_chain(i).model_id to the hash
1216: -- of models which already hadnled

Line 1281: v_parent_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- expl_id of new subtree root node

1277: t_subtree_tbl ArrayId; -- stores subtree array
1278: t_prev_level_expl_ids_tbl IntArray; -- stores expl_ids of the target subtree
1279: -- which will be used as child_expl_ids on the next level
1280: v_parent_ps_node_id CZ_PS_NODES.ps_node_id%TYPE; -- ps_node_id of new subtree root node
1281: v_parent_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- expl_id of new subtree root node
1282: v_parent_level CZ_MODEL_REF_EXPLS.node_depth%TYPE; -- node_depth of new subtree root node
1283: v_target_root_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- root expl_id of the target model
1284: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- stores expl_id generated by sequence
1285:

Line 1282: v_parent_level CZ_MODEL_REF_EXPLS.node_depth%TYPE; -- node_depth of new subtree root node

1278: t_prev_level_expl_ids_tbl IntArray; -- stores expl_ids of the target subtree
1279: -- which will be used as child_expl_ids on the next level
1280: v_parent_ps_node_id CZ_PS_NODES.ps_node_id%TYPE; -- ps_node_id of new subtree root node
1281: v_parent_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- expl_id of new subtree root node
1282: v_parent_level CZ_MODEL_REF_EXPLS.node_depth%TYPE; -- node_depth of new subtree root node
1283: v_target_root_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- root expl_id of the target model
1284: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- stores expl_id generated by sequence
1285:
1286: BEGIN

Line 1283: v_target_root_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- root expl_id of the target model

1279: -- which will be used as child_expl_ids on the next level
1280: v_parent_ps_node_id CZ_PS_NODES.ps_node_id%TYPE; -- ps_node_id of new subtree root node
1281: v_parent_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- expl_id of new subtree root node
1282: v_parent_level CZ_MODEL_REF_EXPLS.node_depth%TYPE; -- node_depth of new subtree root node
1283: v_target_root_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- root expl_id of the target model
1284: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- stores expl_id generated by sequence
1285:
1286: BEGIN
1287: Initialize;

Line 1284: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- stores expl_id generated by sequence

1280: v_parent_ps_node_id CZ_PS_NODES.ps_node_id%TYPE; -- ps_node_id of new subtree root node
1281: v_parent_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- expl_id of new subtree root node
1282: v_parent_level CZ_MODEL_REF_EXPLS.node_depth%TYPE; -- node_depth of new subtree root node
1283: v_target_root_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- root expl_id of the target model
1284: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- stores expl_id generated by sequence
1285:
1286: BEGIN
1287: Initialize;
1288: p_out_err:=0;

Line 1384: FOR i IN (SELECT model_ref_expl_id,node_depth FROM CZ_MODEL_REF_EXPLS

1380: p_out_level:=NULL_VALUE;
1381:
1382:
1383: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1384: FOR i IN (SELECT model_ref_expl_id,node_depth FROM CZ_MODEL_REF_EXPLS
1385: WHERE model_id=p_project_id AND referring_node_id=p_ps_node_id
1386: AND child_model_expl_id IS NULL AND deleted_flag=NO_FLAG)
1387: LOOP
1388: p_out_expl_id:=i.model_ref_expl_id;

Line 1392: FOR i IN (SELECT model_ref_expl_id,node_depth FROM CZ_MODEL_REF_EXPLS

1388: p_out_expl_id:=i.model_ref_expl_id;
1389: p_out_level:=i.node_depth;
1390: END LOOP;
1391: ELSE
1392: FOR i IN (SELECT model_ref_expl_id,node_depth FROM CZ_MODEL_REF_EXPLS
1393: WHERE model_id=p_project_id AND referring_node_id IS NULL
1394: AND component_id=p_ps_node_id AND child_model_expl_id IS NULL AND
1395: deleted_flag=NO_FLAG)
1396: LOOP

Line 1459: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

1455: p_out_ps_node_id IN OUT NOCOPY INTEGER,
1456: p_out_expl_id IN OUT NOCOPY INTEGER,
1457: p_out_level IN OUT NOCOPY INTEGER) IS
1458:
1459: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
1460: NODE_FOUND EXCEPTION;
1461:
1462: BEGIN
1463: p_out_ps_node_id:=NULL_VALUE;

Line 1520: SELECT model_ref_expl_id INTO v_ref_id FROM CZ_MODEL_REF_EXPLS

1516: -- DEBUG ERROR CODE --
1517: --
1518: ERROR_CODE:=300;
1519:
1520: SELECT model_ref_expl_id INTO v_ref_id FROM CZ_MODEL_REF_EXPLS
1521: WHERE parent_expl_node_id=p_expl_id
1522: AND (child_model_expl_id=p_child_expl_id OR model_ref_expl_id=p_child_expl_id)
1523: AND deleted_flag=NO_FLAG;
1524:

Line 1536: SELECT parent_expl_node_id INTO v_ref_id FROM CZ_MODEL_REF_EXPLS

1532: -- DEBUG ERROR CODE --
1533: --
1534: ERROR_CODE:=302;
1535:
1536: SELECT parent_expl_node_id INTO v_ref_id FROM CZ_MODEL_REF_EXPLS
1537: WHERE model_ref_expl_id=p_expl_id;
1538:
1539: --
1540: -- DEBUG ERROR CODE --

Line 1559: v_model_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE ;

1555: p_ps_node_id IN INTEGER,
1556: p_mode IN VARCHAR2, -- DEFAULT PLUS_MODE
1557: p_deleted_expl_id IN INTEGER DEFAULT NULL) IS
1558:
1559: v_model_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE ;
1560: v_project_id CZ_MODEL_REF_EXPLS.model_id%TYPE;
1561: v_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
1562:
1563: BEGIN

Line 1560: v_project_id CZ_MODEL_REF_EXPLS.model_id%TYPE;

1556: p_mode IN VARCHAR2, -- DEFAULT PLUS_MODE
1557: p_deleted_expl_id IN INTEGER DEFAULT NULL) IS
1558:
1559: v_model_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE ;
1560: v_project_id CZ_MODEL_REF_EXPLS.model_id%TYPE;
1561: v_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
1562:
1563: BEGIN
1564:

Line 1561: v_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

1557: p_deleted_expl_id IN INTEGER DEFAULT NULL) IS
1558:
1559: v_model_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE ;
1560: v_project_id CZ_MODEL_REF_EXPLS.model_id%TYPE;
1561: v_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
1562:
1563: BEGIN
1564:
1565: IF p_mode=PLUS_MODE THEN

Line 1573: CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id

1569: --
1570: ERROR_CODE:=400;
1571:
1572: SELECT model_ref_expl_id INTO v_model_ref_id FROM
1573: CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id
1574: AND component_id=p_ps_node_id AND child_model_expl_id IS NULL AND deleted_flag=NO_FLAG;
1575:
1576: --
1577: -- DEBUG ERROR CODE --

Line 1908: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG WHERE model_ref_expl_id IN

1904: -- DEBUG ERROR CODE --
1905: --
1906: ERROR_CODE:=500;
1907:
1908: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG WHERE model_ref_expl_id IN
1909: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1910: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1911: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1912:

Line 1909: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1905: --
1906: ERROR_CODE:=500;
1907:
1908: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG WHERE model_ref_expl_id IN
1909: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1910: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1911: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1912:
1913: --

Line 1924: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id IN

1920: -- DEBUG ERROR CODE --
1921: --
1922: ERROR_CODE:=502;
1923:
1924: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id IN
1925: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1926: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1927: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1928:

Line 1925: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1921: --
1922: ERROR_CODE:=502;
1923:
1924: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id IN
1925: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1926: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1927: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1928:
1929: --

Line 1951: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

1947: p_ps_node_type IN INTEGER DEFAULT NULL) IS
1948:
1949: BEGIN
1950: IF p_del_logically=YES_FLAG THEN
1951: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1952: WHERE model_ref_expl_id=p_expl_id;
1953: ELSE
1954: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id=p_expl_id;
1955: END IF;

Line 1954: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id=p_expl_id;

1950: IF p_del_logically=YES_FLAG THEN
1951: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1952: WHERE model_ref_expl_id=p_expl_id;
1953: ELSE
1954: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id=p_expl_id;
1955: END IF;
1956:
1957: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1958: IF p_del_logically=YES_FLAG THEN

Line 1959: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

1955: END IF;
1956:
1957: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1958: IF p_del_logically=YES_FLAG THEN
1959: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1960: WHERE deleted_flag=NO_FLAG AND model_ref_expl_id IN
1961: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1962: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1963: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 1961: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1957: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1958: IF p_del_logically=YES_FLAG THEN
1959: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1960: WHERE deleted_flag=NO_FLAG AND model_ref_expl_id IN
1961: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1962: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1963: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
1964: PRIOR deleted_flag=NO_FLAG);
1965: ELSE

Line 1966: DELETE FROM CZ_MODEL_REF_EXPLS

1962: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1963: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
1964: PRIOR deleted_flag=NO_FLAG);
1965: ELSE
1966: DELETE FROM CZ_MODEL_REF_EXPLS
1967: WHERE model_ref_expl_id IN
1968: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1969: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1970: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);

Line 1968: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1964: PRIOR deleted_flag=NO_FLAG);
1965: ELSE
1966: DELETE FROM CZ_MODEL_REF_EXPLS
1967: WHERE model_ref_expl_id IN
1968: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1969: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1970: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1971: END IF;
1972: END IF;

Line 1977: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1973: END delete_it_;
1974:
1975: BEGIN
1976: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1977: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1978: WHERE referring_node_id=p_ps_node_id AND deleted_flag=NO_FLAG)
1979: LOOP
1980: delete_it_(i.model_ref_expl_id, YES_FLAG);
1981: END LOOP;

Line 1983: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1979: LOOP
1980: delete_it_(i.model_ref_expl_id, YES_FLAG);
1981: END LOOP;
1982: ELSE
1983: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1984: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG)
1985: LOOP
1986: delete_it_(i.model_ref_expl_id, YES_FLAG);
1987: END LOOP;

Line 2002: FOR i IN(SELECT model_ref_expl_id,referring_node_id,component_id,expl_node_type FROM CZ_MODEL_REF_EXPLS

1998:
1999: BEGIN
2000: p_instanciable:=0;
2001:
2002: FOR i IN(SELECT model_ref_expl_id,referring_node_id,component_id,expl_node_type FROM CZ_MODEL_REF_EXPLS
2003: START WITH model_id=p_model_id AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG
2004: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
2005: deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG
2006: AND ps_node_type IN(BOM_MODEL_TYPE,COMPONENT_TYPE,REFERENCE_TYPE)

Line 2042: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE:=NULL_VALUE;

2038: p_out_ps_node_id IN OUT NOCOPY INTEGER,
2039: p_out_expl_id IN OUT NOCOPY INTEGER,
2040: p_out_level IN OUT NOCOPY INTEGER) IS
2041:
2042: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE:=NULL_VALUE;
2043: v_parent_id CZ_PS_NODES.parent_id%TYPE:=NULL_VALUE;
2044:
2045: BEGIN
2046:

Line 2069: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_ps_node_id

2065: ERROR_CODE:=1002;
2066:
2067: SELECT model_ref_expl_id,node_depth
2068: INTO p_out_expl_id,p_out_level
2069: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_ps_node_id
2070: AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
2071:
2072: RETURN;
2073: END IF;

Line 2093: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id

2089: ERROR_CODE:=700;
2090:
2091: SELECT model_ref_expl_id,node_depth
2092: INTO p_out_expl_id,p_out_level
2093: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id
2094: AND component_id=i.ps_node_id AND deleted_flag=NO_FLAG;
2095:
2096: --
2097: -- DEBUG ERROR CODE --

Line 2128: v_old_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2124: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
2125:
2126: PROCEDURE update_Rules(p_ps_node_id IN INTEGER) IS
2127:
2128: v_old_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2129: v_new_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2130:
2131: BEGIN
2132: FOR i IN t_old_expl_ids.FIRST..t_old_expl_ids.LAST

Line 2129: v_new_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2125:
2126: PROCEDURE update_Rules(p_ps_node_id IN INTEGER) IS
2127:
2128: v_old_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2129: v_new_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2130:
2131: BEGIN
2132: FOR i IN t_old_expl_ids.FIRST..t_old_expl_ids.LAST
2133: LOOP

Line 2190: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2186: p_child_array IN IntArray -- array of direct childs ( in PS tree )
2187: ) IS
2188:
2189: t_child_nodes IntArray;
2190: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2191: v_model_id CZ_MODEL_REF_EXPLS.model_id%TYPE;
2192: v_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2193:
2194: BEGIN

Line 2191: v_model_id CZ_MODEL_REF_EXPLS.model_id%TYPE;

2187: ) IS
2188:
2189: t_child_nodes IntArray;
2190: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2191: v_model_id CZ_MODEL_REF_EXPLS.model_id%TYPE;
2192: v_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2193:
2194: BEGIN
2195: IF t_chain.COUNT=0 THEN

Line 2204: FROM CZ_MODEL_REF_EXPLS

2200: IF t_chain(i).parent_model_id=p_model_id THEN
2201: v_model_id:=t_chain(i).model_id;
2202:
2203: FOR l IN(SELECT model_ref_expl_id,node_depth
2204: FROM CZ_MODEL_REF_EXPLS
2205: WHERE model_id=t_chain(i).model_id AND
2206: child_model_expl_id=p_parent_ref_expl_id
2207: AND deleted_flag=NO_FLAG)
2208: LOOP

Line 2211: -- generate the next PK for CZ_MODEL_REF_EXPLS table

2207: AND deleted_flag=NO_FLAG)
2208: LOOP
2209:
2210: --
2211: -- generate the next PK for CZ_MODEL_REF_EXPLS table
2212: --
2213: v_expl_id:=allocate_Expl_Id;
2214:
2215: --

Line 2220: INSERT INTO CZ_MODEL_REF_EXPLS

2216: -- DEBUG ERROR CODE --
2217: --
2218: ERROR_CODE:=800;
2219:
2220: INSERT INTO CZ_MODEL_REF_EXPLS
2221: (model_ref_expl_id,
2222: parent_expl_node_id,
2223: referring_node_id,
2224: model_id,

Line 2264: UPDATE CZ_MODEL_REF_EXPLS

2260: -- DEBUG ERROR CODE --
2261: --
2262: ERROR_CODE:=802;
2263:
2264: UPDATE CZ_MODEL_REF_EXPLS
2265: SET parent_expl_node_id=v_expl_id
2266: WHERE parent_expl_node_id=l.model_ref_expl_id
2267: AND model_id=v_model_id AND
2268: ((ps_node_type IN(PRODUCT_TYPE,COMPONENT_TYPE,BOM_MODEL_TYPE) AND component_id=v_ps_node_id)

Line 2286: UPDATE CZ_MODEL_REF_EXPLS

2282: --
2283: ERROR_CODE:=804;
2284:
2285: FORALL h IN t_child_nodes.FIRST..t_child_nodes.LAST
2286: UPDATE CZ_MODEL_REF_EXPLS
2287: SET node_depth=node_depth+1
2288: WHERE model_ref_expl_id IN
2289: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2290: START WITH model_ref_expl_id=t_child_nodes(h) AND deleted_flag=NO_FLAG

Line 2289: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

2285: FORALL h IN t_child_nodes.FIRST..t_child_nodes.LAST
2286: UPDATE CZ_MODEL_REF_EXPLS
2287: SET node_depth=node_depth+1
2288: WHERE model_ref_expl_id IN
2289: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2290: START WITH model_ref_expl_id=t_child_nodes(h) AND deleted_flag=NO_FLAG
2291: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
2292: AND PRIOR deleted_flag=NO_FLAG);
2293:

Line 2350: FROM CZ_MODEL_REF_EXPLS

2346: IF t_chain(i).parent_model_id=p_model_id THEN
2347: v_model_id:=t_chain(i).model_id;
2348:
2349: FOR l IN(SELECT model_ref_expl_id,node_depth
2350: FROM CZ_MODEL_REF_EXPLS
2351: WHERE model_id=t_chain(i).model_id AND
2352: child_model_expl_id=p_parent_model_ref_expl_id
2353: AND deleted_flag=NO_FLAG)
2354: LOOP

Line 2357: FROM CZ_MODEL_REF_EXPLS

2353: AND deleted_flag=NO_FLAG)
2354: LOOP
2355:
2356: FOR m IN(SELECT *
2357: FROM CZ_MODEL_REF_EXPLS
2358: WHERE model_ref_expl_id = p_model_ref_expl_id
2359: AND deleted_flag=NO_FLAG)
2360: LOOP
2361: --

Line 2362: -- generate the next PK for CZ_MODEL_REF_EXPLS table

2358: WHERE model_ref_expl_id = p_model_ref_expl_id
2359: AND deleted_flag=NO_FLAG)
2360: LOOP
2361: --
2362: -- generate the next PK for CZ_MODEL_REF_EXPLS table
2363: --
2364: v_expl_id:=allocate_Expl_Id;
2365:
2366: INSERT INTO CZ_MODEL_REF_EXPLS

Line 2366: INSERT INTO CZ_MODEL_REF_EXPLS

2362: -- generate the next PK for CZ_MODEL_REF_EXPLS table
2363: --
2364: v_expl_id:=allocate_Expl_Id;
2365:
2366: INSERT INTO CZ_MODEL_REF_EXPLS
2367: (model_ref_expl_id,
2368: parent_expl_node_id,
2369: referring_node_id,
2370: model_id,

Line 2408: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS WHERE parent_expl_node_id = p_model_ref_expl_id AND deleted_flag = NO_FLAG)

2404: BEGIN
2405:
2406: populate_expl_tree_internal(p_parent_model_ref_expl_id,p_model_ref_expl_id,p_model_id);
2407:
2408: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS WHERE parent_expl_node_id = p_model_ref_expl_id AND deleted_flag = NO_FLAG)
2409: LOOP
2410: populate_parent_expl_tree_(p_model_id => p_model_id, p_model_ref_expl_id => i.model_ref_expl_id, p_parent_model_ref_expl_id => p_model_ref_expl_id);
2411: END LOOP;
2412:

Line 2454: FROM CZ_MODEL_REF_EXPLS

2450:
2451: -- if not a reference node, get the model_refexpl_id record in model ref expls
2452: IF l_reference_id IS NULL THEN
2453: SELECT model_ref_expl_id, node_depth INTO l_expl_id, l_curr_node_depth
2454: FROM CZ_MODEL_REF_EXPLS
2455: WHERE model_id=l_model_id AND component_id=l_component_id AND
2456: child_model_expl_id IS NULL AND deleted_flag = NO_FLAG;
2457: ELSE
2458: SELECT MIN(node_depth) INTO l_min_node_depth

Line 2459: FROM CZ_MODEL_REF_EXPLS

2455: WHERE model_id=l_model_id AND component_id=l_component_id AND
2456: child_model_expl_id IS NULL AND deleted_flag = NO_FLAG;
2457: ELSE
2458: SELECT MIN(node_depth) INTO l_min_node_depth
2459: FROM CZ_MODEL_REF_EXPLS
2460: WHERE model_id=l_model_id AND referring_node_id=p_ps_node_id
2461: AND deleted_flag = NO_FLAG;
2462:
2463: SELECT model_ref_expl_id, node_depth INTO l_expl_id, l_curr_node_depth

Line 2464: FROM CZ_MODEL_REF_EXPLS

2460: WHERE model_id=l_model_id AND referring_node_id=p_ps_node_id
2461: AND deleted_flag = NO_FLAG;
2462:
2463: SELECT model_ref_expl_id, node_depth INTO l_expl_id, l_curr_node_depth
2464: FROM CZ_MODEL_REF_EXPLS
2465: WHERE model_id=l_model_id AND referring_node_id=p_ps_node_id AND
2466: node_depth=l_min_node_depth AND deleted_flag = NO_FLAG;
2467: END IF;
2468:

Line 2485: FOR i IN(SELECT model_ref_expl_id, node_depth FROM CZ_MODEL_REF_EXPLS

2481: END IF;
2482:
2483: IF (l_virtual_flag='1' OR l_virtual_flag IS NULL) AND l_parent_id IS NOT NULL THEN
2484:
2485: FOR i IN(SELECT model_ref_expl_id, node_depth FROM CZ_MODEL_REF_EXPLS
2486: WHERE parent_expl_node_id=v_up_expl_id AND
2487: deleted_flag = NO_FLAG AND
2488: (referring_node_id IS NULL AND component_id IN
2489: (SELECT ps_node_id FROM CZ_PS_NODES

Line 2555: FROM CZ_MODEL_REF_EXPLS a

2551: l_model_updated_tbl(p_current_model_id) := p_current_model_id;
2552: END IF;
2553:
2554: FOR i IN(SELECT model_ref_expl_id, referring_node_id, component_id
2555: FROM CZ_MODEL_REF_EXPLS a
2556: WHERE a.model_id=p_current_model_id AND a.deleted_flag=NO_FLAG)
2557: LOOP
2558:
2559: IF i.referring_node_id IS NULL THEN

Line 2566: FROM CZ_MODEL_REF_EXPLS

2562: l_paths_tbl(i.model_ref_expl_id) := TO_CHAR(i.referring_node_id);
2563: END IF;
2564:
2565: FOR m IN(SELECT model_ref_expl_id,component_id,referring_node_id
2566: FROM CZ_MODEL_REF_EXPLS
2567: WHERE model_ref_expl_id<>i.model_ref_expl_id
2568: START WITH model_ref_expl_id=i.model_ref_expl_id
2569: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag=NO_FLAG)
2570: LOOP

Line 2603: SELECT model_ref_expl_id INTO l_ref_expl_id FROM CZ_MODEL_REF_EXPLS

2599: LOOP
2600:
2601: l_new_expl_path_tbl.DELETE;
2602:
2603: SELECT model_ref_expl_id INTO l_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2604: WHERE model_id=n.devl_project_id AND referring_node_id=n.ps_node_id;
2605:
2606: l_new_paths_tbl.DELETE;
2607:

Line 2610: FROM CZ_MODEL_REF_EXPLS

2606: l_new_paths_tbl.DELETE;
2607:
2608: FOR k IN(SELECT model_ref_expl_id,component_id,
2609: referring_node_id,ps_node_type,child_model_expl_id,model_id
2610: FROM CZ_MODEL_REF_EXPLS
2611: START WITH model_ref_expl_id=l_ref_expl_id AND deleted_flag=NO_FLAG
2612: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
2613: deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
2614: LOOP

Line 2630: FROM CZ_MODEL_REF_EXPLS

2626:
2627: IF k.model_ref_expl_id <> l_ref_expl_id THEN
2628:
2629: FOR kk IN(SELECT model_ref_expl_id,component_id,referring_node_id
2630: FROM CZ_MODEL_REF_EXPLS
2631: WHERE model_ref_expl_id<>k.model_ref_expl_id
2632: START WITH model_ref_expl_id=k.model_ref_expl_id
2633: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag=NO_FLAG)
2634: LOOP

Line 2664: SELECT child_model_expl_id INTO l_child_expl_id FROM CZ_MODEL_REF_EXPLS

2660: END IF;
2661:
2662: IF l_expl_path_tbl.EXISTS(l_new_paths_tbl(l_loop_ind)) THEN
2663:
2664: SELECT child_model_expl_id INTO l_child_expl_id FROM CZ_MODEL_REF_EXPLS
2665: WHERE model_ref_expl_id=l_loop_ind;
2666:
2667: IF l_expl_path_tbl(l_new_paths_tbl(l_loop_ind)) <> l_child_expl_id THEN
2668:

Line 2671: UPDATE CZ_MODEL_REF_EXPLS

2667: IF l_expl_path_tbl(l_new_paths_tbl(l_loop_ind)) <> l_child_expl_id THEN
2668:
2669: l_num_updated_records := l_num_updated_records + 1;
2670:
2671: UPDATE CZ_MODEL_REF_EXPLS
2672: SET child_model_expl_id=l_expl_path_tbl(l_new_paths_tbl(l_loop_ind))
2673: WHERE model_ref_expl_id=l_loop_ind;
2674:
2675: END IF;

Line 2703: FOR i IN(SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS a

2699:
2700: --
2701: -- start with those explosion tree branches which do not have references/connectors to other models
2702: --
2703: FOR i IN(SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS a
2704: WHERE model_id=p_model_id AND deleted_flag=NO_FLAG AND
2705: ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND NOT EXISTS
2706: (SELECT NULL FROM CZ_MODEL_REF_EXPLS
2707: WHERE model_id=a.component_id AND ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND deleted_flag=NO_FLAG))

Line 2706: (SELECT NULL FROM CZ_MODEL_REF_EXPLS

2702: --
2703: FOR i IN(SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS a
2704: WHERE model_id=p_model_id AND deleted_flag=NO_FLAG AND
2705: ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND NOT EXISTS
2706: (SELECT NULL FROM CZ_MODEL_REF_EXPLS
2707: WHERE model_id=a.component_id AND ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND deleted_flag=NO_FLAG))
2708: LOOP
2709: update_layer(i.component_id);
2710: END LOOP;

Line 2720: FOR i IN (SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS

2716:
2717: PROCEDURE delete_duplicates(p_model_id IN NUMBER) IS
2718:
2719: BEGIN
2720: FOR i IN (SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS
2721: WHERE component_id=p_model_id AND referring_node_id IS NOT NULL
2722: AND deleted_flag=NO_FLAG)
2723: LOOP
2724: UPDATE CZ_MODEL_REF_EXPLS a

Line 2724: UPDATE CZ_MODEL_REF_EXPLS a

2720: FOR i IN (SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS
2721: WHERE component_id=p_model_id AND referring_node_id IS NOT NULL
2722: AND deleted_flag=NO_FLAG)
2723: LOOP
2724: UPDATE CZ_MODEL_REF_EXPLS a
2725: SET deleted_flag = '1'
2726: WHERE model_id=i.model_id AND deleted_flag=NO_FLAG
2727: AND referring_node_id IS NOT NULL
2728: AND parent_expl_node_id IN

Line 2729: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

2725: SET deleted_flag = '1'
2726: WHERE model_id=i.model_id AND deleted_flag=NO_FLAG
2727: AND referring_node_id IS NOT NULL
2728: AND parent_expl_node_id IN
2729: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2730: WHERE model_id=i.model_id AND deleted_flag=NO_FLAG
2731: AND referring_node_id=a.referring_node_id);
2732: END LOOP;
2733:

Line 2734: FOR i IN (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS

2730: WHERE model_id=i.model_id AND deleted_flag=NO_FLAG
2731: AND referring_node_id=a.referring_node_id);
2732: END LOOP;
2733:
2734: FOR i IN (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS
2735: WHERE model_id=p_model_id AND referring_node_id IS NOT NULL
2736: AND deleted_flag=NO_FLAG)
2737: LOOP
2738: UPDATE CZ_MODEL_REF_EXPLS a

Line 2738: UPDATE CZ_MODEL_REF_EXPLS a

2734: FOR i IN (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS
2735: WHERE model_id=p_model_id AND referring_node_id IS NOT NULL
2736: AND deleted_flag=NO_FLAG)
2737: LOOP
2738: UPDATE CZ_MODEL_REF_EXPLS a
2739: SET deleted_flag = '1'
2740: WHERE model_id=i.component_id AND deleted_flag=NO_FLAG
2741: AND referring_node_id IS NOT NULL
2742: AND parent_expl_node_id IN

Line 2743: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

2739: SET deleted_flag = '1'
2740: WHERE model_id=i.component_id AND deleted_flag=NO_FLAG
2741: AND referring_node_id IS NOT NULL
2742: AND parent_expl_node_id IN
2743: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2744: WHERE model_id=i.component_id AND deleted_flag=NO_FLAG
2745: AND referring_node_id=a.referring_node_id);
2746: END LOOP;
2747: END delete_duplicates;

Line 2819: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2815:
2816: t_child_nodes IntArray;
2817: t_childs IntArray;
2818:
2819: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2820: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2821: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2822: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2823: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

Line 2820: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2816: t_child_nodes IntArray;
2817: t_childs IntArray;
2818:
2819: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2820: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2821: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2822: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2823: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2824: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

Line 2821: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;

2817: t_childs IntArray;
2818:
2819: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2820: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2821: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2822: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2823: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2824: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
2825: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;

Line 2822: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2818:
2819: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2820: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2821: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2822: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2823: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2824: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
2825: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2826:

Line 2823: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2819: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2820: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2821: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2822: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2823: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2824: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
2825: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2826:
2827: v_up_id CZ_PS_NODES.ps_node_id%TYPE;

Line 2824: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

2820: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2821: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2822: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2823: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2824: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
2825: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2826:
2827: v_up_id CZ_PS_NODES.ps_node_id%TYPE;
2828: v_virtual_flag CZ_PS_NODES.virtual_flag%TYPE;

Line 2825: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;

2821: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2822: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2823: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2824: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
2825: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2826:
2827: v_up_id CZ_PS_NODES.ps_node_id%TYPE;
2828: v_virtual_flag CZ_PS_NODES.virtual_flag%TYPE;
2829: v_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

Line 2934: FROM CZ_MODEL_REF_EXPLS

2930: BEGIN
2931: v_node_Exist:=FALSE;
2932: SELECT model_ref_expl_id,parent_expl_node_id,ps_node_type,virtual_flag,expl_node_type
2933: INTO v_model_ref_expl_id,v_parent_expl_node_id,v_ps_node_type,v_virtual_flag,v_curr_expl_node_type
2934: FROM CZ_MODEL_REF_EXPLS
2935: WHERE ((component_id=p_ps_node_id AND referring_node_id IS NULL) OR
2936: referring_node_id=p_ps_node_id)
2937: AND model_id=p_model_id AND deleted_flag=NO_FLAG AND ROWNUM<2;
2938: v_node_Exist:=TRUE;

Line 2979: -- exist in CZ_MODEL_REF_EXPLS table

2975:
2976: --
2977: -- case when we have Min=1 and Max=1 for not Connectors/References nodes
2978: -- and this node with ps_node_id=p_ps_node_id does not
2979: -- exist in CZ_MODEL_REF_EXPLS table
2980: -- and no Numeric Rules which contribute to Min/Max are specified
2981: -- in this case we just need to exit from program
2982: --
2983: IF (v_expl_node_type=MANDATORY_EXPL_TYPE) AND (v_ps_node_type NOT IN(REFERENCE_TYPE,CONNECTOR_TYPE))

Line 3003: UPDATE CZ_MODEL_REF_EXPLS

2999:
3000: IF SQL%ROWCOUNT>0 THEN
3001:
3002: IF (v_ps_node_type NOT IN(REFERENCE_TYPE,CONNECTOR_TYPE)) THEN
3003: UPDATE CZ_MODEL_REF_EXPLS
3004: SET virtual_flag=p_out_virtual_flag,
3005: expl_node_type=v_expl_node_type
3006: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG;
3007: ELSE

Line 3008: UPDATE CZ_MODEL_REF_EXPLS

3004: SET virtual_flag=p_out_virtual_flag,
3005: expl_node_type=v_expl_node_type
3006: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG;
3007: ELSE
3008: UPDATE CZ_MODEL_REF_EXPLS
3009: SET virtual_flag=p_out_virtual_flag,
3010: expl_node_type=v_expl_node_type
3011: WHERE referring_node_id=p_ps_node_id AND deleted_flag=NO_FLAG;
3012: END IF;

Line 3037: FOR x IN (SELECT model_ref_expl_id,parent_expl_node_id,model_id FROM CZ_MODEL_REF_EXPLS a

3033: --
3034: IF p_out_virtual_flag=YES_FLAG AND
3035: (v_ps_node_type NOT IN(REFERENCE_TYPE,CONNECTOR_TYPE)) AND v_node_Exist THEN
3036:
3037: FOR x IN (SELECT model_ref_expl_id,parent_expl_node_id,model_id FROM CZ_MODEL_REF_EXPLS a
3038: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
3039: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3040: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3041: LOOP

Line 3052: FOR y IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3048: -- DEBUG ERROR CODE --
3049: --
3050: ERROR_CODE:=905;
3051:
3052: FOR y IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3053: START WITH model_ref_expl_id=x.model_ref_expl_id AND deleted_flag=NO_FLAG
3054: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
3055: PRIOR deleted_flag=NO_FLAG)
3056: LOOP

Line 3057: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-1

3053: START WITH model_ref_expl_id=x.model_ref_expl_id AND deleted_flag=NO_FLAG
3054: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
3055: PRIOR deleted_flag=NO_FLAG)
3056: LOOP
3057: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-1
3058: WHERE model_ref_expl_id=y.model_ref_expl_id;
3059: END LOOP;
3060:
3061: --

Line 3066: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=x.parent_expl_node_id

3062: -- DEBUG ERROR CODE --
3063: --
3064: ERROR_CODE:=906;
3065:
3066: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=x.parent_expl_node_id
3067: WHERE parent_expl_node_id=x.model_ref_expl_id
3068: AND model_id=x.model_id AND deleted_flag=NO_FLAG;
3069:
3070: EXCEPTION

Line 3122: INSERT INTO CZ_MODEL_REF_EXPLS

3118: -- DEBUG ERROR CODE --
3119: --
3120: ERROR_CODE:=910;
3121:
3122: INSERT INTO CZ_MODEL_REF_EXPLS
3123: (model_ref_expl_id,
3124: parent_expl_node_id,
3125: referring_node_id,
3126: model_id,

Line 3159: (SELECT component_id FROM CZ_MODEL_REF_EXPLS

3155: SELECT ps_node_id BULK COLLECT INTO t_childs FROM CZ_PS_NODES
3156: WHERE devl_project_id=p_model_id AND ps_node_id<>p_ps_node_id AND
3157: (
3158: (ps_node_type in(COMPONENT_TYPE,PRODUCT_TYPE) AND ps_node_id IN ---- fix for bug #3161931
3159: (SELECT component_id FROM CZ_MODEL_REF_EXPLS
3160: WHERE model_id=p_model_id AND deleted_flag=NO_FLAG AND parent_expl_node_id=v_up_expl_id AND
3161: component_id IN(SELECT ps_node_id FROM CZ_PS_NODES
3162: START WITH ps_node_id=p_ps_node_id AND deleted_flag=NO_FLAG
3163: CONNECT BY PRIOR ps_node_id=parent_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)

Line 3168: (SELECT referring_node_id FROM CZ_MODEL_REF_EXPLS

3164: )
3165: )
3166: OR
3167: (ps_node_type in(REFERENCE_TYPE,CONNECTOR_TYPE) AND ps_node_id IN ---- fix for bug #3161931
3168: (SELECT referring_node_id FROM CZ_MODEL_REF_EXPLS
3169: WHERE model_id=p_model_id AND deleted_flag=NO_FLAG AND parent_expl_node_id=v_up_expl_id AND
3170: referring_node_id IN(SELECT ps_node_id FROM CZ_PS_NODES
3171: START WITH ps_node_id=p_ps_node_id AND deleted_flag=NO_FLAG
3172: CONNECT BY PRIOR ps_node_id=parent_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)

Line 3187: UPDATE CZ_MODEL_REF_EXPLS

3183: FOR t IN t_childs.FIRST..t_childs.LAST
3184: LOOP
3185: t_child_nodes.DELETE;
3186: v_ps_node_id:= t_childs(t);
3187: UPDATE CZ_MODEL_REF_EXPLS
3188: SET parent_expl_node_id=v_expl_id
3189: WHERE parent_expl_node_id=v_up_expl_id
3190: AND model_id=p_model_id AND
3191: ((ps_node_type IN(PRODUCT_TYPE,COMPONENT_TYPE,BOM_MODEL_TYPE) AND component_id=v_ps_node_id)

Line 3204: UPDATE CZ_MODEL_REF_EXPLS

3200: --
3201: ERROR_CODE:=913;
3202:
3203: FORALL h IN t_child_nodes.FIRST..t_child_nodes.LAST
3204: UPDATE CZ_MODEL_REF_EXPLS
3205: SET node_depth=node_depth+1
3206: WHERE model_ref_expl_id IN
3207: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3208: START WITH model_ref_expl_id=t_child_nodes(h) AND deleted_flag=NO_FLAG

Line 3207: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3203: FORALL h IN t_child_nodes.FIRST..t_child_nodes.LAST
3204: UPDATE CZ_MODEL_REF_EXPLS
3205: SET node_depth=node_depth+1
3206: WHERE model_ref_expl_id IN
3207: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3208: START WITH model_ref_expl_id=t_child_nodes(h) AND deleted_flag=NO_FLAG
3209: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3210: AND PRIOR deleted_flag=NO_FLAG);
3211:

Line 3251: FROM CZ_MODEL_REF_EXPLS

3247:
3248: set_Expls(p_model_id,p_ps_node_id, PLUS_MODE);
3249:
3250: SELECT MIN(model_ref_expl_id) INTO v_comp_expl_id
3251: FROM CZ_MODEL_REF_EXPLS
3252: WHERE model_id=p_model_id AND component_id=v_component_id AND
3253: deleted_flag='0';
3254:
3255: refresh_UI_Expl_Ids(p_ps_node_id => p_ps_node_id,

Line 3330: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a

3326: p_out_err:=0;
3327:
3328: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
3329:
3330: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3331: WHERE referring_node_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
3332: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3333: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3334: LOOP

Line 3353: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a

3349: SELECT component_id,NVL(virtual_flag,'1') INTO v_component_id,v_virtual_flag FROM CZ_PS_NODES
3350: WHERE ps_node_id=p_ps_node_id;
3351:
3352: IF v_virtual_flag='0' THEN
3353: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3354: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
3355: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3356: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3357: LOOP

Line 3374: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a

3370: END LOOP;
3371:
3372: ELSE
3373:
3374: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3375: WHERE parent_expl_node_id IN
3376: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3377: WHERE model_id=a.model_id AND component_id=v_component_id AND deleted_flag='0')
3378: AND (component_id IN

Line 3376: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3372: ELSE
3373:
3374: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3375: WHERE parent_expl_node_id IN
3376: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3377: WHERE model_id=a.model_id AND component_id=v_component_id AND deleted_flag='0')
3378: AND (component_id IN
3379: (SELECT ps_node_id FROM CZ_PS_NODES
3380: START WITH ps_node_id=p_ps_node_id

Line 3423: FOR i IN(SELECT model_ref_expl_id,parent_expl_node_id FROM CZ_MODEL_REF_EXPLS

3419: p_level IN INTEGER,
3420: p_tree_level IN INTEGER) IS
3421:
3422: BEGIN
3423: FOR i IN(SELECT model_ref_expl_id,parent_expl_node_id FROM CZ_MODEL_REF_EXPLS
3424: WHERE parent_expl_node_id=p_expl_id AND deleted_flag=NO_FLAG)
3425: LOOP
3426: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=p_level+p_tree_level
3427: WHERE model_ref_expl_id=i.model_ref_expl_id;

Line 3426: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=p_level+p_tree_level

3422: BEGIN
3423: FOR i IN(SELECT model_ref_expl_id,parent_expl_node_id FROM CZ_MODEL_REF_EXPLS
3424: WHERE parent_expl_node_id=p_expl_id AND deleted_flag=NO_FLAG)
3425: LOOP
3426: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=p_level+p_tree_level
3427: WHERE model_ref_expl_id=i.model_ref_expl_id;
3428:
3429: --
3430: -- DEBUG ERROR CODE --

Line 3464: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

3460: t_refs IntArray;
3461: t_models IntArray;
3462: t_model_ref_expl IntArray;
3463: t_model_ref_expl_ IntArray;
3464: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3465: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3466: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3467: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3468: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

Line 3465: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

3461: t_models IntArray;
3462: t_model_ref_expl IntArray;
3463: t_model_ref_expl_ IntArray;
3464: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3465: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3466: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3467: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3468: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3469: STOP_IT EXCEPTION;

Line 3466: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

3462: t_model_ref_expl IntArray;
3463: t_model_ref_expl_ IntArray;
3464: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3465: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3466: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3467: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3468: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3469: STOP_IT EXCEPTION;
3470:

Line 3467: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

3463: t_model_ref_expl_ IntArray;
3464: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3465: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3466: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3467: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3468: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3469: STOP_IT EXCEPTION;
3470:
3471: BEGIN

Line 3468: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

3464: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3465: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3466: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3467: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3468: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3469: STOP_IT EXCEPTION;
3470:
3471: BEGIN
3472:

Line 3484: FROM CZ_MODEL_REF_EXPLS a

3480: -- a moved node in source Model
3481: --
3482: SELECT model_ref_expl_id,model_id
3483: BULK COLLECT INTO t_refs,t_models
3484: FROM CZ_MODEL_REF_EXPLS a
3485: WHERE child_model_expl_id=p_expl_root_id
3486: AND ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND deleted_flag=NO_FLAG AND
3487: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3488: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);

Line 3512: SELECT model_ref_expl_id INTO v_from_up_expl_id FROM CZ_MODEL_REF_EXPLS a

3508: -- DEBUG ERROR CODE --
3509: --
3510: ERROR_CODE:=1202;
3511:
3512: SELECT model_ref_expl_id INTO v_from_up_expl_id FROM CZ_MODEL_REF_EXPLS a
3513: WHERE child_model_expl_id=p_from_expl_id AND model_ref_expl_id
3514: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3515: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3516: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND

Line 3514: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3510: ERROR_CODE:=1202;
3511:
3512: SELECT model_ref_expl_id INTO v_from_up_expl_id FROM CZ_MODEL_REF_EXPLS a
3513: WHERE child_model_expl_id=p_from_expl_id AND model_ref_expl_id
3514: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3515: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3516: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
3517: deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
3518: AND

Line 3528: INTO v_up_expl_id,v_up_level FROM CZ_MODEL_REF_EXPLS a

3524: --
3525: ERROR_CODE:=1203;
3526:
3527: SELECT model_ref_expl_id,node_depth
3528: INTO v_up_expl_id,v_up_level FROM CZ_MODEL_REF_EXPLS a
3529: WHERE child_model_expl_id=p_up_expl_id AND model_ref_expl_id
3530: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3531: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3532: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)

Line 3530: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3526:
3527: SELECT model_ref_expl_id,node_depth
3528: INTO v_up_expl_id,v_up_level FROM CZ_MODEL_REF_EXPLS a
3529: WHERE child_model_expl_id=p_up_expl_id AND model_ref_expl_id
3530: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3531: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3532: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
3533: AND
3534: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

Line 3544: UPDATE CZ_MODEL_REF_EXPLS

3540: ERROR_CODE:=1204;
3541:
3542: FOR k IN p_model_ref_expl.FIRST..p_model_ref_expl.LAST
3543: LOOP
3544: UPDATE CZ_MODEL_REF_EXPLS
3545: SET parent_expl_node_id=v_up_expl_id
3546: WHERE model_ref_expl_id
3547: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3548: WHERE (parent_expl_node_id=v_from_up_expl_id OR model_ref_expl_id=v_from_up_expl_id)

Line 3547: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3543: LOOP
3544: UPDATE CZ_MODEL_REF_EXPLS
3545: SET parent_expl_node_id=v_up_expl_id
3546: WHERE model_ref_expl_id
3547: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3548: WHERE (parent_expl_node_id=v_from_up_expl_id OR model_ref_expl_id=v_from_up_expl_id)
3549: AND child_model_expl_id=p_model_ref_expl(k)
3550: AND deleted_flag=NO_FLAG);
3551:

Line 3575: FROM CZ_MODEL_REF_EXPLS

3571: -- recreate array of child_model_expl_id-s --
3572: --
3573: SELECT model_ref_expl_id,node_depth
3574: BULK COLLECT INTO t_model_ref_expl_,t_levels_
3575: FROM CZ_MODEL_REF_EXPLS
3576: WHERE parent_expl_node_id=v_up_expl_id
3577: AND child_model_expl_id=p_model_ref_expl(k)
3578: AND deleted_flag=NO_FLAG;
3579:

Line 3650: v_ref_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

3646: err INTEGER;
3647: v_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
3648: v_virtual_flag CZ_PS_NODES.virtual_flag%TYPE;
3649:
3650: v_ref_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3651: v_ref_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3652: v_contains_non_virt BOOLEAN:=FALSE;
3653: v_circularity_exists BOOLEAN:=FALSE;
3654: v_comp_expl_id NUMBER;

Line 3651: v_ref_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

3647: v_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
3648: v_virtual_flag CZ_PS_NODES.virtual_flag%TYPE;
3649:
3650: v_ref_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3651: v_ref_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3652: v_contains_non_virt BOOLEAN:=FALSE;
3653: v_circularity_exists BOOLEAN:=FALSE;
3654: v_comp_expl_id NUMBER;
3655: v_model_ref_expl_id NUMBER;

Line 3717: FROM CZ_MODEL_REF_EXPLS

3713:
3714: v_from_up_id:=p_from_ps_node_id;
3715: SELECT model_ref_expl_id,node_depth
3716: INTO v_from_up_expl_id,v_from_up_level
3717: FROM CZ_MODEL_REF_EXPLS
3718: WHERE model_id=p_project_id AND referring_node_id=p_from_ps_node_id
3719: AND deleted_flag=NO_FLAG;
3720:
3721: BEGIN

Line 3724: FROM CZ_MODEL_REF_EXPLS

3720:
3721: BEGIN
3722: SELECT model_ref_expl_id,node_depth
3723: INTO v_ref_up_expl_id,v_ref_up_level
3724: FROM CZ_MODEL_REF_EXPLS
3725: WHERE component_id=v_up_id
3726: AND model_id=p_project_id AND deleted_flag=NO_FLAG;
3727:
3728: UPDATE CZ_MODEL_REF_EXPLS

Line 3728: UPDATE CZ_MODEL_REF_EXPLS

3724: FROM CZ_MODEL_REF_EXPLS
3725: WHERE component_id=v_up_id
3726: AND model_id=p_project_id AND deleted_flag=NO_FLAG;
3727:
3728: UPDATE CZ_MODEL_REF_EXPLS
3729: SET parent_expl_node_id=v_ref_up_expl_id
3730: WHERE model_ref_expl_id=v_from_up_expl_id
3731: AND deleted_flag=NO_FLAG;
3732:

Line 3733: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_ref_up_level+1

3729: SET parent_expl_node_id=v_ref_up_expl_id
3730: WHERE model_ref_expl_id=v_from_up_expl_id
3731: AND deleted_flag=NO_FLAG;
3732:
3733: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_ref_up_level+1
3734: WHERE model_ref_expl_id IN
3735: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3736: START WITH model_ref_expl_id=v_from_up_expl_id AND deleted_flag=NO_FLAG
3737: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG

Line 3735: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3731: AND deleted_flag=NO_FLAG;
3732:
3733: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_ref_up_level+1
3734: WHERE model_ref_expl_id IN
3735: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3736: START WITH model_ref_expl_id=v_from_up_expl_id AND deleted_flag=NO_FLAG
3737: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3738: AND PRIOR deleted_flag=NO_FLAG);
3739: EXCEPTION

Line 3752: FOR k IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS WHERE

3748:
3749: IF t_chain.COUNT>0 THEN
3750: FOR i IN t_chain.FIRST..t_chain.LAST
3751: LOOP
3752: FOR k IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS WHERE
3753: model_id=t_chain(i).model_id AND ps_node_type IN(REFERENCE_TYPE,264)
3754: AND component_id=p_project_id AND deleted_flag=NO_FLAG)
3755: LOOP
3756: BEGIN

Line 3759: FROM CZ_MODEL_REF_EXPLS

3755: LOOP
3756: BEGIN
3757: SELECT model_ref_expl_id,node_depth
3758: INTO v_ref_up_expl_id,v_ref_up_level
3759: FROM CZ_MODEL_REF_EXPLS
3760: WHERE component_id=v_up_id
3761: AND model_ref_expl_id IN
3762: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3763: START WITH model_ref_expl_id=k.model_ref_expl_id AND deleted_flag=NO_FLAG

Line 3762: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3758: INTO v_ref_up_expl_id,v_ref_up_level
3759: FROM CZ_MODEL_REF_EXPLS
3760: WHERE component_id=v_up_id
3761: AND model_ref_expl_id IN
3762: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3763: START WITH model_ref_expl_id=k.model_ref_expl_id AND deleted_flag=NO_FLAG
3764: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3765: AND PRIOR deleted_flag=NO_FLAG);
3766:

Line 3768: UPDATE CZ_MODEL_REF_EXPLS

3764: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3765: AND PRIOR deleted_flag=NO_FLAG);
3766:
3767:
3768: UPDATE CZ_MODEL_REF_EXPLS
3769: SET parent_expl_node_id=v_ref_up_expl_id
3770: WHERE model_ref_expl_id IN
3771: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3772: WHERE referring_node_id=p_from_ps_node_id

Line 3771: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a

3767:
3768: UPDATE CZ_MODEL_REF_EXPLS
3769: SET parent_expl_node_id=v_ref_up_expl_id
3770: WHERE model_ref_expl_id IN
3771: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3772: WHERE referring_node_id=p_from_ps_node_id
3773: AND model_ref_expl_id IN
3774: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3775: START WITH model_ref_expl_id=k.model_ref_expl_id AND deleted_flag=NO_FLAG

Line 3774: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3770: WHERE model_ref_expl_id IN
3771: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3772: WHERE referring_node_id=p_from_ps_node_id
3773: AND model_ref_expl_id IN
3774: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3775: START WITH model_ref_expl_id=k.model_ref_expl_id AND deleted_flag=NO_FLAG
3776: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3777: AND PRIOR deleted_flag=NO_FLAG) AND
3778: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

Line 3782: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-var_subroot_level+v_ref_up_level+1

3778: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3779: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3780: RETURNING model_ref_expl_id,node_depth INTO var_subroot_id,var_subroot_level ;
3781:
3782: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-var_subroot_level+v_ref_up_level+1
3783: WHERE model_ref_expl_id IN
3784: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3785: START WITH model_ref_expl_id=var_subroot_id AND deleted_flag=NO_FLAG
3786: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 3784: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3780: RETURNING model_ref_expl_id,node_depth INTO var_subroot_id,var_subroot_level ;
3781:
3782: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-var_subroot_level+v_ref_up_level+1
3783: WHERE model_ref_expl_id IN
3784: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3785: START WITH model_ref_expl_id=var_subroot_id AND deleted_flag=NO_FLAG
3786: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
3787: PRIOR deleted_flag=NO_FLAG);
3788:

Line 3815: FROM CZ_MODEL_REF_EXPLS

3811: ERROR_CODE:=1303;
3812:
3813: SELECT model_ref_expl_id
3814: BULK COLLECT INTO t_model_ref_expl
3815: FROM CZ_MODEL_REF_EXPLS
3816: WHERE parent_expl_node_id=v_from_up_expl_id AND model_id=p_project_id AND
3817: component_id IN(SELECT ps_node_id FROM CZ_PS_NODES
3818: START WITH ps_node_id=p_from_ps_node_id AND deleted_flag=NO_FLAG
3819: CONNECT BY PRIOR ps_node_id=parent_id AND deleted_flag=NO_FLAG

Line 3837: FROM CZ_MODEL_REF_EXPLS

3833:
3834: v_from_up_id:=p_from_ps_node_id;
3835: SELECT model_ref_expl_id,node_depth
3836: INTO v_from_up_expl_id,v_from_up_level
3837: FROM CZ_MODEL_REF_EXPLS
3838: WHERE model_id=p_project_id AND component_id=v_from_up_id
3839: AND ps_node_type NOT IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND child_model_expl_id IS NULL AND
3840: deleted_flag=NO_FLAG;
3841: t_model_ref_expl(1):=v_from_up_expl_id;

Line 3861: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=v_up_expl_id

3857: -- DEBUG ERROR CODE --
3858: --
3859: ERROR_CODE:=1307;
3860:
3861: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=v_up_expl_id
3862: WHERE model_ref_expl_id=t_model_ref_expl(i)
3863: AND model_id=p_project_id;
3864:
3865: --

Line 3870: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_up_level+1

3866: -- DEBUG ERROR CODE --
3867: --
3868: ERROR_CODE:=1308;
3869:
3870: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_up_level+1
3871: WHERE model_ref_expl_id IN
3872: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3873: START WITH model_ref_expl_id=t_model_ref_expl(i) AND deleted_flag=NO_FLAG
3874: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 3872: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3868: ERROR_CODE:=1308;
3869:
3870: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_up_level+1
3871: WHERE model_ref_expl_id IN
3872: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3873: START WITH model_ref_expl_id=t_model_ref_expl(i) AND deleted_flag=NO_FLAG
3874: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
3875: PRIOR deleted_flag=NO_FLAG);
3876:

Line 3892: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id AND component_id=p_project_id

3888: --
3889: ERROR_CODE:=1310;
3890:
3891: SELECT model_ref_expl_id INTO v_expl_root_id
3892: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id AND component_id=p_project_id
3893: AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
3894:
3895: --
3896: -- DEBUG ERROR CODE --

Line 3909: SELECT node_depth INTO v_temp FROM CZ_MODEL_REF_EXPLS

3905: -- DEBUG ERROR CODE --
3906: --
3907: ERROR_CODE:=1312;
3908:
3909: SELECT node_depth INTO v_temp FROM CZ_MODEL_REF_EXPLS
3910: WHERE model_id=p_project_id AND model_ref_expl_id=t_model_ref_expl(t);
3911: t_levels(t_levels.COUNT+1):=v_temp;
3912:
3913: --

Line 3941: FROM CZ_MODEL_REF_EXPLS

3937: IF v_virtual_flag=YES_FLAG THEN
3938: update_Rules(p_from_ps_node_id);
3939:
3940: SELECT MIN(model_ref_expl_id) INTO v_comp_expl_id
3941: FROM CZ_MODEL_REF_EXPLS
3942: WHERE model_id=p_project_id AND component_id=v_component_id AND
3943: deleted_flag='0';
3944:
3945: SELECT MIN(model_ref_expl_id) INTO v_comp_expl_id

Line 3946: FROM CZ_MODEL_REF_EXPLS

3942: WHERE model_id=p_project_id AND component_id=v_component_id AND
3943: deleted_flag='0';
3944:
3945: SELECT MIN(model_ref_expl_id) INTO v_comp_expl_id
3946: FROM CZ_MODEL_REF_EXPLS
3947: WHERE model_id=p_project_id AND component_id=
3948: (SELECT component_id FROM CZ_PS_NODES WHERE ps_node_id=p_to_ps_node_id) AND
3949: deleted_flag='0';
3950:

Line 4050: FOR n IN(SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a

4046: END IF;
4047:
4048: IF v_BOM_node2>0 THEN
4049: -- check models that reference the current model ( p_refroot_model_id )
4050: FOR n IN(SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a
4051: WHERE component_id=p_refroot_model_id AND ps_node_type=REFERENCE_TYPE AND
4052: deleted_flag='0' AND
4053: EXISTS(SELECT NULL FROM CZ_RP_ENTRIES WHERE object_id=a.model_id AND
4054: object_type='PRJ' AND deleted_flag='0'))

Line 4105: UPDATE CZ_MODEL_REF_EXPLS a SET deleted_flag=YES_FLAG

4101: -- DEBUG ERROR CODE --
4102: --
4103: ERROR_CODE:=1500;
4104:
4105: UPDATE CZ_MODEL_REF_EXPLS a SET deleted_flag=YES_FLAG
4106: WHERE child_model_expl_id=t_arr(i) AND
4107: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4108: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG)
4109: RETURNING model_ref_expl_id BULK COLLECT INTO temp_arr;

Line 4139: FOR j IN(SELECT model_ref_expl_id,ps_node_type,component_id FROM CZ_MODEL_REF_EXPLS

4135:
4136: PROCEDURE delete_subtree(p_model_id IN INTEGER,p_model_ref_expl_id IN INTEGER) IS
4137: t_arr IntArray;
4138: BEGIN
4139: FOR j IN(SELECT model_ref_expl_id,ps_node_type,component_id FROM CZ_MODEL_REF_EXPLS
4140: WHERE model_id=p_model_id AND parent_expl_node_id=p_model_ref_expl_id AND deleted_flag=NO_FLAG)
4141: LOOP
4142: IF j.ps_node_type=CONNECTOR_TYPE THEN
4143: t_arr.DELETE;

Line 4150: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

4146: -- DEBUG ERROR CODE --
4147: --
4148: ERROR_CODE:=1600;
4149:
4150: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
4151: WHERE model_ref_expl_id IN(
4152: SELECT model_ref_expl_id FROM cz_model_ref_expls
4153: START WITH model_ref_expl_id=j.model_ref_expl_id AND deleted_flag=NO_FLAG
4154: CONNECT by PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG

Line 4152: SELECT model_ref_expl_id FROM cz_model_ref_expls

4148: ERROR_CODE:=1600;
4149:
4150: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
4151: WHERE model_ref_expl_id IN(
4152: SELECT model_ref_expl_id FROM cz_model_ref_expls
4153: START WITH model_ref_expl_id=j.model_ref_expl_id AND deleted_flag=NO_FLAG
4154: CONNECT by PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
4155: AND PRIOR deleted_flag=NO_FLAG);
4156:

Line 4185: FOR i IN(SELECT model_ref_expl_id,ps_node_type FROM CZ_MODEL_REF_EXPLS

4181:
4182: PROCEDURE change_structure_(p_model_id IN INTEGER) IS
4183:
4184: BEGIN
4185: FOR i IN(SELECT model_ref_expl_id,ps_node_type FROM CZ_MODEL_REF_EXPLS
4186: WHERE model_id=p_model_id AND component_id=p_model_id AND
4187: ps_node_type IN(CONNECTOR_TYPE,REFERENCE_TYPE) AND deleted_flag=NO_FLAG)
4188: LOOP
4189: delete_subtree(p_model_id,i.model_ref_expl_id);

Line 4199: FOR i IN(SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS

4195:
4196: PROCEDURE change_structure(p_model_id IN INTEGER) IS
4197:
4198: BEGIN
4199: FOR i IN(SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS
4200: WHERE component_id=p_model_id AND
4201: ps_node_type IN(CONNECTOR_TYPE,REFERENCE_TYPE) AND deleted_flag=NO_FLAG)
4202: LOOP
4203: change_structure_(i.model_id);

Line 4221: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_model_id AND ps_node_type=REFERENCE_TYPE

4217: BEGIN
4218:
4219: SELECT DISTINCT model_id BULK COLLECT INTO t_m_chain_tbl FROM
4220: (SELECT DISTINCT component_id AS model_id
4221: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_model_id AND ps_node_type=REFERENCE_TYPE
4222: AND deleted_flag=NO_FLAG
4223: UNION
4224: SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a
4225: WHERE component_id=p_model_id AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND

Line 4224: SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a

4220: (SELECT DISTINCT component_id AS model_id
4221: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_model_id AND ps_node_type=REFERENCE_TYPE
4222: AND deleted_flag=NO_FLAG
4223: UNION
4224: SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a
4225: WHERE component_id=p_model_id AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4226: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4227: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG));
4228:

Line 4238: UPDATE cz_model_ref_expls

4234: -- set has_trackable_children to '1' for those references in explosion tree of t_m_chain_tbl(i) model
4235: -- which points to models which have CZ_PS_NODES.ib_trackable='1'. So here we assume
4236: -- that CZ_PS_NODES.ib_trackable is populated correctly by Import
4237: --
4238: UPDATE cz_model_ref_expls
4239: SET has_trackable_children='1'
4240: WHERE model_id=t_m_chain_tbl(i) AND component_id=t_m_chain_tbl(i) AND deleted_flag=NO_FLAG AND
4241: EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS m WHERE model_id=t_m_chain_tbl(i) AND ps_node_type=REFERENCE_TYPE
4242: AND deleted_flag=NO_FLAG AND

Line 4241: EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS m WHERE model_id=t_m_chain_tbl(i) AND ps_node_type=REFERENCE_TYPE

4237: --
4238: UPDATE cz_model_ref_expls
4239: SET has_trackable_children='1'
4240: WHERE model_id=t_m_chain_tbl(i) AND component_id=t_m_chain_tbl(i) AND deleted_flag=NO_FLAG AND
4241: EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS m WHERE model_id=t_m_chain_tbl(i) AND ps_node_type=REFERENCE_TYPE
4242: AND deleted_flag=NO_FLAG AND
4243: EXISTS(SELECT NULL FROM CZ_PS_NODES
4244: WHERE devl_project_id = m.component_id AND
4245: ib_trackable = '1' AND deleted_flag = NO_FLAG));

Line 4268: UPDATE CZ_MODEL_REF_EXPLS SET has_trackable_children=v_ib_trackable

4264: IF v_ib_trackable=NO_FLAG THEN
4265: t_nontrk_tbl(t_nontrk_tbl.COUNT+1):=t_m_chain_tbl(i);
4266: END IF;
4267:
4268: UPDATE CZ_MODEL_REF_EXPLS SET has_trackable_children=v_ib_trackable
4269: WHERE model_id=t_m_chain_tbl(i) AND component_id=t_m_chain_tbl(i) AND deleted_flag=NO_FLAG;
4270:
4271: END LOOP;
4272:

Line 4275: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children='1'

4271: END LOOP;
4272:
4273: IF t_trk_tbl.COUNT>0 THEN
4274: FORALL i IN t_trk_tbl.First..t_trk_tbl.Last
4275: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children='1'
4276: WHERE component_id=t_trk_tbl(i) AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4277: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4278: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
4279: END IF;

Line 4283: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children=NO_FLAG

4279: END IF;
4280:
4281: IF t_nontrk_tbl.COUNT>0 THEN
4282: FORALL i IN t_nontrk_tbl.First..t_nontrk_tbl.Last
4283: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children=NO_FLAG
4284: WHERE component_id=t_nontrk_tbl(i) AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4285: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4286: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
4287: END IF;