APPS.WSH_UTIL_VALIDATE dependencies on WSH_NEW_DELIVERIES

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

2088: --========================================================================
2089: -- PROCEDURE : Validate_Delivery_Name
2090: --
2091: -- COMMENT : Validates Delivery_id/Delivery_Name against table
2092: -- wsh_new_deliveries. If both values are specified then only
2093: -- delivery_id is used
2094: --========================================================================
2095:
2096: PROCEDURE Validate_Delivery_Name

Line 2103: FROM wsh_new_deliveries

2099: x_return_status OUT NOCOPY VARCHAR2 ) IS
2100:
2101: CURSOR check_delivery_name IS
2102: SELECT delivery_id
2103: FROM wsh_new_deliveries
2104: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2105: delivery_id = p_delivery_id
2106: UNION ALL
2107: SELECT delivery_id

Line 2108: FROM wsh_new_deliveries

2104: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM AND
2105: delivery_id = p_delivery_id
2106: UNION ALL
2107: SELECT delivery_id
2108: FROM wsh_new_deliveries
2109: WHERE NVL(p_delivery_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
2110: name = p_delivery_name;
2111:
2112: --

Line 2990: l_ship_method_code_backup wsh_new_deliveries.ship_method_code%TYPE;

2986: l_num_warnings NUMBER;
2987: l_sm_is_null BOOLEAN := FALSE;
2988: --
2989: l_new_carrier VARCHAR2(1);
2990: l_ship_method_code_backup wsh_new_deliveries.ship_method_code%TYPE;
2991:
2992: -- Below cursors are used if the entity is a delivery.
2993: --TP does not honor WSH's org assignment for ship method, so if caller is TP,
2994: --p_organization_id need not be considered

Line 3093: from wsh_new_deliveries

3089: select carrier_id,
3090: service_level,
3091: mode_of_transport,
3092: ship_method_code
3093: from wsh_new_deliveries
3094: where delivery_id = p_delivery_id;
3095: --
3096: -- Below cursors are used if the entity is a trip.
3097: --