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 208: ' FROM cz_devl_projects proj, cz_model_ref_expls expl, cz_lce_headers head' ||

204: FAILED_TO_LOCK_MODEL EXCEPTION;
205:
206: --bug fix 8689041 Modified the criteria to retrieve last_logic_update and logic creation_date
207: logicSQL VARCHAR2(4000) := 'SELECT proj.devl_project_id, max(proj.last_logic_update),max(head.creation_date)' ||
208: ' FROM cz_devl_projects proj, cz_model_ref_expls expl, cz_lce_headers head' ||
209: ' WHERE proj.deleted_flag = ''' || FLAG_NOT_DELETED ||
210: ''' AND expl.deleted_flag = ''' || FLAG_NOT_DELETED ||
211: ''' AND head.deleted_flag = ''' || FLAG_NOT_DELETED ||
212: ''' AND expl.node_depth = 1' ||

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

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

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

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

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

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

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

282: IS
283:
284: TYPE tNodeDepth IS TABLE OF cz_model_ref_expls.node_depth%TYPE INDEX BY BINARY_INTEGER;
285: TYPE tNodeType IS TABLE OF cz_model_ref_expls.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
286: TYPE tVirtualFlag IS TABLE OF cz_model_ref_expls.virtual_flag%TYPE INDEX BY BINARY_INTEGER;
287: TYPE tParentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
288: TYPE tPsNodeId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
289: TYPE tChildModelExpl IS TABLE OF cz_model_ref_expls.child_model_expl_id%TYPE INDEX BY BINARY_INTEGER;
290: TYPE tExplNodeType IS TABLE OF cz_model_ref_expls.expl_node_type%TYPE INDEX BY BINARY_INTEGER;

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

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

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

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

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

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

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

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

Line 349: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;

345:
346: v_IndexByNodeId tIntegerArray_idx_vc2;
347: v_TypeByExplId tExplNodeType;
348:
349: thisComponentExplId cz_model_ref_expls.model_ref_expl_id%TYPE;
350: thisProjectId cz_devl_projects.devl_project_id%TYPE;
351: thisProjectName cz_devl_projects.name%TYPE;
352: thisProjectType cz_devl_projects.model_type%TYPE;
353: thisRootExplIndex PLS_INTEGER;

Line 694: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;

690: nPresentationFlag cz_rules.presentation_flag%TYPE;
691: vRuleName cz_rules.name%TYPE;
692: vUsageMask cz_rules.effective_usage_mask%TYPE;
693: vClassName cz_rules.class_name%TYPE;
694: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
695: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
696: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
697: baseDepthValue cz_model_ref_expls.node_depth%TYPE;
698: nHeaderId cz_lce_headers.lce_header_id%TYPE;

Line 695: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;

691: vRuleName cz_rules.name%TYPE;
692: vUsageMask cz_rules.effective_usage_mask%TYPE;
693: vClassName cz_rules.class_name%TYPE;
694: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
695: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
696: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
697: baseDepthValue cz_model_ref_expls.node_depth%TYPE;
698: nHeaderId cz_lce_headers.lce_header_id%TYPE;
699: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;

Line 696: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;

692: vUsageMask cz_rules.effective_usage_mask%TYPE;
693: vClassName cz_rules.class_name%TYPE;
694: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
695: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
696: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
697: baseDepthValue cz_model_ref_expls.node_depth%TYPE;
698: nHeaderId cz_lce_headers.lce_header_id%TYPE;
699: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;
700: nNewLogicFileFlag PLS_INTEGER := 0;

Line 697: baseDepthValue cz_model_ref_expls.node_depth%TYPE;

693: vClassName cz_rules.class_name%TYPE;
694: MaxDepthId cz_model_ref_expls.model_ref_expl_id%TYPE;
695: nAux cz_model_ref_expls.model_ref_expl_id%TYPE;
696: MaxDepthValue cz_model_ref_expls.node_depth%TYPE;
697: baseDepthValue cz_model_ref_expls.node_depth%TYPE;
698: nHeaderId cz_lce_headers.lce_header_id%TYPE;
699: nPreviousHeaderId cz_lce_headers.lce_header_id%TYPE;
700: nNewLogicFileFlag PLS_INTEGER := 0;
701: nRuleAssignedLevel PLS_INTEGER;

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

1368: v_return VARCHAR2(4000);
1369: counter PLS_INTEGER;
1370: val PLS_INTEGER;
1371: delimiter CHAR(1) := NULL;
1372: ExplId cz_model_ref_expls.model_ref_expl_id%TYPE := v_tExplNodeId(j);
1373: BEGIN
1374:
1375: IF(NOT v_NodeUpPath.EXISTS(ExplId))THEN
1376: counter := nRuleAssignedLevel;

Line 9888: FROM cz_model_ref_expls

9884: child_model_expl_id, expl_node_type
9885: BULK COLLECT INTO v_NodeId, v_tParentId, v_tNodeDepth,
9886: v_tNodeType, v_tVirtualFlag, v_tPsNodeId, v_tReferringId,
9887: v_tChildModelExpl, v_tExplNodeType
9888: FROM cz_model_ref_expls
9889: WHERE model_id = inComponentId AND deleted_flag = FLAG_NOT_DELETED;
9890:
9891: FOR i IN 1..v_NodeId.COUNT LOOP
9892:

Line 11109: (SELECT DISTINCT component_id FROM cz_model_ref_expls

11105: AND MODEL.deleted_flag = '0'
11106: AND PARENT.devl_project_id = MODEL.object_id
11107: AND MODEL.object_type = 'PRJ'
11108: AND parent.devl_project_id IN
11109: (SELECT DISTINCT component_id FROM cz_model_ref_expls
11110: WHERE deleted_flag = '0' AND model_id = inDevlProjectId
11111: AND (ps_node_type = CZ_TYPES.PS_NODE_TYPE_REFERENCE
11112: OR ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_MODEL))
11113: AND PARENT.ps_node_type = CZ_TYPES.PS_NODE_TYPE_BOM_OPTION_CLASS