33: l_plan_type number;
34:
35: CURSOR c_plan_type(v_plan_id NUMBER) IS
36: SELECT curr_plan_type
37: FROM msc_plans
38: WHERE plan_id = v_plan_id;
39: BEGIN
40: OPEN c_plan_type(p_plan_id);
41: FETCH c_plan_type INTO l_plan_type;
218: --,nvl(sup.new_ship_date,sup.new_schedule_date) new_due_date
219: FROM msc_supplies sup,
220: msc_system_items msi ,
221: msc_item_categories mic,
222: msc_plans mp
223: WHERE mic.sr_instance_id = sup.sr_instance_id
224: AND mic.organization_id = sup.organization_id
225: AND mic.inventory_item_id = sup.inventory_item_id
226: AND
249: p_to_date IN DATE ) IS
250: SELECT dem.demand_id transaction_id
251: --,nvl(dem.planned_inbound_due_date , dem.using_assembly_demand_date) new_due_date
252: FROM msc_demands dem,
253: msc_plans mp,
254: msc_system_items msi ,
255: msc_item_categories mic
256: WHERE mic.sr_instance_id = dem.sr_instance_id
257: AND mic.organization_id = dem.organization_id
286: p_to_date IN DATE ) IS
287: SELECT dem.demand_id transaction_id
288: --,nvl(dem.old_using_assembly_demand_date , dem.using_assembly_demand_date) new_due_date
289: FROM msc_demands dem,
290: msc_plans mp,
291: msc_system_items msi ,
292: msc_item_categories mic
293: WHERE mic.sr_instance_id = dem.sr_instance_id
294: AND mic.organization_id = dem.organization_id
1944: test BOOLEAN;
1945:
1946: CURSOR c_plans IS
1947: SELECT compile_designator
1948: FROM msc_plans
1949: WHERE plan_id = -1;
1950:
1951: l_plan VARCHAR2(30);
1952: l_query_type_temp NUMBER;
2200: -- and
2201:
2202: CURSOR check_release_method IS
2203: SELECT AUTO_RELEASE_METHOD
2204: FROM msc_plans
2205: WHERE plan_id = p_plan_Id;
2206:
2207: TYPE r_cursor is REF CURSOR;
2208: t_cur r_cursor;