APPS.MSC_ATP_SUBST dependencies on MSC_ALLOC_DEMANDS

Line 5221: update msc_alloc_demands

5217:
5218: IF PG_DEBUG in ('Y', 'C') THEN
5219: msc_sch_wb.atp_debug('Update_demand: ' || 'Update preallocated demand');
5220: END IF;
5221: update msc_alloc_demands
5222: set allocated_quantity = p_quantity
5223: where parent_demand_id = p_demand_id
5224: and plan_id = p_plan_id;
5225:

Line 5261: delete msc_alloc_demands

5257:
5258: IF PG_DEBUG in ('Y', 'C') THEN
5259: msc_sch_wb.atp_debug('Delete_demand_subst: ' || 'Delete Allocated demand');
5260: END IF;
5261: delete msc_alloc_demands
5262: where parent_demand_id = p_demand_id
5263: and plan_id = p_plan_id;
5264:
5265: IF PG_DEBUG in ('Y', 'C') THEN

Line 5949: ' msc_alloc_demands');

5945: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5946:
5947: IF PG_DEBUG in ('Y', 'C') THEN
5948: msc_sch_wb.atp_debug('Add_Mat_Demand: before insert into'||
5949: ' msc_alloc_demands');
5950: END IF;
5951:
5952: INSERT INTO MSC_ALLOC_DEMANDS(
5953: PLAN_ID,

Line 5952: INSERT INTO MSC_ALLOC_DEMANDS(

5948: msc_sch_wb.atp_debug('Add_Mat_Demand: before insert into'||
5949: ' msc_alloc_demands');
5950: END IF;
5951:
5952: INSERT INTO MSC_ALLOC_DEMANDS(
5953: PLAN_ID,
5954: INVENTORY_ITEM_ID,
5955: ORGANIZATION_ID,
5956: SR_INSTANCE_ID,