DBA Data[Home] [Help]

APPS.WMS_UNLOAD_UTILS_PVT dependencies on WMS_CONTAINER_PUB

Line 52: l_lpn WMS_CONTAINER_PUB.LPN;

48: l_count NUMBER;
49: l_fm_serial_number VARCHAR2(30);
50: l_to_serial_number VARCHAR2(30);
51: l_serial_transaction_temp_id NUMBER;
52: l_lpn WMS_CONTAINER_PUB.LPN;
53: l_lpn_context NUMBER;
54:
55: CURSOR mmtt_to_del(mol_id NUMBER) IS
56: SELECT mmtt.transaction_temp_id

Line 401: l_lpn.lpn_context := wms_container_pub.lpn_context_inv;

397:
398: --bug 4411814
399: l_lpn.lpn_id := l_content_lpn_id;
400: l_lpn.organization_id := l_org_id;
401: l_lpn.lpn_context := wms_container_pub.lpn_context_inv;
402:
403: wms_container_pvt.Modify_LPN
404: (
405: p_api_version => 1.0

Line 521: mydebug('p_lpn_context = '|| wms_container_pub.LPN_CONTEXT_PICKED );

517: ELSIF l_wms_task_types = wms_globals.g_wms_task_type_stg_move THEN
518:
519: IF (l_debug = 1) THEN
520: mydebug('Calling wms_container_pvt.Modify_LPN_Wrapper for staging move. p_lpn_id = '||l_content_lpn_id);
521: mydebug('p_lpn_context = '|| wms_container_pub.LPN_CONTEXT_PICKED );
522: END IF;
523:
524: wms_container_pub.Modify_LPN_Wrapper
525: ( p_api_version => 1.0

Line 524: wms_container_pub.Modify_LPN_Wrapper

520: mydebug('Calling wms_container_pvt.Modify_LPN_Wrapper for staging move. p_lpn_id = '||l_content_lpn_id);
521: mydebug('p_lpn_context = '|| wms_container_pub.LPN_CONTEXT_PICKED );
522: END IF;
523:
524: wms_container_pub.Modify_LPN_Wrapper
525: ( p_api_version => 1.0
526: ,x_return_status => l_return_status
527: ,x_msg_count => l_msg_count
528: ,x_msg_data => x_message

Line 530: ,p_lpn_context => wms_container_pub.lpn_context_picked

526: ,x_return_status => l_return_status
527: ,x_msg_count => l_msg_count
528: ,x_msg_data => x_message
529: ,p_lpn_id => l_content_lpn_id
530: ,p_lpn_context => wms_container_pub.lpn_context_picked
531: );
532:
533: IF (l_debug = 1) THEN
534: mydebug('wms_container_pvt.Modify_LPN_Wrapper x_return_status = '||l_return_status);

Line 589: l_lpn WMS_CONTAINER_PUB.LPN;

585: l_content_lpn_id NUMBER;
586: l_fm_serial_number VARCHAR2(30);
587: l_to_serial_number VARCHAR2(30);
588: l_serial_transaction_temp_id NUMBER;
589: l_lpn WMS_CONTAINER_PUB.LPN;
590: l_lpn_context NUMBER;
591:
592: CURSOR c_cncl_ovrpick_lines (p_temp_id IN NUMBER) IS
593: SELECT 'CANCELLED'

Line 797: l_lpn.lpn_context := wms_container_pub.lpn_context_inv;

793:
794: --bug 4411814
795: l_lpn.lpn_id := l_content_lpn_id;
796: l_lpn.organization_id := l_org_id;
797: l_lpn.lpn_context := wms_container_pub.lpn_context_inv;
798:
799: wms_container_pvt.Modify_LPN
800: (
801: p_api_version => 1.0