[Home] [Help]
697: IF p_material_detail_rec.subinventory = fnd_api.g_miss_char THEN
698: x_material_detail_rec.subinventory := NULL;
699: x_material_detail_rec.locator_id := NULL;
700: ELSIF p_material_detail_rec.subinventory IS NULL THEN
701: --Bug#5078853 Begin get the default sub inv and locator either from gme_parameters or from Item Master
702: IF p_material_detail_rec.line_type = gme_common_pvt.g_line_type_ing THEN
703: gme_common_pvt.get_supply_defaults ( p_organization_id => x_material_detail_rec.organization_id
704: ,p_inventory_item_id => p_material_detail_rec.inventory_item_id
705: ,x_subinventory => x_material_detail_rec.subinventory
4409: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_del';
4410:
4411: CURSOR c_get_delete(v_org_id NUMBER) IS
4412: SELECT delete_material_ind
4413: FROM gme_parameters
4414: WHERE organization_id = v_org_id;
4415:
4416: CURSOR num_detail_lines (v_batch_id NUMBER, v_line_type NUMBER) IS
4417: SELECT COUNT (*)