DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on WMS_TASK_MGMT_PUB

Line 3482: qty_tbl wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE;

3478: ,x_msg_count OUT NOCOPY NUMBER
3479: ,x_msg_data OUT NOCOPY VARCHAR2
3480: )
3481: IS
3482: qty_tbl wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE;
3483: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3484: l_resultant_task_details wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE;
3485: l_resultant_tasks wms_Task_mgmt_pub.TASK_TAB_TYPE;
3486: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 3484: l_resultant_task_details wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE;

3480: )
3481: IS
3482: qty_tbl wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE;
3483: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3484: l_resultant_task_details wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE;
3485: l_resultant_tasks wms_Task_mgmt_pub.TASK_TAB_TYPE;
3486: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3487:
3488: BEGIN

Line 3485: l_resultant_tasks wms_Task_mgmt_pub.TASK_TAB_TYPE;

3481: IS
3482: qty_tbl wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE;
3483: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3484: l_resultant_task_details wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE;
3485: l_resultant_tasks wms_Task_mgmt_pub.TASK_TAB_TYPE;
3486: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3487:
3488: BEGIN
3489:

Line 3539: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,

3535: fnd_msg_pub.ADD;
3536: END split_mmtt_lpn;
3537:
3538: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
3539: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,
3540: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
3541: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
3542: x_resultant_task_details OUT NOCOPY wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE ,
3543: x_return_status OUT NOCOPY VARCHAR2 ,

Line 3541: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

3537:
3538: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
3539: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,
3540: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
3541: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
3542: x_resultant_task_details OUT NOCOPY wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE ,
3543: x_return_status OUT NOCOPY VARCHAR2 ,
3544: x_msg_count OUT NOCOPY NUMBER ,
3545: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 3542: x_resultant_task_details OUT NOCOPY wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE ,

3538: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
3539: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,
3540: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
3541: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
3542: x_resultant_task_details OUT NOCOPY wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE ,
3543: x_return_status OUT NOCOPY VARCHAR2 ,
3544: x_msg_count OUT NOCOPY NUMBER ,
3545: x_msg_data OUT NOCOPY VARCHAR2 ) IS
3546:

Line 3572: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;

3568: l_mol_num NUMBER;
3569: l_serial_control_code NUMBER;
3570: l_lot_control_code NUMBER;
3571: l_index NUMBER;
3572: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
3573: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
3574: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
3575: l_return_status VARCHAR2(10);
3576: l_msg_count NUMBER;

Line 3573: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;

3569: l_serial_control_code NUMBER;
3570: l_lot_control_code NUMBER;
3571: l_index NUMBER;
3572: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
3573: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
3574: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
3575: l_return_status VARCHAR2(10);
3576: l_msg_count NUMBER;
3577: l_msg_data VARCHAR(200);

Line 3574: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;

3570: l_lot_control_code NUMBER;
3571: l_index NUMBER;
3572: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
3573: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
3574: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
3575: l_return_status VARCHAR2(10);
3576: l_msg_count NUMBER;
3577: l_msg_data VARCHAR(200);
3578: l_validation_status VARCHAR2(10);

Line 3591: l_split_uom_quantities WMS_TASK_MGMT_PUB.QTY_CHANGED_TBL_TYPE;

3587: l_val_task_ret_status VARCHAR2(1);
3588: l_mmtt_inventory_item_id NUMBER;
3589: l_mmtt_task_status NUMBER;
3590: l_mmtt_organization_id NUMBER;
3591: l_split_uom_quantities WMS_TASK_MGMT_PUB.QTY_CHANGED_TBL_TYPE;
3592: l_val_qty_ret_status VARCHAR2(1);
3593: l_invalid_task EXCEPTION;
3594: l_invalid_quantities EXCEPTION;
3595: l_unexpected_error EXCEPTION;

Line 3883: p_split_quantities IN wms_Task_mgmt_pub.task_qty_tbl_type ,

3879: END IF;
3880: END split_task;
3881:
3882: PROCEDURE validate_quantities( p_transaction_temp_id IN NUMBER ,
3883: p_split_quantities IN wms_Task_mgmt_pub.task_qty_tbl_type ,
3884: x_lot_control_code OUT NOCOPY NUMBER ,
3885: x_serial_control_code OUT NOCOPY NUMBER ,
3886: x_split_uom_quantities OUT NOCOPY wms_Task_mgmt_pub.qty_changed_tbl_type ,
3887: x_return_status OUT NOCOPY VARCHAR2 ,

Line 3886: x_split_uom_quantities OUT NOCOPY wms_Task_mgmt_pub.qty_changed_tbl_type ,

3882: PROCEDURE validate_quantities( p_transaction_temp_id IN NUMBER ,
3883: p_split_quantities IN wms_Task_mgmt_pub.task_qty_tbl_type ,
3884: x_lot_control_code OUT NOCOPY NUMBER ,
3885: x_serial_control_code OUT NOCOPY NUMBER ,
3886: x_split_uom_quantities OUT NOCOPY wms_Task_mgmt_pub.qty_changed_tbl_type ,
3887: x_return_status OUT NOCOPY VARCHAR2 ,
3888: x_msg_data OUT NOCOPY VARCHAR2 ,
3889: x_msg_count OUT NOCOPY VARCHAR2 ) IS
3890: