APPS.MSC_ATP_PVT dependencies on MSC_ALLOC_DEMANDS

Line 9264: update msc_alloc_demands

9260: RAISE FND_API.G_EXC_ERROR;
9261: END IF;
9262: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
9263: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
9264: update msc_alloc_demands
9265: set allocated_quantity = (allocated_quantity -
9266: greatest(l_sub_requested_date_quantity, 0))
9267: where parent_demand_id = l_demand_id --updating for primary only
9268: and plan_id = p_plan_id;

Line 9523: update msc_alloc_demands

9519: l_atf_date_qty := 0;
9520: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
9521: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
9522:
9523: update msc_alloc_demands
9524: set allocated_quantity = p_atp_record.quantity_ordered
9525: where parent_demand_id = l_demand_id
9526: and plan_id = p_plan_id;
9527:

Line 9710: update msc_alloc_demands

9706: END IF;
9707: RAISE FND_API.G_EXC_ERROR;
9708: END IF;
9709: ELSE
9710: update msc_alloc_demands
9711: set allocated_quantity = p_atp_record.requested_date_quantity + l_stealing_requested_date_qty
9712: where parent_demand_id = l_demand_id
9713: and plan_id = p_plan_id;
9714: END IF;

Line 10038: update msc_alloc_demands

10034: RAISE FND_API.G_EXC_ERROR;
10035: END IF;
10036: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
10037: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
10038: update msc_alloc_demands
10039: set DEMAND_DATE = l_atp_date_this_level
10040: where parent_demand_id = l_demand_id
10041: and plan_id = p_plan_id;
10042: END IF;

Line 10394: update msc_alloc_demands

10390: OR
10391: MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
10392: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
10393:
10394: update msc_alloc_demands
10395: set ALLOCATED_QUANTITY = 0
10396: where parent_demand_id = l_demand_id
10397: and plan_id = p_plan_id;
10398: END IF;

Line 15615: update msc_alloc_demands

15611: END IF;
15612: --5217510 demand id should be used from substitute record
15613: IF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
15614: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
15615: update msc_alloc_demands
15616: set allocated_quantity = l_atp_ctp_qty
15617: where parent_demand_id = l_substitutes_rec.demand_id(l_index) --l_demand_id
15618: --where parent_demand_id = l_demand_id
15619: and plan_id = p_plan_id;

Line 15770: update msc_alloc_demands

15766: END IF;
15767: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
15768: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
15769:
15770: update msc_alloc_demands
15771: set allocated_quantity = allocated_quantity -l_net_demand
15772: where parent_demand_id = l_demand_id
15773: and plan_id = p_plan_id;
15774: END IF;

Line 15989: update msc_alloc_demands

15985: --alloc_pp
15986: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
15987: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
15988:
15989: update msc_alloc_demands
15990: set allocated_quantity = allocated_quantity - l_net_demand
15991: where parent_demand_id = l_demand_id
15992: and plan_id = p_plan_id;
15993: END IF;

Line 16157: update msc_alloc_demands

16153: END IF;
16154: --alloc_pp
16155: ELSIF MSC_ATP_PVT.G_INV_CTP = 4 and MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y'
16156: AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND MSC_ATP_PVT.G_ALLOCATION_METHOD = 1 THEN
16157: update msc_alloc_demands
16158: set demand_date = p_atp_record.ship_date
16159: where parent_demand_id = l_demand_id
16160: and plan_id = p_plan_id;
16161: END IF;