[Home] [Help]
2006: if (l_status_enabled = 1) then
2007: -- check subinventory
2008: if (l_detail_rec.subinventory is not NULL) then
2009: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2010: p_wms_installed => 'TRUE'
2011: , p_trx_status_enabled => l_status_enabled
2012: , p_trx_type_id => l_trx_type_code
2013: , p_organization_id => l_org_id
2014: , p_sub_code => l_detail_rec.subinventory
2022: end if;
2023: -- check locator
2024: if (l_detail_rec.locator_id is not NULL) then
2025: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2026: p_wms_installed => 'TRUE'
2027: , p_trx_status_enabled => l_status_enabled
2028: , p_trx_type_id => l_trx_type_code
2029: , p_organization_id => l_org_id
2030: , p_locator_id => l_detail_rec.locator_id
2037: end if;
2038: -- check lot
2039: if (l_detail_rec.lot_number is not NULL) then
2040: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2041: p_wms_installed => 'TRUE'
2042: , p_trx_status_enabled => l_status_enabled
2043: , p_trx_type_id => l_trx_type_code
2044: , p_organization_id => l_org_id
2045: , p_inventory_item_id => l_detail_rec.inventory_item_id
2054: end if;
2055: -- check serial
2056: if (l_detail_rec.serial_number is not NULL) then
2057: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2058: p_wms_installed => 'TRUE'
2059: , p_trx_status_enabled => l_status_enabled
2060: , p_trx_type_id => l_trx_type_code
2061: , p_organization_id => l_org_id
2062: , p_inventory_item_id => l_detail_rec.inventory_item_id
2336: RETURN;
2337: END IF;
2338:
2339: ---
2340: l_wms_org_flag := wms_install.check_install(x_return_status => x_return_status,
2341: x_msg_count => l_msg_count,
2342: x_msg_data => x_error_msg,
2343: p_organization_id => l_organization_id);
2344: