APPS.MTL_OG_UTIL_PKG dependencies on MTL_SERIAL_NUMBERS

Line 260: This updates the mtl_object_genealogy and mtl_serial_numbers tables

256: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_data => x_msg_data, p_count => x_msg_count);
257: END gen_insert;
258:
259: /** added the procedure gen_update for the 'Serial Tracking in WIP Project.
260: This updates the mtl_object_genealogy and mtl_serial_numbers tables
261: when a serialized component is returned to stores from a WIP job.
262: The genealogy between the parent and the child serials should be disabled
263: whenever a component return transaction is performed. */
264: PROCEDURE gen_update(

Line 281: FROM mtl_serial_numbers

277:
278: BEGIN
279: if( p_parent_sernum is not null ) then
280: SELECT gen_object_id INTO l_object_id
281: FROM mtl_serial_numbers
282: WHERE serial_number = p_sernum
283: AND parent_serial_number = p_parent_sernum
284: AND current_organization_id = p_org_id
285: AND inventory_item_id = p_item_id; --Bug # 2682600

Line 288: FROM mtl_serial_numbers

284: AND current_organization_id = p_org_id
285: AND inventory_item_id = p_item_id; --Bug # 2682600
286: else
287: SELECT gen_object_id into l_object_id
288: FROM mtl_serial_numbers
289: WHERE serial_number = p_sernum
290: AND current_organization_id = p_org_id
291: AND inventory_item_id = p_item_id; --Bug # 2682600
292: end if;

Line 316: UPDATE mtl_serial_numbers

312: WHERE object_id = l_object_id
313: AND END_date_active IS NULL
314: AND genealogy_type <> 5 ;
315:
316: UPDATE mtl_serial_numbers
317: SET parent_serial_number = NULL
318: ,LAST_UPDATE_DATE = SYSDATE
319: ,LAST_UPDATED_BY = -1
320: ,LAST_UPDATE_LOGIN = -1