DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WMS_CONTAINER_PUB

Line 4102: wms_container_pub.create_lpn(

4098:
4099: IF (l_exist_lpn = 0) THEN
4100: -- LPN does not exist, create it
4101: -- Call Suresh's Create LPN API
4102: wms_container_pub.create_lpn(
4103: p_api_version => 1.0
4104: , p_init_msg_list => fnd_api.g_false
4105: , p_commit => fnd_api.g_false
4106: , x_return_status => x_return_status

Line 7126: l_lpn_update WMS_CONTAINER_PUB.LPN;

7122: l_quantity NUMBER;
7123: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7124:
7125: -- Bug 4411792
7126: l_lpn_update WMS_CONTAINER_PUB.LPN;
7127: l_return_status VARCHAR2(1);
7128: l_msg_count NUMBER;
7129: l_msg_data VARCHAR2(2000);
7130:

Line 7384: IF l_lpn_context = wms_container_pub.lpn_context_pregenerated THEN

7380: IF (l_debug = 1) THEN
7381: mydebug('lpn_context = ' || l_lpn_context);
7382: END IF;
7383:
7384: IF l_lpn_context = wms_container_pub.lpn_context_pregenerated THEN
7385: IF (l_debug = 1) THEN
7386: mydebug('update LPN context to 1');
7387: END IF;
7388:

Line 7392: l_lpn_update.lpn_context := wms_container_pub.lpn_context_inv;

7388:
7389: -- Bug 4411792
7390: l_lpn_update.license_plate_number := p_to_lpn;
7391: l_lpn_update.organization_id := p_org_id;
7392: l_lpn_update.lpn_context := wms_container_pub.lpn_context_inv;
7393:
7394: wms_container_pvt.Modify_LPN
7395: (
7396: p_api_version => 1.0

Line 7408: --SET lpn_context = wms_container_pub.lpn_context_inv

7404: l_lpn_update := NULL;
7405:
7406: -- 4411792 The below is replaced by the above API call
7407: --UPDATE wms_license_plate_numbers
7408: --SET lpn_context = wms_container_pub.lpn_context_inv
7409: --WHERE license_plate_number = p_to_lpn
7410: --AND organization_id = p_org_id;
7411:
7412: END IF;