[Home] [Help]
299: p_customer_id IN NUMBER,
300: p_customer_site_id IN NUMBER,
301: p_assign_set_id IN NUMBER,
302: ---p_ship_set_item IN MRP_ATP_PUB.number_arr,
303: p_item_sourcing_info_rec IN MSC_ATP_CTO.Item_Sourcing_Info_Rec,
304: p_session_id IN NUMBER,
305: x_atp_sources OUT NoCopy MRP_ATP_PVT.Atp_Source_Typ,
306: x_return_status OUT NoCopy VARCHAR2,
307: p_partner_type IN NUMBER, --2814895
1520: and x_atp_sources.instance_id.count > 0 THEN
1521: --- we found an ato item or a model. we need to connect to msc_cto_sourcing to make sure
1522: -- that we have valid source
1523: l_source_list := x_atp_sources;
1524: MSC_ATP_CTO.Validate_CTO_Sources(l_source_list,
1525: l_line_ids,
1526: NVL(MSC_ATP_PVT.G_INSTANCE_ID, p_instance_id),
1527: p_session_id,
1528: x_return_status);
3227: l_return_status VARCHAR2(100);
3228: l_request_item_id NUMBER := NULL;
3229: l_sources mrp_atp_pvt.atp_source_typ;
3230: l_item_arr mrp_atp_pub.number_arr := mrp_atp_pub.number_arr(1);
3231: l_item_sourcing_rec MSC_ATP_CTO.Item_Sourcing_Info_Rec;
3232: l_other_cols order_sch_wb.other_cols_typ;
3233: l_item_id NUMBER;
3234: l_sr_instance_id NUMBER;
3235: l_organization_id NUMBER;
3884:
3885: END get_supply_sources;
3886:
3887: PROCEDURE item_sources_extend(p_item_sourcing_rec
3888: IN OUT NOCOPY MSC_ATP_CTO.Item_Sourcing_Info_Rec) IS
3889: BEGIN
3890: p_item_sourcing_rec.sr_inventory_item_id.extend;
3891: p_item_sourcing_rec.line_id.extend;
3892: p_item_sourcing_rec.ato_line_id.extend;