APPS.CZ_PB_USG dependencies on CZ_PS_NODES

Line 144: TYPE t_mask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;

140: AS
141:
142:
143: TYPE t_indexes IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
144: TYPE t_mask IS TABLE OF cz_ps_nodes.effective_usage_mask%TYPE INDEX BY BINARY_INTEGER;
145:
146: v_nodes t_indexes;
147: v_rules t_indexes;
148: v_masks_nodes t_mask;

Line 170: FROM cz_ps_nodes

166: BULK
167: COLLECT
168: INTO v_nodes,
169: v_masks_nodes
170: FROM cz_ps_nodes
171: WHERE effective_usage_mask NOT IN ('0', '0000000000000000')
172: ORDER BY effective_usage_mask;
173: EXCEPTION
174: WHEN OTHERS THEN

Line 224: UPDATE cz_ps_nodes

220: END IF;
221: END LOOP;
222:
223: FORALL i IN v_nodes.FIRST..v_nodes.LAST
224: UPDATE cz_ps_nodes
225: SET effective_usage_mask = v_masks_nodes(i)
226: WHERE ps_node_id = v_nodes(i);
227:
228: END IF;