APPS.CLN_UPDTDLVY_PKG dependencies on WSH_NEW_DELIVERIES
Line 349: FROM WSH_NEW_DELIVERIES
345: b_is_valid_delivery_num := true;
346: BEGIN
347: SELECT 1
348: INTO l_temp 349: FROM WSH_NEW_DELIVERIES 350: WHERE name = p_delivery_num;
351: EXCEPTION
352: WHEN NO_DATA_FOUND THEN
353: -- Invalid delivery number
Line 355: cln_debug_pub.Add('Delivery number not found in wsh_new_deliveries', 1);
351: EXCEPTION
352: WHEN NO_DATA_FOUND THEN
353: -- Invalid delivery number
354: IF (l_debug_level <= 1) THEN 355: cln_debug_pub.Add('Delivery number not found in wsh_new_deliveries', 1); 356: END IF;
357: b_is_valid_delivery_num := false;
358: END;
359: