APPS.WSH_INTERFACE_VALIDATIONS_PKG dependencies on WSH_NEW_DELIVERIES

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

544: wsh_debug_sv.push (l_module_name, 'VALIDATE_DELIVERIES');
545: wsh_debug_sv.log (l_module_name, 'DELIVERY ID', p_delivery_id);
546: END IF;
547:
548: /* Check if the Delivery ID from Interface table exists in WSH_NEW_DELIVERIES Table */
549:
550: IF (p_delivery_id IS NOT NULL)
551: THEN
552: BEGIN

Line 555: FROM wsh_new_deliveries

551: THEN
552: BEGIN
553: SELECT 'X'
554: INTO x_delivery_exists
555: FROM wsh_new_deliveries
556: WHERE delivery_id = p_delivery_id;
557: EXCEPTION
558: WHEN NO_DATA_FOUND
559: THEN

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

563: IF l_debug_on THEN
564: wsh_debug_sv.log (l_module_name, 'Valid parameters for Validate Deliveries. Return Status : ',X_Return_Status );
565: END IF;
566:
567: /* If the Delivery exists in WSH_New_Deliveries, Get the corresponding Delivery_Detail_IDs
568: from the interface tables and check if they exist in the base tables, and if they are assigned
569: to the same delivery */
570:
571: IF (x_delivery_exists = 'X')

Line 774: FROM wsh_new_deliveries

770: IS
771: SELECT customer_id, initial_pickup_location_id,
772: intmed_ship_to_location_id, organization_id,
773: ultimate_dropoff_location_id
774: FROM wsh_new_deliveries
775: WHERE delivery_id = p_delivery_id;
776:
777: CURSOR delivery_detail_cur (p_delivery_detail_id NUMBER)
778: IS