1212: l_mso_header_id NUMBER; -- The MTL_SALES_ORDERS
1213: --header ID, which should be derived from the OE header ID
1214: -- and used for reservation queries.
1215:
1216: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
1217:
1218: l_update_rsv_rec INV_Reservation_GLOBAL.MTL_RESERVATION_REC_TYPE;
1219: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;
1220: l_prim_qty NUMBER;
1798: l_shipping_attr(1).ordered_quantity := 1;
1799: l_shipping_attr(1).picked_quantity := 1; -- added for bug 3872182
1800: l_return_status := '';
1801:
1802: WSH_INTERFACE.Update_Shipping_Attributes
1803: (p_source_code => 'INV',
1804: p_changed_attributes => l_shipping_attr,
1805: x_return_status => l_return_status
1806: );
1860: l_shipping_attr(1).ordered_quantity := 1;
1861: l_shipping_attr(1).picked_quantity := 1; -- added for bug 3872182
1862: l_return_status := '';
1863:
1864: WSH_INTERFACE.Update_Shipping_Attributes
1865: (p_source_code => 'INV',
1866: p_changed_attributes => l_shipping_attr,
1867: x_return_status => l_return_status
1868: );
1933: l_shipping_attr(1).ordered_quantity := 1;
1934: l_shipping_attr(1).picked_quantity := 1; -- added for bug 3872182
1935: l_return_status := '';
1936:
1937: WSH_INTERFACE.Update_Shipping_Attributes
1938: (p_source_code => 'INV',
1939: p_changed_attributes => l_shipping_attr,
1940: x_return_status => l_return_status
1941: );
1993: l_shipping_attr(1).ordered_quantity := 1;
1994: l_shipping_attr(1).picked_quantity := 1; -- added for bug 3872182
1995: l_return_status := '';
1996:
1997: WSH_INTERFACE.Update_Shipping_Attributes
1998: (p_source_code => 'INV',
1999: p_changed_attributes => l_shipping_attr,
2000: x_return_status => l_return_status
2001: );
2063:
2064:
2065:
2066:
2067: WSH_INTERFACE.Update_Shipping_Attributes
2068: (p_source_code => 'INV',
2069: p_changed_attributes => l_shipping_attr,
2070: x_return_status => l_return_status
2071: );
2307: , x_msg_data OUT NOCOPY VARCHAR2)
2308: IS
2309: l_ret VARCHAR2(1);
2310: l_del_id NUMBER;
2311: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
2312: l_msg_count NUMBER;
2313: l_msg_data VARCHAR2(240);
2314: l_return_status VARCHAR2(1);
2315:
2328: IF (l_debug = 1) THEN
2329: mydebug('Before calling update shipping');
2330: END IF;
2331:
2332: WSH_INTERFACE.Update_Shipping_Attributes
2333: (p_source_code => 'INV',
2334: p_changed_attributes => l_shipping_attr,
2335: x_return_status => l_return_status
2336: );