APPS.MSC_ATP_PUB dependencies on MSC_RESOURCE_REQUIREMENTS

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 2980: update msc_resource_requirements

2976: msc_sch_wb.atp_debug('No of rows updated: msc_supplies ' || SQL%ROWCOUNT );
2977: END IF;
2978:
2979: FORALL i in 1..l_identifier1.COUNT
2980: update msc_resource_requirements
2981: set refresh_number = p_end_refresh_number
2982: where refresh_number = p_refresh_number
2983: and plan_id = l_identifier2(i)
2984: and transaction_id = l_identifier3(i)

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

2984: and transaction_id = l_identifier3(i)
2985: and sr_instance_id = l_identifier1(i);
2986:
2987: IF PG_DEBUG in ('Y', 'C') THEN
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