APPS.MSC_ATP_PUB dependencies on MSC_SUPPLIES

Line 2899: -- sr_instance_id, plan_id and demand_id while updating tables ( msc_demands, msc_supplies,

2895: END IF;
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,

Line 2934: update msc_supplies

2930: msc_sch_wb.atp_debug('No of rows updated:msc_demands ' || SQL%ROWCOUNT );
2931: END IF;
2932:
2933: FORALL i in 1..l_identifier1.COUNT
2934: update msc_supplies
2935: set refresh_number = p_end_refresh_number
2936: where refresh_number = p_refresh_number
2937: and plan_id = l_identifier2(i)
2938: and transaction_id = l_identifier3(i)

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

2938: and transaction_id = l_identifier3(i)
2939: and sr_instance_id = l_identifier1(i);
2940:
2941: IF PG_DEBUG in ('Y', 'C') THEN
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