[Home] [Help]
194: CURSOR c_check_consol_dlvy(p_delivery_id IN NUMBER) IS
195: SELECT delivery_id
196: FROM wsh_new_deliveries
197: WHERE delivery_id = p_delivery_id
198: AND delivery_type = 'STANDARD';
199:
200:
201: -- Standard call to check for call compatibility
202: l_api_version CONSTANT NUMBER := 1.0;
197: WHERE delivery_id = p_delivery_id
198: AND delivery_type = 'STANDARD';
199:
200:
201: -- Standard call to check for call compatibility
202: l_api_version CONSTANT NUMBER := 1.0;
203: l_api_name CONSTANT VARCHAR2(30) := 'WSH_PICKING_BATCHES_GRP';
204: l_return_status VARCHAR2(30) := NULL;
205: l_msg_count NUMBER;
248: END IF;
249: --
250: SAVEPOINT PICKING_BATCH_GRP;
251:
252: -- Standard begin of API savepoint
253: --
254: -- Debug Statements
255: --
256: IF l_debug_on THEN
1026: p_msg_data => l_msg_data
1027: );
1028:
1029: --R12 MDC
1030: --Delivery must be a standard delivery
1031: OPEN c_check_consol_dlvy(l_batch_in_rec.Delivery_Id);
1032: FETCH c_check_consol_dlvy INTO l_batch_in_rec.Delivery_Id;
1033: IF c_check_consol_dlvy%NOTFOUND THEN
1034: CLOSE c_check_consol_dlvy;
2835: -- End of comments
2836: --============================================================================================
2837:
2838: PROCEDURE Release_Batch (
2839: -- Standard parameters
2840: p_api_version_number IN NUMBER,
2841: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
2842: p_commit IN VARCHAR2 DEFAULT NULL,
2843: x_return_status OUT NOCOPY VARCHAR2,
2852: -- p_num_workers IN NUMBER , -- Bug # 7505524
2853: x_request_id OUT NOCOPY NUMBER
2854: ) IS
2855:
2856: -- Standard call to check for call compatibility
2857: l_api_version CONSTANT NUMBER := 1.0;
2858: l_api_name CONSTANT VARCHAR2(30) := 'WSH_PICKING_BATCHES_GRP';
2859: l_return_status VARCHAR2(30);
2860: l_msg_count NUMBER;
2889: END IF;
2890: --
2891: SAVEPOINT PICKING_BATCH_GRP;
2892:
2893: -- Standard begin of API savepoint
2894: --
2895: -- Debug Statements
2896: --
2897: IF l_debug_on THEN