APPS.MSC_ATP_PUB dependencies on MSC_DEMANDS

Line 2861: -- Currently doing this using the brute force method of going by msc_demands. Need to investigate

2857: END IF;
2858: IF p_summary_flag = 'Y' THEN
2859: -- Summary is enabled in destination and at least one line did not result in PDS-ODS switch
2860: -- Now need to check if net summary is running or if latest_refresh_number has increased
2861: -- Currently doing this using the brute force method of going by msc_demands. Need to investigate
2862: -- possibility of using ATP pegging - potential issue there may be unschedules
2863:
2864: select max(decode(p.summary_flag,
2865: MSC_POST_PRO.G_SF_NET_SUMMARY_RUNNING, p_refresh_number+1,

Line 2869: msc_demands d,

2865: MSC_POST_PRO.G_SF_NET_SUMMARY_RUNNING, p_refresh_number+1,
2866: p.latest_refresh_number))
2867: into l_end_refresh_number
2868: from msc_plans p,
2869: msc_demands d,
2870: mrp_atp_details_temp madt
2871: where d.plan_id = p.plan_id
2872: and d.refresh_number = p_refresh_number
2873: and d.plan_id = madt.identifier2

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 2922: update msc_demands

2918: msc_sch_wb.atp_debug('No of rows selected by BULK SELECT ' || SQL%ROWCOUNT );
2919: END IF;
2920:
2921: FORALL i in 1..l_identifier1.COUNT
2922: update msc_demands
2923: set refresh_number = p_end_refresh_number
2924: where refresh_number = p_refresh_number
2925: and plan_id = l_identifier2(i)
2926: and demand_id = l_identifier3(i)

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

2926: and demand_id = l_identifier3(i)
2927: and sr_instance_id = l_identifier1(i);
2928:
2929: IF PG_DEBUG in ('Y', 'C') THEN
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

Line 3000: update msc_demands

2996: IF PG_DEBUG in ('Y', 'C') THEN
2997: msc_sch_wb.atp_debug('Update 1 Table');
2998: END IF;
2999:
3000: update msc_demands
3001: set refresh_number = p_end_refresh_number
3002: --we need to update POD for model components
3003: where origination_type in (6,30,1)
3004: --refresh number will be populated either for SO or POD ofmodel entities

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

3016: and identifier1 is not NULL
3017: );
3018:
3019: IF PG_DEBUG in ('Y', 'C') THEN
3020: msc_sch_wb.atp_debug('No of rows updated: msc_demands ' || SQL%ROWCOUNT );
3021: END IF;
3022: END IF;
3023: END IF;
3024: END UPDATE_TABLES;