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

Line 63: TYPE tExplNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER; --kdande; Bug 6881902; 11-Mar-2008

59: TYPE tSetEffId IS TABLE OF cz_effectivity_sets.effectivity_set_id%TYPE INDEX BY BINARY_INTEGER;
60: TYPE tSetName IS TABLE OF cz_effectivity_sets.name%TYPE INDEX BY BINARY_INTEGER;
61:
62: TYPE tHeaderId IS TABLE OF cz_lce_headers.lce_header_id%TYPE INDEX BY VARCHAR2(15);
63: TYPE tExplNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER; --kdande; Bug 6881902; 11-Mar-2008
64: TYPE tExplNodeId_idx_vc2 IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY VARCHAR2(15); --kdande; Bug 6881902; 11-Mar-2008
65:
66: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
67: TYPE tExprSubtype IS TABLE OF cz_expression_nodes.expr_subtype%TYPE INDEX BY BINARY_INTEGER;

Line 64: TYPE tExplNodeId_idx_vc2 IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY VARCHAR2(15); --kdande; Bug 6881902; 11-Mar-2008

60: TYPE tSetName IS TABLE OF cz_effectivity_sets.name%TYPE INDEX BY BINARY_INTEGER;
61:
62: TYPE tHeaderId IS TABLE OF cz_lce_headers.lce_header_id%TYPE INDEX BY VARCHAR2(15);
63: TYPE tExplNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER; --kdande; Bug 6881902; 11-Mar-2008
64: TYPE tExplNodeId_idx_vc2 IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY VARCHAR2(15); --kdande; Bug 6881902; 11-Mar-2008
65:
66: TYPE tExprType IS TABLE OF cz_expression_nodes.expr_type%TYPE INDEX BY BINARY_INTEGER;
67: TYPE tExprSubtype IS TABLE OF cz_expression_nodes.expr_subtype%TYPE INDEX BY BINARY_INTEGER;
68: TYPE tExprId IS TABLE OF cz_expression_nodes.expr_node_id%TYPE INDEX BY BINARY_INTEGER;

Line 207: ' FROM cz_devl_projects proj, cz_model_ref_expls expl, cz_lce_headers head' ||

203: l_locked_models cz_security_pvt.number_type_tbl;
204: FAILED_TO_LOCK_MODEL EXCEPTION;
205:
206: logicSQL VARCHAR2(4000) := 'SELECT proj.devl_project_id, proj.last_logic_update, head.creation_date' ||
207: ' FROM cz_devl_projects proj, cz_model_ref_expls expl, cz_lce_headers head' ||
208: ' WHERE proj.deleted_flag = ''' || FLAG_NOT_DELETED ||
209: ''' AND expl.deleted_flag = ''' || FLAG_NOT_DELETED ||
210: ''' AND head.deleted_flag = ''' || FLAG_NOT_DELETED ||
211: ''' AND expl.node_depth = 1' ||

Line 221: ' (SELECT model_id FROM cz_model_ref_expls' ||

217: h_containerReferred tIntegerArray_idx_vc2;
218: containerReferred VARCHAR2(4000) :=
219:
220: 'SELECT 1 FROM DUAL WHERE EXISTS' ||
221: ' (SELECT model_id FROM cz_model_ref_expls' ||
222: ' WHERE deleted_flag = ''' || FLAG_NOT_DELETED || '''' ||
223: ' AND ps_node_type IN (' || PS_NODE_TYPE_REFERENCE || ', ' || PS_NODE_TYPE_CONNECTOR || ')' ||
224: ' AND component_id = :1' ||
225: ' AND (SELECT model_type FROM cz_devl_projects' ||

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

276: inProjectId IN NUMBER,
277: inParentLogicHeaderId IN NUMBER)
278: IS
279:
280: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
281: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
282: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
283: TYPE tParentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
284: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;

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

277: inParentLogicHeaderId IN NUMBER)
278: IS
279:
280: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
281: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
282: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
283: TYPE tParentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
284: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
285: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;

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

278: IS
279:
280: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
281: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
282: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
283: TYPE tParentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
284: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
285: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
286: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;

Line 283: TYPE tParentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;

279:
280: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
281: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
282: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
283: TYPE tParentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
284: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
285: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
286: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;
287: --kdande; Bug 6881902; 11-Mar-2008; Made the following PLSQL types local to the procedure as they are used for Bulk Collects

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

280: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
281: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
282: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
283: TYPE tParentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
284: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
285: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
286: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;
287: --kdande; Bug 6881902; 11-Mar-2008; Made the following PLSQL types local to the procedure as they are used for Bulk Collects
288: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

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

281: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
282: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
283: TYPE tParentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
284: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
285: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
286: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;
287: --kdande; Bug 6881902; 11-Mar-2008; Made the following PLSQL types local to the procedure as they are used for Bulk Collects
288: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
289: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;

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

282: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
283: TYPE tParentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
284: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
285: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
286: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;
287: --kdande; Bug 6881902; 11-Mar-2008; Made the following PLSQL types local to the procedure as they are used for Bulk Collects
288: TYPE tPsNodeType IS TABLE OF cz_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
289: TYPE tReferenceId IS TABLE OF cz_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
290: TYPE tDecimalQty IS TABLE OF cz_ps_nodes.decimal_qty_flag%TYPE INDEX BY BINARY_INTEGER;

Line 345: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;

341:
342: v_IndexByNodeId tIntegerArray_idx_vc2;
343: v_TypeByExplId tExplNodeType;
344:
345: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;
346: thisProjectId cz_devl_projects.devl_project_id%TYPE;
347: thisProjectName cz_devl_projects.name%TYPE;
348: thisProjectType cz_devl_projects.model_type%TYPE;
349: thisRootExplIndex PLS_INTEGER;

Line 683: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;

679: nPresentationFlag cz_rules.presentation_flag%TYPE;
680: vRuleName cz_rules.name%TYPE;
681: vUsageMask cz_rules.effective_usage_mask%TYPE;
682: vClassName cz_rules.class_name%TYPE;
683: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
684: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
685: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
686: baseDepthValue cz_model_ref_expls.node_depth%TYPE;
687: nHeaderId cz_lce_headers.lce_header_id%TYPE;

Line 684: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;

680: vRuleName cz_rules.name%TYPE;
681: vUsageMask cz_rules.effective_usage_mask%TYPE;
682: vClassName cz_rules.class_name%TYPE;
683: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
684: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
685: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
686: baseDepthValue cz_model_ref_expls.node_depth%TYPE;
687: nHeaderId cz_lce_headers.lce_header_id%TYPE;
688: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;

Line 685: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;

681: vUsageMask cz_rules.effective_usage_mask%TYPE;
682: vClassName cz_rules.class_name%TYPE;
683: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
684: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
685: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
686: baseDepthValue cz_model_ref_expls.node_depth%TYPE;
687: nHeaderId cz_lce_headers.lce_header_id%TYPE;
688: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;
689: nNewLogicFileFlag PLS_INTEGER := 0;

Line 686: baseDepthValue cz_model_ref_expls.node_depth%TYPE;

682: vClassName cz_rules.class_name%TYPE;
683: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
684: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
685: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
686: baseDepthValue cz_model_ref_expls.node_depth%TYPE;
687: nHeaderId cz_lce_headers.lce_header_id%TYPE;
688: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;
689: nNewLogicFileFlag PLS_INTEGER := 0;
690: nRuleAssignedLevel PLS_INTEGER;

Line 1361: ExplId cz_model_ref_expls.model_ref_expl_id%TYPE := v_tExplNodeId(j);

1357: v_return VARCHAR2(4000);
1358: counter PLS_INTEGER;
1359: val PLS_INTEGER;
1360: delimiter CHAR(1) := NULL;
1361: ExplId cz_model_ref_expls.model_ref_expl_id%TYPE := v_tExplNodeId(j);
1362: BEGIN
1363:
1364: IF(NOT v_NodeUpPath.EXISTS(ExplId))THEN
1365: counter := nRuleAssignedLevel;

Line 9856: FROM cz_model_ref_expls

9852: child_model_expl_id, expl_node_type
9853: BULK COLLECT INTO v_NodeId, v_tParentId, v_tNodeDepth,
9854: v_tNodeType, v_tVirtualFlag, v_tPsNodeId, v_tReferringId,
9855: v_tChildModelExpl, v_tExplNodeType
9856: FROM cz_model_ref_expls
9857: WHERE model_id = inComponentId AND deleted_flag = FLAG_NOT_DELETED;
9858:
9859: FOR i IN 1..v_NodeId.COUNT LOOP
9860: