APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WMS_CONTAINER_PUB

Line 1963: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,

1959: --\Shipping API cleanup
1960:
1961: -- change the LPN context
1962: UPDATE WMS_LICENSE_PLATE_NUMBERS
1963: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,
1964: last_update_date = SYSDATE,
1965: last_updated_by = FND_GLOBAL.USER_ID
1966: where lpn_id = p_outermost_lpn_id;
1967:

Line 1971: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,

1967:
1968: -- update the lpn context for all children lpns
1969: FOR l_lpn_id IN nested_children_lpn_cursor LOOP
1970: UPDATE WMS_LICENSE_PLATE_NUMBERS
1971: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,
1972: last_update_date = SYSDATE,
1973: last_updated_by = FND_GLOBAL.USER_ID
1974: where lpn_id = l_lpn_id.lpn_id;
1975: END LOOP;

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

4148: LOOP
4149: fetch outermost_lpn_for_trip into l_outermost_lpn_id;
4150: exit when outermost_lpn_for_trip%NOTFOUND;
4151: UPDATE WMS_LICENSE_PLATE_NUMBERS
4152: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4153: last_update_date = SYSDATE,
4154: last_updated_by = FND_GLOBAL.USER_ID
4155: where lpn_id = l_outermost_lpn_id;
4156:

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

4156:
4157: -- update the lpn context for all children lpns
4158: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP
4159: UPDATE WMS_LICENSE_PLATE_NUMBERS
4160: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4161: last_update_date = SYSDATE,
4162: last_updated_by = FND_GLOBAL.USER_ID
4163: where lpn_id = l_lpn_id.lpn_id;
4164: END LOOP;

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

4187: LOOP
4188: fetch outermost_lpn_for_dock into l_outermost_lpn_id;
4189: exit when outermost_lpn_for_dock%NOTFOUND;
4190: UPDATE WMS_LICENSE_PLATE_NUMBERS
4191: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4192: last_update_date = SYSDATE,
4193: last_updated_by = FND_GLOBAL.USER_ID
4194: where lpn_id = l_outermost_lpn_id;
4195:

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

4195:
4196: -- update the lpn context for all children lpns
4197: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP
4198: UPDATE WMS_LICENSE_PLATE_NUMBERS
4199: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4200: last_update_date = SYSDATE,
4201: last_updated_by = FND_GLOBAL.USER_ID
4202: where lpn_id = l_lpn_id.lpn_id;
4203: END LOOP;