[Home] [Help]
14: , x_return_status OUT NOCOPY VARCHAR2
15: , x_msg_data OUT NOCOPY VARCHAR2
16: , x_msg_count OUT NOCOPY NUMBER
17: ) IS
18: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
19: BEGIN
20: x_return_status := FND_API.G_RET_STS_SUCCESS;
21: /* Bug 2456261: Added Object_Type = 2 in the Query */
22: SELECT object_id, object_type
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
77: /*
78: * First get Obj. ID and Type of Object and its parent
79: */
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
163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: /* Checking whether Parent Item is Serial Controlled */
270: , p_parent_sernum IN VARCHAR2
271: , p_org_id IN NUMBER
272: ) IS
273: l_object_id NUMBER;
274: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
275: BEGIN
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: BEGIN
357: since it is un-necessary.
358: Also , now populating p_rowid (IN OUT parameter) with '0' to avoid any problems with NULL
359: calue in inltis.
360: p_rowid is not used anywhere */
361: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
362: BEGIN
363: p_rowid := '0';
364: /*
365: * Determine the type of transaction from the transaction source and action