APPS.WMS_SHIPPING_LPN_UTILS_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 33: FROM wms_license_plate_numbers wlpn

29: IS
30:
31: CURSOR child_lpns_cursor(l_lpn_id IN NUMBER) IS
32: SELECT wlpn.lpn_id
33: FROM wms_license_plate_numbers wlpn
34: WHERE wlpn.lpn_context <> wms_globals.lpn_context_inv
35: START WITH wlpn.lpn_id = l_lpn_id
36: CONNECT BY wlpn.lpn_id = PRIOR parent_lpn_id;
37:

Line 67: UPDATE wms_license_plate_numbers

63: LOOP
64: FETCH child_lpns_cursor INTO l_lpn_id;
65: EXIT WHEN child_lpns_cursor%notfound;
66:
67: UPDATE wms_license_plate_numbers
68: SET lpn_context = wms_globals.lpn_context_inv
69: WHERE lpn_id = l_lpn_id;
70:
71: END LOOP;