APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WMS_CONTAINER_PUB

Line 2024: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,

2020: --\Shipping API cleanup
2021:
2022: -- change the LPN context
2023: UPDATE WMS_LICENSE_PLATE_NUMBERS
2024: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,
2025: last_update_date = SYSDATE,
2026: last_updated_by = FND_GLOBAL.USER_ID
2027: where lpn_id = p_outermost_lpn_id;
2028:

Line 2032: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,

2028:
2029: -- update the lpn context for all children lpns
2030: FOR l_lpn_id IN nested_children_lpn_cursor LOOP
2031: UPDATE WMS_LICENSE_PLATE_NUMBERS
2032: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,
2033: last_update_date = SYSDATE,
2034: last_updated_by = FND_GLOBAL.USER_ID
2035: where lpn_id = l_lpn_id.lpn_id;
2036: END LOOP;

Line 4312: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,

4308: LOOP
4309: fetch outermost_lpn_for_trip into l_outermost_lpn_id;
4310: exit when outermost_lpn_for_trip%NOTFOUND;
4311: UPDATE WMS_LICENSE_PLATE_NUMBERS
4312: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4313: last_update_date = SYSDATE,
4314: last_updated_by = FND_GLOBAL.USER_ID
4315: where lpn_id = l_outermost_lpn_id;
4316:

Line 4320: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,

4316:
4317: -- update the lpn context for all children lpns
4318: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP
4319: UPDATE WMS_LICENSE_PLATE_NUMBERS
4320: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4321: last_update_date = SYSDATE,
4322: last_updated_by = FND_GLOBAL.USER_ID
4323: where lpn_id = l_lpn_id.lpn_id;
4324: END LOOP;

Line 4351: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,

4347: LOOP
4348: fetch outermost_lpn_for_dock into l_outermost_lpn_id;
4349: exit when outermost_lpn_for_dock%NOTFOUND;
4350: UPDATE WMS_LICENSE_PLATE_NUMBERS
4351: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4352: last_update_date = SYSDATE,
4353: last_updated_by = FND_GLOBAL.USER_ID
4354: where lpn_id = l_outermost_lpn_id;
4355:

Line 4359: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,

4355:
4356: -- update the lpn context for all children lpns
4357: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP
4358: UPDATE WMS_LICENSE_PLATE_NUMBERS
4359: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4360: last_update_date = SYSDATE,
4361: last_updated_by = FND_GLOBAL.USER_ID
4362: where lpn_id = l_lpn_id.lpn_id;
4363: END LOOP;