APPS.MSC_ATP_PEG dependencies on MSC_ALLOC_SUPPLIES

Line 5105: update msc_alloc_supplies

5101: END IF;
5102:
5103: ---update records due to supply/demand stealing
5104: IF l_so_line_ids.count > 0 THEN
5105: update msc_alloc_supplies
5106: set allocated_quantity = 0
5107: where plan_id = p_plan_id
5108: and sr_instance_id = l_instance_id(1)
5109: and ato_model_line_id = p_identifier

Line 5553: ' before insert into' || ' msc_alloc_supplies');

5549: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5550:
5551: IF PG_DEBUG in ('Y', 'C') THEN
5552: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5553: ' before insert into' || ' msc_alloc_supplies');
5554: END IF;
5555:
5556: -- CTO_PF_PRJ_2 relief_type already set above.
5557: -- Bug 3344102 First set offset type to 6 for supply alloc reliefs.

Line 5563: INSERT INTO MSC_ALLOC_SUPPLIES(

5559: -- End CTO_PF_PRJ_2
5560:
5561: -- Try to apply the offsets using alloc specific relief_type.
5562: FORALL i in 1..x_supply_id.COUNT
5563: INSERT INTO MSC_ALLOC_SUPPLIES(
5564: PLAN_ID,
5565: INVENTORY_ITEM_ID,
5566: ORGANIZATION_ID,
5567: SR_INSTANCE_ID,

Line 6343: ' msc_alloc_supplies');

6339: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6340:
6341: IF PG_DEBUG in ('Y', 'C') THEN
6342: msc_sch_wb.atp_debug('Remove_Offset_Supplies: before delete from ' ||
6343: ' msc_alloc_supplies');
6344: END IF;
6345:
6346: --Bug 3629191
6347: FORALL m IN 1..p_del_supply_ids.COUNT

Line 6348: DELETE msc_alloc_supplies

6344: END IF;
6345:
6346: --Bug 3629191
6347: FORALL m IN 1..p_del_supply_ids.COUNT
6348: DELETE msc_alloc_supplies
6349: WHERE
6350: -- Bug 3629191 :All where clause except and parent_transaction_id are commmented
6351: /* sr_instance_id = p_instance_id
6352: (SELECT sr_instance_id