APPS.MSC_ATP_PVT dependencies on MSC_ALLOC_DEMANDS

Line 8572: update msc_alloc_demands

8568: RAISE FND_API.G_EXC_ERROR;
8569: END IF;
8570: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
8571: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
8572: update msc_alloc_demands
8573: set allocated_quantity = (allocated_quantity -
8574: greatest(l_sub_requested_date_quantity, 0))
8575: where parent_demand_id = l_demand_id --updating for primary only
8576: and plan_id = p_plan_id;

Line 8830: update msc_alloc_demands

8826: l_atf_date_qty := 0;
8827: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
8828: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
8829:
8830: update msc_alloc_demands
8831: set allocated_quantity = p_atp_record.quantity_ordered
8832: where parent_demand_id = l_demand_id
8833: and plan_id = p_plan_id;
8834:

Line 9005: update msc_alloc_demands

9001: END IF;
9002: RAISE FND_API.G_EXC_ERROR;
9003: END IF;
9004: ELSE
9005: update msc_alloc_demands
9006: set allocated_quantity = p_atp_record.requested_date_quantity + l_stealing_requested_date_qty
9007: where parent_demand_id = l_demand_id
9008: and plan_id = p_plan_id;
9009: END IF;

Line 9332: update msc_alloc_demands

9328: RAISE FND_API.G_EXC_ERROR;
9329: END IF;
9330: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
9331: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
9332: update msc_alloc_demands
9333: set DEMAND_DATE = l_atp_date_this_level
9334: where parent_demand_id = l_demand_id
9335: and plan_id = p_plan_id;
9336: END IF;

Line 9687: update msc_alloc_demands

9683: OR
9684: MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
9685: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
9686:
9687: update msc_alloc_demands
9688: set ALLOCATED_QUANTITY = 0
9689: where parent_demand_id = l_demand_id
9690: and plan_id = p_plan_id;
9691: END IF;

Line 14773: update msc_alloc_demands

14769: msc_sch_wb.atp_debug('ATP_Check : demand id :' || l_substitutes_rec.demand_id(l_index));
14770: END IF;
14771: IF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
14772: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
14773: update msc_alloc_demands
14774: set allocated_quantity = l_atp_ctp_qty
14775: where parent_demand_id = l_substitutes_rec.demand_id(l_index) --l_demand_id
14776: --where parent_demand_id = l_demand_id
14777: and plan_id = p_plan_id;

Line 14926: update msc_alloc_demands

14922: END IF;
14923: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
14924: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
14925:
14926: update msc_alloc_demands
14927: set allocated_quantity = allocated_quantity -l_net_demand
14928: where parent_demand_id = l_demand_id
14929: and plan_id = p_plan_id;
14930: END IF;

Line 15139: update msc_alloc_demands

15135: --alloc_pp
15136: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
15137: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
15138:
15139: update msc_alloc_demands
15140: set allocated_quantity = allocated_quantity - l_net_demand
15141: where parent_demand_id = l_demand_id
15142: and plan_id = p_plan_id;
15143: END IF;

Line 15306: update msc_alloc_demands

15302: END IF;
15303: --alloc_pp
15304: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
15305: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
15306: update msc_alloc_demands
15307: set demand_date = p_atp_record.ship_date
15308: where parent_demand_id = l_demand_id
15309: and plan_id = p_plan_id;
15310: END IF;