[Home] [Help]
192: CURSOR c_check_consol_dlvy(p_delivery_id IN NUMBER) IS
193: SELECT delivery_id
194: FROM wsh_new_deliveries
195: WHERE delivery_id = p_delivery_id
196: AND delivery_type = 'STANDARD';
197:
198:
199: -- Standard call to check for call compatibility
200: l_api_version CONSTANT NUMBER := 1.0;
195: WHERE delivery_id = p_delivery_id
196: AND delivery_type = 'STANDARD';
197:
198:
199: -- Standard call to check for call compatibility
200: l_api_version CONSTANT NUMBER := 1.0;
201: l_api_name CONSTANT VARCHAR2(30) := 'WSH_PICKING_BATCHES_GRP';
202: l_return_status VARCHAR2(30) := NULL;
203: l_msg_count NUMBER;
244: END IF;
245: --
246: SAVEPOINT PICKING_BATCH_GRP;
247:
248: -- Standard begin of API savepoint
249: --
250: -- Debug Statements
251: --
252: IF l_debug_on THEN
971: p_msg_data => l_msg_data
972: );
973:
974: --R12 MDC
975: --Delivery must be a standard delivery
976: OPEN c_check_consol_dlvy(l_batch_in_rec.Delivery_Id);
977: FETCH c_check_consol_dlvy INTO l_batch_in_rec.Delivery_Id;
978: IF c_check_consol_dlvy%NOTFOUND THEN
979: CLOSE c_check_consol_dlvy;
2701: -- End of comments
2702: --============================================================================================
2703:
2704: PROCEDURE Release_Batch (
2705: -- Standard parameters
2706: p_api_version_number IN NUMBER,
2707: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
2708: p_commit IN VARCHAR2 DEFAULT NULL,
2709: x_return_status OUT NOCOPY VARCHAR2,
2718: p_num_workers IN NUMBER ,
2719: x_request_id OUT NOCOPY NUMBER
2720: ) IS
2721:
2722: -- Standard call to check for call compatibility
2723: l_api_version CONSTANT NUMBER := 1.0;
2724: l_api_name CONSTANT VARCHAR2(30) := 'WSH_PICKING_BATCHES_GRP';
2725: l_return_status VARCHAR2(30);
2726: l_msg_count NUMBER;
2754: END IF;
2755: --
2756: SAVEPOINT PICKING_BATCH_GRP;
2757:
2758: -- Standard begin of API savepoint
2759: --
2760: -- Debug Statements
2761: --
2762: IF l_debug_on THEN