APPS.WMS_UNLOAD_UTILS_PVT dependencies on WMS_LPN_CONTENTS

Line 682: select count(1) into l_wlc_count from wms_lpn_contents where parent_lpn_id = l_transfer_lpn_id and organization_id = l_org_id;

678:
679: --BUG 12670785 adding to get WLC count. If WLC is present then make LPN context to 1 other wise make it 5.
680: --changed below to txfer lpn id otherwise context was going to 1 for txfer lpn
681: l_wlc_count := 0;
682: select count(1) into l_wlc_count from wms_lpn_contents where parent_lpn_id = l_transfer_lpn_id and organization_id = l_org_id;
683: if (l_wlc_count > 0) then
684: l_lpn.lpn_context := 1;
685: else
686: l_lpn.lpn_context := 5;