APPS.MTL_OG_UTIL_PKG dependencies on MTL_OBJECT_GENEALOGY

Line 72: FROM mtl_object_genealogy

68: l_msg_count NUMBER;
69:
70: CURSOR c IS
71: SELECT ROWID
72: FROM mtl_object_genealogy
73: WHERE object_id = l_obj_id
74: AND parent_object_id = l_parent_obj_id;
75: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
76: BEGIN

Line 92: INSERT INTO mtl_object_genealogy

88: l_genealogy_type := 1;
89: l_genealogy_origin := 1;
90: l_trx_date := SYSDATE;
91:
92: INSERT INTO mtl_object_genealogy
93: (
94: object_id
95: , object_type
96: , parent_object_type

Line 158: FROM mtl_object_genealogy

154: l_parent_ser_ctrl NUMBER;
155:
156: CURSOR c IS
157: SELECT ROWID
158: FROM mtl_object_genealogy
159: WHERE object_id = l_obj_id
160: AND parent_object_id = l_parent_obj_id;
161: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
162: BEGIN

Line 205: INSERT INTO mtl_object_genealogy

201: l_genealogy_type := 1;
202: l_genealogy_origin := 1;
203: l_trx_date := SYSDATE;
204:
205: INSERT INTO mtl_object_genealogy
206: (
207: object_id
208: , object_type
209: , parent_object_type

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 307: UPDATE mtl_object_genealogy

303: END IF;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: END;
306: BEGIN
307: UPDATE mtl_object_genealogy
308: SET end_date_active = SYSDATE
309: ,LAST_UPDATE_DATE = SYSDATE
310: ,LAST_UPDATED_BY = -1
311: ,LAST_UPDATE_LOGIN = -1