31: -- p_cartons_list => Carton Grouping ID List (For Cluster Picking)
32: --
33: -- Output Parameters
34: -- x_task_info => Ref Cursor containing the Task Information
35: -- x_return_status => FND_API.G_RET_STS_SUCESSS or
36: -- FND_API.G_RET_STS_ERROR
37: -- x_error_code => Code indicating the error message.
38: -- x_error_mesg => Error Messages
39: -- x_mesg_count => Error Messages Count
32: --
33: -- Output Parameters
34: -- x_task_info => Ref Cursor containing the Task Information
35: -- x_return_status => FND_API.G_RET_STS_SUCESSS or
36: -- FND_API.G_RET_STS_ERROR
37: -- x_error_code => Code indicating the error message.
38: -- x_error_mesg => Error Messages
39: -- x_mesg_count => Error Messages Count
40:
71: -- x_tasks => Ref Cursor containing the Tasks
72: -- x_drop_type => Either MFG or OTHERS depending on whether LPN has Mfg Picks or not
73: -- x_multiple_drops => Number of drop locations for Mfg Picks
74: -- x_drop_lpn_option => Drop LPN Option
75: -- x_return_status => FND_API.G_RET_STS_SUCESSS or
76: -- FND_API.G_RET_STS_ERROR
77:
78: PROCEDURE get_tasks(
79: x_tasks OUT NOCOPY t_genref
72: -- x_drop_type => Either MFG or OTHERS depending on whether LPN has Mfg Picks or not
73: -- x_multiple_drops => Number of drop locations for Mfg Picks
74: -- x_drop_lpn_option => Drop LPN Option
75: -- x_return_status => FND_API.G_RET_STS_SUCESSS or
76: -- FND_API.G_RET_STS_ERROR
77:
78: PROCEDURE get_tasks(
79: x_tasks OUT NOCOPY t_genref
80: , x_drop_type OUT NOCOPY VARCHAR2
97: -- Input Parameters
98: -- p_txn_temp_id_list => Comma delimited Transaction Temp ID List
99: --
100: -- Output Parameters
101: -- x_return_status => FND_API.G_RET_STS_SUCESSS or
102: -- FND_API.G_RET_STS_ERROR
103: -- x_lot_num_list => Comma delimited Lot Number List
104: -- x_lot_qty_list => Comma delimited Lot Qty List
105: -- x_display_serials => Whether Serials are associated with the Txn Temp ID list.
98: -- p_txn_temp_id_list => Comma delimited Transaction Temp ID List
99: --
100: -- Output Parameters
101: -- x_return_status => FND_API.G_RET_STS_SUCESSS or
102: -- FND_API.G_RET_STS_ERROR
103: -- x_lot_num_list => Comma delimited Lot Number List
104: -- x_lot_qty_list => Comma delimited Lot Qty List
105: -- x_display_serials => Whether Serials are associated with the Txn Temp ID list.
106:
125: -- p_txn_temp_id_list => Comma delimited Transaction Temp ID List
126: -- p_lot_number => Lot Number
127: --
128: -- Output Parameters
129: -- x_return_status => FND_API.G_RET_STS_SUCESSS or
130: -- FND_API.G_RET_STS_ERROR
131: -- x_serial_list => Comma Delimited Serial List
132: PROCEDURE get_serial_numbers(
133: x_return_status OUT NOCOPY VARCHAR2
126: -- p_lot_number => Lot Number
127: --
128: -- Output Parameters
129: -- x_return_status => FND_API.G_RET_STS_SUCESSS or
130: -- FND_API.G_RET_STS_ERROR
131: -- x_serial_list => Comma Delimited Serial List
132: PROCEDURE get_serial_numbers(
133: x_return_status OUT NOCOPY VARCHAR2
134: , x_serial_list OUT NOCOPY VARCHAR2
206: );
207:
208: PROCEDURE split_task( p_source_transaction_number IN NUMBER DEFAULT NULL,
209: p_split_quantities IN wms_Task_mgmt_pub.TASK_QTY_TBL_TYPE ,
210: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
211: x_resultant_tasks OUT NOCOPY WMS_TASK_MGMT_PUB.task_tab_type ,
212: x_resultant_task_details OUT NOCOPY wms_Task_mgmt_pub.TASK_DETAIL_TBL_TYPE ,
213: x_return_status OUT NOCOPY VARCHAR2 ,
214: x_msg_count OUT NOCOPY NUMBER ,