APPS.WSH_UTIL_VALIDATE dependencies on WSH_NEW_DELIVERIES

Line 2070: -- wsh_new_deliveries. If both values are specified then only

2066: --========================================================================
2067: -- PROCEDURE : Validate_Delivery_Name
2068: --
2069: -- COMMENT : Validates Delivery_id/Delivery_Name against table
2070: -- wsh_new_deliveries. If both values are specified then only
2071: -- delivery_id is used
2072: --========================================================================
2073:
2074: PROCEDURE Validate_Delivery_Name

Line 2081: FROM wsh_new_deliveries

2077: x_return_status OUT NOCOPY VARCHAR2 ) IS
2078:
2079: CURSOR check_delivery_name IS
2080: SELECT delivery_id
2081: FROM wsh_new_deliveries
2082: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2083: delivery_id = p_delivery_id
2084: UNION ALL
2085: SELECT delivery_id

Line 2086: FROM wsh_new_deliveries

2082: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2083: delivery_id = p_delivery_id
2084: UNION ALL
2085: SELECT delivery_id
2086: FROM wsh_new_deliveries
2087: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2088: name = p_delivery_name;
2089:
2090: --

Line 2968: l_ship_method_code_backup wsh_new_deliveries.ship_method_code%TYPE;

2964: l_num_warnings NUMBER;
2965: l_sm_is_null BOOLEAN := FALSE;
2966: --
2967: l_new_carrier VARCHAR2(1);
2968: l_ship_method_code_backup wsh_new_deliveries.ship_method_code%TYPE;
2969:
2970: -- Below cursors are used if the entity is a delivery.
2971: --TP does not honor WSH's org assignment for ship method, so if caller is TP,
2972: --p_organization_id need not be considered

Line 3071: from wsh_new_deliveries

3067: select carrier_id,
3068: service_level,
3069: mode_of_transport,
3070: ship_method_code
3071: from wsh_new_deliveries
3072: where delivery_id = p_delivery_id;
3073: --
3074: -- Below cursors are used if the entity is a trip.
3075: --