[Home] [Help]
1740:
1741: x_return_status := FND_API.G_RET_STS_SUCCESS;
1742:
1743: -- dsting 10/1/02 supply/demand performance enh
1744: -- insert period data into mrp_atp_details_temp to transfer later
1745: -- since bulk binds across dblink are not supported.
1746:
1747: MSC_ATP_UTILS.Put_Period_Data(p_atp_period, NULL, MSC_ATP_PVT.G_SESSION_ID);
1748: IF PG_DEBUG in ('Y', 'C') THEN
3106: msc_sch_wb.atp_debug('Add_Coproducts: ' || 'l_transaction_id := ' || l_transaction_id);
3107: msc_Sch_wb.atp_debug('Add_Coproducts: ' || 'Add pegging for coproducts where pegging id = 4');
3108: END IF;
3109:
3110: INSERT into mrp_atp_details_temp
3111: (session_id,
3112: order_line_id,
3113: pegging_id,
3114: parent_pegging_id,
8432: /* Read demand_id from madt*/
8433: BEGIN
8434: SELECT identifier3
8435: INTO l_ship_arrival_date_rec.demand_id
8436: FROM mrp_atp_details_temp
8437: WHERE pegging_id = MSC_ATP_PVT.G_DEMAND_PEGGING_ID
8438: AND session_id = MSC_ATP_PVT.G_SESSION_ID
8439: AND record_type = 3;
8440: EXCEPTION