APPS.MSC_ATP_PUB dependencies on MSC_ALLOC_DEMANDS

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 2958: update msc_alloc_demands

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
2959: set refresh_number = p_end_refresh_number
2960: where refresh_number = p_refresh_number
2961: and plan_id = l_identifier2(i)
2962: and parent_demand_id = l_identifier3(i)

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

2962: and parent_demand_id = l_identifier3(i)
2963: and sr_instance_id = l_identifier1(i);
2964:
2965: IF PG_DEBUG in ('Y', 'C') THEN
2966: msc_sch_wb.atp_debug('No of rows updated: msc_alloc_demands ' || SQL%ROWCOUNT );
2967: END IF;
2968:
2969: FORALL i in 1..l_identifier1.COUNT
2970: update msc_alloc_supplies