DBA Data[Home] [Help]

APPS.WMS_TASK_UTILS_PVT dependencies on WMS_CONTAINER_PUB

Line 107: l_lpn WMS_CONTAINER_PUB.LPN;

103: l_count NUMBER;
104: l_fm_serial_number VARCHAR2(30);
105: l_to_serial_number VARCHAR2(30);
106: l_serial_transaction_temp_id NUMBER;
107: l_lpn WMS_CONTAINER_PUB.LPN;
108: l_lpn_context NUMBER;
109: l_msg_data VARCHAR2(100);
110:
111: CURSOR mmtt_to_del(mol_id NUMBER) IS

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

468:
469: --bug 4411814
470: l_lpn.lpn_id := l_content_lpn_id;
471: l_lpn.organization_id := l_org_id;
472: l_lpn.lpn_context := wms_container_pub.lpn_context_inv;
473:
474: wms_container_pvt.Modify_LPN
475: (
476: p_api_version => 1.0

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

586: ELSIF l_wms_task_types = wms_globals.g_wms_task_type_stg_move THEN
587:
588: IF (l_debug = 1) THEN
589: mydebug('Calling wms_container_pvt.Modify_LPN_Wrapper for staging move. p_lpn_id = '||l_content_lpn_id);
590: mydebug('p_lpn_context = '|| wms_container_pub.LPN_CONTEXT_PICKED );
591: END IF;
592:
593: wms_container_pub.Modify_LPN_Wrapper
594: ( p_api_version => 1.0

Line 593: wms_container_pub.Modify_LPN_Wrapper

589: mydebug('Calling wms_container_pvt.Modify_LPN_Wrapper for staging move. p_lpn_id = '||l_content_lpn_id);
590: mydebug('p_lpn_context = '|| wms_container_pub.LPN_CONTEXT_PICKED );
591: END IF;
592:
593: wms_container_pub.Modify_LPN_Wrapper
594: ( p_api_version => 1.0
595: ,x_return_status => l_return_status
596: ,x_msg_count => l_msg_count
597: ,x_msg_data => x_message

Line 599: ,p_lpn_context => wms_container_pub.lpn_context_picked

595: ,x_return_status => l_return_status
596: ,x_msg_count => l_msg_count
597: ,x_msg_data => x_message
598: ,p_lpn_id => l_content_lpn_id
599: ,p_lpn_context => wms_container_pub.lpn_context_picked
600: );
601:
602: IF (l_debug = 1) THEN
603: mydebug('wms_container_pvt.Modify_LPN_Wrapper x_return_status = '||l_return_status);

Line 1151: IF ( l_lpn_ctx = WMS_Container_PUB.LPN_CONTEXT_PREGENERATED ) THEN

1147: IF (l_debug = 1) THEN
1148: mydebug('LPN id : '||mmtt_row.allocated_lpn_id ||', context:' || l_lpn_ctx );
1149: END IF;
1150:
1151: IF ( l_lpn_ctx = WMS_Container_PUB.LPN_CONTEXT_PREGENERATED ) THEN
1152: mmtt_row.allocated_lpn_id := NULL ;
1153: IF (l_debug = 1) THEN
1154: mydebug('LPN has context 5, so null it out in MMTTT' );
1155: END IF;