DBA Data[Home] [Help]

APPS.GME_MATERIAL_DETAIL_PVT dependencies on GME_PARAMETERS

Line 661: --Bug#5078853 Begin get the default sub inv and locator either from gme_parameters or from Item Master

657: IF p_material_detail_rec.subinventory = fnd_api.g_miss_char THEN
658: x_material_detail_rec.subinventory := NULL;
659: x_material_detail_rec.locator_id := NULL;
660: ELSIF p_material_detail_rec.subinventory IS NULL THEN
661: --Bug#5078853 Begin get the default sub inv and locator either from gme_parameters or from Item Master
662: IF p_material_detail_rec.line_type = gme_common_pvt.g_line_type_ing THEN
663: gme_common_pvt.get_supply_defaults ( p_organization_id => x_material_detail_rec.organization_id
664: ,p_inventory_item_id => p_material_detail_rec.inventory_item_id
665: ,x_subinventory => x_material_detail_rec.subinventory

Line 4222: FROM gme_parameters

4218: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_del';
4219:
4220: CURSOR c_get_delete(v_org_id NUMBER) IS
4221: SELECT delete_material_ind
4222: FROM gme_parameters
4223: WHERE organization_id = v_org_id;
4224:
4225: CURSOR num_detail_lines (v_batch_id NUMBER, v_line_type NUMBER) IS
4226: SELECT COUNT (*)