DBA Data[Home] [Help]

APPS.GMO_DISPENSE_GRP dependencies on GMO_MATERIAL_DISPENSES

Line 53: UPDATE GMO_MATERIAL_DISPENSES

49:
50:
51: -- Maintain Reservation starts now
52: -- first update the material dispense table
53: UPDATE GMO_MATERIAL_DISPENSES
54: SET reservation_id = p_new_reservation_id
55: WHERE batch_id = p_batch_id
56: and inventory_item_id = p_item_id
57: and material_detail_id = p_material_detail_id

Line 174: UPDATE GMO_MATERIAL_DISPENSES

170:
171: raise WRONG_STATUS_ERROR;
172: end if;
173:
174: UPDATE GMO_MATERIAL_DISPENSES
175: SET material_status = p_status_code,
176: DISPENSE_SOURCE_TRANSACTION_ID = nvl(DISPENSE_SOURCE_TRANSACTION_ID, p_transaction_id)
177: WHERE dispense_id = p_dispense_id;
178: