APPS.WSH_USA_CATEGORIES_PVT dependencies on WSH_DELIVERY_DETAILS_INV

Line 990: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

986: l_pickable_flag VARCHAR2(1);
987: l_reservable_flag VARCHAR2(1);
988: l_serial_number VARCHAR2(30);
989: l_trx_temp_id NUMBER;
990: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
991: l_count NUMBER;
992: l_msg_count NUMBER;
993: l_msg_data VARCHAR2(2000);
994: l_reservation_id NUMBER;

Line 1438: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

1434:
1435: l_change_sub_only := 'X';
1436:
1437: ELSE
1438: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
1439: x_item_id => l_item_id,
1440: x_organization_id => g_cache_detail_rec.organization_id,
1441: x_pickable_flag => l_pickable_flag);
1442:

Line 1586: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(

1582: END IF; --l_status IN ('S', 'Y')
1583:
1584: IF (l_serial_number IS NOT NULL) OR (l_trx_temp_id IS NOT NULL) THEN
1585:
1586: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1587: p_delivery_detail_id => l_del_det,
1588: p_inventory_item_id => l_item_id,
1589: p_organization_id => g_cache_detail_rec.organization_id,
1590: p_subinventory => l_subinventory,

Line 1599: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number (

1595:
1596: RAISE update_not_allowed;
1597:
1598: END IF;
1599: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number (
1600: p_delivery_detail_id => l_del_det,
1601: p_serial_number_code => l_inv_controls.serial_code,
1602: p_serial_number => l_serial_number,
1603: p_transaction_temp_id => l_trx_temp_id,