DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on WMS_TASK_MGMT_PUB

Line 3910: qty_tbl wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE;

3906: ,x_msg_count OUT NOCOPY NUMBER
3907: ,x_msg_data OUT NOCOPY VARCHAR2
3908: )
3909: IS
3910: qty_tbl wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE;
3911: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3912: l_resultant_task_details wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE;
3913: l_resultant_tasks wms_Task_mgmt_pub.TASK_TAB_TYPE;
3914: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 3912: l_resultant_task_details wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE;

3908: )
3909: IS
3910: qty_tbl wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE;
3911: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3912: l_resultant_task_details wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE;
3913: l_resultant_tasks wms_Task_mgmt_pub.TASK_TAB_TYPE;
3914: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3915:
3916: BEGIN

Line 3913: l_resultant_tasks wms_Task_mgmt_pub.TASK_TAB_TYPE;

3909: IS
3910: qty_tbl wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE;
3911: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3912: l_resultant_task_details wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE;
3913: l_resultant_tasks wms_Task_mgmt_pub.TASK_TAB_TYPE;
3914: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3915:
3916: BEGIN
3917:

Line 3967: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,

3963: fnd_msg_pub.ADD;
3964: END split_mmtt_lpn;
3965:
3966: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
3967: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,
3968: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
3969: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
3970: x_resultant_task_details OUT NOCOPY wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE ,
3971: x_return_status OUT NOCOPY VARCHAR2 ,

Line 3969: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,

3965:
3966: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
3967: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,
3968: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
3969: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
3970: x_resultant_task_details OUT NOCOPY wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE ,
3971: x_return_status OUT NOCOPY VARCHAR2 ,
3972: x_msg_count OUT NOCOPY NUMBER ,
3973: x_msg_data OUT NOCOPY VARCHAR2 ) IS

Line 3970: x_resultant_task_details OUT NOCOPY wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE ,

3966: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL ,
3967: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,
3968: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
3969: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
3970: x_resultant_task_details OUT NOCOPY wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE ,
3971: x_return_status OUT NOCOPY VARCHAR2 ,
3972: x_msg_count OUT NOCOPY NUMBER ,
3973: x_msg_data OUT NOCOPY VARCHAR2 ) IS
3974:

Line 4000: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;

3996: l_mol_num NUMBER;
3997: l_serial_control_code NUMBER;
3998: l_lot_control_code NUMBER;
3999: l_index NUMBER;
4000: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
4001: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
4002: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
4003: l_return_status VARCHAR2(10);
4004: l_msg_count NUMBER;

Line 4001: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;

3997: l_serial_control_code NUMBER;
3998: l_lot_control_code NUMBER;
3999: l_index NUMBER;
4000: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
4001: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
4002: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
4003: l_return_status VARCHAR2(10);
4004: l_msg_count NUMBER;
4005: l_msg_data VARCHAR(200);

Line 4002: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;

3998: l_lot_control_code NUMBER;
3999: l_index NUMBER;
4000: l_new_tasks_output WMS_TASK_MGMT_PUB.task_tab_type;
4001: l_new_tasks_tbl WMS_TASK_MGMT_PUB.task_tab_type;
4002: x_task_table WMS_TASK_MGMT_PUB.task_tab_type;
4003: l_return_status VARCHAR2(10);
4004: l_msg_count NUMBER;
4005: l_msg_data VARCHAR(200);
4006: l_validation_status VARCHAR2(10);

Line 4019: l_split_uom_quantities WMS_TASK_MGMT_PUB.QTY_CHANGED_TBL_TYPE;

4015: l_val_task_ret_status VARCHAR2(1);
4016: l_mmtt_inventory_item_id NUMBER;
4017: l_mmtt_task_status NUMBER;
4018: l_mmtt_organization_id NUMBER;
4019: l_split_uom_quantities WMS_TASK_MGMT_PUB.QTY_CHANGED_TBL_TYPE;
4020: l_val_qty_ret_status VARCHAR2(1);
4021: l_invalid_task EXCEPTION;
4022: l_invalid_quantities EXCEPTION;
4023: l_unexpected_error EXCEPTION;

Line 4311: p_split_quantities IN wms_Task_mgmt_pub.task_qty_tbl_type ,

4307: END IF;
4308: END split_task;
4309:
4310: PROCEDURE validate_quantities( p_transaction_temp_id IN NUMBER ,
4311: p_split_quantities IN wms_Task_mgmt_pub.task_qty_tbl_type ,
4312: x_lot_control_code OUT NOCOPY NUMBER ,
4313: x_serial_control_code OUT NOCOPY NUMBER ,
4314: x_split_uom_quantities OUT NOCOPY wms_Task_mgmt_pub.qty_changed_tbl_type ,
4315: x_return_status OUT NOCOPY VARCHAR2 ,

Line 4314: x_split_uom_quantities OUT NOCOPY wms_Task_mgmt_pub.qty_changed_tbl_type ,

4310: PROCEDURE validate_quantities( p_transaction_temp_id IN NUMBER ,
4311: p_split_quantities IN wms_Task_mgmt_pub.task_qty_tbl_type ,
4312: x_lot_control_code OUT NOCOPY NUMBER ,
4313: x_serial_control_code OUT NOCOPY NUMBER ,
4314: x_split_uom_quantities OUT NOCOPY wms_Task_mgmt_pub.qty_changed_tbl_type ,
4315: x_return_status OUT NOCOPY VARCHAR2 ,
4316: x_msg_data OUT NOCOPY VARCHAR2 ,
4317: x_msg_count OUT NOCOPY VARCHAR2 ) IS
4318: