APPS.MSC_ATP_UTILS dependencies on MSC_CTO_BOM

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 3570: update msc_cto_bom mcb

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
3574: and mast.order_line_id = mcb.line_id

Line 3579: msc_sch_wb.atp_debug('Number of Rows updated n msc_cto_bom := ' || SQL%ROWCOUNT);

3575: )
3576: where mcb.session_id = p_session_id;
3577:
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