APPS.CZ_TYPES dependencies on CZ_PS_NODES

Line 20: SELECT COUNT(ps_node_id) INTO l_ps_counter FROM CZ_PS_NODES

16: RETURN '0'; -- it's not mutex
17: END IF;
18:
19: -- check for the case when node with p_ps_node_id has only one child node
20: SELECT COUNT(ps_node_id) INTO l_ps_counter FROM CZ_PS_NODES
21: WHERE parent_id=p_ps_node_id AND deleted_flag='0' AND rownum<3;
22:
23: -- if there is only one child node then return "mutex"
24: IF l_ps_counter=0 THEN

Line 35: SELECT COUNT(ps_node_id) INTO l_req_nodes_counter FROM CZ_PS_NODES

31: RETURN '1'; -- it's mutex
32:
33: END IF;
34:
35: SELECT COUNT(ps_node_id) INTO l_req_nodes_counter FROM CZ_PS_NODES
36: WHERE parent_id=p_ps_node_id AND deleted_flag='0' AND
37: bom_required_flag='1';
38:
39: IF ( l_req_nodes_counter+1 = p_max_selected ) THEN

Line 54: SELECT maximum_selected INTO l_max_selected FROM CZ_PS_NODES

50: l_max_selected NUMBER;
51:
52: BEGIN
53:
54: SELECT maximum_selected INTO l_max_selected FROM CZ_PS_NODES
55: WHERE ps_node_id=p_ps_node_id AND deleted_flag='0';
56:
57: RETURN is_Mutex(p_ps_node_id, l_max_selected);
58:

Line 80: SELECT maximum_selected INTO l_max_selected FROM CZ_PS_NODES

76: l_max_selected NUMBER;
77:
78: BEGIN
79:
80: SELECT maximum_selected INTO l_max_selected FROM CZ_PS_NODES
81: WHERE ps_node_id=p_ps_node_id AND deleted_flag='0';
82:
83: x_mutex_flag := is_Mutex(p_ps_node_id, l_max_selected);
84:

Line 91: SELECT '1' INTO l_flag FROM CZ_PS_NODES a

87:
88: FUNCTION contains_Nested_BOM(p_ps_node_id IN NUMBER) RETURN BOOLEAN IS
89: l_flag VARCHAR2(1);
90: BEGIN
91: SELECT '1' INTO l_flag FROM CZ_PS_NODES a
92: WHERE a.parent_id=p_ps_node_id AND a.deleted_flag='0' AND
93: (
94: (a.ps_node_type IN(PS_NODE_TYPE_BOM_MODEL,PS_NODE_TYPE_BOM_OPTION_CLASS))
95: OR

Line 97: EXISTS(SELECT NULL FROM CZ_PS_NODES b

93: (
94: (a.ps_node_type IN(PS_NODE_TYPE_BOM_MODEL,PS_NODE_TYPE_BOM_OPTION_CLASS))
95: OR
96: (a.ps_node_type=PS_NODE_TYPE_REFERENCE AND a.instantiable_flag=MANDATORY_EXPL_TYPE AND
97: EXISTS(SELECT NULL FROM CZ_PS_NODES b
98: WHERE b.devl_project_id=a.reference_id AND
99: b.deleted_flag='0' AND b.ps_node_type=PS_NODE_TYPE_BOM_MODEL))
100: )
101: AND rownum<2 ;

Line 112: FOR l IN(SELECT ps_node_id,reference_id,ps_node_type,maximum,maximum_selected FROM CZ_PS_NODES

108: FUNCTION child_Nodes_Have_Quantities(p_ps_node_id IN NUMBER) RETURN BOOLEAN IS
109: l_flag VARCHAR2(1);
110: v_ps_node_id NUMBER;
111: BEGIN
112: FOR l IN(SELECT ps_node_id,reference_id,ps_node_type,maximum,maximum_selected FROM CZ_PS_NODES
113: WHERE parent_id=p_ps_node_id AND deleted_flag='0')
114: LOOP
115: IF (l.maximum<>1 AND
116: l.ps_node_type IN(PS_NODE_TYPE_BOM_MODEL,PS_NODE_TYPE_BOM_OPTION_CLASS,

Line 123: WHERE EXISTS(SELECT NULL FROM CZ_PS_NODES

119:
120: ELSIF (l.ps_node_type IN(PS_NODE_TYPE_REFERENCE) AND l.maximum_selected<>1) THEN
121: BEGIN
122: SELECT '1' INTO l_flag FROM dual
123: WHERE EXISTS(SELECT NULL FROM CZ_PS_NODES
124: WHERE ps_node_id=l.reference_id AND
125: deleted_flag='0' AND ps_node_type=PS_NODE_TYPE_BOM_MODEL);
126: RETURN TRUE;
127: EXCEPTION

Line 135: FOR k IN(SELECT ps_node_id FROM CZ_PS_NODES

131: END IF;
132:
133: /*
134: IF l.ps_node_type IN(PS_NODE_TYPE_REFERENCE) THEN
135: FOR k IN(SELECT ps_node_id FROM CZ_PS_NODES
136: WHERE parent_id=l.reference_id AND deleted_flag='0' AND
137: ps_node_type IN(PS_NODE_TYPE_BOM_MODEL,PS_NODE_TYPE_BOM_OPTION_CLASS,
138: PS_NODE_TYPE_BOM_STANDART_ITEM) AND
139: maximum<>1 AND rownum<2)

Line 169: v_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;

165: p_max_selected IN NUMBER)
166: RETURN NUMBER IS
167:
168: v_model_type CZ_DEVL_PROJECTS.model_type%TYPE;
169: v_ps_node_type CZ_PS_NODES.ps_node_type%TYPE;
170:
171: BEGIN
172:
173: IF p_ps_node_type IN(PS_NODE_TYPE_PRODUCT,PS_NODE_TYPE_COMPONENT) AND p_instantiable_flag=MANDATORY_EXPL_TYPE THEN

Line 231: SELECT ps_node_type INTO v_ps_node_type FROM CZ_PS_NODES

227:
228: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
229: WHERE devl_project_id=p_reference_id AND deleted_flag='0';
230:
231: SELECT ps_node_type INTO v_ps_node_type FROM CZ_PS_NODES
232: WHERE ps_node_id=p_reference_id AND deleted_flag='0';
233:
234: IF v_ps_node_type=PS_NODE_TYPE_BOM_MODEL AND v_model_type IN (MODEL_TYPE_ATO, MODEL_TYPE_PTO) THEN
235: RETURN UOPTIONAL_BOM_REF_TYPEID;

Line 245: SELECT ps_node_type INTO v_ps_node_type FROM CZ_PS_NODES

241:
242: SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
243: WHERE devl_project_id=p_reference_id AND deleted_flag='0';
244:
245: SELECT ps_node_type INTO v_ps_node_type FROM CZ_PS_NODES
246: WHERE ps_node_id=p_reference_id AND deleted_flag='0';
247:
248: IF v_ps_node_type=PS_NODE_TYPE_BOM_MODEL AND v_model_type IN (MODEL_TYPE_ATO, MODEL_TYPE_PTO) THEN
249: RETURN UMINMAX_BOM_REF_TYPEID;

Line 321: SELECT persistent_node_id INTO l_persistent_node_id FROM CZ_PS_NODES

317:
318: FUNCTION get_Persistent_Node_Id(p_ps_node_id IN NUMBER) RETURN NUMBER IS
319: l_persistent_node_id NUMBER;
320: BEGIN
321: SELECT persistent_node_id INTO l_persistent_node_id FROM CZ_PS_NODES
322: WHERE ps_node_id=p_ps_node_id;
323: RETURN l_persistent_node_id;
324: END get_Persistent_Node_Id;
325: