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

Line 34: TYPE tNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;

30: TYPE t_indexes IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
31:
32: -- vsingava bug6638552 23rd Nov '08
33: -- performance fix for model report
34: TYPE tNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
35: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
36: TYPE tComponentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
37: TYPE tReferringId IS TABLE OF cz_model_ref_expls.referring_node_id%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

Line 35: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;

31:
32: -- vsingava bug6638552 23rd Nov '08
33: -- performance fix for model report
34: TYPE tNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
35: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
36: TYPE tComponentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
37: TYPE tReferringId IS TABLE OF cz_model_ref_expls.referring_node_id%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
39:

Line 36: TYPE tComponentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;

32: -- vsingava bug6638552 23rd Nov '08
33: -- performance fix for model report
34: TYPE tNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
35: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
36: TYPE tComponentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
37: TYPE tReferringId IS TABLE OF cz_model_ref_expls.referring_node_id%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
39:
40: -- tables to cache model explosion data

Line 37: TYPE tReferringId IS TABLE OF cz_model_ref_expls.referring_node_id%TYPE INDEX BY BINARY_INTEGER;

33: -- performance fix for model report
34: TYPE tNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
35: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
36: TYPE tComponentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
37: TYPE tReferringId IS TABLE OF cz_model_ref_expls.referring_node_id%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
39:
40: -- tables to cache model explosion data
41: v_NodeId tNodeId;

Line 38: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

34: TYPE tNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
35: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
36: TYPE tComponentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
37: TYPE tReferringId IS TABLE OF cz_model_ref_expls.referring_node_id%TYPE INDEX BY BINARY_INTEGER;
38: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
39:
40: -- tables to cache model explosion data
41: v_NodeId tNodeId;
42: v_ParentId tParentId;

Line 669: FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS

665:
666: BEGIN
667: l_delta := p_curr_node_depth - p_new_parent_expl_node_depth;
668:
669: FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS
670: START WITH model_ref_expl_id=p_model_ref_expl_id AND deleted_flag='0'
671: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0'
672: AND PRIOR deleted_flag='0')
673: LOOP

Line 674: x_expl_nodes_tbl(i.model_ref_expl_id) := allocateId('CZ_MODEL_REF_EXPLS_S');

670: START WITH model_ref_expl_id=p_model_ref_expl_id AND deleted_flag='0'
671: CONNECT BY PRIOR model_ref_expl_id=parent_expl_node_id AND deleted_flag='0'
672: AND PRIOR deleted_flag='0')
673: LOOP
674: x_expl_nodes_tbl(i.model_ref_expl_id) := allocateId('CZ_MODEL_REF_EXPLS_S');
675: --dbms_output.put_line('i.model_ref_expl_id:'||i.model_ref_expl_id);
676: --dbms_output.put_line(x_expl_nodes_tbl(i.model_ref_expl_id));
677: END LOOP;
678:

Line 686: FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS

682: IF l_index IS NULL THEN
683: EXIT;
684: END IF;
685:
686: FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS
687: WHERE model_ref_expl_id = l_index )
688: LOOP
689:
690: l_referring_node_id := NULL;

Line 714: INSERT INTO CZ_MODEL_REF_EXPLS

710: ELSE
711: l_referring_node_id := i.referring_node_id;
712: END IF;
713:
714: INSERT INTO CZ_MODEL_REF_EXPLS
715: (
716: MODEL_REF_EXPL_ID
717: ,COMPONENT_ID
718: ,PARENT_EXPL_NODE_ID

Line 825: FROM CZ_MODEL_REF_EXPLS

821:
822: -- if not a reference node, get the model_refexpl_id record in model ref expls
823: IF l_reference_id IS NULL THEN
824: SELECT model_ref_expl_id, node_depth INTO l_expl_id, l_curr_node_depth
825: FROM CZ_MODEL_REF_EXPLS
826: WHERE model_id=l_model_id AND component_id=l_component_id AND
827: child_model_expl_id IS NULL AND deleted_flag='0';
828: ELSE
829: SELECT MIN(node_depth) INTO l_min_node_depth

Line 830: FROM CZ_MODEL_REF_EXPLS

826: WHERE model_id=l_model_id AND component_id=l_component_id AND
827: child_model_expl_id IS NULL AND deleted_flag='0';
828: ELSE
829: SELECT MIN(node_depth) INTO l_min_node_depth
830: FROM CZ_MODEL_REF_EXPLS
831: WHERE model_id=l_model_id AND referring_node_id=p_node_id
832: AND deleted_flag='0';
833:
834: SELECT model_ref_expl_id, node_depth INTO l_expl_id, l_curr_node_depth

Line 835: FROM CZ_MODEL_REF_EXPLS

831: WHERE model_id=l_model_id AND referring_node_id=p_node_id
832: AND deleted_flag='0';
833:
834: SELECT model_ref_expl_id, node_depth INTO l_expl_id, l_curr_node_depth
835: FROM CZ_MODEL_REF_EXPLS
836: WHERE model_id=l_model_id AND referring_node_id=p_node_id AND
837: node_depth=l_min_node_depth AND deleted_flag='0';
838: END IF;
839:

Line 842: FROM CZ_MODEL_REF_EXPLS

838: END IF;
839:
840: -- get the ref expl id and node depth of the destination node in ref expls
841: SELECT model_ref_expl_id,node_depth INTO l_new_pr_expl_id, l_node_depth
842: FROM CZ_MODEL_REF_EXPLS
843: WHERE model_id=l_model_id AND component_id=(SELECT component_id
844: FROM CZ_PS_NODES WHERE ps_node_id = p_new_parent_id) AND referring_node_id IS NULL AND
845: child_model_expl_id IS NULL AND deleted_flag='0';
846:

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

1113:
1114: END LOOP;
1115:
1116: IF (l_virtual_flag='1' OR l_virtual_flag IS NULL) AND l_parent_id IS NOT NULL AND l_ps_node_type IN(COMPONENT_TYPE) THEN
1117: FOR i IN(SELECT model_ref_expl_id, node_depth FROM CZ_MODEL_REF_EXPLS
1118: WHERE parent_expl_node_id=l_expl_id AND
1119: (referring_node_id IS NULL AND component_id IN
1120: (SELECT ps_node_id FROM CZ_PS_NODES
1121: START WITH ps_node_id=p_node_id

Line 1125: SELECT model_ref_expl_id, node_depth FROM CZ_MODEL_REF_EXPLS

1121: START WITH ps_node_id=p_node_id
1122: CONNECT BY PRIOR ps_node_id=parent_id AND
1123: deleted_flag='0' AND PRIOR deleted_flag='0'))
1124: UNION
1125: SELECT model_ref_expl_id, node_depth FROM CZ_MODEL_REF_EXPLS
1126: WHERE parent_expl_node_id=l_expl_id AND
1127: (referring_node_id IS NOT NULL AND referring_node_id IN
1128: (SELECT ps_node_id FROM CZ_PS_NODES
1129: START WITH ps_node_id=p_node_id

Line 1253: FROM cz_model_ref_expls a, cz_ps_nodes b

1249: END IF;
1250:
1251: IF (l_ps_node_type_tbl(l_index) IN (263, 264)) THEN
1252: SELECT model_ref_expl_id INTO l_new_expl_id
1253: FROM cz_model_ref_expls a, cz_ps_nodes b
1254: WHERE a.referring_node_id = l_ps_nodes_tbl(l_index)
1255: AND a.referring_node_id = b.ps_node_id
1256: AND b.devl_project_id = l_model_id
1257: AND a.model_id = l_model_id

Line 1267: FROM cz_model_ref_expls a, cz_ps_nodes b

1263: FROM cz_ps_nodes
1264: WHERE ps_node_id=l_ps_nodes_tbl(l_index);
1265:
1266: SELECT model_ref_expl_id INTO l_new_expl_id
1267: FROM cz_model_ref_expls a, cz_ps_nodes b
1268: WHERE a.component_id = b.ps_node_id
1269: AND b.ps_node_id = l_new_component_id
1270: AND b.devl_project_id = l_model_id
1271: AND a.model_id = b.devl_project_id

Line 1295: FOR k IN (SELECT * FROM cz_model_ref_expls

1291: EXIT;
1292: END IF;
1293: IF (l_ps_node_type_tbl(l_index) IN (263, 264)) THEN
1294:
1295: FOR k IN (SELECT * FROM cz_model_ref_expls
1296: START WITH model_id=l_model_id AND referring_node_id = l_index
1297: AND component_id = l_comp_tbl(l_index) AND ps_node_type = l_ps_node_type_tbl(l_index)
1298: AND deleted_flag = '0'
1299: CONNECT BY PRIOR model_ref_expl_id = parent_expl_node_id

Line 1359: FOR k IN (SELECT * FROM cz_model_ref_expls

1355: EXIT;
1356: END IF;
1357: IF (l_ps_node_type_tbl(l_index) IN (263, 264)) THEN
1358:
1359: FOR k IN (SELECT * FROM cz_model_ref_expls
1360: START WITH model_id=l_model_id AND referring_node_id = l_index
1361: AND component_id = l_comp_tbl(l_index) AND ps_node_type = l_ps_node_type_tbl(l_index)
1362: AND deleted_flag = '0'
1363: CONNECT BY PRIOR model_ref_expl_id = parent_expl_node_id

Line 1935: FROM cz_model_ref_expls

1931: --
1932: WHEN NO_DATA_FOUND THEN -- node is under some referenced model
1933: -- find ps_node_id of nearest reference above
1934: FOR p IN (SELECT referring_node_id
1935: FROM cz_model_ref_expls
1936: START WITH model_ref_expl_id=l_model_ref_expl_id
1937: CONNECT by PRIOR parent_expl_node_id=model_ref_expl_id AND
1938: deleted_flag='0' AND PRIOR deleted_flag='0' AND
1939: PRIOR referring_node_id IS NULL)

Line 2823: FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS

2819: IF l_ps_node_id IS NOT NULL THEN
2820: RETURN l_model_path;
2821: END IF;
2822:
2823: FOR i IN(SELECT * FROM CZ_MODEL_REF_EXPLS
2824: START WITH model_ref_expl_id=p_model_ref_expl_id
2825: CONNECT BY PRIOR parent_expl_node_id=model_ref_expl_id
2826: AND deleted_flag='0' AND PRIOR deleted_flag='0')
2827: LOOP

Line 3089: FOR i IN (SELECT * FROM cz_model_ref_expls

3085: --If ps_node_id is in the model with model_id = p_model_id then full path is equal to absolute path.
3086:
3087: IF l_ps_node_id IS NOT NULL THEN RETURN l_model_path; END IF;
3088:
3089: FOR i IN (SELECT * FROM cz_model_ref_expls
3090: START WITH model_ref_expl_id = p_model_ref_expl_id
3091: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id
3092: AND deleted_flag='0' AND PRIOR deleted_flag='0') LOOP
3093:

Line 8751: (SELECT component_id FROM cz_model_ref_expls

8747: EXIT;
8748: END LOOP;
8749: FOR c_node IN (SELECT NULL FROM cz_ps_nodes WHERE deleted_flag = '0'
8750: AND devl_project_id IN
8751: (SELECT component_id FROM cz_model_ref_expls
8752: WHERE deleted_flag = '0'
8753: AND model_id = v_devl_project_id
8754: AND ps_node_type IN (PS_NODE_TYPE_REFERENCE, PS_NODE_TYPE_CONNECTOR))
8755: AND name = c_name.name)LOOP

Line 9761: FROM cz_model_ref_expls

9757: -- vsingava: 24-Nov-2008; Bug 7297669; Populate the data for all non-ModelReport runs
9758: IF NOT modelReportRun THEN
9759: SELECT model_ref_expl_id, parent_expl_node_id, component_id, referring_node_id, ps_node_type
9760: BULK COLLECT INTO v_NodeId, v_ParentId, v_ComponentId, v_ReferringId, v_NodeType
9761: FROM cz_model_ref_expls
9762: WHERE model_id = v_devl_project_id
9763: AND deleted_flag = '0';
9764:
9765: FOR i IN 1..v_NodeId.COUNT LOOP

Line 10002: FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id=p_node_expl_id;

9998: IF(p_base_expl_id = p_node_expl_id)THEN RETURN YES; END IF;
9999:
10000: SELECT model_id,component_id,referring_node_id
10001: INTO l_root_model_id, l_component_id, l_referring_node_id
10002: FROM CZ_MODEL_REF_EXPLS WHERE model_ref_expl_id=p_node_expl_id;
10003:
10004: IF l_referring_node_id IS NULL THEN
10005: SELECT devl_project_id INTO l_model_id FROM CZ_PS_NODES
10006: WHERE ps_node_id=l_component_id;

Line 10043: FROM cz_model_ref_expls

10039: END IF;
10040:
10041: SELECT model_ref_expl_id, expl_node_type
10042: BULK COLLECT INTO v_base_expl_id_tab, v_base_expl_type_tab
10043: FROM cz_model_ref_expls
10044: WHERE deleted_flag = '0'
10045: START WITH model_ref_expl_id = p_base_expl_id
10046: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
10047:

Line 10050: FROM cz_model_ref_expls

10046: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
10047:
10048: SELECT model_ref_expl_id, expl_node_type
10049: BULK COLLECT INTO v_node_expl_id_tab, v_node_expl_type_tab
10050: FROM cz_model_ref_expls
10051: WHERE deleted_flag = '0'
10052: START WITH model_ref_expl_id = p_node_expl_id
10053: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
10054:

Line 10153: FROM cz_model_ref_expls WHERE model_ref_expl_id = p_base_expl_id;

10149: BEGIN
10150:
10151: SELECT component_id, referring_node_id
10152: INTO l_component_id, l_referring_node_id
10153: FROM cz_model_ref_expls WHERE model_ref_expl_id = p_base_expl_id;
10154:
10155: IF(p_base_node_id <> NVL(l_referring_node_id, l_component_id))THEN base_is_in_subtree := TRUE; END IF;
10156:
10157: SELECT component_id, referring_node_id

Line 10159: FROM cz_model_ref_expls WHERE model_ref_expl_id = p_node_expl_id;

10155: IF(p_base_node_id <> NVL(l_referring_node_id, l_component_id))THEN base_is_in_subtree := TRUE; END IF;
10156:
10157: SELECT component_id, referring_node_id
10158: INTO l_component_id, l_referring_node_id
10159: FROM cz_model_ref_expls WHERE model_ref_expl_id = p_node_expl_id;
10160:
10161: IF(p_node_node_id <> NVL(l_referring_node_id, l_component_id))THEN node_is_in_subtree := TRUE; END IF;
10162:
10163: SELECT model_ref_expl_id, expl_node_type

Line 10165: FROM cz_model_ref_expls

10161: IF(p_node_node_id <> NVL(l_referring_node_id, l_component_id))THEN node_is_in_subtree := TRUE; END IF;
10162:
10163: SELECT model_ref_expl_id, expl_node_type
10164: BULK COLLECT INTO v_base_expl_id_tab, v_base_expl_type_tab
10165: FROM cz_model_ref_expls
10166: WHERE deleted_flag = '0'
10167: START WITH model_ref_expl_id = p_base_expl_id
10168: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
10169:

Line 10172: FROM cz_model_ref_expls

10168: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
10169:
10170: SELECT model_ref_expl_id, expl_node_type
10171: BULK COLLECT INTO v_node_expl_id_tab, v_node_expl_type_tab
10172: FROM cz_model_ref_expls
10173: WHERE deleted_flag = '0'
10174: START WITH model_ref_expl_id = p_node_expl_id
10175: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
10176:

Line 10298: FROM cz_model_ref_expls

10294: END IF;
10295:
10296: SELECT model_ref_expl_id, referring_node_id, ps_node_type
10297: BULK COLLECT INTO v_base_expl_id_tab, v_base_ref_id_tab, v_base_expl_type_tab
10298: FROM cz_model_ref_expls
10299: WHERE deleted_flag = '0'
10300: START WITH model_ref_expl_id = p_base_expl_id
10301: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
10302:

Line 10305: FROM cz_model_ref_expls

10301: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
10302:
10303: SELECT model_ref_expl_id, referring_node_id, ps_node_type
10304: BULK COLLECT INTO v_node_expl_id_tab, v_node_ref_id_tab, v_node_expl_type_tab
10305: FROM cz_model_ref_expls
10306: WHERE deleted_flag = '0'
10307: START WITH model_ref_expl_id = p_node_expl_id
10308: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
10309:

Line 10619: SELECT NULL INTO aux_flag FROM cz_model_ref_expls

10615: END;
10616: ---------------------------------------------------------------------------------------
10617: PROCEDURE verify_explosion(p_expl_id IN NUMBER) IS
10618: BEGIN
10619: SELECT NULL INTO aux_flag FROM cz_model_ref_expls
10620: WHERE deleted_flag = '0' AND model_ref_expl_id = p_expl_id
10621: AND model_id = v_model_id;
10622: EXCEPTION
10623: WHEN OTHERS THEN

Line 11240: FROM cz_model_ref_expls

11236: IF(p_base_pers_id = p_node_pers_id AND p_base_expl_id = p_node_expl_id)THEN RETURN NULL; END IF;
11237:
11238: SELECT model_ref_expl_id, referring_node_id, ps_node_type, component_id
11239: BULK COLLECT INTO v_base_expl_id_tab, v_base_ref_id_tab, v_base_expl_type_tab, v_base_component_id_tab
11240: FROM cz_model_ref_expls
11241: WHERE deleted_flag = '0'
11242: START WITH model_ref_expl_id = p_base_expl_id
11243: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
11244:

Line 11247: FROM cz_model_ref_expls

11243: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
11244:
11245: SELECT model_ref_expl_id, referring_node_id, ps_node_type, component_id
11246: BULK COLLECT INTO v_node_expl_id_tab, v_node_ref_id_tab, v_node_expl_type_tab, v_node_component_id_tab
11247: FROM cz_model_ref_expls
11248: WHERE deleted_flag = '0'
11249: START WITH model_ref_expl_id = p_node_expl_id
11250: CONNECT BY PRIOR parent_expl_node_id = model_ref_expl_id;
11251:

Line 11804: FROM cz_model_ref_expls

11800: END IF;
11801: END LOOP;
11802:
11803: SELECT referring_node_id, parent_expl_node_id INTO v_parent_id, v_expl_id
11804: FROM cz_model_ref_expls
11805: WHERE deleted_flag = '0'
11806: AND model_ref_expl_id = v_expl_id;
11807: END LOOP;
11808:

Line 11874: v_model_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;

11870: FUNCTION annotated_node_path(p_model_id IN NUMBER,
11871: p_model_ref_expl_id IN NUMBER,
11872: p_ps_node_id IN NUMBER) RETURN VARCHAR2
11873: IS
11874: v_model_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;
11875: BEGIN
11876:
11877: SELECT model_ref_expl_id INTO v_model_expl_id FROM cz_model_ref_expls
11878: WHERE deleted_flag = '0'

Line 11877: SELECT model_ref_expl_id INTO v_model_expl_id FROM cz_model_ref_expls

11873: IS
11874: v_model_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;
11875: BEGIN
11876:
11877: SELECT model_ref_expl_id INTO v_model_expl_id FROM cz_model_ref_expls
11878: WHERE deleted_flag = '0'
11879: AND model_id = p_model_id
11880: AND parent_expl_node_id IS NULL;
11881:

Line 12062: FROM cz_model_ref_expls

12058: modelReportRun := TRUE; -- vsingava: 24-Nov-2008; Bug 7297669
12059: --Intitialize the explosion data.
12060: SELECT model_ref_expl_id, parent_expl_node_id, component_id, referring_node_id, ps_node_type
12061: BULK COLLECT INTO v_NodeId, v_ParentId, v_ComponentId, v_ReferringId, v_NodeType
12062: FROM cz_model_ref_expls
12063: WHERE model_id IN (SELECT component_id FROM cz_model_ref_expls
12064: WHERE model_id = p_devl_project_id AND deleted_flag = '0')
12065: AND deleted_flag = '0';
12066:

Line 12063: WHERE model_id IN (SELECT component_id FROM cz_model_ref_expls

12059: --Intitialize the explosion data.
12060: SELECT model_ref_expl_id, parent_expl_node_id, component_id, referring_node_id, ps_node_type
12061: BULK COLLECT INTO v_NodeId, v_ParentId, v_ComponentId, v_ReferringId, v_NodeType
12062: FROM cz_model_ref_expls
12063: WHERE model_id IN (SELECT component_id FROM cz_model_ref_expls
12064: WHERE model_id = p_devl_project_id AND deleted_flag = '0')
12065: AND deleted_flag = '0';
12066:
12067: h_ParentId.DELETE;