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 188: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;

184:
185: FUNCTION allocate_Expl_Id RETURN NUMBER IS
186: v_next_id NUMBER;
187: BEGIN
188: SELECT CZ_MODEL_REF_EXPLS_S.NEXTVAL INTO v_next_id FROM dual;
189: RETURN v_next_id;
190: END allocate_Expl_Id;
191:
192: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 196: v_expl_node_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

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

Line 198: SELECT model_ref_expl_id INTO v_expl_node_id FROM CZ_MODEL_REF_EXPLS

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

Line 218: (SELECT component_id FROM CZ_MODEL_REF_EXPLS

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

Line 250: UPDATE CZ_MODEL_REF_EXPLS

246: v_model_ref_expl_id INTEGER;
247:
248: BEGIN
249: IF p_node_depth IS NULL THEN
250: UPDATE CZ_MODEL_REF_EXPLS
251: SET node_depth=0
252: WHERE model_id=p_model_id AND parent_expl_node_id IS NULL
253: AND deleted_flag=NO_FLAG
254: RETURNING model_ref_expl_id INTO v_model_ref_expl_id;

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

254: RETURNING model_ref_expl_id INTO v_model_ref_expl_id;
255: update_Node_Depth_(p_model_id,v_model_ref_expl_id,0);
256: ELSE
257: v_node_depth:=p_node_depth+1;
258: FOR i IN(SELECT model_ref_expl_id,referring_node_id,ps_node_type FROM CZ_MODEL_REF_EXPLS
259: WHERE model_id=p_model_id AND parent_expl_node_id=p_expl_id
260: AND deleted_flag=NO_FLAG)
261: LOOP
262: UPDATE CZ_MODEL_REF_EXPLS

Line 262: UPDATE CZ_MODEL_REF_EXPLS

258: FOR i IN(SELECT model_ref_expl_id,referring_node_id,ps_node_type FROM CZ_MODEL_REF_EXPLS
259: WHERE model_id=p_model_id AND parent_expl_node_id=p_expl_id
260: AND deleted_flag=NO_FLAG)
261: LOOP
262: UPDATE CZ_MODEL_REF_EXPLS
263: SET node_depth=v_node_depth
264: WHERE model_ref_expl_id=i.model_ref_expl_id AND node_depth<>v_node_depth;
265:
266: --

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

279: END update_Node_Depth_;
280:
281: BEGIN
282: t_nodes_to_delete_tbl.DELETE;
283: FOR i IN(SELECT DISTINCT model_id FROM cz_model_ref_expls
284: WHERE ((component_id=p_model_id AND
285: ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE)) OR model_id=p_model_id)
286: AND deleted_flag=NO_FLAG)
287: LOOP

Line 296: UPDATE CZ_MODEL_REF_EXPLS

292: -- temporary workaround to delete possible reference duplicates
293: --
294: IF t_nodes_to_delete_tbl.COUNT>0 THEN
295: FORALL i IN t_nodes_to_delete_tbl.FIRST..t_nodes_to_delete_tbl.LAST
296: UPDATE CZ_MODEL_REF_EXPLS
297: SET deleted_flag=YES_FLAG
298: WHERE model_ref_expl_id IN
299: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
300: START WITH model_id=p_model_id AND model_ref_expl_id=t_nodes_to_delete_tbl(i) AND deleted_flag=NO_FLAG

Line 299: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

295: FORALL i IN t_nodes_to_delete_tbl.FIRST..t_nodes_to_delete_tbl.LAST
296: UPDATE CZ_MODEL_REF_EXPLS
297: SET deleted_flag=YES_FLAG
298: WHERE model_ref_expl_id IN
299: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
300: START WITH model_id=p_model_id AND model_ref_expl_id=t_nodes_to_delete_tbl(i) AND deleted_flag=NO_FLAG
301: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
302: AND PRIOR deleted_flag=NO_FLAG);
303: END IF;

Line 398: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;

394: p_ps_node_type IN INTEGER) RETURN NUMBER IS
395:
396: v_expr_parent_id CZ_EXPRESSION_NODES.expr_parent_id%TYPE;
397: v_expr_subtype CZ_EXPRESSION_NODES.expr_subtype%TYPE;
398: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
399:
400: BEGIN
401: FOR i IN (SELECT rule_id,antecedent_id,consequent_id,NAME FROM CZ_RULES
402: WHERE devl_project_id=p_model_id AND disabled_flag=NO_FLAG

Line 476: INSERT INTO CZ_MODEL_REF_EXPLS

472:
473: BEGIN
474: v_expl_id:=allocate_Expl_Id;
475:
476: INSERT INTO CZ_MODEL_REF_EXPLS
477: (model_ref_expl_id,
478: parent_expl_node_id,
479: referring_node_id,
480: model_id,

Line 560: FROM CZ_MODEL_REF_EXPLS

556: PROCEDURE calc_Expl_Paths(p_root_expl_id IN NUMBER,x_paths_tbl OUT NOCOPY Varchar2Array ) IS
557: BEGIN
558:
559: FOR m IN(SELECT model_ref_expl_id,parent_expl_node_id,component_id,referring_node_id
560: FROM CZ_MODEL_REF_EXPLS
561: START WITH model_ref_expl_id=p_root_expl_id
562: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0' AND PRIOR deleted_flag='0')
563: LOOP
564:

Line 625: FROM CZ_MODEL_REF_EXPLS

621: l_expl_id NUMBER;
622: BEGIN
623: FOR i IN (SELECT parent_expl_node_id,referring_node_id,ps_node_type,
624: virtual_flag,component_id,expl_node_type,model_ref_expl_id,LEVEL
625: FROM CZ_MODEL_REF_EXPLS
626: START WITH model_id=p_target_model_id AND component_id=p_target_model_id -- this condition specifies root of expl tree
627: AND deleted_flag=NO_FLAG
628: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
629: LOOP

Line 692: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

688: -- M1 and M5
689: -- |--C1
690: -- so in this case t_model_ref_expl_ids_tbl will store 2 elements
691: --
692: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
693: WHERE model_id=p_target_model_id AND deleted_flag=NO_FLAG AND
694: ps_node_type IN(CONNECTOR_TYPE,REFERENCE_TYPE) )
695: LOOP
696: FOR j IN (SELECT model_ref_expl_id,ps_node_type

Line 697: FROM CZ_MODEL_REF_EXPLS

693: WHERE model_id=p_target_model_id AND deleted_flag=NO_FLAG AND
694: ps_node_type IN(CONNECTOR_TYPE,REFERENCE_TYPE) )
695: LOOP
696: FOR j IN (SELECT model_ref_expl_id,ps_node_type
697: FROM CZ_MODEL_REF_EXPLS
698: START WITH model_ref_expl_id = i.model_ref_expl_id AND deleted_flag=NO_FLAG
699: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
700: LOOP
701: t_model_ref_expl_ids_tbl(t_model_ref_expl_ids_tbl.COUNT+1):=j.model_ref_expl_id;

Line 743: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;

739: t_subtree_tbl ArrayId; -- stores rehashed ( rekeyed ) subtree
740:
741: t_next_level_expl_ids_tbl ArrayId;
742:
743: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;
744: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
745: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
746: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
747: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

Line 744: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

740:
741: t_next_level_expl_ids_tbl ArrayId;
742:
743: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;
744: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
745: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
746: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
747: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
748:

Line 745: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

741: t_next_level_expl_ids_tbl ArrayId;
742:
743: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;
744: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
745: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
746: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
747: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
748:
749: BEGIN

Line 746: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

742:
743: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;
744: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
745: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
746: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
747: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
748:
749: BEGIN
750:

Line 747: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

743: v_parent_id CZ_MODEL_REF_EXPLS.parent_expl_node_id%TYPE;
744: v_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
745: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
746: v_ind CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
747: v_subtree_root_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
748:
749: BEGIN
750:
751: t_subtree_tbl := p_subtree_tbl;

Line 800: INSERT INTO CZ_MODEL_REF_EXPLS

796: IF v_parent_id=p_new_root_expl_id THEN -- this is a root of attached subtree
797: 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
798: END IF;
799:
800: INSERT INTO CZ_MODEL_REF_EXPLS
801: (model_ref_expl_id,
802: parent_expl_node_id,
803: referring_node_id,
804: model_id,

Line 843: FOR h IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

839: AND EXISTS (SELECT NULL FROM cz_devl_projects
840: WHERE devl_project_id = a.devl_project_id
841: AND deleted_flag='0'))
842: LOOP
843: FOR h IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
844: WHERE model_id=i.devl_project_id AND
845: child_model_expl_id=p_new_root_expl_id AND deleted_flag='0')
846: LOOP
847: g_hash_tree_tbl(h.model_ref_expl_id) := t_next_level_expl_ids_tbl;

Line 900: UPDATE CZ_MODEL_REF_EXPLS

896: END IF;
897:
898: IF l_expl_paths_tbl(l_new_expl_id) = t_attach_subtree_tbl(v_expl_id).expl_path THEN
899:
900: UPDATE CZ_MODEL_REF_EXPLS
901: SET child_model_expl_id=t_attach_subtree_tbl(v_expl_id).new_id
902: WHERE model_ref_expl_id=l_new_expl_id;
903:
904: END IF;

Line 1074: FROM CZ_MODEL_REF_EXPLS

1070: -- in model M2 we have 2 entries that have component_id = p_parent_ps_id = M1
1071: -- these are references Ref1 and Ref2
1072:
1073: FOR m IN(SELECT model_ref_expl_id,component_id,ps_node_type,node_depth
1074: FROM CZ_MODEL_REF_EXPLS
1075: WHERE model_id=t_chain(i).model_id AND component_id=p_parent_ps_id AND
1076: parent_expl_node_id IS NOT NULL AND deleted_flag=NO_FLAG)
1077: LOOP
1078:

Line 1082: WHERE EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS

1078:
1079: BEGIN
1080: v_connector_parent_exists:=NO_FLAG;
1081: SELECT YES_FLAG INTO v_connector_parent_exists FROM dual
1082: WHERE EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS
1083: WHERE ps_node_type=CONNECTOR_TYPE
1084: START WITH model_ref_expl_id=m.model_ref_expl_id
1085: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag=NO_FLAG AND deleted_flag=NO_FLAG);
1086: EXCEPTION

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

1142: --
1143: -- put expl_id of branch that we've just handled
1144: --
1145: t_connect_point_tbl(m.model_ref_expl_id):= t_chain(i).model_id;
1146: END LOOP; -- end of loop through CZ_MODEL_REF_EXPLS table --
1147:
1148: --
1149: -- put the current model = t_chain(i).model_id to the hash
1150: -- of models which already hadnled

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

1211: t_subtree_tbl ArrayId; -- stores subtree array
1212: t_prev_level_expl_ids_tbl IntArray; -- stores expl_ids of the target subtree
1213: -- which will be used as child_expl_ids on the next level
1214: v_parent_ps_node_id CZ_PS_NODES.ps_node_id%TYPE; -- ps_node_id of new subtree root node
1215: v_parent_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- expl_id of new subtree root node
1216: v_parent_level CZ_MODEL_REF_EXPLS.node_depth%TYPE; -- node_depth of new subtree root node
1217: v_target_root_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- root expl_id of the target model
1218: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- stores expl_id generated by sequence
1219:

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

1212: t_prev_level_expl_ids_tbl IntArray; -- stores expl_ids of the target subtree
1213: -- which will be used as child_expl_ids on the next level
1214: v_parent_ps_node_id CZ_PS_NODES.ps_node_id%TYPE; -- ps_node_id of new subtree root node
1215: v_parent_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- expl_id of new subtree root node
1216: v_parent_level CZ_MODEL_REF_EXPLS.node_depth%TYPE; -- node_depth of new subtree root node
1217: v_target_root_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- root expl_id of the target model
1218: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- stores expl_id generated by sequence
1219:
1220: BEGIN

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

1213: -- which will be used as child_expl_ids on the next level
1214: v_parent_ps_node_id CZ_PS_NODES.ps_node_id%TYPE; -- ps_node_id of new subtree root node
1215: v_parent_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- expl_id of new subtree root node
1216: v_parent_level CZ_MODEL_REF_EXPLS.node_depth%TYPE; -- node_depth of new subtree root node
1217: v_target_root_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- root expl_id of the target model
1218: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- stores expl_id generated by sequence
1219:
1220: BEGIN
1221: Initialize;

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

1214: v_parent_ps_node_id CZ_PS_NODES.ps_node_id%TYPE; -- ps_node_id of new subtree root node
1215: v_parent_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- expl_id of new subtree root node
1216: v_parent_level CZ_MODEL_REF_EXPLS.node_depth%TYPE; -- node_depth of new subtree root node
1217: v_target_root_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- root expl_id of the target model
1218: v_next_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE; -- stores expl_id generated by sequence
1219:
1220: BEGIN
1221: Initialize;
1222: p_out_err:=0;

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

1314: p_out_level:=NULL_VALUE;
1315:
1316:
1317: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1318: FOR i IN (SELECT model_ref_expl_id,node_depth FROM CZ_MODEL_REF_EXPLS
1319: WHERE model_id=p_project_id AND referring_node_id=p_ps_node_id
1320: AND child_model_expl_id IS NULL AND deleted_flag=NO_FLAG)
1321: LOOP
1322: p_out_expl_id:=i.model_ref_expl_id;

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

1322: p_out_expl_id:=i.model_ref_expl_id;
1323: p_out_level:=i.node_depth;
1324: END LOOP;
1325: ELSE
1326: FOR i IN (SELECT model_ref_expl_id,node_depth FROM CZ_MODEL_REF_EXPLS
1327: WHERE model_id=p_project_id AND referring_node_id IS NULL
1328: AND component_id=p_ps_node_id AND child_model_expl_id IS NULL AND
1329: deleted_flag=NO_FLAG)
1330: LOOP

Line 1393: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

1389: p_out_ps_node_id IN OUT NOCOPY INTEGER,
1390: p_out_expl_id IN OUT NOCOPY INTEGER,
1391: p_out_level IN OUT NOCOPY INTEGER) IS
1392:
1393: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
1394: NODE_FOUND EXCEPTION;
1395:
1396: BEGIN
1397: p_out_ps_node_id:=NULL_VALUE;

Line 1454: SELECT model_ref_expl_id INTO v_ref_id FROM CZ_MODEL_REF_EXPLS

1450: -- DEBUG ERROR CODE --
1451: --
1452: ERROR_CODE:=300;
1453:
1454: SELECT model_ref_expl_id INTO v_ref_id FROM CZ_MODEL_REF_EXPLS
1455: WHERE parent_expl_node_id=p_expl_id
1456: AND (child_model_expl_id=p_child_expl_id OR model_ref_expl_id=p_child_expl_id)
1457: AND deleted_flag=NO_FLAG;
1458:

Line 1470: SELECT parent_expl_node_id INTO v_ref_id FROM CZ_MODEL_REF_EXPLS

1466: -- DEBUG ERROR CODE --
1467: --
1468: ERROR_CODE:=302;
1469:
1470: SELECT parent_expl_node_id INTO v_ref_id FROM CZ_MODEL_REF_EXPLS
1471: WHERE model_ref_expl_id=p_expl_id;
1472:
1473: --
1474: -- DEBUG ERROR CODE --

Line 1493: v_model_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE ;

1489: p_ps_node_id IN INTEGER,
1490: p_mode IN VARCHAR2, -- DEFAULT PLUS_MODE
1491: p_deleted_expl_id IN INTEGER DEFAULT NULL) IS
1492:
1493: v_model_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE ;
1494: v_project_id CZ_MODEL_REF_EXPLS.model_id%TYPE;
1495: v_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
1496:
1497: BEGIN

Line 1494: v_project_id CZ_MODEL_REF_EXPLS.model_id%TYPE;

1490: p_mode IN VARCHAR2, -- DEFAULT PLUS_MODE
1491: p_deleted_expl_id IN INTEGER DEFAULT NULL) IS
1492:
1493: v_model_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE ;
1494: v_project_id CZ_MODEL_REF_EXPLS.model_id%TYPE;
1495: v_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
1496:
1497: BEGIN
1498:

Line 1495: v_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

1491: p_deleted_expl_id IN INTEGER DEFAULT NULL) IS
1492:
1493: v_model_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE ;
1494: v_project_id CZ_MODEL_REF_EXPLS.model_id%TYPE;
1495: v_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
1496:
1497: BEGIN
1498:
1499: IF p_mode=PLUS_MODE THEN

Line 1507: CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id

1503: --
1504: ERROR_CODE:=400;
1505:
1506: SELECT model_ref_expl_id INTO v_model_ref_id FROM
1507: CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id
1508: AND component_id=p_ps_node_id AND child_model_expl_id IS NULL AND deleted_flag=NO_FLAG;
1509:
1510: --
1511: -- DEBUG ERROR CODE --

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

1838: -- DEBUG ERROR CODE --
1839: --
1840: ERROR_CODE:=500;
1841:
1842: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG WHERE model_ref_expl_id IN
1843: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1844: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1845: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1846:

Line 1843: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1839: --
1840: ERROR_CODE:=500;
1841:
1842: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG WHERE model_ref_expl_id IN
1843: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1844: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1845: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1846:
1847: --

Line 1858: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id IN

1854: -- DEBUG ERROR CODE --
1855: --
1856: ERROR_CODE:=502;
1857:
1858: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id IN
1859: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1860: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1861: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1862:

Line 1859: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1855: --
1856: ERROR_CODE:=502;
1857:
1858: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id IN
1859: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1860: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1861: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1862:
1863: --

Line 1885: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

1881: p_ps_node_type IN INTEGER DEFAULT NULL) IS
1882:
1883: BEGIN
1884: IF p_del_logically=YES_FLAG THEN
1885: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1886: WHERE model_ref_expl_id=p_expl_id;
1887: ELSE
1888: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id=p_expl_id;
1889: END IF;

Line 1888: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id=p_expl_id;

1884: IF p_del_logically=YES_FLAG THEN
1885: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1886: WHERE model_ref_expl_id=p_expl_id;
1887: ELSE
1888: DELETE FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id=p_expl_id;
1889: END IF;
1890:
1891: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1892: IF p_del_logically=YES_FLAG THEN

Line 1893: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

1889: END IF;
1890:
1891: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1892: IF p_del_logically=YES_FLAG THEN
1893: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1894: WHERE deleted_flag=NO_FLAG AND model_ref_expl_id IN
1895: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1896: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1897: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 1895: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1891: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1892: IF p_del_logically=YES_FLAG THEN
1893: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
1894: WHERE deleted_flag=NO_FLAG AND model_ref_expl_id IN
1895: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1896: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1897: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
1898: PRIOR deleted_flag=NO_FLAG);
1899: ELSE

Line 1900: DELETE FROM CZ_MODEL_REF_EXPLS

1896: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1897: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
1898: PRIOR deleted_flag=NO_FLAG);
1899: ELSE
1900: DELETE FROM CZ_MODEL_REF_EXPLS
1901: WHERE model_ref_expl_id IN
1902: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1903: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1904: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);

Line 1902: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1898: PRIOR deleted_flag=NO_FLAG);
1899: ELSE
1900: DELETE FROM CZ_MODEL_REF_EXPLS
1901: WHERE model_ref_expl_id IN
1902: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1903: START WITH model_ref_expl_id=p_expl_id AND deleted_flag=NO_FLAG
1904: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG);
1905: END IF;
1906: END IF;

Line 1911: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1907: END delete_it_;
1908:
1909: BEGIN
1910: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
1911: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1912: WHERE referring_node_id=p_ps_node_id AND deleted_flag=NO_FLAG)
1913: LOOP
1914: delete_it_(i.model_ref_expl_id, YES_FLAG);
1915: END LOOP;

Line 1917: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

1913: LOOP
1914: delete_it_(i.model_ref_expl_id, YES_FLAG);
1915: END LOOP;
1916: ELSE
1917: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
1918: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG)
1919: LOOP
1920: delete_it_(i.model_ref_expl_id, YES_FLAG);
1921: END LOOP;

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

1932:
1933: BEGIN
1934: p_instanciable:=0;
1935:
1936: FOR i IN(SELECT model_ref_expl_id,referring_node_id,component_id,expl_node_type FROM CZ_MODEL_REF_EXPLS
1937: START WITH model_id=p_model_id AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG
1938: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
1939: deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG
1940: AND ps_node_type IN(BOM_MODEL_TYPE,COMPONENT_TYPE,REFERENCE_TYPE)

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

1972: p_out_ps_node_id IN OUT NOCOPY INTEGER,
1973: p_out_expl_id IN OUT NOCOPY INTEGER,
1974: p_out_level IN OUT NOCOPY INTEGER) IS
1975:
1976: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE:=NULL_VALUE;
1977: v_parent_id CZ_PS_NODES.parent_id%TYPE:=NULL_VALUE;
1978:
1979: BEGIN
1980:

Line 2003: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_ps_node_id

1999: ERROR_CODE:=1002;
2000:
2001: SELECT model_ref_expl_id,node_depth
2002: INTO p_out_expl_id,p_out_level
2003: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_ps_node_id
2004: AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
2005:
2006: RETURN;
2007: END IF;

Line 2027: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id

2023: ERROR_CODE:=700;
2024:
2025: SELECT model_ref_expl_id,node_depth
2026: INTO p_out_expl_id,p_out_level
2027: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id
2028: AND component_id=i.ps_node_id AND deleted_flag=NO_FLAG;
2029:
2030: --
2031: -- DEBUG ERROR CODE --

Line 2062: v_old_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2058: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/
2059:
2060: PROCEDURE update_Rules(p_ps_node_id IN INTEGER) IS
2061:
2062: v_old_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2063: v_new_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2064:
2065: BEGIN
2066: FOR i IN t_old_expl_ids.FIRST..t_old_expl_ids.LAST

Line 2063: v_new_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2059:
2060: PROCEDURE update_Rules(p_ps_node_id IN INTEGER) IS
2061:
2062: v_old_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2063: v_new_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2064:
2065: BEGIN
2066: FOR i IN t_old_expl_ids.FIRST..t_old_expl_ids.LAST
2067: LOOP

Line 2124: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2120: p_child_array IN IntArray -- array of direct childs ( in PS tree )
2121: ) IS
2122:
2123: t_child_nodes IntArray;
2124: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2125: v_model_id CZ_MODEL_REF_EXPLS.model_id%TYPE;
2126: v_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2127:
2128: BEGIN

Line 2125: v_model_id CZ_MODEL_REF_EXPLS.model_id%TYPE;

2121: ) IS
2122:
2123: t_child_nodes IntArray;
2124: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2125: v_model_id CZ_MODEL_REF_EXPLS.model_id%TYPE;
2126: v_ps_node_id CZ_PS_NODES.ps_node_id%TYPE;
2127:
2128: BEGIN
2129: IF t_chain.COUNT=0 THEN

Line 2138: FROM CZ_MODEL_REF_EXPLS

2134: IF t_chain(i).parent_model_id=p_model_id THEN
2135: v_model_id:=t_chain(i).model_id;
2136:
2137: FOR l IN(SELECT model_ref_expl_id,node_depth
2138: FROM CZ_MODEL_REF_EXPLS
2139: WHERE model_id=t_chain(i).model_id AND
2140: child_model_expl_id=p_parent_ref_expl_id
2141: AND deleted_flag=NO_FLAG)
2142: LOOP

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

2141: AND deleted_flag=NO_FLAG)
2142: LOOP
2143:
2144: --
2145: -- generate the next PK for CZ_MODEL_REF_EXPLS table
2146: --
2147: v_expl_id:=allocate_Expl_Id;
2148:
2149: --

Line 2154: INSERT INTO CZ_MODEL_REF_EXPLS

2150: -- DEBUG ERROR CODE --
2151: --
2152: ERROR_CODE:=800;
2153:
2154: INSERT INTO CZ_MODEL_REF_EXPLS
2155: (model_ref_expl_id,
2156: parent_expl_node_id,
2157: referring_node_id,
2158: model_id,

Line 2198: UPDATE CZ_MODEL_REF_EXPLS

2194: -- DEBUG ERROR CODE --
2195: --
2196: ERROR_CODE:=802;
2197:
2198: UPDATE CZ_MODEL_REF_EXPLS
2199: SET parent_expl_node_id=v_expl_id
2200: WHERE parent_expl_node_id=l.model_ref_expl_id
2201: AND model_id=v_model_id AND
2202: ((ps_node_type IN(PRODUCT_TYPE,COMPONENT_TYPE,BOM_MODEL_TYPE) AND component_id=v_ps_node_id)

Line 2220: UPDATE CZ_MODEL_REF_EXPLS

2216: --
2217: ERROR_CODE:=804;
2218:
2219: FORALL h IN t_child_nodes.FIRST..t_child_nodes.LAST
2220: UPDATE CZ_MODEL_REF_EXPLS
2221: SET node_depth=node_depth+1
2222: WHERE model_ref_expl_id IN
2223: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2224: START WITH model_ref_expl_id=t_child_nodes(h) AND deleted_flag=NO_FLAG

Line 2223: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

2219: FORALL h IN t_child_nodes.FIRST..t_child_nodes.LAST
2220: UPDATE CZ_MODEL_REF_EXPLS
2221: SET node_depth=node_depth+1
2222: WHERE model_ref_expl_id IN
2223: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2224: START WITH model_ref_expl_id=t_child_nodes(h) AND deleted_flag=NO_FLAG
2225: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
2226: AND PRIOR deleted_flag=NO_FLAG);
2227:

Line 2284: FROM CZ_MODEL_REF_EXPLS

2280: IF t_chain(i).parent_model_id=p_model_id THEN
2281: v_model_id:=t_chain(i).model_id;
2282:
2283: FOR l IN(SELECT model_ref_expl_id,node_depth
2284: FROM CZ_MODEL_REF_EXPLS
2285: WHERE model_id=t_chain(i).model_id AND
2286: child_model_expl_id=p_parent_model_ref_expl_id
2287: AND deleted_flag=NO_FLAG)
2288: LOOP

Line 2291: FROM CZ_MODEL_REF_EXPLS

2287: AND deleted_flag=NO_FLAG)
2288: LOOP
2289:
2290: FOR m IN(SELECT *
2291: FROM CZ_MODEL_REF_EXPLS
2292: WHERE model_ref_expl_id = p_model_ref_expl_id
2293: AND deleted_flag=NO_FLAG)
2294: LOOP
2295: --

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

2292: WHERE model_ref_expl_id = p_model_ref_expl_id
2293: AND deleted_flag=NO_FLAG)
2294: LOOP
2295: --
2296: -- generate the next PK for CZ_MODEL_REF_EXPLS table
2297: --
2298: v_expl_id:=allocate_Expl_Id;
2299:
2300: INSERT INTO CZ_MODEL_REF_EXPLS

Line 2300: INSERT INTO CZ_MODEL_REF_EXPLS

2296: -- generate the next PK for CZ_MODEL_REF_EXPLS table
2297: --
2298: v_expl_id:=allocate_Expl_Id;
2299:
2300: INSERT INTO CZ_MODEL_REF_EXPLS
2301: (model_ref_expl_id,
2302: parent_expl_node_id,
2303: referring_node_id,
2304: model_id,

Line 2342: 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)

2338: BEGIN
2339:
2340: populate_expl_tree_internal(p_parent_model_ref_expl_id,p_model_ref_expl_id,p_model_id);
2341:
2342: 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)
2343: LOOP
2344: 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);
2345: END LOOP;
2346:

Line 2388: FROM CZ_MODEL_REF_EXPLS

2384:
2385: -- if not a reference node, get the model_refexpl_id record in model ref expls
2386: IF l_reference_id IS NULL THEN
2387: SELECT model_ref_expl_id, node_depth INTO l_expl_id, l_curr_node_depth
2388: FROM CZ_MODEL_REF_EXPLS
2389: WHERE model_id=l_model_id AND component_id=l_component_id AND
2390: child_model_expl_id IS NULL AND deleted_flag = NO_FLAG;
2391: ELSE
2392: SELECT MIN(node_depth) INTO l_min_node_depth

Line 2393: FROM CZ_MODEL_REF_EXPLS

2389: WHERE model_id=l_model_id AND component_id=l_component_id AND
2390: child_model_expl_id IS NULL AND deleted_flag = NO_FLAG;
2391: ELSE
2392: SELECT MIN(node_depth) INTO l_min_node_depth
2393: FROM CZ_MODEL_REF_EXPLS
2394: WHERE model_id=l_model_id AND referring_node_id=p_ps_node_id
2395: AND deleted_flag = NO_FLAG;
2396:
2397: SELECT model_ref_expl_id, node_depth INTO l_expl_id, l_curr_node_depth

Line 2398: FROM CZ_MODEL_REF_EXPLS

2394: WHERE model_id=l_model_id AND referring_node_id=p_ps_node_id
2395: AND deleted_flag = NO_FLAG;
2396:
2397: SELECT model_ref_expl_id, node_depth INTO l_expl_id, l_curr_node_depth
2398: FROM CZ_MODEL_REF_EXPLS
2399: WHERE model_id=l_model_id AND referring_node_id=p_ps_node_id AND
2400: node_depth=l_min_node_depth AND deleted_flag = NO_FLAG;
2401: END IF;
2402:

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

2415: END IF;
2416:
2417: IF (l_virtual_flag='1' OR l_virtual_flag IS NULL) AND l_parent_id IS NOT NULL THEN
2418:
2419: FOR i IN(SELECT model_ref_expl_id, node_depth FROM CZ_MODEL_REF_EXPLS
2420: WHERE parent_expl_node_id=v_up_expl_id AND
2421: deleted_flag = NO_FLAG AND
2422: (referring_node_id IS NULL AND component_id IN
2423: (SELECT ps_node_id FROM CZ_PS_NODES

Line 2489: FROM CZ_MODEL_REF_EXPLS a

2485: l_model_updated_tbl(p_current_model_id) := p_current_model_id;
2486: END IF;
2487:
2488: FOR i IN(SELECT model_ref_expl_id, referring_node_id, component_id
2489: FROM CZ_MODEL_REF_EXPLS a
2490: WHERE a.model_id=p_current_model_id AND a.deleted_flag=NO_FLAG)
2491: LOOP
2492:
2493: IF i.referring_node_id IS NULL THEN

Line 2500: FROM CZ_MODEL_REF_EXPLS

2496: l_paths_tbl(i.model_ref_expl_id) := TO_CHAR(i.referring_node_id);
2497: END IF;
2498:
2499: FOR m IN(SELECT model_ref_expl_id,component_id,referring_node_id
2500: FROM CZ_MODEL_REF_EXPLS
2501: WHERE model_ref_expl_id<>i.model_ref_expl_id
2502: START WITH model_ref_expl_id=i.model_ref_expl_id
2503: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag=NO_FLAG)
2504: LOOP

Line 2537: SELECT model_ref_expl_id INTO l_ref_expl_id FROM CZ_MODEL_REF_EXPLS

2533: LOOP
2534:
2535: l_new_expl_path_tbl.DELETE;
2536:
2537: SELECT model_ref_expl_id INTO l_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2538: WHERE model_id=n.devl_project_id AND referring_node_id=n.ps_node_id;
2539:
2540: l_new_paths_tbl.DELETE;
2541:

Line 2544: FROM CZ_MODEL_REF_EXPLS

2540: l_new_paths_tbl.DELETE;
2541:
2542: FOR k IN(SELECT model_ref_expl_id,component_id,
2543: referring_node_id,ps_node_type,child_model_expl_id,model_id
2544: FROM CZ_MODEL_REF_EXPLS
2545: START WITH model_ref_expl_id=l_ref_expl_id AND deleted_flag=NO_FLAG
2546: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
2547: deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
2548: LOOP

Line 2564: FROM CZ_MODEL_REF_EXPLS

2560:
2561: IF k.model_ref_expl_id <> l_ref_expl_id THEN
2562:
2563: FOR kk IN(SELECT model_ref_expl_id,component_id,referring_node_id
2564: FROM CZ_MODEL_REF_EXPLS
2565: WHERE model_ref_expl_id<>k.model_ref_expl_id
2566: START WITH model_ref_expl_id=k.model_ref_expl_id
2567: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id AND deleted_flag=NO_FLAG)
2568: LOOP

Line 2598: SELECT child_model_expl_id INTO l_child_expl_id FROM CZ_MODEL_REF_EXPLS

2594: END IF;
2595:
2596: IF l_expl_path_tbl.EXISTS(l_new_paths_tbl(l_loop_ind)) THEN
2597:
2598: SELECT child_model_expl_id INTO l_child_expl_id FROM CZ_MODEL_REF_EXPLS
2599: WHERE model_ref_expl_id=l_loop_ind;
2600:
2601: IF l_expl_path_tbl(l_new_paths_tbl(l_loop_ind)) <> l_child_expl_id THEN
2602:

Line 2605: UPDATE CZ_MODEL_REF_EXPLS

2601: IF l_expl_path_tbl(l_new_paths_tbl(l_loop_ind)) <> l_child_expl_id THEN
2602:
2603: l_num_updated_records := l_num_updated_records + 1;
2604:
2605: UPDATE CZ_MODEL_REF_EXPLS
2606: SET child_model_expl_id=l_expl_path_tbl(l_new_paths_tbl(l_loop_ind))
2607: WHERE model_ref_expl_id=l_loop_ind;
2608:
2609: END IF;

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

2633:
2634: --
2635: -- start with those explosion tree branches which do not have references/connectors to other models
2636: --
2637: FOR i IN(SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS a
2638: WHERE model_id=p_model_id AND deleted_flag=NO_FLAG AND
2639: ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND NOT EXISTS
2640: (SELECT NULL FROM CZ_MODEL_REF_EXPLS
2641: WHERE model_id=a.component_id AND ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND deleted_flag=NO_FLAG))

Line 2640: (SELECT NULL FROM CZ_MODEL_REF_EXPLS

2636: --
2637: FOR i IN(SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS a
2638: WHERE model_id=p_model_id AND deleted_flag=NO_FLAG AND
2639: ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND NOT EXISTS
2640: (SELECT NULL FROM CZ_MODEL_REF_EXPLS
2641: WHERE model_id=a.component_id AND ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND deleted_flag=NO_FLAG))
2642: LOOP
2643: update_layer(i.component_id);
2644: END LOOP;

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

2650:
2651: PROCEDURE delete_duplicates(p_model_id IN NUMBER) IS
2652:
2653: BEGIN
2654: FOR i IN (SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS
2655: WHERE component_id=p_model_id AND referring_node_id IS NOT NULL
2656: AND deleted_flag=NO_FLAG)
2657: LOOP
2658: UPDATE CZ_MODEL_REF_EXPLS a

Line 2658: UPDATE CZ_MODEL_REF_EXPLS a

2654: FOR i IN (SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS
2655: WHERE component_id=p_model_id AND referring_node_id IS NOT NULL
2656: AND deleted_flag=NO_FLAG)
2657: LOOP
2658: UPDATE CZ_MODEL_REF_EXPLS a
2659: SET deleted_flag = '1'
2660: WHERE model_id=i.model_id AND deleted_flag=NO_FLAG
2661: AND referring_node_id IS NOT NULL
2662: AND parent_expl_node_id IN

Line 2663: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

2659: SET deleted_flag = '1'
2660: WHERE model_id=i.model_id AND deleted_flag=NO_FLAG
2661: AND referring_node_id IS NOT NULL
2662: AND parent_expl_node_id IN
2663: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2664: WHERE model_id=i.model_id AND deleted_flag=NO_FLAG
2665: AND referring_node_id=a.referring_node_id);
2666: END LOOP;
2667:

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

2664: WHERE model_id=i.model_id AND deleted_flag=NO_FLAG
2665: AND referring_node_id=a.referring_node_id);
2666: END LOOP;
2667:
2668: FOR i IN (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS
2669: WHERE model_id=p_model_id AND referring_node_id IS NOT NULL
2670: AND deleted_flag=NO_FLAG)
2671: LOOP
2672: UPDATE CZ_MODEL_REF_EXPLS a

Line 2672: UPDATE CZ_MODEL_REF_EXPLS a

2668: FOR i IN (SELECT DISTINCT component_id FROM CZ_MODEL_REF_EXPLS
2669: WHERE model_id=p_model_id AND referring_node_id IS NOT NULL
2670: AND deleted_flag=NO_FLAG)
2671: LOOP
2672: UPDATE CZ_MODEL_REF_EXPLS a
2673: SET deleted_flag = '1'
2674: WHERE model_id=i.component_id AND deleted_flag=NO_FLAG
2675: AND referring_node_id IS NOT NULL
2676: AND parent_expl_node_id IN

Line 2677: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

2673: SET deleted_flag = '1'
2674: WHERE model_id=i.component_id AND deleted_flag=NO_FLAG
2675: AND referring_node_id IS NOT NULL
2676: AND parent_expl_node_id IN
2677: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2678: WHERE model_id=i.component_id AND deleted_flag=NO_FLAG
2679: AND referring_node_id=a.referring_node_id);
2680: END LOOP;
2681: END delete_duplicates;

Line 2752: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2748:
2749: t_child_nodes IntArray;
2750: t_childs IntArray;
2751:
2752: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2753: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2754: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2755: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2756: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

Line 2753: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2749: t_child_nodes IntArray;
2750: t_childs IntArray;
2751:
2752: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2753: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2754: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2755: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2756: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2757: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

Line 2754: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;

2750: t_childs IntArray;
2751:
2752: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2753: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2754: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2755: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2756: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2757: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
2758: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;

Line 2755: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2751:
2752: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2753: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2754: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2755: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2756: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2757: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
2758: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2759:

Line 2756: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

2752: v_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2753: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2754: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2755: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2756: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2757: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
2758: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2759:
2760: v_up_id CZ_PS_NODES.ps_node_id%TYPE;

Line 2757: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

2753: v_model_ref_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2754: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2755: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2756: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2757: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
2758: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2759:
2760: v_up_id CZ_PS_NODES.ps_node_id%TYPE;
2761: v_virtual_flag CZ_PS_NODES.virtual_flag%TYPE;

Line 2758: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;

2754: v_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2755: v_del_ref_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2756: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
2757: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
2758: v_curr_expl_node_type CZ_MODEL_REF_EXPLS.expl_node_type%TYPE;
2759:
2760: v_up_id CZ_PS_NODES.ps_node_id%TYPE;
2761: v_virtual_flag CZ_PS_NODES.virtual_flag%TYPE;
2762: v_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

Line 2867: FROM CZ_MODEL_REF_EXPLS

2863: BEGIN
2864: v_node_Exist:=FALSE;
2865: SELECT model_ref_expl_id,parent_expl_node_id,ps_node_type,virtual_flag,expl_node_type
2866: INTO v_model_ref_expl_id,v_parent_expl_node_id,v_ps_node_type,v_virtual_flag,v_curr_expl_node_type
2867: FROM CZ_MODEL_REF_EXPLS
2868: WHERE ((component_id=p_ps_node_id AND referring_node_id IS NULL) OR
2869: referring_node_id=p_ps_node_id)
2870: AND model_id=p_model_id AND deleted_flag=NO_FLAG AND ROWNUM<2;
2871: v_node_Exist:=TRUE;

Line 2912: -- exist in CZ_MODEL_REF_EXPLS table

2908:
2909: --
2910: -- case when we have Min=1 and Max=1 for not Connectors/References nodes
2911: -- and this node with ps_node_id=p_ps_node_id does not
2912: -- exist in CZ_MODEL_REF_EXPLS table
2913: -- and no Numeric Rules which contribute to Min/Max are specified
2914: -- in this case we just need to exit from program
2915: --
2916: IF (v_expl_node_type=MANDATORY_EXPL_TYPE) AND (v_ps_node_type NOT IN(REFERENCE_TYPE,CONNECTOR_TYPE))

Line 2936: UPDATE CZ_MODEL_REF_EXPLS

2932:
2933: IF SQL%ROWCOUNT>0 THEN
2934:
2935: IF (v_ps_node_type NOT IN(REFERENCE_TYPE,CONNECTOR_TYPE)) THEN
2936: UPDATE CZ_MODEL_REF_EXPLS
2937: SET virtual_flag=p_out_virtual_flag,
2938: expl_node_type=v_expl_node_type
2939: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG;
2940: ELSE

Line 2941: UPDATE CZ_MODEL_REF_EXPLS

2937: SET virtual_flag=p_out_virtual_flag,
2938: expl_node_type=v_expl_node_type
2939: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG;
2940: ELSE
2941: UPDATE CZ_MODEL_REF_EXPLS
2942: SET virtual_flag=p_out_virtual_flag,
2943: expl_node_type=v_expl_node_type
2944: WHERE referring_node_id=p_ps_node_id AND deleted_flag=NO_FLAG;
2945: END IF;

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

2966: --
2967: IF p_out_virtual_flag=YES_FLAG AND
2968: (v_ps_node_type NOT IN(REFERENCE_TYPE,CONNECTOR_TYPE)) AND v_node_Exist THEN
2969:
2970: FOR x IN (SELECT model_ref_expl_id,parent_expl_node_id,model_id FROM CZ_MODEL_REF_EXPLS a
2971: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
2972: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
2973: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
2974: LOOP

Line 2985: FOR y IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

2981: -- DEBUG ERROR CODE --
2982: --
2983: ERROR_CODE:=905;
2984:
2985: FOR y IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
2986: START WITH model_ref_expl_id=x.model_ref_expl_id AND deleted_flag=NO_FLAG
2987: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
2988: PRIOR deleted_flag=NO_FLAG)
2989: LOOP

Line 2990: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-1

2986: START WITH model_ref_expl_id=x.model_ref_expl_id AND deleted_flag=NO_FLAG
2987: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
2988: PRIOR deleted_flag=NO_FLAG)
2989: LOOP
2990: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-1
2991: WHERE model_ref_expl_id=y.model_ref_expl_id;
2992: END LOOP;
2993:
2994: --

Line 2999: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=x.parent_expl_node_id

2995: -- DEBUG ERROR CODE --
2996: --
2997: ERROR_CODE:=906;
2998:
2999: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=x.parent_expl_node_id
3000: WHERE parent_expl_node_id=x.model_ref_expl_id
3001: AND model_id=x.model_id AND deleted_flag=NO_FLAG;
3002:
3003: EXCEPTION

Line 3055: INSERT INTO CZ_MODEL_REF_EXPLS

3051: -- DEBUG ERROR CODE --
3052: --
3053: ERROR_CODE:=910;
3054:
3055: INSERT INTO CZ_MODEL_REF_EXPLS
3056: (model_ref_expl_id,
3057: parent_expl_node_id,
3058: referring_node_id,
3059: model_id,

Line 3092: (SELECT component_id FROM CZ_MODEL_REF_EXPLS

3088: SELECT ps_node_id BULK COLLECT INTO t_childs FROM CZ_PS_NODES
3089: WHERE devl_project_id=p_model_id AND ps_node_id<>p_ps_node_id AND
3090: (
3091: (ps_node_type in(COMPONENT_TYPE,PRODUCT_TYPE) AND ps_node_id IN ---- fix for bug #3161931
3092: (SELECT component_id FROM CZ_MODEL_REF_EXPLS
3093: WHERE model_id=p_model_id AND deleted_flag=NO_FLAG AND parent_expl_node_id=v_up_expl_id AND
3094: component_id IN(SELECT ps_node_id FROM CZ_PS_NODES
3095: START WITH ps_node_id=p_ps_node_id AND deleted_flag=NO_FLAG
3096: CONNECT BY PRIOR ps_node_id=parent_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)

Line 3101: (SELECT referring_node_id FROM CZ_MODEL_REF_EXPLS

3097: )
3098: )
3099: OR
3100: (ps_node_type in(REFERENCE_TYPE,CONNECTOR_TYPE) AND ps_node_id IN ---- fix for bug #3161931
3101: (SELECT referring_node_id FROM CZ_MODEL_REF_EXPLS
3102: WHERE model_id=p_model_id AND deleted_flag=NO_FLAG AND parent_expl_node_id=v_up_expl_id AND
3103: referring_node_id IN(SELECT ps_node_id FROM CZ_PS_NODES
3104: START WITH ps_node_id=p_ps_node_id AND deleted_flag=NO_FLAG
3105: CONNECT BY PRIOR ps_node_id=parent_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)

Line 3120: UPDATE CZ_MODEL_REF_EXPLS

3116: FOR t IN t_childs.FIRST..t_childs.LAST
3117: LOOP
3118: t_child_nodes.DELETE;
3119: v_ps_node_id:= t_childs(t);
3120: UPDATE CZ_MODEL_REF_EXPLS
3121: SET parent_expl_node_id=v_expl_id
3122: WHERE parent_expl_node_id=v_up_expl_id
3123: AND model_id=p_model_id AND
3124: ((ps_node_type IN(PRODUCT_TYPE,COMPONENT_TYPE,BOM_MODEL_TYPE) AND component_id=v_ps_node_id)

Line 3137: UPDATE CZ_MODEL_REF_EXPLS

3133: --
3134: ERROR_CODE:=913;
3135:
3136: FORALL h IN t_child_nodes.FIRST..t_child_nodes.LAST
3137: UPDATE CZ_MODEL_REF_EXPLS
3138: SET node_depth=node_depth+1
3139: WHERE model_ref_expl_id IN
3140: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3141: START WITH model_ref_expl_id=t_child_nodes(h) AND deleted_flag=NO_FLAG

Line 3140: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3136: FORALL h IN t_child_nodes.FIRST..t_child_nodes.LAST
3137: UPDATE CZ_MODEL_REF_EXPLS
3138: SET node_depth=node_depth+1
3139: WHERE model_ref_expl_id IN
3140: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3141: START WITH model_ref_expl_id=t_child_nodes(h) AND deleted_flag=NO_FLAG
3142: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3143: AND PRIOR deleted_flag=NO_FLAG);
3144:

Line 3184: FROM CZ_MODEL_REF_EXPLS

3180:
3181: set_Expls(p_model_id,p_ps_node_id, PLUS_MODE);
3182:
3183: SELECT MIN(model_ref_expl_id) INTO v_comp_expl_id
3184: FROM CZ_MODEL_REF_EXPLS
3185: WHERE model_id=p_model_id AND component_id=v_component_id AND
3186: deleted_flag='0';
3187:
3188: refresh_UI_Expl_Ids(p_ps_node_id => p_ps_node_id,

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

3248: p_out_err:=0;
3249:
3250: IF p_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) THEN
3251:
3252: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3253: WHERE referring_node_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
3254: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3255: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3256: LOOP

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

3271: SELECT component_id,NVL(virtual_flag,'1') INTO v_component_id,v_virtual_flag FROM CZ_PS_NODES
3272: WHERE ps_node_id=p_ps_node_id;
3273:
3274: IF v_virtual_flag='0' THEN
3275: FOR i IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3276: WHERE component_id=p_ps_node_id AND deleted_flag=NO_FLAG AND
3277: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3278: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3279: LOOP

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

3292: END LOOP;
3293:
3294: ELSE
3295:
3296: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3297: WHERE parent_expl_node_id IN
3298: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3299: WHERE model_id=a.model_id AND component_id=v_component_id AND deleted_flag='0')
3300: AND (component_id IN

Line 3298: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3294: ELSE
3295:
3296: FOR i IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3297: WHERE parent_expl_node_id IN
3298: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3299: WHERE model_id=a.model_id AND component_id=v_component_id AND deleted_flag='0')
3300: AND (component_id IN
3301: (SELECT ps_node_id FROM CZ_PS_NODES
3302: START WITH ps_node_id=p_ps_node_id

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

3341: p_level IN INTEGER,
3342: p_tree_level IN INTEGER) IS
3343:
3344: BEGIN
3345: FOR i IN(SELECT model_ref_expl_id,parent_expl_node_id FROM CZ_MODEL_REF_EXPLS
3346: WHERE parent_expl_node_id=p_expl_id AND deleted_flag=NO_FLAG)
3347: LOOP
3348: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=p_level+p_tree_level
3349: WHERE model_ref_expl_id=i.model_ref_expl_id;

Line 3348: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=p_level+p_tree_level

3344: BEGIN
3345: FOR i IN(SELECT model_ref_expl_id,parent_expl_node_id FROM CZ_MODEL_REF_EXPLS
3346: WHERE parent_expl_node_id=p_expl_id AND deleted_flag=NO_FLAG)
3347: LOOP
3348: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=p_level+p_tree_level
3349: WHERE model_ref_expl_id=i.model_ref_expl_id;
3350:
3351: --
3352: -- DEBUG ERROR CODE --

Line 3386: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

3382: t_refs IntArray;
3383: t_models IntArray;
3384: t_model_ref_expl IntArray;
3385: t_model_ref_expl_ IntArray;
3386: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3387: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3388: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3389: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3390: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

Line 3387: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

3383: t_models IntArray;
3384: t_model_ref_expl IntArray;
3385: t_model_ref_expl_ IntArray;
3386: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3387: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3388: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3389: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3390: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3391: STOP_IT EXCEPTION;

Line 3388: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

3384: t_model_ref_expl IntArray;
3385: t_model_ref_expl_ IntArray;
3386: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3387: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3388: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3389: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3390: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3391: STOP_IT EXCEPTION;
3392:

Line 3389: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

3385: t_model_ref_expl_ IntArray;
3386: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3387: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3388: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3389: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3390: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3391: STOP_IT EXCEPTION;
3392:
3393: BEGIN

Line 3390: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

3386: v_expl_root_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3387: v_from_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3388: v_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3389: v_from_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3390: v_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3391: STOP_IT EXCEPTION;
3392:
3393: BEGIN
3394:

Line 3406: FROM CZ_MODEL_REF_EXPLS a

3402: -- a moved node in source Model
3403: --
3404: SELECT model_ref_expl_id,model_id
3405: BULK COLLECT INTO t_refs,t_models
3406: FROM CZ_MODEL_REF_EXPLS a
3407: WHERE child_model_expl_id=p_expl_root_id
3408: AND ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND deleted_flag=NO_FLAG AND
3409: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3410: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);

Line 3434: SELECT model_ref_expl_id INTO v_from_up_expl_id FROM CZ_MODEL_REF_EXPLS a

3430: -- DEBUG ERROR CODE --
3431: --
3432: ERROR_CODE:=1202;
3433:
3434: SELECT model_ref_expl_id INTO v_from_up_expl_id FROM CZ_MODEL_REF_EXPLS a
3435: WHERE child_model_expl_id=p_from_expl_id AND model_ref_expl_id
3436: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3437: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3438: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND

Line 3436: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3432: ERROR_CODE:=1202;
3433:
3434: SELECT model_ref_expl_id INTO v_from_up_expl_id FROM CZ_MODEL_REF_EXPLS a
3435: WHERE child_model_expl_id=p_from_expl_id AND model_ref_expl_id
3436: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3437: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3438: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND
3439: deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
3440: AND

Line 3450: INTO v_up_expl_id,v_up_level FROM CZ_MODEL_REF_EXPLS a

3446: --
3447: ERROR_CODE:=1203;
3448:
3449: SELECT model_ref_expl_id,node_depth
3450: INTO v_up_expl_id,v_up_level FROM CZ_MODEL_REF_EXPLS a
3451: WHERE child_model_expl_id=p_up_expl_id AND model_ref_expl_id
3452: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3453: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3454: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)

Line 3452: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3448:
3449: SELECT model_ref_expl_id,node_depth
3450: INTO v_up_expl_id,v_up_level FROM CZ_MODEL_REF_EXPLS a
3451: WHERE child_model_expl_id=p_up_expl_id AND model_ref_expl_id
3452: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3453: START WITH model_ref_expl_id=t_refs(i) AND deleted_flag=NO_FLAG
3454: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND PRIOR deleted_flag=NO_FLAG)
3455: AND
3456: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

Line 3466: UPDATE CZ_MODEL_REF_EXPLS

3462: ERROR_CODE:=1204;
3463:
3464: FOR k IN p_model_ref_expl.FIRST..p_model_ref_expl.LAST
3465: LOOP
3466: UPDATE CZ_MODEL_REF_EXPLS
3467: SET parent_expl_node_id=v_up_expl_id
3468: WHERE model_ref_expl_id
3469: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3470: WHERE (parent_expl_node_id=v_from_up_expl_id OR model_ref_expl_id=v_from_up_expl_id)

Line 3469: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3465: LOOP
3466: UPDATE CZ_MODEL_REF_EXPLS
3467: SET parent_expl_node_id=v_up_expl_id
3468: WHERE model_ref_expl_id
3469: IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3470: WHERE (parent_expl_node_id=v_from_up_expl_id OR model_ref_expl_id=v_from_up_expl_id)
3471: AND child_model_expl_id=p_model_ref_expl(k)
3472: AND deleted_flag=NO_FLAG);
3473:

Line 3497: FROM CZ_MODEL_REF_EXPLS

3493: -- recreate array of child_model_expl_id-s --
3494: --
3495: SELECT model_ref_expl_id,node_depth
3496: BULK COLLECT INTO t_model_ref_expl_,t_levels_
3497: FROM CZ_MODEL_REF_EXPLS
3498: WHERE parent_expl_node_id=v_up_expl_id
3499: AND child_model_expl_id=p_model_ref_expl(k)
3500: AND deleted_flag=NO_FLAG;
3501:

Line 3572: v_ref_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;

3568: err INTEGER;
3569: v_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
3570: v_virtual_flag CZ_PS_NODES.virtual_flag%TYPE;
3571:
3572: v_ref_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3573: v_ref_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3574: v_contains_non_virt BOOLEAN:=FALSE;
3575: v_circularity_exists BOOLEAN:=FALSE;
3576: v_comp_expl_id NUMBER;

Line 3573: v_ref_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;

3569: v_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
3570: v_virtual_flag CZ_PS_NODES.virtual_flag%TYPE;
3571:
3572: v_ref_up_expl_id CZ_MODEL_REF_EXPLS.model_ref_expl_id%TYPE;
3573: v_ref_up_level CZ_MODEL_REF_EXPLS.node_depth%TYPE;
3574: v_contains_non_virt BOOLEAN:=FALSE;
3575: v_circularity_exists BOOLEAN:=FALSE;
3576: v_comp_expl_id NUMBER;
3577: v_model_ref_expl_id NUMBER;

Line 3639: FROM CZ_MODEL_REF_EXPLS

3635:
3636: v_from_up_id:=p_from_ps_node_id;
3637: SELECT model_ref_expl_id,node_depth
3638: INTO v_from_up_expl_id,v_from_up_level
3639: FROM CZ_MODEL_REF_EXPLS
3640: WHERE model_id=p_project_id AND referring_node_id=p_from_ps_node_id
3641: AND deleted_flag=NO_FLAG;
3642:
3643: BEGIN

Line 3646: FROM CZ_MODEL_REF_EXPLS

3642:
3643: BEGIN
3644: SELECT model_ref_expl_id,node_depth
3645: INTO v_ref_up_expl_id,v_ref_up_level
3646: FROM CZ_MODEL_REF_EXPLS
3647: WHERE component_id=v_up_id
3648: AND model_id=p_project_id AND deleted_flag=NO_FLAG;
3649:
3650: UPDATE CZ_MODEL_REF_EXPLS

Line 3650: UPDATE CZ_MODEL_REF_EXPLS

3646: FROM CZ_MODEL_REF_EXPLS
3647: WHERE component_id=v_up_id
3648: AND model_id=p_project_id AND deleted_flag=NO_FLAG;
3649:
3650: UPDATE CZ_MODEL_REF_EXPLS
3651: SET parent_expl_node_id=v_ref_up_expl_id
3652: WHERE model_ref_expl_id=v_from_up_expl_id
3653: AND deleted_flag=NO_FLAG;
3654:

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

3651: SET parent_expl_node_id=v_ref_up_expl_id
3652: WHERE model_ref_expl_id=v_from_up_expl_id
3653: AND deleted_flag=NO_FLAG;
3654:
3655: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_ref_up_level+1
3656: WHERE model_ref_expl_id IN
3657: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3658: START WITH model_ref_expl_id=v_from_up_expl_id AND deleted_flag=NO_FLAG
3659: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG

Line 3657: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3653: AND deleted_flag=NO_FLAG;
3654:
3655: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_ref_up_level+1
3656: WHERE model_ref_expl_id IN
3657: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3658: START WITH model_ref_expl_id=v_from_up_expl_id AND deleted_flag=NO_FLAG
3659: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3660: AND PRIOR deleted_flag=NO_FLAG);
3661: EXCEPTION

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

3670:
3671: IF t_chain.COUNT>0 THEN
3672: FOR i IN t_chain.FIRST..t_chain.LAST
3673: LOOP
3674: FOR k IN(SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS WHERE
3675: model_id=t_chain(i).model_id AND ps_node_type IN(REFERENCE_TYPE,264)
3676: AND component_id=p_project_id AND deleted_flag=NO_FLAG)
3677: LOOP
3678: BEGIN

Line 3681: FROM CZ_MODEL_REF_EXPLS

3677: LOOP
3678: BEGIN
3679: SELECT model_ref_expl_id,node_depth
3680: INTO v_ref_up_expl_id,v_ref_up_level
3681: FROM CZ_MODEL_REF_EXPLS
3682: WHERE component_id=v_up_id
3683: AND model_ref_expl_id IN
3684: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3685: START WITH model_ref_expl_id=k.model_ref_expl_id AND deleted_flag=NO_FLAG

Line 3684: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3680: INTO v_ref_up_expl_id,v_ref_up_level
3681: FROM CZ_MODEL_REF_EXPLS
3682: WHERE component_id=v_up_id
3683: AND model_ref_expl_id IN
3684: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3685: START WITH model_ref_expl_id=k.model_ref_expl_id AND deleted_flag=NO_FLAG
3686: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3687: AND PRIOR deleted_flag=NO_FLAG);
3688:

Line 3690: UPDATE CZ_MODEL_REF_EXPLS

3686: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3687: AND PRIOR deleted_flag=NO_FLAG);
3688:
3689:
3690: UPDATE CZ_MODEL_REF_EXPLS
3691: SET parent_expl_node_id=v_ref_up_expl_id
3692: WHERE model_ref_expl_id IN
3693: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3694: WHERE referring_node_id=p_from_ps_node_id

Line 3693: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a

3689:
3690: UPDATE CZ_MODEL_REF_EXPLS
3691: SET parent_expl_node_id=v_ref_up_expl_id
3692: WHERE model_ref_expl_id IN
3693: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3694: WHERE referring_node_id=p_from_ps_node_id
3695: AND model_ref_expl_id IN
3696: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3697: START WITH model_ref_expl_id=k.model_ref_expl_id AND deleted_flag=NO_FLAG

Line 3696: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3692: WHERE model_ref_expl_id IN
3693: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS a
3694: WHERE referring_node_id=p_from_ps_node_id
3695: AND model_ref_expl_id IN
3696: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3697: START WITH model_ref_expl_id=k.model_ref_expl_id AND deleted_flag=NO_FLAG
3698: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
3699: AND PRIOR deleted_flag=NO_FLAG) AND
3700: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES

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

3700: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
3701: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG))
3702: RETURNING model_ref_expl_id,node_depth INTO var_subroot_id,var_subroot_level ;
3703:
3704: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-var_subroot_level+v_ref_up_level+1
3705: WHERE model_ref_expl_id IN
3706: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3707: START WITH model_ref_expl_id=var_subroot_id AND deleted_flag=NO_FLAG
3708: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 3706: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3702: RETURNING model_ref_expl_id,node_depth INTO var_subroot_id,var_subroot_level ;
3703:
3704: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-var_subroot_level+v_ref_up_level+1
3705: WHERE model_ref_expl_id IN
3706: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3707: START WITH model_ref_expl_id=var_subroot_id AND deleted_flag=NO_FLAG
3708: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
3709: PRIOR deleted_flag=NO_FLAG);
3710:

Line 3737: FROM CZ_MODEL_REF_EXPLS

3733: ERROR_CODE:=1303;
3734:
3735: SELECT model_ref_expl_id
3736: BULK COLLECT INTO t_model_ref_expl
3737: FROM CZ_MODEL_REF_EXPLS
3738: WHERE parent_expl_node_id=v_from_up_expl_id AND model_id=p_project_id AND
3739: component_id IN(SELECT ps_node_id FROM CZ_PS_NODES
3740: START WITH ps_node_id=p_from_ps_node_id AND deleted_flag=NO_FLAG
3741: CONNECT BY PRIOR ps_node_id=parent_id AND deleted_flag=NO_FLAG

Line 3759: FROM CZ_MODEL_REF_EXPLS

3755:
3756: v_from_up_id:=p_from_ps_node_id;
3757: SELECT model_ref_expl_id,node_depth
3758: INTO v_from_up_expl_id,v_from_up_level
3759: FROM CZ_MODEL_REF_EXPLS
3760: WHERE model_id=p_project_id AND component_id=v_from_up_id
3761: AND ps_node_type NOT IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND child_model_expl_id IS NULL AND
3762: deleted_flag=NO_FLAG;
3763: t_model_ref_expl(1):=v_from_up_expl_id;

Line 3783: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=v_up_expl_id

3779: -- DEBUG ERROR CODE --
3780: --
3781: ERROR_CODE:=1307;
3782:
3783: UPDATE CZ_MODEL_REF_EXPLS SET parent_expl_node_id=v_up_expl_id
3784: WHERE model_ref_expl_id=t_model_ref_expl(i)
3785: AND model_id=p_project_id;
3786:
3787: --

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

3788: -- DEBUG ERROR CODE --
3789: --
3790: ERROR_CODE:=1308;
3791:
3792: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_up_level+1
3793: WHERE model_ref_expl_id IN
3794: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3795: START WITH model_ref_expl_id=t_model_ref_expl(i) AND deleted_flag=NO_FLAG
3796: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND

Line 3794: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

3790: ERROR_CODE:=1308;
3791:
3792: UPDATE CZ_MODEL_REF_EXPLS SET node_depth=node_depth-v_from_up_level+v_up_level+1
3793: WHERE model_ref_expl_id IN
3794: (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS
3795: START WITH model_ref_expl_id=t_model_ref_expl(i) AND deleted_flag=NO_FLAG
3796: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG AND
3797: PRIOR deleted_flag=NO_FLAG);
3798:

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

3810: --
3811: ERROR_CODE:=1310;
3812:
3813: SELECT model_ref_expl_id INTO v_expl_root_id
3814: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_project_id AND component_id=p_project_id
3815: AND parent_expl_node_id IS NULL AND deleted_flag=NO_FLAG;
3816:
3817: --
3818: -- DEBUG ERROR CODE --

Line 3831: SELECT node_depth INTO v_temp FROM CZ_MODEL_REF_EXPLS

3827: -- DEBUG ERROR CODE --
3828: --
3829: ERROR_CODE:=1312;
3830:
3831: SELECT node_depth INTO v_temp FROM CZ_MODEL_REF_EXPLS
3832: WHERE model_id=p_project_id AND model_ref_expl_id=t_model_ref_expl(t);
3833: t_levels(t_levels.COUNT+1):=v_temp;
3834:
3835: --

Line 3863: FROM CZ_MODEL_REF_EXPLS

3859: IF v_virtual_flag=YES_FLAG THEN
3860: update_Rules(p_from_ps_node_id);
3861:
3862: SELECT MIN(model_ref_expl_id) INTO v_comp_expl_id
3863: FROM CZ_MODEL_REF_EXPLS
3864: WHERE model_id=p_project_id AND component_id=v_component_id AND
3865: deleted_flag='0';
3866:
3867: SELECT MIN(model_ref_expl_id) INTO v_comp_expl_id

Line 3868: FROM CZ_MODEL_REF_EXPLS

3864: WHERE model_id=p_project_id AND component_id=v_component_id AND
3865: deleted_flag='0';
3866:
3867: SELECT MIN(model_ref_expl_id) INTO v_comp_expl_id
3868: FROM CZ_MODEL_REF_EXPLS
3869: WHERE model_id=p_project_id AND component_id=
3870: (SELECT component_id FROM CZ_PS_NODES WHERE ps_node_id=p_to_ps_node_id) AND
3871: deleted_flag='0';
3872:

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

3968: END IF;
3969:
3970: IF v_BOM_node2>0 THEN
3971: -- check models that reference the current model ( p_refroot_model_id )
3972: FOR n IN(SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a
3973: WHERE component_id=p_refroot_model_id AND ps_node_type=REFERENCE_TYPE AND
3974: deleted_flag='0' AND
3975: EXISTS(SELECT NULL FROM CZ_RP_ENTRIES WHERE object_id=a.model_id AND
3976: object_type='PRJ' AND deleted_flag='0'))

Line 4027: UPDATE CZ_MODEL_REF_EXPLS a SET deleted_flag=YES_FLAG

4023: -- DEBUG ERROR CODE --
4024: --
4025: ERROR_CODE:=1500;
4026:
4027: UPDATE CZ_MODEL_REF_EXPLS a SET deleted_flag=YES_FLAG
4028: WHERE child_model_expl_id=t_arr(i) AND
4029: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4030: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG)
4031: RETURNING model_ref_expl_id BULK COLLECT INTO temp_arr;

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

4057:
4058: PROCEDURE delete_subtree(p_model_id IN INTEGER,p_model_ref_expl_id IN INTEGER) IS
4059: t_arr IntArray;
4060: BEGIN
4061: FOR j IN(SELECT model_ref_expl_id,ps_node_type,component_id FROM CZ_MODEL_REF_EXPLS
4062: WHERE model_id=p_model_id AND parent_expl_node_id=p_model_ref_expl_id AND deleted_flag=NO_FLAG)
4063: LOOP
4064: IF j.ps_node_type=CONNECTOR_TYPE THEN
4065: t_arr.DELETE;

Line 4072: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG

4068: -- DEBUG ERROR CODE --
4069: --
4070: ERROR_CODE:=1600;
4071:
4072: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
4073: WHERE model_ref_expl_id IN(
4074: SELECT model_ref_expl_id FROM cz_model_ref_expls
4075: START WITH model_ref_expl_id=j.model_ref_expl_id AND deleted_flag=NO_FLAG
4076: CONNECT by PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG

Line 4074: SELECT model_ref_expl_id FROM cz_model_ref_expls

4070: ERROR_CODE:=1600;
4071:
4072: UPDATE CZ_MODEL_REF_EXPLS SET deleted_flag=YES_FLAG
4073: WHERE model_ref_expl_id IN(
4074: SELECT model_ref_expl_id FROM cz_model_ref_expls
4075: START WITH model_ref_expl_id=j.model_ref_expl_id AND deleted_flag=NO_FLAG
4076: CONNECT by PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag=NO_FLAG
4077: AND PRIOR deleted_flag=NO_FLAG);
4078:

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

4103:
4104: PROCEDURE change_structure_(p_model_id IN INTEGER) IS
4105:
4106: BEGIN
4107: FOR i IN(SELECT model_ref_expl_id,ps_node_type FROM CZ_MODEL_REF_EXPLS
4108: WHERE model_id=p_model_id AND component_id=p_model_id AND
4109: ps_node_type IN(CONNECTOR_TYPE,REFERENCE_TYPE) AND deleted_flag=NO_FLAG)
4110: LOOP
4111: delete_subtree(p_model_id,i.model_ref_expl_id);

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

4117:
4118: PROCEDURE change_structure(p_model_id IN INTEGER) IS
4119:
4120: BEGIN
4121: FOR i IN(SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS
4122: WHERE component_id=p_model_id AND
4123: ps_node_type IN(CONNECTOR_TYPE,REFERENCE_TYPE) AND deleted_flag=NO_FLAG)
4124: LOOP
4125: change_structure_(i.model_id);

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

4139: BEGIN
4140:
4141: SELECT DISTINCT model_id BULK COLLECT INTO t_m_chain_tbl FROM
4142: (SELECT DISTINCT component_id AS model_id
4143: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_model_id AND ps_node_type=REFERENCE_TYPE
4144: AND deleted_flag=NO_FLAG
4145: UNION
4146: SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a
4147: WHERE component_id=p_model_id AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND

Line 4146: SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a

4142: (SELECT DISTINCT component_id AS model_id
4143: FROM CZ_MODEL_REF_EXPLS WHERE model_id=p_model_id AND ps_node_type=REFERENCE_TYPE
4144: AND deleted_flag=NO_FLAG
4145: UNION
4146: SELECT DISTINCT model_id FROM CZ_MODEL_REF_EXPLS a
4147: WHERE component_id=p_model_id AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4148: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4149: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG));
4150:

Line 4160: UPDATE cz_model_ref_expls

4156: -- set has_trackable_children to '1' for those references in explosion tree of t_m_chain_tbl(i) model
4157: -- which points to models which have CZ_PS_NODES.ib_trackable='1'. So here we assume
4158: -- that CZ_PS_NODES.ib_trackable is populated correctly by Import
4159: --
4160: UPDATE cz_model_ref_expls
4161: SET has_trackable_children='1'
4162: WHERE model_id=t_m_chain_tbl(i) AND component_id=t_m_chain_tbl(i) AND deleted_flag=NO_FLAG AND
4163: EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS m WHERE model_id=t_m_chain_tbl(i) AND ps_node_type=REFERENCE_TYPE
4164: AND deleted_flag=NO_FLAG AND

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

4159: --
4160: UPDATE cz_model_ref_expls
4161: SET has_trackable_children='1'
4162: WHERE model_id=t_m_chain_tbl(i) AND component_id=t_m_chain_tbl(i) AND deleted_flag=NO_FLAG AND
4163: EXISTS(SELECT NULL FROM CZ_MODEL_REF_EXPLS m WHERE model_id=t_m_chain_tbl(i) AND ps_node_type=REFERENCE_TYPE
4164: AND deleted_flag=NO_FLAG AND
4165: EXISTS(SELECT NULL FROM CZ_PS_NODES
4166: WHERE devl_project_id = m.component_id AND
4167: ib_trackable = '1' AND deleted_flag = NO_FLAG));

Line 4190: UPDATE CZ_MODEL_REF_EXPLS SET has_trackable_children=v_ib_trackable

4186: IF v_ib_trackable=NO_FLAG THEN
4187: t_nontrk_tbl(t_nontrk_tbl.COUNT+1):=t_m_chain_tbl(i);
4188: END IF;
4189:
4190: UPDATE CZ_MODEL_REF_EXPLS SET has_trackable_children=v_ib_trackable
4191: WHERE model_id=t_m_chain_tbl(i) AND component_id=t_m_chain_tbl(i) AND deleted_flag=NO_FLAG;
4192:
4193: END LOOP;
4194:

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

4193: END LOOP;
4194:
4195: IF t_trk_tbl.COUNT>0 THEN
4196: FORALL i IN t_trk_tbl.First..t_trk_tbl.Last
4197: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children='1'
4198: WHERE component_id=t_trk_tbl(i) AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4199: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4200: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
4201: END IF;

Line 4205: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children=NO_FLAG

4201: END IF;
4202:
4203: IF t_nontrk_tbl.COUNT>0 THEN
4204: FORALL i IN t_nontrk_tbl.First..t_nontrk_tbl.Last
4205: UPDATE CZ_MODEL_REF_EXPLS a SET has_trackable_children=NO_FLAG
4206: WHERE component_id=t_nontrk_tbl(i) AND ps_node_type=REFERENCE_TYPE AND deleted_flag=NO_FLAG AND
4207: model_id IN(SELECT object_id FROM CZ_RP_ENTRIES
4208: WHERE object_id=a.model_id AND object_type='PRJ' AND deleted_flag=NO_FLAG);
4209: END IF;