DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WMS_CONTAINER_PUB

Line 3897: wms_container_pub.create_lpn(

3893:
3894: IF (l_exist_lpn = 0) THEN
3895: -- LPN does not exist, create it
3896: -- Call Suresh's Create LPN API
3897: wms_container_pub.create_lpn(
3898: p_api_version => 1.0
3899: , p_init_msg_list => fnd_api.g_false
3900: , p_commit => fnd_api.g_false
3901: , x_return_status => x_return_status

Line 6799: l_lpn_update WMS_CONTAINER_PUB.LPN;

6795: l_quantity NUMBER;
6796: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6797:
6798: -- Bug 4411792
6799: l_lpn_update WMS_CONTAINER_PUB.LPN;
6800: l_return_status VARCHAR2(1);
6801: l_msg_count NUMBER;
6802: l_msg_data VARCHAR2(2000);
6803:

Line 7057: IF l_lpn_context = wms_container_pub.lpn_context_pregenerated THEN

7053: IF (l_debug = 1) THEN
7054: mydebug('lpn_context = ' || l_lpn_context);
7055: END IF;
7056:
7057: IF l_lpn_context = wms_container_pub.lpn_context_pregenerated THEN
7058: IF (l_debug = 1) THEN
7059: mydebug('update LPN context to 1');
7060: END IF;
7061:

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

7061:
7062: -- Bug 4411792
7063: l_lpn_update.license_plate_number := p_to_lpn;
7064: l_lpn_update.organization_id := p_org_id;
7065: l_lpn_update.lpn_context := wms_container_pub.lpn_context_inv;
7066:
7067: wms_container_pvt.Modify_LPN
7068: (
7069: p_api_version => 1.0

Line 7081: --SET lpn_context = wms_container_pub.lpn_context_inv

7077: l_lpn_update := NULL;
7078:
7079: -- 4411792 The below is replaced by the above API call
7080: --UPDATE wms_license_plate_numbers
7081: --SET lpn_context = wms_container_pub.lpn_context_inv
7082: --WHERE license_plate_number = p_to_lpn
7083: --AND organization_id = p_org_id;
7084:
7085: END IF;