APPS.MSC_ATP_UTILS dependencies on MSC_CTO_SOURCES

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

3619: msc_sch_wb.atp_debug('Number of Rows updated := ' || SQL%ROWCOUNT);
3620: END IF;
3621: */
3622:
3623: ---update plan_id on msc_cto_bom and msc_cto_sources for 24x7
3624: update msc_cto_bom mcb
3625: set plan_id = (select plan_id
3626: from mrp_atp_schedule_temp mast
3627: where mast.session_id = p_session_id

Line 3636: update msc_cto_sources mcs

3632: IF PG_DEBUG in ('Y', 'C') THEN
3633: msc_sch_wb.atp_debug('Number of Rows updated n msc_cto_bom := ' || SQL%ROWCOUNT);
3634: END IF;
3635:
3636: update msc_cto_sources mcs
3637: set plan_id = (select plan_id
3638: from mrp_atp_schedule_temp mast
3639: where mast.session_id = p_session_id
3640: and mast.order_line_id = mcs.line_id

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

3641: )
3642: where mcs.session_id = p_session_id;
3643:
3644: IF PG_DEBUG in ('Y', 'C') THEN
3645: msc_sch_wb.atp_debug('Number of Rows updated in msc_cto_sources := ' || SQL%ROWCOUNT);
3646: END IF;
3647: END IF;
3648:
3649: