APPS.MSC_ATP_UTILS dependencies on MSC_CTO_SOURCES

Line 3569: ---update plan_id on msc_cto_bom and msc_cto_sources for 24x7

3565: msc_sch_wb.atp_debug('Number of Rows updated := ' || SQL%ROWCOUNT);
3566: END IF;
3567: */
3568:
3569: ---update plan_id on msc_cto_bom and msc_cto_sources for 24x7
3570: update msc_cto_bom mcb
3571: set plan_id = (select plan_id
3572: from mrp_atp_schedule_temp mast
3573: where mast.session_id = p_session_id

Line 3582: update msc_cto_sources mcs

3578: IF PG_DEBUG in ('Y', 'C') THEN
3579: msc_sch_wb.atp_debug('Number of Rows updated n msc_cto_bom := ' || SQL%ROWCOUNT);
3580: END IF;
3581:
3582: update msc_cto_sources mcs
3583: set plan_id = (select plan_id
3584: from mrp_atp_schedule_temp mast
3585: where mast.session_id = p_session_id
3586: and mast.order_line_id = mcs.line_id

Line 3591: msc_sch_wb.atp_debug('Number of Rows updated in msc_cto_sources := ' || SQL%ROWCOUNT);

3587: )
3588: where mcs.session_id = p_session_id;
3589:
3590: IF PG_DEBUG in ('Y', 'C') THEN
3591: msc_sch_wb.atp_debug('Number of Rows updated in msc_cto_sources := ' || SQL%ROWCOUNT);
3592: END IF;
3593: END IF;
3594:
3595: