DBA Data[Home] [Help]

APPS.MSC_ATP_PUB dependencies on MSC_DEMANDS

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

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

Line 2903: msc_demands d,

2899: MSC_POST_PRO.G_SF_NET_SUMMARY_RUNNING, p_refresh_number+1,
2900: p.latest_refresh_number))
2901: into l_end_refresh_number
2902: from msc_plans p,
2903: msc_demands d,
2904: mrp_atp_details_temp madt
2905: where d.plan_id = p.plan_id
2906: and d.refresh_number = p_refresh_number
2907: and d.plan_id = madt.identifier2

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

2952: msc_sch_wb.atp_debug('No of rows selected by BULK SELECT ' || SQL%ROWCOUNT );
2953: END IF;
2954:
2955: FORALL i in 1..l_identifier1.COUNT
2956: update msc_demands
2957: set refresh_number = p_end_refresh_number
2958: where refresh_number = p_refresh_number
2959: and plan_id = l_identifier2(i)
2960: and demand_id = l_identifier3(i)

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

2960: and demand_id = l_identifier3(i)
2961: and sr_instance_id = l_identifier1(i);
2962:
2963: IF PG_DEBUG in ('Y', 'C') THEN
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

Line 3034: update msc_demands

3030: IF PG_DEBUG in ('Y', 'C') THEN
3031: msc_sch_wb.atp_debug('Update 1 Table');
3032: END IF;
3033:
3034: update msc_demands
3035: set refresh_number = p_end_refresh_number
3036: --we need to update POD for model components
3037: where origination_type in (6,30,1)
3038: --refresh number will be populated either for SO or POD ofmodel entities

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

3050: and identifier1 is not NULL
3051: );
3052:
3053: IF PG_DEBUG in ('Y', 'C') THEN
3054: msc_sch_wb.atp_debug('No of rows updated: msc_demands ' || SQL%ROWCOUNT );
3055: END IF;
3056: END IF;
3057: END IF;
3058: END UPDATE_TABLES;