APPS.WMS_LPN_LOVS dependencies on WMS_CONTAINER_PUB

Line 2538: l_lpn WMS_container_pub.LPN;

2534: (p_lpn IN VARCHAR2 ,
2535: p_organization_id IN NUMBER ,
2536: x_result OUT NOCOPY NUMBER)
2537: IS
2538: l_lpn WMS_container_pub.LPN;
2539: l_result NUMBER;
2540:
2541: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2542: BEGIN

Line 2545: l_result := wms_container_pub.Validate_LPN(l_lpn);

2541: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2542: BEGIN
2543: l_lpn.lpn_id := NULL;
2544: l_lpn.license_plate_number := p_lpn;
2545: l_result := wms_container_pub.Validate_LPN(l_lpn);
2546: IF (l_result = INV_Validate.F) THEN
2547: -- LPN was not found
2548: x_result := 2;
2549: ELSE

Line 2738: and lpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

2734: and lpnc.parent_lpn_id = lpn.lpn_id
2735: and nvl(lpn.SUBINVENTORY_CODE,'@@@') = nvl(p_subinventory_code,'@@@')
2736: and nvl(lpn.LOCATOR_ID, 0) = nvl(p_locator_id, 0)
2737: and lpn.license_plate_number like (p_lpn)
2738: and lpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2739: and not exists (select null
2740: from wms_lpn_contents
2741: where parent_lpn_id = lpnc.parent_lpn_id
2742: and inventory_item_id <> lpnc.inventory_item_id)

Line 4455: AND (wlpn.lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED

4451: NVL(wlpn.content_volume, 0)
4452: FROM wms_license_plate_numbers wlpn
4453: WHERE wlpn.organization_id = p_organization_id
4454: AND wlpn.lpn_id <> p_lpn_id
4455: AND (wlpn.lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED
4456: OR (wlpn.lpn_context = p_lpn_context
4457: AND ( (NOT EXISTS (SELECT 'LPN_HAS_MATERIAL'
4458: FROM wms_lpn_contents
4459: WHERE parent_lpn_id IN (SELECT wlpn1.lpn_id