APPS.MSC_ATP_PUB dependencies on MSC_ALLOC_DEMANDS

Line 2934: -- msc_resource_requirements, msc_alloc_demands, msc-alloc_supplies) in demand priority case

2930:
2931: -- Bug 3517529: anbansal
2932: -- Used identifier1, identifier2 and identifier3 from pegging records to have additional check on
2933: -- sr_instance_id, plan_id and demand_id while updating tables ( msc_demands, msc_supplies,
2934: -- msc_resource_requirements, msc_alloc_demands, msc-alloc_supplies) in demand priority case
2935: -- to improve the performance.
2936:
2937: SELECT identifier2,
2938: identifier3,

Line 2992: update msc_alloc_demands

2988: msc_sch_wb.atp_debug('No of rows updated: msc_resource_requirements ' || SQL%ROWCOUNT );
2989: END IF;
2990:
2991: FORALL i in 1..l_identifier1.COUNT
2992: update msc_alloc_demands
2993: set refresh_number = p_end_refresh_number
2994: where refresh_number = p_refresh_number
2995: and plan_id = l_identifier2(i)
2996: and parent_demand_id = l_identifier3(i)

Line 3000: msc_sch_wb.atp_debug('No of rows updated: msc_alloc_demands ' || SQL%ROWCOUNT );

2996: and parent_demand_id = l_identifier3(i)
2997: and sr_instance_id = l_identifier1(i);
2998:
2999: IF PG_DEBUG in ('Y', 'C') THEN
3000: msc_sch_wb.atp_debug('No of rows updated: msc_alloc_demands ' || SQL%ROWCOUNT );
3001: END IF;
3002:
3003: FORALL i in 1..l_identifier1.COUNT
3004: update msc_alloc_supplies