437: ELSE
438: BEGIN
439: SELECT 1
440: INTO l_dummy
441: FROM mtl_item_revisions
442: WHERE inventory_item_id = p_inv_item_id
443: AND organization_id = p_inv_org_id
444: AND revision = p_revision;
445: l_return_value := TRUE;
458: IF ((p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR)) THEN
459: BEGIN
460: SELECT 1
461: INTO l_dummy
462: FROM mtl_item_revisions
463: WHERE inventory_item_id = p_inv_item_id
464: AND organization_id = p_inv_org_id
465: AND revision = p_revision;
466: l_return_value := TRUE;
538: ELSE
539: BEGIN
540: SELECT 1
541: INTO l_dummy
542: FROM mtl_item_revisions
543: WHERE inventory_item_id = p_inv_item_id
544: AND organization_id = p_inv_org_id
545: AND revision = p_revision;
546: l_return_value := TRUE;
559: IF ((p_revision IS NOT NULL) AND (p_revision <> FND_API.G_MISS_CHAR)) THEN
560: BEGIN
561: SELECT 1
562: INTO l_dummy
563: FROM mtl_item_revisions
564: WHERE inventory_item_id = p_inv_item_id
565: AND organization_id = p_inv_org_id
566: AND revision = p_revision;
567: l_return_value := TRUE;