APPS.MSC_ATP_PUB dependencies on MSC_SUPPLIES

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

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

Line 2968: update msc_supplies

2964: msc_sch_wb.atp_debug('No of rows updated:msc_demands ' || SQL%ROWCOUNT );
2965: END IF;
2966:
2967: FORALL i in 1..l_identifier1.COUNT
2968: update msc_supplies
2969: set refresh_number = p_end_refresh_number
2970: where refresh_number = p_refresh_number
2971: and plan_id = l_identifier2(i)
2972: and transaction_id = l_identifier3(i)

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

2972: and transaction_id = l_identifier3(i)
2973: and sr_instance_id = l_identifier1(i);
2974:
2975: IF PG_DEBUG in ('Y', 'C') THEN
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