APPS.MSC_ATP_PUB dependencies on MSC_OE_DATA_TEMP

Line 578: insert into msc_oe_data_temp

574:
575: -- Start 4279623
576: IF nvl(l_atp_rec.calling_module(1), -1) not in (724,-1) THEN
577: FORALL i in 1..l_atp_rec.action.COUNT
578: insert into msc_oe_data_temp
579: (
580: seq_id,
581: order_line_id,
582: oe_flag,

Line 588: msc.msc_oe_data_temp_s.NEXTVAL,

584: session_id
585: )
586: values
587: (
588: msc.msc_oe_data_temp_s.NEXTVAL,
589: l_atp_rec.identifier(i),
590: decode(l_atp_rec.oe_flag(i),'Y',(Select decode(MSC_ATP_PVT.G_INV_CTP, 5, l_atp_rec.OE_FLAG(i),
591: decode( prha.interface_source_code, 'MRP', 'Y', 'MSC', 'Y','CTO', 'Y', 'CTO-LOWER LEVEL', 'Y', 'N')) --4889943
592: from po_requisition_headers_all prha

Line 604: msc_sch_wb.atp_debug('Call_ATP: Inserted data into msc_oe_data_temp');

600: p_session_id
601: );
602:
603: IF PG_DEBUG in ('Y', 'C') THEN
604: msc_sch_wb.atp_debug('Call_ATP: Inserted data into msc_oe_data_temp');
605: msc_sch_wb.atp_debug('Records selected in mrp_oe_data_temp : ' || SQL%ROWCOUNT);
606: END IF;
607:
608: select oe_flag,internal_org_id,seq_id

Line 613: from msc_oe_data_temp

609: bulk collect into
610: l_atp_rec.oe_flag,
611: l_atp_rec.internal_org_id,
612: l_atp_rec.attribute_11
613: from msc_oe_data_temp
614: where session_id = p_session_id
615: order by seq_id;
616:
617: IF PG_DEBUG in ('Y', 'C') THEN