431: END IF;
432:
433: else /* LPN transaction */
434: /*
435: ** Look at WMS_LPN_CONTENTS, lpn content details table
436: */
437:
438: BEGIN
439: SELECT 'Y' INTO l_lpn_contents_exist
445: --Changing the count(*) to existence for performance improvement
446: --select
447: --count(*)
448: --into l_lpn_contents_count
449: from wms_lpn_contents
450: where organization_id = p_organization_id
451: AND inventory_item_id = p_inventory_item_id
452: AND (revision = p_revision
453: OR revision is null and p_revision is null)