DBA Data[Home] [Help]

APPS.WMS_UNLOAD_UTILS_PVT dependencies on WMS_CONTAINER_PUB

Line 69: l_lpn WMS_CONTAINER_PUB.LPN;

65: l_count NUMBER;
66: l_fm_serial_number VARCHAR2(30);
67: l_to_serial_number VARCHAR2(30);
68: l_serial_transaction_temp_id NUMBER;
69: l_lpn WMS_CONTAINER_PUB.LPN;
70: l_lpn_context NUMBER;
71:
72: l_lpn_id NUMBER; --BUG 12670785 Unload problem
73: l_wlc_count NUMBER;--BUG 12670785 Unload problem

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

547:
548: --bug 4411814
549: l_lpn.lpn_id := l_content_lpn_id;
550: l_lpn.organization_id := l_org_id;
551: l_lpn.lpn_context := wms_container_pub.lpn_context_inv;
552:
553: wms_container_pvt.Modify_LPN
554: (
555: p_api_version => 1.0

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

712: ELSIF l_wms_task_types = wms_globals.g_wms_task_type_stg_move THEN
713:
714: IF (l_debug = 1) THEN
715: mydebug('Calling wms_container_pvt.Modify_LPN_Wrapper for staging move. p_lpn_id = '||l_content_lpn_id);
716: mydebug('p_lpn_context = '|| wms_container_pub.LPN_CONTEXT_PICKED );
717: END IF;
718:
719: wms_container_pub.Modify_LPN_Wrapper
720: ( p_api_version => 1.0

Line 719: wms_container_pub.Modify_LPN_Wrapper

715: mydebug('Calling wms_container_pvt.Modify_LPN_Wrapper for staging move. p_lpn_id = '||l_content_lpn_id);
716: mydebug('p_lpn_context = '|| wms_container_pub.LPN_CONTEXT_PICKED );
717: END IF;
718:
719: wms_container_pub.Modify_LPN_Wrapper
720: ( p_api_version => 1.0
721: ,x_return_status => l_return_status
722: ,x_msg_count => l_msg_count
723: ,x_msg_data => x_message

Line 725: ,p_lpn_context => wms_container_pub.lpn_context_picked

721: ,x_return_status => l_return_status
722: ,x_msg_count => l_msg_count
723: ,x_msg_data => x_message
724: ,p_lpn_id => l_content_lpn_id
725: ,p_lpn_context => wms_container_pub.lpn_context_picked
726: );
727:
728: IF (l_debug = 1) THEN
729: mydebug('wms_container_pvt.Modify_LPN_Wrapper x_return_status = '||l_return_status);

Line 784: l_lpn WMS_CONTAINER_PUB.LPN;

780: l_content_lpn_id NUMBER;
781: l_fm_serial_number VARCHAR2(30);
782: l_to_serial_number VARCHAR2(30);
783: l_serial_transaction_temp_id NUMBER;
784: l_lpn WMS_CONTAINER_PUB.LPN;
785: l_lpn_context NUMBER;
786:
787: CURSOR c_cncl_ovrpick_lines (p_temp_id IN NUMBER) IS
788: SELECT 'CANCELLED'

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

1005:
1006: --bug 4411814
1007: l_lpn.lpn_id := l_content_lpn_id;
1008: l_lpn.organization_id := l_org_id;
1009: l_lpn.lpn_context := wms_container_pub.lpn_context_inv;
1010:
1011: wms_container_pvt.Modify_LPN
1012: (
1013: p_api_version => 1.0