[Home] [Help]
2044: CLOSE get_lpn_id_wdd; --16482236
2045: -- check subinventory
2046: if (l_detail_rec.subinventory is not NULL) then
2047: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2048: p_wms_installed => 'TRUE'
2049: , p_trx_status_enabled => l_status_enabled
2050: , p_trx_type_id => l_trx_type_code
2051: , p_organization_id => l_org_id
2052: , p_sub_code => l_detail_rec.subinventory
2061: end if;
2062: -- check locator
2063: if (l_detail_rec.locator_id is not NULL) then
2064: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2065: p_wms_installed => 'TRUE'
2066: , p_trx_status_enabled => l_status_enabled
2067: , p_trx_type_id => l_trx_type_code
2068: , p_organization_id => l_org_id
2069: , p_locator_id => l_detail_rec.locator_id
2077: end if;
2078: -- check lot
2079: if (l_detail_rec.lot_number is not NULL) then
2080: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2081: p_wms_installed => 'TRUE'
2082: , p_trx_status_enabled => l_status_enabled
2083: , p_trx_type_id => l_trx_type_code
2084: , p_organization_id => l_org_id
2085: , p_inventory_item_id => l_detail_rec.inventory_item_id
2097: end if;
2098: -- check serial
2099: if (l_detail_rec.serial_number is not NULL) then
2100: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2101: p_wms_installed => 'TRUE'
2102: , p_trx_status_enabled => l_status_enabled
2103: , p_trx_type_id => l_trx_type_code
2104: , p_organization_id => l_org_id
2105: , p_inventory_item_id => l_detail_rec.inventory_item_id
2489: RETURN;
2490: END IF;
2491:
2492: ---
2493: l_wms_org_flag := wms_install.check_install(x_return_status => x_return_status,
2494: x_msg_count => l_msg_count,
2495: x_msg_data => x_error_msg,
2496: p_organization_id => l_organization_id);
2497: