[Home] [Help]
4958: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4959:
4960: IF PG_DEBUG in ('Y', 'C') THEN
4961: msc_sch_wb.atp_debug('Add_Offset_Demands: before insert into'||
4962: ' msc_alloc_demands');
4963: END IF;
4964:
4965: -- CTO_PF_PRJ2 relief_type already set above.
4966: -- Bug 3344102 First set offset type to 5 for alloc reliefs.
4969:
4970: -- Try to apply the offsets using alloc specific relief_type.
4971:
4972: FORALL i in 1..x_demand_id.COUNT
4973: INSERT INTO MSC_ALLOC_DEMANDS(
4974: PLAN_ID,
4975: INVENTORY_ITEM_ID,
4976: ORGANIZATION_ID,
4977: SR_INSTANCE_ID,
5109: ELSE
5110: -- Try to apply the offsets using alloc specific relief_type.
5111:
5112: FORALL i in 1..x_demand_id.COUNT
5113: INSERT INTO MSC_ALLOC_DEMANDS(
5114: PLAN_ID,
5115: INVENTORY_ITEM_ID,
5116: ORGANIZATION_ID,
5117: SR_INSTANCE_ID,
6144: -- Relief_Type 7 can get created irrespective of allocation profiles.
6145:
6146: IF PG_DEBUG in ('Y', 'C') THEN
6147: msc_sch_wb.atp_debug('Remove_Offset_Demands: before delete from ' ||
6148: ' msc_alloc_demands');
6149: END IF;
6150:
6151: --Bug 3629191
6152: FORALL m IN 1..p_del_demand_ids.COUNT
6149: END IF;
6150:
6151: --Bug 3629191
6152: FORALL m IN 1..p_del_demand_ids.COUNT
6153: DELETE msc_alloc_demands
6154: WHERE
6155: -- Bug 3629191 :All where clause except plan_id and parent_demand_id are commmented
6156: /*sr_instance_id IN
6157: (SELECT sr_instance_id
6593: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id, mapt.end_demand_id,
6594: mapt.created_by, mapt.creation_date, mapt.last_updated_by, mapt.last_update_date,
6595: mapt.inventory_item_id, mapt.transaction_date,
6596: alocd.customer_id, alocd.ship_to_site_id
6597: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,
6598: msc_system_items msi
6599: WHERE mapt.reference_item_id = p_reference_item_id
6600: AND mapt.plan_id = p_plan_id
6601: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)