2042: AND wdd.delivery_detail_id = wda.delivery_detail_id;
2043:
2044:
2045: IF (l_debug = 1) THEN
2046: print_debug('Before calling wms_pick_drop_pvt.get_default_drop_lpn ' , 1);
2047: print_debug('p_to_sub: ' ||l_to_sub_code , 1);
2048: print_debug('p_to_loc: ' || l_to_loc_id, 1);
2049: print_debug('p_delivery_id: ' || l_delivery_id, 1);
2050: END IF;
2050: END IF;
2051:
2052: l_progress := '20';
2053:
2054: wms_pick_drop_pvt.get_default_drop_lpn
2055: ( x_drop_lpn_num => l_license_plan_number
2056: , x_return_status => x_return_status
2057: , p_organization_id => l_organization_id
2058: , p_delivery_id => l_delivery_id