60: FUNCTION available_to_mrp(p_demand_id IN NUMBER) RETURN NUMBER IS
61:
62: CURSOR AVAIL IS
63: SELECT DECODE(visible_demand_flag,'Y',1,2)
64: FROM oe_order_lines_all oe
65: WHERE line_id = p_demand_id;
66:
67: l_available_to_mrp NUMBER := 1;
68:
129: FUNCTION available_to_atp(p_demand_id IN NUMBER) RETURN NUMBER IS
130:
131: CURSOR AVAIL IS
132: SELECT DECODE(visible_demand_flag,'Y',1,2)
133: FROM oe_order_lines_all oe
134: WHERE line_id = p_demand_id;
135:
136: l_available_to_atp NUMBER := 1;
137: