APPS.WSH_INTERFACE_COMMON_ACTIONS dependencies on WSH_FREIGHT_COSTS_INTERFACE

Line 1078: FROM wsh_freight_costs_interface

1074: END IF;
1075:
1076: -- Process Interface freight costs
1077: SELECT count(*) INTO l_det_freight_costs
1078: FROM wsh_freight_costs_interface
1079: WHERE delivery_detail_interface_id = del_det_int_rec.delivery_detail_interface_id
1080: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1081:
1082: IF l_debug_on THEN

Line 1456: FROM wsh_freight_costs_interface

1452:
1453: -- Process interface freight costs
1454: SELECT COUNT(*)
1455: INTO l_det_freight_costs
1456: FROM wsh_freight_costs_interface
1457: WHERE delivery_detail_interface_id =
1458: del_det_int_rec.delivery_detail_interface_id
1459: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1460:

Line 2294: FROM wsh_freight_costs_interface

2290: wsh_debug_sv.logmsg (l_module_name, '--------------------------------------------------------------------------------------------');
2291: END IF;
2292:
2293: SELECT count(*) INTO l_del_freight_costs
2294: FROM wsh_freight_costs_interface
2295: WHERE delivery_interface_id = p_delivery_interface_id
2296: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2297:
2298: IF l_debug_on THEN

Line 2868: FROM wsh_freight_costs_interface

2864: PROGRAM_UPDATE_DATE,
2865: REQUEST_ID,
2866: FREIGHT_CODE,
2867: INTERFACE_ACTION_CODE
2868: FROM wsh_freight_costs_interface
2869: WHERE (delivery_detail_interface_id = NVL(p_del_detail_interface_id, -99999))
2870: OR (delivery_interface_id = NVL(p_delivery_interface_id, -99999))
2871: OR (stop_interface_id = NVL(p_stop_interface_id, -99999))
2872: OR (trip_interface_id = NVL(p_trip_interface_id, -99999))

Line 2975: l_loc_interface_error_rec.p_interface_table_name := 'WSH_FREIGHT_COSTS_INTERFACE';

2971: IF l_debug_on THEN
2972: wsh_debug_sv.logmsg(l_module_name, 'Invalid Freight Cost Type');
2973: END IF;
2974:
2975: l_loc_interface_error_rec.p_interface_table_name := 'WSH_FREIGHT_COSTS_INTERFACE';
2976: l_loc_interface_error_rec.p_interface_id := l_entity_interface_id;
2977:
2978: Log_Errors(
2979: p_loc_interface_errors_rec => l_loc_interface_error_rec,

Line 3052: l_loc_interface_error_rec.p_interface_table_name := 'WSH_FREIGHT_COSTS_INTERFACE';

3048: wsh_debug_sv.log (l_module_name, 'freight_cost id created', l_freight_cost_id);
3049: END IF;
3050:
3051: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
3052: l_loc_interface_error_rec.p_interface_table_name := 'WSH_FREIGHT_COSTS_INTERFACE';
3053: l_loc_interface_error_rec.p_interface_id := l_entity_interface_id;
3054:
3055: Log_Errors(
3056: p_loc_interface_errors_rec => l_loc_interface_error_rec,