[Home] [Help]
586: SELECT 1,
587: lpn_context
588: INTO l_lpn_exists,
589: l_lpn_context
590: FROM wms_license_plate_numbers wlpn
591: WHERE wlpn.organization_id = p_org_id
592: AND wlpn.lpn_id = p_lpn;
593:
594: EXCEPTION
672: l_from_lpn,
673: l_loc_id,
674: l_lpn_context
675: FROM
676: wms_license_plate_numbers w
677: WHERE
678: w.lpn_id = p_lpn
679: AND w.locator_id is not null;
680:
946: AND organization_id = p_org_id;
947:
948: select count(*)
949: into l_lpn_include_lpn
950: from wms_license_plate_numbers
951: where outermost_lpn_id = p_lpn
952: and organization_id = p_org_id;
953:
954:
2618: --For SO Pick, TM handles it in post 11.5.10.
2619: --In case the LPN is going to the non-LPN controlled sub then TM would have already unpacked and updated the lpn context TO 'defined but not used'. Leave these LPN as it is.
2620:
2621: CURSOR c_update_xfer_lpns_context IS
2622: SELECT wlpn.lpn_id,organization_id FROM wms_license_plate_numbers wlpn
2623: WHERE wlpn.lpn_context <> wms_container_pub.lpn_context_pregenerated
2624: --to avoid LPNS that have been unpacked by TM for non-LPN ctrld sub
2625: AND wlpn.lpn_id IN
2626: (SELECT wdr.xfer_lpn_id
2911:
2912: BEGIN
2913: SELECT lpn_context
2914: INTO l_pick_lpn_context
2915: FROM wms_license_plate_numbers WHERE
2916: lpn_id = l_rec.lpn_id
2917: AND organization_id = l_rec.organization_id;
2918:
2919:
3017:
3018: BEGIN
3019: SELECT lpn_context,license_plate_number
3020: INTO l_lpn_context, l_xfer_lpn
3021: FROM wms_license_plate_numbers WHERE
3022: lpn_id = l_rec.xfer_lpn_id
3023: AND organization_id = l_rec.organization_id;
3024:
3025: IF (l_debug = 1) THEN
3555: --
3556:
3557: /* updated as part of the bug 4411819
3558: --using wms_container_pvt.Modify_LPN() API instead
3559: UPDATE wms_license_plate_numbers
3560: SET lpn_context = l_lpn_context -- this still has
3561: --the original value of lpn context
3562: WHERE lpn_id = l_rec.xfer_lpn_id;
3563: */