APPS.MSC_ATP_PUB dependencies on MSC_RESOURCE_REQUIREMENTS

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

2896:
2897: -- Bug 3517529: anbansal
2898: -- Used identifier1, identifier2 and identifier3 from pegging records to have additional check on
2899: -- sr_instance_id, plan_id and demand_id while updating tables ( msc_demands, msc_supplies,
2900: -- msc_resource_requirements, msc_alloc_demands, msc-alloc_supplies) in demand priority case
2901: -- to improve the performance.
2902:
2903: SELECT identifier2,
2904: identifier3,

Line 2946: update msc_resource_requirements

2942: msc_sch_wb.atp_debug('No of rows updated: msc_supplies ' || SQL%ROWCOUNT );
2943: END IF;
2944:
2945: FORALL i in 1..l_identifier1.COUNT
2946: update msc_resource_requirements
2947: set refresh_number = p_end_refresh_number
2948: where refresh_number = p_refresh_number
2949: and plan_id = l_identifier2(i)
2950: and transaction_id = l_identifier3(i)

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

2950: and transaction_id = l_identifier3(i)
2951: and sr_instance_id = l_identifier1(i);
2952:
2953: IF PG_DEBUG in ('Y', 'C') THEN
2954: msc_sch_wb.atp_debug('No of rows updated: msc_resource_requirements ' || SQL%ROWCOUNT );
2955: END IF;
2956:
2957: FORALL i in 1..l_identifier1.COUNT
2958: update msc_alloc_demands