APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_NEW_DELIVERIES

Line 376: /* Check if the Delivery ID from Interface table exists in WSH_NEW_DELIVERIES Table */

372: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERIES');
373: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);
374: END IF;
375:
376: /* Check if the Delivery ID from Interface table exists in WSH_NEW_DELIVERIES Table */
377:
378: IF (p_delivery_id IS NOT NULL)
379: THEN
380: BEGIN

Line 383: FROM wsh_new_deliveries

379: THEN
380: BEGIN
381: SELECT 'X'
382: INTO x_delivery_exists
383: FROM wsh_new_deliveries
384: WHERE delivery_id = p_delivery_id;
385: EXCEPTION
386: WHEN NO_DATA_FOUND
387: THEN

Line 395: /* If the Delivery exists in WSH_New_Deliveries, Get the corresponding Delivery_Detail_IDs

391: IF l_debug_on THEN
392: wsh_debug_sv.log (l_module_name, 'Valid parameters for Validate Deliveries. Return Status : ',X_Return_Status );
393: END IF;
394:
395: /* If the Delivery exists in WSH_New_Deliveries, Get the corresponding Delivery_Detail_IDs
396: from the interface tables and check if they exist in the base tables, and if they are assigned
397: to the same delivery */
398:
399: IF (x_delivery_exists = 'X')

Line 478: FROM wsh_new_deliveries

474: IS
475: SELECT customer_id, initial_pickup_location_id,
476: intmed_ship_to_location_id, organization_id,
477: ultimate_dropoff_location_id
478: FROM wsh_new_deliveries
479: WHERE delivery_id = p_delivery_id;
480:
481: CURSOR delivery_detail_cur (p_delivery_detail_id NUMBER)
482: IS