APPS.WSH_USA_CATEGORIES_PVT dependencies on WSH_DELIVERY_DETAILS_INV

Line 967: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

963: l_pickable_flag VARCHAR2(1);
964: l_reservable_flag VARCHAR2(1);
965: l_serial_number VARCHAR2(30);
966: l_trx_temp_id NUMBER;
967: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
968: l_count NUMBER;
969: l_msg_count NUMBER;
970: l_msg_data VARCHAR2(2000);
971: l_reservation_id NUMBER;

Line 1365: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

1361:
1362: l_change_sub_only := 'X';
1363:
1364: ELSE
1365: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
1366: x_item_id => l_item_id,
1367: x_organization_id => g_cache_detail_rec.organization_id,
1368: x_pickable_flag => l_pickable_flag);
1369:

Line 1513: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(

1509: END IF; --l_status IN ('S', 'Y')
1510:
1511: IF (l_serial_number IS NOT NULL) OR (l_trx_temp_id IS NOT NULL) THEN
1512:
1513: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(
1514: p_delivery_detail_id => l_del_det,
1515: p_inventory_item_id => l_item_id,
1516: p_organization_id => g_cache_detail_rec.organization_id,
1517: p_subinventory => l_subinventory,

Line 1526: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number (

1522:
1523: RAISE update_not_allowed;
1524:
1525: END IF;
1526: WSH_DELIVERY_DETAILS_INV.Unmark_Serial_Number (
1527: p_delivery_detail_id => l_del_det,
1528: p_serial_number_code => l_inv_controls.serial_code,
1529: p_serial_number => l_serial_number,
1530: p_transaction_temp_id => l_trx_temp_id,