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

Line 482: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;

478: BEGIN
479:
480: --Initialize id allocation for model explosions ids
481:
482: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;
483: next_expl_id := base_expl_id;
484:
485: --Initialize id allocation for ps_node ids
486:

Line 562: (SELECT NULL FROM cz_model_ref_expls

558: WHERE deleted_flag = flag_not_deleted
559: AND ps_node_type = ps_node_type_product
560: AND devl_project_id = p.devl_project_id)
561: AND NOT EXISTS
562: (SELECT NULL FROM cz_model_ref_expls
563: WHERE model_id = p.devl_project_id)
564: ) LOOP
565:
566: IF(c_devl.orig_sys_ref IS NOT NULL)THEN

Line 705: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;

701: BEGIN
702:
703: current_expl_id := next_expl_id;
704: IF(next_expl_id = base_expl_id)THEN
705: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;
706: END IF;
707: next_expl_id := next_expl_id + 1;
708:
709: IF(inparentexplid IS NULL)THEN

Line 721: INSERT INTO cz_model_ref_expls

717: IF(npsnodetype IN (ps_node_type_bom_model/*, ps_node_type_product*/))THEN
718: localmodelid := incomponentid;
719: END IF;
720:
721: INSERT INTO cz_model_ref_expls
722: (model_ref_expl_id, parent_expl_node_id, component_id, model_id,
723: node_depth, virtual_flag, deleted_flag, ps_node_type)
724: SELECT
725: current_expl_id,

Line 733: (SELECT NULL FROM cz_model_ref_expls WHERE model_id = localmodelid AND component_id = incomponentid);

729: decode(npsnodetype, ps_node_type_bom_model, 0, /*PS_NODE_TYPE_PRODUCT, 0,*/ inlogicnetlevel),
730: decode(inlogicnetlevel, 0, flag_virtual, svirtualflag),
731: flag_not_deleted, npsnodetype
732: FROM dual WHERE NOT EXISTS
733: (SELECT NULL FROM cz_model_ref_expls WHERE model_id = localmodelid AND component_id = incomponentid);
734:
735: correct_expl_id := current_expl_id;
736:
737: IF(npsnodetype IN (ps_node_type_bom_model/*, ps_node_type_product*/))THEN

Line 739: FOR expl IN (SELECT model_ref_expl_id, node_depth, model_id FROM cz_model_ref_expls

735: correct_expl_id := current_expl_id;
736:
737: IF(npsnodetype IN (ps_node_type_bom_model/*, ps_node_type_product*/))THEN
738:
739: FOR expl IN (SELECT model_ref_expl_id, node_depth, model_id FROM cz_model_ref_expls
740: WHERE component_id = inparentcomponentid) LOOP
741:
742: BEGIN
743:

Line 746: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;

742: BEGIN
743:
744: local_expl_id := next_expl_id;
745: IF(next_expl_id = base_expl_id)THEN
746: SELECT cz_model_ref_expls_s.NEXTVAL INTO base_expl_id FROM dual;
747: END IF;
748: next_expl_id := next_expl_id + 1;
749:
750: IF(expl.model_id = root_model_id)THEN correct_expl_id := local_expl_id; END IF;

Line 752: INSERT INTO cz_model_ref_expls

748: next_expl_id := next_expl_id + 1;
749:
750: IF(expl.model_id = root_model_id)THEN correct_expl_id := local_expl_id; END IF;
751:
752: INSERT INTO cz_model_ref_expls
753: (model_ref_expl_id, parent_expl_node_id, node_depth, ps_node_type, virtual_flag,
754: component_id, model_id, referring_node_id, child_model_expl_id, deleted_flag)
755: SELECT
756: local_expl_id, expl.model_ref_expl_id, expl.node_depth + 1, ps_node_type_reference,

Line 760: (SELECT NULL FROM cz_model_ref_expls

756: local_expl_id, expl.model_ref_expl_id, expl.node_depth + 1, ps_node_type_reference,
757: flag_virtual, incomponentid, expl.model_id, inreferringnodeid, current_expl_id,
758: flag_not_deleted
759: FROM dual WHERE NOT EXISTS
760: (SELECT NULL FROM cz_model_ref_expls
761: WHERE component_id = incomponentid
762: AND model_id = expl.model_id
763: AND referring_node_id = inreferringnodeid
764: AND child_model_expl_id = current_expl_id);

Line 1180: FROM cz_model_ref_expls

1176: SELECT component_id
1177: BULK
1178: COLLECT
1179: INTO v_child_models_tbl
1180: FROM cz_model_ref_expls
1181: WHERE cz_model_ref_expls.model_id = v_published_root_models_tbl(rootModel)
1182: AND cz_model_ref_expls.deleted_flag = '0';
1183: -----AND cz_model_ref_expls.ps_node_type = '263';
1184: EXCEPTION

Line 1181: WHERE cz_model_ref_expls.model_id = v_published_root_models_tbl(rootModel)

1177: BULK
1178: COLLECT
1179: INTO v_child_models_tbl
1180: FROM cz_model_ref_expls
1181: WHERE cz_model_ref_expls.model_id = v_published_root_models_tbl(rootModel)
1182: AND cz_model_ref_expls.deleted_flag = '0';
1183: -----AND cz_model_ref_expls.ps_node_type = '263';
1184: EXCEPTION
1185: WHEN NO_DATA_FOUND THEN

Line 1182: AND cz_model_ref_expls.deleted_flag = '0';

1178: COLLECT
1179: INTO v_child_models_tbl
1180: FROM cz_model_ref_expls
1181: WHERE cz_model_ref_expls.model_id = v_published_root_models_tbl(rootModel)
1182: AND cz_model_ref_expls.deleted_flag = '0';
1183: -----AND cz_model_ref_expls.ps_node_type = '263';
1184: EXCEPTION
1185: WHEN NO_DATA_FOUND THEN
1186: x_err_message := substr(SQLERRM,1,2000);

Line 1183: -----AND cz_model_ref_expls.ps_node_type = '263';

1179: INTO v_child_models_tbl
1180: FROM cz_model_ref_expls
1181: WHERE cz_model_ref_expls.model_id = v_published_root_models_tbl(rootModel)
1182: AND cz_model_ref_expls.deleted_flag = '0';
1183: -----AND cz_model_ref_expls.ps_node_type = '263';
1184: EXCEPTION
1185: WHEN NO_DATA_FOUND THEN
1186: x_err_message := substr(SQLERRM,1,2000);
1187: WHEN OTHERS THEN

Line 1300: FROM cz_model_ref_expls

1296: -----get explosion id for above selected v_model_id
1297: BEGIN
1298: SELECT model_ref_expl_id
1299: INTO v_model_ref_expl_id
1300: FROM cz_model_ref_expls
1301: WHERE cz_model_ref_expls.model_id = v_model_id
1302: AND cz_model_ref_expls.component_id = v_component_id
1303: AND cz_model_ref_expls.deleted_flag = '0';
1304: EXCEPTION

Line 1301: WHERE cz_model_ref_expls.model_id = v_model_id

1297: BEGIN
1298: SELECT model_ref_expl_id
1299: INTO v_model_ref_expl_id
1300: FROM cz_model_ref_expls
1301: WHERE cz_model_ref_expls.model_id = v_model_id
1302: AND cz_model_ref_expls.component_id = v_component_id
1303: AND cz_model_ref_expls.deleted_flag = '0';
1304: EXCEPTION
1305: WHEN NO_DATA_FOUND THEN

Line 1302: AND cz_model_ref_expls.component_id = v_component_id

1298: SELECT model_ref_expl_id
1299: INTO v_model_ref_expl_id
1300: FROM cz_model_ref_expls
1301: WHERE cz_model_ref_expls.model_id = v_model_id
1302: AND cz_model_ref_expls.component_id = v_component_id
1303: AND cz_model_ref_expls.deleted_flag = '0';
1304: EXCEPTION
1305: WHEN NO_DATA_FOUND THEN
1306: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_model_ref_expls for model_id '||v_model_id;

Line 1303: AND cz_model_ref_expls.deleted_flag = '0';

1299: INTO v_model_ref_expl_id
1300: FROM cz_model_ref_expls
1301: WHERE cz_model_ref_expls.model_id = v_model_id
1302: AND cz_model_ref_expls.component_id = v_component_id
1303: AND cz_model_ref_expls.deleted_flag = '0';
1304: EXCEPTION
1305: WHEN NO_DATA_FOUND THEN
1306: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_model_ref_expls for model_id '||v_model_id;
1307: RAISE;

Line 1306: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_model_ref_expls for model_id '||v_model_id;

1302: AND cz_model_ref_expls.component_id = v_component_id
1303: AND cz_model_ref_expls.deleted_flag = '0';
1304: EXCEPTION
1305: WHEN NO_DATA_FOUND THEN
1306: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_model_ref_expls for model_id '||v_model_id;
1307: RAISE;
1308: WHEN OTHERS THEN
1309: RAISE;
1310: END;

Line 1313: ------get the component_id from cz_model_ref_expls for v_model_ref_expl_id

1309: RAISE;
1310: END;
1311:
1312: ELSIF (v_net_type = 2) THEN
1313: ------get the component_id from cz_model_ref_expls for v_model_ref_expl_id
1314: BEGIN
1315: SELECT component_id
1316: INTO v_component_id
1317: FROM cz_model_ref_expls

Line 1317: FROM cz_model_ref_expls

1313: ------get the component_id from cz_model_ref_expls for v_model_ref_expl_id
1314: BEGIN
1315: SELECT component_id
1316: INTO v_component_id
1317: FROM cz_model_ref_expls
1318: WHERE cz_model_ref_expls.model_ref_expl_id = v_model_ref_expl_id
1319: AND cz_model_ref_expls.deleted_flag = '0';
1320: EXCEPTION
1321: WHEN NO_DATA_FOUND THEN

Line 1318: WHERE cz_model_ref_expls.model_ref_expl_id = v_model_ref_expl_id

1314: BEGIN
1315: SELECT component_id
1316: INTO v_component_id
1317: FROM cz_model_ref_expls
1318: WHERE cz_model_ref_expls.model_ref_expl_id = v_model_ref_expl_id
1319: AND cz_model_ref_expls.deleted_flag = '0';
1320: EXCEPTION
1321: WHEN NO_DATA_FOUND THEN
1322: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';

Line 1319: AND cz_model_ref_expls.deleted_flag = '0';

1315: SELECT component_id
1316: INTO v_component_id
1317: FROM cz_model_ref_expls
1318: WHERE cz_model_ref_expls.model_ref_expl_id = v_model_ref_expl_id
1319: AND cz_model_ref_expls.deleted_flag = '0';
1320: EXCEPTION
1321: WHEN NO_DATA_FOUND THEN
1322: x_populate_error_msg := 'The component_id '||v_component_id||' of lce_header_id '||p_lce_header_id||' does not have associated record in cz_ps_nodes';
1323: RAISE;

Line 1328: ------get the component_id from cz_model_ref_expls for v_model_ref_expl_id

1324: WHEN OTHERS THEN
1325: RAISE;
1326: END;
1327:
1328: ------get the component_id from cz_model_ref_expls for v_model_ref_expl_id
1329: BEGIN
1330: SELECT devl_project_id
1331: INTO v_model_id
1332: FROM cz_ps_nodes

Line 1584: FROM cz_model_ref_expls

1580: IF (v_attachment_expl_id IS NOT NULL) THEN
1581: v_required_expl_chk_count := 0;
1582: SELECT count(*)
1583: INTO v_required_expl_chk_count
1584: FROM cz_model_ref_expls
1585: WHERE cz_model_ref_expls.model_id = (SELECT model_id
1586: FROM cz_model_ref_expls t
1587: WHERE t.model_ref_expl_id = v_attachment_expl_id
1588: AND t.deleted_flag = '0')

Line 1585: WHERE cz_model_ref_expls.model_id = (SELECT model_id

1581: v_required_expl_chk_count := 0;
1582: SELECT count(*)
1583: INTO v_required_expl_chk_count
1584: FROM cz_model_ref_expls
1585: WHERE cz_model_ref_expls.model_id = (SELECT model_id
1586: FROM cz_model_ref_expls t
1587: WHERE t.model_ref_expl_id = v_attachment_expl_id
1588: AND t.deleted_flag = '0')
1589: AND cz_model_ref_expls.model_ref_expl_id = v_required_expl_tbl(reqdExplId)

Line 1586: FROM cz_model_ref_expls t

1582: SELECT count(*)
1583: INTO v_required_expl_chk_count
1584: FROM cz_model_ref_expls
1585: WHERE cz_model_ref_expls.model_id = (SELECT model_id
1586: FROM cz_model_ref_expls t
1587: WHERE t.model_ref_expl_id = v_attachment_expl_id
1588: AND t.deleted_flag = '0')
1589: AND cz_model_ref_expls.model_ref_expl_id = v_required_expl_tbl(reqdExplId)
1590: AND cz_model_ref_expls.deleted_flag = '0';

Line 1589: AND cz_model_ref_expls.model_ref_expl_id = v_required_expl_tbl(reqdExplId)

1585: WHERE cz_model_ref_expls.model_id = (SELECT model_id
1586: FROM cz_model_ref_expls t
1587: WHERE t.model_ref_expl_id = v_attachment_expl_id
1588: AND t.deleted_flag = '0')
1589: AND cz_model_ref_expls.model_ref_expl_id = v_required_expl_tbl(reqdExplId)
1590: AND cz_model_ref_expls.deleted_flag = '0';
1591:
1592: IF (v_required_expl_chk_count = 0) THEN
1593: x_error_status := -1;

Line 1590: AND cz_model_ref_expls.deleted_flag = '0';

1586: FROM cz_model_ref_expls t
1587: WHERE t.model_ref_expl_id = v_attachment_expl_id
1588: AND t.deleted_flag = '0')
1589: AND cz_model_ref_expls.model_ref_expl_id = v_required_expl_tbl(reqdExplId)
1590: AND cz_model_ref_expls.deleted_flag = '0';
1591:
1592: IF (v_required_expl_chk_count = 0) THEN
1593: x_error_status := -1;
1594: x_error_msg := 'The required expl id '||v_required_expl_tbl(reqdExplId)||' is not in the explosion tree of root expl id '||v_attachment_expl_id;

Line 1652: TYPE tExplNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;

1648: TYPE tSetEffId IS TABLE OF cz_effectivity_sets.effectivity_set_id%TYPE INDEX BY BINARY_INTEGER;
1649: TYPE tSetName IS TABLE OF cz_effectivity_sets.name%TYPE INDEX BY BINARY_INTEGER;
1650:
1651: TYPE tHeaderId IS TABLE OF cz_lce_headers.lce_header_id%TYPE INDEX BY BINARY_INTEGER;
1652: TYPE tExplNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
1653: TYPE tExplNodeId_idx_vc2 IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY VARCHAR2(15);
1654:
1655: IsLogicGenerated tIntegerArray_idx_vc2; --jonatara:int2long:bug6054920
1656:

Line 1653: TYPE tExplNodeId_idx_vc2 IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY VARCHAR2(15);

1649: TYPE tSetName IS TABLE OF cz_effectivity_sets.name%TYPE INDEX BY BINARY_INTEGER;
1650:
1651: TYPE tHeaderId IS TABLE OF cz_lce_headers.lce_header_id%TYPE INDEX BY BINARY_INTEGER;
1652: TYPE tExplNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
1653: TYPE tExplNodeId_idx_vc2 IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY VARCHAR2(15);
1654:
1655: IsLogicGenerated tIntegerArray_idx_vc2; --jonatara:int2long:bug6054920
1656:
1657: glPsNodeId tPsNodeId;

Line 1711: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;

1707: PROCEDURE GENERATE_COMPONENT_TREE(inComponentId IN NUMBER,
1708: inProjectId IN NUMBER)
1709: IS
1710:
1711: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
1712: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1713: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1714: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
1715: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;

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

1708: inProjectId IN NUMBER)
1709: IS
1710:
1711: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
1712: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1713: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1714: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
1715: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
1716: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;

Line 1713: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;

1709: IS
1710:
1711: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
1712: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1713: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1714: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
1715: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
1716: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
1717: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;

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

1710:
1711: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
1712: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1713: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1714: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
1715: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
1716: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
1717: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;
1718:

Line 1715: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;

1711: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
1712: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1713: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1714: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
1715: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
1716: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
1717: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;
1718:
1719: ntPsNodeId tPsNodeId;

Line 1716: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;

1712: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
1713: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1714: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
1715: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
1716: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
1717: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;
1718:
1719: ntPsNodeId tPsNodeId;
1720: ntItemId tItemId;

Line 1717: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;

1713: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
1714: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
1715: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
1716: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
1717: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;
1718:
1719: ntPsNodeId tPsNodeId;
1720: ntItemId tItemId;
1721: ntPersistentId tPersistentId;

Line 1755: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;

1751:
1752: v_IndexByNodeId tIntegerArray;
1753: v_TypeByExplId tExplNodeType;
1754:
1755: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;
1756: thisProjectId cz_devl_projects.devl_project_id%TYPE;
1757: thisRootExplIndex PLS_INTEGER;
1758:
1759: i PLS_INTEGER;

Line 1848: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;

1844: nRuleOperator cz_rules.expr_rule_type%TYPE;
1845: nReasonId cz_rules.reason_id%TYPE;
1846: vRuleName cz_rules.name%TYPE;
1847: vUsageMask cz_rules.effective_usage_mask%TYPE;
1848: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
1849: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
1850: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
1851: nHeaderId cz_lce_headers.lce_header_id%TYPE;
1852: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;

Line 1849: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;

1845: nReasonId cz_rules.reason_id%TYPE;
1846: vRuleName cz_rules.name%TYPE;
1847: vUsageMask cz_rules.effective_usage_mask%TYPE;
1848: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
1849: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
1850: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
1851: nHeaderId cz_lce_headers.lce_header_id%TYPE;
1852: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;
1853: nNewLogicFileFlag PLS_INTEGER := 0;

Line 1850: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;

1846: vRuleName cz_rules.name%TYPE;
1847: vUsageMask cz_rules.effective_usage_mask%TYPE;
1848: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
1849: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
1850: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
1851: nHeaderId cz_lce_headers.lce_header_id%TYPE;
1852: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;
1853: nNewLogicFileFlag PLS_INTEGER := 0;
1854: nRuleAssignedLevel PLS_INTEGER;

Line 2699: FROM cz_model_ref_expls

2695: child_model_expl_id, expl_node_type
2696: BULK COLLECT INTO v_NodeId, v_tParentId, v_tNodeDepth,
2697: v_tNodeType, v_tVirtualFlag, v_tPsNodeId, v_tReferringId,
2698: v_tChildModelExpl, v_tExplNodeType
2699: FROM cz_model_ref_expls
2700: WHERE model_id = inComponentId and deleted_flag = FLAG_NOT_DELETED;
2701:
2702: FOR i IN 1..v_NodeId.COUNT LOOP
2703:

Line 3223: FROM CZ_MODEL_REF_EXPLS

3219: COLLECT
3220: INTO t_uis_ref
3221: FROM cz_ui_defs
3222: WHERE cz_ui_defs.devl_project_id IN (SELECT COMPONENT_ID
3223: FROM CZ_MODEL_REF_EXPLS
3224: WHERE model_id = t_model_ids_tbl(i)
3225: AND deleted_flag = '0')
3226: AND cz_ui_defs.deleted_flag = '0'
3227: AND cz_ui_defs.ui_style = '0';