APPS.MSC_ATP_SUBST dependencies on MSC_ALLOC_DEMANDS

Line 5447: update msc_alloc_demands

5443:
5444: IF PG_DEBUG in ('Y', 'C') THEN
5445: msc_sch_wb.atp_debug('Update_demand: ' || 'Update preallocated demand');
5446: END IF;
5447: update msc_alloc_demands
5448: set allocated_quantity = p_quantity
5449: where parent_demand_id = p_demand_id
5450: and plan_id = p_plan_id;
5451:

Line 5487: delete msc_alloc_demands

5483:
5484: IF PG_DEBUG in ('Y', 'C') THEN
5485: msc_sch_wb.atp_debug('Delete_demand_subst: ' || 'Delete Allocated demand');
5486: END IF;
5487: delete msc_alloc_demands
5488: where parent_demand_id = p_demand_id
5489: and plan_id = p_plan_id;
5490:
5491: IF PG_DEBUG in ('Y', 'C') THEN

Line 6175: ' msc_alloc_demands');

6171: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6172:
6173: IF PG_DEBUG in ('Y', 'C') THEN
6174: msc_sch_wb.atp_debug('Add_Mat_Demand: before insert into'||
6175: ' msc_alloc_demands');
6176: END IF;
6177:
6178: INSERT INTO MSC_ALLOC_DEMANDS(
6179: PLAN_ID,

Line 6178: INSERT INTO MSC_ALLOC_DEMANDS(

6174: msc_sch_wb.atp_debug('Add_Mat_Demand: before insert into'||
6175: ' msc_alloc_demands');
6176: END IF;
6177:
6178: INSERT INTO MSC_ALLOC_DEMANDS(
6179: PLAN_ID,
6180: INVENTORY_ITEM_ID,
6181: ORGANIZATION_ID,
6182: SR_INSTANCE_ID,